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