JDE_TS_F5606ZW 
Default Table Name  JDE_TS_F5606ZW 
Definition 
 Name: JD Edwards Exported Table.     Description: This table contains exported timesheet records that have been “transferred” from the EXPORT_LABOR table for Enterprise One. (JD Edwards).
 

JDE_TS_F5606ZW Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
WKC5606EMP(PK)    CHAR(20)  NO 
Name:  Employee ID. Description: The unique identifier of the employee.
 
WKC5606TS(PK)    CHAR(10)  NO 
Name:  Timesheet Schedle. Description: Timesheet frequency identifier.
 
WKC5606FYR(PK)    CHAR(4)  NO 
Name:  Timesheet Year. Description: The timesheet frequency’s year code.
 
WKC5606PER(PK)    CHAR(3)  NO 
Name:  Timesheet Period. Description: Period number for timesheet frequency.
 
WKEDLN(PK)    REAL/SMALLFLOAT  NO 
Name:  Timeheet Line Number. Description: The timesheet line number to which the timesheet cell record belongs.
 
WKC5606CDT(PK)    CHAR(10)  NO 
Name:  Hours Date. Description: The column (cell) date for this row.
 
WKC5606SDT    CHAR(10)  YES 
Name:  Period Start Date. Description: Start date of the period.
 
WKC5606EDT    CHAR(10)  YES 
Name:  Period End Date. Description: End date of the period.
 
WKEDBT    CHAR(15)  YES 
Name:  Batch ID. Description: Batch Number.
 
WKC5606TSD    CHAR(10)  YES 
Name:  Timesheet Date. Description: The date associated with the timesheet.
 
WKC5606SID    CHAR(10)  YES 
Name:  Site ID. Description: The site ID that the timesheet and employee are from.
 
WKC5606CCD    CHAR(10)  YES 
Name:  Timesheet Class. Description: The current class that the employee belongs to.
 
WKC5606OTH    CHAR(20)  YES 
Name:  Overtime Hours. Description: The number of overtime hours.
 
WKC5606LDS    CHAR(120)  YES 
Name: Charge Description. Description: Description of the charge on the line. (Line Description)
 
WKC5606GRP    CHAR(20)  YES 
Name: Employee Group. Description: Group Code.
 
WKC5606CHG    CHAR(45)  YES 
Name: Charge Tree. Description: Charge number for the timesheet line.
 
WKC5606CAI    CHAR(20)  YES 
Name: Charge Abbreviation. Description: Charge abbreviation code.
 
WKC5606UTL    CHAR(10)  YES 
Name: . Description: Utilization Code.
 
WKC5606T01    CHAR(30)  YES 
Name: UDT01 ID. Description: The UDT01 identifier for the timesheet line. (Proj/Task or Work Order)
 
WKC5606T02    CHAR(30)  YES 
Name: UDT02 ID. Description: The UDT02 identifier for the timesheet line.
 
WKC5606T03    CHAR(20)  YES 
Name: UDT03 ID. Description: The UDT03 identifier for the timesheet line.
 
WKC5606T04    CHAR(20)  YES 
Name: UDT04 ID. Description: The UDT04 identifier for the timesheet line.
 
WKC5606T05    CHAR(20)  YES 
Name: UDT05 ID. Description: The UDT05 identifier for the timesheet line.
 
WKC5606T06    CHAR(20)  YES 
Name: UDT06 ID. Description: The UDT06 identifier for the timesheet line. (Job Step)
 
WKC5606T07    CHAR(20)  YES 
Name: UDT07 ID. Description: The UDT07 identifier for the timesheet line. (Job Type)
 
WKC5606T08    CHAR(20)  YES 
Name: UDT08 ID. Description: The UDT08 identifier for the timesheet line.
 
WKC5606T09    CHAR(20)  YES 
Name: UDT09 ID. Description: The UDT09 identifier for the timesheet line.
 
WKC5606T10    CHAR(20)  YES 
Name: UDT10 ID. Description: The UDT10 identifier for the timesheet line. (Pay Type)
 
WKC5606TST    CHAR(254)  YES 
Name: Timesheet Comment. Description: Timesheet Text.
 
WKC5606LBR    CHAR(20)  YES 
Name: User Defined Rate 1. Description: The labor rate.
 
WKC5606LAM    CHAR(20)  YES 
Name: User Defined Rate 1 Amount. Description: The labor amount.
 
WKC5606BRT    CHAR(20)  YES 
Name: User Defined Rate 2 . Description: The billing rate.
 
WKC5606BAM    CHAR(20)  YES 
Name: User Defined Rate 2 Amount. Description:  The billing amount.
 
WKC5606HRS    CHAR(20)  YES 
Name: Hours. Description: The entered labor hours for this cell.
 
WKC5606CRF    CHAR(1)  YES 
Name: Correcting Flag. Description: Logical as to whether this cell is a correcting entry.
 
WKC5606CTX    CHAR(254)  YES 
Name: Timesheet Cell Comment. Description: User-provided notes about the timesheet cell.
 
WKC5606LTX    CHAR(254)  YES 
Name: Timesheet Line Comment. Description: User-provided notes about the timesheet line.
 
WKC5606STS    CHAR(1)  YES 
Name: Timesheet Cell Status. Description: Status of the cell.
 
WKEDSP    CHAR(1)  YES 
Name: Record Pickup Flag. Description: (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)  YES 
Name: Error Text. Description: Error Text.
 
WKC5606ETK    CHAR(50)  YES 
Name: Record Key. Description: ET Key ID
 
WKUSER    CHAR(10)  YES 
Name: User ID. Description: User ID
 
WKPID    CHAR(10)  YES 
Name: Program ID. Description: Program ID
 
WKJOBN    CHAR(10)  YES 
Name: Workstation ID. Description: Workstation ID
 
WKUPMJ    NUMERIC(6, 0)  YES 
Name: Update Date. Description: Date - Updated
 
WKUPMT    NUMERIC(6, 0)  YES 
Name: Update Time. Description: Time - Updated
 
WKC5606T11    CHAR(30)  YES 
Name: UDT11 ID. Description: The UDT11 identifier for the timesheet line. 
 
WKC5606T12    CHAR(30)  YES 
Name: UDT12 ID. Description: The UDT12 identifier for the timesheet line. 
 
WKC5606T13    CHAR(30)  YES 
Name: UDT13 ID. Description: The UDT13 identifier for the timesheet line. 
 
WKC5606T14    CHAR(30)  YES 
Name: UDT14 ID. Description: The UDT14 identifier for the timesheet line. 
 
WKC5606T15    CHAR(30)  YES 
Name: UDT15 ID. Description: The UDT15 identifier for the timesheet line. 
 

JDE_TS_F5606ZW Keys 
Key Name  Key Type  Keys 
SI_0055  Inversion Entry  WKC5606EMP, WKC5606T01, WKC5606T10, WKC5606CRF, WKC5606TSD, WKC5606T07 
SI_0054  Inversion Entry  WKC5606CRF, WKEDSP 
SI_0053  Inversion Entry  WKC5606EMP, WKC5606T01, WKC5606T10 
PI_O233  PrimaryKey  WKC5606EMP, WKC5606TS, WKC5606FYR, WKC5606PER, WKEDLN, WKC5606CDT 

JDE_TS_F5606ZW Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype