Standard Job Cost Export Interface Layout

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",""

 

Be the first to review this article