| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AIQI | Inventory Opening Balance | 5 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
2 | AIQR | Inventory Posting | 5 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
3 | AQI1 | Inventory Opening Balance - Rows | 12 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
4 | AQR1 | Inventory Posting - Rows | 12 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
5 | IOD1 | Inventory Opening Balance Draft - Rows | 12 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
6 | IPD1 | Inventory Posting Draft - Rows | 12 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
7 | IQI1 | Inventory Opening Balance - Rows | 12 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
8 | IQR1 | Inventory Posting - Rows | 12 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
9 | OIOD | Inventory Opening Balance Draft | 5 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
10 | OIPD | Inventory Posting Draft | 5 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
11 | OIQI | Inventory Opening Balance | 5 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
12 | OIQR | Inventory Posting | 5 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
13 | OIVL | Whse Journal | 47 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
14 | SIVL | Whse Journal | 47 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |
15 | UIVL | Whse Journal | 47 | DOffDecAcc | Inventory Offset Decrease Acct | nVarChar | 15 | 0 | | |