|
Column name |
Status |
Column definition |
Technical term |
Column description |
XML Element |
EN16931-ID |
Example |
|---|---|---|---|---|---|---|---|
|
ACKEY |
required |
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
|
|
ACREF |
required |
DECIMAL(5, 0) |
Reference ID to the Specified Table |
Referencing the tables (i-effect column) |
|
|
0 = Head level |
|
ACTYPE |
required |
CHAR(1) |
Type of Allowance Charge |
Type of surcharge/discount |
|
|
0 = Surcharge/discount at head level |
|
ACLFD |
required |
DECIMAL(5, 0) |
Order of the Sur/decution |
Order of additions and deductions (i-effect column) |
|
|
|
|
ACTACI |
required |
CHAR(5) |
Switch for Sur/deduction |
Switch for on/off |
ChargeIndicator |
BG-20-0, BG-21-0 |
|
|
ACTACS |
optional |
CHAR(1) |
Calculation Order |
Calculation sequence |
SequenceNumeric |
|
|
|
ACTACP |
optional |
DECIMAL(6, 2) |
Discount Percentage |
Percentage surcharge or discount at document level |
CalculationPercent |
BT-94, BT-101 |
|
|
ACTACBAD |
optional |
DECIMAL(15, 4) |
Basic amount of discount |
Basic amount of the surcharge or discount at document level |
BasisAmount |
BT-93, BT-100 |
|
|
ACTACBQ |
optional |
DECIMAL(15, 4) |
Base quantity of discount |
Base amount of the discount |
BasisQuantity |
|
|
|
ACTTEACBPU |
required wenn ACTACBQ gefüllt ist. |
VARCHAR(10) |
UNIT pricing Base |
Unit of the price base quantity |
unitCode |
|
|
|
ACTACBA |
required |
DECIMAL(15, 2) |
Amount of Sur/deduction |
Amount of the surcharge or discount at document level |
ActualAmount |
BT-92, BT-99 |
|
|
ACTACRC |
optional |
CHAR(5) |
Reason of Sur/deduction(Code) |
Code for the reason for the surcharge or discount at document level |
ReasonCode |
BT-98, BT-105 |
|
|
ACTACRF |
optional |
VARCHAR(200) |
Reason of Sur/deduction(Free text) |
Reason for the surcharge or discount at document level |
Reason |
BT-97, BT-104 |
|
|
ACTAXT |
required |
CHAR(5) |
Type of Tax |
Code for the sales tax category of the surcharge or discount at document level |
TypeCode |
BT-95-0, BT-102-0 |
|
|
ACTAXCAT |
required |
CHAR(2) |
Tax category |
Code for the sales tax category of the surcharge or discount at document level |
CategoryCode |
BT-95, BT-102 |
|
|
ACTAXPER |
optional |
DECIMAL(6, 2) |
Tax rate |
Sales tax rate for surcharges or discounts at document level |
RateApplicablePercent |
BT-96, BT-103 |
|