Import Job Cost Transactions

From GivenHansco Keystone Help
(Redirected from Import Job Cost Tranactions)
Jump to navigation Jump to search

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.