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.
Resource | Notes |
---|---|
addresstype | 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 | 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 | Allocation patterns for allocating orders of items among multiple stores. |
biometrics | 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.
|
calendar | List of calendars. |
chargeterm | Charge terms. Charge terms are defined in customer records. |
comment | Comments for POS documents. |
company | 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 | Contact type (Mail, Phone, Email). Contact types are defined in Admin Console > Preferences & Settings > Data Types. |
country | List of countries |
couponset | Coupon set. (Defined in coupon sets and coupons in Point of Sale > Promotions > Coupons) |
couponsetcoupon | Coupon set coupon. (Defined in coupon sets and coupons in Point of Sale > Promotions > Coupons) |
customer | The list of customer records. Customer class, customer document history and customer UDF fields are replicated using their own dedicated resources (see the entries that follow). |
customerclass | The Class field is used to group customers for marketing and other purposes. This resource replicates the class field info. |
customerdocumenthistory | Information about customer purchasing history. |
customerudf | Information about customer UDF fields, defined in Admin Console > Node Preferences > Customers > UDF |
dcs | The list of departments (groupings of merchandise). |
docposflag | POS flags. Defined in Admin Console > Preferences & Settings > Node Preferences > Merchandise > POS Flags. |
document | Transactions. |
documentfeetype | Fee types assigned to fee amounts on documents. Define fee types in Admin Console > Node Preferences > Transactions > Fees/Shipment. |
drawerevent | Z-Out drawer open events. |
emailtype | Email type (e.g. Home, Work, Other). Email types are defined in Admin Console > Preferences & Settings > Data Types. |
employeeudf | Employee user-defined fields. Defined in the employee record. |
exchangerate | The list of exchange rates for each currency. Define exchange rates in Admin Console > Global Preferences > Currency > Exchange Rate. |
fiscaldocument | Fiscal documents. |
fiscalsequence | Fiscal document sequences. |
griddata | Grid format settings. Grid data settings are defined in Admin Console > Preferences & Settings > Grid Formats. |
inventory | Inventory information. Note: If using loyalty, as part of the inventory resource, each item's Loyalty Redeem and Loyalty Reward point values are replicated as well as the Item Reward information if the item is part of an Item Reward program. |
inventorystyle | Inventory style information. |
invnlot | Inventory lot number information. Lot number information is added in the Inventory item record. |
invnminmax | (Prism 2.1 and above) To replicate Min/Max levels for Inventory items, select the invnminmax resource in the profile. Care should be taken when selecting this resource to avoid replicating a lot of excess data. When the invnminmax resource is selected, Prism replicates the Min/Max tables and the New Min, New Max values. Configuration for Auto Min/Max is not replicated. |
invnsbssublocationqty | Sublocation quantities. Sublocation data and the corresponding resources are spit between the sublocations themselves and their item quantities. At a store, a sublocation can be created or modified, and this will be replicated enterprise wide. But a store's sublocation item quantities are modified by documents. Subsequent stock quantity updates are executed by the documents through replication. Sublocations and their properties are core resources to ensure that the sublocation of a document exists at the document target. Note: The sublocationsegpref resource is part of the "Core" resources and as such it is not displayed in the list of resources. This resource is sent with the other core resources during initialization (or if the profile has the core resources checkbox selected). |
invnserial | Inventory serial number information. Serial number information is added in the Inventory item record. |
invnudf | User-defined fields for inventory items, defined in Admin Console > Node Preferences > Merchandise > Inventory > UDF. |
job | Job titles (e.g. Manager, Associate, Cashier). |
kitcomponent | Information about Kit Items and their components. |
language | List of languages. |
ltylevel | Customer loyalty-level assignments. |
ltylevelprogram | Loyalty levels and programs. |
markdown | (Prism 2.1 and above) The markdown resource sends the Price Adjustment Memos created when updating a markdown in Price Manager. Previously, replicating markdowns required sending the Inventory resource (a time-consuming resource to process).By creating a separate resource for markdowns, Prism replicates these price changes more efficiently. Notes:
|
mediatype | This resource is not currently used in Prism and can be safely omitted from profiles, including initialization. |
pcppromotion | Promotions created in Prism. |
phonetype | Phone type (e.g. Home, Work, Other). Phone types are defined in Admin Console > Preferences & Settings > Data Types. |
plugindata | Customization and plugin data. |
pricerounding | Price rounding information. |
printarea | The printarea resource enables replication of report groups for printing. |
puchaseorder | Purchase orders. |
purchfeetype | Fee types for purchase orders. Define fee types for POs in Admin Console > Preferences & Settings > Purchasing > General. |
reason | Reasons for applying discounts and other actions. Define reasons in Admin Console > Preferences & Settings > System > Reasons and Notes. |
receiving | Receiving documents. |
region | Corporate regions (for regional inventory). |
scale | Grid scales (sets of size/attribute combinations). |
scalepattern | Inventory grid scale patterns (size/attribute patterns). |
shippingmethod | This resource contains the shipment carriers and methods (e.g. USPS, UPS, FEDEX). |
till | List of tills. |
timeclock | Check In/Check Out records. |
title | Titles (Mr., Mrs., Ms., etc.). Titles are defined in Admin Console > Node Preferences > Data Types. |
touchmenu | 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 | Fee Types for transfer orders, defined in Admin Console > Preferences & Settings > Node Preferences > Transfers > General |
transferorder | List of transfer orders. |
transferslip | List of transfer slips. |
transrule | Resolution rules for transfer verification. Resolution rules are defined in Admin Console > Preferences & Settings > Transfers > Resolution Rules. |
userpasswordhistory |
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 | List of vendors. Vendors are defined in Store Operations > Merchandise > Vendors. |
vendorinvoice | 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 | Vendor user-defined fields. |
zoutcontrol | Z-Out) reports provide end-of-day reporting of sales totals. |
Central Resources
Resource | Description |
---|---|
ltycustcentral | Use this resource to replicate customer point balances. |