Month Data

In Scope

Technical: MONTH_DATA | ID: OR-FIN-MONTH_DATA-MONTH_DATA

This table provides a history, by month, of all dollar figures that are maintained by Oracle Retail. The table contains one row for each department/location/half/month number combination within the company.

See how this object fits into Finance

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
MONTH_DATA

Field Definitions(5)

Rules & Considerations(126)

constraint

validation

Sample Load Data(4)

Example values from field definitions

DEPTRPK
1
CLASSRPK
1
LOCATIONRPK
1
LOC_TYPERPK
S
SUBCLASSRPK
1
VAT_IN
1.0000
HALF_NO
1
VAT_OUT
1.0000
EOM_DATE
2026-01-01
MONTH_NO
1
RTV_COST
1.0000
PURCH_COST
1.0000
RTV_RETAIL
1.0000
SALES_UNITS
1.0000
TSF_IN_COST
1.0000
CLS_STK_COST
1.0000
CURRENCY_IND
S
FREIGHT_COST
1.0000
OPN_STK_COST
1.0000
PURCH_RETAIL
1.0000
RETURNS_COST
1.0000
TSF_OUT_COST
1.0000
WORKROOM_AMT
1.0000
CASH_DISC_AMT
1.0000
HTD_GAFS_COST
1.0000
MARKUP_RETAIL
1.0000
TSF_IN_RETAIL
1.0000
CLS_STK_RETAIL
1.0000
CUM_MARKON_PCT
1.0000
NET_SALES_COST
1.0000
OPN_STK_RETAIL
1.0000
RESTOCKING_FEE
1.0000
RETURNS_RETAIL
1.0000
SHRINKAGE_COST
1.0000
STOCK_ADJ_COST
1.0000
TSF_OUT_RETAIL
1.0000
HTD_GAFS_RETAIL
1.0000
RECLASS_IN_COST
1.0000
RECOVERABLE_TAX
1.0000
SET_OF_BOOKS_ID
1
UP_CHRG_AMT_EXP
1.0000
EMPL_DISC_RETAIL
1.0000
GROSS_MARGIN_AMT
1.0000
NET_SALES_RETAIL
1.0000
RECLASS_OUT_COST
1.0000
SHRINKAGE_RETAIL
1.0000
STOCK_ADJ_RETAIL
1.0000
TSF_IN_BOOK_COST
1.0000
COST_VARIANCE_AMT
1.0000
DEAL_INCOME_PURCH
1.0000
DEAL_INCOME_SALES
1.0000
MARKUP_CAN_RETAIL
1.0000
RECLASS_IN_RETAIL
1.0000
TSF_OUT_BOOK_COST
1.0000
DEAL_COST_VARIANCE
1.0000
DEAL_INCOME_ISSUES
1.0000
FREIGHT_CLAIM_COST
1.0000
RECLASS_OUT_RETAIL
1.0000
TSF_IN_BOOK_RETAIL
1.0000
UP_CHRG_AMT_PROFIT
1.0000
INTERCOMPANY_MARGIN
1.0000
INTERCOMPANY_MARKUP
1.0000
MARKDOWN_CAN_RETAIL
1.0000
REVERSE_TAX_IN_COST
1.0000
STOCK_ADJ_COGS_COST
1.0000
TSF_OUT_BOOK_RETAIL
1.0000
WO_ACTIVITY_UPD_INV
1.0000
DEAL_COST_ADJUSTMENT
1.0000
FRANCHISE_SALES_COST
1.0000
FREIGHT_CLAIM_RETAIL
1.0000
INTERCOMPANY_IN_COST
1.0000
MARGIN_COST_VARIANCE
1.0000
PERM_MARKDOWN_RETAIL
1.0000
PROM_MARKDOWN_RETAIL
1.0000
RETAIL_COST_VARIANCE
1.0000
WO_ACTIVITY_POST_FIN
1.0000
CLEAR_MARKDOWN_RETAIL
1.0000
INTERCOMPANY_MARKDOWN
1.0000
INTERCOMPANY_OUT_COST
1.0000
REC_COST_ADJ_VARIANCE
1.0000
STOCKTAKE_ACTSTK_COST
1.0000
STOCK_ADJ_COGS_RETAIL
1.0000
FRANCHISE_RETURNS_COST
1.0000
FRANCHISE_SALES_RETAIL
1.0000
INTERCOMPANY_IN_RETAIL
1.0000
NET_SALES_NON_INV_COST
1.0000
REVERSE_TAX_OUT_RETAIL
1.0000
STOCKTAKE_BOOKSTK_COST
1.0000
WEIGHT_VARIANCE_RETAIL
1.0000
FRANCHISE_MARKUP_RETAIL
1.0000
INTERCOMPANY_OUT_RETAIL
1.0000
NET_SALES_RETAIL_EX_VAT
1.0000
STOCKTAKE_ACTSTK_RETAIL
1.0000
STOCKTAKE_MTD_SALES_AMT
1.0000
FRANCHISE_RESTOCKING_FEE
1.0000
FRANCHISE_RETURNS_RETAIL
1.0000
NET_SALES_NON_INV_RETAIL
1.0000
STOCKTAKE_BOOKSTK_RETAIL
1.0000
STOCKTAKE_MTD_SHRINK_AMT
1.0000
FRANCHISE_MARKDOWN_RETAIL
1.0000
INTER_STOCKTAKE_SALES_AMT
1.0000
INTER_STOCKTAKE_SHRINK_AMT
1.0000
NET_SALES_NON_INV_RTL_EX_VAT
1.0000

default

DEPTRPK
1003
CLASSRPK
1103
LOCATIONRPK
3
LOC_TYPERPK
W
SUBCLASSRPK
1113
VAT_IN
12.5000
HALF_NO
4
VAT_OUT
12.5000
EOM_DATE
2026-01-03
MONTH_NO
4
RTV_COST
12.5000
PURCH_COST
12.5000
RTV_RETAIL
12.5000
SALES_UNITS
12.5000
TSF_IN_COST
12.5000
CLS_STK_COST
12.5000
CURRENCY_IND
M
FREIGHT_COST
12.5000
OPN_STK_COST
12.5000
PURCH_RETAIL
12.5000
RETURNS_COST
12.5000
TSF_OUT_COST
12.5000
WORKROOM_AMT
12.5000
CASH_DISC_AMT
12.5000
HTD_GAFS_COST
12.5000
MARKUP_RETAIL
12.5000
TSF_IN_RETAIL
12.5000
CLS_STK_RETAIL
12.5000
CUM_MARKON_PCT
12.5000
NET_SALES_COST
12.5000
OPN_STK_RETAIL
12.5000
RESTOCKING_FEE
12.5000
RETURNS_RETAIL
12.5000
SHRINKAGE_COST
12.5000
STOCK_ADJ_COST
12.5000
TSF_OUT_RETAIL
12.5000
HTD_GAFS_RETAIL
12.5000
RECLASS_IN_COST
12.5000
RECOVERABLE_TAX
12.5000
SET_OF_BOOKS_ID
1000000003
UP_CHRG_AMT_EXP
12.5000
EMPL_DISC_RETAIL
12.5000
GROSS_MARGIN_AMT
12.5000
NET_SALES_RETAIL
12.5000
RECLASS_OUT_COST
12.5000
SHRINKAGE_RETAIL
12.5000
STOCK_ADJ_RETAIL
12.5000
TSF_IN_BOOK_COST
12.5000
COST_VARIANCE_AMT
12.5000
DEAL_INCOME_PURCH
12.5000
DEAL_INCOME_SALES
12.5000
MARKUP_CAN_RETAIL
12.5000
RECLASS_IN_RETAIL
12.5000
TSF_OUT_BOOK_COST
12.5000
DEAL_COST_VARIANCE
12.5000
DEAL_INCOME_ISSUES
12.5000
FREIGHT_CLAIM_COST
12.5000
RECLASS_OUT_RETAIL
12.5000
TSF_IN_BOOK_RETAIL
12.5000
UP_CHRG_AMT_PROFIT
12.5000
INTERCOMPANY_MARGIN
12.5000
INTERCOMPANY_MARKUP
12.5000
MARKDOWN_CAN_RETAIL
12.5000
REVERSE_TAX_IN_COST
12.5000
STOCK_ADJ_COGS_COST
12.5000
TSF_OUT_BOOK_RETAIL
12.5000
WO_ACTIVITY_UPD_INV
12.5000
DEAL_COST_ADJUSTMENT
12.5000
FRANCHISE_SALES_COST
12.5000
FREIGHT_CLAIM_RETAIL
12.5000
INTERCOMPANY_IN_COST
12.5000
MARGIN_COST_VARIANCE
12.5000
PERM_MARKDOWN_RETAIL
12.5000
PROM_MARKDOWN_RETAIL
12.5000
RETAIL_COST_VARIANCE
12.5000
WO_ACTIVITY_POST_FIN
12.5000
CLEAR_MARKDOWN_RETAIL
12.5000
INTERCOMPANY_MARKDOWN
12.5000
INTERCOMPANY_OUT_COST
12.5000
REC_COST_ADJ_VARIANCE
12.5000
STOCKTAKE_ACTSTK_COST
12.5000
STOCK_ADJ_COGS_RETAIL
12.5000
FRANCHISE_RETURNS_COST
12.5000
FRANCHISE_SALES_RETAIL
12.5000
INTERCOMPANY_IN_RETAIL
12.5000
NET_SALES_NON_INV_COST
12.5000
REVERSE_TAX_OUT_RETAIL
12.5000
STOCKTAKE_BOOKSTK_COST
12.5000
WEIGHT_VARIANCE_RETAIL
12.5000
FRANCHISE_MARKUP_RETAIL
12.5000
INTERCOMPANY_OUT_RETAIL
12.5000
NET_SALES_RETAIL_EX_VAT
12.5000
STOCKTAKE_ACTSTK_RETAIL
12.5000
STOCKTAKE_MTD_SALES_AMT
12.5000
FRANCHISE_RESTOCKING_FEE
12.5000
FRANCHISE_RETURNS_RETAIL
12.5000
NET_SALES_NON_INV_RETAIL
12.5000
STOCKTAKE_BOOKSTK_RETAIL
12.5000
STOCKTAKE_MTD_SHRINK_AMT
12.5000
FRANCHISE_MARKDOWN_RETAIL
12.5000
INTER_STOCKTAKE_SALES_AMT
12.5000
INTER_STOCKTAKE_SHRINK_AMT
12.5000
NET_SALES_NON_INV_RTL_EX_VAT
12.5000

default

DEPTRPK
1005
CLASSRPK
1105
LOCATIONRPK
5
LOC_TYPERPK
E
SUBCLASSRPK
1115
VAT_IN
14.0000
HALF_NO
6
VAT_OUT
14.0000
EOM_DATE
2026-01-05
MONTH_NO
6
RTV_COST
14.0000
PURCH_COST
14.0000
RTV_RETAIL
14.0000
SALES_UNITS
14.0000
TSF_IN_COST
14.0000
CLS_STK_COST
14.0000
CURRENCY_IND
M
FREIGHT_COST
14.0000
OPN_STK_COST
14.0000
PURCH_RETAIL
14.0000
RETURNS_COST
14.0000
TSF_OUT_COST
14.0000
WORKROOM_AMT
14.0000
CASH_DISC_AMT
14.0000
HTD_GAFS_COST
14.0000
MARKUP_RETAIL
14.0000
TSF_IN_RETAIL
14.0000
CLS_STK_RETAIL
14.0000
CUM_MARKON_PCT
14.0000
NET_SALES_COST
14.0000
OPN_STK_RETAIL
14.0000
RESTOCKING_FEE
14.0000
RETURNS_RETAIL
14.0000
SHRINKAGE_COST
14.0000
STOCK_ADJ_COST
14.0000
TSF_OUT_RETAIL
14.0000
HTD_GAFS_RETAIL
14.0000
RECLASS_IN_COST
14.0000
RECOVERABLE_TAX
14.0000
SET_OF_BOOKS_ID
1000000005
UP_CHRG_AMT_EXP
14.0000
EMPL_DISC_RETAIL
14.0000
GROSS_MARGIN_AMT
14.0000
NET_SALES_RETAIL
14.0000
RECLASS_OUT_COST
14.0000
SHRINKAGE_RETAIL
14.0000
STOCK_ADJ_RETAIL
14.0000
TSF_IN_BOOK_COST
14.0000
COST_VARIANCE_AMT
14.0000
DEAL_INCOME_PURCH
14.0000
DEAL_INCOME_SALES
14.0000
MARKUP_CAN_RETAIL
14.0000
RECLASS_IN_RETAIL
14.0000
TSF_OUT_BOOK_COST
14.0000
DEAL_COST_VARIANCE
14.0000
DEAL_INCOME_ISSUES
14.0000
FREIGHT_CLAIM_COST
14.0000
RECLASS_OUT_RETAIL
14.0000
TSF_IN_BOOK_RETAIL
14.0000
UP_CHRG_AMT_PROFIT
14.0000
INTERCOMPANY_MARGIN
14.0000
INTERCOMPANY_MARKUP
14.0000
MARKDOWN_CAN_RETAIL
14.0000
REVERSE_TAX_IN_COST
14.0000
STOCK_ADJ_COGS_COST
14.0000
TSF_OUT_BOOK_RETAIL
14.0000
WO_ACTIVITY_UPD_INV
14.0000
DEAL_COST_ADJUSTMENT
14.0000
FRANCHISE_SALES_COST
14.0000
FREIGHT_CLAIM_RETAIL
14.0000
INTERCOMPANY_IN_COST
14.0000
MARGIN_COST_VARIANCE
14.0000
PERM_MARKDOWN_RETAIL
14.0000
PROM_MARKDOWN_RETAIL
14.0000
RETAIL_COST_VARIANCE
14.0000
WO_ACTIVITY_POST_FIN
14.0000
CLEAR_MARKDOWN_RETAIL
14.0000
INTERCOMPANY_MARKDOWN
14.0000
INTERCOMPANY_OUT_COST
14.0000
REC_COST_ADJ_VARIANCE
14.0000
STOCKTAKE_ACTSTK_COST
14.0000
STOCK_ADJ_COGS_RETAIL
14.0000
FRANCHISE_RETURNS_COST
14.0000
FRANCHISE_SALES_RETAIL
14.0000
INTERCOMPANY_IN_RETAIL
14.0000
NET_SALES_NON_INV_COST
14.0000
REVERSE_TAX_OUT_RETAIL
14.0000
STOCKTAKE_BOOKSTK_COST
14.0000
WEIGHT_VARIANCE_RETAIL
14.0000
FRANCHISE_MARKUP_RETAIL
14.0000
INTERCOMPANY_OUT_RETAIL
14.0000
NET_SALES_RETAIL_EX_VAT
14.0000
STOCKTAKE_ACTSTK_RETAIL
14.0000
STOCKTAKE_MTD_SALES_AMT
14.0000
FRANCHISE_RESTOCKING_FEE
14.0000
FRANCHISE_RETURNS_RETAIL
14.0000
NET_SALES_NON_INV_RETAIL
14.0000
STOCKTAKE_BOOKSTK_RETAIL
14.0000
STOCKTAKE_MTD_SHRINK_AMT
14.0000
FRANCHISE_MARKDOWN_RETAIL
14.0000
INTER_STOCKTAKE_SALES_AMT
14.0000
INTER_STOCKTAKE_SHRINK_AMT
14.0000
NET_SALES_NON_INV_RTL_EX_VAT
14.0000

Rule Validation Summary

Source Rule Count
133
Governed Rule Count
126