WON Work Order History Line Detail (WON_HistoryLineDetail) Level: 4.40
Record Type: 1 Routing (Step) Detail 08/28/2009
File Type: Direct Key Size: 44 Rec Len: 412 Min Len: 188 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7)
Work Order Header Sequence. . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3)
Record Type "R" For Routing . . . . . . RecordType. . . . . . . . . . Uppercase *(11,1)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(12,4)
Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(16,1)
Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(17,4)
Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase *(21,5)
Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase *(26,5)
Key Blanks. . . . . . . . . . . . . . . KeyBlanks . . . . . . . . . . String *(31,14)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (45,16)
Sytext Description? (Y/N) . . . . . . . SytextDesc. . . . . . . . . . Yes/No (61,1)
Std Run Time Type (Loh) . . . . . . . . StdRunTimeType. . . . . . . . Uppercase (62,1)
(Lot, Operatns/Hr, Hours/Operatn) . . . . . . . . . . . . . . . . . Memo
Parent Item Type (O/P). . . . . . . . . ParentItemType. . . . . . . . Uppercase (63,1)
(Operation/Parent, Parents/Op). . . . . . . . . . . . . . . . . . . Memo
Tooling Number. . . . . . . . . . . . . ToolingNumber . . . . . . . . Uppercase (64,20)
Scheduled Start Date. . . . . . . . . . SchedStartDat . . . . . . . . Date (84,6)
Scheduled Completion Date . . . . . . . SchedCompDate . . . . . . . . Date (90,6)
Actual Start Date . . . . . . . . . . . ActualStartDate . . . . . . . Date (96,6)
Last Activity Date. . . . . . . . . . . LastActivityDate. . . . . . . Date (102,6)
Step Complete? (Y/N). . . . . . . . . . StepComplete. . . . . . . . . Yes/No (108,1)
Step Description. . . . . . . . . . . . StepDescription . . . . . . . String (109,30)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (139,50)
Schedule Overlap Percent. . . . . . . . SchedOverlapPcnt. . . . . . . Number [0] 3.0
Std Run Time - Lot: Hours/Lot . . . . . StdRunTimeLot . . . . . . . . Number [1] 7.2
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
- Opertns/Hr: Cycles/Hour. . . . . . . . . . . . . . . . . . . . . Memo
- Hrs/Opertn: Hours/Cycle. . . . . . . . . . . . . . . . . . . . . Memo
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Parent Qty Factor . . . . . . . . . . . ParentQtyFactor . . . . . . . Number [2] 5.0
Extended Standard Time. . . . . . . . . ExtdStdTime . . . . . . . . . Number [3] 6.3
Op Cycles Planned For This Step . . . . OpCyclesPlannedThisStep . . . Number [4] 6.3
Actual Run Time (Jtd) . . . . . . . . . ActualRunTime . . . . . . . . Number [5] 6.3
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [6] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [7] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [8] 0.
Qty Completed . . . . . . . . . . . . . QtyCompleted. . . . . . . . . Number [9] 6.4
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [10] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [11] 0.
Standard Labor Cost For This Step . . . StdLaborCostThisStep. . . . . Number [12] 7.2
Std Material Cost . . . . . . . . . . . StdMaterialCost . . . . . . . Number [13] 7.2
Std Outside Processing Cost . . . . . . StdOutsideProcessCost . . . . Number [14] 7.2
Std Fixed Overhead Cost . . . . . . . . StdFixedOverheadCost. . . . . Number [15] 7.2
Std Variable Overhead Cost. . . . . . . StdVariableOverheadCost . . . Number [16] 7.2
Actual Labor Cost For This Step . . . . ActualLaborCost . . . . . . . Number [17] 7.2
Actual Material Cost. . . . . . . . . . ActualMaterialCost. . . . . . Number [18] 7.2
Actual Outside Processing Cost. . . . . ActualOutsideProcessCost. . . Number [19] 7.2
Actual Fixed Overhead Cost. . . . . . . ActualFixedOverheadCost . . . Number [20] 7.2
Actual Variable Overhead Cost . . . . . ActualVariableOHCost. . . . . Number [21] 7.2
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [22] 0.
Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [23] 0.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Only The Routing Steps In The . . . . . . . . . . . . . . . . . . . Memo
Work Order Accumulate The Costs.. . . . . . . . . . . . . . . . . . Memo
The Material Steps Are For. . . . . . . . . . . . . . . . . . . . . Memo
Indicating What Materials Were. . . . . . . . . . . . . . . . . . . Memo
Needed And Are Not Used To. . . . . . . . . . . . . . . . . . . . . Memo
Accumulate Costs Or Times.. . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 392
WON Work Order History Line Detail (WON_HistoryLineDetail) Level: 4.40
Record Type: 2 Work Order Material Line Detail 08/28/2009
File Type: Direct Key Size: 44 Rec Len: 412 Min Len: 188 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7)
Work Order Header Sequence. . . . . . . WOHeaderSeq . . . . . . . . . Zero-Filled *(8,3)
Record Type "M" For Material. . . . . . RecordType. . . . . . . . . . Uppercase *(11,1)
Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase *(12,30)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(42,3)
Revision. . . . . . . . . . . . . . . . Revision. . . . . . . . . . . Uppercase (45,3)
Step Number . . . . . . . . . . . . . . MaterialStepNumber. . . . . . Zero-Filled (48,4)
U/M . . . . . . . . . . . . . . . . . . UM. . . . . . . . . . . . . . Uppercase (52,4)
Item Description (Blank = CI_Item Desc) ItemDescription . . . . . . . String (56,30)
Warehouse . . . . . . . . . . . . . . . Whse. . . . . . . . . . . . . Account (86,3)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (89,100)
Qty/Parent. . . . . . . . . . . . . . . QtyParent . . . . . . . . . . Number [0] 6.4
U/M Conversion Factor . . . . . . . . . UMConvFctr. . . . . . . . . . Number [1] 6.4
Unit Cost (Specials Only) . . . . . . . UnitCost. . . . . . . . . . . Number [2] 5.4
Scrap Percent . . . . . . . . . . . . . ScrapPercent. . . . . . . . . Number [3] 3.4
Extended Qty Required . . . . . . . . . ExtdQtyRequired . . . . . . . Number [4] 6.4
Qty Issued. . . . . . . . . . . . . . . QtyIssued . . . . . . . . . . Number [5] 6.4
Direct Costs Incurred . . . . . . . . . DirectCostsIncurred . . . . . Number [6] 7.2
Fixed Overhead Costs Incurred . . . . . FixedOverheadCostsIncurred. . Number [7] 7.2
Variable Overhead Costs Incurred. . . . VariableOHCostsIncurred . . . Number [8] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [9] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [10] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [11] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [12] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [13] 0.
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [14] 0.
Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [15] 0.
Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [16] 0.
Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [17] 0.
Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [18] 0.
Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [19] 0.
Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [20] 0.
Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [21] 0.
Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [22] 0.
Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [23] 0.
________
Total Bytes 315