In this version, the only format available is "Enterprise One." This is the table name used by JD Edwards.

This table contains the batch IDs that were used to export timesheets. It contains all batch IDs in the EXPORT_LABOR table. They are displayed in alphabetical order. To select a row, select the checkbox to the left of that row. To unselect a row, uncheck the checkbox to the left of the row. To select all of the rows, select the checkbox in the upper left corner. This will automatically select the checkboxes in all of the rows.

Select the Execute pushbutton to transfer the selected timesheet records.

Select the Close pushbutton to close the screen and return to your designated default screen as set up in your preferences.

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.

# Timesheet Transfer

Use this utility to transfer exported timesheet records to a selected table. Currently the only option available is for JD Edwards and is called "Enterprise One." You can select the records you want to transfer by batch ID. Once the records have been processed, the system deletes them from the table, based on selected Batch ID.

## When do I use the Transfer Timesheets screen?

Use this screen to transfer exported labor records to a table of your choice.

## The Timesheet Transfer screen

The Timesheet Transfer screen is a process application. This application assumes that you do NOT have a value for the LABOR=parameter in the exporttimesheets.properties file. If you do, the EXPORT_LABOR file will be cleared and there will be nothing to transfer. If no records exist in the EXPORT_LABOR table when the screen is first loaded, the system will display the following message: "No exported timesheets found for transfer."

Format

Batch ID

Execute

Close

Data mapping