| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPPublic Sector Contract Accounts Receivable and Payable |
1 | DFMCA_BRF700 | BRF: Check Registration Status | 10 | PERIOD_KEY | BRF: Expression | nvarchar | 20 | 0 | | |
2 | DFMCA_BRF710 | BRF: Offset Period Key | 6 | PERIOD_KEY | BRF: Expression | nvarchar | 20 | 0 | | |
3 | DFMCA_BRF720 | BRF: Statute of Limitations | 7 | PERIOD_KEY | BRF: Expression | nvarchar | 20 | 0 | | |
4 | DFMCA_BRF730 | BRF: Read Tax Liabilities | 10 | PERIOD_KEY | BRF: Expression | nvarchar | 20 | 0 | | |
5 | DFMCA_RETURN | Data Table for Tax Returns | 19 | PERIOD_KEY | Key for Period Assignment | nvarchar | 4 | 0 | | |
6 | DFMCA_RETURN_M | Data Table for Additional Accounting Data in Return | 9 | PERIOD_KEY | Key for Period Assignment | nvarchar | 4 | 0 | | |
7 | DFMCA_RETURN_O | Data Table for Tax Returns | 22 | PERIOD_KEY | Key for Period Assignment | nvarchar | 4 | 0 | | |
8 | TFMCA_BRF290 | BRF: Parameters for Address Check | 8 | PERIOD_KEY | Key for Period Assignment | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
9 | TRCOTS_PERIODS | Period Defintions | 2 | PERIOD_KEY | Period key for calendar periods | nvarchar | 3 | 0 | | |
10 | TRCOTS_PERIODS_T | Period Defintions | 2 | PERIOD_KEY | Period key for calendar periods | nvarchar | 3 | 0 | | |