Updated: January 8, 2020 2:10pm

Resources

Resources are the data types replicated from one Prism server to another. When configuring data replication, you create profiles that include the resources you need to send from the server to other locations. When you link a profile to a connection, the resources specified in the profile will be sent to the server at the other end of the connection. The resources that can be included in a profile vary depending on whether the profile is a RIL-to-Prism profile, Prism-to-RIL, or Prism-to-Prism. In most cases, the name of the resource is the same as the RIL Oracle table name; however, there are some differences. Disclaimer: The following list is current as of Prism 1.14.6. The list of resources is still expanding.

Resource RIL to Prism Prism to RIL Prism to Prism Notes
addresstype Yes Yes Yes List of address types. Define address types in Admin Console > Preferences & Settings > Node Preferences > Data Types. The address types defined in preferences can be assigned to individual addresses in customer records.
adjustment Yes Yes Yes Adjustment memos. Adjustment memos are typically only sent UPSTREAM, from a store to its POA or from the POA to HQ. Best practice is to not send adjustment memos downstream from HQ to stores
allocationpattern Yes Yes Yes Allocation patterns for allocating orders of items among multiple stores. Define allocation patterns in RIL. The patterns defined in RIL will be available for use on purchase orders in Prism.
biometrics No No Yes Biometrics login information. Two database columns play a key role in biometric login: user_name and empl_name.
The Prism RPSODS database EMPLOYEE table includes user_name and empl_name columns. The BIOMETRICS table includes empl_name column.
  • The user_name column is unique across all subsidiaries. When a user does a regular log in using user name and password, the server looks in the EMPLOYEE table and tries to find a matching record. The employee resource is a core resource and cannot be filtered or excluded from replication. As a result, you can use the user_name and password of any employee and login to Prism at any store.
  • The empl_name column is unique within a single subsidiary. When a user does a biometric log in using a fingerprint, the server first looks in the BIOMETRICS table and retrieves the empl_name and sbs_sid. The server tries to match the retrieved information with a corresponding empl_name and orig_sbs_sid in the EMPLOYEE table. If a match is found, the server uses the user_name and password from the EMPLOYEE table for the login. The biometrics resource is not a core resource; therefore, you can apply a filter or simply not replicate the resource. This creates the possibility that a user may be able to log in using the username and password but the log in using the fingerprint fails.
If you want to filter your data by subsidiary but still want all fingerprints to be replicated you must create a separate profile that only includes the biometrics resource and do not apply any filter to it. The rule is: empl_name + orig_sbs_sid from EMPLOYEE table MUST match empl_name + sbs_sid from BIOMETRICS table. Therefore when you create a biometrics record, you should pass empl_name and sbs_sid equal to empl_name and orig_sbs_sid (important! Not employee sbs_sid but employee orig_sbs_sid) of the employee who you are creating the fingerprint for.
calendar Yes No Yes List of calendars defined in RIL Global Preferences > Calendars > Retail Calendars. The following default retail calendars are replicated: Default, Weekly, 4-5-4, 4-4-5, 13 Months.
chargeterm Yes No Yes Charge terms. Charge terms are defined in customer records in RP Prism and RIL.
comment Yes Yes Yes Comments for POS documents. Comments are defined in RIL Management in Local Preferences > Point of Sale > Receipts > Comments.
company Yes Yes Yes The list of companies that can be assigned to customer records. When a new company is entered in a customer record, the company is added to the database in a special table and will be available for selection on customer records.
contacttype No No Yes Contact type (Mail, Phone, Email). Contact types are defined in Admin Console > Preferences & Settings > Data Types.
country No Yes Yes List of countries
couponset No No Yes Coupon set. (Defined in coupon sets and coupons in Point of Sale > Promotions > Coupons)
couponsetcoupon No No Yes Coupon set coupon. (Defined in coupon sets and coupons in Point of Sale > Promotions > Coupons)
currency Yes Yes No List of currencies defined in RIL Global Preferences > Currencies (Currencies area). The currencies defined in preferences can be used as foreign currency tenders and can be assigned to vendors for ordering items in a foreign currency.
customer Yes Yes Yes The list of customer records. The customers defined in RIL Management are copied to the Prism server during initialization. Customer class and customer UDF fields are replicated from RIL to Prism using their own dedicated resources (see the entries that follow).
customerclass Yes No No The Class field is used to group customers for marketing and other purposes. This resource replicates the class field info.
customerdocumenthistory No No Yes Information about customer purchasing history.
customerudf Yes Yes Yes Information about customer UDF fields, defined in RIL Local Preferences > Customers > UDF/Aux. The UDF fields defined in RIL are copied to the Prism server during initialization.
dcs Yes Yes Yes The list of departments (groupings of merchandise). Defined in Store Operations > Merchandise > Departments area of RIL Management.
docposflag Yes Yes Yes POS flags. Defined in Admin Console > Preferences & Settings > Node Preferences > Merchandise > POS Flags.
document No Yes Yes Transactions.
documentfeetype Yes Yes Yes Fee types assigned to fee amounts on documents.
drawerevent No Yes Yes Z-Out drawer open events.
emailtype No No Yes Email type (e.g. Home, Work, Other). Email types are defined in Admin Console > Preferences & Settings > Data Types.
employee Yes Yes Yes Employee information. Define employee UDF fields in the employee record.
employeeudf Yes Yes Yes Employee user-defined fields. Defined in the employee record.
exchangerate Yes Yes Yes The list of exchange rates for each currency. Define exchange rates in Admin Console > Global Preferences > Currency > Exchange Rate.
griddata No No Yes Grid format settings. Grid data settings are defined in Admin Console > Preferences & Settings > Grid Formats.
inventory Yes Yes Yes Inventory information. Note: As part of the inventory resource, each item's Loyalty Redeem and Loyalty Reward point values are replicated from RIL to Prism (item-based programs) as well as the Item Reward information if the item is part of an Item Reward program.
For customer loyalty: Replicates Item Loyalty Redeem and Loyalty Reward point values from RIL to Prism (item-based loyalty programs). The Item Reward program information is for those items that part of programs that have a Redeem Type of "Item Reward."
inventorystyle Yes No Yes Inventory style information, defined in RIL Merchandise > Inventory > Style View area.
invnlot Yes Yes Yes Inventory lot number information. Lot number information is added in the Inventory item record.
invnserial Yes Yes Yes Inventory serial number information. Serial number information is added in the Inventory item record.
invnudf Yes Yes Yes User-defined fields for inventory items, defined in Admin Console > Node Preferences > Merchandise > Inventory > UDF.
job Yes Yes Yes Job titles (e.g. Manager, Associate, Cashier). Currently job titles must be defined in RIL preferences.
kitcomponent Yes Yes Yes Information about Kit Items and their components. Currently, kit items must be added and configured in RIL Merchandise > Inventory > Packages and Kits.
language No Yes Yes List of languages.
ltylevel Yes No Yes (RIL-to-Prism profiles only) Use this resource to replicate loyalty levels and loyalty programs to Prism.
markdown Yes No Yes Price manager markdowns.
mediatype Yes Yes Yes This resource is not currently used in Prism and can be safely omitted from profiles, including initialization.
pcppromotion No No Yes Promotions created in Prism.
phonetype No No Yes Phone type (e.g. Home, Work, Other). Phone types are defined in Admin Console > Preferences & Settings > Data Types.
pisheetdata No No Yes Physical Inventory sheets
plugindata Yes No Yes Customization and plugin data.
pricelevel Yes Yes Yes Price level information. Define Price Level information in Admin Console > Preferences & Settings > Merchandise > Pricing > Price Levels.
pricerounding Yes Yes Yes Price rounding information. Price rounding instructions are defined in the RIL Prism Management application preferences area.
printarea No No Yes The printarea resource enables replication of report groups for printing.
puchaseorder Yes Yes Yes Purchase orders.
purchfeetype Yes Yes Yes Fee types for purchase orders. Define fee types for POs in Admin Console > Preferences & Settings > Purchasing > General.
reason Yes Yes Yes Reasons for applying discounts and other actions. Reasons are defined in Admin Console > Preferences & Settings > System > Reasons and Notes.
receiving Yes Yes Yes Receiving documents.
scale Yes Yes Yes Grid scales (sets of size/attribute combinations).
scalepattern Yes Yes Yes Inventory grid scale patterns (size/attribute patterns). Currently scale patterns are defined in RIL preferences
season Yes Yes Yes Information about Seasons. Seasons are defined in Admin Console > Preferences & Settings > Global Preferences > Seasons.
shippingmethod Yes Yes Yes This resource contains the shipment carriers and methods (e.g. USPS, UPS, FEDEX) defined in RIL Local Preferences > Point of Sale > Sales Orders > Options.
store Yes Yes No Store information Stores are added in Prism in the Admin Console > Node Preferences > Node Selection: New Store.
storetype Yes No No Store type information.
subsidiary Yes Yes No Subsidiary information Subsidiaries are added in Prism in the Admin Console > Node Preferences > Node Selection: New Subsidiary.
taxarea Yes Yes No Tax area information. Tax information is defined in Admin Console > Node Preferences > Taxes > Tax Areas. (Note: Previously, four separate resources (taxcode, taxarea, taxrule and tax) were used to replicate tax information between Prism and RIL. The taxrule and tax resources are now child resources of taxarea.)
taxcode Yes Yes No List of tax codes. Tax information is defined in Admin Console > Node Preferences > Taxes > Tax Areas.
till Yes Yes Yes List of tills.
timeclock No Yes Yes Check In/Check Out records.
title Yes Yes Yes Titles (Mr., Mrs., Ms., etc.). Titles are defined in Admin Console > Preferences & Settings > Data Types.
touchmenu No No Yes Touch menus and buttons. (Important! If the touch menus use item images, those images must be available at the other end of the connection. You can define a central image server in Node Preferences > Themes and Layouts, or export the images, extract and copy to the ...\ProgramData\RetailPro\Server\images folder at the other location.)
tranfeetype Yes Yes Yes Fee Types for transfer orders, defined in Admin Console > Preferences & Settings > Node Preferences > Transfers > General
transferorder Yes Yes Yes List of transfer orders.
transferslip Yes Yes Yes List of transfer slips.
transrule Yes No Yes Resolution rules for transfer verification. Resolution rules are defined in Admin Console > Preferences & Settings > Transfers > Resolution Rules.
usergroup No Yes No This table contains the list of user groups. User groups are defined in Store Operations > Employee Mgmt > Groups. During initialization, the five default groups are sent as well as any other groups defined. Default = POS, Backoffice, Managers, Admin, Buyers
userpasswordhistory No No Yes

The userpasswordhistory resource helps Prism to enforce the password history setting. By replicating the resource, Prism servers will have up-to-date information about user password history.

vendor Yes Yes Yes List of vendors. Vendors are defined in Store Operations > Merchandise > Vendors.
vendorinvoice Yes Yes Yes Vendor invoices. Vendor invoices record the actual amount charged by the vendor for an order. Each vendor invoice is matched with one or more vouchers.
vendorudf Yes Yes Yes Vendor user-defined fields.
zoutcontrol No No Yes Z-Out) reports provide end-of-day reporting of sales totals.

Central Resources

Resource Description
ltycustcentral Use this resource to replicate customer point balances. You must create a separate profile that only includes this resource. First click the Centrals checkbox on a RIL-to-Prism or Prism-to-RIL profile and then select the ltycustcentral resource.