| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | P2NZ_LVTAK | Payroll Result: Leave Taken LVTAK - NZ | 11 | PDIND | Pay rate indicator for leave taken - NZ | nvarchar | 1 | 0 | | |
| TOPProduction and Revenue Accounting |
| 2 | OIUX1_ARCH_MKTH | Reporting history for marketing costs for reporting | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 3 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 4 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 5 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 6 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 7 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| TOPPublic Sector |
| 8 | PA0573 | Master leave code for Public Sector Australia | 183 | PDIND | Day Indicator | nvarchar | 2 | 0 | | |
| TOPRoyalty Reporting |
| 9 | OIUREP_LGL_RPTS | Legal Reports for Tax and Royalty Reporting | 5 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| TOPTax Reporting |
| 10 | OIUX1_ADJ_MKTC | Tax adjustments marketing costs for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 11 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 12 | OIUX1_ADJ_XMPC | Tax adjustment exemptions for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 13 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 14 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 15 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 10 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 16 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 15 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 17 | OIUX1_TRN_MKTC | Tax transaction marketing costs for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 18 | OIUX1_TRN_MKTL | Tax transaction marketing costs for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 19 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 20 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 21 | OIUX1_TRN_XMPC | Tax transaction exemptions for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 22 | OIUX1_TRN_XMPL | Tax transaction exemptions for reporting | 7 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
| 23 | OIUX1_VKEY_XREF | Table for variable key in Tax Reporting | 3 | PDIND | Purchaser/Producer Indicator | nvarchar | 1 | 0 | | |
