| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | ALR2 | Dynamic message data row | 2 | Location | The order of columns in message | Int | 11 | 0 | | |
2 | ALR3 | Dynamic message data cells | 2 | Location | Number of Column in Message | Int | 11 | 0 | | |
3 | NFN1 | Not a Fiscal Sequence | 20 | Location | Location Code | Int | 11 | 0 | | |
4 | OCSN | Certificate Series | 4 | Location | Location | Int | 11 | 0 | | |
5 | OERX | Excise Register Numbering Ext | 2 | Location | Loc. | Int | 11 | 0 | | |
TOPBusiness Partners |
6 | OCLG | Activities | 26 | Location | Location | Int | 6 | 0 | -1 | |
TOPFinance |
7 | AJD1 | Journal Entry - History - Rows | 94 | Location | Loc. | Int | 11 | 0 | | |
8 | AJDT | Journal Entry - History | 60 | Location | Loc. | Int | 11 | 0 | | |
9 | AWHT | Withholding Tax | 32 | Location | Location | Int | 11 | 0 | | |
10 | BTF1 | Journal Voucher - Rows | 94 | Location | Loc. | Int | 11 | 0 | | |
11 | JDT1 | Journal Entry - Rows | 94 | Location | Loc. | Int | 11 | 0 | | |
12 | OACK | Acknowledge Number | 5 | Location | Location | Int | 11 | 0 | | |
13 | OBTF | Journal Voucher Entry | 60 | Location | Loc. | Int | 11 | 0 | | |
14 | OJDT | Journal Entry | 60 | Location | Loc. | Int | 11 | 0 | | |
15 | OWHT | Withholding Tax | 32 | Location | Location | Int | 11 | 0 | | |
TOPInventory and Production |
16 | ABTN | Batch Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
17 | ABTW | Batch Attributes in Location | 4 | Location | Location | nVarChar | 100 | 0 | | |
18 | AITM | Items - History | 271 | Location | Location | Int | 11 | 0 | | |
19 | AQI1 | Inventory Opening Balance - Rows | 32 | Location | Location | Int | 11 | 0 | | |
20 | ASRN | Serial Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
21 | AWHS | Warehouses - History | 29 | Location | Location | Int | 11 | 0 | | |
22 | IOD1 | Inventory Opening Balance Draft - Rows | 32 | Location | Location | Int | 11 | 0 | | |
23 | IQI1 | Inventory Opening Balance - Rows | 32 | Location | Location | Int | 11 | 0 | | |
24 | OAIM | Archive Inventory Message | 46 | Location | Location | Int | 11 | 0 | | |
25 | OBTN | Batch Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
26 | OBTW | Batch Attributes in Location | 4 | Location | Location | nVarChar | 100 | 0 | | |
27 | ODBN | Bat. Nos - Draft - Master Data | 12 | Location | Loc. | nVarChar | 100 | 0 | | |
28 | ODBW | Batch Draft Attribs in Locat. | 4 | Location | Loc. | nVarChar | 100 | 0 | | |
29 | ODSN | SNs - Draft - Master Data | 12 | Location | Loc. | nVarChar | 100 | 0 | | |
30 | ODSW | SN Draft Attribs in Location | 4 | Location | Loc. | nVarChar | 100 | 0 | | |
31 | OILM | Inventory Log Message | 66 | Location | Location | Int | 11 | 0 | | |
32 | OITM | Items | 271 | Location | Location | Int | 11 | 0 | | |
33 | OLCT | Location | 2 | Location | Name | nVarChar | 100 | 0 | | |
34 | OSRN | Serial Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
35 | OSRW | Serial No. Attribs in Location | 4 | Location | Location | nVarChar | 100 | 0 | | |
36 | OWHS | Warehouses | 29 | Location | Location | Int | 11 | 0 | | |
37 | SITM | Items | 271 | Location | Location | Int | 11 | 0 | | |
38 | UBTN | Batch Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
39 | UILM | IVI Inventory Log Message | 66 | Location | Location | Int | 11 | 0 | | |
40 | UITM | Items | 271 | Location | Location | Int | 11 | 0 | | |
41 | USRN | Serial Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
TOPService |
42 | ASCL | History | 75 | Location | Location | Int | 6 | 0 | -1 | |
43 | OSCL | Service Calls | 75 | Location | Location | Int | 6 | 0 | -1 | |