MP_04 Supplies And Demands File (MP_04SuppliesAndDemands) Level: 4.40
Record Type: 1 Supplies And Demands File 08/28/2009
File Type: Mkeyed Key Size: 58 Rec Len: 365 Min Len: 273 Define: Y
Main Key (KNO=0)ItemNumber(134,30)+WarehouseGroup(16,3)+RequiredDate(19,6)+Type(25,2)+DemandWO_SO_PO(27,7
2nd Key (KNO=1) TopLevelItemNumber(194,30)+TopLevelSO(99,7)+TopLevelWO(106,7)+RequiredDate(19,6)+Sequence
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (1,15)
Warehouse Group . . . . . . . . . . . . WarehouseGroup. . . . . . . . Uppercase (16,3)
Required Date . . . . . . . . . . . . . RequiredDate. . . . . . . . . Date (19,6)
Type. . . . . . . . . . . . . . . . . . Type. . . . . . . . . . . . . Uppercase (25,2)
Demand WO/SO/PO . . . . . . . . . . . . DemandWO_SO_PO. . . . . . . . Uppercase (27,7)
Sequence Number . . . . . . . . . . . . SequenceNumber. . . . . . . . Zero-Filled (34,10)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (44,15)
Supply WO # . . . . . . . . . . . . . . SupplyWO_Number . . . . . . . Uppercase (59,7)
Supply On Date. . . . . . . . . . . . . SupplyOnDate. . . . . . . . . Date (66,6)
Action. . . . . . . . . . . . . . . . . Action. . . . . . . . . . . . Uppercase (72,8)
Action Required Date. . . . . . . . . . ActionRequiredDate. . . . . . Date (80,6)
New Required Date . . . . . . . . . . . NewRequiredDate . . . . . . . Date (86,6)
Line Number/Step Number . . . . . . . . LineNumber_StepNumber . . . . Zero-Filled (92,6)
SO or WO. . . . . . . . . . . . . . . . SO_Or_WO. . . . . . . . . . . Uppercase (98,1)
Top Level SO. . . . . . . . . . . . . . TopLevelSO. . . . . . . . . . Uppercase (99,7)
Top Level WO. . . . . . . . . . . . . . TopLevelWO. . . . . . . . . . Uppercase (106,7)
Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (113,15)
Scheduled Lock. . . . . . . . . . . . . ScheduledLock . . . . . . . . Yes/No (128,1)
Bill Revision . . . . . . . . . . . . . BillRevision. . . . . . . . . Zero-Filled (129,3)
Bill Explosion Level. . . . . . . . . . BillExplosionLevel. . . . . . Zero-Filled (132,2)
Item Number . . . . . . . . . . . . . . ItemNumber. . . . . . . . . . Uppercase (134,30)
Where Used. . . . . . . . . . . . . . . WhereUsed . . . . . . . . . . Uppercase (164,30)
Top Level Item Number . . . . . . . . . TopLevelItemNumber. . . . . . Uppercase (194,30)
Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (224,50)
Supply/Demand . . . . . . . . . . . . . Supply_Demand . . . . . . . . Number [0] 8.3
Issued/Supplied . . . . . . . . . . . . Issued_Supplied . . . . . . . Number [1] 8.3
Projected On Hand . . . . . . . . . . . ProjectedOnHand . . . . . . . Number [2] 8.3
Quantity Manufacture. . . . . . . . . . QuantityManufacture . . . . . Number [3] 8.3
Quantity Buy. . . . . . . . . . . . . . QuantityBuy . . . . . . . . . Number [4] 8.3
WO Issue Number . . . . . . . . . . . . WO_IssueNumber. . . . . . . . Number [5] 7.0
WO Parent Issue Number. . . . . . . . . WO_ParentIssueNumber. . . . . Number [6] 7.0
________
Total Bytes 365