Import Job Cost Transactions

This option imports Job Cost transactions into the Job Cost Transaction table. The input file must be in comma delimitted (.csv) format.

Sequence of Fields

• JOB_ID
• BUDCAT_ID
• TRX_TYPE
• ASSET_ID
• TRX_DATE
• TRX_QTY
• TRX_AMOUNT
• UNIT_OF_MEASURE
• DESCRIPTION

Sample File

JOB_ID,BUDCAT_ID,TRX_TYPE,ASSET_ID,TRX_DATE,TRX_QTY,TRX_AMOUNT,UNIT_OF_MEASURE,DESCRIPTION
19495,600,REG,1000,1/13/2010,18,288,HR,REG
19495,2900,REG,1000,1/13/2010,22,352,HR,REG
LB1986,MAINT,REG,1001,1/13/2010,25,312.5,HR,REG
LB1986,MAINT,REG,1002,1/13/2010,33,495,HR,REG
19495,600,REG,1000,1/20/2010,18,288,HR,REG
19495,2900,REG,1000,1/20/2010,22,352,HR,REG

See Also

Import_G/L_Transactions The G/L import program can import Job Cost entries along with G/L entries.