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