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