Oracle® Retail Merchandising System Operations Guide, Volume 1 - Batch Overviews and Designs 16.0.024 E89599-02 |
|
Previous |
Next |
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.
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 |
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 |
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.
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 |
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.
Integration Type | Download from RMS |
File Name | Determined by runtime parameter |
Integration Contract | IntCon000020 |
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 |
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 |
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.
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:
|
Pre-Processing |
NA |
Post-Processing |
poscdnld_post() - set status back to NULL |
Threading Scheme |
Single Thread |
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).
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 |
Integration Type | Download from RMS |
File Name | Determined by runtime parameter. |
Integration Contract | IntCon000063 |
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 |