RMS Oi Late Post Transactions
In ScopeTechnical: RMS_OI_LATE_POST_TRANSACTIONS | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- RMS_OI_LATE_POST_TRANSACTIONS
Field Definitions(20)
Rules & Considerations(3)
Sequencing
Reconciliation
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1001 | 1101 | 201 | 301 | RMS Oi Late Post Transactions Primary | RMS Oi Late Post Transactions-001 | 1111 | Apparel | RMS Oi Late Post Transactions-001 | Menswear | 1000000001 | 11.0000 | 1 | RMS Oi Late Post Transactions Primary | 11.0000 | STD-RMS_OI-001 | RMS Oi Late Post Transactions Primary | Core Range | RMS Oi Late Post Transactions-001 |
default
- LOC
- 1
- DEPT
- 1001
- CLASS
- 1101
- REGION
- 201
- DISTRICT
- 301
- LOC_NAME
- RMS Oi Late Post Transactions Primary
- LOC_TYPE
- RMS Oi Late Post Transactions-001
- SUBCLASS
- 1111
- DEPT_NAME
- Apparel
- TRAN_TYPE
- RMS Oi Late Post Transactions-001
- CLASS_NAME
- Menswear
- SESSION_ID
- 1000000001
- TOTAL_COST
- 11.0000
- TRAN_COUNT
- 1
- REGION_NAME
- RMS Oi Late Post Transactions Primary
- TOTAL_RETAIL
- 11.0000
- CURRENCY_CODE
- STD-RMS_OI-001
- DISTRICT_NAME
- RMS Oi Late Post Transactions Primary
- SUBCLASS_NAME
- Core Range
- TRAN_TYPE_DESC
- RMS Oi Late Post Transactions-001