|
|
|
Tag Name
|
Type
|
Min Occurs
|
Max Occurs
|
Description
|
rms Mapping For
DSDDeals
|
|
Table Name
|
Column Name
|
API Type
|
Column Length
|
API Required
|
API Description
|
|
order_no
|
number8
|
1
|
1
|
Not used by SIM
|
ordhead
|
order_no
|
null
|
null
|
Yes
|
The order number
that the deal should be applied.
|
|
supplier
|
varchar210
|
1
|
1
|
Not used by SIM
|
invc_head
|
supplier
|
null
|
null
|
Yes
|
Invoice Supplier's
Number.
|
|
store
|
number10
|
1
|
1
|
This field
contains the location that the shipment will be delivered to.
|
shipment
|
to_loc
|
number
|
10
|
Yes
|
This field
contains the location that the shipment will be delivered to.
|
|
dept
|
number4
|
0
|
1
|
Not used by SIM
|
n/a
|
n/a
|
null
|
null
|
No
|
Not used by RMS.
|
|
currency_code
|
varchar23
|
1
|
1
|
Not used by SIM
|
n/a
|
n/a
|
null
|
null
|
Yes
|
Not used by RMS.
|
|
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 used by SIM
|
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
|
null
|
null
|
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
|
null
|
null
|
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 that 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 that the
invoice was paid from the POS system. This field will be populated when
the invoice is interfaced through ReSA.
|
|
deals_ind
|
varchar21
|
1
|
1
|
Specifies whether
deals will be applied to the generated order. If set to 'Y', the
procedure APPLY_DEALS_TO_ORDER will be called.
|
n/a
|
n/a
|
null
|
null
|
Yes
|
Specifies whether
deals will be applied to the generated order. If set to 'Y', the
procedure APPLY_DEALS_TO_ORDER will be called.
|
|
shipment
|
number10
|
1
|
1
|
The corresponding
shipment for the order that was applied by the deal.
|
shipment
|
shipment
|
null
|
null
|
No
|
The corresponding
shipment for the order that was applied by the deal.
|
|
invc_id
|
number10
|
1
|
1
|
Contains the
invoice number for the purchase order of this deal.
|
invc_head
|
invc_id
|
null
|
null
|
No
|
Contains the
invoice number for the purchase order of this deal.
|
|
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.
|
|
vdate
|
xs:dateTime
|
1
|
1
|
Not used by SIM
|
period
|
vdate
|
null
|
null
|
Yes
|
Contains the
current date of the RMS application.
|
|
qty_sum
|
number12_4
|
1
|
1
|
Not used by SIM
|
invc_head
|
total_qty
|
null
|
null
|
No
|
Total quantity of
items on the order to be invoiced.
|
|
cost_sum
|
number20_4
|
1
|
1
|
Total merchandise
cost for the invoice. This field will be held in the invoice currency.
|
invc_head
|
total_merch_cost
|
null
|
null
|
No
|
Total merchandise
cost for the invoice. This field will be held in the invoice currency.
|
|
ext_receipt_no
|
varchar217
|
1
|
1
|
Description is not
available.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
|
ExtOfDSDDealsDesc:ExtOfDSDDeals
|
*
|
0
|
1
|
Provide an extension hook to
customize DSDDeals.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|
