ZF2INVDR - Document references
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 | ||