With the introduction of ZUGFeRD version 2.5 (Factur-X 1.09) in i-effect 3.1.18, the following extensions were made to the database interfaces. Existing fields and tables remain unchanged, as ZUGFeRD 2.5 is backward-compatible with 2.4.0 and contains exclusively additions to the EXTENDED profile.
New fields in ZF23INVAC
The table ZF23INVAC was extended with the following fields:
|
Column |
Type |
Description |
|---|---|---|
|
ACACRCCL |
CHAR(5) |
Code list qualifier for non VAT tax reason |
|
ACVERT |
VARCHAR(128) |
VAT exemption reason text |
|
ACVERC |
CHAR(5) |
VAT exemption reason code |
New fields in ZF23INVPT
The table ZF23INVPT (payment terms) was extended with the following fields:
|
Column |
Type |
Description |
|---|---|---|
|
PTBUYFAN |
VARCHAR(128) |
Name of the debited account (BT-91) |
|
PTDACSPID |
VARCHAR(128) |
Debited account service provider name |
|
PTDACSPBIC |
VARCHAR(128) |
Debited account service provider ID (e.g. BIC) |
New fields in ZF23INVTI
The table ZF23INVTI (line item tax) was extended with the following fields:
|
Column |
Type |
Description |
|---|---|---|
|
TIVERT |
VARCHAR(128) |
VAT exemption reason text |
|
TIVERC |
CHAR(5) |
VAT exemption reason code |
New table ZF23INVTPC (Third party charges)
The table ZF23INVTPC stores third party charges according to ZUGFeRD 2.5 EXTENDED.
|
Column |
Type |
NOT NULL |
Description |
|---|---|---|---|
|
TPCKEY |
VARCHAR(15) |
Yes |
Internal pagination number |
|
TPCREF |
DECIMAL(5,0) |
Yes |
Reference of position or head |
|
TPCLFD |
DECIMAL(5,0) |
Yes |
Sequence |
|
TPCSPEC |
VARCHAR(128) |
No |
Charges specifications |
|
TPCAMNT |
DECIMAL(15,4) |
No |
Charges amount |