| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAccounting Engine |
| 1 | FINACHD | Accounting Document Header | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 2 | FINACITCASH | Line Items in the Cash Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 3 | FINACITCRV | Line Items in Cost and Revenue Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 4 | FINACITDUE | Line Items in the AP/AR Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 5 | FINACITFXA | Line Item in Asset Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 6 | FINACITGEN | Line Items in General Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 7 | FINACITGRI | Line Items in the GR/IR Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 8 | FINACITINV | Line Items in the Material Inventory Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 9 | FINACITTAX | Line Items in the Tax Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 10 | FINACITWIP | Line Items in the WIP Journal | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| TOPInventory Accounting |
| 11 | FAIBSV01 | Incoming/Outgoing Invoices | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 12 | FAIBSV02 | Valuated Receipts | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
| 13 | FAIBSV03 | Logistical Goods Movements | 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | | |
