Table Abbreviation Description Module Activity code
DOCSIINX3 DSIID SII external documents Common Data DSII

Key Description Duplicates Activity code
DSIID0 CPY+TYPENV+GTE+VCRNUM+VCRLIN No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AMTATI Total invoice amount   DCB 12.2        
AUUID Single identifier   AUUID          
BASEEXE Exemption base   DCB 12.2        
BASEEXES Exemption base (serv.)   DCB 12.2        
BASEIMP Taxable base 6 DCB 12.2        
BASEIMPS Tax base services 6 DCB 12.2        
BASERECT Correction base   DCB 12.2        
BIMPACOSTE Taxable cost base   DCB 12.2        
BPRNAM BP company name   A 120        
CAUSAEXE Exemption reason   A 2        
CAUSAEXES Exemption reason (serv.)   A 2        
CLADECCON Consignment key   A 1        
CLAVEREG Key   A 2        
CLAVEREGAD1 Additional key   A 2        
CLAVEREGAD2 Additional key 2   A 2        
COUTADED Deductible amount   DCB 12.2        
CPY Company   A 5        
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[DSIID]CREUSR Other  
CRY Country   A 2        
CUENTA Account or payment method 5 A 34        
CUOTARE Surcharge tax 6 DCB 12.2        
CUOTARECT Correction tax   DCB 12.2        
CUOTAREQRECT Correction surcharge tax   DCB 12.2        
CUOTARS Tax payable 6 DCB 12.2        
CUOTARSS Tax (services) 6 DCB 12.2        
CUPON Coupon   A 1        
DATOPE Operation date   D          
DATOPEDEC Declared operation date   D          
DESCRY Destination country   CRY     [TCY]TCY0=[DSIID]DESCRY Block  
DESOPE Operation description   A 250        
EJERCICIO Fiscal year   C 4        
EJEREXPINI Fiscal year   A 4        
EMITER Issued by BPs   A 1        
EXPDAT Export date   D          
FACTGAS Gas market invoice   A 1        
FACTSIMP Simplified invoice   A 1        
FECHACONT Accounting date   D          
FECHAEXP Shipping date   D          
FECHAEXPAGR Grouped invoice shipping date 10 D          
FECHAREC Correction invoice date 10 D          
FPAGOCOBRO Payment date 5 D          
GTE Entry type   A 5        
IDEXPINI Identifier   A 60        
IDTYPE Document type   A 2        
IMPNS714 Article 714 amount   DCB 12.2        
IMPNS714S Art. 714 amt. (serv.)   DCB 12.2        
IMPNSLOC Amount TAI localization rules   DCB 12.2        
IMPNSLOCS Amt. TAI localization rules (serv.)   DCB 12.2        
IMPPAGCOBRO Payment amount 5 DCB 12.2        
IMPREAG REAGYP compensation 6 DCB 12.2        
IMPTRANIVA Transmitted VAT amt.   DCB 12.2        
MEDIO Coll./payment method 5 A 2        
NFACAGR Grouped invoice   L 4        
NIFREP Representative TIN   A 9        
NIFREPC Representative TIN   A 40        
NIFREPT BP represent. TIN   A 9        
NIFS Succeeded entity ID   A 9        
NIP Identification   A 40        
NOMNOTARIO Art. 25 notary name 5 A 120        
NUMACFAC Billing agreement   A 15        
NUMFACAGR Grouped invoice number 10 A 55        
NUMFACREC Correction invoice number 10 A 60        
NUMFACTRES Summary invoice number   A 60        
NUMFACTURA Invoice number   A 60        
NUMPROTO Art. 25 protocol number 5 A 6        
ORICRY Country of origin   CRY     [TCY]TCY0=[DSIID]ORICRY Other  
PAGOANT Art. 25 prepayment 5 A 1        
PEREXPINI Period   A 2        
PERIODO Period   A 2        
PORREAG REAGYP percentage 6 DCB 3.2        
QTY Quantity   QTY          
RAZONS Succeeded entity name   A 120        
RECDAT Receipt date   D          
REFCAT Cadastre reference   A 25        
REFEXT External reference   A 60        
REGPRE Previous registration   A 1        
SINIDEART61 Unidentified invoice   A 1        
SITINM Building location   A 1        
TIPOBIEN Art. 25 asset type 5 A 2        
TIPODESG Breakdown type   A 1        
TIPODOCU Art. 25 document type 5 A 2        
TIPOIMP Tax type 6 DCB 3.2        
TIPOIMPS Tax type services 6 DCB 3.2        
TIPONOEXE Non-exempted type   A 2        
TIPONOEXES Non-exempt. (serv.)   A 2        
TIPOREQ Surcharge type 6 DCB 3.2        
TYPENV Transmission method   M 50 2115      
TYPOPECON Consignment type   M 50 2125      
UNIPRI Unit price   DCB 12.2        
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[DSIID]UPDUSR Other  
VALBASIMP Tax base value   DCB 12.2        
VALBIEN Stock value   DCB 12.2        
VARDEST Several recipients   A 1        
VCRLIN Line no.   L 8        
VCRNUM Document   A 60