| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAccounting Engine |
1 | /EACC/V_CUR | Currency Types | 4 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
2 | /EACC/V_CUR_SUB | Names of Views for Currency Types | 4 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
TOPBusiness Accounting |
3 | UAV0PRICE001 | Price Table with Period Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
4 | UAV0PRICE001H | Price History Table with Period Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
5 | UAV0PRICE002 | Price Table with Date Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
6 | UAV0PRICE002H | Price History Table with Date Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
7 | UAV0PRICE003 | Price Table with Period Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
8 | UAV0PRICE003H | Price History Table with Period Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
9 | UAV0PRICE004 | Price Table with Date Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
10 | UAV0PRICE004H | Price History Table with Date Dependency | 7 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
TOPFinancials |
11 | FINCURRTYPE0C | Currency Type | 1 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
12 | FINCURRTYPE0T | Text for Currency Type | 2 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
TOPInventory Accounting |
13 | FAIBSV17C | Rule: Currency Types | 3 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
14 | UAINVDEBCRI | Document Item for Revaluation Through Material Debit/Credit | 5 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |
15 | UAINVREVALI | Document Item for Inventory Price Change and Revaluation | 5 | FIN_CURRTYPE | Currency Type | nvarchar | 2 | 0 | | |