JC_JobBillingHeader J/C Job Billing Entry Header Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/JC"+%C$+"/JC_JobBillingHeader.M4T"
KPRIMARY: JobNo
Fld Column Name M/L TUR Description/Notes Class
1 JobNo . . . . . . . . . . . . 7 SYY Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM 2 InvoiceNo . . . . . . . . . . 7 SYY Invoice Number. . . . . . . . .INVOICE FmtType:MASTERNUM 3 InvoiceType . . . . . . . . . 2 SYY Invoice Type. . . . . . . . . . Valid:CA,CM,DM,FC,IN,PP,PY, BA,BC,BF 4 InvoiceDate . . . . . . . . . 8 SYY Date. . . . . . . . . . . . . .DATE 5 SalespersonNo . . . . . . . . 4 SYN Salesperson Number. . . . . . .SALESPERSONNO 6 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30 7 PrintInvoice. . . . . . . . . 1 SYN Print Invoice Yes/No. . . . . .YESNO DfltVal:N Valid:Y,N 8 BillMethod. . . . . . . . . . 1 SYN Bill Method (Fix, Time & Materi Valid:F,T 9 ARDivisionNo. . . . . . . . . 2 SYN A/R Division Number . . . . . .ARDIVISION Mask:00 10 CustomerNo. . . . . . . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO FmtType:MASTERNUMC ChngTag:Re place1/ARDivisionNo$ 11 HasInvoiceBeenPrinted . . . . 1 SYN Has Invoice Been Printed Yes/NoYESNO DfltVal:N Valid:Y,N 12 JobBillingDate. . . . . . . . 8 SYN Job Billing Date. . . . . . . .DATE 13 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE 14 TermsCode . . . . . . . . . . 2 SNN A/R Terms Code. . . . . . . . .ARTERMS 15 ApplyToInvoiceNo. . . . . . . 7 SYN Apply To Invoice Number . . . .INVOICE FmtType:MASTERNUM 16 Adjustment. . . . . . . . . . 1 SYN Adjustment Yes/No . . . . . . .YESNO DfltVal:N Valid:Y,N 17 InvoiceDueDate. . . . . . . . 8 SYN Invoice Due Date. . . . . . . .DATE 18 DiscountDueDate . . . . . . . 8 SYN Discount Due Date . . . . . . .DATE 19 InvalidTaxCalc. . . . . . . . 1 SYN Invalid Tax Calculation Yes/No.YESNO DfltVal:N Valid:Y,N 20 CommissionRate. . . . . . . . 9.3 NNN Commission Rate . . . . . . . .COMMISSIONRATE Mask:###0.000 21 ActualPercentComplete . . . . 10.2 NNN Actual Percent Complete . . . .PERCENTAGE Mask:###,###.00- 22 RetentionRate . . . . . . . . 10.2 NNN Rentention Rate . . . . . . . .PERCENTAGE Mask:###,###.00- 23 AmountBillable. . . . . . . . 13.2 NNN Amount Billable . . . . . . . .AMOUNT Mask:###,###,###.00 24 RetentionAmt. . . . . . . . . 13.2 NNN Retention Amount. . . . . . . .AMOUNT Mask:###,###,###.00 25 AmountSubjectToComm . . . . . 13.2 NNN Amount Subject To Commission. .AMOUNT Mask:###,###,###.00 26 CommissionAmt . . . . . . . . 13.2 NNN Commission Amount . . . . . . .AMOUNT Mask:###,###,###.00 27 RevisedEstimate . . . . . . . 13.2 NNN Revised Estimate. . . . . . . .AMOUNT Mask:###,###,###.00 28 RevisedContract . . . . . . . 13.2 NNN Revised Contract. . . . . . . .AMOUNT Mask:###,###,###.00 29 JTDCost . . . . . . . . . . . 13.2 NNN Job-To-Date Cost . . . . . . .AMOUNT Mask:###,###,###.00 30 JTDInvoiceBilledAmt . . . . . 13.2 NNN JTD Invoice Billed Amount . . .AMOUNT Mask:###,###,###.00 31 OriginalContractAmt . . . . . 13.2 NNN Original Contract Amount. . . .AMOUNT Mask:###,###,###.00 32 TaxableAmt. . . . . . . . . . 13.2 NNN Taxable Amount. . . . . . . . .AMOUNT Mask:###,###,###.00 33 NonTaxableAmt . . . . . . . . 13.2 NNN Non-Taxable Amount. . . . . . .AMOUNT Mask:###,###,###.00 34 SalesTaxAmt . . . . . . . . . 13.2 NNN Sales Tax Amount. . . . . . . .AMOUNT Mask:###,###,###.00 35 PreviousRetentionAmt. . . . . 13.2 NNN Previous Retention Amount . . .AMOUNT Mask:###,###,###.00 36 BillableContract. . . . . . . 13.2 NNN Billable Contract . . . . . . .AMOUNT Mask:###,###,###.00 37 MiscCharges . . . . . . . . . 13.2 NNN Miscellaneous Charges . . . . .AMOUNT Mask:###,###,###.00