WO0 W/O Parameter File (WO0_Parameter) Level: 4.40
Record Type: 1 Parameter File 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"W/O" . . . . . . . . . . . . . . . . . WOApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
New System? (Y/N) . . . . . . . . . . . NewSystem . . . . . . . . . . Yes/No (7,1)
Print W/O Travelers Upon Release? . . . PrntWOTravlrsUponRelease. . . Yes/No (8,1)
Print Matrl On Travelers? . . . . . . . PrntMatrlOnTravelers. . . . . Yes/No (9,1)
Matrl Print Option (First, Mixed) . . . MaterialPrintOption . . . . . Uppercase (10,1)
Print Pick Sheets (Whse, Order, No) . . PrintPickSheets . . . . . . . Uppercase (11,1)
Sort Items By Bin Location? . . . . . . SortItemsByBinLocation. . . . Yes/No (12,1)
Page By Step? . . . . . . . . . . . . . PageByStep. . . . . . . . . . Yes/No (13,1)
Print Pick Sheets Upon Release. . . . . PrntPickSheetsUponRelease . . Yes/No (14,1)
Auto Issue Material Trans (Y,N,A) . . . AutoIssueMatlTran . . . . . . Uppercase (15,1)
Y=Yes, N=No, A=Avail QOH. . . . . . . . . . . . . . . . . . . . . . Memo
No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo
Avail issues no more than QOH . . . . . . . . . . . . . . . . . . . Memo
Shortage Report Format (Cobn) . . . . . ShortageRptFormat . . . . . . Uppercase (16,1)
(Component Seq, Order # Seq,. . . . . . . . . . . . . . . . . . . . Memo
Both, None) . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
W/O Step Auto Increment Amount. . . . . WOStepAutoIncrementAmount . . Zero-Filled (17,3)
Retain W/O Trans Detail?. . . . . . . . RetainWOTransDetail . . . . . Yes/No (20,1)
Allow Memo Inquiry From Data Entry. . . AllowMemoInqFromDataEntry . . Uppercase (21,1)
(Yes, No, Maintain) . . . . . . . . . . . . . . . . . . . . . . . . Memo
Upon Completion:. . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Print Missing Cost Rpt (Y,N,Page) . . . PrntMissingCostReport . . . . Uppercase (22,1)
Min Variance Percent To Print . . . . . MinVarPercentToPrintCostRpt . Zero-Filled (23,3)
Print Var From Stds Rpt (Y,N,Pge) . . . PrntVarFromStdsRpt. . . . . . Uppercase (26,1)
Min Variance Percent To Print . . . . . MinVarPercentToPrintStdsRpt . Zero-Filled (27,3)
Print Order Fill Report? (Y/N). . . . . PrntOrderFillRpt. . . . . . . Yes/No (30,1)
Cost Completion Method (A/P/L). . . . . CostCompletionMethod. . . . . Uppercase (31,1)
Default for new work order. . . . . . . . . . . . . . . . . . . . . Memo
A=Actual (Options default). . . . . . . . . . . . . . . . . . . . . Memo
P=Planned . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
L=Lower of Actual or Planned. . . . . . . . . . . . . . . . . . . . Memo
Auto Gen Labor Tran . . . . . . . . . . AutoGenLabTran. . . . . . . . Yes/No (32,1)
No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo
Auto Gen Outside Proc Tran. . . . . . . AutoGenOutsProcTran . . . . . Yes/No (33,1)
No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo
Issue Method (A/B/M). . . . . . . . . . IssueMethod . . . . . . . . . Uppercase (34,1)
Auto, Backflush, Manual . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (35,12)
Print Missing Cost Rpt (Y,N,Page) . . . PrntMissingCostRpt. . . . . . Uppercase (47,1)
Min Variance Percent To Print . . . . . MinVarPerToPrintCloseCostRpt. Zero-Filled (48,3)
Print W/O Close Cst Ledger? (Ynp) . . . PrntWOCloseCstLedger. . . . . Uppercase (51,1)
Print Var From Stds Rpt (Y,N,Pg). . . . PrntVarFromStdsRptUponClose . Uppercase (52,1)
Min Variance Percent To Print . . . . . MinVarPerToPrintCloseStdRpt . Zero-Filled (53,3)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (56,16)
Retain Work Order History? (Y/N). . . . RetainWorkOrderHistory. . . . Yes/No (72,1)
Retain W/O Line Detail. . . . . . . . . RetainWOLineDetail. . . . . . Yes/No (73,1)
Retain Trans History. . . . . . . . . . RetainTransHistory. . . . . . Yes/No (74,1)
History Purge Option Password . . . . . HistoryPurgeOptPasswor. . . . String (75,7)
# Of Days To Retain Closed W/O'S. . . . NoOfDaysToRetainClosedWO. . . Zero-Filled (82,3)
User Defined Fld 1 Description. . . . . UserDefinedField1Description. String (85,15)
User Defined Fld 2 Description. . . . . UserDefinedField2Description. String (100,15)
User Defined Fld 3 Description. . . . . UserDefinedField3Description. String (115,15)
User Defined Fld 4 Description. . . . . UserDefinedField4Description. String (130,15)
User Defined Fld 1 Data Type. . . . . . UserDefinedField1DataType . . Uppercase (145,1)
(Date, Text). . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
User Defined Fld 2 Data Type. . . . . . UserDefinedField2DataType . . Uppercase (146,1)
User Defined Fld 3 Data Type. . . . . . UserDefinedField3DataType . . Uppercase (147,1)
User Defined Fld 4 Data Type. . . . . . UserDefinedField4DataType . . Uppercase (148,1)
Next Automatic W/O Number . . . . . . . NextAutomaticWONumber . . . . Zero-Filled (149,7)
"T" For Next Template Number. . . . . . TForNextTemplateNumber. . . . Uppercase (156,1)
Next Auto W/O Template Number . . . . . NextAutoWOTemplateNumber. . . Zero-Filled (157,6)
Next Auto W/O Trans Number. . . . . . . NextAutoWOTransNumber . . . . Zero-Filled (163,7)
Integrate W/O With S/O? . . . . . . . . IntegrateWOWithSO . . . . . . Yes/No (170,1)
Allow Wrk Center & Op Code Addition . . AllowWrkCenterAndOpCodeAdds . Uppercase (171,1)
From: (Routing, Work Order, . . . . . . . . . . . . . . . . . . . . Memo
Both, None) . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Include W/O Component Requirements. . . InclWOComponentRequirements . Yes/No (172,1)
On Fill Reports?. . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Future Days To Include W/O'S. . . . . . FutureDaysToIncludeWO . . . . Zero-Filled (173,3)
Print W/O Labels? (L/S/B/A/N) . . . . . PrntWOLabels. . . . . . . . . Yes/No (176,1)
Max # Of Months To Schedule . . . . . . MaxNoOfMonthsToSchedule . . . Zero-Filled (177,3)
Require Depts For Prod Employees? . . . RequireDeptsForProdEmploye. . Yes/No (180,1)
Comp/Close Reports Term Id#-Fid(0). . . CompCloseRptTermIdFid . . . . String (181,3)
Parent Default Whse (W/O Entry) . . . . ParentDefaultWhseEntry. . . . String (184,3)
Component Default Whse (W/O Entry). . . ComponentDefaultWhseEn. . . . String (187,3)
Allow Batch Entry? (Y/N). . . . . . . . AllowBatchEntry . . . . . . . String (190,1)
Passowrd For Batch Override . . . . . . PassowrdForBatchOverride. . . String (191,6)
Next Batch Number . . . . . . . . . . . NextBatchNumber . . . . . . . String (197,5)
Explode Sub-Assemblies W/O Entry? . . . ExplodeSubassembliesWOEnt . . Yes/No (202,1)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (203,48)
________
Total Bytes 252
WO0 W/O Parameter File (WO0_Parameter) Level: 4.40
Record Type: 2 G/L Account Numbers 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"W/O" . . . . . . . . . . . . . . . . . WOApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
"2" - G/L Account Numbers . . . . . . . RecordNumber. . . . . . . . . Uppercase *(7,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (8,12)
W/O Scrap Account . . . . . . . . . . . WOScrapAccount. . . . . . . . G/L Account (20,9)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (29,3)
Default Special Item Purch Accnt. . . . DefaultSpecialItemPurchAccnt. G/L Account (32,9)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (41,3)
Dflt Wip Dir Accnt. . . . . . . . . . . DfltWipDirAccnt . . . . . . . G/L Account (44,9)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (53,3)
Dflt Wip Fixed Ovrhd Accnt. . . . . . . DfltWipFixedOvrhdAccnt. . . . G/L Account (56,9)
Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (65,3)
Dflt Wip Variable Ovrhd Accnt . . . . . DfltWipVariableOvrhdAccnt . . G/L Account (68,9)
Open String . . . . . . . . . . . . . . _S6 . . . . . . . . . . . . . Open String (77,3)
Default Applied Direct Account. . . . . DefaultAppliedDirectAccount . G/L Account (80,9)
Open String . . . . . . . . . . . . . . _S7 . . . . . . . . . . . . . Open String (89,3)
Dflt Appld Fixed Ovrhd Accnt. . . . . . DfltAppldFixedOvrhdAccnt. . . G/L Account (92,9)
Open String . . . . . . . . . . . . . . _S8 . . . . . . . . . . . . . Open String (101,3)
Dflt Appld Variable Ovrhd Accnt . . . . DfltAppldVariableOvrhdAccnt . G/L Account (104,9)
Open String . . . . . . . . . . . . . . _S9 . . . . . . . . . . . . . Open String (113,3)
Open String . . . . . . . . . . . . . . _S10. . . . . . . . . . . . . Open String (116,85)
________
Total Bytes 202
WO0 W/O Parameter File (WO0_Parameter) Level: 4.40
Record Type: 8 '8' Record - Tab Fields 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"W/O" (Application Code). . . . . . . . WOApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
'8' . . . . . . . . . . . . . . . . . . RecordNumber. . . . . . . . . String *(7,1)
Work Order Entry Tab Fields . . . . . . . . . . . . . . . . . . . . Memo
Step Description. . . . . . . . . . . . StepDescriptionOE . . . . . . Yes/No (8,1)
Ignore Queue Time . . . . . . . . . . . IgnoreQueueTimeOE . . . . . . Yes/No (9,1)
Overlap Percent . . . . . . . . . . . . OverlapPercentOE. . . . . . . Yes/No (10,1)
Standard Run Type . . . . . . . . . . . StandardRunTypeOE . . . . . . Yes/No (11,1)
Parent Item Type. . . . . . . . . . . . ParentItemTypeOE. . . . . . . Yes/No (12,1)
Parent Factor . . . . . . . . . . . . . ParentFactorOE. . . . . . . . Yes/No (13,1)
Required Tooling. . . . . . . . . . . . RequiredToolingOE . . . . . . Yes/No (14,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (15,1)
B/M Revision. . . . . . . . . . . . . . BMRevisionOE. . . . . . . . . Yes/No (16,1)
Step Number . . . . . . . . . . . . . . StepNumberOE. . . . . . . . . Yes/No (17,1)
Scrap % . . . . . . . . . . . . . . . . ScrapPercOE . . . . . . . . . Yes/No (18,1)
Warehouse . . . . . . . . . . . . . . . WarehouseOE . . . . . . . . . Yes/No (19,1)
Unit Of Measure . . . . . . . . . . . . UnitOfMeasureOE . . . . . . . Yes/No (20,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (21,10)
Routing Maint Tab Fields. . . . . . . . . . . . . . . . . . . . . . Memo
Step Description. . . . . . . . . . . . StepDescriptionRM . . . . . . Yes/No (31,1)
Ignore Queue Time . . . . . . . . . . . IgnoreQueueTimeRM . . . . . . Yes/No (32,1)
Overlap Percent . . . . . . . . . . . . OverlapPercentRM. . . . . . . Yes/No (33,1)
Standard Run Type . . . . . . . . . . . StandardRunTypeRM . . . . . . Yes/No (34,1)
Parent Item Type. . . . . . . . . . . . ParentItemTypeRM. . . . . . . Yes/No (35,1)
Parent Factor . . . . . . . . . . . . . ParentFactorRM. . . . . . . . Yes/No (36,1)
Required Tooling. . . . . . . . . . . . RequiredToolingRM . . . . . . Yes/No (37,1)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (38,8)
Material Issue Trans Tab Fields . . . . . . . . . . . . . . . . . . Memo
Substitute Material?. . . . . . . . . . SubstituteMaterialMI. . . . . Yes/No (46,1)
Warehouse . . . . . . . . . . . . . . . WarehouseMI . . . . . . . . . Yes/No (47,1)
Unit Of Measure . . . . . . . . . . . . UnitOfMeasureMI . . . . . . . Yes/No (48,1)
Substitution Warehouse. . . . . . . . . SubstitutionWarehouseMI . . . Yes/No (49,1)
Substitution Unit Of Measure. . . . . . SubstitutionUnitOfMeasureMI . Yes/No (50,1)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (51,10)
Labor Trans Tab Fields. . . . . . . . . . . . . . . . . . . . . . . Memo
Work Center . . . . . . . . . . . . . . WorkCenterLT. . . . . . . . . Yes/No (61,1)
Operation Code. . . . . . . . . . . . . OperationCodeLT . . . . . . . Yes/No (62,1)
Start Date. . . . . . . . . . . . . . . StartDateLT . . . . . . . . . Yes/No (63,1)
Start Time. . . . . . . . . . . . . . . StartTimeLT . . . . . . . . . Yes/No (64,1)
Stop Date . . . . . . . . . . . . . . . StopDateLT. . . . . . . . . . Yes/No (65,1)
Qty Completed . . . . . . . . . . . . . QtyCompletedLT. . . . . . . . Yes/No (66,1)
Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (67,9)
Misc Labor Charge Trans Tab Fields. . . . . . . . . . . . . . . . . Memo
Work Center . . . . . . . . . . . . . . WorkCenterML. . . . . . . . . Yes/No (76,1)
Operation Code. . . . . . . . . . . . . OperationCodeML . . . . . . . Yes/No (77,1)
Date. . . . . . . . . . . . . . . . . . DateML. . . . . . . . . . . . Yes/No (78,1)
Open String . . . . . . . . . . . . . . _S6 . . . . . . . . . . . . . Open String (79,12)
Misc Material Charge Trans Tab Flds . . . . . . . . . . . . . . . . Memo
Work Center . . . . . . . . . . . . . . WorkCenterMM. . . . . . . . . Yes/No (91,1)
Operation Code. . . . . . . . . . . . . OperationCodeMM . . . . . . . Yes/No (92,1)
Date. . . . . . . . . . . . . . . . . . DateMM. . . . . . . . . . . . Yes/No (93,1)
Open String . . . . . . . . . . . . . . _S7 . . . . . . . . . . . . . Open String (94,12)
Outside Process Charge Trans Tab. . . . . . . . . . . . . . . . . . Memo
Work Center . . . . . . . . . . . . . . WorkCenterOP. . . . . . . . . Yes/No (106,1)
Operation Code. . . . . . . . . . . . . OperationCodeOP . . . . . . . Yes/No (107,1)
Vendor. . . . . . . . . . . . . . . . . VendorOP. . . . . . . . . . . Yes/No (108,1)
Date. . . . . . . . . . . . . . . . . . DateOP. . . . . . . . . . . . Yes/No (109,1)
Open String . . . . . . . . . . . . . . _S8 . . . . . . . . . . . . . Open String (110,11)
Completion Transaction Tab Fields . . . . . . . . . . . . . . . . . Memo
Unit Of Measure . . . . . . . . . . . . UnitOfMeasureCT . . . . . . . Yes/No (121,1)
Warehouse . . . . . . . . . . . . . . . WarehouseCT . . . . . . . . . Yes/No (122,1)
Purchases Account . . . . . . . . . . . PurchasesAccountCT. . . . . . Yes/No (123,1)
Parent Unit Of Measure. . . . . . . . . ParentUnitOfMeasureCT . . . . Yes/No (124,1)
Open String . . . . . . . . . . . . . . _S9 . . . . . . . . . . . . . Open String (125,36)
Open String . . . . . . . . . . . . . . _S10. . . . . . . . . . . . . Open String (161,25)
Open String . . . . . . . . . . . . . . _S11. . . . . . . . . . . . . Open String (186,25)
________
Total Bytes 212
WO0 W/O Parameter File (WO0_Parameter) Level: 4.40
Record Type: 9 '9' System Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"W/O" . . . . . . . . . . . . . . . . . WOApplicationCode . . . . . . String *(1,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(4,3)
"9" - System Record '9' . . . . . . . . RecordNumber. . . . . . . . . Uppercase *(7,1)
Interfaced To G/L? (Y/N). . . . . . . . InterfacedToGL. . . . . . . . Yes/No (8,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (9,1)
Allow Purge Option In G/L Recap Rpt . . AllowPurgeOptionInGLRecap . . Yes/No (10,1)
Use GUI Work Order Travelers. . . . . . UseGUIWOTravelers . . . . . . Yes/No (11,1)
Use GUI Picking Sheets. . . . . . . . . UseGUIPickingSheets . . . . . Yes/No (12,1)
Use GUI Operation Tickets . . . . . . . UseGUIOperationTickets. . . . Yes/No (13,1)
Use GUI Work Oder labels. . . . . . . . UseGUIWOlabels. . . . . . . . Yes/No (14,1)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (15,86)
________
Total Bytes 102
WO0 W/O Parameter File (WO0_Parameter) Level: 4.40
Record Type: B Batch Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Batch Record. . . . . . . . . . . . . . BatchRecord . . . . . . . . . String (1,128)
( 1, 1) "h". . . . . . . . . . . . . . . . . . . . . . . . . . Memo
( 2, 3) FID(0) Terminal ID . . . . . . . . . . . . . . . . . . Memo
( 5, 3) Application Code (A/A) . . . . . . . . . . . . . . . . Memo
( 8, 5) Batch Number . . . . . . . . . . . . . . . . . . . . . Memo
(13,116) Open String . . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 130
WO0 W/O Parameter File (WO0_Parameter) Level: 4.40
Record Type: v Version Record 08/28/2009
File Type: Direct Key Size: 9 Rec Len: 256 Min Len: 9 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Version Record. . . . . . . . . . . . . VersionRecord . . . . . . . . String *(1,1)
W/O Application Code. . . . . . . . . . WOApplicationCode . . . . . . Uppercase *(2,3)
Company Code. . . . . . . . . . . . . . CompanyCode . . . . . . . . . String *(5,3)
Version Number. . . . . . . . . . . . . VersionNumber . . . . . . . . String (8,10)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (18,83)
________
Total Bytes 102