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 | AccessByPermission: TableData 5790=R
|
|
| 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 | 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 |