Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Administration | ||||||||||
1 | AAD1 | Administration Extension-Log | 89 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
2 | ADM1 | Administration Extension | 89 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
Business Partners | ||||||||||
3 | ABPL | Business Place | 51 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
4 | ACR1 | Business Partner Addresses - History | 25 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
5 | ACRD | Business Partners - History | 308 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
6 | CRD1 | Business Partners - Addresses | 25 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
7 | OBPL | Business Place | 51 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
8 | OCRD | Business Partner | 308 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
Inventory and Production | ||||||||||
9 | AWHS | Warehouses - History | 90 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
10 | OWHS | Warehouses | 90 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
Service | ||||||||||
11 | ASC6 | Service Call Scheduling - History | 36 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 | ||
12 | SCL6 | Service Call Scheduling | 36 | GlblLocNum | Global Location Number | nVarChar | 50 | 0 |