| 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 | ACL1 | Activity Check-ins | 4 | Location | Location | nVarChar | 254 | 0 | | |
7 | ACLG | Activities - History | 26 | Location | Location | Int | 6 | 0 | -1 | |
8 | CLG1 | Activity CheckIns | 4 | Location | Location | nVarChar | 254 | 0 | | |
9 | OCLG | Activities | 26 | Location | Location | Int | 6 | 0 | -1 | |
TOPFinance |
10 | AJD1 | Journal Entry - History - Rows | 94 | Location | Loc. | Int | 11 | 0 | | |
11 | AJDT | Journal Entry - History | 60 | Location | Loc. | Int | 11 | 0 | | |
12 | AWHT | Withholding Tax | 32 | Location | Location | Int | 11 | 0 | | |
13 | BTF1 | Journal Voucher - Rows | 94 | Location | Loc. | Int | 11 | 0 | | |
14 | JDT1 | Journal Entry - Rows | 94 | Location | Loc. | Int | 11 | 0 | | |
15 | OACK | Acknowledge Number | 5 | Location | Location | Int | 11 | 0 | | |
16 | OBTF | Journal Voucher Entry | 60 | Location | Loc. | Int | 11 | 0 | | |
17 | OJDT | Journal Entry | 60 | Location | Loc. | Int | 11 | 0 | | |
18 | OWHT | Withholding Tax | 32 | Location | Location | Int | 11 | 0 | | |
TOPGeneral |
19 | ASH1 | Project Management Time Sheet - Rows - History | 13 | Location | Location | Int | 11 | 0 | | |
20 | TSH1 | Project Management Time Sheet - Rows | 13 | Location | Location | Int | 11 | 0 | | |
TOPInventory and Production |
21 | ABTN | Batch Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
22 | ABTW | Batch Attributes in Location | 4 | Location | Location | nVarChar | 100 | 0 | | |
23 | AITM | Items - History | 271 | Location | Location | Int | 11 | 0 | | |
24 | AQI1 | Inventory Opening Balance - Rows | 32 | Location | Location | Int | 11 | 0 | | |
25 | ASRN | Serial Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
26 | AWHS | Warehouses - History | 29 | Location | Location | Int | 11 | 0 | | |
27 | IOD1 | Inventory Opening Balance Draft - Rows | 32 | Location | Location | Int | 11 | 0 | | |
28 | IQI1 | Inventory Opening Balance - Rows | 32 | Location | Location | Int | 11 | 0 | | |
29 | OAIM | Archive Inventory Message | 46 | Location | Location | Int | 11 | 0 | | |
30 | OBTN | Batch Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
31 | OBTW | Batch Attributes in Location | 4 | Location | Location | nVarChar | 100 | 0 | | |
32 | ODBN | Bat. Nos - Draft - Master Data | 12 | Location | Loc. | nVarChar | 100 | 0 | | |
33 | ODBW | Batch Draft Attribs in Locat. | 4 | Location | Loc. | nVarChar | 100 | 0 | | |
34 | ODSN | SNs - Draft - Master Data | 12 | Location | Loc. | nVarChar | 100 | 0 | | |
35 | ODSW | SN Draft Attribs in Location | 4 | Location | Loc. | nVarChar | 100 | 0 | | |
36 | OILM | Inventory Log Message | 66 | Location | Location | Int | 11 | 0 | | |
37 | OITM | Items | 271 | Location | Location | Int | 11 | 0 | | |
38 | OLCT | Location | 2 | Location | Name | nVarChar | 100 | 0 | | |
39 | OSRN | Serial Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
40 | OSRW | Serial No. Attribs in Location | 4 | Location | Location | nVarChar | 100 | 0 | | |
41 | OWHS | Warehouses | 29 | Location | Location | Int | 11 | 0 | | |
42 | SITM | Items | 271 | Location | Location | Int | 11 | 0 | | |
43 | UBTN | Batch Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
44 | UILM | IVI Inventory Log Message | 66 | Location | Location | Int | 11 | 0 | | |
45 | UITM | Items | 271 | Location | Location | Int | 11 | 0 | | |
46 | USRN | Serial Numbers Master Data | 12 | Location | Location | nVarChar | 100 | 0 | | |
TOPService |
47 | ASC6 | Service Call Scheduling - History | 10 | Location | Location | Int | 6 | 0 | -1 | |
48 | ASCL | History | 75 | Location | Location | Int | 6 | 0 | -1 | |
49 | OSCL | Service Calls | 75 | Location | Location | Int | 6 | 0 | -1 | |
50 | SCL6 | Service Call Scheduling | 10 | Location | Location | Int | 6 | 0 | -1 | |