| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREP_XTRCT_ROY | Extract Royaty Data for the current reporting period | 103 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
TOPTax Reporting |
2 | OIUX1_ADJ_MKTC | Tax adjustments marketing costs for reporting | 14 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
3 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 36 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
4 | OIUX1_ADJ_TAXHC | Tax adjustments header for reporting | 27 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
5 | OIUX1_ADJ_XMPC | Tax adjustment exemptions for reporting | 15 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
6 | OIUX1_TRN_MKTC | Tax transaction marketing costs for reporting | 14 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
7 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 36 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
8 | OIUX1_TRN_TAXHC | Tax transaction header for reporting | 24 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
9 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 24 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |
10 | OIUX1_TRN_XMPC | Tax transaction exemptions for reporting | 15 | REJECT_FLAG | Reject flag | nvarchar | 1 | 0 | | |