RMS Oi Late Post Transactions

In Scope

Technical: RMS_OI_LATE_POST_TRANSACTIONS | ID: OR-FND-RMS_OI_LATE_POST_TRANSACTIONS-RMS_OI_LATE_POST_TRANSACTIONS

Stores the information about sof any late posted transactions that have occurred since the last month close for total company and by location for the Late posted transaction Variance Report.

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

Field Definitions(5)

Rules & Considerations(20)

Sample Load Data(4)

_scenario	LOC	DEPT	CLASS	REGION	DISTRICT	LOC_NAME	LOC_TYPE	SUBCLASS	DEPT_NAME	TRAN_TYPE	CLASS_NAME	SESSION_ID	TOTAL_COST	TRAN_COUNT	REGION_NAME	TOTAL_RETAIL	CURRENCY_CODE	DISTRICT_NAME	SUBCLASS_NAME	TRAN_TYPE_DESC
Example values from field definitions	1	1	1	1	1	SAMPLE	S	1	SAMPLE	SAMP	SAMPLE	1	1.0000	1	SAMPLE	1.0000	SAM	SAMPLE	SAMPLE	SAMPLE
default	3	1003	1103	203	303	RMS Oi Late Post Transactions Secondary	R	1113	Footwear	RMS	Womenswear	1000000003	12.5000	3	RMS Oi Late Post Transactions Secondary	12.5000	ALT	RMS Oi Late Post Transactions Secondary	Fashion Range	RMS Oi Late Post Transactions-002-ALT
default	5	1005	1105	205	305	RMS Oi Late Post Transactions Core	R	1115	Beauty	RMS	Kidswear	1000000005	14.0000	5	RMS Oi Late Post Transactions Core	14.0000	EDG	RMS Oi Late Post Transactions Core	Value Range	RMS Oi Late Post Transactions-003-EDGE

Example values from field definitions

LOC: 1
DEPT: 1
CLASS: 1
REGION: 1
DISTRICT: 1
LOC_NAME: SAMPLE
LOC_TYPE: S
SUBCLASS: 1
DEPT_NAME: SAMPLE
TRAN_TYPE: SAMP
CLASS_NAME: SAMPLE
SESSION_ID: 1
TOTAL_COST: 1.0000
TRAN_COUNT: 1
REGION_NAME: SAMPLE
TOTAL_RETAIL: 1.0000
CURRENCY_CODE: SAM
DISTRICT_NAME: SAMPLE
SUBCLASS_NAME: SAMPLE
TRAN_TYPE_DESC: SAMPLE

default

LOC: 3
DEPT: 1003
CLASS: 1103
REGION: 203
DISTRICT: 303
LOC_NAME: RMS Oi Late Post Transactions Secondary
LOC_TYPE: R
SUBCLASS: 1113
DEPT_NAME: Footwear
TRAN_TYPE: RMS
CLASS_NAME: Womenswear
SESSION_ID: 1000000003
TOTAL_COST: 12.5000
TRAN_COUNT: 3
REGION_NAME: RMS Oi Late Post Transactions Secondary
TOTAL_RETAIL: 12.5000
CURRENCY_CODE: ALT
DISTRICT_NAME: RMS Oi Late Post Transactions Secondary
SUBCLASS_NAME: Fashion Range
TRAN_TYPE_DESC: RMS Oi Late Post Transactions-002-ALT

default

LOC: 5
DEPT: 1005
CLASS: 1105
REGION: 205
DISTRICT: 305
LOC_NAME: RMS Oi Late Post Transactions Core
LOC_TYPE: R
SUBCLASS: 1115
DEPT_NAME: Beauty
TRAN_TYPE: RMS
CLASS_NAME: Kidswear
SESSION_ID: 1000000005
TOTAL_COST: 14.0000
TRAN_COUNT: 5
REGION_NAME: RMS Oi Late Post Transactions Core
TOTAL_RETAIL: 14.0000
CURRENCY_CODE: EDG
DISTRICT_NAME: RMS Oi Late Post Transactions Core
SUBCLASS_NAME: Value Range
TRAN_TYPE_DESC: RMS Oi Late Post Transactions-003-EDGE

Rule Validation Summary

Source Rule Count: 23
Governed Rule Count: 20

All objects