     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