This database table consists of the following fields
|
Column Name |
Status |
Column definition |
Technical term |
Description |
|---|---|---|---|---|
|
UDRKEY |
required |
VARCHAR(15) |
Reference ID head |
Reference to ZF23INVHT.HTKEY |
|
UDRREF |
required |
INTEGER(4) |
Reference ID line item |
Reference to the Head (“0”) or reference to ZF23INVPI.PILFD |
|
UDRLFD |
required |
DECIMAL(5) |
Order of the included Products |
Sequence of records within UDRKEY, UDRREF |
|
UDRISSID |
optional |
VARCHAR(50) |
Ultimate Customer Order number of the final customer |
|
|
UDRLINEID |
optional |
VARCHAR(50) |
Order item (ultimate customer) |
LineID |
|
UDRDOCDATE |
optional |
DATE '0001-01-01' |
Document date, value |
|
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 |
|---|---|---|---|
|
UDRISSID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:UltimateCustomerOrderReferencedDocument/ram:IssuerAssignedID |
BT-X-150 |
|
|
UDRLINEID |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:IncludedSupplyChainTradeLineItem/ram:SpecifiedLineTradeAgreement/ram:UltimateCustomerOrderReferencedDocument/ram:LineID |
BT-X-44 |
|
|
UDRDOCDATE |
/rsm:CrossIndustryInvoice/rsm:SupplyChainTradeTransaction/ram:ApplicableHeaderTradeAgreement/ram:UltimateCustomerOrderReferencedDocument/ram:FormattedIssueDateTime/qdt:DateTimeString |
BT-X-151 |
|