Diagrams


Table

Config. Setup

Fields

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

Keys

# Fields
0 Primary Key Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field