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