Header - Explanatory documents
|
Column name |
In use? |
Status |
Column definition |
Column description |
Technical term |
Example |
|---|---|---|---|---|---|---|
|
DRKEY |
x |
|
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
DRREF |
x |
|
DECIMAL(5, 0) |
Position number |
Positionsnummer |
0 |
|
DRTYPE |
x |
|
CHAR(1) |
Type of reference |
Type of referencing (i-effect column) |
0 = Header level |
|
DRLFD |
x |
|
DECIMAL(5, 0) |
Order of document references |
Order of document references (i-effect column) |
|
|
DRDOLIC |
x |
required |
VARCHAR(50) |
Document number |
Document identification |
0155841575145 |
|
DRDURIID |
x |
optional |
VARCHAR(55) |
URIID |
Reference place of the document on which the invoice is based |
|
|
DRDOLID |
|
|
INTEGER |
Referenced Position |
Referenced Position |
|
|
DRDTYPECO |
x |
required |
VARCHAR(10) |
Type Code |
Type of the referenced document |
|
|
DRNAME |
x |
optional |
VARCHAR(35) |
Name |
Description of the document on which the invoice is based |
|
|
AttachmentBinaryObject (optional) |
||||||
|
DRDMIMECO |
x |
required |
VARCHAR(60) |
MIME Code of File |
MIME code of the annex document |
|
|
DRDFILENA |
x |
required |
VARCHAR(35) |
Filename |
filename |
|
|
DRDTYOFRED |
x |
optional |
VARCHAR(10) |
Type of referenced Document |
Identification of the scheme |
BO |
|
DRDOIDTD |
x |
optional |
DATE '0001-01-01' |
Document date |
Document date |
2018-12-24 10:04:05Position number |
Position - Details of an additional document reference
|
Column name |
In use? |
Status |
Column definition |
Column description |
Technical term |
Example |
|---|---|---|---|---|---|---|
|
DRKEY |
x |
|
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
DRREF |
x |
|
DECIMAL(5, 0) |
Position number |
Position number |
|
|
DRTYPE |
x |
|
CHAR(1) |
Type of reference |
Type of referencing (i-effect column) |
1 = Position level |
|
DRLFD |
x |
|
DECIMAL(5, 0) |
Order of document references |
Order of document references (i-effect column) |
|
|
DRDOLIC |
x |
required |
VARCHAR(50) |
Document number |
Document number |
0155841575145 |
|
DRDURIID |
x |
optional |
VARCHAR(55) |
URIID |
URIID |
|
|
DRDOLID |
x |
optional |
INTEGER |
Referenced Position |
Referenced position |
|
|
DRDTYPECO |
x |
required |
VARCHAR(10) |
Type Code |
TypeCode |
|
|
DRNAME |
x |
optional |
VARCHAR(35) |
Name |
Name |
|
|
AttachmentBinaryObject (optional) |
||||||
|
DRDMIMECO |
x |
required |
VARCHAR(60) |
MIME Code of File |
MIME code of the annex document |
|
|
DRDFILENA |
x |
required |
VARCHAR(35) |
Filename |
filename |
|
|
DRDTYOFRED |
x |
optional |
VARCHAR(10) |
Type of referenced Document |
Type of referenced document |
BO |
|
DRDOIDTD |
x |
optional |
DATE '0001-01-01' |
Document date |
Document date |
2018-12-24 10:04:05 |
Item - object identifier at invoice item level
|
Column name |
Use? |
Status |
Column definition |
Column description |
Technical term |
Example |
|---|---|---|---|---|---|---|
|
DRKEY |
x |
|
VARCHAR(15) |
Internal pagination number |
Internal invoice number (i-effect column) |
|
|
DRREF |
x |
|
DECIMAL(5, 0) |
Position number |
Position number |
|
|
DRTYPE |
x |
|
CHAR(1) |
Type of reference |
Type of referencing (i-effect column) |
2 = Object identifier at invoice item level |
|
DRLFD |
x |
|
DECIMAL(5, 0) |
Order of document references |
Order of document references (i-effect column) |
|
|
DRDOLIC |
x |
optional |
VARCHAR(50) |
Document number |
Object identifier at invoice item level |
0155841575145 |
|
DRDURIID |
|
|
VARCHAR(55) |
URIID |
URIID |
|
|
DRDOLID |
|
|
INTEGER |
Referenced Position |
Referenced position |
|
|
DRDTYPECO |
x |
required |
VARCHAR(10) |
Type Code |
Type of identifier for an object on which the invoice item is based |
|
|
DRNAME |
|
|
VARCHAR(35) |
Name |
Name |
|
|
AttachmentBinaryObject (optional) |
||||||
|
DRDMIMECO |
|
|
VARCHAR(60) |
MIME Code of File |
MIME code of the annex document |
|
|
DRDFILENA |
|
|
VARCHAR(35) |
Filename |
filename |
|
|
DRDTYOFRED |
x |
optional |
VARCHAR(10) |
Type of referenced Document |
Identification of the scheme |
BO |
|
DRDOIDTD |
|
|
DATE '0001-01-01' |
Document date |
Document date |
2018-12-24 10:04:05 |