JCD J/C Job Billing Entry Header File (JCD_JobBillingsDataEntry) Level: 4.40 Record Type: 1 J/C Job Billing Data Entry Header File 08/28/2009 File Type: Direct Key Size: 7 Rec Len: 410 Min Len: 178 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7) Invoice Number. . . . . . . . . . . . . InvoiceNumber . . . . . . . . Zero-Filled (8,7) Invoice Type. . . . . . . . . . . . . . InvoiceType . . . . . . . . . Uppercase (15,2) Invoice Date. . . . . . . . . . . . . . InvoiceDate . . . . . . . . . Date (17,6) Salesperson Code. . . . . . . . . . . . SalespersonCode . . . . . . . Uppercase (23,4) Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String (27,30) Print Invoice? (Y/N). . . . . . . . . . PrntInvoice . . . . . . . . . Yes/No (57,1) Bill Method (Fix, Time & Material). . . BillMethod. . . . . . . . . . Uppercase (58,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (59,9) Has Invoice Been Printed? (Y/N) . . . . HasInvoiceBeenPrinted . . . . Yes/No (68,1) Job Billing Date. . . . . . . . . . . . JobBillingDate. . . . . . . . Date (69,6) Tax Schedule. . . . . . . . . . . . . . TaxSchedule . . . . . . . . . Uppercase (75,9) Terms Code. . . . . . . . . . . . . . . TermsCode . . . . . . . . . . Zero-Filled (84,2) Apply To Invoice Number . . . . . . . . ApplyToInvoiceNumber. . . . . Zero-Filled (86,7) Adjustment? (Y/N) . . . . . . . . . . . Adjustment. . . . . . . . . . Yes/No (93,1) Invoice Due Date. . . . . . . . . . . . InvoiceDueDate. . . . . . . . Date (94,6) Discount Due Date . . . . . . . . . . . DiscountDueDate . . . . . . . Date (100,6) Invalid Tax Calculation?. . . . . . . . InvalidTaxCalc. . . . . . . . Yes/No (106,1) Division Number . . . . . . . . . . . . ARDivisionNumber. . . . . . . Zero-Filled (107,2) Customer Number . . . . . . . . . . . . CustomerNumber. . . . . . . . Account (109,20) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (129,50) Link To First Detail Record . . . . . . LinkToFirstDetailRecord . . . Number [0] 5.0 Commission Rate . . . . . . . . . . . . CommRate. . . . . . . . . . . Number [1] 3.2 Actual Percent Complete . . . . . . . . ActualPercentComplete . . . . Number [2] 3.2 Retention Rate. . . . . . . . . . . . . RetentionRate . . . . . . . . Number [3] 3.2 Amount Billable . . . . . . . . . . . . AmountBillable. . . . . . . . Number [4] 8.2 Retention Amount. . . . . . . . . . . . RetentionAmount . . . . . . . Number [5] 8.2 Amount Subject To Commission. . . . . . AmountSubjectToComm . . . . . Number [6] 8.2 Commission Amount . . . . . . . . . . . CommAmount. . . . . . . . . . Number [7] 7.2 Revised Estimate. . . . . . . . . . . . RevisedEstimate . . . . . . . Number [8] 8.2 Revised Contract. . . . . . . . . . . . RevisedContract . . . . . . . Number [9] 8.2 Jtd Cost. . . . . . . . . . . . . . . . JtdCost . . . . . . . . . . . Number [10] 8.2 Jtd Invoice Billed Amount . . . . . . . JtdInvoicBilledAmount . . . . Number [11] 8.2 (Includes Future Inv Billed Amt). . . . . . . . . . . . . . . . . . Memo Original Contract Amount. . . . . . . . OriginalContractAmount. . . . Number [12] 8.2 Taxable Amount. . . . . . . . . . . . . TaxableAmount . . . . . . . . Number [13] 8.2 Non-Taxable Amount. . . . . . . . . . . NontaxableAmount. . . . . . . Number [14] 8.2 Sales Tax Amount. . . . . . . . . . . . SalesTaxAmount. . . . . . . . Number [15] 8.2 Previous Retention Balance. . . . . . . PreviousRetentionAmount . . . Number [16] 8.2 Billable Contract (If Fixed Contract) . BillableContract. . . . . . . Number [17] 8.2 Misc Charges (Calc During Update) . . . MiscChrg. . . . . . . . . . . Number [18] 8.2 ________ Total Bytes 406
JCD J/C Job Billing Entry Header File (JCD_JobBillingsDataEntry) Level: 4.40 Record Type: 2 Posting Restart Record 08/28/2009 File Type: Direct Key Size: 7 Rec Len: 410 Min Len: 178 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
rs1 . . . . . . . . . . . . . . . . . . rs1 . . . . . . . . . . . . . String (1,14) rn1 . . . . . . . . . . . . . . . . . . rn1 . . . . . . . . . . . . . Number [0] 8.3 rn2 . . . . . . . . . . . . . . . . . . rn2 . . . . . . . . . . . . . Number [1] 8.3 rn3 . . . . . . . . . . . . . . . . . . rn3 . . . . . . . . . . . . . Number [2] 8.3 rs2 . . . . . . . . . . . . . . . . . . rs2 . . . . . . . . . . . . . String (1,3) ________ Total Bytes 62