Table Abbreviation Description Module Activity code
BPSINVLIG PIL Supplier invoice lines A/P-A/R accounting  

Key Description Duplicates Activity code
PIL0 NUM+LIG No  
PIL1 PJTLIN Yes PJM

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACC General accounts 10 GAC     [GAC]GAC0=COA(indice);ACC(indice) Block  
AMTATILIN Amount + tax   MD1          
AMTNOTLIN Amount - tax   MD1          
AMTTAX1 Tax amount   MD1          
AMTTAX2 Tax amount   MD1          
AMTTAXISS Issue tax amount   MD1         PTX
AMTTAXOTH1 Amount other tax 1   MD1         PTX
AMTTAXOTH2 Amount other tax 2   MD1         PTX
AMTTAXRCP Receipt tax amount   MD1         PTX
AMTVAT Tax amount   MD1          
AUUID Single identifier   AUUID          
BPRLIN BP   BPR     [BPR]BPR0=[PIL]BPRLIN Block  
COA Chart code 10 COA     [COA]COA0=[PIL]COA Block  
CPYLIN Company   CPY     [CPY]CPY0=[PIL]CPYLIN Block  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[PIL]CREUSR Other  
DCLEECNUM VAT declaration no.   EEC         KPO
DEDTAX1 Deductible tax   MD1          
DEDTAX2 Deductible tax   MD1          
DEDTAXISS Deductible tax   MD1         PTX
DEDTAXOTH1 Deductible tax   MD1         PTX
DEDTAXOTH2 Deductible tax   MD1         PTX
DEDTAXRCP Deductible tax   MD1         PTX
DEDVAT Input VAT   MD1          
DES Comment   A 30        
DSP Distribution   DSP     [DSP]DSP0=DSP;1 Block  
ENDDAT End date   D          
FCYLIN Site   FCY     [FCY]FCY0=[PIL]FCYLIN Block  
FLG1099 1099   M 4 1     S1099
FLGDEP Subject to discount   M 4 1      
INVTYP Invoice category   M 15 645      
LED Ledger 10 LED     [LED]LED0=[PIL]LED Block  
LIG Line number   C 3        
NUM Document no.   VCR          
PCCCOD Cost type   PJCC     [PJCC]PCC0=[PIL]PCCCOD Block PJM
PERNBR Periodicity   C 4        
PERTYP Periodicity   M 15 635      
PJTLIN Project   PJT     [PIM]PIM0=PJTLIN Block PJM
PURTYP Purchase type   M 15 646      
QTY Quantity   QTY          
RITCODSRC Withholding tax code   RTZ     [RTZ]RTZ0=[PIL]RITCODSRC Block WTHMG
SAC Control   SAC          
STRDAT Start date   D          
STT1 Statistics   A 3        
STT2 Statistics   A 3        
STT3 Statistics   A 3        
TAX1 Tax 1   VAT     [TVT]TVT0=TAX1;[V]GSUPCLE Block  
TAX2 Tax 2   VAT     [TVT]TVT0=TAX2;[V]GSUPCLE 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
UOM Nonfinancial unit   UOM     [TUN]TUN0=[PIL]UOM Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[PIL]UPDUSR Other  
VAT Tax 3   VAT     [TVT]TVT0=VAT;[V]GSUPCLE Block