The Standard Job Cost Export Interface layout is comma-delimited text file that is available in detailed format and has two types of transactions: a header line, and detail line(s).
When exporting the user has to define two parameters:
Parameters:
- Batch Date – The Summary date the transactions should be posted against
- Memo – User typed text field, maximum of 50 characters
Employee Identification – Drop down list if the employee information should be included for each line item. Options are:
- Blank
- Employee Number
- Employee Number + Surname + First Name
- Employee Number + First Name + Surname
Layout:
The Header line is comma-delimited like the details and list the column names as listed on the left of the below grid.
Column Name | Description |
Employee_Identification | As defined by user selection |
Work_Date | Date of the job/labor entry |
Category_Number | The Payroll Category Code the job was assigned too |
Category_Name | The Payroll category name the job was assigned too |
Job_Centre_Code | The Job Centre/Project code |
Job_Center_Name | The Job Centre/Project name |
Cost_Center_Code | The Cost Centre/Task code |
Cost_Center_Name | The Cost centre/Task code |
Unit | The number of units (normally hours) worked |
Rate | The Payroll rate of pay |
Amount | The $ value |
Department_Number | The Department Number |
Debit_GL_Account | Applicable GL Account |
Comment | Comment/description of the labour entry |
Batch_Date | As Entered by user |
Check_Number | The Check number this record was assigned too. |
Memo | As entered by user |
Sample file:
EMPLOYEE_IDENTIFICATION,WORK_DATE,CATEGORY_NUMBER,CATEGORY_NAME,JOB_CENTRE_CODE,JOB_CENTRE_NAME,COST_CENTRE_CODE,COST_CENTRE_NAME,UNIT,RATE,AMOUNT,DEPARTMENT_NUMBER,DEBIT_GL_ACCOUNT,COMMENT,BATCH_DATE,CHECK_NUMBER,MEMO
"004","20190215","102","Hourly wages","001","Main","001","Main",2.0000,20.0000,40.00,"","","","20190819",""
"004","20190215","101","Salary","001","Main","001","Main",0.0000,0.0000,4000.00,"","","","20190819",""