| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | FINACITCRV | Line Items in Cost and Revenue Journal | 46 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
2 | FINACITFXA | Line Item in Asset Journal | 40 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
3 | FINACITGRI | Line Items in the GR/IR Journal | 40 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
4 | FINACITINV | Line Items in the Material Inventory Journal | 42 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
5 | FINACITWIP | Line Items in the WIP Journal | 46 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
TOPInventory Accounting |
6 | FAIBSV01 | Incoming/Outgoing Invoices | 32 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
7 | FAIBSV02 | Valuated Receipts | 29 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
8 | FAIBSV03 | Logistical Goods Movements | 15 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
9 | UAINVDEBCRI | Document Item for Revaluation Through Material Debit/Credit | 11 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |
10 | UAINVREVALI | Document Item for Inventory Price Change and Revaluation | 12 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | | |