POS Product Rest Header

In Scope

Technical: POS_PROD_REST_HEAD | ID: OR-FND-POS_PROD_REST_HEAD-POS_PRODUCT_REST_HEADER

Stores the product restriction details for all types of product restrictions, including: food stamp, minimum age, container deposit, container redemption value, date restriction, time restriction, day restriction, tender type, non-discountable,...

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: POS_PROD_REST_HEAD

Field Definitions(5)

Rules & Considerations(26)

constraint

validation

Sample Load Data(4)

_scenario	EFFECTIVE_DATER	POS_PROD_REST_IDRPK	POS_PROD_REST_DESCR	POS_PROD_REST_TYPER	AGE_MIN	MAX_QTY	CREATE_ID	MODIFY_ID	CREATE_DATE	MODIFY_DATE	CURRENCY_CODE	EXTRACTED_IND	PROD_REST_AMT	EXTRACT_REQ_IND	POS_CONFIG_STATUS	TENDER_TYPE_GROUP	MERCH_CRIT_CHG_IND
Example values from field definitions	2026-01-01	1	SAMPLE	SAMPLE	1	1.0000	SAMPLE	SAMPLE	2026-01-01	2026-01-01	SAM	S	1.0000	S	S	SAMPLE	S
default	2026-01-03	100003	POS Prod Rest Head-002-ALT	STMP	3	12.5000	MDM_USER	ALT-POS_PROD-002	2026-01-03	2026-01-03	ALT	P	12.5000	P	P	CHECK	P
default	2026-01-05	100005	POS Prod Rest Head-003-EDGE	STMP	5	14.0000	BATCH_USER	EDGE-POS_PROD-003	2026-01-05	2026-01-05	EDG	P	14.0000	P	A	CCARD	P

Example values from field definitions

EFFECTIVE_DATER: 2026-01-01
POS_PROD_REST_IDRPK: 1
POS_PROD_REST_DESCR: SAMPLE
POS_PROD_REST_TYPER: SAMPLE
AGE_MIN: 1
MAX_QTY: 1.0000
CREATE_ID: SAMPLE
MODIFY_ID: SAMPLE
CREATE_DATE: 2026-01-01
MODIFY_DATE: 2026-01-01
CURRENCY_CODE: SAM
EXTRACTED_IND: S
PROD_REST_AMT: 1.0000
EXTRACT_REQ_IND: S
POS_CONFIG_STATUS: S
TENDER_TYPE_GROUP: SAMPLE
MERCH_CRIT_CHG_IND: S

default

EFFECTIVE_DATER: 2026-01-03
POS_PROD_REST_IDRPK: 100003
POS_PROD_REST_DESCR: POS Prod Rest Head-002-ALT
POS_PROD_REST_TYPER: STMP
AGE_MIN: 3
MAX_QTY: 12.5000
CREATE_ID: MDM_USER
MODIFY_ID: ALT-POS_PROD-002
CREATE_DATE: 2026-01-03
MODIFY_DATE: 2026-01-03
CURRENCY_CODE: ALT
EXTRACTED_IND: P
PROD_REST_AMT: 12.5000
EXTRACT_REQ_IND: P
POS_CONFIG_STATUS: P
TENDER_TYPE_GROUP: CHECK
MERCH_CRIT_CHG_IND: P