| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCheck Input |
1 | OIUCI_RULESLOCK | Incoming Check Usage of Process Rules | 5 | PRODUCT_CODE | Product Code | nvarchar | 3 | 0 | | |
TOPExcise Duty |
2 | /BEV2/CS_C_PCODE | Product Codes | 2 | PRODUCT_CODE | EMCS: Excise Duty Product Code | nvarchar | 4 | 0 | | |
3 | /BEV2/CS_C_PCODT | Text Table - Product Codes | 2 | PRODUCT_CODE | EMCS: Excise Duty Product Code | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
4 | DFMCA_TF_MFT_D_H | Header Table of Motor Fuel Tax Disbursement Schedule | 4 | PRODUCT_CODE | Product Code for Motor Fuel Tax | nvarchar | 1 | 0 | | |
5 | DFMCA_TF_MFT_R_H | Header Table of Motor Fuel Tax Receipts Schedule | 4 | PRODUCT_CODE | Product Code for Motor Fuel Tax | nvarchar | 1 | 0 | | |
TOPRevenue |
6 | OIUH_NM_PDCD_XRF | New Mexico Product Code Cross Reference (TBLTR091) | 3 | PRODUCT_CODE | | nvarchar | 2 | 0 | | |
TOPRoyalty Reporting |
7 | OIUREP_PDCD_XREF | Cross Reference Between State Agency and PRA Material | 5 | PRODUCT_CODE | Material Number | nvarchar | 18 | 0 | | |