WO_01 W/O Auto Issue Material Shortage File (WO_01AutoIssue) Level: 4.40
Record Type: 1 Work Order Sort 08/28/2009
File Type: Direct Key Size: 45 Rec Len: 106 Min Len: 65 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"1" - Prefix. . . . . . . . . . . . . RecordType. . . . . . . . . . Uppercase *(1,1)
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase *(2,7)
Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase *(9,30)
Warehouse . . . . . . . . . . . . . . . Warehouse . . . . . . . . . . Account *(39,3)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(42,4)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,20)
Quantity Required . . . . . . . . . . . QtyRequired . . . . . . . . . Number [0] 6.4
Quantity Issued . . . . . . . . . . . . QtyIssued . . . . . . . . . . Number [1] 6.4
Quantity Short. . . . . . . . . . . . . QtyShort. . . . . . . . . . . Number [2] 6.4
________
Total Bytes 106
WO_01 W/O Auto Issue Material Shortage File (WO_01AutoIssue) Level: 4.40
Record Type: 2 Component Item Sort 08/28/2009
File Type: Direct Key Size: 45 Rec Len: 106 Min Len: 65 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
"2" - Prefix. . . . . . . . . . . . . RecordType. . . . . . . . . . Uppercase *(1,1)
Component Item Number . . . . . . . . . ComponentItemNo . . . . . . . Uppercase *(2,30)
Warehouse . . . . . . . . . . . . . . . Warehouse . . . . . . . . . . Account *(32,3)
Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase *(35,7)
Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled *(42,4)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (46,20)
Quantity Required . . . . . . . . . . . QtyRequired . . . . . . . . . Number [0] 6.4
Quantity Issued . . . . . . . . . . . . QtyIssued . . . . . . . . . . Number [1] 6.4
Quantity Short. . . . . . . . . . . . . QtyShort. . . . . . . . . . . Number [2] 6.4
________
Total Bytes 106