Diagrams


Table

Ship-to Address

DynamicsDocs.comShip-to Address«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 10»Shipment MethodCode [PK,NN]Description«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 318»Tax AreaCode [PK,NN]Description«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 5957»Service ZoneCode [PK,NN]Description<Customer No.><Ship-to Filter><Shipment Method Code><Shipping Agent Code><Location Code><Tax Area Code><Shipping Agent Service Code><Service Zone Code><Ship-to Code><Shipment Method Code><Shipping Agent Code><Bill-to Customer No.><Location Code><Tax Area Code><Shipping Agent Service Code><Service Zone Code><Customer No.><Shipping Agent Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Customer No. Code20 NotBlank: Yes
2 Code Code10 NotBlank: Yes
3 Name Text50
4 Name 2 Text50
5 Address Text50
6 Address 2 Text50
7 City Text30
8 Contact Text50
9 Phone No. Text30 [Phone No.]
10 Telex No. Text30
30 Shipment Method Code Code10
31 Shipping Agent Code Code10
32 Place of Export Code20
35 Country/Region Code Code10
54 Last Date Modified Date Editable: No
83 Location Code Code10
84 Fax No. Text30
85 Telex Answer Back Text20
91 Post Code Code20
92 County Text30
102 E-Mail Text80 [E-Mail]
103 Home Page Text80 [URL]
108 Tax Area Code Code20
109 Tax Liable Boolean
5792 Shipping Agent Service Code Code10
5900 Service Zone Code Code10

Keys

# Fields
0 Customer No.,Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code Country/Region Code 1..n
Customer No. Customer No. 1..n
Location Code Location 1..n
Service Zone Code Service Zone Code 1..n
Shipment Method Code Shipment Method Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services Code 1..n
Tax Area Code Tax Area Code 1..n

Table Relations From Other Tables

From Table From Field
Contract Gain/Loss Entry Ship-to Code 1..n
Customer Ship-to Filter 1..n
Filed Contract Line Ship-to Code 1..n
Filed Service Contract Header Ship-to Code 1..n
Gen. Journal Line Ship-to/Order Address Code 1..n
Purch. Cr. Memo Hdr. Ship-to Code 1..n
Purch. Inv. Header Ship-to Code 1..n
Purch. Rcpt. Header Ship-to Code 1..n
Purchase Header Ship-to Code 1..n
Requisition Line Ship-to Code 1..n
Return Receipt Header Ship-to Code 1..n
Return Shipment Header Ship-to Code 1..n
Sales Cr.Memo Header Ship-to Code 1..n
Sales Header Ship-to Code 1..n
Sales Header Archive Ship-to Code 1..n
Sales Invoice Header Ship-to Code 1..n
Sales Shipment Header Ship-to Code 1..n
Service Contract Header Ship-to Code 1..n
Service Contract Line Ship-to Code 1..n
Service Cr.Memo Header Ship-to Code 1..n
Service Cr.Memo Line Ship-to Code 1..n
Service Header Ship-to Code 1..n
Service Invoice Header Ship-to Code 1..n
Service Invoice Line Ship-to Code 1..n
Service Item Ship-to Code 1..n
Service Item Line Ship-to Code 1..n
Service Ledger Entry Ship-to Code 1..n
Service Line Ship-to Code 1..n
Service Shipment Header Ship-to Code 1..n
Service Shipment Item Line Ship-to Code 1..n
Service Shipment Line Ship-to Code 1..n
Standard General Journal Line Ship-to/Order Address Code 1..n
VAT Entry Ship-to/Order Address Code 1..n
Warranty Ledger Entry Ship-to Code 1..n