| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /SLOAP/BILLINFO | SLOAS Service Billing Information | 4 | PDATE | Field of type DATS | nvarchar | 8 | 0 | | |
| 2 | P05TPRNL_PR_RSP | Pension Return: PR - Output Data - Response Data | 8 | PDATE | Processing Date for Response Message | nvarchar | 8 | 0 | | |
| 3 | P2NZ_EMS | Payroll Result: Employer Monthly Schedule - NZ | 6 | PDATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
| 4 | T549S | Personnel Date Specifications Per Payroll Period | 8 | PDATE | Date Specifications Per Payroll Period | nvarchar | 8 | 0 | | |
| 5 | T7OM10 | Visa Block Request Information | 6 | PDATE | Ministry of Labor Approval Date | nvarchar | 8 | 0 | | |
| 6 | T7QA61 | Visa Block Request Information | 6 | PDATE | Ministry of Labor Approval Date | nvarchar | 8 | 0 | | |
| 7 | T7SA45 | Visa Block Request Information | 6 | PDATE | Ministry of Labor Approval Date | nvarchar | 8 | 0 | | |
| TOPAlternative Valuation Run |
| 8 | CKMLRUNW | Runs for Weekly Actual Costing in Material Ledger | 13 | PDATE | Last Day of Reporting Period | nvarchar | 8 | 0 | | |
| TOPBasic Functions |
| 9 | T807R | FI-SL Rollup: History of Executions | 3 | PDATE | Date of the last execution | nvarchar | 8 | 0 | | |
| TOPBilling |
| 10 | SDINVUPD | VPRS Update: Worklist for VPRS Update | 11 | PDATE | System Date | nvarchar | 8 | 0 | | |
| TOPClinical System |
| 11 | N1MEOACT | i.s.h.med: Medication, Order Activities | 6 | PDATE | Medication: Planned Date of Order Activity | nvarchar | 8 | 0 | | |
| TOPContract Accounts Receivable and Payable |
| 12 | DFKKDEFREV_POS | Line Item Table (Event-Based Deferred Revenues) | 7 | PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | | |
| 13 | DFKKDEFREV_TRIG | Trigger Table - Amounts (Event-Based Deferred Revenues) | 4 | PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | | |
| 14 | FKKDEFREV | Trigger Table for Deferred Revenue Postings | 4 | PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | | |
| TOPDenmark |
| 15 | T5M49 | Date Identifiers for Special Payroll | 11 | PDATE | Date Specifications Per Payroll Period | nvarchar | 8 | 0 | | |
| 16 | T5MFH | Special Transfer Days for Wage Types | 11 | PDATE | Special Transfer Day for a Wage Type | nvarchar | 8 | 0 | | |
| TOPFinancial Services Localization |
| 17 | /GSINS/UPR_DEFRE | UPR - Calculation of unearned insurance premium reserve | 4 | PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | | |
| 18 | /GSINS/UPR_FKUPR | UPR - Calculation of unearned insurance premium reserve | 7 | PDATE | Transfer Posting Date for Delayed Revenues | nvarchar | 8 | 0 | | |
| TOPFunds Management |
| 19 | FMRESUPDC | Status Table for Conversion Programs | 5 | PDATE | Date | nvarchar | 8 | 0 | | |
| 20 | KBLP | Document Item: Manual Document Entry | 99 | PDATE | ITFM: Peremption Date | nvarchar | 8 | 0 | | |
| TOPGreat Britain |
| 21 | T5GEF01 | HR-GB: filing - Store parsed recording coming in from GG | 27 | PDATE | Date when record set to status processed | nvarchar | 8 | 0 | | |
| TOPHR Information Systems |
| 22 | HRSEL_STRUCTURE | Structural Reporting | 10 | PDATE | Structural Authorization Selection Period | nvarchar | 1 | 0 | | |
| TOPJust-In-Time Processing |
| 23 | JITIT | Components Group | 6 | PDATE | Planned Dispatch Time | decimal | 15 | 0 | | |
| TOPKorea |
| 24 | T7KRTM | Tax calculation method | 3 | PDATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
| TOPLocalization |
| 25 | J_1IQRDEP | Quarterly Returns Depot structure | 32 | PDATE | Actual Goods Movement Date | nvarchar | 8 | 0 | | |
| 26 | J_3RSEXTRACTD | Exctract details (obsolete) | 27 | PDATE | Payment date | nvarchar | 8 | 0 | | |
| TOPOrganizational Management |
| 27 | T77PR | Definition of Authorization Profiles | 12 | PDATE | Structural Authorization Selection Period | nvarchar | 1 | 0 | | |
| TOPRecords and Case Management |
| 28 | RMPS_DISPORTION | Disposal Portion | 4 | PDATE | (8-character) Date for SYST | nvarchar | 8 | 0 | | |
| TOPRisk Analysis |
| 29 | JBROZPROTPOS | RM Gap: Log Information from OI Determination (Items) | 3 | PDATE | Funds flow date within cash flow | nvarchar | 8 | 0 | | |
| TOPRuntime Analysis |
| 30 | SATR_PRFL | SAT: Profile | 7 | PDATE | | nvarchar | 8 | 0 | | |
| TOPSales and Distribution |
| 31 | J_1USEXTRACTD | EXTRACTD | 27 | PDATE | | nvarchar | 8 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 32 | OIJPLCAL | OIL-TSW: Planning Calendar Definitions | 6 | PDATE | Date | nvarchar | 8 | 0 | | |
| TOPUpgrade Tools |
| 33 | TICNV | DD: Status of Incremental Conversions | 22 | PDATE | System Date | nvarchar | 8 | 0 | | |
| TOPUSA |
| 34 | T5UGJ | Print Request of Notification Letters | 7 | PDATE | Date for Printing | nvarchar | 8 | 0 | | |
| 35 | T5UGK | Print Request of Answer Letters | 6 | PDATE | Date for Printing | nvarchar | 8 | 0 | | |
