XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for LocPOTsfDealsDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
deal_id |
number10 |
1 |
1 |
Not Yet Available |
deal_head |
Fill table column name. |
number |
10 |
Yes |
Unique Deal number |
deal_type |
varchar210 |
1 |
1 |
Not Yet Available |
deal_head |
type |
varchar2 |
10 |
Yes |
Type of the deal. Valid values are A for annual deal, P for promotional deal, O for PO-specific deal or M for vendor-funded markdown. |
active_date |
xs:dateTime |
1 |
1 |
Not Yet Available |
deal_head |
active_date |
date |
Fill column length. |
Yes |
This is the date the deal will become active |
close_date |
xs:dateTime |
0 |
1 |
Not Yet Available |
deal_head |
close_date |
date |
Fill column length. |
No |
Date the deal will/did end. This date determines when deal components are no longer factored into item costs. |
deal_class |
varchar26 |
0 |
1 |
Not Yet Available |
deal_detail |
deal_class |
varchar2 |
6 |
No |
Identifies the calculation class of the deal component. Valid values are CU for cumulative (discounts are added together and taken off as one lump sum), CS for cascade (discounts are taken one at a time with subsequent discounts taken off the result of the previous discount) and EX for exclusive (overrides all other discounts). EX type deal components are only valid for promotional deals. |
limit_type |
varchar26 |
0 |
1 |
Not Yet Available |
deal_head |
threshold_limit_type |
varchar2 |
6 |
No |
Identifies whether thresholds will be set up as qty values, currency amount values or percentages (growth rebates only). Valid values are Q for qty, A for currency amount or P for percentage. |
value_type |
varchar26 |
0 |
1 |
Not Yet Available |
deal_detail |
THRESHOLD_VALUE_TYPE |
varchar2 |
6 |
No |
Identifies whether the discount values associated with the thresholds will be set up as qty values, currency amount values, percentages or fixed amounts. Valid values are Q for qty, A for currency amount, P for percentage or F for fixed amount. Qty threshold deals are only allowed on off-invoice discounts. |
lower_limit |
number20 |
1 |
1 |
Not Yet Available |
deal_threshold |
lower_limit |
number |
20 |
Yes |
Lower limit of the deal component. This is the minimum value that must be met in order to get the specified discount. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_limit_type field of this deal component. |
upper_limit |
number20 |
1 |
1 |
Not Yet Available |
deal_threshold |
upper_limit |
number |
20 |
Yes |
Upper limit of the deal component. This is the maximum value for which the specified discount will apply. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_limit_type field of this deal component. |
value |
number20 |
1 |
1 |
Not Yet Available |
deal_threshold |
value |
number |
20 |
Yes |
Value of the discount that will be given for meeting the specified thresholds for this deal component. This value will be either a currency amount or quantity value, depending on the value in the deal_detail.threshold_value_type field of this deal component. |