WOJ W/O WIP Cost File (WOJ_WIPCostFile) Level: 4.40 Record Type: 1 WIP Summary By Operation Code 08/28/2009 File Type: Direct Key Size: 26 Rec Len: 173 Min Len: 40 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase *(17,5) Operation Code. . . . . . . . . . . . . OpCode. . . . . . . . . . . . Uppercase *(22,5) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (27,1) Record Type "1". . . . . . . . . . . . RecordType. . . . . . . . . . Uppercase (28,1) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (29,12) WIP Direct Matrl Amount Debited . . . WipDirectMaterialDebit. . . . Number [0] 7.2 WIP Direct Labor Amount Debited . . . WipDirectLaborDebit . . . . . Number [1] 7.2 WIP Direct Outside Proc Debited . . . WipDirectOutsideProcDebit . . Number [2] 7.2 WIP Fixed Overhead Amount Debited . . . WipFixedOverheadDebit . . . . Number [3] 7.2 WIP Variable Overhead Amt Debited . . . WipVariableOverheadDebit. . . Number [4] 7.2 Above 5 Fields Come From Cost . . . . . . . . . . . . . . . . . . . Memo Transactions (Mat Iss, Labor...). . . . . . . . . . . . . . . . . . Memo WIP Direct Matrl Amount Credited. . . WipDirectMaterial . . . . . . Number [5] 7.2 WIP Direct Labor Amount Credited. . . WipDirectLabor. . . . . . . . Number [6] 7.2 WIP Outside Proc Amount Credited. . . WipOutsideProc. . . . . . . . Number [7] 7.2 WIP Fixed Ovhd Amount Credited. . . WipFixedOvhd. . . . . . . . . Number [8] 7.2 WIP Var Ovhd Amount Credited. . . WipVarOvhd. . . . . . . . . . Number [9] 7.2 Above 5 Fields Come From Compltn. . . . . . . . . . . . . . . . . . Memo And Close Transactions. . . . . . . . . . . . . . . . . . . . . . . Memo Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [10] 0. ________ Total Bytes 163
WOJ W/O WIP Cost File (WOJ_WIPCostFile) Level: 4.40 Record Type: 2 Temp Record In Copy_WOJ For Comp Qty 08/28/2009 File Type: Direct Key Size: 26 Rec Len: 173 Min Len: 40 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Work Order Step (= blanks) . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix (= blanks)SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix (= blanks)SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Work Center (= blanks)WorkCenter. . . . . . . . . . Uppercase *(17,5) Operation Code (= blanks) OpCode. . . . . . . . . . . . Uppercase *(22,5) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (27,1) Record Type "2". . . . . . . . . . . . RecordType. . . . . . . . . . Uppercase (28,1) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (29,12) A Copy Of The W/O Header Record . . . . . . . . . . . . . . . . . . Memo (WO1) With Just Planned, Complt . . . . . . . . . . . . . . . . . . Memo And Scrapped Qtys. Updated In . . . . . . . . . . . . . . . . . . . Memo Pre-Update By Completions . . . . . . . . . . . . . . . . . . . . . Memo Quantity Planned. . . . . . . . . . . . QtyPlanned. . . . . . . . . . Number [0] 6.4 WO1 U/M Conversion Factor . . . . . . . WO1_UM_ConversionFactor . . . Number [1] 6.4 Quantity Completed. . . . . . . . . . . QtyCompleted. . . . . . . . . Number [2] 6.4 Total From WO1 Plus . . . . . . . . . . . . . . . . . . . . . . . . Memo Current Completion Transactions . . . . . . . . . . . . . . . . . . Memo Quantity Scrapped . . . . . . . . . . . QtyScrapped . . . . . . . . . Number [3] 6.4 Total From WO1 Plus . . . . . . . . . . . . . . . . . . . . . . . . Memo Current Completion Transactions . . . . . . . . . . . . . . . . . . Memo Quantity Transfered . . . . . . . . . . QtyTransferred. . . . . . . . Number [4] 6.4 Total From WO1 Plus . . . . . . . . . . . . . . . . . . . . . . . . Memo Current Completion Transactions . . . . . . . . . . . . . . . . . . Memo Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [10] 0. ________ Total Bytes 113
WOJ W/O WIP Cost File (WOJ_WIPCostFile) Level: 4.40 Record Type: 3 Temp Record In Copy_WOJ For Labor Time 08/28/2009 File Type: Direct Key Size: 26 Rec Len: 173 Min Len: 40 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7) Step Number . . . . . . . . . . . . . . WorkOrderStep . . . . . . . . Zero-Filled *(8,4) Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase *(12,1) Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled *(13,4) Work Center (= blanks)WorkCenter. . . . . . . . . . Uppercase *(17,5) Operation Code (= blanks)OpCode. . . . . . . . . . . . Uppercase *(22,5) Step Complete?. . . . . . . . . . . . . StepComplete. . . . . . . . . Yes/No (27,1) Record Type "3". . . . . . . . . . . . RecordType. . . . . . . . . . String (28,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (29,12) A Copy Of The W/O Step Record . . . . . . . . . . . . . . . . . . . Memo (WO3) With Just Planned And . . . . . . . . . . . . . . . . . . . . Memo Actual Run Times. Updated In. . . . . . . . . . . . . . . . . . . . Memo Pre-Update By Labor Trans . . . . . . . . . . . . . . . . . . . . . Memo Extended Standard Time. . . . . . . . . ExtendedStdTime . . . . . . . Number [0] 6.3 Actual Time . . . . . . . . . . . . . . ActualTime. . . . . . . . . . Number [1] 6.3 Total From WO3 Plus . . . . . . . . . . . . . . . . . . . . . . . . Memo Current Labor Transactions. . . . . . . . . . . . . . . . . . . . . Memo Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [2] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [3] 0. Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [4] 0. Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [5] 0. Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [6] 0. Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [7] 0. Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [8] 0. Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [9] 0. Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [10] 0. ________ Total Bytes 75