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