Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

Application	Retail Merchandising System
Target Name Space	http://www.oracle.com/retail/integration/base/bo/DSDReceiptDesc/v1
Version	1.0
Description	This is root element of this document which contains name space definitions for the document elements.
	DSDReceiptDesc DSDReceipt DSDDtl ExtOfDSDDtl DSDNonMerch ExtOfDSDNonMerch ExtOfDSDReceipt ExtOfDSDReceiptDesc

XML-Schema Name:DSDReceiptDesc

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For DSDReceiptDesc
					Table Name	Column Name	API Type	Column Length	API Required	API Description
DSDReceipt	*	1	unbounded	Description is not available.
ExtOfDSDReceiptDesc:ExtOfDSDReceiptDesc	*	0	1	Provide an extension hook to customize DSDReceipt.	NA	NA	NA	NA	NA	NA

XML-Schema Name:DSDReceipt

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For DSDReceipt
					Table Name	Column Name	API Type	Column Length	API Required	API Description
supplier	varchar210	1	1	Unique identifying number for a supplier for the receipt.	ordhead	supplier	null	null	Yes	Unique identifying number for a supplier for the receipt.
origin_country_id	varchar23	1	1	The identifier of the country from which the item is being sourced.	ordsku	origin_country_id	null	null	Yes	The identifier of the country from which the item is being sourced.
store	number10	1	1	Not Yet Available	store	store	number	10	Yes	Contains the number which uniquely identifies the store.
dept	number4	0	1	The department in which are all the items on the order. This field is required if the system enforces single department ordering.	deps	dept	null	null	No	The department in which are all the items on the order. This field is required if the system enforces single department ordering.
currency_code	varchar23	1	1	Contains a code identifying the currency the supplier uses for business transactions.	sups	currency_code	varchar2	3	Yes	Contains a code identifying the currency the supplier uses for business transactions.
paid_ind	varchar21	1	1	Indicates if the invoice has already been paid. Valid values are 'Y' (invoice has already been paid) or 'N' (invoice should be paid in AP system).	invc_head	paid_ind	varchar2	1	Yes	Indicates if the invoice has already been paid. Valid values are 'Y' (invoice has already been paid) or 'N' (invoice should be paid in AP system).
ext_ref_no	varchar230	0	1	Not Yet Available	invc_head	ext_ref_no	varchar2	14	No	Any given supplier-generated invoice number.
proof_of_delivery_no	varchar230	0	1	Proof of delivery or service number, given at the time of receipt at the store. This field will be populated when the invoice is interfaced through ReSA.	invc_head	proof_of_delivery_no	varchar2	30	No	Proof of delivery or service number, given at the time of receipt at the store. This field will be populated when the invoice is interfaced through ReSA.
payment_ref_no	varchar216	0	1	Reference number attached to the invoice payment, used when the invoice is paid from the POS system and interfaced through ReSA	invc_head	payment_ref_no	varchar2	16	No	Reference number attached to the invoice payment, used when the invoice is paid from the POS system and interfaced through ReSA
payment_date	xs:dateTime	0	1	Date when the invoice was paid from the POS system. This field will be populated when the invoice is interfaced through ReSA.	invc_head	payment_date	RIBDate	*	No	Date when the invoice was paid from the POS system. This field will be populated when the invoice is interfaced through ReSA.
invc_ind	varchar21	1	1	Inidcates whether an invoice was created for this receipt by the supplier.	n/a	n/a	null	null	Yes	Inidcates whether an invoice was created for this receipt by the supplier.
deals_ind	varchar21	1	1	Valid values are 'Y' and NULL. This field decides whether deals need to be applied to the order or not.	n/a	n/a	null	null	Yes	Valid values are 'Y' and NULL. This field decides whether deals need to be applied to the order or not.
DSDDtl	*	0	unbounded	Description is not available.
DSDNonMerch	*	0	unbounded	Description is not available.
ext_receipt_no	varchar217	0	1	This field holds the external transaction sequence number for the receipt.	shipment	ext_ref_no_in	null	null	No	This field holds the external transaction sequence number for the receipt.
ExtOfDSDReceiptDesc:ExtOfDSDReceipt	*	0	1	Provide an extension hook to customize DSDReceipt.	NA	NA	NA	NA	NA	NA

XML-Schema Name:DSDDtl

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For DSDDtl
					Table Name	Column Name	API Type	Column Length	API Required	API Description
item	varchar225	1	1	Not Yet Available	shipsku	item	null	null	Yes	Item that was received for the DSD.
qty_received	number12_4	1	1	Contains the number of items already received for the SKU / Shipment combination.	shipsku	qty_received	null	null	Yes	Contains the number of items already received for the SKU / Shipment combination.
unit_cost	number20_4	0	1	This field contains the cost for the SKU from the supplier/ origin country. This field is stored in the supplier's currency.	ordloc	unit_cost	null	null	No	This field contains the cost for the SKU from the supplier/ origin country. This field is stored in the supplier's currency.
weight	number12_4	0	1	Contains the actual weight of the item on received.	shipsku	weight_received	null	null	No	Contains the actual weight of the item on received.
weight_uom	varchar24	0	1	Contains the unit of measure of the received weight (e.g. pounds, kilograms).	shipsku	weight_received_uom	null	null	No	Contains the unit of measure of the received weight (e.g. pounds, kilograms).
ExtOfDSDReceiptDesc:ExtOfDSDDtl	*	0	1	Provide an extension hook to customize DSDDtl.	NA	NA	NA	NA	NA	NA

XML-Schema Name:ExtOfDSDDtl

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfDSDDtl
					Table Name	Column Name	API Type	Column Length	API Required	API Description

XML-Schema Name:DSDNonMerch

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For DSDNonMerch
					Table Name	Column Name	API Type	Column Length	API Required	API Description
non_merch_code	varchar26	1	1	Code identifying a non-merchandise cost that can be added to an invoice.	invc_non_merch_temp	non_merch_code	varchar2	6	Yes	Code identifying a non-merchandise cost that can be added to an invoice.
non_merch_amt	number20	1	1	Amount of the non-merchandise cost, specified by the non-merchandise code, that has been invoiced for. This field will be held in the invoice currency.	invc_non_merch_temp	non_merch_amt	number	20	Yes	Amount of the non-merchandise cost, specified by the non-merchandise code, that has been invoiced for. This field will be held in the invoice currency.
vat_code	varchar26	0	1	Code identifying the VAT rate that should be applied to the non_merch_amt entered.	invc_non_merch_temp	vat_code	varchar2	6	No	Code identifying the VAT rate that should be applied to the non_merch_amt entered.
service_perf_ind	varchar21	1	1	Indicates if a service non-merchandise cost has actually been performed. Valid values are 'Y' (service has been performed) or 'N' (service has not been performed or non-merchandise cost is not a service cost).	invc_non_merch_temp	service_perf_ind	varchar2	1	Yes	Indicates if a service non-merchandise cost has actually been performed. Valid values are 'Y' (service has been performed) or 'N' (service has not been performed or non-merchandise cost is not a service cost).
ExtOfDSDReceiptDesc:ExtOfDSDNonMerch	*	0	1	Provide an extension hook to customize DSDNonMerch.	NA	NA	NA	NA	NA	NA

XML-Schema Name:ExtOfDSDNonMerch

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfDSDNonMerch
					Table Name	Column Name	API Type	Column Length	API Required	API Description

XML-Schema Name:ExtOfDSDReceipt

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfDSDReceipt
					Table Name	Column Name	API Type	Column Length	API Required	API Description

XML-Schema Name:ExtOfDSDReceiptDesc

Version:13.1.1

Return to Top

Tag Name	Type	Min Occurs	Max Occurs	Description	rms Mapping For ExtOfDSDReceiptDesc
					Table Name	Column Name	API Type	Column Length	API Required	API Description