|
Column name |
Status |
Column definition |
Technical term |
Column description |
XML Element |
EN16931-ID |
Example |
|---|---|---|---|---|---|---|---|
|
TIKEY |
required |
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
|
|
TIREF |
required |
DECIMAL(5, 0) |
Reference ID to the Specified Table |
Reference to table (i-effect column) |
|
|
0 = document header |
|
TITYPE |
required |
CHAR(1) |
Type of Tax |
Type of tax (i-effect column) |
|
|
0 = Taxes in document header/footer |
|
TILFD |
required |
DECIMAL(5, 0) |
Order of Tax |
Control sequence (i-effect column) |
|
|
|
|
TITAXA |
required |
DECIMAL(15, 2) |
Tax amount calculated |
Category-specific tax amount |
CalculatedAmount |
BT-117 |
|
|
TITAXT |
required |
CHAR(5) |
Type of Tax |
VAT category code |
TypeCode |
BT-118-0 |
VAT |
|
TITAXFT |
optional |
VARCHAR(255) |
Reason for tax exemption |
Reason for tax exemption (free text) |
ExemptionReason |
BT-120 |
|
|
TITAXBA |
required |
DECIMAL(15, 2) |
Basic Amount for Tax calculation |
tax base amount |
BasisAmount |
BT-116 |
|
|
TITAXGA |
optional |
DECIMAL(15, 2) |
Goods amount of the Tax rate |
Amount of goods subject to tax |
LineTotalBasisAmount |
|
|
|
TITAXCOMA |
optional |
DECIMAL(15, 2) |
Total amount increases and reductions in the tax rate |
Total amount of tax rate increases and reductions |
AllowanceChargeBasisAmount |
|
|
|
TITAXCAT |
required |
CHAR(2) |
Tax category |
Coded designation of a sales tax category |
CategoryCode |
BT-118 |
S |
|
TITAXFTC |
optional |
CHAR(16) |
Reason for tax exemption (CODE) |
Code for the reason for VAT exemption |
ExemptionReasonCode |
BT-121 |
|
|
TITAXTPD |
optional |
DATE '0001-01-01' |
Tax due date |
tax due date |
TaxPointDate |
|
|
|
TITAXDTC |
optional |
CHAR(5) |
Code for the tax due date |
Code for the tax due date |
DueDateTypeCode |
BT-8 |
|
|
TITAXPER |
optional |
DECIMAL(6, 2) |
Tax rate |
Category-specific sales tax rate |
RateApplicablePercent |
BT-119 |
19.00 |