WO1 Work Order Master File (WO1_WorkOrderMaster) Level: 4.40 Record Type: 1 Work Order Header Record 08/28/2009 File Type: Mkeyed Key Size: 7 Rec Len: 680 Min Len: 396 Define: Y
Main Key (KNO=0)WorkOrder(1,7) 2nd Key (KNO=1) ItemBillDescription(28,30)+WorkOrder(1,7) 3rd Key (KNO=2) ItemBillNumber(317,30)+WorkOrder(1,7) 4th Key (KNO=3) UserDefinedField1(111,10)+WorkOrder(1,7) 5th Key (KNO=4) UserDefinedField2(121,10)+WorkOrder(1,7) 6th Key (KNO=5) UserDefinedField3(131,10)+WorkOrder(1,7) 7th Key (KNO=6) UserDefinedField4(141,10)+WorkOrder(1,7)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (8,20) Item Description. . . . . . . . . . . . ItemBillDescription . . . . . String (28,30) U/M . . . . . . . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase (58,4) Bill Revision Code. . . . . . . . . . . BillRevision. . . . . . . . . Uppercase (62,3) Bill Options. . . . . . . . . . . . . . BillOptions . . . . . . . . . Uppercase (65,18) Effective Date. . . . . . . . . . . . . EffectiveDate . . . . . . . . Date (83,6) Routing Number. . . . . . . . . . . . . RoutingNumber . . . . . . . . Uppercase (89,20) Issue Method (A/B/M). . . . . . . . . . IssueMethod . . . . . . . . . Uppercase (109,1) Auto, Backflush, Manual . . . . . . . . . . . . . . . . . . . . . . Memo Print Pick List . . . . . . . . . . . . PrntPickList. . . . . . . . . Yes/No (110,1) User Defined Field 1. . . . . . . . . . UserDefinedField1 . . . . . . String (111,10) User Defined Field 2. . . . . . . . . . UserDefinedField2 . . . . . . String (121,10) User Defined Field 3. . . . . . . . . . UserDefinedField3 . . . . . . String (131,10) User Defined Field 4. . . . . . . . . . UserDefinedField4 . . . . . . String (141,10) Planner Code. . . . . . . . . . . . . . PlannerCode . . . . . . . . . Uppercase (151,3) Copy From Template Number . . . . . . . CopyFromTemplate. . . . . . . Zero-Filled (154,7) Print Labels. . . . . . . . . . . . . . PrntLabels. . . . . . . . . . Yes/No (161,1) Explode Sub-Assemblies. . . . . . . . . ExplodeSubassemblies. . . . . Yes/No (162,1) Cost Completion Method. . . . . . . . . CostCmplMthd. . . . . . . . . Uppercase (163,1) A=Actual, P=Planned. . . . . . . . . . . . . . . . . . . . . . . . Memo L=Lower of actual or planned. . . . . . . . . . . . . . . . . . . . Memo Auto Issue Material Tran (Y, N, A). . . AutoIssueMatlTran . . . . . . Uppercase (164,1) Y=Yes, N=No, A=Avail. . . . . . . . . . . . . . . . . . . . . . . . Memo No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo Avail issues no more than QOH . . . . . . . . . . . . . . . . . . . Memo Auto Gen Labor Tran . . . . . . . . . . AutoGenLabTran. . . . . . . . Yes/No (165,1) No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo Auto Gen Outside Proc Tran. . . . . . . AutoGenOutsProcTran . . . . . Yes/No (166,1) No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (167,14) Duplication Of Changes To WO5 . . . . . . . . . . . . . . . . . . . Memo Date Closed . . . . . . . . . . . . . . DateClosed. . . . . . . . . . Date (181,6) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (187,1) Make For (IM, WO, SO) . . . . . . . . . MakeFor . . . . . . . . . . . Uppercase (188,1) Make For Order Number . . . . . . . . . MakeForOrderNumber. . . . . . Uppercase (189,7) S/O Line Index. . . . . . . . . . . . . SOLineIndex . . . . . . . . . String (196,6) (Or W/O Step # + 2 Blanks). . . . . . . . . . . . . . . . . . . . . Memo Parent Warehouse. . . . . . . . . . . . ParentWhse. . . . . . . . . . Account (202,3) Component Warehouse . . . . . . . . . . DefaultComponentWhse. . . . . Account (205,3) Status (Firm, Release, Close, Est). . . Status. . . . . . . . . . . . Uppercase (208,1) W/O Date. . . . . . . . . . . . . . . . WODate. . . . . . . . . . . . Date (209,6) W/O Due Date. . . . . . . . . . . . . . WODueDate . . . . . . . . . . Date (215,6) Scheduled Release Date. . . . . . . . . SchedRelDate. . . . . . . . . Date (221,6) Actual Production Start Date. . . . . . ActualProdStartDate . . . . . Date (227,6) Last Activity Date. . . . . . . . . . . LastActivityDate. . . . . . . Date (233,6) Last Reschedule Date. . . . . . . . . . LastReschedDate . . . . . . . Date (239,6) Prior Due Date (B/4 Last Resched) . . . PriorDueDate. . . . . . . . . Date (245,6) User Who Performed Last Reschedule. . . UserWhoLastResched. . . . . . Uppercase (251,3) On Hold . . . . . . . . . . . . . . . . OnHold. . . . . . . . . . . . Yes/No (254,1) Status Comment Field. . . . . . . . . . StatusComment . . . . . . . . String (255,30) W/O Traveler Printed. . . . . . . . . . TravelerPrinted . . . . . . . Yes/No (285,1) Last Step Complete. . . . . . . . . . . LastStepComplete. . . . . . . Zero-Filled (286,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase (290,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled (291,4) S/O Customer Division . . . . . . . . . CustomerDivision. . . . . . . String (295,2) S/O Customer Number . . . . . . . . . . SOCustNumber. . . . . . . . . Account (297,20) Item/Bill Number. . . . . . . . . . . . ItemBillNumber. . . . . . . . Uppercase (317,30) Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (347,50) Link To First Detail Record . . . . . . LinkToFirstDetailRecord . . . Number [0] 6.0 U/M Conversion Factor. . . . . . . . . UMConversion. . . . . . . . . Number [1] 6.4 Qty Ordered . . . . . . . . . . . . . . QtyOrdered. . . . . . . . . . Number [2] 6.4 Yield Percentage. . . . . . . . . . . . YieldPercentage . . . . . . . Number [3] 3.3 Qty Planned . . . . . . . . . . . . . . QtyPlanned. . . . . . . . . . Number [4] 6.4 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [6] 0. Qty Complete. . . . . . . . . . . . . . QtyComplete . . . . . . . . . Number [7] 6.4 Qty Transfered To Another W/O . . . . . QtyTransferred. . . . . . . . Number [8] 6.4 Qty Scrapped. . . . . . . . . . . . . . QtyScrapped . . . . . . . . . Number [9] 6.4 Calculated Lead Time. . . . . . . . . . CalcLeadTime. . . . . . . . . Number [10] 4.0 Qty Completed Today . . . . . . . . . . QtyCompletedToday . . . . . . Number [11] 5.4 Standard Labor Cost . . . . . . . . . . StdLaborCost. . . . . . . . . Number [12] 7.2 Actual Labor Cost (JTD) . . . . . . . . ActualLaborCost . . . . . . . Number [13] 7.2 Standard Material Cost. . . . . . . . . StdMaterialCost . . . . . . . Number [14] 5.4 Actual Material Cost (JTD). . . . . . . ActualMaterialCost. . . . . . Number [15] 5.4 Standard Outside Process Cost . . . . . StdOutsideProcessCost . . . . Number [16] 7.2 Actual Outside Process Cost (JTD) . . . ActualOutsideProcessCost. . . Number [17] 7.2 Standard Fixed Overhead Cost. . . . . . StdFixedOverheadCost. . . . . Number [18] 7.2 Actual Fixed Overhead Cost (JTD). . . . ActualFixedOverheadCost . . . Number [19] 7.2 Standard Variable Overhead Cost . . . . StdVariableOverheadCost . . . Number [20] 7.2 Actual Variable Ovhd Cost (JTD) . . . . ActualVariableOvhdCost. . . . Number [21] 7.2 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [22] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [23] 0. ________ Total Bytes 637