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