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 |