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