POS Coupon Header

In Scope

Technical: POS_COUPON_HEAD | ID: OR-FND-POS_COUPON_HEAD-POS_COUPON_HEADER

Stores the detailed coupon information such as accounting classifications (profit center, tax class), and start and end dates for the coupon.

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_COUPON_HEAD

Field Definitions(5)

Rules & Considerations(49)

constraint

validation

Sample Load Data(4)

_scenario	COUPON_IDRPK	TAX_CLASSR	COUPON_DESCR	COUPON_SEQ_NOR	VENDOR	SUPPLIER	CREATE_ID	MODIFY_ID	PROMOTION	COUPON_AMT	CREATE_DATE	DISPLAY_IND	EXPORT_CODE	MODIFY_DATE	PERCENT_IND	VENDOR_TYPE	BARCODE_TYPE	PROMPTED_IND	TRAN_LVL_IND	CURRENCY_CODE	PROFIT_CENTER	COUPON_BARCODE	COUPON_MAX_QTY	EFFECTIVE_DATE	EXPIRATION_DATE	EXTRACT_REQ_IND	MAX_DISCOUNT_AMT	POS_CONFIG_STATUS	MERCH_CRIT_CHG_IND	PROMOTION_COMPONENT_ID
Example values from field definitions	1	SAMPLE	SAMPLE	1	SAMPLE	1	SAMPLE	SAMPLE	1	1.0000	2026-01-01	S	SAMPLE	2026-01-01	S	SAMPLE	S	S	S	SAM	SAMPLE	SAMPLE	1	2026-01-01	2026-01-01	S	1.0000	S	S	1
default	100003	POS Co	POS Coupon Head-002-ALT	4	POS Coupon	3	MDM_USER	ALT-POS_COUPON-002	3	12.5000	2026-01-03	P	ALT-PO	2026-01-03	P	AG	E	P	P	ALT	POS Co	POS Coupon Head-002-	3	2026-01-03	2026-01-03	P	12.5000	P	P	1000000003
default	100005	POS Co	POS Coupon Head-003-EDGE	6	POS Coupon	5	BATCH_USER	EDGE-POS_COUPON-003	5	14.0000	2026-01-05	P	EDGE-P	2026-01-05	P	AG	E	P	P	EDG	POS Co	POS Coupon Head-003-	5	2026-01-05	2026-01-05	P	14.0000	A	P	1000000005

Example values from field definitions

COUPON_IDRPK: 1
TAX_CLASSR: SAMPLE
COUPON_DESCR: SAMPLE
COUPON_SEQ_NOR: 1
VENDOR: SAMPLE
SUPPLIER: 1
CREATE_ID: SAMPLE
MODIFY_ID: SAMPLE
PROMOTION: 1
COUPON_AMT: 1.0000
CREATE_DATE: 2026-01-01
DISPLAY_IND: S
EXPORT_CODE: SAMPLE
MODIFY_DATE: 2026-01-01
PERCENT_IND: S
VENDOR_TYPE: SAMPLE
BARCODE_TYPE: S
PROMPTED_IND: S
TRAN_LVL_IND: S
CURRENCY_CODE: SAM
PROFIT_CENTER: SAMPLE
COUPON_BARCODE: SAMPLE
COUPON_MAX_QTY: 1
EFFECTIVE_DATE: 2026-01-01
EXPIRATION_DATE: 2026-01-01
EXTRACT_REQ_IND: S
MAX_DISCOUNT_AMT: 1.0000
POS_CONFIG_STATUS: S
MERCH_CRIT_CHG_IND: S
PROMOTION_COMPONENT_ID: 1

default

COUPON_IDRPK: 100003
TAX_CLASSR: POS Co
COUPON_DESCR: POS Coupon Head-002-ALT
COUPON_SEQ_NOR: 4
VENDOR: POS Coupon
SUPPLIER: 3
CREATE_ID: MDM_USER
MODIFY_ID: ALT-POS_COUPON-002
PROMOTION: 3
COUPON_AMT: 12.5000
CREATE_DATE: 2026-01-03
DISPLAY_IND: P
EXPORT_CODE: ALT-PO
MODIFY_DATE: 2026-01-03
PERCENT_IND: P
VENDOR_TYPE: AG
BARCODE_TYPE: E
PROMPTED_IND: P
TRAN_LVL_IND: P
CURRENCY_CODE: ALT
PROFIT_CENTER: POS Co
COUPON_BARCODE: POS Coupon Head-002-
COUPON_MAX_QTY: 3
EFFECTIVE_DATE: 2026-01-03
EXPIRATION_DATE: 2026-01-03
EXTRACT_REQ_IND: P
MAX_DISCOUNT_AMT: 12.5000
POS_CONFIG_STATUS: P
MERCH_CRIT_CHG_IND: P
PROMOTION_COMPONENT_ID: 1000000003

default

COUPON_IDRPK: 100005
TAX_CLASSR: POS Co
COUPON_DESCR: POS Coupon Head-003-EDGE
COUPON_SEQ_NOR: 6
VENDOR: POS Coupon
SUPPLIER: 5
CREATE_ID: BATCH_USER
MODIFY_ID: EDGE-POS_COUPON-003
PROMOTION: 5
COUPON_AMT: 14.0000
CREATE_DATE: 2026-01-05
DISPLAY_IND: P
EXPORT_CODE: EDGE-P
MODIFY_DATE: 2026-01-05
PERCENT_IND: P
VENDOR_TYPE: AG
BARCODE_TYPE: E
PROMPTED_IND: P
TRAN_LVL_IND: P
CURRENCY_CODE: EDG
PROFIT_CENTER: POS Co
COUPON_BARCODE: POS Coupon Head-003-
COUPON_MAX_QTY: 5
EFFECTIVE_DATE: 2026-01-05
EXPIRATION_DATE: 2026-01-05
EXTRACT_REQ_IND: P
MAX_DISCOUNT_AMT: 14.0000
POS_CONFIG_STATUS: A
MERCH_CRIT_CHG_IND: P
PROMOTION_COMPONENT_ID: 1000000005

Rule Validation Summary

Source Rule Count: 54
Governed Rule Count: 49