Oracle® Retail Xstore Suite 19.0/Merchandising 16.0.2 Implementation Guide Release 19.0/16.0.2 F20787-06 |
|
![]() Previous |
![]() Next |
The mapping from the POSLog format to the RTLog format is defined in the Xstore configuration file RTLogMappingConfig.xml. This appendix provides details on the following mappings:
The ReSA transaction type values are defined in code_type TRAT.
The ReSA sub-transaction type values are defined in code_type TRAS.
Table A-1 describes the Xstore to ReSA transaction type mapping.
Table A-1 Transaction Type Mapping
Xstore Transaction Type | ReSA Transaction Type TRAT | ReSA Sub-Transaction Type TRAS | Description |
---|---|---|---|
ACCOUNT_LOOKUP |
OTHER |
OTHER |
ACCOUNT_LOOKUP transactions are passed from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. |
BALANCE_INQUIRY |
OTHER |
OTHER |
BALANCE_INQUIRY transactions are passed from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. |
CREDIT_APPLICATION |
OTHER |
OTHER |
CREDIT_APPLICATION transactions are passed from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. |
ESCROW |
OTHER |
OTHER |
ESCROW transactions are passed from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. |
EXCHANGE_RATE |
OTHER |
OTHER |
EXCHANGE_RATE transactions are passed from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. |
GNRIC |
OTHER |
OTHER |
GNRIC transactions are passed from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. |
INVENTORY_CONTROL |
OTHER |
OTHER |
INVENTORY_CONTROL transactions are mapped from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. Xstore should be configured so that inventory control transactions are not generated, and therefore not sent to ReSA. |
INVENTORY_SUMMARY_COUNT |
OTHER |
OTHER |
INVENTORY_SUMMARY_COUNT transactions are mapped from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. Xstore should be configured so that inventory summary count transactions are not generated, and therefore not sent to ReSA. |
MOVEMENT_PENDING |
OTHER |
OTHER |
MOVEMENT_PENDING transactions are mapped from Xstore to ReSA for full visibility audit, but not otherwise implemented in ReSA. Xstore should be configured so that inventory summary count transactions are not generated, and therefore not sent to ReSA. |
NO_SALE |
NOSALE |
NOSALE |
NA |
POST_VOID |
PVOID |
VOID |
NA |
RETAIL_SALE (can be mapped to multiple ReSA transaction types depending on other conditions) |
SALE |
SALE |
Regular transaction. |
NOSALE |
SUSPND |
Suspend transaction. |
|
VOID |
CANCEL |
Cancel transaction. |
|
VOID |
CANCEL |
Cancel orphaned transaction. |
|
SESSION_CONTROL |
OTHER |
OTHER |
Issue till. |
OTHER |
OTHER |
Assign till/assign till tender transfer. |
|
OTHER |
OTHER |
Attach till. |
|
OTHER |
OTHER |
Remove till. |
|
OTHER |
OTHER |
Return till. |
|
SYSTEM_CLOSE |
CLOSE |
CSTORE |
Close store. |
SYSTEM_OPEN |
OPEN |
OSTORE |
Open store. |
TENDER_CONTROL (can be mapped to multiple ReSA transaction types depending on other conditions) |
OPEN |
OTILL |
Begin till count. |
CLOSE with TOTAL /OTHER |
CTILL with CTILLT /OTHER |
Till closing count (register accountability/till accountability). |
|
CLOSE and TOTAL |
CTILL and CTILLT |
Till reconcile. Each counted tender type has a corresponding TOTAL and CTILLT as a THEAD. |
|
PAIDIN |
PITILL |
Pay in. |
|
PAIDOU |
POTILL |
Pay out. |
|
OTHER |
AUDIT |
Till audit. |
|
PULL |
PUTILL |
Mid-day deposit. Place funds in store bank. |
|
OTHER |
BANK |
Bank deposit. |
|
LOAN |
LOTILL |
Till loan (cash transfer). |
|
PULL |
PUTILL |
Pick up till (cash pickup). |
|
OTHER |
OTHER |
Open store bank. |
|
OTHER |
OTHER |
Store bank reconcile. |
|
TENDER_EXCHANGE |
PAIDIN |
PITILL |
NA |
TILL_CONTROL |
OTHER |
OTHER |
NA |
TIMECLOCK |
OTHER |
OTHER |
Employee clock in. |
OTHER |
OTHER |
Employee clock out. |
|
TRAINING_MODE_ENTRY |
OTHER |
NTRAIN |
NA |
TRAINING_MODE_EXIT |
OTHER |
XTRAIN |
NA |
WORKSTATION_CLOSE |
CLOSE |
CREG |
NA |
WORKSTATION_COMPLETE_REMOTE_CLOSE |
CLOSE |
CRGRC |
NA |
WORKSTATION_OPEN |
OPEN |
OREG |
NA |
WORKSTATION_START_REMOTE_CLOSE |
OTHER |
CRGRC |
NA |
GIFT_REGISTRY |
OTHER |
OTHER |
Assign gift registry (register operation) |
OTHER |
OTHER |
Reissue gift registry (register operation) |
|
RAIN_CHECK |
OTHER |
OTHER |
Redeem rain check. |
BATCH_CLOSE |
OTHER |
OTHER |
Credit and debit settlement. |
The ReSA tender type groups are defined in code_type TENT.
The ReSA tenders are defined in the seeded data table POS_TENDER_TYPE_HEAD.
Table A-2 describes the Xstore to ReSA transaction tender type mapping.
Table A-2 Tender Type Mapping
Xstore | Xstore POS Log Tender Group Type | ReSA RTLog | |||
---|---|---|---|---|---|
TenderTypeCode | TenderTypeID | Tender Type | Tender ID | TenderTypeGroup | TenderTypeID |
CURRENCY |
USD_CURRENCY |
Cash |
USD_CURRENCY |
CASH |
If primary 1000, if alternate 1010. |
AUD_CURRENCY |
Cash |
AUD_CURRENCY |
CASH |
If primary 1000, if alternate 1010. |
|
CAD_CURRENCY |
Cash |
CAD_CURRENCY |
CASH |
If primary 1000, if alternate 1010. |
|
EUR_CURRENCY |
Cash |
EUR_CURRENCY |
CASH |
If primary 1000, if alternate 1010. |
|
GBP_CURRENCY |
Cash |
GBP_CURRENCY |
CASH |
If primary 1000, if alternate 1010. |
|
CREDIT_CARD |
VISA |
CreditDebit |
VISA |
CCARD |
3000 |
MASTERCARD |
CreditDebit |
MASTERCARD |
CCARD |
3010 |
|
AMERICAN_EXPRESS |
CreditDebit |
AMERICAN_EXPRESS |
CCARD |
3020 |
|
DINERS_CLUB |
CreditDebit |
DINERS_CLUB |
CCARD |
3040 |
|
DISCOVER |
CreditDebit |
DISCOVER |
CCARD |
3030 |
|
JCB |
CreditDebit |
JCB |
CCARD |
3090 |
|
DEBITCARD |
CreditDebit |
DEBITCARD |
DCARD |
8000 |
|
ACCOUNT |
HOUSE_ACCOUNT |
dtv:Account |
HOUSE_ACCOUNT |
CCARD |
3120 |
A new type of credit card |
CreditDebit |
A new type of credit card |
CCARD |
Map to UNKNW. |
|
CHECK |
CHECK |
Check |
CHECK |
CHECK |
If primary 2000, if foreign 2050. |
TRAVELERS_CHECK |
USD_TRAVELERS_CHECK |
dtv:TravelersCheck |
USD_TRAVELERS_CHECK |
CHECK |
If primary 2020, if foreign 2060. |
CAD_TRAVELERS_CHECK |
dtv:TravelersCheck |
CAD_TRAVELERS_CHECK |
CHECK |
If primary 2020, if foreign 2060. |
|
VOUCHER |
GIFT_CERTIFICATE |
Voucher |
GIFT_CERTIFICATE |
VOUCH |
If primary 4030, if foreign 4100. |
ISSUE_GIFT_CERTIFICATE |
Voucher |
ISSUE_GIFT_CERTIFICATE |
VOUCH |
If primary 4030, if foreign 4100. |
|
ISSUE_MERCHANDISE_CREDIT_CARD |
Voucher |
ISSUE_MERCHANDISE_CREDIT_CARD |
VOUCH |
4050 |
|
ISSUE_STORE_CREDIT |
Voucher |
ISSUE_STORE_CREDIT |
VOUCH |
4050 |
|
ISSUE_XPAY_GIFT_CARD |
Voucher |
ISSUE_XPAY_GIFT_CARD |
VOUCH |
4040 |
|
MALL_CERTIFICATE |
Voucher |
MALL_CERTIFICATE |
VOUCH |
4060 |
|
MERCHANDISE_CREDIT_CARD |
Voucher |
MERCHANDISE_CREDIT_CARD |
VOUCH |
4050 |
|
RELOAD_MERCHANDISE_CREDIT_CARD |
Voucher |
RELOAD_MERCHANDISE_CREDIT_CARD |
VOUCH |
4050 |
|
RELOAD_XPAY_GIFT_CARD |
Voucher |
RELOAD_XPAY_GIFT_CARD |
VOUCH |
4040 |
|
STORE_CREDIT |
Voucher |
STORE_CREDIT |
VOUCH |
If primary 4050, if foreign 4090. |
|
XPAY_GIFT_CARD |
Voucher |
XPAY_GIFT_CARD |
VOUCH |
4040 |
|
COUPON |
COUPON |
ManufacturerCoupon |
COUPON |
QPON |
5000 |
ROOM_CHARGE |
CreditDebit |
ROOM_CHARGE |
VOUCH |
4050 |
|
CREDIT_CARD |
PAYPAL |
TBD |
PAYPAL |
PAYPAL |
3075 |
HOME_OFFICE_CHECK |
HOME_OFFICE_CHECK |
NA |
NA |
Not supported in this solution. Home office check tenders should not be used in Xstore if it is integrated with ReSA. |
Table A-3 describes the ReSA mapping for the total ID record in the transaction header.
Table A-3 Total Tender ID Mapping
Xstore | ReSA RTLog | |
---|---|---|
TenderType | TenderID | Total ID |
CURRENCY |
USD_CURRENCY |
CASH |
AUD_CURRENCY |
CASHAC |
|
CAD_CURRENCY |
CASHAC |
|
EUR_CURRENCY |
CASHAC |
|
GBP_CURRENCY |
CASHAC |
|
TRAVELERS_CHECK |
USD_TRAVELERS_CHECK |
TCHECK |
AUD_TRAVELERS_CHECK |
TCHECKAC |
|
CAD_TRAVELERS_CHECK |
TCHECKAC |
|
EUR_TRAVELERS_CHECK |
TCHECKAC |
|
GBP_TRAVELERS_CHECK |
TCHECKAC |
|
MXN_TRAVELERS_CHECK |
TCHECKAC |
|
CREDIT_CARD |
CREDIT_CARD |
CCARD |
VOUCHER |
GIFT_CERTIFICATE |
GIFTCERT |
MALL_CERTIFICATE |
MALLCERT |
|
MERCHANDISE_CREDIT_CARD |
MCCARD |
|
RELOAD_MERCHANDISE_CREDIT_CARD |
RMCCARD |
|
RELOAD_XPAY_GIFT_CARD |
RXPAYGC |
|
STORE_CREDIT |
STCRDT |
|
XPAY_GIFT_CARD |
XPAYGC |
|
ISSUE_XPAY_GIFT_CARD |
IXPAYGC |
|
ISSUE_STORE_CREDIT |
ISTCRDT |
|
ISSUE_MERCHANDISE_CREDIT_CARD |
IMCCARD |
|
ACCOUNT |
HOUSE_ACCOUNT |
HACCNT |
COUPON |
COUPON |
COUPON |
ReSA tender type values are defined in code SAIT and used in the following:
RTLOG TITEM record, item type field
Sa_tran_item.item_type
Table A-4 describes the Xstore item type mapping.
Table A-4 Item Type Mapping
Xstore Item Type | ReSA Item Type | Description |
---|---|---|
Alteration |
NMITEM |
NA |
Deposit |
NMITEM |
NA |
dtv:GiftCertificate |
GCN |
Gift Card and Gift Certificate |
dtv:NonMerchandise |
NMITEM |
NA |
dtv:Payment |
NMITEM |
NA |
Fee |
NMITEM |
NA |
ItemCollection |
ITEM |
NA |
Service |
NMITEM |
NA |
Stock |
ITEM |
NA |
Warranty |
NMITEM |
NA |
Xstore has a single set of reason codes, used both for reason codes, price override codes, and other modifications. ReSA separates these concepts into individual sets used in different RTLog fields and saved to different database table/fields. Because reason codes can be mixed coming out of Xstore, ReSA has mapped some code values to multiple code types to avoid the possibility of errors.
ReSA reason codes:
Code type REAC
Note: ReSA supports a number of other transaction level reason codes. Only reason codes related to Xstore integration are listed here. |
SA_TRAN_HEAD.REASON_CODE
Used for further information on a number of transaction types.
Mapped to Xstore miscellaneous reason codes.
Table A-5 describes the reason code mapping.
Table A-5 ReSA Reason Codes
Xstore Reason Code | ReSA Reason Code | Description |
---|---|---|
PV1 |
PV1 |
Cashier Error |
PV2 |
PV2 |
Supervisors Discretion |
PV3 |
PV3 |
Customer Satisfaction |
NS1 |
NS1 |
Making Change |
NS2 |
NS2 |
Employee Check Cashed |
NS3 |
NS3 |
Petty Cash In |
NS4 |
NS4 |
Petty Cash Out |
NS5 |
NS5 |
Spiff/Bonus Out 1 |
CF1 |
CF1 |
Holiday Adjustment |
CF2 |
CF2 |
Register Down |
PAID_IN |
PI1 |
Change from Paid Out |
PAID_IN |
PI2 |
Found Money |
PAID_IN |
PI3 |
Drawer Loan 1 |
PAID_IN |
TENDEX |
Tender exchange |
PAID_OUT |
PO1 |
Stocks |
PAID_OUT |
PO2 |
Delivery |
PAID_OUT |
PO3 |
Postage |
PAID_OUT |
PO4 |
Contractor Services |
PAID_OUT |
PO5 |
Store Incentives |
ReSA return reason codes:
Code type = SARR
SA_TRAN_ITEM. RETURN_REASON_CODE
Table A-6 describes the return reason code mapping.
ReSA discount reason codes:
Code type SADT
Note: ReSA supports a number of other discount types. Only discount types related to Xstore integration are listed here. |
SA_TRAN_DISC.DISC_TYPE
Table A-7 describes the discount reason code mapping.
Table A-7 ReSA Discount Reason Codes
Xstore Reason Code | ReSA Reason Code | Description |
---|---|---|
DC1 |
S |
Incorrect Label |
DC2 |
MS |
Manager Discretion |
DC3 |
CP |
Price Guarantee |
DC4 |
D |
Damage Adjustment |
NEW_PRICE_RULE |
NEWPRC |
New Price Rule |
DOCUMENT |
DOC |
Document |
MANUFACTURER_COUPON |
MCOUP |
Manufacturer Coupon |
REFUND_PRORATION |
REFUND |
Refund Proration |
CALCULATED_WARRANTY_PRICE |
CALWAR |
Warranty Price |
ReSA item price override reason codes:
Code type ORRC
SA_TRAN_ITEM.OVERRIDE_REASON
Table A-8 describes the item price override reason code mapping.
Table A-8 ReSA Item Price Override Reason Codes
Xstore Reason Code | ReSA Reason Code | Description |
---|---|---|
AR_PR_1 |
AR_PR_1 |
Insufficient Funds |
AR_PR_2 |
AR_PR_2 |
Wrong Amount |
AR_PR_3 |
AR_PR_3 |
Wrong Amount |
AR_PR_4 |
AR_PR_4 |
Wrong Invoice |
COMMENT |
NEWPRC |
Other - Enter Comments |
PC1 |
S |
Incorrect Label |
PC2 |
MS |
Supervisors Discretion |
PC3 |
CP |
Competitive Price Match |
PC4 |
D |
Damage Adjustment |
BASE_PRICE_RULE |
BSPRC |
Base Price Rule |
PROMPT_PRICE_CHANGE |
PROMPT |
Price Prompt |
AUTHORIZED_AMOUNT |
AUTHMT |
Authorized Amount |
ReSA item status:
Code type SASI
SA_TRAN_ITEM.ITEM_STATUS
Valid values for the ReSA item status are shown in the following table:
V | Voided |
S | Sale |
R | Return |
O | Other |
ORI | Order Initiate |
ORC | Order Cancel |
ORD | Order Complete |
LIN | Layaway Initiate |
LCA | Layaway Cancel |
LCO | Layaway Complete |
ReSA sales type:
Code type SASY
SA_TRAN_ITEM.SALES_TYPE
Valid values for the ReSA sales type are shown in the following table:
R | Regular |
I | In-Store Customer Order |
E | External Customer Order |
Table A-9 describes the item status and sales type mapping.
Table A-9 ReSA Item Status/Sales Type Mapping
Xstore Item | Xstore Action | ReSA Item Status | ReSA Sales Type |
---|---|---|---|
Regular Sale |
Sale |
S |
R |
Return |
R |
R |
|
Void |
S and V (two lines) |
R |
|
Layaway Item |
Init |
LIN |
I |
Cancel |
LCA |
I |
|
Pickup |
LCO |
I |
|
Void |
S and V (two lines) |
I |
|
Locate Order |
Init |
ORI |
E |
Cancel |
ORC |
E |
|
Pickup |
ORD |
E |
|
Void when update or pickup |
ORC |
E |
|
Void when Init |
S and V (two lines) |
E |
|
Special Order |
Init |
ORI |
E |
Cancel |
ORC |
E |
|
Pickup |
ORD |
E |
|
Void when update or pickup |
ORC |
E |
|
Void when Init |
S and V (two lines) |
E |
|
Work Order |
Init |
ORI |
I |
Cancel |
ORC |
I |
|
Pickup |
ORD |
I |
|
Void when update or pickup |
ORC |
I |
|
Void when Init |
S and V (two lines) |
I |
|
Pre-Sale |
Init |
ORI |
I |
Cancel |
ORC |
E |
|
Pickup |
ORD |
E |
|
Void when update or pickup |
ORC |
E |
|
Void when Init |
S and V (two lines) |
E |
|
On Hold |
Init |
ORI |
I |
Cancel |
ORC |
I |
|
Pickup |
ORD |
I |
|
Void when update or pickup |
ORC |
I |
|
Void when Init |
S and V (two lines) |
I |
|
Send Sale |
Init |
S |
R |
Return |
R |
R |
|
Void |
S and V (two lines) |
R |