| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DIAN_A_XRUN | DIAN Extraction Runs | 5 | AJAHR | Year | nvarchar | 4 | 0 | | |
2 | T440L | Correction Factors: Forecast | 4 | AJAHR | Year | nvarchar | 4 | 0 | | |
TOPBatches |
3 | PROOB | Original Batch for Production Order | 4 | AJAHR | Year in Which Original Batch was Created | nvarchar | 4 | 0 | | |
4 | PUROB | Original Batch for Purchase Order | 4 | AJAHR | Year in Which Original Batch was Created | nvarchar | 4 | 0 | | |
TOPContract Accounts Receivable and Payable |
5 | DFKKREP04 | Payment History: Open Items at End of Period | 8 | AJAHR | Reporting year | nvarchar | 4 | 0 | | |
6 | DFKKREP05 | Payment History: Reversals and Write-Offs | 8 | AJAHR | Reporting year | nvarchar | 4 | 0 | | |