ZF23INVDR - Detailangaben zu einer zusätzlichen Dokumentenreferenz
Diese Datenbanktabelle besteht aus den folgenden Feldern
Spaltenname | Status | Spaltendefinition | Fachbegriff | Beschreibung |
|---|---|---|---|---|
DRKEY | required | VARCHAR(15) | Reference ID head | Reference to ZF23INVHT.HTKEY |
DRREF | required | INTEGER(4, 0) | Reference ID line item | Reference to the Head (“0”) or reference to ZF23INVPI.PILFD |
DRTYPE | required | CHAR(1) | Type of reference | 0 = OriginatorDokumentReference (HEAD) 2 = AdditionalDokumentReferences (LINE) |
DRLFD | required | DECIMAL(5, 0) | Order of document references | Sequence of records within DRKEY, DRREF |
DRDOLIC | required | VARCHAR(50) | Tender or lot reference | The identification of the call for tender or lot the invoice relates to. |
Invoiced object identifier | An identifier for an object on which the invoice is based, given by the Seller. | |||
Supporting document reference | An identifier of the supporting document. | |||
DRDURIID | optional | VARCHAR(255) | External document location | The URL (Uniform Resource Locator) that identifies where the external document is located. |
DRDOLID | optional | INTEGER(4, 0) | Referenced position | |
DRDTYPECO | required | VARCHAR(10) | Referenced document type | |
Referenced document type | ||||
Referenced document type | ||||
DRNAME | optional | VARCHAR(1000) | Supporting document description | A description of the supporting document. |
DRDMIMECO | required | VARCHAR(60) | Attached document Mime code | The mime code of the attached document. |
DRDFILENA | required | VARCHAR(35) | Attached document Filename | The file name of the attached document |
DRDTYOFRED | optional | VARCHAR(10) | Scheme identifier | The identification scheme identifier of the Invoiced object identifier. |
DRDOIDTD | optional | DATE '0001-01-01' | Document date |