| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBusiness Accounting |
1 | UAV0PRICE001 | Price Table with Period Dependency | 10 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
2 | UAV0PRICE001H | Price History Table with Period Dependency | 11 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
3 | UAV0PRICE002 | Price Table with Date Dependency | 10 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
4 | UAV0PRICE002H | Price History Table with Date Dependency | 11 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
5 | UAV0PRICE003 | Price Table with Period Dependency | 10 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
6 | UAV0PRICE003H | Price History Table with Period Dependency | 11 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
7 | UAV0PRICE004 | Price Table with Date Dependency | 10 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
8 | UAV0PRICE004H | Price History Table with Date Dependency | 11 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
TOPFinancials |
9 | FINXCOMPANY0C | Local Values for FIN_COMPANY (Not Used in Live System) | 4 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
TOPInventory Accounting |
10 | UAINVDEBCRI | Document Item for Revaluation Through Material Debit/Credit | 13 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |
11 | UAINVREVALI | Document Item for Inventory Price Change and Revaluation | 13 | FIN_CURRENCY | Currency Key | nvarchar | 5 | 0 | | |