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