Diagrams


Table

Config. Setup

Fields

# Name Type
1 Primary Key (Primary Key) Code10
2 Name (Name) Text50
3 Name 2 (Name 2) Text50
4 Address (Address) Text50
5 Address 2 (Address 2) Text50
6 City (City) Text30
7 Phone No. (Phone No.) Text30
8 Phone No. 2 (Phone No. 2) Text30
9 Telex No. (Telex No.) Text30
10 Fax No. (Fax No.) Text30
11 Giro No. (Giro No.) Text20
12 Bank Name (Bank Name) Text50
13 Bank Branch No. (Bank Branch No.) Text20
14 Bank Account No. (Bank Account No.) Text30
15 Payment Routing No. (Payment Routing No.) Text20
17 Customs Permit No. (Customs Permit No.) Text10
18 Customs Permit Date (Customs Permit Date) Date
19 VAT Registration No. (VAT Registration No.) Text20
20 Registration No. (Registration No.) Text20
21 Telex Answer Back (Telex Answer Back) Text20
22 Ship-to Name (Ship-to Name) Text50
23 Ship-to Name 2 (Ship-to Name 2) Text50
24 Ship-to Address (Ship-to Address) Text50
25 Ship-to Address 2 (Ship-to Address 2) Text50
26 Ship-to City (Ship-to City) Text30
27 Ship-to Contact (Ship-to Contact) Text50
28 Location Code (Location Code) Code10
29 Picture (Picture) BLOB [Bitmap]
30 Post Code (Post Code) Code20
31 County (County) Text30
32 Ship-to Post Code (Ship-to Post Code) Code20
33 Ship-to County (Ship-to County) Text30
34 E-Mail (E-Mail) Text80
35 Home Page (Home Page) Text80
36 Country/Region Code (Country/Region Code) Code10
37 Ship-to Country/Region Code (Ship-to Country/Region Code) Code10
38 IBAN (IBAN) Code50
39 SWIFT Code (SWIFT Code) Code20
40 Industrial Classification (Industrial Classification) Text30
5700 Responsibility Center (Responsibility Center) Code10
5791 Check-Avail. Period Calc. (Check-Avail. Period Calc.) DateFormula
5792 Check-Avail. Time Bucket (Check-Avail. Time Bucket) Option
7600 Base Calendar Code (Base Calendar Code) Code10
7601 Cal. Convergence Time Frame (Cal. Convergence Time Frame) DateFormula
8600 Package File Name (Package File Name) Text250
8601 Package Code (Package Code) Code20 Editable: No
8602 Language ID (Language ID) Integer Editable: No
8603 Product Version (Product Version) Text80 Editable: No
8604 Package Name (Package Name) Text50
8605 Your Profile Code (Your Profile Code) Code30

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Your Profile Code (Your Profile Code) Profile Profile ID (Profile ID) 1..n
Language ID (Language ID) Windows Language () 1..n

Table Relations From Other Tables

From Table From Field