ZF23INVDR - Details of an additional document reference
This database table consists of the following fields
Column Name | Status | Column definition | Technical term | Description |
|---|---|---|---|---|
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 | |
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 |
The following list contains the business rule numbers corresponding to the fields, the XML target elements and further explanations.
Column name | XML Element | EN16931-ID | Example | Info |
|---|---|---|---|---|
DRDOLIC | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="50"]/ram:IssuerAssignedID | BT-17 | In some countries a reference to the call for tender that has led to the contract shall be provided. | |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="130"]/ram:IssuerAssignedID | BT-18 | It may be a subscription number, telephone number, meter point, vehicle, person etc., as applicable. | ||
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="916"]/ram:IssuerAssignedID | BT-122 | |||
DRDURIID | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="916"]/ram:URIID | BT-124 | A means of locating the resource including its primary access mechanism, e.g. http:// | |
DRDOLID | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:AdditionalReferencedDocument/ram:LineID | BT-X-29 | ||
DRDTYPECO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="50"]/ram:TypeCode | BT-17-0 | The code 50 "Price/sales catalogue response" shall be used to refer to the tendering or batch. (BT-17) | |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="130"]/ram:TypeCode | BT-18-0 | The code 130 "invoice data" shall be used to refer to the identifier of an object given by the seller (BT-18). | ||
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="916"]/ram:TypeCode | BT-122-0 | The code 916 "Additional supporting documents" shall be used to refer to the identification of additional supporting documents (BT-122). | ||
DRNAME | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="916"]/ram:Name | BT-123 | Such as: timesheet, usage report etc. | |
DRDMIMECO | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="916"]/ram:AttachmentBinaryObject/@mimeCode | BT-125-1 | Allowed mime codes:
| |
DRDFILENA | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="916"]/ram:AttachmentBinaryObject/@filename | BT-125-2 | ||
DRDTYOFRED | /rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:AdditionalReferencedDocument[ram:TypeCode="130"]/ram:ReferenceTypeCode | BT-18-1 | If it may be not clear for the receiver what scheme is used for the identifier, a onditional scheme identifier should be used that shall be chosen from the UNTDID 1153 code list [6] entries. | |
DRDOIDTD | FormattedIssueDateTime | 24.12.2018 10:04 |