AqQte Aqqtet AqInvEst AQPartLog AQMatLst aqnotes ----------------- ------------------- ------------ ----------------- -------------------------------------------------------- ----------- Ovd Qtet EstInv PartLog FullMatList MatList PMRate AqNotes ----------------- ------------------- ------------ ----------------- -------------------- ---------------- ---------------- ----------- One row per One row per quoted One row per One row per parts One row per material Often (pehaps Often (perhaps One row per quote. item. invoice. order. item. always) no rows. always) no rows. note. ----------------- ------------------- ------------ ----------------- -------------------- ---------------- ---------------- ----------- Est_no Est_no Est_no Est_No Desp Est_no Insurance Est_no Est_date Supp_no InvoiceOrder OrderNo MatRate Supp_no S1 aDate Job_status Tax_code DebtCode CompanyCode Mat_hr Desp S2 aNotes Job_no Desp DebtName CompanyName Mat_amt MatRate M1 LnSeq No_supps Part_no InvoiceDate OrderDate Mat_ln Mat_hr M2 Est_status Part_list InvoiceNo OrdType Mat_remarks Mat_amt M3 Est_status2 RR_hr Comment TransType LsSeq Mat_cc_ln M4 Owner RI_hr IDesp1 OrdQty Mat_remarks LnSeq Title RA_hr IAmt1 InvTot Mat_type Mat_ln First_name REF_hr IGSTAmt1 sInvNum LnSeq WeldCon Last_name UF_hr IDesp2 M5 Address1 MEC_hr IAmt2 M6 Address2 DC_hr IGSTAmt2 PreRef Town MISC_hr IDesp3 PanCon State SUBLET_amt IAmt3 RefCon Post_code US_inv_pr IGSTAmt3 Phone_h Part_trade IDesp4 Phone_w Part_tax_pc IAmt4 Fax Disc_pc IGSTAmt4 Mobile Part_Qty IDesp5 Debtor Remarks IAmt5 Dot1 Adj_part_amt IGSTAmt5 Vehicle Adj_RR_hr IDes6 Year Adj_RI_hr IGSTAmt6 Model Adj_RA_hr IAmt6 Transmission Adj_REF_hr IDesp7 Rego Adj_UF_hr IAmt7 Badge Adj_MEC_hr IGSTAmt7 Dot2 Adj_DC_hr IDesp8 Mileage Adj_MISC_hr IAmt8 Mod_no Adj_SUBLET_amt IGSTAmt8 Vin Ln_no IDesp9 Color Part_ord_status IAmt9 Color1_code Part_ord_date IGSTAmt9 Col1_Desp Part_ord_cred IDesp10 Col1_Rate Part_rec_qty IAmt10 LoanCarOut RR_amt IGSTAmt10 LoanCarDesp RI_amt IDesp11 LoanCarBack RA_amt IAmt11 Loan_car REF_amt IGSTAmt11 Loan_days UF_amt IDesp12 Loan_amt MEC_amt IAmt12 Own_instr DC_amt IGSTAmt12 Remarks MISC_amt IDesp13 Est_by Adj_RR_amt IAmt13 Source Adj_RI_amt IGSTAmt13 Rate_code Adj_RA_amt IDesp14 Hrs_code Adj_REF_amt IAmt14 Model_code Adj_UF_amt IGSTAmt14 Labor_code Adj_MEC_amt IDesp15 Met_wkr Adj_DC_amt IAmt15 Ref_wkr Adj_MISC_amt IGSTAmt15 Uf_wkr Part_cc TransTypeID Mec_wkr RR_cc GstPc Dc_wkr RI_cc GstTotal Met_tar RA_cc InvoiceTotal Ref_tar REF_cc InvoiceType Uf_tar UF_cc Mec_tar MEC_cc (If InvoiceOrder=4, InvoiceDate is excess invoice date) Dc_tar DC_cc (If InvoiceOrder=3, InvoiceDate is supplemental invoice date) Met_act MISC_cc (If InvoiceOrder=1, InvoiceDate is debtor invoice date) Ref_act SUBLET_cc Uf_act Part_ass (In the databases tested, InvoiceOrder value was always one of {1, 3, 4}.) Mec_act RR_ass Dc_act RI_ass Met_rem RA_ass Ref_rem REF_ass Uf_rem UF_ass Mec_rem MEC_ass Dc_rem DC_ass Date_in MISC_ass Time_in SUBLET_ass Date_out Part_cc_ln Time_out RR_cc_ln Days_delay RI_cc_ln Date_notes RA_cc_ln Num_notes REF_cc_ln Inv_deb_no UF_cc_ln Inv_deb_date MEC_cc_ln Inv_deb_amt DC_cc_ln Inv_deb_pay MISC_cc_ln Inv_deb_days SUBLET_cc_ln Inv_ex_no Part_remarks Inv_ex_date RR_remarks Inv_ex_amt RI_remarks Inv_ex_pay RA_remarks Inv_ex_days REF_remarks Inv_3_no UF_remarks Inv_3_date MEC_remarks Inv_3_amt DC_remarks Inv_3_pay MISC_remarks Inv_3_days SUBLET_remarks Part_ord_no RefRates Part_ord_date part_unit_list Part_sup LnSeq Part_to_come UniqueNo Part_to_come_date Part_return_no Part_return_date Policy_no Sum_ins Claim_no Tow_fee Est_amt Est_book Est_ass_date Est_ass_fg Est_assessor Est_adj_by Est_part_ord_by Sup1_amt Sup1_book Sup1_ass_date Sup1_ass_fg Sup1_assessor Sup1_adj_by Sup1_part_ord_by Sup2_amt Sup2_book Sup2_ass_date Sup2_ass_fg Sup2_assessor Sup2_adj_by Sup2_part_ord_by Own_amt Own_book Own_ass_date Own_ass_fg Own_assessor Own_adj_by Own_part_ord_by Est_total Excess Owner_cont WAMarkUp dVar1 dVar2 dVar3 dVar4 tVar2 dateVar1 dateVar2 Inv1PayDate InvExPayDate Inv9PayDate