| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAccounting Engine |
| 1 | FINACHD | Accounting Document Header | 29 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| TOPFinancials |
| 2 | FINBTATYPE0C | Business Transaction Categories | 1 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 3 | FINBTATYPE0T | Business Transaction Categories | 2 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 4 | FINVALSTRATDERIV | Derivation Table: Valuation Strategy for Business Transactio | 4 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| TOPInventory Accounting |
| 5 | FAIBSV01 | Incoming/Outgoing Invoices | 13 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 6 | FAIBSV02 | Valuated Receipts | 11 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 7 | FAIBSV03 | Logistical Goods Movements | 13 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 8 | UAINVREVALH | Document for INV Price Change and Inventory Revaluation | 3 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 9 | UAINV_BTACOGSC | Additional Business Trans Categories for Revaluation of COS | 3 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 10 | UAIQSEDGETYPE | Quantity Structure: Edge Type (of Sender/Rec. Relationship) | 3 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 11 | UAIQSITEMCTRL | Quantity Structure: Control Table Items | 1 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 12 | UAI_ABGRIR_ACTIV | Activation of Transaction-Based GR/IR Clearing | 2 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
| 13 | UAI_ABGRIR_BTA | Business Trans. Categories of Transactional GR/IR Clearing | 2 | FIN_BTATYPE | Business Transaction Category | nvarchar | 5 | 0 | | |
