Item Supp Country Bracket Cost

In Scope

Technical: ITEM_SUPP_COUNTRY_BRACKET_COST | ID: OR-ITM-ITEM_SUPP_COUNTRY_BRACKET_COST-ITEM_SUPP_COUNTRY_BRACKET_COST

This table will contain the costs at the item/supplier/country/location level for each bracket. The brackets will default in from one of the supplier levels, supplier, supplier/department, supplier/department/location, supplier/location, and costing...

See how this object fits into Item Management

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: ITEM_SUPP_COUNTRY_BRACKET_COST

Field Definitions(5)

Rules & Considerations(23)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	SUPPLIERR	BRACKET_VALUE1R	ORIGIN_COUNTRY_IDR	LOCATION	LOC_TYPE	CREATE_ID	UNIT_COST	BRACKET_VALUE2	CREATE_DATETIME	SUP_DEPT_SEQ_NO	DEFAULT_BRACKET_IND
Example values from field definitions	SAMPLE	1	1.0000	SAM	1	S	SAMPLE	1.0000	1.0000	2026-01-01	1	S
default	Item Supp Country Bracket	3	12.5000	ALT	3	W	C LIENT_INFO	12.5000	12.5000	2026-01-03	4	I
default	Item Supp Country Bracket	5	14.0000	EDG	5	S	USE RENV	14.0000	14.0000	2026-01-05	6	I

Example values from field definitions

ITEMRPK: SAMPLE
SUPPLIERR: 1
BRACKET_VALUE1R: 1.0000
ORIGIN_COUNTRY_IDR: SAM
LOCATION: 1
LOC_TYPE: S
CREATE_ID: SAMPLE
UNIT_COST: 1.0000
BRACKET_VALUE2: 1.0000
CREATE_DATETIME: 2026-01-01
SUP_DEPT_SEQ_NO: 1
DEFAULT_BRACKET_IND: S

default

ITEMRPK: Item Supp Country Bracket
SUPPLIERR: 3
BRACKET_VALUE1R: 12.5000
ORIGIN_COUNTRY_IDR: ALT
LOCATION: 3
LOC_TYPE: W
CREATE_ID: C LIENT_INFO
UNIT_COST: 12.5000
BRACKET_VALUE2: 12.5000
CREATE_DATETIME: 2026-01-03
SUP_DEPT_SEQ_NO: 4
DEFAULT_BRACKET_IND: I