IM Bdi Financials Stage Out

In Scope

Technical: IM_BDI_FINANCIALS_STAGE_OUT | ID: OR-IM-IM_BDI_FINANCIALS_STAGE_OUT-IM_BDI_FINANCIALS_STAGE_OUT

Invoice Matching Financials BDI staging table.

See how this object fits into Invoice Matching

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

Field Definitions(5)

Sample Load Data(4)

_scenario	SEQ_NOR	BDI_SEQ_IDRPK	BDI_APP_NAMERPK	AMOUNT	DOC_ID	VENDOR	DEAL_ID	DOC_DATE	ORDER_NO	VAT_CODE	VAT_RATE	CREATE_ID	PARENT_ID	SEGMENT_1	SEGMENT_2	SEGMENT_3	SEGMENT_4	SEGMENT_5	SEGMENT_6	SEGMENT_7	SEGMENT_8	SEGMENT_9	TAX_ENTRY	TRAN_CODE	BEST_TERMS	EXT_DOC_ID	POSTING_ID	RECEIPT_ID	SEGMENT_10	SEGMENT_11	SEGMENT_12	SEGMENT_13	SEGMENT_14	SEGMENT_15	SEGMENT_16	SEGMENT_17	SEGMENT_18	SEGMENT_19	SEGMENT_20	VENDOR_TYPE	PRE_PAID_IND	RECEIPT_DATE	REFERENCE_ID	TRANS_AMOUNT	CURRENCY_CODE	EXCHANGE_RATE	LOCAL_CURRENCY	BEST_TERMS_DATE	CREATE_DATETIME	ODI_SESSION_NUM	SET_OF_BOOKS_ID	BDI_DATASET_TYPE	DEBIT_CREDIT_IND	MANUALLY_PAID_IND	PRIM_TRANS_AMOUNT	BDI_DATASET_ACTION	EXCHANGE_RATE_TYPE	PRIM_CURRENCY_CODE	TOTAL_COST_INC_VAT	INCOME_LOCAL_CURRENCY
Example values from field definitions	1	1	SAMPLE	1.0000	1	SAMPLE	1	2026-01-01	1	SAMPLE	1.0000000000	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	2026-01-01	SAMPLE	1.0000	SAM	1.0000000000	SAM	2026-01-01	2026-01-01	1	1	SAMPLE	SAMPLE	S	1.0000	SAMPLE	SAMPLE	SAM	1.0000	1.0000
default	4	1000000003	current_schema	12.5000	1000000003	IM Bdi Fin	1000000003	2026-01-03	4	ALT-IM	12.5000000000	USER	1000000003	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	I	write	IM Bdi Financia	ALT-IM_BDI-002	1000000003	1000000003	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi	I	2026-01-03	ALT-IM_BDI-002	12.5000	ALT	12.5000000000	IM	2026-01-03	2026-01-03	4	1000000003	FULL	IM Bdi	I	12.5000	REPLACE	IM Bdi Financials Stage Out-00	ALT	12.5000	12.5000
default	6	1000000005	userenv	14.0000	1000000005	IM Bdi Fin	1000000005	2026-01-05	6	EDGE-I	14.0000000000	USER	1000000005	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	I	non	IM Bdi Financia	EDGE-IM_BDI-003	1000000005	1000000005	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi Financials Stage O	IM Bdi	I	2026-01-05	—	14.0000	EDG	14.0000000000	IM	2026-01-05	2026-01-05	6	1000000005	FULL	IM Bdi	I	14.0000	REPLACE	IM Bdi Financials Stage Out-00	EDG	14.0000	14.0000

Example values from field definitions

SEQ_NOR: 1
BDI_SEQ_IDRPK: 1
BDI_APP_NAMERPK: SAMPLE
AMOUNT: 1.0000
DOC_ID: 1
VENDOR: SAMPLE
DEAL_ID: 1
DOC_DATE: 2026-01-01
ORDER_NO: 1
VAT_CODE: SAMPLE
VAT_RATE: 1.0000000000
CREATE_ID: SAMPLE
PARENT_ID: 1
SEGMENT_1: SAMPLE
SEGMENT_2: SAMPLE
SEGMENT_3: SAMPLE
SEGMENT_4: SAMPLE
SEGMENT_5: SAMPLE
SEGMENT_6: SAMPLE
SEGMENT_7: SAMPLE
SEGMENT_8: SAMPLE
SEGMENT_9: SAMPLE
TAX_ENTRY: S
TRAN_CODE: SAMPLE
BEST_TERMS: SAMPLE
EXT_DOC_ID: SAMPLE
POSTING_ID: 1
RECEIPT_ID: 1
SEGMENT_10: SAMPLE
SEGMENT_11: SAMPLE
SEGMENT_12: SAMPLE
SEGMENT_13: SAMPLE
SEGMENT_14: SAMPLE
SEGMENT_15: SAMPLE
SEGMENT_16: SAMPLE
SEGMENT_17: SAMPLE
SEGMENT_18: SAMPLE
SEGMENT_19: SAMPLE
SEGMENT_20: SAMPLE
VENDOR_TYPE: SAMPLE
PRE_PAID_IND: S
RECEIPT_DATE: 2026-01-01
REFERENCE_ID: SAMPLE
TRANS_AMOUNT: 1.0000
CURRENCY_CODE: SAM
EXCHANGE_RATE: 1.0000000000
LOCAL_CURRENCY: SAM
BEST_TERMS_DATE: 2026-01-01
CREATE_DATETIME: 2026-01-01
ODI_SESSION_NUM: 1
SET_OF_BOOKS_ID: 1
BDI_DATASET_TYPE: SAMPLE
DEBIT_CREDIT_IND: SAMPLE
MANUALLY_PAID_IND: S
PRIM_TRANS_AMOUNT: 1.0000
BDI_DATASET_ACTION: SAMPLE
EXCHANGE_RATE_TYPE: SAMPLE
PRIM_CURRENCY_CODE: SAM
TOTAL_COST_INC_VAT: 1.0000
INCOME_LOCAL_CURRENCY: 1.0000

default

SEQ_NOR: 4
BDI_SEQ_IDRPK: 1000000003
BDI_APP_NAMERPK: current_schema
AMOUNT: 12.5000
DOC_ID: 1000000003
VENDOR: IM Bdi Fin
DEAL_ID: 1000000003
DOC_DATE: 2026-01-03
ORDER_NO: 4
VAT_CODE: ALT-IM
VAT_RATE: 12.5000000000
CREATE_ID: USER
PARENT_ID: 1000000003
SEGMENT_1: IM Bdi Financials Stage O
SEGMENT_2: IM Bdi Financials Stage O
SEGMENT_3: IM Bdi Financials Stage O
SEGMENT_4: IM Bdi Financials Stage O
SEGMENT_5: IM Bdi Financials Stage O
SEGMENT_6: IM Bdi Financials Stage O
SEGMENT_7: IM Bdi Financials Stage O
SEGMENT_8: IM Bdi Financials Stage O
SEGMENT_9: IM Bdi Financials Stage O
TAX_ENTRY: I
TRAN_CODE: write
BEST_TERMS: IM Bdi Financia
EXT_DOC_ID: ALT-IM_BDI-002
POSTING_ID: 1000000003
RECEIPT_ID: 1000000003
SEGMENT_10: IM Bdi Financials Stage O
SEGMENT_11: IM Bdi Financials Stage O
SEGMENT_12: IM Bdi Financials Stage O
SEGMENT_13: IM Bdi Financials Stage O
SEGMENT_14: IM Bdi Financials Stage O
SEGMENT_15: IM Bdi Financials Stage O
SEGMENT_16: IM Bdi Financials Stage O
SEGMENT_17: IM Bdi Financials Stage O
SEGMENT_18: IM Bdi Financials Stage O
SEGMENT_19: IM Bdi Financials Stage O
SEGMENT_20: IM Bdi Financials Stage O
VENDOR_TYPE: IM Bdi
PRE_PAID_IND: I
RECEIPT_DATE: 2026-01-03
REFERENCE_ID: ALT-IM_BDI-002
TRANS_AMOUNT: 12.5000
CURRENCY_CODE: ALT
EXCHANGE_RATE: 12.5000000000
LOCAL_CURRENCY: IM
BEST_TERMS_DATE: 2026-01-03
CREATE_DATETIME: 2026-01-03
ODI_SESSION_NUM: 4
SET_OF_BOOKS_ID: 1000000003
BDI_DATASET_TYPE: FULL
DEBIT_CREDIT_IND: IM Bdi
MANUALLY_PAID_IND: I
PRIM_TRANS_AMOUNT: 12.5000
BDI_DATASET_ACTION: REPLACE
EXCHANGE_RATE_TYPE: IM Bdi Financials Stage Out-00
PRIM_CURRENCY_CODE: ALT
TOTAL_COST_INC_VAT: 12.5000
INCOME_LOCAL_CURRENCY: 12.5000

default

SEQ_NOR: 6
BDI_SEQ_IDRPK: 1000000005
BDI_APP_NAMERPK: userenv
AMOUNT: 14.0000
DOC_ID: 1000000005
VENDOR: IM Bdi Fin
DEAL_ID: 1000000005
DOC_DATE: 2026-01-05
ORDER_NO: 6
VAT_CODE: EDGE-I
VAT_RATE: 14.0000000000
CREATE_ID: USER
PARENT_ID: 1000000005
SEGMENT_1: IM Bdi Financials Stage O
SEGMENT_2: IM Bdi Financials Stage O
SEGMENT_3: IM Bdi Financials Stage O
SEGMENT_4: IM Bdi Financials Stage O
SEGMENT_5: IM Bdi Financials Stage O
SEGMENT_6: IM Bdi Financials Stage O
SEGMENT_7: IM Bdi Financials Stage O
SEGMENT_8: IM Bdi Financials Stage O
SEGMENT_9: IM Bdi Financials Stage O
TAX_ENTRY: I
TRAN_CODE: non
BEST_TERMS: IM Bdi Financia
EXT_DOC_ID: EDGE-IM_BDI-003
POSTING_ID: 1000000005
RECEIPT_ID: 1000000005
SEGMENT_10: IM Bdi Financials Stage O
SEGMENT_11: IM Bdi Financials Stage O
SEGMENT_12: IM Bdi Financials Stage O
SEGMENT_13: IM Bdi Financials Stage O
SEGMENT_14: IM Bdi Financials Stage O
SEGMENT_15: IM Bdi Financials Stage O
SEGMENT_16: IM Bdi Financials Stage O
SEGMENT_17: IM Bdi Financials Stage O
SEGMENT_18: IM Bdi Financials Stage O
SEGMENT_19: IM Bdi Financials Stage O
SEGMENT_20: IM Bdi Financials Stage O
VENDOR_TYPE: IM Bdi
PRE_PAID_IND: I
RECEIPT_DATE: 2026-01-05
REFERENCE_ID: —
TRANS_AMOUNT: 14.0000
CURRENCY_CODE: EDG
EXCHANGE_RATE: 14.0000000000
LOCAL_CURRENCY: IM
BEST_TERMS_DATE: 2026-01-05
CREATE_DATETIME: 2026-01-05
ODI_SESSION_NUM: 6
SET_OF_BOOKS_ID: 1000000005
BDI_DATASET_TYPE: FULL
DEBIT_CREDIT_IND: IM Bdi
MANUALLY_PAID_IND: I
PRIM_TRANS_AMOUNT: 14.0000
BDI_DATASET_ACTION: REPLACE
EXCHANGE_RATE_TYPE: IM Bdi Financials Stage Out-00
PRIM_CURRENCY_CODE: EDG
TOTAL_COST_INC_VAT: 14.0000
INCOME_LOCAL_CURRENCY: 14.0000

Rule Validation Summary

Source Rule Count: 90
Governed Rule Count: 72

All objects