Changes to the DB interfaces (from i-effect 3.1.13 onwards)
With the switch to the new ZUGFeRD version 2.3.2 in i-effect 3.1.13, the previous ZF2INVxx tables were converted to new ZF23INVxx tables. In addition, type and length changes were made to fields so that a format-independent interface can be used for ZUGFeRD and xRechnung.
If you have been working with the ZF2INVxxx interfaces, you will need to adapt the read or fill programmes when using i-effect version 3.1.13. This article documents the changes and shows the modified fields and tables.
Type changes
The fields listed here have been adapted in type and/or length to meet current requirements.
Table | Column | Before 3.1.13 | After 3.1.16 | Comment |
|---|---|---|---|---|
ZF23INVAC | ACREF | DECIMAL(5,0) | INTEGER | Data type changed |
ZF23INVBR | BRREF | DECIMAL(5,0) | INTEGER | Data type changed, field renamed |
ZF23INVDR | DRNAME | VARCHAR (35) | VARCHAR (1000) | Data type changed |
ZF23INVDR | DRREF | DECIMAL(5,0) | INTEGER | Data type changed |
ZF23INVPC | PCREF | DECIMAL(5,0) | INTEGER | Data type changed |
ZF23INVPI | PIREF | DECIMAL(5,0) | INTEGER | Data type changed |
ZF23INVPI | PIDOLIO | INTEGER (4) | VARCHAR (100) | Data type changed |
ZF23INVPP | PPREF | DECIMAL(5,0) | INTEGER | Data type changed |
ZF23INVPT | PTATSPMCH | VARCHAR (25) | VARCHAR (1000) | Data type changed |
ZF23INVTI | TIREF | DECIMAL(5,0) | INTEGER | Data type changed |
ZF23INVTP | TPTEXT | VARCHAR (2048) | VARCHAR (1000) | Data type changed |
ZF23INVTP | TPPAPMID | VARCHAR (15) | VARCHAR (1000) | Data type changed |
ZF23INVTX | TXREF | DECIMAL(5,0) | INTEGER | Data type changed |
ZF23INVHT | HTSPPID | INTEGER | VARCHAR(1000) | Data type changed |
ZF23INVPI | PILFD | INTEGER | New field | |
ZF23INVAP | APLFD | INTEGER | New field | |
ZF23INVHT | SESSIONNR | < Field removed > | ||
ZF23INVHT | HTZTSMSTB2 | DECIMAL(15,2) | New field | |
ZF23INVHT | HTZTSMSGT2 | DECIMAL(15,2) | New field | |
ZF23INVHT | HTNAPPFMT | VARCHAR(10) | New field | |
ZF23INVHT | HTNAPPVER | VARCHAR(10) | New field |
New table ZF23INVTPP
Information on advance payments is displayed here.
TPPKEY | TPPLFD | TPPTYPE | TPPAMOUNT | TPPCUR | TPPDESC |
|---|---|---|---|---|---|
Analogue HTKEY | Sequential number | 0 | Amount of advance payment | Currency | Description |
New table ZF23INVPIR
Information about previous invoice documents is displayed here.
PIRKEY | PIRLFD | PIRREF | PIRDATE | PIRDATET |
|---|---|---|---|---|
Analogue HTKEY | Sequential number | Document reference | Date of the referenced document | Date type |
New table ZF23INVIDT
Tax identification details are displayed here.
IDTKEY | IDTREF | IDTGROUP | ID | IDTYPE |
|---|---|---|---|---|
Analogue HTKEY | 0 = Header information | *SELLER | Tax identification | Type of tax identification |
New table ZF23INVID
Information on identification features for invoice participants has been removed from tables ZF2INVPI, ZF2INVIP, and ZF2INVHT and transferred to the new table ZF23INVID. Here, a record is created for each information unit, which can be identified by the IDGROUP feature.
The respective columns in the following table show which field contents from the previous tables ZF2INVPI, ZF23INVIP, or ZF2INVHT must be used to fill the fields in the new tables.
IDKEY | IDREF 0=Head | IDGROUP Group identification | ID Identification | IDTYPE Type of identification |
|---|---|---|---|---|
ZF2INVIP.IPKEY | ZF2INVIP.IPREF | *REFERENCEDPRODUCT | ZF2INVIP.IPPGIC | ZF2INVIP.IPPSID |
ZF2INVPI.PIKEY | ZF2INVPI.PIREF | *SHIPTO | ZF2INVPI.PIWRDID | empty |
ZF2INVPI.PIKEY | ZF2INVPI.PIREF | *SHIPTO | ZF2INVPI.PIWRDGLN | ZF2INVPI.PIWRDGLNT |
ZF2INVPI.PIKEY | ZF2INVPI.PIREF | *ULTIMATESHIPTO | ZF2INVPI.PIFRDID | empty |
ZF2INVPI.PIKEY | ZF2INVPI.PIREF | *ULTIMATESHIPTO | ZF2INVPI.PIFRDGLN | ZF2INVPI.PIFRDGLNT |
ZF2INVHT.HTKEY | 0 | *SELLER | ZF2INVHT.HTGSEID | empty |
ZF2INVHT.HTKEY | 0 | *SELLER | ZF2INVHT.HTGSEGLN | ZF2INVHT.HTGSEGLNT |
ZF2INVHT.HTKEY | 0 | *BUYER | ZF2INVHT.HTGBID | empty |
ZF2INVHT.HTKEY | 0 | *BUYER | ZF2INVHT.HTGBGLN | ZF2INVHT.HTGBGLNT |
ZF2INVHT.HTKEY | 0 | *SELLERTAXREPRESENTATIVE | ZF2INVHT.HTGTID | empty |
ZF2INVHT.HTKEY | 0 | *SELLERTAXREPRESENTATIVE | ZF2INVHT.HTGTGLN | ZF2INVHT.HTGTGLNT |
ZF2INVHT.HTKEY | 0 | *PRODUCTENDUSER | ZF2INVHT.HTGUDID | empty |
ZF2INVHT.HTKEY | 0 | *PRODUCTENDUSER | ZF2INVHT.HTGUDGLN | ZF2INVHT.HTGUDGLNT |
ZF2INVHT.HTKEY | 0 | *SHIPTO | ZF2INVHT.HTLWRDID | empty |
ZF2INVHT.HTKEY | 0 | *SHIPTO | ZF2INVHT.HTLWRDGLN | ZF2INVHT.HTLWRDGLNT |
ZF2INVHT.HTKEY | 0 | *DEVIANTULTIMATESHIPTO | ZF2INVHT.HTLFRDID | empty |
ZF2INVHT.HTKEY | 0 | *DEVIANTULTIMATESHIPTO | ZF2INVHT.HTLFRDGLN | ZF2INVHT.HTLFRDGLNT |
ZF2INVHT.HTKEY | 0 | *SHIPFROM | ZF2INVHT.HTLCDID | empty |
ZF2INVHT.HTKEY | 0 | *SHIPFROM | ZF2INVHT.HTLCDGLN | ZF2INVHT.HTLCDGLNT |
ZF2INVHT.HTKEY | 0 | *INVOICEE | ZF2INVHT.HTZIRDREID | empty |
ZF2INVHT.HTKEY | 0 | *INVOICEE | ZF2INVHT.HTZIRDGLN | ZF2INVHT.HTZIRDGLNT |
ZF2INVHT.HTKEY | 0 | *PAYEE | ZF2INVHT.HTZPRDREID | empty |
ZF2INVHT.HTKEY | 0 | *PAYEE | ZF2INVHT.HTZPRDGLN | ZF2INVHT.HTZPRDGLNT |
New table ZF23INVPD
Information on previous documents has been removed from table ZF2INVHT and transferred to the new table ZF23INVPD. Here, a record is created for each information unit, which can be identified by the PDTYPE characteristic.
The respective columns in the following table show which field contents from the previous table ZF2INVHT must be used to populate the fields in the new tables.
PDKEY | PDTYPE Type of document | PDREF 0=Head | PDIAID Issue assigned ID of previous document | PDTC Document type code | PDFIDT Date of previous document |
|---|---|---|---|---|---|
HTKEY | 0 | 1 | HTZIRDIAID | empty | HTZIRDFIDT |
New table ZF23INVDP
Information on invoice participants has been removed from table ZF2INVHT and transferred to the new table ZF23INVDP. Here, a record is created for each information unit, which can be identified by the DPTYPE characteristic.
The respective columns in the following table show which field contents from the previous table ZF2INVHT must be used to populate the fields in the new tables.
DPKEY | DPREF 0=Head | DPTYPE Participant type | DPNAME Name of participant | DPDESC Description | DPROLECODE Role Code | DPORGID ID of legal organization | DPORGIDT ID of scheme | DPTRBNE Trading business name | DPBEPLZ Postcode | DPBAD1 Name 1 | DPBAD2 Name 2 | DPBAD3 Name 3 | DPBCITY City | DPBLLC Country Code | DPBCSDN Country Sub Division | DPCEPLZ Postcode | DPCAD1 Name 1 | DPCAD2 Name 2 | DPCAD3 Name 3 | DPCCITY City | DPCLLC Country code | DPCCSDN Country sub division | DPURID URI Communication | DPURIDT URI communication type | DPSNR FC Tax Number | DPASNR VA tax number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HTKEY | 0 | *SELLER | HTGSENAME | HTGSDESC | HTGSOID | HTGSOIDT | HTGSOTRBN | HTGSOEZIP | HTGSOEAD1 | HTGSOEAD2 | HTGSOEAD3 | HTGSOELC | HTGSOECR | HTGSEZIP | HTGSEAD1 | HTGSEAD2 | HTGSEAD3 | HTGSELC | HTGSECR | HTGSCSDN | HTGSURID | HTGSURIDT | HTGSETAX | HTGSETAXT | ||
HTKEY | 0 | *BUYER | HTGBNAME | HTGBOID | HTGBOIDT | HTGBOTRBN | HTGBOEZIP | HTGBOEAD1 | HTGBOEAD2 | HTGBOEAD3 | HTGBOELC | HTGBOECR | HTGBZIP | HTGBAD1 | HTGBAD2 | HTGBAD3 | HTGBLC | HTGBCR | HTGBCSDN | HTGBURID | HTGBURIDT | HTGBTAX | HTGBTAXT | |||
HTKEY | 0 | *SELLERTAXREPRESENTATIVE | HTGTNAME | HTGTOID | HTGTOIDT | HTGTOTRBN | HTGTZIP | HTGTAD1 | HTGTAD2 | HTGTAD3 | HTGTLC | HTGTCR | HTGTCSDN | HTGTURID | HTGTURIDT | HTGTTAX | HTGTTAXT | |||||||||
HTKEY | 0 | *PRODUCTENDUSER | HTGUDNAME | HTGUDOID | HTGUDOIDT | HTGUDOTRBN | HTGUDZIP | HTGUDAD1 | HTGUDAD2 | HTGUDAD3 | HTGUDLC | HTGUDCR | HTGUDCSDN | HTGUDURID | HTGUDURIDT | HTGUDTAX | HTGUDTAXT | |||||||||
HTKEY | 0 | *SHIPTOLOCATION | HTLWRDREC | HTLWROID | HTLWROIDT | HTLWROTRBN | HTLWRDPLZ | HTLWRDAD1 | HTLWRDAD2 | HTLWRDAD3 | HTLWRDCITY | HTLWRDLC | HTLWRCSDN | HTLWRURID | HTLWRURIDT | HTLWRDSNR | HTLWRDASNR | |||||||||
HTKEY | 0 | *DEVIANTULTIMATESHIPTO | HTLFRDREC | HTLFROID | HTLFROIDT | HTLFROTRBN | HTLFRDPLZ | HTLFRDAD1 | HTLFRDAD2 | HTLFRDAD3 | HTLFRDCITY | HTLFRDLC | HTLFRCSDN | HTLFRURID | HTLFRURIDT | HTLFRDSNR | HTLFRDASNR | |||||||||
HTKEY | 0 | *SHIPFROM | HTLCDREC | HTLCDOID | HTLCDOIDT | HTLCDOTRBN | HTLCDPLZ | HTLCDAD1 | HTLCDAD2 | HTLCDAD3 | HTLCDCITY | HTLCDLC | HTLCDCSDN | HTLCDURID | HTLCDURIDT | HTLCDSNR | HTLCDASNR | |||||||||
HTKEY | 0 | *INVOICER(not used) | HTZITDREC | HTZITOID | HTZITOIDT | HTZITOTRBN | HTZITDEPLZ | HTZITDAD1 | HTZITDAD2 | HTZITDAD3 | HTZITDCITY | HTZITDLLC | HTZITCSDN | HTZITURID | HTZITURIDT | HTZITDSNR | HTZITDASNR | |||||||||
HTKEY | 0 | *INVOICEE | HTZIRDREC | HTZIROID | HTZIROIDT | HTZIROTRBN | HTZIRDEPLZ | HTZIRDAD1 | HTZIRDAD2 | HTZIRDAD3 | HTZIRDCITY | HTZIRDLLC | HTZIRCSDN | HTZIRURID | HTZIRURIDT | HTZIRDSNR | HTZIRDASNR | |||||||||
HTKEY | 0 | *PAYEE | HTZPRDREC | HTZPROID | HTZPROIDT | HTZPROTRBN | HTZPRDPLZ | HTZPRDAD1 | HTZPRDAD2 | HTZPRDAD3 | HTZPRDCITY | HTZPRDLLC | HTZPRCSDN | HTZPRURID | HTZPRURIDT | HTZPRDSNR | HTZPRDASNR | |||||||||
New table ZF23INVAI
Contact details have been removed from table ZF2INVHT and transferred to the new table ZF23INVAI. Here, a record is created for each information unit, which can be identified by the AITYPE characteristic.
The respective columns in the following table show which field contents from the previous table ZF2INVHT must be used to populate the fields in the new tables.
AIKEY | AIREF 0=Head | AITYPE Contact type | AICNAME Contact name | AIDNAME Departement name | AITC Type of contact | AITEL Phone number | AIFAX Fax number | AIMAIL Mail address |
|---|---|---|---|---|---|---|---|---|
HTKEY | 0 | *SELLER | HTGSECT | HTGSECTD | HTGSETE | HTGSEFX | HTGSEEM | |
HTKEY | 0 | *BUYER | HTGBCT | HTGBCTD | HTGBTE | HTGBFX | HTGBEM | |
HTKEY | 0 | *SELLERTAXREPRESENTATIVE | HTGTCT | HTGTCTD | HTGTTE | HTGTFX | HTGTEM | |
HTKEY | 0 | *PRODUCTENDUSER | HTGUDCT | HTGUDCTD | HTGUDTE | HTGUDFX | HTGUDEM | |
HTKEY | 0 | *SHIPTOLOCATION | HTLWRDCN | HTLWRDDN | HTLWRDTEL | HTLWRDFAX | HTLWRDMAIL | |
HTKEY | 0 | *DEVIANTULTIMATESHIPTO | HTLFRDCN | HTLFRDDN | HTLFRDTEL | HTLFRDFAX | HTLFRDMAIL | |
HTKEY | 0 | *SHIPFROM | HTLCDCN | HTLCDDN | HTLCDTEL | HTLCDFAX | HTLCDMAIL | |
HTKEY | 0 | *INVOICER (not used) | HTZITDCN | HTZITDDN | HTZITDTEL | HTZITDFAX | HTZITDMAIL | |
HTKEY | 0 | *INVOICEE | HTZIRDCN | HTZIRDDN | HTZIRDTEL | HTZIRDFAX | HTZIRDMAIL | |
HTKEY | 0 | *PAYEE | HTZPRDCN | HTZPRDDN |
New table ZF23INIDT
Tax identification details have been removed from table ZF2INVHT and transferred to the new table ZF23INVIDT. Here, a record is created for each information unit, which uses the IDTGROUP characteristic to identify the identity to which the tax identifications belong.
The respective columns in the following table show which field contents from the previous table ZF2INVHT must be used to populate the fields in the new tables.
IDTKEY | IDTREF 0=Head | IDTGROUP Participant type | ID Tax Number | IDTYPE Tax type |
|---|---|---|---|---|
HTKEY | 0 | *SELLER | HTGSETAX | HTGSETAXT |
HTKEY | 0 | *BUYER | HTGBTAX | HTGBTAXT |
HTKEY | 0 | *SELLERTAXREPRESENTATIVE | HTGTTAX | HTGTTAXT |
HTKEY | 0 | *PRODUCTENDUSER | HTGUDTAX | HTGUDTAXT |
HTKEY | 0 | *SHIPTOLOCATION | HTLWRDSNR | HTLWRDASNR |
HTKEY | 0 | *DEVIANTULTIMATESHIPTO | HTLFRDSNR | HTLFRDASNR |
HTKEY | 0 | *SHIPFROM | HTLCDSNR | HTLCDASNR |
HTKEY | 0 | *INVOICER(not used) | HTZITDSNR | HTZITDASNR |
HTKEY | 0 | *INVOICEE | HTZIRDSNR | HTZIRDASNR |
HTKEY | 0 | *PAYEE | HTZPRDSNR | HTZPRDASNR |