|
Column name |
Status |
Column definition |
Technical term |
Column description |
XML Element |
EN16931-ID |
Example |
|---|---|---|---|---|---|---|---|
|
DRKEY |
required |
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
|
|
DRREF |
required |
DECIMAL(5, 0) |
Position number |
item number |
|
|
0 |
|
DRTYPE |
required |
CHAR(1) |
Type of reference |
Type of referencing (i-effect column) |
|
|
0 = head level |
|
DRLFD |
required |
DECIMAL(5, 0) |
Order of document references |
Order of document references (i-effect column) |
|
|
|
|
DRDOLIC |
required |
VARCHAR(50) |
Document number |
Document identifier |
IssuerAssignedID |
BT-17,BT-18,BT-122 |
1,55842E+11 |
|
DRDURIID |
optional |
VARCHAR(255) |
URIID |
Place of reference of the document giving rise to the invoice |
URIID |
BT-124 |
|
|
DRDOLID |
optional |
INTEGER |
Referenced Position |
Referenced position |
LineID |
|
|
|
DRDTYPECO |
required |
VARCHAR(10) |
Type Code |
Type of referenced document |
TypeCode |
BT-17-0,BT-18-0,BT-122-0 |
|
|
DRNAME |
optional |
VARCHAR(35) |
Name |
Description of the document justifying the invoice |
Name |
BT-123 |
|
|
DRDMIMECO |
required |
VARCHAR(60) |
MIME Code of File |
MIME code of the attachment document |
mimeCode |
BT-125-1 |
|
|
DRDFILENA |
required |
VARCHAR(35) |
Filename |
File name of the attachment |
filename |
BT-125-2 |
|
|
DRDTYOFRED |
optional |
VARCHAR(10) |
Type of referenced Document |
Identification of the scheme |
ReferenceTypeCode |
BT-18-1 |
BO |
|
DRDOIDTD |
optional |
DATE '0001-01-01' |
Document date |
Document date |
FormattedIssueDateTime |
|
24.12.2018 10:04 |