| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | FINACITCASH | Line Items in the Cash Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
2 | FINACITCRV | Line Items in Cost and Revenue Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
3 | FINACITDUE | Line Items in the AP/AR Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
4 | FINACITFXA | Line Item in Asset Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
5 | FINACITGEN | Line Items in General Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
6 | FINACITGRI | Line Items in the GR/IR Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
7 | FINACITINV | Line Items in the Material Inventory Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
8 | FINACITTAX | Line Items in the Tax Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
9 | FINACITWIP | Line Items in the WIP Journal | 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
TOPFinancials |
10 | FINORDPUR01 | Data Storage for Purchase Order Information - Items | 15 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
11 | FINXCOSTCTR0C | Local Values for FIN_COSTCTR (Not Used in Live System) | 5 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
12 | FINXPROFITCTR0C | Local Values for FIN_PROFITCTR (Not Used in Live System) | 3 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
13 | FINXPROFITCTR0T | Local Texts for FIN_PROFITCTR (Not Used in Live System) | 4 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
TOPInventory Accounting |
14 | CFIOCONSI0C | FIN Objects for Consignment | 11 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
15 | CFIOGMVMT0C | FIN Objects for Material Documents (GR-Based IV) | 11 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
16 | CFIOSENTR0C | FIN Objects for Services | 11 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
17 | UAIQSINV | Quantity Structure: Inventory Node | 6 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
18 | UAIQSPURORD | Quantity Structure: Purchasing Node | 9 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |
19 | UAIQSWIP | Quantity Structure: WIP Node | 8 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | | |