| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F0609 | Deduction/Benefit/Accrual Ledger File | 4 | Y$ | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
2 | F0618 | Employee Transaction History | 69 | YT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
3 | F0619 | Benefit/Accrual Detail File | 4 | Y$ | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
4 | F0709 | Deduction/Benefit/Accrual Ledger File | 4 | Y$ | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
TOP05T: Time Entry |
5 | F06116 | Employee Transaction Detail File | 69 | YT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
6 | F06116Z1 | Employee Transactions - Batch File | 83 | VL | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
7 | F06278 | Retro Timecard Detail File | 69 | YT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
8 | F0618TA | Temp table for F0618T for conversion | 3 | YT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
TOP07: Payroll |
9 | F0719 | DBA Transaction Detail History | 4 | Y$ | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
10 | F0724 | Burden Distribution File | 3 | YS | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
11 | F07241 | Burden Distribution File | 3 | YS | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
12 | F0728 | Employee Paid Workers Compensation Transactions | 3 | YW | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
13 | F07353 | Tax Detail File | 24 | Y3 | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
14 | F07UI200 | Timecard History Work File | 72 | TH | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
TOP18: Resource Scheduling |
15 | F186301 | Timecard Templates | 10 | TT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
TOP48S: Service Billing |
16 | F48S0618 | Payroll Reclassification Workfile | 69 | YT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
TOP77: Payroll (Canadian) |
17 | F07183 | Commission History Detail File | 4 | ZB | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
TOP89: Conversion Programs |
18 | F06116T | Needed for upgrade from Xe to B9 | 3 | YT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |
19 | F0618T | Needed for upgrade from Xe to B9 | 3 | YT | DWK | Date - Worked | Date | Generic Edit | 6 | 0 |