| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | /EACC/AUNIT_MBEW | MVR Replacement for BTA Unit Test | 2 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
TOPFinancials |
2 | FINORDPUR01 | Data Storage for Purchase Order Information - Items | 12 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
3 | FINXPRODUCT01 | Local Values for FIN_PRODUCT (Not Used in Live System) | 2 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
4 | FINXPRODUCT0C | Local Values for FIN_PRODUCT (Not Used in Live System) | 2 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
TOPInventory Accounting |
5 | CFIOCONSI0C | FIN Objects for Consignment | 9 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
6 | CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) | 9 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
7 | CFIORPURITM0C | FIN Objects for Purchase Order Items | 10 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
8 | CFIPVLOCPRD0C | Product Depending on Company/Location | 5 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
9 | CFIPVLOCPRDBTC0C | Product Depending on Company/Location/Batch | 5 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
10 | UAIQSINV | Quantity Structure: Inventory Node | 4 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
11 | UAIQSPURORD | Quantity Structure: Purchasing Node | 4 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |
12 | UAIQSWIP | Quantity Structure: WIP Node | 4 | FIN_PRODUCT | Product | nvarchar | 22 | 0 | | |