| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCheck Input |
| 1 | OIUCI_CDEXH | CDEX Header | 9 | EFF_DATE | Effective Date | nvarchar | 4 | 0 | | |
| TOPDistributor-Reseller-Management |
| 2 | /SAPHT/DRMAGRWL | DRM - worklist table for agreement negotiation | 10 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | | |
| 3 | /SAPHT/DRMBUDL | Bill Up Due List | 7 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | | |
| 4 | /SAPHT/DRMDETL | DRM Audit Trail | 67 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | | |
| 5 | /SAPHT/DRMINVSUM | DRM Inventory Summary | 14 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | | |
| 6 | /SAPHT/DRMSDDL | Ship and Debit Due List | 7 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | | |
| 7 | /SAPHT/DRMSTAG | DRM Staging Area | 7 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | | |
| 8 | S495 | Transmission Report | 20 | EFF_DATE | Effective date of EDI transmission | nvarchar | 8 | 0 | | |
| TOPNon Profit Organizations |
| 9 | T7UNCMT_CNTY | CMT Interface: Country | 6 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 10 | T7UNCMT_DEPA | CMT Interface: Dependency Allowed | 8 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 11 | T7UNCMT_DSSG | CMT Interface: Staff Assessment Grade Range | 10 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 12 | T7UNCMT_EGEN | CMT Interface: Education Grant Entitlement | 7 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 13 | T7UNCMT_EXCH | CMT Interface: Exchange Rate | 4 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 14 | T7UNCMT_HDSC | CMT Hardship Classification | 4 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 15 | T7UNCMT_HDSP | CMT Hardship Element | 6 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 16 | T7UNCMT_HRDC | CMT Hardship Classification | 4 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 17 | T7UNCMT_LNGA | CMT Interface: Language Allowance | 7 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 18 | T7UNCMT_MBLT | CMT Interface: Mobility Element | 8 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 19 | T7UNCMT_NNRM | CMT Interface: Non-Removal Element | 6 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 20 | T7UNCMT_PADJ | CMT Interface: Post Adjustment | 7 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 21 | T7UNCMT_PENR | CMT Interface: Pensionable Renumeration | 10 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 22 | T7UNCMT_RGNT | CMT Interface: Repatriation Grant | 7 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 23 | T7UNCMT_RMBR | CMT Interface: Reimbursible Percentage | 8 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 24 | T7UNCMT_RMXR | CMT Interface: Rental Subsidy Maximum Rent | 8 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 25 | T7UNCMT_RNGR | CMT Interface: Rental Subsidy Global Reference | 6 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 26 | T7UNCMT_RNSE | CMT Interface: Subsidy/Deduction Entitlement | 6 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 27 | T7UNCMT_RNTE | CMT Interface: Subsidy/Deduction Entitlement | 6 | EFF_DATE | | nvarchar | 8 | 0 | | |
| 28 | T7UNCMT_STFA | CMT Interface: Salary and Staff Assessment | 10 | EFF_DATE | | nvarchar | 8 | 0 | | |
| TOPRemote Logistics Management |
| 29 | OIO_CM_DOC_FLOW | RLM document flow index | 6 | EFF_DATE | Effective date | nvarchar | 8 | 0 | | |
| TOPSales |
| 30 | /CBAD/CHG_EFF_H | CBAD: Changes to the future in extended contracts - Header | 4 | EFF_DATE | Effectivity Date | nvarchar | 8 | 0 | | |
| 31 | /CBAD/CHG_FUTURE | CBAD: Changes to the future in extended contracts - Header | 4 | EFF_DATE | Effectivity Date | nvarchar | 8 | 0 | | |
| 32 | /CBAD/CONTRACT_H | Advanced Order Processing and Billing: Header Data | 4 | EFF_DATE | Effectivity Date | nvarchar | 8 | 0 | | |
| 33 | /CBAD/CONTRACT_I | Advanced Order Processing and Billing: Item Data | 9 | EFF_DATE | Effectivity Date | nvarchar | 8 | 0 | | |
| 34 | /CBAD/CON_DBS | Advanced Order Processing and Billing: DBS Item Data | 7 | EFF_DATE | Effectivity Date | nvarchar | 8 | 0 | | |
| 35 | /CBAD/CON_FUND_H | Advanced Order Processing and Billing: Fund Header Data | 5 | EFF_DATE | Effectivity Date | nvarchar | 8 | 0 | | |
