ZF2INVDR - Einzelheiten einer zusätzlichen Dokumentenreferenz
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 | Position number | ||
| 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 number | 0155841575145 |
| DRDURIID | x | optional | VARCHAR(55) | URIID | URIID | |
| 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 | File name of the attachment document | |
| 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 | ||
Item - object identifier at invoice item level
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) | 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 identification at invoice item level (object identification) | 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 (object identifier) | |
| DRNAME | VARCHAR(35) | Name | Name | |||
| 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 schema (object identification) | BO |
| DRDOIDTD | DATE '0001-01-01' | Document date | Document date | 2018-12-24 10:04:05 |