     PO_MaterialReqDetail               PO Material Requisition Detail     Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: PO_MaterialReqDetail_bus
     SQL Def: Y  SysDB: N                                  "MAS_"+%C$+"/PO"+%C$+"/PO_MaterialReqDetail.M4T"

     KPRIMARY: IssueType+IssueNo+LineKey
     KDISPLAY: IssueType+IssueNo+LineSeqNo+LineKey
     KITEMWHSE: ItemCode+WarehouseCode+IssueType+IssueNo+LineKey
     KEXTENDEDDESC: ExtendedDescriptionKey+IssueType+IssueNo+LineKey

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  IssueType . . . . . . . . . .     1 SYY  Issue Type. . . . . . . . . . .
                                                    Read Only:Y DfltVal:M
                                                    Valid:M Notes: {POI$(1,1)}
       2  IssueNo . . . . . . . . . . .     6 SYY  Issue Number. . . . . . . . . .ISSUENO
                                                    Read Only:Y FmtType:CHARNUM
                                                    Notes: {POI$(2,6)}
       3  LineKey . . . . . . . . . . .     6 SNY  LineKey . . . . . . . . . . . .
                                                    Read Only:Y Mask:000000
                                                    FmtType:ZEROFILL
       4  LineSeqNo . . . . . . . . . .    14 SNY  Line Sequence Number. . . . . .
                                                    Read Only:Y Mask:000000000000
                                                    00 FmtType:ZEROFILL
       5  ItemCode. . . . . . . . . . .    30 SYY  Item Code . . . . . . . . . . .ITEMCODE
                                                    Notes: {POI$(8,15)}
       6  ExtendedDescriptionKey. . . .    10 SNN  Extended Description Key. . . .EXTDESCKEY
                                                    Read Only:Y ValGroup:NotComme
                                                    nt,ItemRequired
       7  ItemType. . . . . . . . . . .     1 SYY  Item Type . . . . . . . . . . .
                                                    Read Only:Y DfltVal:1
                                                    Valid:1,2,3,4,5 Notes:
                                                    {POI$(28,1)}1=Regular Item,
                                                    2=Special Item, 3=Charge
                                                    Item, 4=Comment Item,
                                                    5=Miscellaneous Item
       8  ItemCodeDesc. . . . . . . . .    30 SNN  Item Code Description . . . . .DESCRIPTION
                                                    ValGroup:NotComment,
                                                    ItemRequired
       9  RequiredDate. . . . . . . . .     8 SNN  Required Date . . . . . . . . .DATE
                                                    ValGroup:NotComment,
                                                    ItemRequired,NotCharge
                                                    Notes: {POI$(30,6)}
      10  MaterialReqExpAcctKey . . . .     9 SYN  Material Requisition Expense AcACCOUNT
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired Notes:
                                                    {POI$(60,9)}
      11  Valuation . . . . . . . . . .     1 SYN  Valuation . . . . . . . . . . .
                                                    Read Only:Y Valid:1,2,3,4,5,
                                                    6 Notes: {POI$(77,1)}1=Stand
                                                    ard, 2=Average, 3=Fifo,
                                                    4=Lifo, 5=Lot, 6=Serial
      12  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .UNITOFMEASURE
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired,
                                                    ItemTypes Notes: {POI$(78,4)}
      13  WarehouseCode . . . . . . . .     3 SYN  Warehouse Code. . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:IMIntegrated,
                                                    NotComment,MultiWarehouse,
                                                    ItemRequired,RegularItem,
                                                    NotNulWarehouseCode Notes:
                                                    {POI$(82,3)}
      14  LotSerialFullyDistributed . .     1 SYN  Lot Serial Fully DistribributedYESNO
                                                    DfltVal:Y Valid:Y,N
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired Notes:
                                                    {POI$(85,1)}
      15  OrderWarehouseCode. . . . . .     3 SYN  Order Warehouse . . . . . . . .WAREHOUSE
                                                    FmtType:CHARNUM ValGroup:IMIn
                                                    tegrated,NotComment,
                                                    MultiWarehouse,ItemRequired,
                                                    RegularItem,NotNulWarehouseCo
                                                    de Notes: {POI$(86,3)}
      16  ProductLine . . . . . . . . .     4 SYN  Product Line. . . . . . . . . .PRODUCTLINE
                                                    Read Only:Y FmtType:CHARNUM
                                                    Notes: {POI$(89,4)}
      17  OrderLineKey. . . . . . . . .     6 SNN  Order Line Key. . . . . . . . .
                                                    Mask:000000 FmtType:ZEROFILL
                                                    ValGroup:NotComment Notes:
                                                    {POI$(93,5)}
      18  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM DepVal:REQUIR
                                                    ED ValGroup:JCIntegrated,
                                                    ItemRequired Notes:
                                                    {POI$(100,7)}
      19  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo,ItemRequired
                                                    Notes: {POI$(107,9)}
      20  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .COSTTYPE
                                                    DepVal:REQUIRED ValGroup:JCIn
                                                    tegrated,JobNo,ItemRequired
                                                    Notes: {POI$(116,1)}
      21  VendorAliasItemNo . . . . . .    30 SYN  Vendor Alias Item Number. . . .
                                                    DepVal:REQUIRED ValGroup:NotC
                                                    omment,ItemRequired,
                                                    RegularItem Notes: {POI$(127,
                                                    30)}
      22  CommentText . . . . . . . . .  2048 SNN  Comment Text. . . . . . . . . .COMMENT
                                                    DepVal:REQUIRED ValGroup:Item
                                                    Required
      23  QuantityRequested . . . . . . 16.6  NNN  Quantity Requested. . . . . . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: {POI[0]}
      24  QuantityPreviouslyIssued. . . 16.6  NNN  Quantity Previously Issued. . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: {POI[1]}
      25  QuantityIssued. . . . . . . . 16.6  NNN  Quantity Issued This Entry. . .QUANTITY
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: {POI[2]}
      26  UnitCost. . . . . . . . . . . 16.6  NNN  Unit Cost . . . . . . . . . . .COST
                                                    Mask:##,###,###.000000-
                                                    ValGroup:NotComment,
                                                    ItemRequired,ItemTypes
                                                    Notes: {POI[3]}
      27  ExtensionAmt. . . . . . . . . 12.2  NNN  Extension Amount. . . . . . . .MISCAMOUNT
                                                    Mask:###,###,###.00
                                                    ValGroup:NotComment,
                                                    ItemRequired Notes: {POI[4]}
      28  ExtendedNegQtyAdj . . . . . . 12.2  NNN  Extended Negative Quanity . . .MISCAMOUNT
                                                    Mask:###,###,###.00
      29  UnitOfMeasureConvFactor . . . 12.4  NNN  Unit Of Measure Conversion FactUMCONVFACTOR
                                                    Read Only:Y Mask:#####0.0000
                                                    Notes: {POI[6]}