| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Accounting Engine | ||||||||||
| 1 | FINACITCASH | Line Items in the Cash Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 2 | FINACITCRV | Line Items in Cost and Revenue Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 3 | FINACITDUE | Line Items in the AP/AR Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 4 | FINACITFXA | Line Item in Asset Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 5 | FINACITGEN | Line Items in General Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 6 | FINACITGRI | Line Items in the GR/IR Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 7 | FINACITINV | Line Items in the Material Inventory Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 8 | FINACITTAX | Line Items in the Tax Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 9 | FINACITWIP | Line Items in the WIP Journal | 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| Financials | ||||||||||
| 10 | FINGLACCTGRP0C | Account Group | 6 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 11 | FINJOURNAL0C | Journals | 2 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||
| 12 | FINJOURNAL0T | Texts for Journals | 3 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | ||