| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | FINACITCASH | Line Items in the Cash Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
2 | FINACITCRV | Line Items in Cost and Revenue Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
3 | FINACITDUE | Line Items in the AP/AR Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
4 | FINACITFXA | Line Item in Asset Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
5 | FINACITGEN | Line Items in General Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
6 | FINACITGRI | Line Items in the GR/IR Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
7 | FINACITINV | Line Items in the Material Inventory Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
8 | FINACITTAX | Line Items in the Tax Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
9 | FINACITWIP | Line Items in the WIP Journal | 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
TOPFinancials |
10 | FINPOSTYPE0C | FS item categories | 1 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |
11 | FINPOSTYPE0T | Texts of Item Categories | 2 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | | |