Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Inventory and Production | ||||||||||
1 | AIN1 | Inventory Counting - Rows | 37 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
2 | AIN2 | Inventory Counting - UoM | 17 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
3 | AITB | Item Groups - History | 76 | IUoMEntry | Default Inventory UoM | Int | 11 | 0 | ||
4 | AITM | Items - History | 264 | IUoMEntry | Inventory UoM | Int | 11 | 0 | ||
5 | AQR1 | Inventory Posting - Rows | 44 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
6 | AQR2 | Inventory Counting - UoM | 17 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
7 | ICD1 | Inventory Counting Draft - Rows | 37 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
8 | ICD2 | Inventory Counting Draft - UoM | 17 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
9 | INC1 | Inventory Counting - Rows | 37 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
10 | INC2 | Inventory Counting - UoM | 17 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
11 | IPD1 | Inventory Posting Draft - Rows | 44 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
12 | IPD2 | Inventory Posting Draft - UoM | 17 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
13 | IQR1 | Inventory Posting - Rows | 44 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
14 | IQR2 | Inventory Posting - UoM | 17 | IUomEntry | Inventory UoM Entry | nVarChar | 20 | 0 | ||
15 | OITB | Item Groups | 76 | IUoMEntry | Default Inventory UoM | Int | 11 | 0 | ||
16 | OITM | Items | 264 | IUoMEntry | Inventory UoM | Int | 11 | 0 | ||
17 | SITM | Items | 264 | IUoMEntry | Inventory UoM | Int | 11 | 0 | ||
18 | UITM | Items | 264 | IUoMEntry | Inventory UoM | Int | 11 | 0 |