JC1 J/C Job Master File (JC1_JobMaster) Level: 4.40
Record Type: 1 J/C Job Masterfile 08/28/2009
File Type: Mkeyed Key Size: 7 Rec Len: 675 Min Len: 383 Define: Y
Main Key (KNO=0)JobNumber(1,7)
2nd Key (KNO=1) JobDescription(8,30)+JobNumber(1,7)
3rd Key (KNO=2) Estimator(182,10)+JobNumber(1,7)
4th Key (KNO=3) Manager(192,10)+JobNumber(1,7)
5th Key (KNO=4) DivisionNumber(312,2)+CustomerNumber(314,20)+JobNumber(1,7)
6th Key (KNO=5) JobType(223,3)+JobNumber(1,7)
7th Key (KNO=6) SortField(289,10)+JobNumber(1,7)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7)
Description . . . . . . . . . . . . . . JobDescription. . . . . . . . String (8,30)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (38,9)
Address 1 . . . . . . . . . . . . . . . Address1. . . . . . . . . . . String (47,30)
Address 2 . . . . . . . . . . . . . . . Address2. . . . . . . . . . . String (77,30)
Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String (107,30)
Contact . . . . . . . . . . . . . . . . ContactName . . . . . . . . . String (137,30)
Phone Number. . . . . . . . . . . . . . PhoneNo . . . . . . . . . . . Phone (167,10)
Extension . . . . . . . . . . . . . . . Extension . . . . . . . . . . String (177,5)
Estimator . . . . . . . . . . . . . . . Estimator . . . . . . . . . . Uppercase (182,10)
Manager . . . . . . . . . . . . . . . . Manager . . . . . . . . . . . Uppercase (192,10)
Contract Number . . . . . . . . . . . . ContractNumber. . . . . . . . String (202,15)
Contract Date . . . . . . . . . . . . . ContractDate. . . . . . . . . Date (217,6)
Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase (223,3)
Accnt Method (Percent Completion Cont)AcctMethod. . . . . . . . . . Uppercase (226,1)
Completed Contract) . . . . . . . . . . . . . . . . . . . . . . . . Memo
Bill Meth (None, Fixed, Time & Mat.L) . BillingMethod . . . . . . . . Uppercase (227,1)
Job Stat (Bid,Cmplt,Hld,Late,Open,Xlosd)JobStatus . . . . . . . . . . Uppercase (228,1)
Status Date . . . . . . . . . . . . . . StatusDate. . . . . . . . . . Date (229,6)
Estimated Start Date. . . . . . . . . . EstimatedStartDate. . . . . . Date (235,6)
Estimated Completion Date . . . . . . . EstimatedCompDate . . . . . . Date (241,6)
Actual Start Date . . . . . . . . . . . ActualStartDate . . . . . . . Date (247,6)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (253,1)
Retain Jtd Cost Detail? (Y/N) . . . . . RetainJTDTransDetail. . . . . Yes/No (254,1)
Unit Of Measure Description . . . . . . UnitOfMeasureDesc . . . . . . String (255,10)
Date Reported . . . . . . . . . . . . . DateReported. . . . . . . . . Date (265,6)
Last Cost Transaction Date. . . . . . . LastCostTransDate . . . . . . Date (271,6)
Last Bill Date. . . . . . . . . . . . . LastBillDate. . . . . . . . . Date (277,6)
Last Payment Date . . . . . . . . . . . LastPaymentDate . . . . . . . Date (283,6)
Sort Field. . . . . . . . . . . . . . . SortField . . . . . . . . . . Uppercase (289,10)
Calculate Sales Tax? (Y/N). . . . . . . CalcSalesTax. . . . . . . . . Yes/No (299,1)
In Billing Selection And Entry. . . . . . . . . . . . . . . . . . . Memo
Sales Tax - Next Period . . . . . . . . FutureSalesTax. . . . . . . . String (300,12)
Mask Is ########.00-. . . . . . . . . . . . . . . . . . . . . . . . Memo
Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled (312,2)
Customer Number . . . . . . . . . . . . CustomerNumber. . . . . . . . Account (314,20)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (334,50)
Sales Tax Job To Date . . . . . . . . . JTDSalesTax . . . . . . . . . Number [0] 8.2
Retention Percent . . . . . . . . . . . RetentionPercent. . . . . . . Number [1] 3.2
Total Job Units . . . . . . . . . . . . TotalJobUnits . . . . . . . . Number [2] 8.0
Original Estimate . . . . . . . . . . . OriginalEstimate. . . . . . . Number [3] 8.2
Revised Estimate. . . . . . . . . . . . RevisedEstimate . . . . . . . Number [4] 8.2
Original Contract . . . . . . . . . . . OriginalContract. . . . . . . Number [5] 8.2
Revised Contract. . . . . . . . . . . . RevisedContract . . . . . . . Number [6] 8.2
Actual Percent Complete . . . . . . . . ActualPercentComplete . . . . Number [7] 3.2
Actual Costs Period To Date . . . . . . PTDActualCost . . . . . . . . Number [8] 8.2
Actual Costs Year To Date . . . . . . . YTDActualCosts. . . . . . . . Number [9] 8.2
Actual Costs Job To Date . . . . . . . JTDActualCosts. . . . . . . . Number [10] 8.2
Invoice Billed Period To Date . . . . . PTDInvoiceBilled. . . . . . . Number [11] 8.2
Invoice Billed Year To Date . . . . . . YTDInvoiceBilled. . . . . . . Number [12] 8.2
Invoice Billed Job To Date . . . . . . JTDInvoiceBilled. . . . . . . Number [13] 8.2
Payment Received Period To Date . . . . PTDPaymentReceived. . . . . . Number [14] 8.2
Payment Received Year To Date . . . . . YTDPaymentReceived. . . . . . Number [15] 8.2
Payment Received Job To Date. . . . . . JTDPaymentReceived. . . . . . Number [16] 8.2
Retention Balance . . . . . . . . . . . RetentionBalance. . . . . . . Number [17] 8.2
Deferred Revenue (Accntg Methd = C) . . DeferredRevenue . . . . . . . Number [18] 8.2
Unbilled Cost . . . . . . . . . . . . . UnbilledCost. . . . . . . . . Number [19] 8.2
Actual Costs Next Period. . . . . . . . FutureActualCosts . . . . . . Number [20] 8.2
Invoice Billed Next Period. . . . . . . FutureInvoiceBilled . . . . . Number [21] 8.2
Payment Received Next Period. . . . . . FuturePaymentReceived . . . . Number [22] 8.2
________
Total Bytes 672