Skip to main content
Skip table of contents

ZF2INVDR - Document references

Header - Explanatory documents

Column nameIn use?StatusColumn definitionColumn descriptionTechnical termExample
DRKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
DRREFx
DECIMAL(5, 0)Position numberPositionsnummer0
DRTYPEx
CHAR(1)Type of referenceType of referencing (i-effect column)

0 = Header level

DRLFDx
DECIMAL(5, 0)Order of document referencesOrder of document references (i-effect column)
DRDOLICxrequiredVARCHAR(50)Document numberDocument identification0155841575145
DRDURIIDxoptionalVARCHAR(55)URIIDReference place of the document on which the invoice is based
DRDOLID

INTEGERReferenced PositionReferenced Position
DRDTYPECOxrequired

VARCHAR(10)

Type Code

Type of the referenced document


DRNAMExoptional

VARCHAR(35)

NameDescription of the document on which the invoice is based
AttachmentBinaryObject (optional)
DRDMIMECOxrequiredVARCHAR(60)MIME Code of FileMIME code of the annex document
DRDFILENAxrequiredVARCHAR(35)Filenamefilename
DRDTYOFREDxoptionalVARCHAR(10)Type of referenced Document

Identification of the scheme

BO
DRDOIDTDxoptionalDATE '0001-01-01'Document dateDocument date2018-12-24 10:04:05Position number

Position - Details of an additional document reference

Column name

In use?StatusColumn definitionColumn descriptionTechnical termExample
DRKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
DRREFx
DECIMAL(5, 0)Position numberPosition number
DRTYPEx
CHAR(1)Type of referenceType of referencing (i-effect column)

1 = Position level

DRLFDx
DECIMAL(5, 0)Order of document referencesOrder of document references (i-effect column)
DRDOLICxrequiredVARCHAR(50)Document numberDocument number0155841575145
DRDURIIDxoptionalVARCHAR(55)URIIDURIID
DRDOLIDxoptionalINTEGERReferenced PositionReferenced position
DRDTYPECOxrequired

VARCHAR(10)

Type Code

TypeCode


DRNAMExoptional

VARCHAR(35)

NameName
AttachmentBinaryObject (optional)
DRDMIMECOxrequiredVARCHAR(60)MIME Code of FileMIME code of the annex document
DRDFILENAxrequiredVARCHAR(35)Filenamefilename
DRDTYOFREDxoptionalVARCHAR(10)Type of referenced Document

Type of referenced document

BO
DRDOIDTDxoptionalDATE '0001-01-01'Document dateDocument date2018-12-24 10:04:05

Item - object identifier at invoice item level

Column name

Use?StatusColumn definitionColumn descriptionTechnical termExample
DRKEYx
VARCHAR(15)Internal pagination numberInternal invoice number (i-effect column)
DRREFx
DECIMAL(5, 0)Position numberPosition number
DRTYPEx
CHAR(1)Type of referenceType of referencing (i-effect column)

2 = Object identifier at invoice item level

DRLFDx
DECIMAL(5, 0)Order of document referencesOrder of document references (i-effect column)
DRDOLICxoptionalVARCHAR(50)Document numberObject identifier at invoice item level0155841575145
DRDURIID

VARCHAR(55)URIIDURIID
DRDOLID

INTEGERReferenced PositionReferenced position
DRDTYPECOxrequired

VARCHAR(10)

Type Code

Type of identifier for an object on which the invoice item is based
DRNAME

VARCHAR(35)

NameName
AttachmentBinaryObject (optional)
DRDMIMECO

VARCHAR(60)MIME Code of FileMIME code of the annex document
DRDFILENA

VARCHAR(35)Filenamefilename
DRDTYOFREDxoptionalVARCHAR(10)Type of referenced Document

Identification of the scheme

BO
DRDOIDTD

DATE '0001-01-01'Document dateDocument date2018-12-24 10:04:05


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.