The table ZF23INVTPC (Third party charges) is available from i-effect 3.1.18 (ZUGFeRD 2.5 / Factur-X 1.09, EXTENDED profile) and maps third party charges at document level. It corresponds to group BG-34 (Charges on behalf of a third party) of the Factur-X 1.09 specification.
This database table consists of the following fields
|
Column Name |
Status |
Column definition |
Technical term |
Description |
|---|---|---|---|---|
|
TPCKEY |
required |
VARCHAR(15) |
Internal Pagination Number |
Internal Page number |
|
TPCREF |
required |
DECIMAL(5,0) |
Reference |
Reference of position or head. |
|
TPCLFD |
required |
DECIMAL(5,0) |
Sequence |
Sequence number of the third party charge. |
|
TPCSPEC |
optional |
VARCHAR(128) |
Charges specifications |
Specification (reason) of the third party charge. Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
|
TPCAMNT |
optional |
DECIMAL(15,4) |
Charges amount |
Amount of the third party charge. Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
The following list shows the business rule numbers matching the fields, the XML target elements and further explanations
|
Column Name |
XML Element |
EN16931-ID |
Example |
Info |
|---|---|---|---|---|
|
TPCSPEC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedFinancialAdjustment/ram:Reason |
BT-180 |
Specification of the charge amount |
from ZUGFeRD 2.5 (EXTENDED) |
|
TPCAMNT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedFinancialAdjustment/ram:ActualAmount |
BT-179 |
Charge amount, not part of the invoice, that should be paid as well |
from ZUGFeRD 2.5 (EXTENDED); BR-FXEXT-CO-16: Amount due for payment (BT-115) = Invoice total with VAT (BT-112) - Paid amount (BT-113) + Rounding amount (BT-114) + sum of third party charge amounts (BT-179) |