JC0 J/C Parameters (JC0_Parameters) Level: 4.40 Record Type: 1 J/C Parameter Record 08/28/2009 File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 99 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
'J/C' (Application Code). . . . . . . . JCApplicationCode . . . . . . String *(1,3) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3) New System? . . . . . . . . . . . . . . NewSystem . . . . . . . . . . Yes/No (7,1) Cost Code - Length Segment 1. . . . . . CostCodeLengthSegment1. . . . Zero-Filled (8,1) Cost Code - Length Segment 2. . . . . . CostCodeLengthSegment2. . . . Zero-Filled (9,1) Cost Code - Length Segment 3. . . . . . CostCodeLengthSegment3. . . . Zero-Filled (10,1) Use Sub-Job Number? (Y/N) . . . . . . . UseSubJobNumber . . . . . . . Yes/No (11,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (12,1) Post Wip To G/L? (Y/N). . . . . . . . . PostWipToGL . . . . . . . . . Yes/No (13,1) Allow Job Change Orders? (Y/N). . . . . AllowJobChgOrders . . . . . . Yes/No (14,1) Allow Sub-Contract Change Orders? (Y/N) AllowSubcontractChgOrde . . . Yes/No (15,1) Post To G/L For Direct Cost Trans? (Y/N)PostToGLForDirectCostTrans. . Yes/No (16,1) Post To G/L For Bill & Csh Rcpt Trans?. PostToGLforBillCshRcp . . . . Yes/No (17,1) Number Of Decimals In Unit Cost (2-4). NoOfDecimalsInUnitCos . . . . Zero-Filled (18,1) Number Of Decimals In Unit Price (2-4). NoOfDecimalsInUnitPrice . . . Zero-Filled (19,1) Number Of Decimals In Units (0-4). NumberOfDecimalsInUnits . . . Zero-Filled (20,1) Next Cost Posting Batch Number. . . . . NextCostPostingBatchNo. . . . Zero-Filled (21,7) Next Billing Batch Number . . . . . . . NextBillingBatchNo. . . . . . Zero-Filled (28,7) Next Cash Receipt Batch Number. . . . . NextCashRecptBatchNo. . . . . Zero-Filled (35,7) Length Of Cost Code (1-9) . . . . . . . LengthOfCostCode. . . . . . . Zero-Filled (42,1) Sort Field Description. . . . . . . . . SortFieldDescription. . . . . String (43,15) Default Job Type. . . . . . . . . . . . DefaultJobType. . . . . . . . Uppercase (58,3) Apply Overhead? (D/M/N) . . . . . . . . ApplyOverhead . . . . . . . . Uppercase (61,1) Period End Flag (1=Period, 2=Year). . . PeriodEndFlag . . . . . . . . String (62,1) Application Interfaced To A/R?(Y/N) . . AppInterfacedToAR . . . . . . Yes/No (63,1) Application Interfaced To I/M?(Y/N) . . AppInterfacedToIM . . . . . . Yes/No (64,1) Current Period. . . . . . . . . . . . . CurrentPeriod . . . . . . . . Zero-Filled (65,2) Current Calendar Year . . . . . . . . . CurrentCalendarYr . . . . . . Packed Year (67,2) Allow Cst Memo Inq-Data Ent?(Y/N/M) . . AllowCstMemoInqdataEnt. . . . Uppercase (69,1) Actual Or Calculated % Complete . . . . ActualOrCalcComplet . . . . . Uppercase (70,1) Current J/C Fiscal Year . . . . . . . . CurrentJCFiscalYr . . . . . . Packed Year (71,2) Print Tax Detail On Billing Reg.? . . . PrintTaxDetailOnBillRegister. Yes/No (73,1) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (74,1) Retention Taxable . . . . . . . . . . . RetentionTaxable. . . . . . . Yes/No (75,1) Retain Job Cost History . . . . . . . . RetainJobCostHistory. . . . . Yes/No (76,1) All Cost Transactions Set to Billed . . AllCostTransactionsSetToBilledYes/No (77,1) Cost Code Status Determination. . . . . CostCodeStatusDetermination . Yes/No (78,1) Inactive Cost Code Password . . . . . . InactiveCostCodePassword. . . String (79,7) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (86,15) Job Number Format (0A7 Or 0A4A3). . . . JobNumberFormat . . . . . . . String (1,5) Cost Code Format (Default Is 0A3A3A3) . CostCodeFormat. . . . . . . . String (1,7) ________ Total Bytes 116
JC0 J/C Parameters (JC0_Parameters) Level: 4.40 Record Type: 2 J/C Parameters - Record 2 08/28/2009 File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 99 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
'J/C' . . . . . . . . . . . . . . . . . JCApplicationCode . . . . . . String *(1,3) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3) '2' . . . . . . . . . . . . . . . . . . NewSystem . . . . . . . . . . String *(7,1) Cost Type 1 . . . . . . . . . . . . . . CostType1 . . . . . . . . . . Uppercase *(8,1) Cost Type 2 . . . . . . . . . . . . . . CostType2 . . . . . . . . . . Uppercase *(9,1) Cost Type 3 . . . . . . . . . . . . . . CostType3 . . . . . . . . . . Uppercase (10,1) Cost Type 4 . . . . . . . . . . . . . . CostType4 . . . . . . . . . . Uppercase (11,1) Cost Type 5 . . . . . . . . . . . . . . CostType5 . . . . . . . . . . Uppercase (12,1) Cost Type 6 . . . . . . . . . . . . . . CostType6 . . . . . . . . . . Uppercase (13,1) Cost Type 7 . . . . . . . . . . . . . . CostType7 . . . . . . . . . . Uppercase (14,1) Cost Type 8 . . . . . . . . . . . . . . CostType8 . . . . . . . . . . Uppercase (15,1) Cost Type 9 . . . . . . . . . . . . . . CostType9 . . . . . . . . . . Uppercase (16,1) Cost Type 10. . . . . . . . . . . . . . CostType10. . . . . . . . . . Uppercase (17,1) Cost Type 11. . . . . . . . . . . . . . CostType11. . . . . . . . . . Uppercase (18,1) Cost Type 12. . . . . . . . . . . . . . CostType12. . . . . . . . . . Uppercase (19,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,3) Cost Type 1 Description . . . . . . . . CostType1Description. . . . . String (23,15) Cost Type 2 Description . . . . . . . . CostType2Description. . . . . String (38,15) Cost Type 3 Description . . . . . . . . CostType3Description. . . . . String (53,15) Cost Type 4 Description . . . . . . . . CostType4Description. . . . . String (68,15) Cost Type 5 Description . . . . . . . . CostType5Description. . . . . String (83,15) Cost Type 6 Description . . . . . . . . CostType6Description. . . . . String (98,15) Cost Type 7 Description . . . . . . . . CostType7Description. . . . . String (113,15) Cost Type 8 Description . . . . . . . . CostType8Description. . . . . String (128,15) Cost Type 9 Description . . . . . . . . CostType9Description. . . . . String (143,15) Cost Type 10 Description. . . . . . . . CostType10Description . . . . String (158,15) Cost Type 11 Description. . . . . . . . CostType11Description . . . . String (173,15) Cost Type 12 Description. . . . . . . . CostType12Description . . . . String (188,15) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (203,12) Cost Type 1-12 Detailed Billing?. . . . CostTypesDetailBilling. . . . String (215,12) Cost Type 1-12 Tax Class. . . . . . . . CostTypesTaxClass . . . . . . Uppercase (227,24) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (251,4) ________ Total Bytes 256
JC0 J/C Parameters (JC0_Parameters) Level: 4.40 Record Type: 3 J/C Parameters - Record 3 08/28/2009 File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 99 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
'J/C' . . . . . . . . . . . . . . . . . JCApplicationCode . . . . . . String *(1,3) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3) '3' . . . . . . . . . . . . . . . . . . NewSystem . . . . . . . . . . String *(7,1) Job Invoice Message Line 1. . . . . . . JobInvoiceMessageLine1. . . . String (8,50) Job Invoice Message Line 2. . . . . . . JobInvoiceMessageLine2. . . . String (58,50) Integrated with Timberline. . . . . . . IntegratedWithTimberline. . . Yes/No (108,1) Directory for Estimating Database . . . DirectoryForEstimatingDatabaseString (109,135) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (244,4) ________ Total Bytes 249
JC0 J/C Parameters (JC0_Parameters) Level: 4.40 Record Type: 9 '9' Record - All Applications 08/28/2009 File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 99 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"J/C" (Application Code). . . . . . . . JCApplicationCode . . . . . . String *(1,3) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3) '9' . . . . . . . . . . . . . . . . . . NewSystem . . . . . . . . . . String *(7,1) Application Interfaced To G/L?(Y/N) . . ApplicationInterfacedToGL . . Yes/No (8,1) Allow Job Memo Inq-Data Ent?(Y/N/M) . . AllowJobMemoInq . . . . . . . Uppercase (9,1) Allow Purge Option In G/L Recap Rpt . . AllowPurgeOptionInGLRecap . . Yes/No (10,1) Use GUI Job Invoices. . . . . . . . . . UseGUIJobInvoices . . . . . . Yes/No (11,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (12,89) ________ Total Bytes 102
JC0 J/C Parameters (JC0_Parameters) Level: 4.40 Record Type: Q 'Q' - Keys Of Quick Print - Invoices 08/28/2009 File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 99 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"Q" . . . . . . . . . . . . . . . . . . QRecord . . . . . . . . . . . String *(1,1) Terminal Id (Fid(0)). . . . . . . . . . TerminalID. . . . . . . . . . String *(2,3) "J/C" . . . . . . . . . . . . . . . . . JCApplicationCode . . . . . . String *(5,3) Program Name ('Jczrda') . . . . . . . . ProgramName . . . . . . . . . String (8,6) Name Of Selection Screen Of Print . . . . . . . . . . . . . . . . . Memo Program . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Key Of Record Quick Printing. . . . . . KeyOfRecordQuickPrinting. . . String (14,7) Jcd$(1,7) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (21,80) ________ Total Bytes 102
JC0 J/C Parameters (JC0_Parameters) Level: 4.40 Record Type: v Version Record 08/28/2009 File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 99 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"v" Record. . . . . . . . . . . . . . . VRecord . . . . . . . . . . . String *(1,1) Application Code. . . . . . . . . . . . ApplicationCode . . . . . . . String *(2,3) Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3) Version Number. . . . . . . . . . . . . VersionNumber . . . . . . . . String (8,10) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (18,83) ________ Total Bytes 102