| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGeneral |
1 | AGRS | G/L Account Advanced Rules for Resources - History | 18 | ResCode | Resource No. | nVarChar | 20 | 0 | | |
2 | ARSC | Resource Master Data - Log | 1 | ResCode | Internal Code | nVarChar | 20 | 0 | | |
3 | ARSC1 | Resources - Warehouses - Log | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
4 | ARSC2 | Resources - Prices - Log | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
5 | ARSC3 | Resouces - Fixed Assets - Log | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
6 | ARSC4 | Resources - Employees - Log | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
7 | ARSC5 | Resources - Preferred Vendors - Log | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
8 | ARSC6 | Resources - Daily Capacities - Log | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
9 | COLM | COLM resource | 62 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
10 | DOCR | DOCR | 58 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
11 | FORM | FORM resource | 16 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
12 | ITEM | Item Resource | 69 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
13 | ITMR | ITMR | 101 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
14 | MDKY | MetaData Tables DKeys | 9 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
15 | MFLD | MetaData Tables Fields | 23 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
16 | MHKY | MetaData Tables HKeys | 10 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
17 | MTBL | MetaData Tables | 11 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
18 | MVAL | MetaData Tables Fields Vals | 11 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
19 | OGRS | G/L Account Advanced Rules for Resources | 18 | ResCode | Resource No. | nVarChar | 20 | 0 | | |
20 | ORCJ | Resource Capacity Log | 2 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
21 | ORSC | Resources | 1 | ResCode | Internal Code | nVarChar | 20 | 0 | | |
22 | RLOG | Resource Edit Log | 11 | ResCode | Resource Code | Int | 11 | 0 | -1 | |
23 | RSC1 | Resources - Warehouses | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
24 | RSC2 | Resources - Prices | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
25 | RSC3 | Resouces - Fixed Assets | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
26 | RSC4 | Resources - Employees | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
27 | RSC5 | Resources - Preferred Vendors | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
28 | RSC6 | Resources - Daily Capacities | 1 | ResCode | Internal Resource ID | nVarChar | 20 | 0 | | |
29 | STRI | String list item resource | 10 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
30 | STRL | String List resource | 8 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
31 | TABL | Table resource | 17 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
32 | TYPR | TYPR | 8 | ResCode | Resource Code from RSBD | Int | 11 | 0 | -1 | |
TOPInventory and Production |
33 | ORTL | Resource Transaction Log | 2 | ResCode | Resource Code | nVarChar | 20 | 0 | | |