Table > Module Purchasing > Table Purchase orders by product 

TableAbbreviationDescriptionModuleActivity code
PORDITMPOIPurchase orders by productPurchasing 

KeyDescriptionDuplicatesActivity code
POI0USR+NOLIGNo 
POI1USR+POILINNo 

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AUUIDSingle identifier AUUID     
BPSNUMSupplier BPR  [BPR]BPR0=[POI]BPSNUMBlock 
BUYBuyer AUS  [AUS]CODUSR=[POI]BUYBlock 
CCEAnalytical dimension CCE  [CCE]CCE0=DIE(indice);CCE(indice)BlockANA
CHGCOERate RCU     
CHGTYPRate type M15202   
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRCreation user A5    
CURCurrency CUR  [TCU]TCU0=[POI]CURBlock 
DIEDimension type code DIE  [DIE]DIE0=[POI]DIEBlockANA
DISCRGREN1Discount 1 reason PPR  [PPR]PPR0=[POI]DISCRGREN1BlockPP1
DISCRGREN2Discount 2 reason PPR  [PPR]PPR0=[POI]DISCRGREN2BlockPP2
DISCRGREN3Discount 3 reason PPR  [PPR]PPR0=[POI]DISCRGREN3BlockPP3
DISCRGREN4Discount 4 reason C4   PP4
DISCRGREN5Discount 5 reason C4   PP5
DISCRGREN6Discount 6 reason C4   PP6
DISCRGREN7Discount 7 reason C4   PP7
DISCRGREN8Discount 8 reason C4   PP8
DISCRGREN9Discount 9 reason C4   PP9
DISCRGVAL1Discount/Charge 1 MD8    PP1
DISCRGVAL2Discount/Charge 2 MD8    PP2
DISCRGVAL3Discount/Charge 3 MD8    PP3
DISCRGVAL4Discount/Charge 4 DCB19.8   PP4
DISCRGVAL5Discount/Charge 5 DCB19.8   PP5
DISCRGVAL6Discount/Charge 6 DCB19.8   PP6
DISCRGVAL7Discount/Charge 7 DCB19.8   PP7
DISCRGVAL8Discount/Charge 8 DCB19.8   PP8
DISCRGVAL9Discount/Charge 9 DCB19.8   PP9
ECCVALMAJMajor version ECS    ECC
ECCVALMINMinor version EVL    ECC
EECINCRATIntrastat increase RAT    DEB
EXPNUMExport number L8    
EXTRCPDATExp. receipt date D     
FCYADDAddr. ADR     
GROPRIGross price MD8     
ITMDESDescription DES     
ITMDES1Description DES     
ITMKNDProduct type M152513   
ITMREFProduct ITM  [ITM]ITM0=[POI]ITMREFBlock 
LINBUYBuyer AUS  [AUS]CODUSR=[POI]LINBUYBlock 
NETPRINet price MD8     
NOLIGLine number C3    
ORDDATOrder date D     
ORDREFInternal reference A20    
ORICRYCountry of origin CRY  [TCY]TCY0=[POI]ORICRYBlock 
PJTProject A20    
POHFCYOrder site FCY  [FCY]FCY0=[POI]POHFCYBlock 
POICOULine sequence number L8    
POILINOrder information L8    
PRHFCYReceiving site FCY  [FCY]FCY0=[POI]PRHFCYBlock 
PRIRENPrice reason PPR  [PPR]PPR0=[POI]PRIRENBlock 
PRONUMProcess number L8    
PUUPurchase unit UOM  [TUN]TUN0=[POI]PUUBlock 
QTYPUUPUR quantity QTY     
QTYSTUSTK quantity QTY     
QTYUOMOrdered qty. QTY     
QUAFLGQC management M41   
RETQTYPUURequired PUR QTY     
RETQTYSTURequired STK QTY     
RETRCPDATRequirement date D     
STOMGTCODStock management M15215   
STUStock unit UOM  [TUN]TUN0=[POI]STUBlock 
TSICODStatistical group ADI  [ADI]CODE=indice+20;TSICODOtherSTI
UOMOrder unit UOM  [TUN]TUN0=[POI]UOMBlock 
UOMFLGOrder in PAC M41   
UOMPUUCOESTK-PUR conversion COE     
UPDDATChange date D     
UPDDATTIMDate time ADATIM     
UPDPSDFLGPurchase request upd M41   
UPDUSRChange user A5    
USEPLCLocation reference A30    
USROperator AUS  [AUS]CODUSR=[POI]USRBlock 
VATTax3VAT  [TVT]TVT0=VAT(indice);[V]GSUPCLEBlock