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 |