Sales Transactions (POS) Feed

Overview

The Sales Transactions feed gathers detailed sales information, such as customer, item, tax, and shipping data, from Radial Order Management and provides the information to the client.

Notes:

Default Character Encoding: Unicode: UTF-8
Recipient Acknowledgment Required: Client Specific
Exchange Frequency: Client Specific
Production Mailbox Location: Client Specific
Test Mailbox Location: Client Specific

Schema

Sales Transactions schema: POS.xsd

API Structure

Sales Transactions element table: POS.xsd.htm

Examples

Sale With Multiple Items

Sale With Multiple Taxes and Multiple Releases

Sale With Subsequent Credit Memo

Sale With Multiple Releases and Multiple Credit Memos

Sale With Multiple Items and a Promotional Discount on One Item

Sale With Multiple Items and a Promotional Discount on One Item (Partially Returned)

Sale With Multiple Ship-to Addresses

Sale With Shipping Promotion (Order-Level Free Shipping)

Gift Card Sale

Gift Card Reissue

Zero Cost Reship Exchange Shipment

Zero Cost Reship Exchange Without Return

Sale With Duty

Sale With Customization

Sale With Fees

Sale With Gift Wrap Charge

Sale With Tax Credit

Data Keys

Charge Category	Description
CheckPaymentDiscount	Check Payment Discount
CODSurcharge	COD payment method surcharge
Customization	Customization
CustomizationCredit	Customization Credit
CustomizationDisc	Customization Discount
CVSSurcharge	Convenient store payment method surcharge
Duty	Duty
DutyCredit	Duty Credit
Fees	Fees
FeesCredit	Fees Credit
GiftWrap	Gift Wrap charge
GiftWrapCredit	Gift wrap credit to the customer
GiftWrapDiscount	Gift Wrap Discount
HFR	HFR Charge
HFRCredit	HFR Credit
InventorySetCharge	Inventory Set Charge
InventorySetDiscount	Inventory Set Discount
MerchandiseDiscount	Merchandise Discount
PriceAdjustment	Price Adjustment
Shipping	Shipping
ShippingCredit	Shipping Credit
ShippingDiscount	Shipping Discount

Inventory Condition	Description
Non-Sellable	Returned inventory is not sellable
Sellable	Returned inventory is sellable

Invoice Amount Type	Description
TotalCheckPaymentDiscountAmount	Total Check Payment Discount Amount
TotalCheckPaymentDiscountTaxAmount	Total Check Payment Discount Tax Amount
TotalCODSurchargeAmount	Total COD Surcharge Amount
TotalCODSurchargeTaxAmount	Total COD Surcharge Tax Amount
TotalCustomizationAmount	Total invoice customization charges
TotalCustomizationCreditAmount	Total Customization Credit Amount
TotalCustomizationCreditTaxAmount	Total Customization Credit Tax Amount
TotalCustomizationDiscAmount	Total Customization Discount Amount
TotalCustomizationDiscTaxAmount	Total Customization Discount Tax Amount
TotalCustomizationTaxAmount	Total Customization Tax Amount
TotalCVSSurchargeAmount	Total CVS Surcharge Amount
TotalCVSSurchargeTaxAmount	Total CVS Surcharge Tax Amount
TotalDiscountAmount	Total Discount Amount
TotalDiscountTaxAmount	Total Discount Tax Amount
TotalDutyAmount	Total Invoice duties amount
TotalDutyCreditAmount	Total Duty Credit Amount
TotalDutyCreditTaxAmount	Total Duty Credit Tax Amount
TotalDutyTaxAmount	Total Duty Tax Amount
TotalFeesAmount	Total Fees Amount
TotalFeesCreditAmount	Total Fees Credit Amount
TotalFeesCreditTaxAmount	Total Fees Credit Tax Amount
TotalFeesTaxAmount	Total Fees Tax Amount
TotalGiftWrapAmount	Total Invoice gift wrap Amount
TotalGiftWrapCreditAmount	Total Gift Wrap Credit Amount
TotalGiftWrapCreditTaxAmount	Total Gift Wrap Credit Tax Amount
TotalGiftWrapDiscountAmount	Total Gift Wrap Discount Amount
TotalGiftWrapDiscountTaxAmount	Total Gift Wrap Discount Tax Amount
TotalGiftWrapTaxAmount	Total Gift Wrap Tax Amount
TotalHandlingAmount	Total Handling Amount
TotalHandlingCreditAmount	Total Handling Credit Amount
TotalHandlingCreditTaxAmount	Total Handling Credit Tax Amount
TotalHandlingTaxAmount	Total Handling Tax Amount
TotalHFRCreditAmount	Total HFR Credit Amount
TotalHFRCreditTaxAmount	Total HFR Credit Tax Amount
TotalInventorySetChargeAmount	Total Inventory Set Charge Amount
TotalInventorySetChargeTaxAmount	Total Inventory Set Charge Tax Amount
TotalInventorySetDiscountAmount	Total Inventory Set Discount Amount
TotalInventorySetDiscountTaxAmount	Total Inventory Set Discount Tax Amount
TotalInvoiceAmount	Total Invoice Amount
TotalMerchandiseAmount	Total Shipped Merchandise Amount
TotalMerchandiseDiscountAmount	Total merchandise discount amount
TotalMerchandiseDiscountTaxAmount	Total Merchandise Discount Tax Amount
TotalPriceAdjustmentAmount	Total Price Adjustment Amount
TotalPriceAdjustmentTaxAmount	Total Price Adjustment Tax Amount
TotalShippingAmount	Total Shipping Amount
TotalShippingCreditAmount	Total Shipping Credit Amount
TotalShippingCreditTaxAmount	Total Shipping Credit Tax Amount
TotalShippingDiscountAmount	Total shipping discount amount
TotalShippingDiscountTaxAmount	Total Shipping Discount Tax Amount
TotalShippingTaxAmount	Total Shipping Tax Amount
TotalTaxAmount	Total Tax Amount
TotalTaxCreditAmount	Total Tax Credit Amount
TotalTaxCreditTaxAmount	Total Tax Credit Tax Amount
TotalZCRChargeAmount	Total ZCR Charge Amount
TotalZCRChargeTaxAmount	Total ZCR Charge Tax Amount

Invoice Type	Description
CREDIT_MEMO	Price Adjustment to an existing order
DEBIT_MEMO	Debit on an existing order
ORDER	Sales Order
RETURN	Return Order
SHIPMENT	Shipment

ISO Standard	Definition
Country – ISO 3166-1	2 Letter Country Standard
Currency – ISO 4217	Currency Standard
Time – ISO 8601	Date Time Standard

Item Type	Description
CUSTOM	Customization SKU. A virtual item that represents a charge to the shopper to customize an item and a description of the customization options selected by the shopper.
DONATION	Donation SKU. A virtual item that represents a shopper's donation to a charitable cause.
GC	Physical gift card
GIFTWRAP	Physical gift wrap.
MERCH	A typical physically-fulfilled item.
OGC	Online gift certificates that are hosted or processed by Radial. Our in-house products for gift certificates that don't have a physical card associated with them (only a payment account number and PIN).
POSTSALEFULFILLMENT	Post-sale fulfillment SKU. A virtual item that needs to be classified separately from other virtual SKU types such as Donation, Surcharge, or Warranty SKUs.
RefundOGC	Refund online gift certificate. 'Refund' used for accounting purposes to differentiate refunds from the original tender.
RefundOGCForCOD	Refund online gift certificate issued against a COD order.
RefundOGCForCVS	Refund online gift certificate issued against a CVS order.
RefundVGC	Refund virtual gift card. 'Refund' used for accounting purposes to differentiate refunds from the original tender.
VGC	Functionally similar to OGCs except they are processed by a third-party gift-card provider (for example, SVS or ValueLink).
WARRANTY	Product warranty. A virtual item that represents a warranty purchased for another physical item on the order.

Jurisdiction Level	Desciption
APO	Army Post Office
BOROUGH	Borough
CITY	City
COUNTRY	Country
COUNTY	County
DISTRICT	District
FPO	Fleet Post Office
LOCAL_IMPROVEMENT_DISTRICT	Local Improvement District
PARISH	Parish
PROVINCE	Province
SPECIAL_PURPOSE_DISTRICT	Special Purpose District
STATE	State
TERRITORY	Territory
TOWNSHIP	Township
TRADE_BLOCK	Trade Block (ex. European Union, NAFTA)
TRANSIT_DISTRICT	Transit District

Order Type	Description
CSROMS	CSR OMS Order
CSRWEB	CSR Web Store Orders
EB2C	External B2B Orders
GAOS	Associate Ordering System
GROUP_SALES	Group Sales
LEGACY	Legacy data migrated from V9/V10
MOBILE	Mobile Device Order Source
MPCAAMAZON	Marketplace Amazon via Channel Advisor
MPCABUY	Marketplace Buy via Channel Advisor
MPCAEBAY	Marketplace eBay via Channel Advisor
MPRAKUTEN	Marketplace Rakuten
MPYAHOO	Marketplace Yahoo
PHONE	Phone order via IVR
WEB	Web Store Order Source
XLEGACY	External Legacy data migrated when launching a new store on V11
XMOBILE	External Mobile Store
XWEB	External Web Store
ZCREXCHANGE	Zero Cost Reship

Reason Code	Description
01	Dissatisfied
02	Damaged
03	Defective
04	Not as Desc or Pictured
05	Mistake in Ordering
06	Wrong Product Shipped
07	Other
08	Package Refused At Door
09	Freight Damaged
10	AAFES Order Return
11	Exchange
12	Bad Address
13	Returned from Store for Credit
14	Returned at Store, No Credit or Ref
15	Wrong Carrier Selected When Shipped16
16	Carrier Does Not Service Address
17	Carrier Could Not Locate Address
18	Missing UPC
19	Return Not Valid
20	Missing Major Component
21	Did not fit - too small
22	Did not fit - too short
23	Did not fit - too narrow
26	Did not fit - too large
28	Incorrect item - Color
AH	AH-Invalid Shipping Address
ALC	Arrived late due to carrier
AM	American Express Fraud
APP	APPEASEMENT (LNT)
ARD	Arrived Damaged
ARL	Arrived Late
ATL	Arrived too late
AW	AW-Whse Zip Code Error
B01	Size too large/small
B02	Did not fit as expected
B03	Item not as described or pictured
B04	Incorrect item received
B05	Order arrived late
B06	Item was damaged
B07	Unwanted gift
B08	Change mind
B09	Other, please specify
BM	Bought multiples, plan to keep 1
CB	Customer Request - Presell
CBL	Chargeback Loss Prevention
CCE	Cancelled Customer Error
CCM	Cancelled Changed Mind
CDE	Cancelled Data Entry Error
CFC	I Ordered Incorrect Color
CFS	I Ordered Incorrect Size
CID	I Didn't Like
CL	Late Shipment Cancel
CLR	Color different from order
CMD	Buyers remorse
CMM	I Changed My Mind
CMN	Cancelled Modified Name,Addres
CN	Shop NBC Cancellation
CNC	Cancelled at Customer Request
COL	Cancelled Order Late
COT	Cancelled Other
CP	Customer Request
CR	Customer Req - Order Replaced
CSU	Cancelled Substitution
CWS	Size Just Didn't Fit
DAM	Damaged refused or concealed damage
DC	Damaged when Customizing
DEE	Date Entry Error
DEF	Manufacturer error
DFC	Destroy Authorization from Vendor
DFT	Defective
DI	Insufficient Credit
DIN	Damaged Interior
DIQ	Disappointed in quality
DLC	Did not like color
DLS	Did not like styling
DNR	Did Not Receive Package
DSD	Drop Ship Damaged
DT	Cancel After Date
DUP	Duplicate order
DW	Wireless Plan Credit Decline
DX	Other Credit Declines
EC	ExpiredPromotional Code
EP	Customer Request - Epiphany
ESC	Corporate Escalation (for GC void)
EX	Expired Product
F1	Finance Cancel-Denied PO
F2	Finance Cancel-Wait greater than 10 Days
FB	Invalid Billing Address
FC	FTC CANCELLATION
FED	Fed Ex Return
FF	Lost Or Stolen Card
FI	International Billing Address
FIT	Did not fit
FRD	Fraud (for voiding GC)
FS	Suspected Fraud
GCF	GC failure
GFT	Gift Certificate Failure (LNT)
GRG	Gratis- Gloss
GSE	GSI site error
GW	Gift Wrap cancel code
HM	Hot Market SKU Cancel
IC	Inappropriate Customization
ID	OOS - Inventory Discrepancy
IK	Fill and Kill
IM	Shipping Mode Mismatch
IN	Too Many Letters in Name
IO	OOS - Out of Stock
IP	Incorrect Product
IR	Warehouse Cancel - unspecified
IS	Inactive Sku
IV	Vendor Direct Cancellation
LOS	Lost item
LP	Wrong Address
LPC	LP-Canadian Post
LPP	LP-Purolator
MIS	Wrong item, size or color sent
MSC	I Received Incorrect Color
MSI	I Received Incorrect Item
MSS	I Received Incorrect Size
MSW	Fulfillment Misship
NAD	Not as pictured or described
NCR	Never Received by Carrier
ND	Duplicate - Don't send email
NDC	Non-Delivered - Claim (LNT)
NDN	Non-Delivered - No Claim (LNT)
NE	Item did not meet my expectations
NEX	Fabric/Color not as expected
NRC	Never Received by Carrier
OBM	OBM Requested
OS	Out of Stock
OTH	Other
OVD	Last resort compensation
PAQ	Package Quality
PC	Pick Cancel (In Store Pick-Up)
PCF	Promo/Coupon Failure (LNT)
PE	Promotional Error
PMF	Promotional failure
PRA	Price Adjustment
PRE	Personal Reaction
PRM	Price match
PRQ	Product Quality
PRT	Partner requested
PST	Return Postage
QPM	Product Melted
QPP	Sloppy Personalization
RAG	Received as gift
RL	Return Lost
RPM	Product misinformation
RV	RTV cancels
SAM	Sample
SC	Size or Color Issue
SD	Backorder - Don't send email
SE	Setup Error
SHE	Shipping error
SHT	Shortage
SSC	Cancel Customer Initiated
SSH	Short Shipped (LNT)
SSR	ISPU Return Reason Code
SZE	Size different from order
TC	OOS - Timing
TDR	30-DAY RETURN
TEX	Tax exempt credit
TLG	Too Large
TLO	Too Long
TQ	OOS - Timing - QVC Default
TSH	Too Short
TSM	Too Small
UND	Undeliverable
VC	Variance Cancel
WA	Wrong Address
XC	Customer Cancel
XF	Fraud
XG	Google Canceled Order
XI	ORDERREVIEWCXL-XI
XU	Fraud Analyst Cancel
YC	Order Clean Up
YD	Duplicate Order
YT	Test Order
YY	GBuy Settlement 29 Day Limit
Z	Cancel Inventory Discrepancy
Z1	PayPal Settlement 60 Day Limit
Z2	Failed PayPal Authorization
ZC	Zero Cost Re-ship Cancel
ZRN	No reason
ZZ	PayPal Settlement 29 Day Limit

Situs	Description
ADMINISTRATIVE_DESTINATION	Tax address of the receiving entity
ADMINISTRATIVE_ORIGIN	Tax address of the shipping entity
DESTINATION	Ship-to location
PHYSICAL_ORIGIN	Ship-from location

Tax Type	Description
CONSUMERS_USE	Use tax applied to purchaser
IMPORT_VAT	VAT applied to the import of an item
NONE	No tax applied
SALES	Sales tax
SELLER_USE	Use tax applied to selling organization
VAT	Value added tax

Telephone Type	Description
DayFaxNo	Daytime Fax Number
DayPhone	Daytime Telephone
EveningFaxNo	Evening Fax Number
EveningPhone	Evening Telephone
MobilePhone	Mobile Phone
OtherPhone	Other Phone Type