Stage Ext Tran Data
In ScopeTechnical: STAGE_EXT_TRAN_DATA | ID: OR-MFCS-STAGE_EXT_TRAN_DATA
Stores the staged transaction data records from a flat file. The records are inserted by an external transaction data upload batch program.
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
- STAGE_EXT_TRAN_DATA
Field Definitions(29)
Rules & Considerations(16)
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | UNITSR | STATUSR | LOCATIONR | LOC_TYPER | SUBCLASSR | TRAN_CODER | TRAN_DATER | WAC_RECALC_INDR | CREATE_TIMESTAMPR | LAST_UPDATED_TIMESTAMPR | ITEM | AV_COST | ERR_MSG | TRAN_ID | ADJ_CODE | PGM_NAME | REF_NO_1 | REF_NO_2 | VAT_RATE | GL_REF_NO | SALES_TYPE | TOTAL_COST | REF_PACK_NO | TOTAL_RETAIL | NEW_UNIT_RETAIL | OLD_UNIT_RETAIL | TOTAL_COST_EXCL_ELC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | 1101 | 11.0000 | ACTIVE | 1 | Stage Ext Tran Data-001 | 1111 | 0001 | 2026-01-01 | N | 2026-01-06 | 2026-01-01 | Stage Ext Tran Data-001 | 11.0000 | Stage Ext Tran Data-001 | 1000000001 | STD-STAGE_EXT-001 | Stage Ext Tran Data Primary | Stage Ext Tran Data-001 | Stage Ext Tran Data-001 | 11.0000 | Stage Ext Tran Data-001 | Stage Ext Tran Data-001 | 11.0000 | Stage Ext Tran Data-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- DEPTR
- 1001
- CLASSR
- 1101
- UNITSR
- 11.0000
- STATUSR
- ACTIVE
- LOCATIONR
- 1
- LOC_TYPER
- Stage Ext Tran Data-001
- SUBCLASSR
- 1111
- TRAN_CODER
- 0001
- TRAN_DATER
- 2026-01-01
- WAC_RECALC_INDR
- N
- CREATE_TIMESTAMPR
- 2026-01-06
- LAST_UPDATED_TIMESTAMPR
- 2026-01-01
- ITEM
- Stage Ext Tran Data-001
- AV_COST
- 11.0000
- ERR_MSG
- Stage Ext Tran Data-001
- TRAN_ID
- 1000000001
- ADJ_CODE
- STD-STAGE_EXT-001
- PGM_NAME
- Stage Ext Tran Data Primary
- REF_NO_1
- Stage Ext Tran Data-001
- REF_NO_2
- Stage Ext Tran Data-001
- VAT_RATE
- 11.0000
- GL_REF_NO
- Stage Ext Tran Data-001
- SALES_TYPE
- Stage Ext Tran Data-001
- TOTAL_COST
- 11.0000
- REF_PACK_NO
- Stage Ext Tran Data-001
- TOTAL_RETAIL
- 11.0000
- NEW_UNIT_RETAIL
- 11.0000
- OLD_UNIT_RETAIL
- 11.0000
- TOTAL_COST_EXCL_ELC
- 11.0000