JC_Job                           J/C Job Master File                  Rel: 4.40  Bld: 398  8/28/2009
 Bus Obj: N/A
 SQL Def: N  SysDB: N                                                "MAS_"+%C$+"/JC"+%C$+"/JC_Job.M4T"

 KPRIMARY: JobNo
 KDESCRIPTION: JobDesc+JobNo
 KESTIMATOR: Estimator+JobNo
 KMANAGER: Manager+JobNo
 KCUSTOMER: ARDivisionNo+CustomerNo+JobNo
 KTYPE: JobType+JobNo
 KSORT: SortField+JobNo

 Fld  Column Name                     M/L TUR  Description/Notes              Class

   1  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                FmtType:CHARNUM
   2  JobDesc . . . . . . . . . . .    30 SNN  Job Description . . . . . . . .DESCRIPTION
   3  ARDivisionNo. . . . . . . . .     2 SYN  A/R Division Number . . . . . .ARDIVISION
                                                Mask:00
   4  CustomerNo. . . . . . . . . .    20 SNN  Customer Number . . . . . . . .CUSTOMERNO
                                                FmtType:MASTERNUMC ChngTag:Re
                                                place1/ARDivisionNo$
   5  Address1. . . . . . . . . . .    30 SNN  Address Line 1. . . . . . . . .ADDRESSLINE
   6  Address2. . . . . . . . . . .    30 SNN  Address Line 2. . . . . . . . .ADDRESSLINE
   7  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .COMMENT30
   8  ContactName . . . . . . . . .    30 SNN  Contact Name. . . . . . . . . .
   9  TelephoneNo . . . . . . . . .    17 SNN  Telephone No. . . . . . . . . .TELEPHONENO
  10  TelephoneExt. . . . . . . . .     5 SNN  Telephone Ext . . . . . . . . .TELEPHONEEXT
  11  Estimator . . . . . . . . . .    10 SYN  Estimator . . . . . . . . . . .
  12  Manager . . . . . . . . . . .    10 SYN  Manager . . . . . . . . . . . .
  13  ContractNumber. . . . . . . .    15 SNN  Contract Number . . . . . . . .
  14  ContractDate. . . . . . . . .     8 SNN  Contract Date . . . . . . . . .DATE
  15  JobType . . . . . . . . . . .     3 SYN  Job Type. . . . . . . . . . . .
  16  AccountingMethod. . . . . . .     1 SYN  Accnt Method (Percent Completio
                                                Notes: Completed Contract
  17  BillingMethod . . . . . . . .     1 SYN  Bill Meth (None, Fixed, Time &
                                                Valid:N,F,T
  18  JobStatus . . . . . . . . . .     1 SYN  Job Stat (Bid,Cmplt,Hld,Late,Op
                                                Valid:B,C,H,L,O,X
  19  StatusDate. . . . . . . . . .     8 SNN  Status Date . . . . . . . . . .DATE
  20  EstimatedStartDate. . . . . .     8 SNN  Estimated Start Date. . . . . .DATE
  21  EstimatedCompDate . . . . . .     8 SNN  Estimated Completion Date . . .DATE
  22  ActualStartDate . . . . . . .     8 SNN  Actual Start Date . . . . . . .DATE
  23  RetainJTDTransDetail. . . . .     1 SYN  Retain Jtd Cost Detail. . . . .YESNO
                                                DfltVal:N Valid:Y,N
  24  UnitOfMeasureDesc . . . . . .    10 SNN  Unit Of Measure Description . .
  25  DateReported. . . . . . . . .     8 SNN  Date Reported . . . . . . . . .DATE
  26  LastCostTransDate . . . . . .     8 SNN  Last Cost Transaction Date. . .DATE
  27  LastBillDate. . . . . . . . .     8 SNN  Last Bill Date. . . . . . . . .DATE
  28  LastPaymentDate . . . . . . .     8 SNN  Last Payment Date . . . . . . .DATE
  29  SortField . . . . . . . . . .    10 SYN  Sort Field. . . . . . . . . . .
  30  CalculateSalesTax . . . . . .     1 SYN  Calculate Sales Tax . . . . . .YESNO
                                                DfltVal:N Valid:Y,N Notes:
                                                In Billing Selection And
                                                Entry
  31  FutureSalesTax. . . . . . . .    12 SNN  Sales Tax - Next Period . . . .
                                                Mask:########.00- Notes: 
  32  JTDSalesTax . . . . . . . . . 12.2  NNN  Sales Tax Job To Date . . . . .
                                                Mask:#######0.00
  33  RetentionPercent. . . . . . .  7.2  NNN  Retention Percent . . . . . . .
                                                Mask:##0.00
  34  TotalJobUnits . . . . . . . . 10.0  NNN  Total Job Units . . . . . . . .
                                                Mask:#######0
  35  OriginalEstimate. . . . . . . 12.2  NNN  Original Estimate . . . . . . .
                                                Mask:#######0.00
  36  RevisedEstimate . . . . . . . 12.2  NNN  Revised Estimate. . . . . . . .
                                                Mask:#######0.00
  37  OriginalContract. . . . . . . 12.2  NNN  Original Contract . . . . . . .
                                                Mask:#######0.00
  38  RevisedContract . . . . . . . 12.2  NNN  Revised Contract. . . . . . . .
                                                Mask:#######0.00
  39  ActualPercentComplete . . . .  7.2  NNN  Actual Percent Complete . . . .
                                                Mask:##0.00
  40  PTDActualCosts. . . . . . . . 12.2  NNN  Actual Costs Period To Date . .
                                                Mask:#######0.00
  41  YTDActualCosts. . . . . . . . 12.2  NNN  Actual Costs Year To Date . . .
                                                Mask:#######0.00
  42  JTDActualCosts. . . . . . . . 12.2  NNN  Actual Costs Job  To Date . . .
                                                Mask:#######0.00
  43  PTDInvoiceBilled. . . . . . . 12.2  NNN  Invoice Billed Period To Date .
                                                Mask:#######0.00
  44  YTDInvoiceBilled. . . . . . . 12.2  NNN  Invoice Billed Year To Date . .
                                                Mask:#######0.00
  45  JTDInvoiceBilled. . . . . . . 12.2  NNN  Invoice Billed Job  To Date . .
                                                Mask:#######0.00
  46  PTDPaymentReceived. . . . . . 12.2  NNN  Payment Received Period To Date
                                                Mask:#######0.00
  47  YTDPaymentReceived. . . . . . 12.2  NNN  Payment Received Year To Date .
                                                Mask:#######0.00
  48  JTDPaymentReceived. . . . . . 12.2  NNN  Payment Received Job To Date. .
                                                Mask:#######0.00
  49  RetentionBalance. . . . . . . 12.2  NNN  Retention Balance . . . . . . .
                                                Mask:#######0.00
  50  DeferredRevenue . . . . . . . 12.2  NNN  Deferred Revenue (Accntg Methd
                                                Mask:#######0.00
  51  UnbilledCost. . . . . . . . . 12.2  NNN  Unbilled Cost . . . . . . . . .
                                                Mask:#######0.00
  52  FutureActualCosts . . . . . . 12.2  NNN  Actual Costs Next Period. . . .
                                                Mask:#######0.00
  53  FutureInvoiceBilled . . . . . 12.2  NNN  Invoice Billed Next Period. . .
                                                Mask:#######0.00
  54  FuturePaymentReceived . . . . 12.2  NNN  Payment Received Next Period. .
                                                Mask:#######0.00
  55  DateCreated . . . . . . . . .     8 SNY  Date Created. . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  56  TimeCreated . . . . . . . . .     8 SNY  Time Created. . . . . . . . . .
                                                Read Only:Y
  57  UserCreatedKey. . . . . . . .    10 SYY  User Created Key. . . . . . . .USER
                                                Read Only:Y Mask:0000000000
  58  DateUpdated . . . . . . . . .     8 SNN  Date Updated. . . . . . . . . .DATE
                                                Read Only:Y Notes: YYYYMMDD
  59  TimeUpdated . . . . . . . . .     8 SNN  Time Updated. . . . . . . . . .
                                                Read Only:Y
  60  UserUpdatedKey. . . . . . . .    10 SNN  User Updated Key. . . . . . . .USER
                                                Read Only:Y Mask:0000000000