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 |
|
In der folgenden Auflistung können die zu den Feldern passenden Geschäftsregelnummern, die XML Zielelemente und weitere Erläuterungen entnommen werden
|
Spaltenname |
XML Element |
EN16931-ID |
Beispiel |
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 |
|