This database table consists of the following fields
|
Column name |
Status |
Column definition |
Technical term |
Description |
|---|---|---|---|---|
|
ACKEY |
required |
VARCHAR(15) |
Reference ID head |
Reference to ZF23INVHT.HTKEY |
|
ACREF |
required |
INTEGER(4, 0) |
Reference ID line item |
Reference to the Head (“0”) or reference to ZF23INVPI.PILFD |
|
ACTYPE |
required |
CHAR(1) |
Type of Allowance Charge |
0 = Document level 1 = Line level 2 = Gross price level (may be used only once) |
|
ACLFD |
required |
DECIMAL(5, 0) |
Order of the Sur/decution |
Sequence of records within ACKEY, ACREF |
|
ACTACI |
required |
CHAR(5) |
Indicator for allowance |
|
|
ACTACS |
optional |
CHAR(1) |
Calculation Order |
Calculation sequence |
|
ACTACP |
optional |
DECIMAL(6, 2) |
Document level allowance percentage |
The percentage that may be used, in conjunction with the document level allowance base amount, to calculate the document level allowance amount. |
|
ACTACBAD |
optional |
DECIMAL(15, 4) |
Document level allowance base amount |
The base amount that may be used, in conjunction with the document level allowance percentage, to calculate the document level allowance amount. |
|
ACTACBQ |
optional |
DECIMAL(15, 4) |
Base quantity of discount |
|
|
ACTTEACBPU |
required wenn ACTACBQ gefüllt ist. |
VARCHAR(10) |
UNIT pricing Base |
|
|
ACTACBA |
required |
DECIMAL(15, 2) |
Document level allowance amount |
The amount of an allowance, without VAT. |
|
ACTACRC |
optional |
CHAR(5) |
Document level allowance reason code |
The reason for the document level allowance, expressed as a code.
|
|
ACACRCCL |
optional |
CHAR(5) |
Code list qualifier |
Code list qualifier for the reason code (ACTACRC) of a non VAT tax reason. Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
|
ACTACRF |
optional |
VARCHAR(200) |
Document level allowance reason |
The reason for the document level allowance, expressed as text. |
|
ACTAXT |
required |
CHAR(5) |
Type of tax (code) |
|
|
ACTAXCAT |
required |
CHAR(2) |
Document level allowance VAT category code |
A coded identification of what VAT category applies to the document level allowance. |
|
ACTAXPER |
optional |
DECIMAL(6, 2) |
Document level allowance VAT rate |
The VAT rate, represented as percentage that applies to the document level allowance. |
|
ACVERT |
optional |
VARCHAR(128) |
VAT exemption reason text |
Reason for the VAT exemption of the allowance/charge tax as free text. Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
|
ACVERC |
optional |
CHAR(5) |
VAT exemption reason code |
Reason for the VAT exemption of the allowance/charge tax, expressed as a code. Available from ZUGFeRD 2.5 (EXTENDED profile, i-effect 3.1.18). |
The following list contains the business rule numbers corresponding to the fields, the XML target elements and further explanations.
|
Column name |
XML Element |
EN16931-ID |
Example |
Info |
|---|---|---|---|---|
|
ACTACI |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:ChargeIndicator |
BG-20-0 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:ChargeIndicator |
BG-21-0 |
|
|
|
ACTACS |
SequenceNumeric |
|
|
|
|
ACTACP |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:CalculationPercent |
BT-94 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:CalculationPercent |
BT-101 |
|
|
|
ACTACBAD |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:BasisAmount |
BT-93 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:BasisAmount |
BT-100 |
|
|
|
ACTACBQ |
BasisQuantity |
|
|
|
|
ACTTEACBPU |
unitCode |
|
|
|
|
ACTACBA |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:ActualAmount |
BT-92 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:ActualAmount |
BT-99 |
|
|
|
ACTACRC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:ReasonCode |
BT-98 |
Use entries of the UNTDID 5189 code list [6]. The Document level allowance reason code and the Document level allowance reason shall indicate the same allowance reason. |
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:ReasonCode |
BT-105 |
Use entries of the UNTDID 7161 code list [6]. The Document level charge reason code and the Document level charge reason shall indicate the same charge reason. |
|
|
ACACRCCL |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge/ram:ReasonCode/@listID |
BT-177-1 |
Value = 5153 |
from ZUGFeRD 2.5 (EXTENDED); BR-FXEXT-38, BR-FXEXT-CO-06, BR-FXEXT-CO-22 |
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeSettlement/ram:SpecifiedTradeAllowanceCharge/ram:ReasonCode/@listID |
BT-193-1 |
Value = 5153 |
from ZUGFeRD 2.5 (EXTENDED); BR-FXEXT-44, BR-FXEXT-CO-8, BR-FXEXT-CO-24 |
|
ACTACRF |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:Reason |
BT-97 |
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:Reason |
BT-104 |
|
|
|
ACTAXT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:CategoryTradeTax/ram:TypeCode |
BT-95-0 |
Fixed value = "VAT" |
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:CategoryTradeTax/ram:TypeCode |
BT-102-0 |
Fixed value = "VAT" |
|
|
ACTAXCAT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:CategoryTradeTax/ram:CategoryCode |
BT-95 |
The following entries of UNTDID 5305 [6] are used (further clarification between brackets):
|
|
|
|
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="true"]/ram:CategoryTradeTax/ram:CategoryCode |
BT-102 |
The following entries of UNTDID 5305 [6] are used (further clarification between brackets):
|
|
|
ACTAXPER |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:CategoryTradeTax/ram:RateApplicablePercent |
BT-96 |
|
|
|
ACVERT |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge/ram:CategoryTradeTax/ram:ExemptionReason |
BT-173 / BT-175 |
The reason, expressed as text, for exemption from this trade related tax |
from ZUGFeRD 2.5 (EXTENDED) |
|
ACVERC |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge/ram:CategoryTradeTax/ram:ExemptionReasonCode |
BT-174 / BT-176 |
The reason, expressed as code, for exemption from this trade related tax. VATEX (VAT exemption reason and specification) code list |
from ZUGFeRD 2.5 (EXTENDED); VATEX code list |