 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:DSDReceiptDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| DSDReceipt | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:DSDReceipt |
| Tag Name | Table Name | Column Name | API Req | Description |
| supplier | ordhead | supplier | Yes | Unique identifying number for a supplier for the receipt. |
| origin_country_id | ordsku | origin_country_id | Yes | The identifier of the country from which the item is being sourced. |
| store | store | store | Yes | Contains the number which uniquely identifies the store. |
| dept | deps | dept | 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 | sups | currency_code | Yes | Contains a code identifying the currency the supplier uses for business transactions. |
| paid_ind | invc_head | paid_ind | 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 | invc_head | ext_ref_no | No | Any given supplier-generated invoice number. |
| proof_of_delivery_no | invc_head | proof_of_delivery_no | 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 | invc_head | payment_ref_no | No | Reference number attached to the invoice payment, used when the invoice is paid from the POS system and interfaced through ReSA |
| payment_date | invc_head | payment_date | 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 | n/a | n/a | Yes | Inidcates whether an invoice was created for this receipt by the supplier. |
| deals_ind | n/a | n/a | Yes | Valid values are 'Y' and NULL. This field decides whether deals need to be applied to the order or not. |
| DSDDtl | * | * | * | * |
| DSDNonMerch | * | * | * | * |
| ext_receipt_no | shipment | ext_ref_no_in | No | This field holds the external transaction sequence number for the receipt. |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:DSDDtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| item | shipsku | item | Yes | Item that was received for the DSD. |
| qty_received | shipsku | qty_received | Yes | Contains the number of items already received for the SKU / Shipment combination. |
| unit_cost | ordloc | unit_cost | No | This field contains the cost for the SKU from the supplier/ origin country. This field is stored in the supplier's currency. |
| weight | shipsku | weight_received | No | Contains the actual weight of the item on received. |
| weight_uom | shipsku | weight_received_uom | No | Contains the unit of measure of the received weight (e.g. pounds, kilograms). |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:DSDNonMerch |
| Tag Name | Table Name | Column Name | API Req | Description |
| non_merch_code | invc_non_merch_temp | non_merch_code | Yes | Code identifying a non-merchandise cost that can be added to an invoice. |
| non_merch_amt | invc_non_merch_temp | non_merch_amt | 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 | invc_non_merch_temp | vat_code | No | Code identifying the VAT rate that should be applied to the non_merch_amt entered. |
| service_perf_ind | invc_non_merch_temp | service_perf_ind | 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). |