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