Field Listing for Table JOBTIMESHEETS
Field: | TIMESHEETBATCHNO | Type: | INTEGER |
Field: | TIMESHEETSTATUS | Type: | VARCHAR Length: 20 |
Field: | TIMESHEETREFERENCE | Type: | VARCHAR Length: 50 |
Field: | ENTRYSTYLE | Type: | VARCHAR Length: 10 |
Field: | ENTRYSELECTION | Type: | VARCHAR Length: 30 |
Field: | USETIMEOFTHEDAY | Type: | BOOLEAN |
Field: | TIMESHEETDATE | Type: | DATE |
Field: | APPROVALSTATUS | Type: | VARCHAR Length: 20 |
Field: | APPROVALDATE | Type: | DATE |
Field: | APPROVALUSERNAME | Type: | VARCHAR Length: 30 |
Field: | TIMESHEETNOTES | Type: | BLOB |
Field: | TIMESHEETBATCHDATE | Type: | DATE |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |