Ship-to Address #222

Other table in Microsoft Dynamics 365 Business Central. 33 fields, 4 records in Cronus demo.

33
Fields
4
Records
2
Primary key
0
FlowFields
11
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Customer No., Code.

All fields (33)

Ship-to Address — FIELDS
NO.FIELDTYPECLASSRELATION
1 Customer No. PK Code Normal → Customer #18
2 Code PK Code Normal
3 Name Text Normal
4 Name 2 Text Normal
5 Address Text Normal
6 Address 2 Text Normal
7 City Text Normal
8 Contact Text Normal
9 Phone No. Text Normal
10 Telex No. Text Normal
29 Salesperson Code Code Normal → Salesperson/Purchaser #13
30 Shipment Method Code Code Normal → Shipment Method #10
31 Shipping Agent Code Code Normal → Shipping Agent #291
32 Place of Export Code Normal
35 Country/Region Code Code Normal → Country/Region #9
54 Last Date Modified Date Normal
83 Location Code Code Normal → Location #14
84 Fax No. Text Normal
85 Telex Answer Back Text Normal
90 GLN Code Normal
91 Post Code Code Normal
92 County Text Normal
102 Email Text Normal
103 Home Page Text Normal
108 Tax Area Code Code Normal → Tax Area #318
109 Tax Liable Boolean Normal
5792 Shipping Agent Service Code Code Normal → Shipping Agent Services #5790
5900 Service Zone Code Code Normal → Service Zone #5957
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (10)

Tables referenced by fields on the Ship-to Address table through TableRelation properties.

Customer
#18 · Sales · via Customer No.
Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
Shipment Method
#10 · General Ledger · via Shipment Method Code
Shipping Agent
#291 · Other · via Shipping Agent Code
Country/Region
#9 · General Ledger · via Country/Region Code
Location
#14 · General Ledger · via Location Code
Tax Area
#318 · Other · via Tax Area Code
Shipping Agent Services
#5790 · Other · via Shipping Agent Service Code
Service Zone
#5957 · Service · via Service Zone Code