ZF23INVAC - Detailed information on surcharges and discounts

This database table consists of the following fields

Column name	Status	Column definition	Technical term	Description
ACKEY	required	VARCHAR(15)	Reference to ZF23INVHT.HTKEY	Unique auto generated identifier
ACREF	required	INTEGER(4, 0)	Reference ID to the Parent Table	Reference to the Head (“0”) or the line item (<> “0”)
ACTYPE	required	CHAR(1)	Type of Allowance Charge	0 = Document level 1 = Line level 2 = Gross price level
ACLFD	required	DECIMAL(5, 0)	Order of the Sur/decution	Sequence of the Allowance or charge
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.
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.

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
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.
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): Standard rate (Liable for VAT in a standard way) Zero rated goods (Liable for VAT with a percentage rate of zero) Exempt from tax (VAT/IGIC/IPSI) VAT Reverse Charge (Reverse charge VAT/IGIC/IPSI rules apply) VAT exempt for intra community supply of goods (VAT/IGIC/IPSI not levied due to Intra-community supply rules) Free export item, tax not charged (VAT/IGIC/IPSI not levied due to export outside of the EU) Services outside scope of tax (Sale is not subject to VAT/IGIC/IPSI) Canary Islands General Indirect Tax (Liable for IGIC tax) Liable for IPSI (Ceuta/Melilla tax)
	/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): Standard rate (Liable for VAT in a standard way) Zero rated goods (Liable for VAT with a percentage rate of zero) Exempt from tax (VAT/IGIC/IPSI) VAT Reverse Charge (Reverse charge VAT/IGIC/IPSI rules apply) VAT exempt for intra community supply of goods (VAT/IGIC/IPSI not levied due to Intra-community supply rules) Free export item, tax not charged (VAT/IGIC/IPSI not levied due to export outside of the EU) Services outside scope of tax (Sale is not subject to VAT/IGIC/IPSI) Canary Islands General Indirect Tax (Liable for IGIC tax) Liable for IPSI (Ceuta/Melilla tax)
ACTAXPER	/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeSettlement/ram:SpecifiedTradeAllowanceCharge[ram:ChargeIndicator/udt:Indicator="false"]/ram:CategoryTradeTax/ram:RateApplicablePercent	BT-96