Table > Module Purchasing > Table Purchase request detail 

TableAbbreviationDescriptionModuleActivity code
PREQUISDPSDPurchase request detailPurchasing 

KeyDescriptionDuplicatesActivity code
PSD0PSHNUM+PSDLINNo 
PSD1LINORDFLG+ITMREF+EXTRCPDAT+PSHNUM+PSDLINYes 
PSD2LINORDFLG+LINBUY+EXTORDDATYes 
PSD3PSDNUMMMS+PSHNUM+PSDLINNoMMS
PJMPJT1PJTYesPJM

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AMTTAXISSIssue tax amount MD1    PTX
AMTTAXLIN1Tax amount 1 MD1     
AMTTAXLIN2Tax amount 2 MD1     
AMTTAXLIN3Tax amount 3 MD1     
AMTTAXOTH1Amount other tax 1 MD1    PTX
AMTTAXOTH2Amount other tax 2 MD1    PTX
AMTTAXRCPReceipt tax amount MD1    PTX
ATECORISource M157885   
AUUIDSingle identifier AUUID     
BASTAXLIN1Tax basis 1 MD1     
BPSNUMSupplier BPR  [BPR]BPR0=[PSD]BPSNUMBlock 
CHGCOERate RCU     
CHGTYPRate type M15202   
CLCAMT1Tax calculation basis 1 MD1     
CLCAMT2Tax calculation basis 2 MD1     
CLCAMT3Tax calculation basis 3 MD1     
CLCAMT4Tax calculation basis 4 MD1    PTX
CLCAMT5Tax calculation basis 5 MD1    PTX
CLCAMT6Tax calculation basis 6 MD1    PTX
CLCAMT7Tax calculation basis 7 MD1    PTX
CMMPRPFLGPre commitment indic C1    
CMMPRPNUMPre-commitment no. VCR     
CMMPRPTAXCommitment type M25578   
CPYCompany CPY  [CPY]CPY0=[PSD]CPYBlock 
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRCreation user A5    
CURCurrency CUR  [TCU]TCU0=[PSD]CURBlock 
DEDTAXISSDeductible tax MD1    PTX
DEDTAXLIN1Deductible tax 1 MD1     
DEDTAXLIN2Deductible tax 2 MD1     
DEDTAXLIN3Deductible tax 3 MD1     
DEDTAXOTH1Deductible tax MD1    PTX
DEDTAXOTH2Deductible tax MD1    PTX
DEDTAXRCPDeductible tax MD1    PTX
DISCRGREN1Discount 1 reason PPR  [PPR]PPR0=[PSD]DISCRGREN1BlockPP1
DISCRGREN2Discount 2 reason PPR  [PPR]PPR0=[PSD]DISCRGREN2BlockPP2
DISCRGREN3Discount 3 reason PPR  [PPR]PPR0=[PSD]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
EXTORDDATCalculated order date D     
EXTRCPDATRequested date D     
FBUFLGBudget overrun M41   
GROPRIGross price MD8     
ITMDESDescription DES     
ITMDES1Description DES     
ITMKNDProduct type M152513   
ITMREFProduct ITM  [ITM]ITM0=[PSD]ITMREFBlock 
LINAMTLine amount - tax MD1     
LINAPPFLGSigned line M15280   
LINATIAMTLine amount + tax MD1     
LINBUYBuyer AUS  [AUS]CODUSR=[PSD]LINBUYBlock 
LINCLEFLGLine closed M41   
LINORDFLGOrdered line M41   
LINPURTYPPurchase type M5646   
LINTEXText TXC     
NBAOFNo. of RFQs L4    
NETPRINet price MD8     
ORDQTYPUUOrdered PUR QTY     
ORDQTYSTUOrdered STK QTY     
ORIRequest source M15505   
PJTProject PJT  [PIM]PIM0=[PSD]PJTBlock 
PPDLINResponse line L8    
PQHNUMRFQ no. VCR     
PRHFCYReceiving site FCY  [FCY]FCY0=[PSD]PRHFCYBlock 
PRIRENPrice reason PPR  [PPR]PPR0=[PSD]PRIRENBlock 
PSDLINLine L8    
PSDNUMMMSMaintenance line id A15    
PSHFCYRequest site FCY  [FCY]FCY0=[PSD]PSHFCYBlock 
PSHNUMRequest no. VCR     
PUUPurchase unit UOM  [TUN]TUN0=[PSD]PUUBlock 
QTYPUUPUR quantity QTY     
QTYSTUSTK quantity QTY     
STUStock unit UOM  [TUN]TUN0=[PSD]STUBlock 
TAXISSIssue tax VAT  [TVT]TVT0=TAXISS;[V]GSUPCLEBlockPTX
TAXOTH1Other tax 1 VAT  [TVT]TVT0=TAXOTH1;[V]GSUPCLEBlockPTX
TAXOTH2Other tax 2 VAT  [TVT]TVT0=TAXOTH2;[V]GSUPCLEBlockPTX
TAXRCPReceipt tax VAT  [TVT]TVT0=TAXRCP;[V]GSUPCLEBlockPTX
UPDDATChange date D     
UPDDATTIMDate time ADATIM     
UPDUSRChange user A5    
VACBPRTax rule TVB  [TVB]TVB0=VACBPR;[V]GSUPCLEBlock 
VACTYPTax rule type C1    
VATTax3VAT  [TVT]TVT0=VAT(indice);[V]GSUPCLEBlock 
WIPNUMOrder no. VCR