JD Edwards Data Mapping Table
The JD Edwards data mapping table lists the fields that are imported from JD Edwards to Time and Expense.
The following information shows the mapping for the JDEdwards table (JDE_TS_F5606ZW):
| Field | Size | Source | Notes |
|---|---|---|---|
| WKC5606EMP | CHAR (20) | EXPORT_LABOR.empl_id | The unique identifier of the employee. |
| WKC5606TS | CHAR (10) | EXPORT_LABOR.ts_schedule_cd | The timesheet frequency identifier. |
| WKC5606FYR | CHAR (4) | EXPORT_LABOR.year_no_cd | The timesheet frequency's year code. |
| WKC5606PER | CHAR (3) | EXPORT_LABOR.period_no_cd | The period number for the timesheet frequency. |
| WKEDLN | FLOAT (126) | EXPORT_LABOR.line_no | The timesheet line number to which the timesheet cell record belongs. |
| WKC5606CDT | CHAR (10) | EXPORT_LABOR.hrs_dt | The column (cell) date for this row. |
| WKC5606SDT | CHAR (10) | TS_SCHEDULE_PERIOD.start_dt based on EXPORT_LABOR.ts_schedule_cd and EXPORT_LABOR.year_no_cd and EXPORT_LABOR.period_no_cd | The start date of the period.
Converted to String yyyy-mm-dd. |
| WKC5606EDT | CHAR (10) | TS_SCHEDULE_PERIOD.end_dt based on EXPORT_LABOR.ts_schedule_cd and EXPORT_LABOR.year_no_cd and EXPORT_LABOR.period_no_cd | End date of the period.
Converted to string yyyy-mm-dd. |
| WKEDBT | CHAR (15) | EXPORT_LABOR.batch_id | Batch Number. |
| WKC5606TSD | CHAR (10) | EXPORT_LABOR.timesheet_dt | The date associated with the timesheet.
Converted to string yyyy-mm-dd. |
| WKC5606SID | CHAR (10) | "01" | The ID of the site ID from which the timesheet and employee came. |
| WKC5606CCD | CHAR (10) | EXPORT_LABOR.class_cd | The current class to which the employee belongs. |
| WKC5606OTH | CHAR (20) | If EXPORT_LABOR.ot_fl = "Y," EXPORT_LABOR.hrs ; otherwise, 0.00. | The number of overtime hours.
Converted to string. |
| WKC5606LDS | CHAR (120) | EXPORT_LABOR.line_desc | Description of the charge on the line (Line Description). |
| WKC5606GRP | CHAR (20) | SPACES | Group Code. |
| WKC5606CHG | CHAR (45) | EXPORT_LABOR.charge_cd | Charge number for the timesheet line. |
| WKC5606CAI | CHAR (20) | SPACES | Charge abbreviation code. |
| WKC5606UTL | CHAR (10) | SPACES | Utilization code. |
| WKC5606T01 | CHAR (30) | EXPORT_LABOR.udt01_id | The UDT01 identifier for the timesheet line (Proj/Task or Work Order). |
| WKC5606T02 | CHAR (30) | EXPORT_LABOR.udt02_id if not null; otherwise, spaces, | The UDT02 identifier for the timesheet line. |
| WKC5606T03 | CHAR (20) | EXPORT_LABOR.udt03_id if not null; otherwise, spaces, | The UDT03 identifier for the timesheet line. |
| WKC5606T04 | CHAR (20) | EXPORT_LABOR.udt04_id if not null; otherwise, spaces. | The UDT04 identifier for the timesheet line. |
| WKC5606T05 | CHAR (20) | EXPORT_LABOR.udt05_id if not null; otherwise, spaces. | The UDT05 identifier for the timesheet line. |
| WKC5606T06 | CHAR (20) | EXPORT_LABOR.udt06_id if not null; otherwise, spaces. | The UDT06 identifier for the timesheet line (Job Step). |
| WKC5606T07 | CHAR (20) | EXPORT_LABOR.udt07_id if not null; otherwise, spaces. | The UDT07 identifier for the timesheet line (Job Type). |
| WKC5606T08 | CHAR (20) | EXPORT_LABOR.udt08_id if not null; otherwise, spaces. | The UDT08 identifier for the timesheet line. |
| WKC5606T09 | CHAR (20) | EXPORT_LABOR.udt09_id if not null; otherwise, spaces | The UDT09 identifier for the timesheet line. |
| WKC5606T10 | CHAR (20) | EXPORT_LABOR.udt10_id | The UDT10 identifier for the timesheet line (Pay Type). |
| WKC5606TST | CHAR (254) | EXPORT_LABOR.short_header_text if not null; otherwise, spaces. | Timesheet Text. |
| WKC5606LBR | CHAR (20) | EXPORT_LABOR.rate1_amt/ EXPORT_LABOR.hrs | The labor rate. Converted to string. |
| WKC5606LAM | CHAR (20) | EXPORT_LABOR.rate1_amt | The labor amount. Converted to string. |
| WKC5606BRT | CHAR (20) | EXPORT_LABOR.rate2_amt/ EXPORT_LABOR.hrs | The billing rate. Converted to string. |
| WKC5606BAM | CHAR (20) | EXPORT_LABOR.rate2_amt | The billing amount. Converted to string. |
| WKC5606HRS | CHAR (20) | EXPORT_LABOR.hrs | The entered labor hours for this cell. |
| WKC5606CRF | CHAR (1) | EXPORT_LABOR.correct_fl | Logical as to whether this cell is a correcting entry. |
| WKC5606CTX | CHAR (254) | EXPORT_LABOR.short_cell_text if not null; otherwise, spaces. | User-provided notes about the timesheet cell. |
| WKC5606LTX | CHAR (254) | EXPORT_LABOR.short_line_text if not null; otherwise, spaces. | User-provided notes about the timesheet line. |
| WKC5606STS | CHAR (1) | "P" | Status of the cell. |
| WKEDSP | CHAR (1) | "N" | (EditSuccessfullyProcess) Logical as to whether this cell record has been confirmed.
"N" - Record has not been picked up. "Y" - Record has been picked up. |
| WKC5606ETX | CHAR (254) | SPACES | Error Text. |
| WKC5606ETK | VARCHAR2 (50) | EXPORT_LABOR.empl_id+ EXPORT_LABOR.ts_schedule_cd + EXPORT_LABOR.year_no_cd + EXPORT_LABOR.period_no_cd +
EXPORT_LABOR.hrs_dt |
ET Key ID.
Padded with spaces to make fields full width. |
| WKUSER | CHAR (10) | Null | User ID. |
| WKPID | CHAR (10) | Null | Program ID. |
| WKJOBN | CHAR (10) | Null | Workstation ID. |
| WKUPMJ | NUMBER (6) | Null | Date - Updated. |
| WKUPMT | NUMBER (6) | Null | Time - Updated. |