| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMaintenance Orders |
1 | /MRSS/C_DEMSCHED | Demand Scheduling Active? | 3 | SCHEDULE_TYPE | Type of Demand Scheduling | nvarchar | 1 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
2 | DFMCA_TF_MFT_D_H | Header Table of Motor Fuel Tax Disbursement Schedule | 5 | SCHEDULE_TYPE | Schedule Type for Motor Fuel Tax Disbursement Schedule | nvarchar | 2 | 0 | | |
3 | DFMCA_TF_MFT_R_H | Header Table of Motor Fuel Tax Receipts Schedule | 5 | SCHEDULE_TYPE | Schedule Type for Motor Fuel Tax Receipt Schedule | nvarchar | 2 | 0 | | |
TOPSAP Business Partner |
4 | CRMM_BUT_FRG0060 | Business Partner Business Hours | 3 | SCHEDULE_TYPE | Schedule Type | nvarchar | 1 | 0 | | |
5 | CRMM_BUT_FRG0061 | Business Partner Business Hours Interval | 3 | SCHEDULE_TYPE | Schedule Type | nvarchar | 1 | 0 | | |
6 | TB049 | Appointment Rules: Schedule Types | 3 | SCHEDULE_TYPE | Schedule Type | nvarchar | 1 | 0 | | |
7 | TB049T | Appointment Rules: Texts for Schedule Types | 4 | SCHEDULE_TYPE | Schedule Type | nvarchar | 1 | 0 | | |
TOPStructure |
8 | DPR_PROJECT | Project Definition | 18 | SCHEDULE_TYPE | Scheduling Type | nvarchar | 1 | 0 | | |
9 | DPR_PRO_TYPE | Project Type | 29 | SCHEDULE_TYPE | Scheduling Type | nvarchar | 1 | 0 | | |
TOPTools |
10 | HRPYO_D_SCHDL | Schedule | 5 | SCHEDULE_TYPE | Payroll Schedule Type | nvarchar | 10 | 0 | | |
11 | T77PYOTMPLT | Template Definition | 3 | SCHEDULE_TYPE | Payroll Schedule Type | nvarchar | 10 | 0 | | |