ERP Internals/Data Tables/Job Transaction

This table contains one record for every Job transaction.

Used by: Job Costing

Key: Transaction Number

Fields:

  • Transaction Number (a unique number assigned by the ERP package)
  • Job Number
  • Item Number
  • Buy/Pick
  • Date
  • Type (Labor/Materials/Subcontract)
  • Hours
  • Quantity
  • Amount
  • Currency
  • Posted to General Ledger Date/Time