Dc Deps

In Scope

Technical: DC_DEPS | ID: OR-MFCS-DC_DEPS

This table is a staging table for data conversion and will hold data for department table..

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

Target Structure

Load Approach: Table
Target Objects: DC_DEPS

Field Definitions(27)

Rules & Considerations(3)

Sequencing

Reconciliation

Sample Load Data(4)

_scenario	DEPT	BUYER	MERCH	GROUP_NO	DEPT_NAME	MRKUP_PCT	OTB_CALC_TYPE	PURCHASE_TYPE	MAX_AVG_COUNTER	WORKSHEET_LEVEL	MARKUP_CALC_TYPE	PROFIT_CALC_TYPE	TOTAL_MARKET_AMT	AVG_TOLERANCE_PCT	DEPT_VAT_INCL_IND	REGULAR_SALES_IND	INCLUDE_WH_ON_HAND	CLEARANCE_SALES_IND	INCLUDE_WH_ON_ORDER	LOWEST_STRATEGY_LEVEL	PROMOTIONAL_SALES_IND	HISTORICAL_SALES_LEVEL	COST_CHG_HIGHLIGHT_DAYS	PEND_COST_CHG_WINDOW_DAYS	RETAIL_CHG_HIGHLIGHT_DAYS	PEND_COST_CHG_HIGHLIGHT_DAYS	PRICE_CHANGE_AMOUNT_CALC_TYPE
default	1001	0001	0001	0002	Apparel	11.0000	Dc Deps-001	1	00001	000001	Dc Deps-001	1	11.0000	11.0000	Dc Deps-001	000001	000001	000001	000001	000001	000001	000001	0001	0001	0001	0001	000001

default

DEPT: 1001
BUYER: 0001
MERCH: 0001
GROUP_NO: 0002
DEPT_NAME: Apparel
MRKUP_PCT: 11.0000
OTB_CALC_TYPE: Dc Deps-001
PURCHASE_TYPE: 1
MAX_AVG_COUNTER: 00001
WORKSHEET_LEVEL: 000001
MARKUP_CALC_TYPE: Dc Deps-001
PROFIT_CALC_TYPE: 1
TOTAL_MARKET_AMT: 11.0000
AVG_TOLERANCE_PCT: 11.0000
DEPT_VAT_INCL_IND: Dc Deps-001
REGULAR_SALES_IND: 000001
INCLUDE_WH_ON_HAND: 000001
CLEARANCE_SALES_IND: 000001
INCLUDE_WH_ON_ORDER: 000001
LOWEST_STRATEGY_LEVEL: 000001
PROMOTIONAL_SALES_IND: 000001
HISTORICAL_SALES_LEVEL: 000001
COST_CHG_HIGHLIGHT_DAYS: 0001
PEND_COST_CHG_WINDOW_DAYS: 0001
RETAIL_CHG_HIGHLIGHT_DAYS: 0001
PEND_COST_CHG_HIGHLIGHT_DAYS: 0001
PRICE_CHANGE_AMOUNT_CALC_TYPE: 000001