Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Code (Code) | Code10 | NotBlank: Yes | |
| 2 | Name (Name) | Text50 | ||
| 3 | Address (Address) | Text50 | ||
| 4 | Address 2 (Address 2) | Text50 | ||
| 5 | City (City) | Text30 |
|
|
| 6 | Post Code (Post Code) | Code20 |
|
|
| 7 | Country/Region Code (Country/Region Code) | Code10 |
|
|
| 8 | Phone No. (Phone No.) | Text30 [Phone No.] | ||
| 9 | Fax No. (Fax No.) | Text30 | ||
| 10 | Name 2 (Name 2) | Text50 | ||
| 11 | Contact (Contact) | Text50 | ||
| 12 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
| 13 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
| 14 | Location Code (Location Code) | Code10 |
|
|
| 15 | County (County) | Text30 | ||
| 102 | E-Mail (E-Mail) | Text80 [E-Mail] | ||
| 103 | Home Page (Home Page) | Text90 [URL] | ||
| 5900 | Date Filter (Date Filter) | Date | FlowFilter | |
| 5901 | Contract Gain/Loss Amount (Contract Gain/Loss Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Code (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 |
| Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Location Code (Location Code) | Location | () |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Company Information | Responsibility Center (Responsibility Center) |
|
1..n |
| Contract Gain/Loss Entry | Responsibility Center (Responsibility Center) |
|
1..n |
| Customer | Responsibility Center (Responsibility Center) |
|
1..n |
| Default Dimension | No. (No.) |
|
1..n |
| Filed Service Contract Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Purch. Cr. Memo Hdr. | Responsibility Center (Responsibility Center) |
|
1..n |
| Purch. Cr. Memo Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Purch. Inv. Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Purch. Inv. Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Purch. Rcpt. Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Purch. Rcpt. Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Purchase Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Purchase Header Archive | Responsibility Center (Responsibility Center) |
|
1..n |
| Purchase Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Purchase Line Archive | Responsibility Center (Responsibility Center) |
|
1..n |
| Return Receipt Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Return Receipt Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Return Shipment Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Return Shipment Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Cr.Memo Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Cr.Memo Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Header Archive | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Invoice Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Invoice Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Line Archive | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Shipment Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Sales Shipment Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Contract Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Cr.Memo Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Cr.Memo Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Invoice Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Invoice Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Item Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Ledger Entry | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Shipment Header | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Shipment Item Line | Responsibility Center (Responsibility Center) |
|
1..n |
| Service Shipment Line | Responsibility Center (Responsibility Center) |
|
1..n |
| User Setup | Service Resp. Ctr. Filter (Service Resp. Ctr. Filter) |
|
1..n |
| Vendor | Responsibility Center (Responsibility Center) |
|
1..n |