Generate E-Commerce Offer Tables (M29) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Generic Integration Values (I13) |
Purpose: The Interface section of the System Control table defines parameters that control:
• system information
• program names
• program information
For more information: See Point of Sale Integration Overview.
Quick Reference of Interface System Control Values
This table describes briefly each system control value for the point of sale interface and lists the control code, control value, a short definition, other control values to which you should refer in this section, if necessary, and a column where you can indicate the value that you assigned for your company.
If you have more than one company on your system, make a copy of this table for each.
Purpose: Company: ________________________________
System Control Value |
Description |
Your Value |
Defines the number of days to retain processed IL outbound triggers before purging them. |
Number field: |
|
Defines whether the system creates triggers in the IL Outbound Trigger table when you add, change, or delete item or SKU information. |
Selected/ Unselected: |
|
Defines whether the system creates triggers in the IL Outbound Trigger table when you add, change, or delete vendor information. |
Selected/ Unselected: |
|
Defines whether the system creates triggers in the IL Outbound Trigger table when you create or update an invoice. |
Selected/ Unselected: |
|
Indicates whether to generate pick download trigger records (file type = PCH). |
Selected/ Unselected: |
|
Indicates whether the system creates trigger records for the Outbound Purchase Order API. (file type = POH). |
Selected/ Unselected: |
|
Defines whether the system creates a purchase order download (POH) trigger for a purchase order receipt transaction. |
Selected/ Unselected: |
|
Indicates whether to create trigger records for the Outbound Return Authorization API (file type = RAD). |
Selected/ Unselected: |
|
Indicates whether to create trigger records for the generic inventory integration (file type = ITW) based on changes in inventory levels. |
Selected/ Unselected: |
|
Indicates whether to create trigger records for the Generic Customer Outbound API (file type = CST). |
Selected/ Unselected: |
|
Indicates whether to generate inventory download trigger records when you create or change a purchase order. |
Selected/ Unselected: |
|
Indicates whether to include warehouses whose Allocatable flag is unselected when generating trigger records for the generic inventory integration. |
Selected/ Unselected: |
|
Defines whether certain fields are required when creating an item: |
||
Defines whether the long SKU division is a required field when you create or change a long SKU department. |
Selected/ Unselected: |
|
Defines whether the long SKU department code is required when creating or maintaining an item. |
Selected/ Unselected: |
|
Defines whether the long SKU class code is required when creating or maintaining an item. |
Selected/ Unselected: |
|
Defines whether the long SKU style code is required when creating or maintaining a SKU. |
Selected/ Unselected: |
|
Defines whether an item class is required when creating or maintaining an item. |
Selected/ Unselected: |
|
Defines default rules and settings for integration with the Order Broker in Order Broker. |
||
Defines whether merchandise locator searches are available for information and to support store pickup order creation. |
Selected/ Unselected |
|
Defines whether the distance measurement for merchandise locator or store pickup searches is miles or kilometers. |
Code: |
|
Defines whether to submit all brokered backorders on an order in a single Submit Order message. |
Selected/ Unselected |
|
Indicates the default search radius, in miles or kilometers, for merchandise locator or store pickup searches. |
Number: |
|
Indicates whether to send fulfillment requests for backordered items (brokered backorders) to Order Broker’s Order Broker module. |
Selected/ Unselected: |
|
Defines how many minutes to wait before sending a new status inquiry request for to the Order Broker for brokered backorders or for retail pickup, delivery, or store pickup orders. |
Number: |
|
Indicates whether backordered items on orders flagged to ship complete are eligible for fulfillment through the Order Broker. |
Selected/ Unselected: |
|
Defines the number of days in the future a purchase order’s expected date needs to be before the system requests the Order Broker fulfill a backordered item, or for the system to reject a retail pickup or delivery order. |
Number: |
|
Indicates whether backordered items assigned coordinate group codes are eligible for fulfillment through the Order Broker. |
Selected/ Unselected: |
|
Indicates whether backordered items on gift orders are eligible for fulfillment through the Order Broker. |
Selected/ Unselected: |
|
Defines the account number to specify in Order Broker request messages to identify the Order Broker database. |
System name: |
|
Defines the system code to specify in Order Broker request messages to identify the requesting system. |
System name: |
|
Defines the default location code to specify in Order Broker request messages to identify the requesting warehouse in Order Management System. |
System name: |
|
Defines the location code the Order Broker assigns to a brokered backorder when it cannot find a location to fulfill it. |
System name: |
|
Indicates whether to send inventory information to and request orders from Order Broker separately by warehouse, or to aggregate information and to use the OROB Default Location (K51). |
Selected/ Unselected: |
|
Defines the code in Order Broker identifying your default integrated point of sale system for assignment of ship-for-pickup or store pickup orders. |
Code: |
|
Indicates whether to accept delivery or retail pickup orders assigned by the Order Broker even if they include items that are backordered. |
Selected/ Unselected: |
|
Defines the order type to apply to delivery orders assigned by the Order Broker. |
Code: |
|
Define the batch number to use for delivery or retail pickup orders in error that are assigned by the Order Broker. |
Number: |
|
Indicates whether to update a customer’s email address based on the information received from the Order Broker when it sends delivery or retail pickup orders to Order Management System for fulfillment. |
Selected/ Unselected: |
|
Defines the order type to apply to retail pickup orders assigned by the Order Broker. |
Code: |
|
Defines the hold reason code to apply to a delivery or retail pickup order when Order Broker indicates that the order has been canceled during pick slip generation in Order Management System. |
Code: |
|
Indicates whether to update a customer’s email address based on the information received from the Order Broker when it sends delivery or retail pickup orders to Order Management System for fulfillment. |
Selected/ Unselected: |
|
Defines the default source code to apply to delivery or retail pickup orders assigned to Order Management System for fulfillment if no source code was specified in the message from the Order Broker or for the Store Cross Reference record. |
Code: |
|
Defines the hold reason code to apply to ship-for-pickup orders if Order Broker returns an error when Order Management System.sends the submit order request during pick slip generation. |
Code: |
|
Indicates whether to flag a retail pickup or delivery order to ship complete. |
Selected/ Unselected: |
|
Defines the pay type to apply to retail pickup or delivery orders assigned to Order Management System for fulfillment. |
Number: |
|
Defines the price override reason code to use for order lines on retail pickup or delivery orders assigned to Order Management System for fulfillment. |
Code: |
|
Indicates whether to flag retail pickup or delivery orders as gifts in order to prevent prices from printing on pick slips. |
Selected/ Unselected: |
|
Defines the default ship via code to apply to retail pickup or delivery orders assigned to Order Management System for fulfillment if a ship via code is not specified in the message from the Order Broker. |
Number: |
|
Indicates whether to calculate freight for store pickup orders that you create in interactive order entry. |
Selected/ Unselected: |
|
Indicates whether to send a status update of polled when a delivery or retail pickup order is received from the Order Broker and the order is in error. |
Selected/ Unselected: |
|
Defines the order type to assign to store pickup orders. |
Code: |
|
Defines the cancel reason code to apply to store pickup orders rejected by Order Broker or by the assigned fulfilling location. |
Code: |
|
Defines whether you collect payment for a ship-for-pickup order at the store location rather than billing the order when you ship it from the warehouse. |
Selected/ Unselected: |
|
Defines whether to automatically cancel retail pickup, delivery, or special ship-for-pickup orders if their pick slips are voided through the generic pick in API. |
Code: |
|
Controls whether to authorize store pickup orders for verification only, or to authorize and bill store pickup orders in Order Management System. |
Selected/ Unselected: |
|
Defines whether you can process a return or a negative additional charge for a retail pickup or delivery order. |
Selected/ Unselected: |
|
Indicates the field where you store Order Broker’s default product code. |
Code: |
|
Indicates whether to map the long SKU division or the item category to the category in Order Broker. |
Code: |
|
Select this system control value to use the Order Broker Fulfillment Integration. |
Selected/ Unselected: |
|
Defines the originating location code for delivery orders that originated in Order Management System and are sent to Order Broker to determine the fulfilling location. |
Code: |
|
Defines the order type code the system assigns to delivery orders that originated in Order Management System that Order Broker determined should be fulfilled by Order Management System. |
Code: |
|
Defines whether ship-for-pickup orders are sent to Order Broker for fulfillment assignment. |
Code: |
|
Order Type for Retail Pickup Orders Originating in OROMS (M35) |
Defines the order type code the system assigns to retail pickup orders that originated in Order Management System that Order Broker determined should be fulfilled by Order Management System. |
Code: |
Select this field if you are using Order Broker to process drop ship purchase orders. |
Selected/ Unselected: |
|
Defines the number of days added to the date passed to Order Broker to calculate the Expected ship date stored in Order Management System for a drop ship purchase order line. |
Number: |
|
Identifies whether or not an external warehouse management system is being used with Order Management System. |
Selected/ Unselected: |
|
Defines whether the system automatically advances you to the Work with Customer Profile Screen in order entry and order maintenance for all customers that require customer demographics or only for customers that have an alternate customer number defined. |
Selected/ Unselected: |
|
Defines the program that generates the store pickup notification email. |
Program name: |
|
These values control integration with Oracle Retail Customer Engagement. |
||
Defines how Order Management System sends customer information to Oracle Retail Customer Engagement. |
Code: |
|
Defines how Order Management System identifies items/SKUs for integrations with other systems. |
Code: |
|
Defines the item code to include in the Customer Engagement Post POSlog Transaction Message to represent all non-merchandise amounts for an item, such as freight, additional freight, handling and additional charges. |
Code: |
|
Defines the types of orders Order Management System excludes in the Oracle Retail Customer Engagement Sales Feed. |
Code: |
|
Defines the return disposition code assigned to return (credit) invoices that Order Management System excludes from the Oracle Retail Customer Engagement Sales Feed. In addition, Order Management System does not generate a return confirmation for these returns. |
Code: |
|
Defines whether Order Management System includes full invoice totals or only merchandise and tax amounts in the Oracle Retail Customer Engagement Sales Feed. |
Selected/ Unselected: |
|
Identifies the Oracle Retail Customer Engagement organization that maps to your Order Management System company. |
Code: |
|
Defines whether to include customer profile information when sending new or changed customer information to Oracle Retail Customer Engagement through the interactive customer integration. |
Selected/ Unselected: |
|
Indicates the store cross-reference record you use as part of an integration with a point-of-sale system. |
Code: |
|
Defines whether you use the Customer Engagement Customer Wish List Integration. |
Selected/ Unselected: |
|
Defines whether you use the Customer Engagement Loyalty Integration. |
Selected/ Unselected: |
|
Defines whether the system automatically displays the Customer Loyalty Registration Window during Order Entry and Work with Customers (WCST) when the customer is not assigned to a loyalty card in Oracle Retail Customer Engagement. |
Selected/ Unselected: |
|
Defines the 5 digit prefix assigned to the Loyalty Card Definition in Oracle Retail Customer Engagement that is used to assign new loyalty cards to sold to customers that join the loyalty program. |
Code: |
|
Defines the 2 digit card series number assigned to the Loyalty Card Definition in Oracle Retail Customer Engagement that is used to assign new loyalty cards to sold to customers that join the loyalty program. |
Code: |
|
Defines the program used to generate a Loyalty Registration Notification email when a sold to customer joins the loyalty program and is assigned a loyalty card in Oracle Retail Customer Engagement. |
System Name: |
|
Defines whether the system retrieves item images and item information from an external image hosting application. |
Selected/ Unselected: |
|
Defines the number of days old a periodic process history record should be before it is eligible for purge. |
Number: |
|
Defines whether to generate separate pick slips or drop ship purchase orders for ship-for-pickup orders so that each line creates a separate order in Order Broker. |
Selected/ Unselected: |
|
Defines the order type to assign to orders you process through the ChannelAdvisor integration. |
Code: |
|
Defines the available quantity to report to ChannelAdvisor for drop ship and non-inventory items. |
Number: |
|
Defines the offer associated with item and SKU cross-references for ChannelAdvisor. |
Code: |
|
Enterprise Integration Values (M41) These values control integration with integration with Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) through Omnichannel Cloud Data Service (OCDS), as well as with RICS. |
||
Defines the number of seconds to wait for a response from OCDS for responses to requests for item and related data, and RICS for backorder notification requests. |
Number: |
|
Defines the default warehouse to use when importing enterprise foundation data through OCDS. |
Number: |
|
Defines the soldout control code to use when Order Management System indicates to sell out an item immediately. |
Code: |
|
Defines the soldout control code to assign when creating items or SKUs. |
Code: |
|
Defines the location to use when creating item location records through the OCDS import. |
Code: |
|
Defines the location identifier to map item and pricing from Oracle Retail Merchandising Foundation Cloud Service (RMFCS) and Oracle Retail Pricing Cloud Service (RPCS) to a company in Order Management System when integrating through OCDS. |
Code: |
|
Defines the URL to use when requesting merchandise hierarchy information from OCDS. |
Long: |
|
Defines the URL to use when requesting item differential information from OCDS. Not currently implemented. |
Long: |
|
Defines the URL to use when requesting item information from OCDS. |
Long: |
|
Defines the URL to use when requesting information derived from the ITEM_LOC table in OCDS. |
Long: |
|
Defines the URL to use when requesting item image information from OCDS. |
Long: |
|
Defines the URL to use when requesting item price information from OCDS. |
Long: |
|
Defines the URL to use when requesting future available inventory information from OCDS. |
Long: |
|
Defines the URL to use when submitting requests to RICS. |
Long: |