     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