Time & Material Invoices - Data Tables

User Table:  TMINVOICETRANS

•This table is used to hold the various transactions that will be included in the T&M invoice.

oJOB COST RECORDS - CostRecordType = 1  (Cost Record comes from JOBDETL where trans_type = 14 and source not in (17,18,19) and isnull(inv_ref_no,0) = 0

oPAYROLL TIME CARD RECORDS - CostRecordType = 2   (Cost Record comes from TIMECARD table)

oPURCHASE JOURNAL RECORDS - CostRecordType = 3   (Cost Record comes from PURCHJNL table)

oPRODUCTION UNIT RECORDS - CostRecordType = 4     (Cost Record comes from JOBDETL table (Source 15))