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