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]}