WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: 1 Cost Ledger - Release Work Order Trans 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7)
" " First Step (Four Blanks). . . . FirstStep . . . . . . . . . . Zero-Filled *(8,4)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (12,5)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date (17,6)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (23,10)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
1=Release Work Order. . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (46,177)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [6] 0.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
There Are No Direct Costs . . . . . . . . . . . . . . . . . . . . . Memo
Associated With Releasing A Work. . . . . . . . . . . . . . . . . . Memo
Order. This Transaction Simply . . . . . . . . . . . . . . . . . . Memo
Records The Date. . . . . . . . . . . . . . . . . . . . . . . . . . Memo
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Other Transaction Types:. . . . . . . . . . . . . . . . . . . . . . Memo
2 = Material Issue. . . . . . . . . . . . . . . . . . . . . . . . . Memo
3 = Labor, 4 = Misc Labor . . . . . . . . . . . . . . . . . . . . . Memo
5 = Misc. Material Issue. . . . . . . . . . . . . . . . . . . . . . Memo
6 = Outside Processing. . . . . . . . . . . . . . . . . . . . . . . Memo
7 = Completion Record, 8 = Closing. . . . . . . . . . . . . . . . . Memo
A = Material Substitution . . . . . . . . . . . . . . . . . . . . . Memo
B/C = Material Issue Lot/Serial No. . . . . . . . . . . . . . . . . Memo
D/E = Completion Lot/Serial No. . . . . . . . . . . . . . . . . . . Memo
F = Labor Crew Transaction. . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 231
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: 2 Cost Ledger - Material Issue Record 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5)
Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
2=Material Issue. . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,20)
Warehouse . . . . . . . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3)
Unit Of Measure . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4)
Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String (73,30)
Seq Of Associated Type "A" Record . . . AssocSeqNum . . . . . . . . . Zero-Filled (103,5)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (108,55)
Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (163,30)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (193,30)
Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2
Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2
Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . Number [2] 7.2
Quantity. . . . . . . . . . . . . . . . Qty . . . . . . . . . . . . . Number [3] 6.4
Unit Of Measure Conversion Factor . . . UMConvFactor. . . . . . . . . Number [4] 6.4
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [6] 0.
________
Total Bytes 288
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: 3 Cost Ledger - Labor Transaction 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5)
Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
3=Labor Transaction . . . . . . . . . . . . . . . . . . . . . . . . Memo
Employee/Crew Division. . . . . . . . . EmployeeCrewDivision. . . . . String (46,2)
Blanks when Crew# is used below . . . . . . . . . . . . . . . . . . Memo
Employee/Crew Number. . . . . . . . . . EmployeeCrewNumber. . . . . . Uppercase (48,7)
When Crew#: "CREW000", 000=Crew# . . . . . . . . . . . . . . . . . Memo
Employee/Crew Name. . . . . . . . . . . EmployeeCrewName. . . . . . . String (55,30)
Start Date. . . . . . . . . . . . . . . StartDate . . . . . . . . . . Date (85,6)
Start Time ("##.###") . . . . . . . . . StartTime . . . . . . . . . . Uppercase (91,6)
Stop Date . . . . . . . . . . . . . . . StopDate. . . . . . . . . . . Date (97,6)
Stop Time ("##.###"). . . . . . . . . . StopTime. . . . . . . . . . . Uppercase (103,6)
Step Complete?. . . . . . . . . . . . . StepComplete. . . . . . . . . Yes/No (109,1)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (110,113)
Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2
Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2
Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . Number [2] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Quantity Complete . . . . . . . . . . . QtyComplete . . . . . . . . . Number [5] 6.4
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [6] 0.
________
Total Bytes 276
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: 4 Cost Ledger - Misc Mat'l Or Labor Charge 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5)
Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
4=Misc Labor Charge . . . . . . . . . . . . . . . . . . . . . . . . Memo
5=Misc Material Charge. . . . . . . . . . . . . . . . . . . . . . . Memo
Description Of Charge . . . . . . . . . Description . . . . . . . . . String (46,30)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (76,147)
Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2
Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2
Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . Number [2] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0.
________
Total Bytes 264
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: 6 Cost Ledger - Outside Processing Charge 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5)
Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
6=Outside Processing Charge . . . . . . . . . . . . . . . . . . . . Memo
Description Of Product Or Service . . . Description . . . . . . . . . String (46,30)
Vendor Division . . . . . . . . . . . . VendorDivision. . . . . . . . Zero-Filled (76,2)
Vendor Number . . . . . . . . . . . . . VendorNumber. . . . . . . . . Account (78,7)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (85,138)
Wip Direct Amount Debited . . . WipDirect . . . . . . . . . . Number [0] 7.2
Wip Fixed Overhead Amount Debited . . . WipFixedOvhd. . . . . . . . . Number [1] 7.2
Wip Variable Overhead Amt Debited . . . WipVariableOvhd . . . . . . . Number [2] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0.
________
Total Bytes 264
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: 7 Cost Ledger - Completion Transaction 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7)
"9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4)
"ZYYYY" To Force To End . . . . . . . . ForceToEndCodeClosing . . . . Uppercase *(12,5)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
7=Completion Transaction. . . . . . . . . . . . . . . . . . . . . . Memo
Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (46,1)
1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Complete To Order# (If 2 Or 3). . . . . CompleteToOrderNumber . . . . Uppercase (47,7)
Complete To Step # (If 3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (54,4)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (58,20)
Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (78,4)
Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (82,3)
Special Item Purchases Acct Debited . . SpecItemPurchsAcct. . . . . . G/L Account (85,9)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (94,23)
Original Item Unit Of Measure . . . . . OriginalItemUM. . . . . . . . Uppercase (117,4)
S/O Customer Division . . . . . . . . . CustomerDivision. . . . . . . Account (121,2)
S/O Customer Number . . . . . . . . . . SOCustomerNumber. . . . . . . Account (123,20)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (143,20)
Completed Item Number . . . . . . . . . CompletedItemNumber . . . . . Uppercase (163,30)
Original Item Number. . . . . . . . . . OrigItemNum . . . . . . . . . Uppercase (193,30)
Inventory/Spec Purch Amnt Debited . . . InvSpecPurchAmnt. . . . . . . Number [0] 7.2
Amount From Fixed Overhead. . . . . . . AmountFromFixedOverhead . . . Number [1] 7.2
Amount From Variable Overhead . . . . . AmountFromVariableOverhead. . Number [2] 7.2
Completed Quantity. . . . . . . . . . . Qty . . . . . . . . . . . . . Number [3] 6.4
Completed Item Unit Of Measure Conv . . UMConvFactor. . . . . . . . . Number [4] 4.0
Original Parent Quantity. . . . . . . . OriginalParentQty . . . . . . Number [5] 6.4
Original Parent Unit Of Measure Con . . OrigParentUMConv. . . . . . . Number [6] 4.0
________
Total Bytes 300
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: 8 Cost Ledger - Close Work Order Trans. 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7)
"9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4)
"ZZZZZ" To Force To End . . . . . . . . ForceToEndCodeClosing . . . . Uppercase *(12,5)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
8=Close Work Order Transaction. . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,177)
Direct Cost Amount Debited To Scrap . . DirectCostDebitToScrap. . . . Number [0] 7.2
Fixed Ovrhd Amount Debited To Scrap . . FixedOvrhdDebitedToScrap. . . Number [1] 7.2
Var Overhd Amount Debited To Scrap . . VarOverhdDebitedToScrap . . . Number [2] 7.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [6] 0.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
These Transactions Reflect The. . . . . . . . . . . . . . . . . . . Memo
Cost Removed From Wip When A. . . . . . . . . . . . . . . . . . . . Memo
Work Order Is Finally Closed. . . . . . . . . . . . . . . . . . . . Memo
If Any Amounts Remain In Wip, . . . . . . . . . . . . . . . . . . . Memo
They Are Credited To Wip And. . . . . . . . . . . . . . . . . . . . Memo
Debited To The W/O Scrap. . . . . . . . . . . . . . . . . . . . . . Memo
Account Defined In The Work . . . . . . . . . . . . . . . . . . . . Memo
Order Options.. . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 264
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: A Cost Ledger - Material Substitution Rec 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5)
Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
A=Material Subst Orig Item Number . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,20)
Issued Item Warehouse . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3)
Issued Item Unit Of Measure . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (73,20)
Original Item Warehouse Planned . . . . OrigItemWhsePlanned . . . . . Account (93,3)
Original Item Unit Of Measure . . . . . OrigItemUM. . . . . . . . . . Uppercase (96,4)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (100,3)
Seq Of Associated Type "2" Record . . . AssocSeqNum . . . . . . . . . Zero-Filled (103,5)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (108,55)
Issued Item Number. . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (163,30)
Original Item Number Planned. . . . . . OrigItemNumberPlanned . . . . String (193,30)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Issued Item Quantity. . . . . . . . . . Qty . . . . . . . . . . . . . Number [3] 6.4
Issued Item Unit Of Meas Convrsn. . . . UMConvFactor. . . . . . . . . Number [4] 6.4
Original Item Quantity Replaced . . . . OrigItemQtyReplaced . . . . . Number [5] 6.4
Original Item Unit Of Meas Convrsn. . . OrigItemUMConversion. . . . . Number [6] 6.4
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
This Transaction Stores What Was. . . . . . . . . . . . . . . . . . Memo
Originally Planned To Be Issued . . . . . . . . . . . . . . . . . . Memo
And What Was Substituted. . . . . . . . . . . . . . . . . . . . . . Memo
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
This Record Does Not Store Any. . . . . . . . . . . . . . . . . . . Memo
Cost Info. Cost Info Is Stored. . . . . . . . . . . . . . . . . . . Memo
In The Type 2 Record. . . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 279
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: B Cost Ledger - Material Issue Serial# 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5)
Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
"B" = Serial Number Record. . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,20)
Warehouse . . . . . . . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3)
Unit Of Measure . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4)
Serial Number . . . . . . . . . . . . . LotSerialNumber . . . . . . . String (73,15)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (88,75)
Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (163,30)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Quantity Of This Serial# Issued (=1). . Qty . . . . . . . . . . . . . Number [3] 6.4
Unit Of Measure Conversion Factor . . . UMConvFactor. . . . . . . . . Number [4] 6.4
Total Cost From This Serial#. . . . . . TotalCostLotSerial. . . . . . Number [5] 7.2
This record simply provides . . . . . . . . . . . . . . . . . . . . Memo
documentation of the serial number. . . . . . . . . . . . . . . . . Memo
that was issued to the work order . . . . . . . . . . . . . . . . . Memo
The costs in these records support. . . . . . . . . . . . . . . . . Memo
the costs that are saved in the Materi. . . . . . . . . . . . . . . Memo
Issue Type 2 record.. . . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 265
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: C Cost Ledger - Material Issue Lot# 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5)
Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
"C" = Lot Number Record . . . . . . . . . . . . . . . . . . . . . . Memo
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (46,20)
Warehouse . . . . . . . . . . . . . . . WhseNumber. . . . . . . . . . Account (66,3)
Unit Of Measure . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase (69,4)
Lot Number. . . . . . . . . . . . . . . LotSerialNumber . . . . . . . String (73,15)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (88,75)
Item Number1. . . . . . . . . . . . . . ItemNumber1 . . . . . . . . . Uppercase (163,30)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Quantity Of This Lot/Serial# Issued . . Qty . . . . . . . . . . . . . Number [3] 6.4
Unit Of Measure Conversion Factor . . . UMConvFactor. . . . . . . . . Number [4] 6.4
Total Cost From This Lot/Ser. . . . . . TotalCostLotSerial. . . . . . Number [5] 7.2
This record simply provides . . . . . . . . . . . . . . . . . . . . Memo
documentation of the Lot numbers. . . . . . . . . . . . . . . . . . Memo
that were used in the Work Order. . . . . . . . . . . . . . . . . . Memo
The costs in these records support. . . . . . . . . . . . . . . . . Memo
the costs that are saved in . . . . . . . . . . . . . . . . . . . . Memo
the Material Issue Type 2 record. . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 265
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: D Cost Ledger - Completion Serial Number 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7)
"9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4)
"ZZYYY" To Force To End (After Comp . . ForceToEndCodeClosing . . . . Uppercase *(12,5)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5)
Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
"D" = Completion Serial Number. . . . . . . . . . . . . . . . . . . Memo
Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (46,1)
1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Complete To Order# (If 2 Or 3). . . . . CompleteToOrderNumber . . . . Uppercase (47,7)
Complete To Step # (If 3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (54,4)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (58,20)
Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (78,4)
Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (82,3)
Starting Serial Number. . . . . . . . . StartingLotSerNumber. . . . . Uppercase (85,15)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (100,63)
Completed Item Number . . . . . . . . . CompletedItemNumber . . . . . Uppercase (163,30)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Completed Quantity Serial# (=1) . . . . Qty . . . . . . . . . . . . . Number [3] 6.4
Completed Item Unit Of Measure Conv . . UMConvFactor. . . . . . . . . Number [4] 6.4
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [6] 0.
This transactions reflects the actual . . . . . . . . . . . . . . . Memo
serial number records created or. . . . . . . . . . . . . . . . . . Memo
added to when completing to I/M . . . . . . . . . . . . . . . . . . Memo
for Stock, S/O, or W/O. . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 255
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: E Cost Ledger - Completion Lot Number 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase *(1,7)
"9999" Last Step. . . . . . . . . . . . LastStepCode. . . . . . . . . Zero-Filled *(8,4)
"ZZYYY" To Force To End (After Comp . . ForceToEndCodeClosing . . . . Uppercase *(12,5)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (23,10)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled (33,5)
Transaction Number From WOR File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
"E" = Completion Lot Number . . . . . . . . . . . . . . . . . . . . Memo
Complete To . . . . . . . . . . . . . . CompleteToStock . . . . . . . String (46,1)
1=Stock . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
2=Sales Order . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
3=Work Order. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
4=Scrap . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
Complete To Order# (If 2 Or 3). . . . . CompleteToOrderNumber . . . . Uppercase (47,7)
Complete To Step # (If 3) . . . . . . . CompleteToStepNumber. . . . . Zero-Filled (54,4)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (58,20)
Completed Item Unit Of Measure. . . . . CompletedItemUM . . . . . . . Uppercase (78,4)
Completed Item Warehouse. . . . . . . . CompletedItemWhse . . . . . . Uppercase (82,3)
Starting Lot Number . . . . . . . . . . StartingLotSerNumber. . . . . Uppercase (85,15)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (100,63)
Completed Item Number1. . . . . . . . . CompletedItemNumber1. . . . . Uppercase (163,30)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (193,30)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Completed Quantity This Lot#. . . . . . Qty . . . . . . . . . . . . . Number [3] 6.4
Completed Item Unit Of Measure Conv . . UMConvFactor. . . . . . . . . Number [4] 6.4
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [6] 0.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
This transaction reflects the actual. . . . . . . . . . . . . . . . Memo
Lot# records created or added to. . . . . . . . . . . . . . . . . . Memo
when completing to IM for Stock,. . . . . . . . . . . . . . . . . . Memo
S/O, or W/O.. . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 255
WO9 Work Order Cost Ledger (WO9_WorkOrderCostLedger) Level: 4.40
Record Type: F Cost Ledger - Labor Transaction Crew Rec 08/28/2009
File Type: Direct Key Size: 37 Rec Len: 316 Min Len: 222 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)
Transaction Date. . . . . . . . . . . . TransDate . . . . . . . . . . Date *(17,6)
Work Center Where Activ Took Place. . . WorkCenter. . . . . . . . . . Uppercase *(23,5)
Oper Code Actually Performed. . . . . . OperationCode . . . . . . . . Uppercase *(28,5)
Sequence Number . . . . . . . . . . . . SeqNumber . . . . . . . . . . Zero-Filled *(33,5)
Transaction Number From Wor File. . . . TransNumber . . . . . . . . . Uppercase (38,7)
Transaction Type. . . . . . . . . . . . TransType . . . . . . . . . . Uppercase (45,1)
F=Crew Name/Time Record . . . . . . . . . . . . . . . . . . . . . . Memo
Crew Number (CREW000, 000=Crew#). . . . CrewNumber. . . . . . . . . . Uppercase (46,9)
Crew Member Employee Division . . . . . CrewEmpDivision . . . . . . . Zero-Filled (55,2)
Crew Member Employee Number . . . . . . CrewMemberEmployeeNo. . . . . Account (57,7)
Crew Member Employee Name . . . . . . . CrewMemberName. . . . . . . . String (64,30)
Crew Member Start Date. . . . . . . . . CrewMemberStartDate . . . . . Date (94,6)
Crew Member Start Time ("##.###") . . . CrewMemberStartTime . . . . . Uppercase (100,6)
Crew Member Stop Date . . . . . . . . . CrewMemberStopDate. . . . . . Date (106,6)
Crew Member Stop Time ("##.###") . . . CrewMemberStopTime. . . . . . Uppercase (112,6)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (118,105)
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0.
Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0.
Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2] 0.
Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3] 0.
Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4] 0.
Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5] 0.
Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [6] 0.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
This Transaction Stores The Time. . . . . . . . . . . . . . . . . . Memo
For An Individual Crew Member . . . . . . . . . . . . . . . . . . . Memo
That Worked On A Work Order.. . . . . . . . . . . . . . . . . . . . Memo
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Memo
All Costs Are Stored In . . . . . . . . . . . . . . . . . . . . . . Memo
Transaction Type 3 Record.. . . . . . . . . . . . . . . . . . . . . Memo
________
Total Bytes 231