25 Integration with Third Party POS

This chapter contains information about the batch processes that send information to 3rd Party POS systems.

For information about integration of transactions from either 3rd party POS systems or the Oracle Retail POS Suite to RMS, see the chapter Sales Posting.

Program Summary

Table 25-1 Program Summary

Program	Description
poscdnld.pc	Download of POS Configuration Data to 3rd Party POS
export_merchhier.ksh	Download of Merchandise Hierarchy to POS. See the Chapter in this guide regarding Xstore integration.
taxdnld.pc	Tax Download to 3rd Party POS in Global Tax [GTAX] Implementations

It is likely that all 3rd Party POS Integration programs will not be used by most clients. The programs a client should use are dependent on their POS systems, business processes for managing those POS systems and operations requirements.

The information sent to 3rd Party POS systems falls into the following broad categories:

Table 25-2 Categories 3rd Party POS Systems

Category	Programs	Usage Recommendation
POS Configuration	poscdnld.pc	Only run this program if you use RMS to master POS Copnfiguration Data
Foundation	export_merhhier.ksh	This program sends merchandise hierarchy information to POS systems. Client business process and POS system requirements will determine if this program needs to be run. See the Chapter in this guide regarding Xstore integration.
Tax	taxdnld.pc	This program should be used when clients run 'GTAX' Tax

taxdnld (Tax Download to 3rd Party POS in Global Tax [GTAX] Implementations)

Module Name	taxdnld
Description	Tax Download to 3rd Party POS in Global Tax [GTAX] Implementations
Functional Area	Integration - 3rd Party POS
Module Type	Integration
Module Technology	ProC
Catalog ID	RMS124

Design Overview

Taxdnld.pc downloads the tax information to 3rd Party POS systems when the RMS default tax type is GTAX.This program only needs to be run is the client uses RMS Global Tax functionality.

Scheduling Constraints

Table 25-3 Scheduling Constraints

Schedule Information	Description
Frequency	As Needed
Scheduling Considerations	Optional - This program only needs to be run is the client uses RMS Global Tax (GTAX) functionality
Pre-Processing	NA
Post-Processing	NA
Threading Scheme	Threading logic is based on STORE number

Restart/Recovery

The logical unit of work for this module is defined by item, ref_item and store combination. This batch program uses table-based restart/recovery. The commit happens in the database when the commit_max_ctr is reached.

Key Tables Affected

Table 25-4 Key Tables Affected

Table	Select	Insert	Update	Delete
POS_MODS_TAX_INFO	Yes	No	No	No
GTAX_ITEM	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
ITEM_LOC	Yes	No	No	No
V_RESTART_STORE	Yes	No	No	No
CLASS	Yes	No	No	No

Integration Contract

Integration Type	Download from RMS
File Name	Determined by runtime parameter
Integration Contract	IntCon000020

I/O Specification - Output File Layout

Table 25-5 Output File Layout

Record Name	Field Name	Field Type	Default Value	Description
FHEAD	File Type Record Descriptor	Char(5)	FHEAD	Identifies file record type
	File Line Sequence	Number(10)	NA	Line number of the current file
	File Type Definition	Char(4)	TAXD	Identifies file as 'Tax Details'
	File Create Date	Char(14)	create date	Vdate in 'YYYMMDDHHMISS'format
FDETL	FDETL	Char(5)	FDETL	FDETL
	File Line Sequence	Number(10)	NA	Line number of the current file
	STORE	Char(10)	NA	Store number
	ITEM	Char(25)	NA	Item
	item_number_type	Char(6)	S - Store W - Warehouse	Item number type
	format_id	Char(1)	NA	Format id
	prefix	Char(2)	NA	Prefix
	ref_item	Char(25)	NA	Reference Item
	ref_item_number_type	Char(6)	NA	Refrerence item number type
	ref_format_id	Char(1)	NA	Ref format id
	ref_prefix	Char(2)	NA	Ref no. prefix
	taxable indicator	Char(1)	NA	Taxable indicator
	class_vat_ind	Char(1)	NA	Class vat indicator
FTAXD	FTAXD	Char(5)	FTAXD	FTAXD
	File Line Sequence	Number(10)	NA	Line number of the current file
	tax_code	Char(10)	NA	Tax code
	tax_rate	Char(20)	NA	Tax rate
	calculation_basis	Char(1)	NA	Calculation basis
	tax_amount	Char(20)	NA	Tax amount
	effective_from	Char(8)	NA	Effective from
	time	Char(6)	NA	Time
	status	Char(1)	NA	Status
FTAIL	File Type Record Descriptor	Char(5)	FTAIL	Identifies file record type
	File Line Sequence	Number(10)	NA	Line number of the current file
	rec_counter	Number(10)	NA	Record counter

poscdnld (Download of POS Configuration Data to 3rd Party POS)

Module Name	poscdnld.pc
Description	Download of POS Configuration Data to 3rd Party POS
Functional Area	Integration - 3rd Party POS
Module Type	Integration
Module Technology	ProC
Catalog ID	RMS69
Runtime Parameters	NA

Design Overview

This program downloads POS configuration information from RMS to a flat file. This file can be used to load POS and back-office systems.This program (and its related prepost function poscdnld_post() ) should only be run if RMS is used to master:

• Coupon definitions and relationships to items

• Restrictions on product sales, including but not limited to minimum age of purchaser, time/days when product cannot be sold, tenders that cannot be used to purchase the product, and so on.

Scheduling Constraints

Table 25-6 Scheduling Constraints

Schedule Information	Description
Frequency	Daily
Scheduling Considerations	This program (and its related prepost function poscdnld_post() ) should only be run if RMS is used to master: Coupon definitions and relationships to items Restrictions on product sales, including but not limited to minimum age of purchaser, time/days when product cannot be sold, tenders that cannot be used to purchase the product, and so on.
Pre-Processing	NA
Post-Processing	poscdnld_post() - set status back to NULL
Threading Scheme	Single Thread

Restart/Recovery

The logic unit of work is pos configuration type and pos configuration ID. The commit_max_ctr field should be set to prevent excessive rollback space usage, and to reduce the overhead of file I/O. The recommended commit counter setting is 1000 records (subject to change based on implementation).

Key Tables Affected

Table 25-7 Key Tables Affected

Table	Select	Insert	Update	Delete
POS_PROD_REST_HEAD	Yes	No	No	Yes
POS_COUPON_HEAD	Yes	No	No	Yes
POS_CONFIG_ITEMS	Yes	No	No	Yes
POS_STORE	Yes	No	No	Yes
POS_DAY_TIME_DATE	Yes	No	No	Yes
POS_MERCH_CRITERIA	Yes	No	No	Yes
DEPS	Yes	No	No	No
ITEM_LOC	Yes	No	No	No
ITEM_MASTER	Yes	No	No	No
PERIOD	Yes	No	No	No

I/O Specification

Integration Type	Download from RMS
File Name	Determined by runtime parameter.
Integration Contract	IntCon000063

Output File Layout

Table 25-8 Output File Layout

Record Name	Field Name	Field Type	Default Value	Description
FHEAD	Record Type	Char(5)	'FHEAD'	Record Identifier
	Line id	Number(10)	0000000001	Sequential Line Identifier
	File Name	Char(4)	'POSC'	File Identifier
	File Date	Char(14)	NA	Date the file was created in 'YYYYMMDD HHMMSS' format
TCOUP	Record Type	Char(5)	TCOUP	Record Identifier
	Line id	Number(10)	NA	Sequential Line Identifier
	Coupon id	Number(6)	NA	NA
	Coupon Desc	Char(250)	NA	NA
	Currency Code	Char2(3)	NA	NA
	Max Discount Amount	Number(20,4)	NA	NA
	Amount	Number(20,4)	NA	NA
	Percent Ind	Char(1)	'N' - Amount 'Y'- Percentage	NA
	Profit Center	Char(6)	NA	NA
	Tax Class	Char(6)	NA	NA
	Export Code	Char(6)	NA	NA
	Effective Date	Char(14)	NA	Indicates the first day the coupon can be used in 'YYYYMMDD HHMMSS' format
	Expiration Date	Char(14)	NA	Indicates the day the coupon becomes invalid in 'YYYYMMDD HHMMSS' format
	Prompted Ind	Char(1)	'Y', 'N'	This indicator identifies if the cashier should be prompted to ask for a Coupon.
	Display Ind	Char(1)	'Y', 'N'	This indicator specifies whether the coupon is displayed in the list of valid coupons on the register.
	Status	Char(1)	'A','C','D'	Indicates if the coupon configuration is new, has been changed, or being deleted.
	Vendor	Number(10)	NA	NA
	Vendor Type	Char(6)	'AG' - Agent 'AP' - Applicant 'BK' - Bank 'BR' - Broker 'CN' - Coonsignee 'CO' - Consolidator 'FA' - Factory 'FF' - Freight Forwarder 'IM' - Importer 'SU' - Supplier	NA
	Promotion	Number(10)	NA	NA
	Coupon Barcode	Char(20)	NA	NA
	Coupon Max Qty	Number(6)	NA	NA
TPRES	Record Type	Char(5)	TPRES	Record Identifier
	Line id	Number(10)	NA	Sequential Line Identifier
	POS Product Restriction id	Number(6)	NA	NA
	POS Product Restriction Desc	Char(120)	NA	NA
	POS Product Restriction Type	Char(6)	'PPRT' include: 'STMP' - Food Stamp 'MNAG' - Minimum Age 'CNDP' -Container Deposit 'CNVL' - Container Redemption Value 'DTDR' - Day/Time/Date Restriction 'TENT' - Tender Type 'NDSC' - Non-Discountable 'RTRN' - Returnable 'QLMT' - Quantity Limit	NA
	Effective Date	Char(14)	NA	Date the product restriction is first effective in 'YYYYMMDD HHMMSS' format
	Currency Code	Char(3)	NA	NA
	Product Restriction Amount	Number(20,4)	NA	NA
	Age Minimum	Number(2)	NA	NA
	Date Restriction	Char(14)	NA	Date on which a specified product restriction is applied in 'YYYYMMDD HHMMSS' format
	Before Time Restriction	Char(6)	NA	NA
	After Time Restriction	Char(6)	NA	NA
	Day Restriction	Char(6)	NA	NA
	Max Qty Amount	Number(12,4)	NA	NA
	Tender Type Group	Char(6)	'CASH' - Cash, 'CHECK' - Check, 'CCARD' - Credit, 'COUPON' - Coupon, 'LOTTRY' - Lottery, 'FSTAMP' - Food Stamp, 'DCARD' - Debit Card, 'MORDER' - Money Order 'VOUCH' - Voucher 'ERR' - Error, 'SOCASS' - Social Assistance, 'TERM' - Termination Record, 'DRIVEO' - Drive Off, 'EBS' - Electronic Benefits ( Food Stamps)	NA
	Status	Char(1)	'A','C','D'	Indicates if the product restriction configuration is new, has been changed, or being deleted.
TSTOR	Record Type	Char(5)	'TSTOR'	NA
	Line id	Number(10)	NA	NA
	Store	Number(10)	NA	NA
	Status	Char(1)	'A' - Add 'D' - Delete 'C' - Change	NA
TITEM	Record Type	Char(5)	TITEM	Record Identifier
	Line id	Number(10)	NA	Sequential Line Identifier
	Item	Char(25)	NA	Left-Justified Item Identifier
	Status	Char(1)	'A' - Add 'D' - Delete 'C' - Change	Indicates the item's status at the POS. Overlays of items as a result of a change to the merch criteria will have a ’C' status.
FTAIL	Record Type	Char(5)	FTAIL	Marks end of file
	Line id	Number(10)	NA	Total number of lines in file
	Number of transactions	Number(10)	NA	Number of transactions in file