| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | AITB | Item Groups - History | 79 | CompoWH | Component Warehouse | VarChar | 1 | 0 | B | B=From Bill of Materials Line, P=From Parent Item Document Line |
2 | AITM | Items - History | 299 | CompoWH | Component Warehouse | VarChar | 1 | 0 | B | B=From Bill of Materials Line, P=From Parent Item Document Line |
3 | OITB | Item Groups | 79 | CompoWH | Component Warehouse | VarChar | 1 | 0 | B | B=From Bill of Materials Line, P=From Parent Item Document Line |
4 | OITM | Items | 299 | CompoWH | Component Warehouse | VarChar | 1 | 0 | B | B=From Bill of Materials Line, P=From Parent Item Document Line |
5 | SITM | Items | 299 | CompoWH | Component Warehouse | VarChar | 1 | 0 | B | B=From Bill of Materials Line, P=From Parent Item Document Line |
6 | UITM | Items | 299 | CompoWH | Component Warehouse | VarChar | 1 | 0 | B | B=From Bill of Materials Line, P=From Parent Item Document Line |
TOPMRP |
7 | MSN4 | MRP Scenarios - Items Array | 14 | CompoWH | Component Warehouse | VarChar | 1 | 0 | B | B=From Bill of Materials Line, P=From Parent Item Document Line |