Setting Up Interface Values

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

Generic Integration Values (I13)

Outbound Interface Trigger File Purge Days (I14)

Defines the number of days to retain processed IL outbound triggers before purging them.

Number field:

Create Generic Item Download Trigger Records (I15)

Defines whether the system creates triggers in the IL Outbound Trigger table when you add, change, or delete item or SKU information.

Selected/ Unselected:

Create Generic Vendor Download Trigger Records (I16)

Defines whether the system creates triggers in the IL Outbound Trigger table when you add, change, or delete vendor information.

Selected/ Unselected:

Create Generic Invoice Download Trigger Records (I17)

Defines whether the system creates triggers in the IL Outbound Trigger table when you create or update an invoice.

Selected/ Unselected:

Create Generic Pick Download Triggers (I31)

Indicates whether to generate pick download trigger records (file type = PCH).

Selected/ Unselected:

Create Generic PO Download Triggers (K26)

Indicates whether the system creates trigger records for the Outbound Purchase Order API. (file type = POH).

Selected/ Unselected:

Create Generic PO Download Trigger for PO Receipt (K27)

Defines whether the system creates a purchase order download (POH) trigger for a purchase order receipt transaction.

Selected/ Unselected:

Create Return Download Triggers (K28)

Indicates whether to create trigger records for the Outbound Return Authorization API (file type = RAD).

Selected/ Unselected:

Create Generic Inventory Download Triggers (I32)

Indicates whether to create trigger records for the generic inventory integration (file type = ITW) based on changes in inventory levels.

Selected/ Unselected:

Create Generic Customer Download Triggers (L12)

Indicates whether to create trigger records for the Generic Customer Outbound API (file type = CST).

Selected/ Unselected:

Include PO Updates (J93)

Indicates whether to generate inventory download trigger records when you create or change a purchase order.

Selected/ Unselected:

Include Non-Allocatable Warehouses (I34)

Indicates whether to include warehouses whose Allocatable flag is unselected when generating trigger records for the generic inventory integration.

Selected/ Unselected:

Item Values (I91)

Defines whether certain fields are required when creating an item:

Require L/S Division with L/S Department (E85)

Defines whether the long SKU division is a required field when you create or change a long SKU department.

Selected/ Unselected:

Require L/S Department (I92)

Defines whether the long SKU department code is required when creating or maintaining an item.

Selected/ Unselected:

Require L/S Class (I93)

Defines whether the long SKU class code is required when creating or maintaining an item.

Selected/ Unselected:

Require L/S Style (I94)

Defines whether the long SKU style code is required when creating or maintaining a SKU.

Selected/ Unselected:

Require Item Class (F06)

Defines whether an item class is required when creating or maintaining an item.

Selected/ Unselected:

Order Broker Values (K15)

Defines default rules and settings for integration with the Order Broker in Order Broker.

Use Merchandise Locator (I38)

Defines whether merchandise locator searches are available for information and to support store pickup order creation.

Selected/ Unselected

Merchandise Locator Distance Measurement (I39)

Defines whether the distance measurement for merchandise locator or store pickup searches is miles or kilometers.

Code:

Use Split Order (L56)

Defines whether to submit all brokered backorders on an order in a single Submit Order message.

Selected/ Unselected

Default Search Within Radius (I40)

Indicates the default search radius, in miles or kilometers, for merchandise locator or store pickup searches.

Number:

Send B/O to OROB (K08)

Indicates whether to send fulfillment requests for backordered items (brokered backorders) to Order Broker’s Order Broker module.

Selected/ Unselected:

Order Broker Status Update Interval (K10)

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:

Order Broker Include Ship Complete Orders (K12)

Indicates whether backordered items on orders flagged to ship complete are eligible for fulfillment through the Order Broker.

Selected/ Unselected:

Order Broker Due Date Threshold (K11)

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:

Order Broker Include Coordinate Grouped Orders (K13)

Indicates whether backordered items assigned coordinate group codes are eligible for fulfillment through the Order Broker.

Selected/ Unselected:

Order Broker Include Gift Orders (K14)

Indicates whether backordered items on gift orders are eligible for fulfillment through the Order Broker.

Selected/ Unselected:

OROB Account (K49)

Defines the account number to specify in Order Broker request messages to identify the Order Broker database.

System name:

OROB System (K50)

Defines the system code to specify in Order Broker request messages to identify the requesting system.

System name:

OROB Default Location (K51)

Defines the default location code to specify in Order Broker request messages to identify the requesting warehouse in Order Management System.

System name:

OROB Default Location Code for Unfulfillable Orders (K56)

Defines the location code the Order Broker assigns to a brokered backorder when it cannot find a location to fulfill it.

System name:

Send Inventory by Warehouse to OROB (L06)

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:

Name in OROB for Point of Sale (L09)

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:

Retain Backordered Lines Brokered to OROMS (K89)

Indicates whether to accept delivery or retail pickup orders assigned by the Order Broker even if they include items that are backordered.

Selected/ Unselected:

Order Type for Orders Brokered for Delivery (K91)

Defines the order type to apply to delivery orders assigned by the Order Broker.

Code:

Order Broker Error Batch Number (K90)

Define the batch number to use for delivery or retail pickup orders in error that are assigned by the Order Broker.

Number:

Sold to Email Update for Orders Brokered to OROMS (K96)

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:

Order Type for Retail Pickup Orders Brokered to OROMS (K92)

Defines the order type to apply to retail pickup orders assigned by the Order Broker.

Code:

Order Broker Hold Reason (Cancel) (L02)

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:

Sold to Address Update for Orders Brokered to OROMS (K97)

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:

Order Broker Source Code (K93)

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:

Hold Reason for Errored Ship for Pickup Orders (L10)

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:

Ship Complete for Orders Brokered to OROMS (L01)

Indicates whether to flag a retail pickup or delivery order to ship complete.

Selected/ Unselected:

Order Broker Payment Type (K98)

Defines the pay type to apply to retail pickup or delivery orders assigned to Order Management System for fulfillment.

Number:

Order Broker Price Override (K95)

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:

Gift Flag for Orders Brokered to OROMS (L03)

Indicates whether to flag retail pickup or delivery orders as gifts in order to prevent prices from printing on pick slips.

Selected/ Unselected:

Order Broker Ship Via (K94)

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:

Calculate Freight for Store Pickup Orders (L32)

Indicates whether to calculate freight for store pickup orders that you create in interactive order entry.

Selected/ Unselected:

Re-Polling for Orders Brokered to OROMS (L04)

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:

Store Pickup Order Type (L33)

Defines the order type to assign to store pickup orders.

Code:

Cancel Reason (Rejected Store Pickup Orders) (G11)

Defines the cancel reason code to apply to store pickup orders rejected by Order Broker or by the assigned fulfilling location.

Code:

Payment at POS for Ship for Pickup Orders (L60)

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:

Cancel Reason (Pick In) (L86)

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:

Payment at POS for Store Pickup (M16)

Controls whether to authorize store pickup orders for verification only, or to authorize and bill store pickup orders in Order Management System.

Selected/ Unselected:

Suppress Returns for Retail Pickup/Delivery (L88)

Defines whether you can process a return or a negative additional charge for a retail pickup or delivery order.

Selected/ Unselected:

OROB Product Code ID (K66)

Indicates the field where you store Order Broker’s default product code.

Code:

Order Broker Fulfillment Values

Use OROB for Fulfillment Assignment (M31)

Select this system control value to use the Order Broker Fulfillment Integration.

Selected/ Unselected:

Originating Location to Pass to OROB (M32)

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:

Order Type for Delivery Orders Originating in OROMS (M33)

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:

Use OROB for Ship for Pickup Fulfillment Assignment (M34)

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:

Drop Ship Integration Values (H20)

Use OROB Drop Shipping (H13)

Select this field if you are using Order Broker to process drop ship purchase orders.

Selected/ Unselected:

Drop Ship Lead Days (H36)

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:

Use WMS Integration (K25)

Identifies whether or not an external warehouse management system is being used with Order Management System.

Selected/ Unselected:

Alternate ID Required for Displaying Customer Profile (K87)

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:

Store Pickup Confirmation Email Program (L48)

Defines the program that generates the store pickup notification email.

Program name:

ORCE Integration Values (L52)

These values control integration with Oracle Retail Customer Engagement.

ORCE Customer Integration (L37)

Defines how Order Management System sends customer information to Oracle Retail Customer Engagement.

Code:

MICROS Integration Item ID (L38)

Defines how Order Management System identifies items/SKUs for integrations with other systems.

Code:

Item for Non-Merchandise Amounts (L39)

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:

Cross Channel Orders to Exclude in Sales Feed (L35)

Defines the types of orders Order Management System excludes in the Oracle Retail Customer Engagement Sales Feed.

Code:

Return Disposition Code to Exclude in ORCE Sales Feed (M22)

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:

Merchandise Only in Sales Feed (L36)

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:

ORCE Organization Descriptor (L50)

Identifies the Oracle Retail Customer Engagement organization that maps to your Order Management System company.

Code:

Send Profile Data to ORCE (L51)

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:

Default Location for ORCE Integration (K69)

Indicates the store cross-reference record you use as part of an integration with a point-of-sale system.

Code:

Use ORCE Wish List (M26)

Defines whether you use the Customer Engagement Customer Wish List Integration.

Selected/ Unselected:

Use ORCE Loyalty (M06)

Defines whether you use the Customer Engagement Loyalty Integration.

Selected/ Unselected:

Prompt to Join Loyalty (M07)

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:

ORCE Loyalty Card Prefix (M08)

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:

ORCE Loyalty Card Series Sequence Number (M09)

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:

ORCE Loyalty Registration Notification Email Program (M10)

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:

Use External Item Image (L55)

Defines whether the system retrieves item images and item information from an external image hosting application.

Selected/ Unselected:

Periodic Process History Purge Days (L77)

Defines the number of days old a periodic process history record should be before it is eligible for purge.

Number:

Create Separate Picks for Ship for Pickup Orders (L89)

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:

ChannelAdvisor Order Type (L90)

Defines the order type to assign to orders you process through the ChannelAdvisor integration.

Code:

ChannelAdvisor Inventory Level Default (L91)

Defines the available quantity to report to ChannelAdvisor for drop ship and non-inventory items.

Number:

ChannelAdvisor SKU X-Ref Offer (L92)

Defines the offer associated with item and SKU cross-references for ChannelAdvisor.

Code:

IN03_17 OMS 17.1 September 2018 OTN