Retail Integration Mappings Report Release:16.0.21

Application	RCE
Target Name Space	http://www.oracle.com/retail/integration/base/bo/LoyPntRcvryCriVo/v1
Version	1.0
Description
XSD Structure	LoyPntRcvryCriVo LoyAcctRef

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for LoyPntRcvryCriVo in RCE application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	RCE's Table Name	RCE's Column Name	Integration API(RIB or/and RSB or/and RSL)	RCE's Column Length	Is Column Required in RCE's API?	RCE's API Description
transaction_id	varchar248	1	1	Contains the transaction or order id of the sale that should be re-evaluated for awarding loyalty points to the specified loyalty account.	Fill application table name.	Fill table column name.	RIB or/and RSB	Fill column length.	Yes	Fill this description.
LoyAcctRef:LoyAcctRef	*	1	1	A set of identifiers that refer to a specific loyalty account record. Typical detail to include would be the loyalty account id or the card number used to identify the shopper. Other details may be excluded.	NA	NA	NA	NA	NA	NA

XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	Mapping for LoyAcctRef in RCE application.
XSD Element Name	XSD Element Data Type	XSD Min Occurs	XSD Max Occurs	XSD Element Description	RCE's Table Name	RCE's Column Name	Integration API(RIB or/and RSB or/and RSL)	RCE's Column Length	Is Column Required in RCE's API?	RCE's API Description
account_id	varchar232	0	1	The id of the loyalty account as maintained by, and usually generated by, the loyalty system of record.	Fill application table name.	Fill table column name.	RIB or/and RSB	Fill column length.	Yes	Fill this description.
card_number	varchar232	0	1	The card number being searched when searching for a specific loyalty account. The card number could be the same as the account_id. There could also be more than one card associated with a single loyalty account.	Fill application table name.	Fill table column name.	RIB or/and RSB	Fill column length.	Yes	Fill this description.