| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F06106 | Employee Pay Instructions | 104 | YM | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
2 | F0618 | Employee Transaction History | 121 | YT | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
TOP05T: Time Entry |
3 | F06116 | Employee Transaction Detail File | 173 | YT | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
4 | F06116Z1 | Employee Transactions - Batch File | 186 | VL | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
TOP07: Payroll |
5 | F0716701 | Employee Assignment T/E Template Information | 1 | EA | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
6 | F0716702 | Employee Assignment Rates | 1 | EA | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
7 | F0716703 | Employee Assignment Job Description | 1 | EA | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
8 | F0716709 | Employee Assignment T/E Template Info History | 1 | EA | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
9 | F0729 | Employee DBA Override Instructions | 6 | Y9 | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
TOP13R: Resource Assignments |
10 | F48311 | Resource Assignments | 1 | RA | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
11 | F48311S | Purge - Resource Assignments | 1 | RA | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
TOP18: Resource Scheduling |
12 | F186602 | Labor Rules Tag File | 179 | TF | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
TOP48S: Service Billing |
13 | F48S0618 | Payroll Reclassification Workfile | 121 | YT | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |
TOP87: JDE Internal |
14 | F1811 | Task Resource | 1 | TK | TSKID | Task Unique Key ID | Numeric | Generic Edit | 15 | 0 |