     JC1_JobMaster                        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$+"/JC1"+%C$+".soa"

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  JobNumber . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .
                                                    FmtType:CHARNUM
       2  JobDescription. . . . . . . .    30 SNN  Description . . . . . . . . . .
       3  _S3 . . . . . . . . . . . . .     9 SNN  Open String . . . . . . . . . .
       4  Address1. . . . . . . . . . .    30 SNN  Address 1 . . . . . . . . . . .
       5  Address2. . . . . . . . . . .    30 SNN  Address 2 . . . . . . . . . . .
       6  Comment . . . . . . . . . . .    30 SNN  Comment . . . . . . . . . . . .
       7  ContactName . . . . . . . . .    30 SNN  Contact . . . . . . . . . . . .
       8  PhoneNo . . . . . . . . . . .    10 SNN  Phone Number. . . . . . . . . .Phone
       9  Extension . . . . . . . . . .     5 SNN  Extension . . . . . . . . . . .
      10  Estimator . . . . . . . . . .    10 SYN  Estimator . . . . . . . . . . .
      11  Manager . . . . . . . . . . .    10 SYN  Manager . . . . . . . . . . . .
      12  ContractNumber. . . . . . . .    15 SNN  Contract Number . . . . . . . .
      13  ContractDate. . . . . . . . .     6 SNN  Contract Date . . . . . . . . .DATE*MAS90
      14  JobType . . . . . . . . . . .     3 SYN  Job Type. . . . . . . . . . . .
      15  AcctMethod. . . . . . . . . .     1 SYN  Accnt Method (Percent Completio
                                                    Notes: Completed Contract)
      16  BillingMethod . . . . . . . .     1 SYN  Bill Meth (None, Fixed, Time &
      17  JobStatus . . . . . . . . . .     1 SYN  Job Stat (Bid,Cmplt,Hld,Late,Op
      18  StatusDate. . . . . . . . . .     6 SNN  Status Date . . . . . . . . . .DATE*MAS90
      19  EstimatedStartDate. . . . . .     6 SNN  Estimated Start Date. . . . . .DATE*MAS90
      20  EstimatedCompDate . . . . . .     6 SNN  Estimated Completion Date . . .DATE*MAS90
      21  ActualStartDate . . . . . . .     6 SNN  Actual Start Date . . . . . . .DATE*MAS90
      22  _S1 . . . . . . . . . . . . .     1 SNN  Open String . . . . . . . . . .
      23  RetainJTDTransDetail. . . . .     1 SYN  Retain Jtd Cost Detail? (Y/N) .YesNo
      24  UnitOfMeasureDesc . . . . . .    10 SNN  Unit Of Measure Description . .
      25  DateReported. . . . . . . . .     6 SNN  Date Reported . . . . . . . . .DATE*MAS90
      26  LastCostTransDate . . . . . .     6 SNN  Last Cost Transaction Date. . .DATE*MAS90
      27  LastBillDate. . . . . . . . .     6 SNN  Last Bill Date. . . . . . . . .DATE*MAS90
      28  LastPaymentDate . . . . . . .     6 SNN  Last Payment Date . . . . . . .DATE*MAS90
      29  SortField . . . . . . . . . .    10 SYN  Sort Field. . . . . . . . . . .
      30  CalcSalesTax. . . . . . . . .     1 SYN  Calculate Sales Tax? (Y/N). . .YesNo
                                                    Notes: In Billing Selection
                                                    And Entry
      31  FutureSalesTax. . . . . . . .    12 SNN  Sales Tax - Next Period . . . .
                                                    Notes: Mask Is ########.00-
      32  DivisionNumber. . . . . . . .     2 SNN  Division Number . . . . . . . .
                                                    Mask:00
      33  CustomerNumber. . . . . . . .    20 SNN  Customer Number . . . . . . . .Accnt
      34  _S2 . . . . . . . . . . . . .    50 SNN  Open String . . . . . . . . . .
      35  JTDSalesTax . . . . . . . . . 12.2  NNN  Sales Tax Job To Date . . . . .
                                                    Mask:#######0.00
      36  RetentionPercent. . . . . . .  7.2  NNN  Retention Percent . . . . . . .
                                                    Mask:##0.00
      37  TotalJobUnits . . . . . . . . 10.0  NNN  Total Job Units . . . . . . . .
                                                    Mask:#######0
      38  OriginalEstimate. . . . . . . 12.2  NNN  Original Estimate . . . . . . .
                                                    Mask:#######0.00
      39  RevisedEstimate . . . . . . . 12.2  NNN  Revised Estimate. . . . . . . .
                                                    Mask:#######0.00
      40  OriginalContract. . . . . . . 12.2  NNN  Original Contract . . . . . . .
                                                    Mask:#######0.00
      41  RevisedContract . . . . . . . 12.2  NNN  Revised Contract. . . . . . . .
                                                    Mask:#######0.00
      42  ActualPercentComplete . . . .  7.2  NNN  Actual Percent Complete . . . .
                                                    Mask:##0.00
      43  PTDActualCost . . . . . . . . 12.2  NNN  Actual Costs Period To Date . .
                                                    Mask:#######0.00
      44  YTDActualCosts. . . . . . . . 12.2  NNN  Actual Costs Year To Date . . .
                                                    Mask:#######0.00
      45  JTDActualCosts. . . . . . . . 12.2  NNN  Actual Costs Job  To Date . . .
                                                    Mask:#######0.00
      46  PTDInvoiceBilled. . . . . . . 12.2  NNN  Invoice Billed Period To Date .
                                                    Mask:#######0.00
      47  YTDInvoiceBilled. . . . . . . 12.2  NNN  Invoice Billed Year To Date . .
                                                    Mask:#######0.00
      48  JTDInvoiceBilled. . . . . . . 12.2  NNN  Invoice Billed Job  To Date . .
                                                    Mask:#######0.00
      49  PTDPaymentReceived. . . . . . 12.2  NNN  Payment Received Period To Date
                                                    Mask:#######0.00
      50  YTDPaymentReceived. . . . . . 12.2  NNN  Payment Received Year To Date .
                                                    Mask:#######0.00
      51  JTDPaymentReceived. . . . . . 12.2  NNN  Payment Received Job To Date. .
                                                    Mask:#######0.00
      52  RetentionBalance. . . . . . . 12.2  NNN  Retention Balance . . . . . . .
                                                    Mask:#######0.00
      53  DeferredRevenue . . . . . . . 12.2  NNN  Deferred Revenue (Accntg Methd
                                                    Mask:#######0.00
      54  UnbilledCost. . . . . . . . . 12.2  NNN  Unbilled Cost . . . . . . . . .
                                                    Mask:#######0.00
      55  FutureActualCosts . . . . . . 12.2  NNN  Actual Costs Next Period. . . .
                                                    Mask:#######0.00
      56  FutureInvoiceBilled . . . . . 12.2  NNN  Invoice Billed Next Period. . .
                                                    Mask:#######0.00
      57  FuturePaymentReceived . . . . 12.2  NNN  Payment Received Next Period. .
                                                    Mask:#######0.00