| 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 | 3 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
2 | FINACITGRI | Line Items in the GR/IR Journal | 48 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
3 | FINACITINV | Line Items in the Material Inventory Journal | 43 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
4 | FINACITWIP | Line Items in the WIP Journal | 50 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
TOPFinancials |
5 | FINORDPUR01 | Data Storage for Purchase Order Information - Items | 13 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
6 | FINXLOCATION0C | Local Values for FIN_LOCATION (Not Used in Live System) | 2 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
7 | FINXPRODUCT01 | Local Values for FIN_PRODUCT (Not Used in Live System) | 3 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
TOPInventory Accounting |
8 | CFIOCONSI0C | FIN Objects for Consignment | 10 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
9 | CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) | 10 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
10 | CFIORMNF0C | FIN Objects for Manufacturing Orders | 5 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
11 | CFIORMNT0C | FIN Objects for Maintenance Orders | 5 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
12 | CFIORNTA0C | FIN Objects for Network Items | 6 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
13 | CFIORNTW0C | FIN Objects for Networks | 5 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
14 | CFIORPURITM0C | FIN Objects for Purchase Order Items | 11 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
15 | CFIORQMM0C | FIN Objects for QM Orders | 5 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
16 | CFIORSRV0C | FIN Objects for Service Orders | 5 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
17 | CFIORWBS0C | FIN Objects for WBS Elements | 5 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
18 | CFIOSENTR0C | FIN Objects for Services | 10 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
19 | CFIPVLOCPRD0C | Product Depending on Company/Location | 4 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
20 | CFIPVLOCPRDBTC0C | Product Depending on Company/Location/Batch | 4 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
21 | UAINV_DYNRELACT | Activation of Dynamic Price Release | 3 | FIN_LOCATION | Plant | nvarchar | 4 | 0 | | |
22 | UAIQSINV | Quantity Structure: Inventory Node | 3 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
23 | UAIQSPURORD | Quantity Structure: Purchasing Node | 3 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
24 | UAIQSWIP | Quantity Structure: WIP Node | 3 | FIN_LOCATION | Location | nvarchar | 22 | 0 | | |
25 | UAI_ABGRIR_ACTIV | Activation of Transaction-Based GR/IR Clearing | 4 | FIN_LOCATION | Plant | nvarchar | 4 | 0 | | |