WOL Work Order History - Header Information (WOL_WorkOrderHistoryHeader) Level: 4.40 Record Type: 1 Work Order History Header Record 08/28/2009 File Type: Direct Key Size: 10 Rec Len: 590 Min Len: 342 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(8,3) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (11,20) Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String (31,30) Um. . . . . . . . . . . . . . . . . . . UM. . . . . . . . . . . . . . Uppercase (61,4) Bill Revision Code. . . . . . . . . . . BillRevisionCode. . . . . . . Uppercase (65,3) Bill Options. . . . . . . . . . . . . . BillOptions . . . . . . . . . Uppercase (68,18) Effective Date. . . . . . . . . . . . . EffectiveDate . . . . . . . . Date (86,6) Routing Number. . . . . . . . . . . . . RoutingNumber . . . . . . . . Uppercase (92,20) Issue Method (A/B/M). . . . . . . . . . IssueMethod . . . . . . . . . Uppercase (112,1) Auto, Backflush, Manual . . . . . . . . . . . . . . . . . . . . . . Memo User Defined Field 1. . . . . . . . . . UserDefinedField1 . . . . . . String (113,10) User Defined Field 2. . . . . . . . . . UserDefinedField2 . . . . . . String (123,10) User Defined Field 3. . . . . . . . . . UserDefinedField3 . . . . . . String (133,10) User Defined Field 4. . . . . . . . . . UserDefinedField4 . . . . . . String (143,10) Planner Code. . . . . . . . . . . . . . PlannerCode . . . . . . . . . Uppercase (153,3) Copy From Template Number . . . . . . . CopyFromTemplate. . . . . . . Zero-Filled (156,7) Make For (IM, WO, SO) . . . . . . . . . MakeFor . . . . . . . . . . . Uppercase (163,1) Make For Order Number . . . . . . . . . MakeForOrderNumber. . . . . . Uppercase (164,7) Parent Warehouse. . . . . . . . . . . . ParentWhse. . . . . . . . . . Account (171,3) Component Warehouse . . . . . . . . . . ComponentWhse . . . . . . . . Account (174,3) W/O Date Created. . . . . . . . . . . . WODateCreated . . . . . . . . Date (177,6) W/O Due Date. . . . . . . . . . . . . . WODueDate . . . . . . . . . . Date (183,6) Scheduled Release Date. . . . . . . . . SchedRelDate. . . . . . . . . Date (189,6) Actual Production Start Date. . . . . . ActualProdStartDate . . . . . Date (195,6) Last Activity Date. . . . . . . . . . . LastActivityDate. . . . . . . Date (201,6) Last Reschedule Date. . . . . . . . . . LastReschedDate . . . . . . . Date (207,6) Prior Due Date (B/R Last Resched) . . . PriorDueDate. . . . . . . . . Date (213,6) User Who Performed Last Resched . . . . UserWhoLastResched. . . . . . Uppercase (219,3) Status Comment Field. . . . . . . . . . StatusCommentField. . . . . . String (222,30) Closed Date . . . . . . . . . . . . . . ClosedDate. . . . . . . . . . Date (252,6) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (258,9) Cost Completion Method. . . . . . . . . CostCmplMthd. . . . . . . . . Uppercase (267,1) A=Actual, P=Planned. . . . . . . . . . . . . . . . . . . . . . . . Memo L=Lower of Actual or Planned. . . . . . . . . . . . . . . . . . . . Memo Auto Issue Material Trans (Y/N/A) . . . AutoIssueMatlTran . . . . . . Uppercase (268,1) Y=Yes, N=No, A=Available. . . . . . . . . . . . . . . . . . . . . . Memo Avail issues no more than QOH . . . . . . . . . . . . . . . . . . . Memo Auto Gen Labor Tran . . . . . . . . . . AutoGenLabTran. . . . . . . . Yes/No (269,1) No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo Auto Gen Outside Proc Tran. . . . . . . AutoGenOutsProcTran . . . . . Yes/No (270,1) No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo S/O Customer Division . . . . . . . . . CustomerDivision. . . . . . . Account (271,2) S/O Customer Number . . . . . . . . . . SOCustNumber. . . . . . . . . Account (273,20) Item/Bill Number. . . . . . . . . . . . ItemBillNumber. . . . . . . . Uppercase (293,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (323,20) U/M Conversion Factor . . . . . . . . . UMConversion. . . . . . . . . Number [0] 6.4 Qty Ordered . . . . . . . . . . . . . . QtyOrdered. . . . . . . . . . Number [1] 6.4 Yield Percentage. . . . . . . . . . . . YieldPercentage . . . . . . . Number [2] 3.4 Qty Planned . . . . . . . . . . . . . . QtyPlanned. . . . . . . . . . Number [3] 6.4 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [4] 0. Qty Complete. . . . . . . . . . . . . . QtyComplete . . . . . . . . . Number [5] 6.4 Qty Transferred To Another W/O. . . . . QtyTransferred. . . . . . . . Number [6] 6.4 Qty Scrapped. . . . . . . . . . . . . . QtyScrapped . . . . . . . . . Number [7] 6.4 Calculated Lead Time. . . . . . . . . . CalcLeadTime. . . . . . . . . Number [8] 4.0 Standard Labor Cost . . . . . . . . . . StdLaborCost. . . . . . . . . Number [9] 7.2 Actual Labor Cost . . . . . . . . . . . ActualLaborCost . . . . . . . Number [10] 7.2 Standard Material Cost. . . . . . . . . StdMaterialCost . . . . . . . Number [11] 7.2 Actual Material Cost. . . . . . . . . . ActualMaterialCost. . . . . . Number [12] 7.2 Standard Outside Process Cost . . . . . StdOutsideProcessCost . . . . Number [13] 7.2 Actual Outside Process Cost . . . . . . ActualOutsideProcessCost. . . Number [14] 7.2 Standard Fixed Overhead Cost. . . . . . StdFixedOHCost. . . . . . . . Number [15] 7.2 Actual Fixed Overhead Cost. . . . . . . ActualFixedOverheadCost . . . Number [16] 7.2 Standard Variable Overhead Cost . . . . StdVariableOverheadCost . . . Number [17] 7.2 Actual Variable Overhead Cost . . . . . ActualVariableOHCost. . . . . Number [18] 7.2 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [19] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [20] 0. ________ Total Bytes 562