Skip to main content
Skip table of contents

ZF2INVAC - Detailed information on markups and markdowns

Header - surcharges and discounts at document level

Column name

In use?StatusColumn definitionColumn descriptionTechnical termExample
ACKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
ACREFx
DECIMAL(5, 0)Reference ID to the Specified Table

Referenzierung auf die Tabellen (i-effect Spalte)

0 = header level
ACTYPEx

CHAR(1)

Type of Allowance ChargeType of surcharge/discount

0 = Surcharge/discount at header level

ACLFDx
DECIMAL(5, 0)Order of the Sur/decutionOrder of surcharges and discounts (i-effect column)
ACTACIxrequiredCHAR(5)Switch for Sur/deductionSwitch for increase/decrease
ACTACSxoptionalCHAR(1)Calculation OrderCalculation sequence
ACTACP

x

optional

DECIMAL(6, 2)Discount Percentage

Percentage surcharge or discount at document level


ACTACBAD

x

optionalDECIMAL(15, 4)Basic amount of discount

Basic amount of the surcharge or discount at document level


ACTACBQxoptionalDECIMAL(15, 4)Base quantity of discountBase quantity of the discount
ACTTEACBPUxrequired if ACTACBQ is filledVARCHAR(10)UNIT pricing BaseUnit of the price base quantity
ACTACBA

x

requiredDECIMAL(15, 2)Amount of Sur/deductionamount of the surcharge or discount at document level
ACTACRCxoptionalCHAR(5)Reason of Sur/deduction(Code)

Code for the reason for the surcharge or discount at document level


ACTACRFxoptionalVARCHAR(200)Reason of Sur/deduction(Free text)Reason for the surcharge or discount at document level
Detailed information on tax details (only available in header) (required)

ACTAXT

x

required

CHAR(5)

Type of Tax

Code for the VAT category of the surcharge or deduction at document level


ACTAXCAT

x

required

CHAR(2)

Tax category

Code for the VAT category of the surcharge or deduction at document level


ACTAXPER

x

optional

DECIMAL(6, 2)

Tax rate

VAT rate for the surcharge or discount at document level


Items - deductions at invoice item level

Column name

In use?StatusColumn definitionColumn descriptionTechnical termExample
ACKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
ACREFx
DECIMAL(5, 0Reference ID to the Specified Table

Reference to the tables (i-effect column)

ZF2INVPI (PIREF)


ACTYPEx

CHAR(1)

Type of Allowance ChargeType of surcharge/discount

1 = Addition/deduction at item level

ACLFDx
DECIMAL(5, 0)Order of the Sur/decutionOrder of surcharges and discounts (i-effect column)
ACTACIxoptionalCHAR(5)Switch for Sur/deductionSwitch for increase/decrease
ACTACS

CHAR(1)Calculation OrderCalculation sequence
ACTACP

x

optional

DECIMAL(6, 2)Discount Percentage

Percentage surcharge/discount at invoice item level


ACTACBAD

x

optionalDECIMAL(15, 4)Basic amount of discount

Basic amount of the surcharge/discount at invoice item level


ACTACBQ

DECIMAL(15, 4)Base quantity of discountBase quantity of the discount
ACTTEACBPU

VARCHAR(10)UNIT pricing BaseUnit of the price base quantity
ACTACBA

x

requiredDECIMAL(15, 2)Amount of Sur/deductionAmount of the surcharge/discount at invoice item level
ACTACRCxoptionalVARCHAR(5)Reason of Sur/deduction(Code)

Code for the reason for the surcharge/discount at invoice item level


ACTACRFxoptionalVARCHAR(200)Reason of Sur/deduction(Free text)Reason for the surcharge/discount at invoice item level
Detailed information on tax details (only available in header) (required)

ACTAXT



CHAR(5)

Type of Tax

Code for the VAT category of the surcharge or deduction at document level


ACTAXCAT



CHAR(2)

Tax category

Code for the VAT category of the surcharge or deduction at document level


ACTAXPER



DECIMAL(6, 2)

Tax rate

VAT rate for the surcharge or discount at document level


Position - discounts on the level of the gross price of the item (detailed information on surcharges and discounts)

Column name

In use?StatusColumn definitionColumn descriptionTechnical termExample
ACKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
ACREFx
DECIMAL(5, 0Reference ID to the Specified Table

Reference to the tables (i-effect column)

ZF2INVPI (PIREF)


ACTYPEx

CHAR(1)

Type of Allowance ChargeType of surcharge/discount

2 = Surcharge/discount on gross price level of the article

ACLFDx
DECIMAL(5, 0)Order of the Sur/decutionOrder of surcharges and discounts (i-effect column)
ACTACIxrequiredCHAR(5)Switch for Sur/deductionSwitch for increase/decrease
ACTACS

CHAR(1)Calculation OrderCalculation sequence
ACTACP

x

optional

DECIMAL(6, 2)Discount Percentage

Discount in percent


ACTACBAD

x

optionalDECIMAL(15, 4)Basic amount of discount

Base amount of the discount


ACTACBQ

DECIMAL(15, 4)Base quantity of discountBase quantity of the discount
ACTTEACBPU

VARCHAR(10)UNIT pricing BaseUnit of the price base quantity
ACTACBA

x

requiredDECIMAL(15, 2)Amount of Sur/deductionDiscount on the article price
ACTACRC

VARCHAR(5)Reason of Sur/deduction(Code)

Code for the reason for the increase or reduction


ACTACRFxoptionalVARCHAR(200)Reason of Sur/deduction(Free text)Reason for the surcharge/deduction (free text)
Detailed information on tax details (only available in header) (required)

ACTAXT



CHAR(5)

Type of Tax

Code for the VAT category of the surcharge or deduction at document level


ACTAXCAT



CHAR(2)

Tax category

Code for the VAT category of the surcharge or deduction at document level


ACTAXPER



DECIMAL(6, 2)

Tax rate

VAT rate for the surcharge or discount at document level


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.