Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
1 | FIAAPTD_COL16VAL | Residual amounts to be reported in col16 for remaining years | 4 | REPORTING_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
2 | FIAPPTD_BALANCE | Table to store the Balances for Vendor/Customer/Bank Account | 3 | REPORTING_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
3 | FIAPPTD_RUNID | Table to store the Run ID details of the CBR PT Reporting | 3 | REPORTING_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
4 | FIAPPTD_TRANS | Table to store the transaction details of the CBR PT | 13 | REPORTING_YEAR | Fiscal Year | nvarchar | 4 | 0 | ||
5 | TEXT_CTY_EXPOS | Commodity Price Exposure | 26 | REPORTING_YEAR | Reporting Year | nvarchar | 4 | 0 | ||
Asset Accounting | ||||||||||
6 | IDPT_A031 | Manual Entries for Form 32.1 | 3 | REPORTING_YEAR | Reporting Year | nvarchar | 4 | 0 |