Operations and Maintenance
Data Storage
The Radial integration stores data in both system objects and custom objects. Custom object data is cleaned through a job.
The following table lists the details of the overall attributes created in SFCC.
|
System Object Type |
Attribute ID |
Radial API/Module |
Description |
|---|---|---|---|
|
Product Line Item |
radialLineItemEstDeliveryDate |
Inventory Details API |
Product estimated delivery information |
|
|
radialLineItemShipFromAddress |
Inventory Details API |
Product Ship-From Address information |
|
|
radialLineItemTaxXML |
Tax Quote API |
Radial Tax Response for line item |
|
|
radialItemStatusOMS |
Order Details API |
Line item status OMS |
|
|
radialItemTrackingId |
Order Details API |
Line item tracking ID |
|
|
radialStatusChange |
Order Status Job |
Radial line item status change history |
|
|
radialShipmentInfo |
Order Status Job |
Radial shipment information |
|
|
radialDutyAmount |
Radial Line Item Duty Amount |
Line item duty charges |
|
|
|
|
|
|
Product |
isItemExported |
Item Master Job |
Item export status to OMS |
|
|
isDropShipped |
Item Master Job |
Item drop ship eligible |
|
|
dropShipSupplierPrefix |
Item Master Job |
Drop ship supplier prefix |
|
|
dropShipSupplierName |
Item Master Job |
Drop ship supplier name |
|
|
dropShipSupplierNumber |
Item Master Job |
Drop ship supplier number |
|
|
dropShipSupplierPartNumber |
Item Master Job |
Drop ship supplier part number |
|
|
countryOfOrigin |
Item Master Job |
Product country of origin |
|
|
|
|
|
|
Customer Address |
radialAddressValidated |
Address Validation API |
Address validation status |
|
|
|
|
|
|
Order |
radialRDFUID |
Radial Risk Module |
Device fingerprint ID |
|
|
radialFraudStatus |
Radial Risk Module |
Fraud status for non-Radial OMS clients |
|
|
radialFraudStatusHistory |
Radial Risk Module |
Fraud status change history |
|
|
orderCreationStatusROM |
Radial OMS |
Order creation status OMS |
|
|
radialInventoryReservationID |
Inventory Allocation API |
Inventory reservation ID |
|
|
radialTaxTransactionId |
Radial Tax |
Tax transaction ID |
|
|
orderStatusOMS |
Order History |
Order status ROM |
|
|
radialOMSOrderId |
Order History |
Radial OMS order ID |
|
|
radialPaymentStatus |
Radial Payment Status HPP |
Payment Status for HPP transactions |
|
|
reqOrigin |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqHost |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqConnection |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqAccept |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqCookie |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqReferer |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqAcceptLanguage |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqAcceptEncoding |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqRequestedWith |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqUserAgent |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqRadialSessionId |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqDeviceIP |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqProtoType |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqForwardedProto |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqRequestMethod |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
reqScriptName |
Browser Information |
Browser informationto be sent for Risk/OMS |
|
|
|
|
|
|
Payment Transaction |
radialPaypalPayerID |
PayPal API |
PayPal payer ID |
|
|
radialPaypalEmail |
PayPal API |
PayPal payer Email |
|
|
radialPaypalToken |
PayPal API |
PayPal set express Token |
|
|
radialPayPalTransactionId |
PayPal API |
PayPal transaction ID |
|
|
radialAMEXPhoneResponseCode |
Credit Card Auth API |
AMEX phone response code |
|
|
radialAMEXNameResponseCode |
Credit Card Auth API |
AMEX name response code |
|
|
radialAMEXEmailResponseCode |
Credit Card Auth API |
AMEX email response code |
|
|
radialPANToken |
Credit Card Auth API |
Credit Card Token Value |
|
|
radialResponseCode |
Credit Card Auth API |
Response code |
|
|
radialAuthorizationResponseCode |
Credit Card Auth API |
Authorization response code |
|
|
radialBankAuthorizationCode |
Credit Card Auth API |
Bank authorization code |
|
|
radialCVVAuthorizationCode |
Credit Card Auth API |
CVV authorization code |
|
|
radialAVSResponseCode |
Credit Card Auth API |
AVS Response Code |
|
|
radialTenderType |
Credit Card Auth API |
Tender type |
|
|
radialGiftCardNumber |
Gift Certificate Redeem |
Gift card number |
|
|
radialGiftCardPIN |
Gift Certificate Redeem |
Gift card PIN |
|
|
afterpayPaymentID |
Afterpay |
Afterpay payment ID |
|
|
interacOrderId |
Interac |
Interac order ID |
|
|
radialPaymentStatus |
Payments |
Payment status |
|
|
radialTransactionId |
Payments |
Transaction ID |
|
|
radialInteracFinancialCode |
Interac Online |
Interac financial code |
|
|
radialInteracFinancialName |
Interac Online |
Interac financial name |
|
|
radialgooglePaysignatures |
Google Pay |
Google Pay signature |
|
|
radialgooglePayvalue |
Google Pay |
Google Pay value |
|
|
radialgooglePayexpiration |
Google Pay |
Google Pay expiration |
|
|
radialgooglePayephemeralPublicKey |
Google Pay |
Google Pay ephemeral public key |
|
|
radialgooglePaytag |
Google Pay |
Google Pay tag |
|
|
radialgooglePayversion |
Google Pay |
Google Pay version |
|
|
radialgooglePaydata |
Google Pay |
Google Pay data |
|
|
radialgooglePaysignature |
Google Pay |
Google Pay signature |
|
|
radialgooglePayCardType |
Google Pay |
Google Pay card type |
|
|
openInvoiceGender |
Open Invoice |
Open Invoice gender |
|
|
openInvoiceDOB |
Open Invoice |
Open Invoice date of birth |
|
|
radialKlarnaAuthcode |
Klarna |
Klarna authorization code |
|
|
|
|
|
|
Basket |
radialPaypalToken |
PayPal |
PayPal token |
|
|
radialPaypalPayerID |
PayPal |
PayPal payer ID |
|
|
radialPaypalEmail |
PayPal |
PayPal payer email ID |
|
|
radialCheckoutOrderNo |
PayPal |
Order number generated in checkout flow |
|
|
radialRDFUID |
Radial Risk |
Device fingerprint ID |
|
|
radialTaxTransactionId |
Radial Tax |
Tax transaction ID |
|
|
|
|
|
|
ShippingMethod |
radialShippingID |
Radial Create Order |
Corresponding Radial shipping ID to SFCC shipping ID |
The following table lists the Radial shipping method IDs configured for each SFCC shipping method.
|
SFCC Shipping Method ID |
Name |
Description |
Radial Mapping |
|---|---|---|---|
|
001 |
Ground |
Order received within 7-10 business days |
ANY_STD |
|
002 |
2-Day Express |
Order received in 2 business days |
ANY_2DAY |
|
003 |
Overnight |
Order received the next business day |
ANY_1DAY |
|
004 |
Super Saver |
Super Saver Delivery (arrives in 3-7 business days) |
ANY_STD |
|
005 |
Store Pickup |
Store Pickup |
ISPU |
|
012 |
Express |
Orders shipped outside continental US received in 2-3 business days |
ANY_INTEX |
|
021 |
USPS |
Order shipped by USPS received within 7-10 business days |
USPS_USPS |
|
EUR001 |
Ground |
Order received within 7-10 business days |
ANY_INTEX |
|
EUR002 |
2-Day Express |
Order received in 2 business days |
INTL_EXPEU1 |
|
EUR003 |
Overnight |
Order received the next business day |
INTL_EXPSA2 |
The following table lists the custom objects used in SFCC.
|
Custom Object Type |
Attribute ID |
Radial API/Module |
Description |
|---|---|---|---|
|
FraudStatusUpdate |
orderNo_Status |
Radial risk status updates through Event Bridge |
Custom object to store fraud status updates received from Radial. Saved in custom object to be sent to OMS. |
|
|
responseXML |
|
|
|
|
dataExported |
|
|
|
|
|
|
|
|
PaymentSettlementStatusUpdate |
orderNo_Type |
Radial payment settlement status updates through Event Bridge |
Custom object to store payment settlement updates received from Radial. Saved in custom object to be sent to OMS. |
|
|
responseXML |
|
|
|
|
dataExported |
|
|
|
|
|
|
|
|
PaymentCancelUpdate |
orderNo_Type |
Radial authorization cancel status updates through Event Bridge |
Custom object to store authorization cancel status updates received from Radial. Saved in custom object to be sent to OMS. |
|
|
responseXML |
|
|
|
|
dataExported |
|
|