Table Abbreviation Description Module Activity code
PREQUISD PSD Purchase request detail Purchasing  

Key Description Duplicates Activity code
PSD0 PSHNUM+PSDLIN No  
PSD1 LINORDFLG+ITMREF+EXTRCPDAT+PSHNUM+PSDLIN Yes  
PSD2 LINORDFLG+LINBUY+EXTORDDAT Yes  
PSD3 PSDNUMMMS+PSHNUM+PSDLIN No MMS
PJMPJT1 PJT Yes PJM

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AMTTAXISS Issue tax amount   MD1         PTX
AMTTAXLIN1 Tax amount 1   MD1          
AMTTAXLIN2 Tax amount 2   MD1          
AMTTAXLIN3 Tax amount 3   MD1          
AMTTAXOTH1 Amount other tax 1   MD1         PTX
AMTTAXOTH2 Amount other tax 2   MD1         PTX
AMTTAXRCP Receipt tax amount   MD1         PTX
ATECORI Source   M 15 7885      
AUUID Single identifier   AUUID          
BASTAXLIN1 Tax basis 1   MD1          
BPSNUM Supplier   BPR     [BPR]BPR0=[PSD]BPSNUM Block  
CHGCOE Rate   RCU          
CHGTYP Rate type   M 15 202      
CLCAMT1 Tax calculation basis 1   MD1          
CLCAMT2 Tax calculation basis 2   MD1          
CLCAMT3 Tax calculation basis 3   MD1          
CLCAMT4 Tax calculation basis 4   MD1         PTX
CLCAMT5 Tax calculation basis 5   MD1         PTX
CLCAMT6 Tax calculation basis 6   MD1         PTX
CLCAMT7 Tax calculation basis 7   MD1         PTX
CMMPRPFLG Pre commitment indic   C 1        
CMMPRPNUM Pre-commitment no.   VCR          
CMMPRPTAX Commitment type   M 25 578      
CPY Company   CPY     [CPY]CPY0=[PSD]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[PSD]CUR Block  
DEDTAXISS Deductible tax   MD1         PTX
DEDTAXLIN1 Deductible tax 1   MD1          
DEDTAXLIN2 Deductible tax 2   MD1          
DEDTAXLIN3 Deductible tax 3   MD1          
DEDTAXOTH1 Deductible tax   MD1         PTX
DEDTAXOTH2 Deductible tax   MD1         PTX
DEDTAXRCP Deductible tax   MD1         PTX
DISCRGREN1 Discount 1 reason   PPR     [PPR]PPR0=[PSD]DISCRGREN1 Block PP1
DISCRGREN2 Discount 2 reason   PPR     [PPR]PPR0=[PSD]DISCRGREN2 Block PP2
DISCRGREN3 Discount 3 reason   PPR     [PPR]PPR0=[PSD]DISCRGREN3 Block PP3
DISCRGREN4 Discount 4 reason   C 4       PP4
DISCRGREN5 Discount 5 reason   C 4       PP5
DISCRGREN6 Discount 6 reason   C 4       PP6
DISCRGREN7 Discount 7 reason   C 4       PP7
DISCRGREN8 Discount 8 reason   C 4       PP8
DISCRGREN9 Discount 9 reason   C 4       PP9
DISCRGVAL1 Discount/Charge 1   MD8         PP1
DISCRGVAL2 Discount/Charge 2   MD8         PP2
DISCRGVAL3 Discount/Charge 3   MD8         PP3
DISCRGVAL4 Discount/Charge 4   DCB 19.8       PP4
DISCRGVAL5 Discount/Charge 5   DCB 19.8       PP5
DISCRGVAL6 Discount/Charge 6   DCB 19.8       PP6
DISCRGVAL7 Discount/Charge 7   DCB 19.8       PP7
DISCRGVAL8 Discount/Charge 8   DCB 19.8       PP8
DISCRGVAL9 Discount/Charge 9   DCB 19.8       PP9
ECCVALMAJ Major version   ECS         ECC
ECCVALMIN Minor version   EVL         ECC
EXTORDDAT Calculated order date   D          
EXTRCPDAT Requested date   D          
FBUFLG Budget overrun   M 4 1      
GROPRI Gross price   MD8          
ITMDES Description   DES          
ITMDES1 Description   DES          
ITMKND Product type   M 15 2513      
ITMREF Product   ITM     [ITM]ITM0=[PSD]ITMREF Block  
LINAMT Line amount - tax   MD1          
LINAPPFLG Signed line   M 15 280      
LINATIAMT Line amount + tax   MD1          
LINBUY Buyer   AUS     [AUS]CODUSR=[PSD]LINBUY Block  
LINCLEFLG Line closed   M 4 1      
LINORDFLG Ordered line   M 4 1      
LINPURTYP Purchase type   M 5 646      
LINTEX Text   TXC          
NBAOF No. of RFQs   L 4        
NETPRI Net price   MD8          
ORDQTYPUU Ordered PUR   QTY          
ORDQTYSTU Ordered STK   QTY          
ORI Request source   M 15 505      
PJT Project   PJT     [PIM]PIM0=[PSD]PJT Block  
PPDLIN Response line   L 8        
PQHNUM RFQ no.   VCR          
PRHFCY Receiving site   FCY     [FCY]FCY0=[PSD]PRHFCY Block  
PRIREN Price reason   PPR     [PPR]PPR0=[PSD]PRIREN Block  
PSDLIN Line   L 8        
PSDNUMMMS Maintenance line id   A 15        
PSHFCY Request site   FCY     [FCY]FCY0=[PSD]PSHFCY Block  
PSHNUM Request no.   VCR          
PUU Purchase unit   UOM     [TUN]TUN0=[PSD]PUU Block  
QTYPUU PUR quantity   QTY          
QTYSTU STK quantity   QTY          
STU Stock unit   UOM     [TUN]TUN0=[PSD]STU Block  
TAXISS Issue tax   VAT     [TVT]TVT0=TAXISS;[V]GSUPCLE Block PTX
TAXOTH1 Other tax 1   VAT     [TVT]TVT0=TAXOTH1;[V]GSUPCLE Block PTX
TAXOTH2 Other tax 2   VAT     [TVT]TVT0=TAXOTH2;[V]GSUPCLE Block PTX
TAXRCP Receipt tax   VAT     [TVT]TVT0=TAXRCP;[V]GSUPCLE Block PTX
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACBPR Tax rule   TVB     [TVB]TVB0=VACBPR;[V]GSUPCLE Block  
VACTYP Tax rule type   C 1        
VAT Tax 3 VAT     [TVT]TVT0=VAT(indice);[V]GSUPCLE Block  
WIPNUM Order no.   VCR