|
Field Name |
Description |
Length |
Example |
|
COM_CODE |
This is the existing code of your company. The Company Code is set in Systems Maintenance. This is a 3 character alphanumeric code. Must be valid COM_CODE from SYSCOM table This is a mandatory field. |
3 Alpha Numeric |
100 |
|
JOB_CODE |
This is the Job Code. This is a 12 character alphanumeric code. Must be valid JOB_CODE from GJCJOB_HDR table, for the selected COM_CODE. This is a mandatory field. |
12 Alpha-numeric |
123456 |
|
REFERENCE |
Set this timesheet reference number Leave Blank |
40 Alpha -Numeric |
“” |
|
SUB_JOB_CODE
|
This is the Sub Job Code. This is a 3 character alphanumeric code. Must be valid COM_CODE, JOB_CODE, SUB_JOB_CODE from GJCSUB_JOB table, for the selected COM_CODE and JOB_CODE. |
3 Alpha -Numeric |
“A1” |
|
CLASS_CODE |
This is the Cost Centre. This is a 8 character alphanumeric code. Must be valid CLASS_CODE, from GJCCLASS table, for the selected COM_CODE. This is a mandatory field. |
8 Alpha -Numeric
|
‘LABOUR’ |
|
TRANS_TYPE |
This is the Timesheet transaction type Leave Blank |
Char 3 |
“” |
|
START_TIME |
START time in HH:MM corresponding to the Hours worked. If Start and End times are not applicable then the HOURS_WORKED field can be used only |
Timestamp |
14:20 |
|
END_TIME |
END time in HH:MM corresponding to the Hours worked. If Start and End times are not applicable then the HOURS_WORKED field can be used only. Must be > START_TIME |
Timestamp |
15:45 |
|
DESCRIPTION |
This is the timesheet detail line description. This is required to explain what the line item on the timesheet is for. It Is envisaged that the description is to be used as the reference relating to the type of time recorded by the Engineer |
Char 100 |
“Additional Cleaning of first level” |
|
CHARGE_RATE |
Hourly rate of Charge applicable. |
8 Float Numeric |
10.45 |
|
CHARGED_VALUE |
Total Charge applicable to Job. This value will usually be the CHARGE_RATE * HOURS_WORKED, but can be differing value |
8 Float Numeric |
145.77 |
|
CHARGEABLE |
Indicates whether timesheet transaction is chargeable to the job. ‘C’ = chargeable, N= Not chargeable. This is a 1 character alphanumeric field This is a mandatory field. |
1 Alpha numeric |
‘C’ |
|
PERIOD_NO |
Period number corresponding to the entry date in the format YYYYMM. YYYY = year and MM = months 01-12 This is a mandatory field. |
6 Numeric |
200710 |
|
HOURS_WORKED |
Number of Hours, in decimals for the timesheet transaction. For example 1hr 15 minutes would be represented as 1.25 hrs This is a FLOAT field of 8 characters. This is a mandatory field. |
8 Float numeric |
1.25 |
|
UNITS |
This is the number of ‘work’ units as per the unit size that equates to the HOURS_WORKED Equates to 1.25 hours of ‘15’ minute work units (Unit size) May be left blank |
8 Float |
“5” |
|
HOURLY_COST |
Hourly rate of COST applicable. |
8 Float Numeric |
10 |
|
COST_VALUE |
Total COST applicable to Job. This value will usually be the HOURLY_COST * HOURS_WORKED, but can be differing value. |
8 Float Numeric |
100 |
|
PAY_WORK_ID |
This is the Work type for the selected Engineer if Engineer is linked to Employee in payroll. This is a 3 character numeric code. Must be PAY_WORK_ID from the PYPAY_WORK_TYPE table for the selected COM_CODE. This is a mandatory field if the ENGINEER_CODE is NOT blank |
3 Alpha Numeric |
‘OT’ |
|
FACTOR |
This is the ‘factor’ to be applied to the cost calculation. Usually set to 1. Leave blank |
8 Float |
“” |
|
ENTRY_DATE |
Transaction entry date in format dd-mmm-yyyy This is a mandatory field. |
Date |
1-Oct-2007 |
|
ENGINEER_CODE |
This is the Engineer Code. This is a 6 character alphanumeric code. Must be valid ENGINEER_CODE, from GJCENGINEER table, for the selected COM_CODE. This is a mandatory field. |
6 Alpha Numeric |
‘BSMITH’ |
|
EMPLOYEE_ID |
This is the Employee Code for the selected Engineer if Engineer is linked to Employee in payroll. This is a 3 character numeric code. Must be EMPLOYEE_ID from the GJCENGINEER table for the selected COM_CODE and ENGINEER_CODE. |
3 Numeric |
123 |
|
PAY_RATE_ID |
This is the Pay Rate for the selected Engineer if Engineer is linked to Employee in payroll. This is a 3 character numeric code. Must be PAY_RATE_ID from the PYPAY_PAY_RATE table for the selected COM_CODE. This is a mandatory field if EMPLOYEE_ID is not null |
3 Numeric |
‘PM’ |
|
UNIT_SIZE |
This is the Unit size value for selected Engineer. This is a 3 character numeric code. Must be EMPLOYEE_ID from the GJCENGINEER table for the selected COM_CODE and ENGINEER_CODE. |
3 Numeric |
15 |
|
ALLOWANCE_ID |
This is a Payroll Allowance for the selected Engineer if Engineer is linked to Employee in payroll. This is a 10 character numeric code. Must be ALLOWANCE_ID from the PYALLOWANCE table for the selected COM_CODE. This is NOT mandatory field |
10 Alpha Numeric |
‘MEAL’ |
|
TOTAL |
This is total amount for the ALLOWANCE. This is NOT mandatory field. |
10 Float Numeric |
’52.50’ |