Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Customer No. (Customer No.) | Code20 |
|
NotBlank: Yes |
2 | Code (Code) | Code10 | NotBlank: Yes | |
3 | Name (Name) | Text50 | ||
4 | Name 2 (Name 2) | Text50 | ||
5 | Address (Address) | Text50 | ||
6 | Address 2 (Address 2) | Text50 | ||
7 | City (City) | Text30 |
|
|
8 | Contact (Contact) | Text50 | ||
9 | Phone No. (Phone No.) | Text30 [Phone No.] | ||
10 | Telex No. (Telex No.) | Text30 | ||
30 | Shipment Method Code (Shipment Method Code) | Code10 |
|
|
31 | Shipping Agent Code (Shipping Agent Code) | Code10 | AccessByPermission: TableData 5790=R
|
|
32 | Place of Export (Place of Export) | Code20 | ||
35 | Country/Region Code (Country/Region Code) | Code10 |
|
|
54 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
83 | Location Code (Location Code) | Code10 |
|
|
84 | Fax No. (Fax No.) | Text30 | ||
85 | Telex Answer Back (Telex Answer Back) | Text20 | ||
91 | Post Code (Post Code) | Code20 |
|
|
92 | County (County) | Text30 | ||
102 | E-Mail (E-Mail) | Text80 [E-Mail] | ||
103 | Home Page (Home Page) | Text80 [URL] | ||
108 | Tax Area Code (Tax Area Code) | Code20 |
|
|
109 | Tax Liable (Tax Liable) | Boolean | ||
5792 | Shipping Agent Service Code (Shipping Agent Service Code) | Code10 |
|
|
5900 | Service Zone Code (Service Zone Code) | Code10 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | Customer No.,Code (Customer No.,Code) | Clustered: Yes |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
Customer No. (Customer No.) | Customer | No. (No.) |
|
1..n |
Location Code (Location Code) | Location | () |
|
1..n |
Service Zone Code (Service Zone Code) | Service Zone | Code (Code) |
|
1..n |
Shipment Method Code (Shipment Method Code) | Shipment Method | Code (Code) |
|
1..n |
Shipping Agent Code (Shipping Agent Code) | Shipping Agent | Code (Code) |
|
1..n |
Shipping Agent Service Code (Shipping Agent Service Code) | Shipping Agent Services | Code (Code) |
|
1..n |
Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Contract Gain/Loss Entry | Ship-to Code (Ship-to Code) |
|
1..n |
Customer | Ship-to Filter (Ship-to Filter) |
|
1..n |
Filed Contract Line | Ship-to Code (Ship-to Code) |
|
1..n |
Filed Service Contract Header | Ship-to Code (Ship-to Code) |
|
1..n |
Gen. Journal Line | Ship-to/Order Address Code (Ship-to/Order Address Code) |
|
1..n |
Purch. Cr. Memo Hdr. | Ship-to Code (Ship-to Code) |
|
1..n |
Purch. Inv. Header | Ship-to Code (Ship-to Code) |
|
1..n |
Purch. Rcpt. Header | Ship-to Code (Ship-to Code) |
|
1..n |
Purchase Header | Ship-to Code (Ship-to Code) |
|
1..n |
Requisition Line | Ship-to Code (Ship-to Code) |
|
1..n |
Return Receipt Header | Ship-to Code (Ship-to Code) |
|
1..n |
Return Shipment Header | Ship-to Code (Ship-to Code) |
|
1..n |
Sales Cr.Memo Header | Ship-to Code (Ship-to Code) |
|
1..n |
Sales Header | Ship-to Code (Ship-to Code) |
|
1..n |
Sales Header Archive | Ship-to Code (Ship-to Code) |
|
1..n |
Sales Invoice Header | Ship-to Code (Ship-to Code) |
|
1..n |
Sales Shipment Header | Ship-to Code (Ship-to Code) |
|
1..n |
Service Contract Header | Ship-to Code (Ship-to Code) |
|
1..n |
Service Contract Line | Ship-to Code (Ship-to Code) |
|
1..n |
Service Cr.Memo Header | Ship-to Code (Ship-to Code) |
|
1..n |
Service Cr.Memo Line | Ship-to Code (Ship-to Code) |
|
1..n |
Service Header | Ship-to Code (Ship-to Code) |
|
1..n |
Service Invoice Header | Ship-to Code (Ship-to Code) |
|
1..n |
Service Invoice Line | Ship-to Code (Ship-to Code) |
|
1..n |
Service Item | Ship-to Code (Ship-to Code) |
|
1..n |
Service Item Line | Ship-to Code (Ship-to Code) |
|
1..n |
Service Ledger Entry | Ship-to Code (Ship-to Code) |
|
1..n |
Service Line | Ship-to Code (Ship-to Code) |
|
1..n |
Service Shipment Header | Ship-to Code (Ship-to Code) |
|
1..n |
Service Shipment Item Line | Ship-to Code (Ship-to Code) |
|
1..n |
Service Shipment Line | Ship-to Code (Ship-to Code) |
|
1..n |
Standard General Journal Line | Ship-to/Order Address Code (Ship-to/Order Address Code) |
|
1..n |
VAT Entry | Ship-to/Order Address Code (Ship-to/Order Address Code) |
|
1..n |
Warranty Ledger Entry | Ship-to Code (Ship-to Code) |
|
1..n |