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