Stage Extension Transaction Data
In ScopeTechnical: STAGE_EXT_TRAN_DATA | ID: OR-FND-STAGE_EXT_TRAN_DATA-STAGE_EXTENSION_TRANSACTION_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- STAGE_EXT_TRAN_DATA
Field Definitions(5)
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | SUBCLASSR | ITEM | UNITS | STATUS | AV_COST | ERR_MSG | TRAN_ID | ADJ_CODE | LOCATION | LOC_TYPE | PGM_NAME | REF_NO_1 | REF_NO_2 | VAT_RATE | GL_REF_NO | TRAN_CODE | TRAN_DATE | SALES_TYPE | TOTAL_COST | REF_PACK_NO | TOTAL_RETAIL | WAC_RECALC_IND | NEW_UNIT_RETAIL | OLD_UNIT_RETAIL | CREATE_TIMESTAMP | TOTAL_COST_EXCL_ELC | LAST_UPDATED_TIMESTAMP |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | 1.0000 | S | 1.0000 | SAMPLE | 1 | S | 1 | S | SAMPLE | SAMPLE | SAMPLE | 1.0000000000 | SAMPLE | 1 | 2026-01-01 | S | 1.0000 | SAMPLE | 1.0000 | S | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 2026-01-01 |
| default | 1003 | 1103 | 1113 | Stage Ext Tran Data-002-A | 12.5000 | P | 12.5000 | Stage Ext Tran Data-002-ALT | 1000000003 | A | 3 | S | Stage Ext Tran Data Secondary | Stage Ext Tran Data-002-ALT | Stage Ext Tran Data-002-ALT | 12.5000000000 | Stage Ext Tran Data-002-A | 3 | 2026-01-03 | S | 12.5000 | Stage Ext Tran Data-002-A | 12.5000 | N | 12.5000 | 12.5000 | 2026-02-09 | 12.5000 | 2026-01-03 |
| default | 1005 | 1105 | 1115 | Stage Ext Tran Data-003-E | 14.0000 | A | 14.0000 | Stage Ext Tran Data-003-EDGE | 1000000005 | E | 5 | S | Stage Ext Tran Data Core | Stage Ext Tran Data-003-EDGE | Stage Ext Tran Data-003-EDGE | 14.0000000000 | Stage Ext Tran Data-003-E | 5 | 2026-01-05 | S | 14.0000 | Stage Ext Tran Data-003-E | 14.0000 | N | 14.0000 | 14.0000 | 2026-03-12 | 14.0000 | 2026-01-05 |
Example values from field definitions
- DEPTR
- 1
- CLASSR
- 1
- SUBCLASSR
- 1
- ITEM
- SAMPLE
- UNITS
- 1.0000
- STATUS
- S
- AV_COST
- 1.0000
- ERR_MSG
- SAMPLE
- TRAN_ID
- 1
- ADJ_CODE
- S
- LOCATION
- 1
- LOC_TYPE
- S
- PGM_NAME
- SAMPLE
- REF_NO_1
- SAMPLE
- REF_NO_2
- SAMPLE
- VAT_RATE
- 1.0000000000
- GL_REF_NO
- SAMPLE
- TRAN_CODE
- 1
- TRAN_DATE
- 2026-01-01
- SALES_TYPE
- S
- TOTAL_COST
- 1.0000
- REF_PACK_NO
- SAMPLE
- TOTAL_RETAIL
- 1.0000
- WAC_RECALC_IND
- S
- NEW_UNIT_RETAIL
- 1.0000
- OLD_UNIT_RETAIL
- 1.0000
- CREATE_TIMESTAMP
- 2026-01-01
- TOTAL_COST_EXCL_ELC
- 1.0000
- LAST_UPDATED_TIMESTAMP
- 2026-01-01
default
- DEPTR
- 1003
- CLASSR
- 1103
- SUBCLASSR
- 1113
- ITEM
- Stage Ext Tran Data-002-A
- UNITS
- 12.5000
- STATUS
- P
- AV_COST
- 12.5000
- ERR_MSG
- Stage Ext Tran Data-002-ALT
- TRAN_ID
- 1000000003
- ADJ_CODE
- A
- LOCATION
- 3
- LOC_TYPE
- S
- PGM_NAME
- Stage Ext Tran Data Secondary
- REF_NO_1
- Stage Ext Tran Data-002-ALT
- REF_NO_2
- Stage Ext Tran Data-002-ALT
- VAT_RATE
- 12.5000000000
- GL_REF_NO
- Stage Ext Tran Data-002-A
- TRAN_CODE
- 3
- TRAN_DATE
- 2026-01-03
- SALES_TYPE
- S
- TOTAL_COST
- 12.5000
- REF_PACK_NO
- Stage Ext Tran Data-002-A
- TOTAL_RETAIL
- 12.5000
- WAC_RECALC_IND
- N
- NEW_UNIT_RETAIL
- 12.5000
- OLD_UNIT_RETAIL
- 12.5000
- CREATE_TIMESTAMP
- 2026-02-09
- TOTAL_COST_EXCL_ELC
- 12.5000
- LAST_UPDATED_TIMESTAMP
- 2026-01-03
default
- DEPTR
- 1005
- CLASSR
- 1105
- SUBCLASSR
- 1115
- ITEM
- Stage Ext Tran Data-003-E
- UNITS
- 14.0000
- STATUS
- A
- AV_COST
- 14.0000
- ERR_MSG
- Stage Ext Tran Data-003-EDGE
- TRAN_ID
- 1000000005
- ADJ_CODE
- E
- LOCATION
- 5
- LOC_TYPE
- S
- PGM_NAME
- Stage Ext Tran Data Core
- REF_NO_1
- Stage Ext Tran Data-003-EDGE
- REF_NO_2
- Stage Ext Tran Data-003-EDGE
- VAT_RATE
- 14.0000000000
- GL_REF_NO
- Stage Ext Tran Data-003-E
- TRAN_CODE
- 5
- TRAN_DATE
- 2026-01-05
- SALES_TYPE
- S
- TOTAL_COST
- 14.0000
- REF_PACK_NO
- Stage Ext Tran Data-003-E
- TOTAL_RETAIL
- 14.0000
- WAC_RECALC_IND
- N
- NEW_UNIT_RETAIL
- 14.0000
- OLD_UNIT_RETAIL
- 14.0000
- CREATE_TIMESTAMP
- 2026-03-12
- TOTAL_COST_EXCL_ELC
- 14.0000
- LAST_UPDATED_TIMESTAMP
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 42
- Governed Rule Count
- 38