Stg FIF GL Data

In Scope

Technical: STG_FIF_GL_DATA | ID: OR-INV-STG_FIF_GL_DATA-STG_FIF_GL_DATA

This table will hold all the Stock Ledger information for RMS and Total ID information for ReSA to be sent across to Financial General Ledger.

See how this object fits into Inventory Management

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

Field Definitions(5)

Rules & Considerations(58)

Sample Load Data(4)

_scenario	ID	STATUS	PGM_NAME	ATTRIBUTE1	ATTRIBUTE2	ATTRIBUTE3	ATTRIBUTE4	ATTRIBUTE5	ATTRIBUTE6	CREATED_BY	REFERENCE1	REFERENCE2	REFERENCE3	REFERENCE4	REFERENCE5	REFERENCE6	REFERENCE7	REFERENCE8	REFERENCE9	ACTUAL_FLAG	PERIOD_NAME	REFERENCE10	DATE_CREATED	ACCT_SEGMENT1	ACCT_SEGMENT2	ACCT_SEGMENT3	ACCT_SEGMENT4	ACCT_SEGMENT5	ACCT_SEGMENT6	ACCT_SEGMENT7	ACCT_SEGMENT8	ACCT_SEGMENT9	CURRENCY_CODE	FIN_GL_SEQ_ID	ACCT_SEGMENT10	ACCT_SEGMENT11	ACCT_SEGMENT12	ACCT_SEGMENT13	ACCT_SEGMENT14	ACCT_SEGMENT15	ACCT_SEGMENT16	ACCT_SEGMENT17	ACCT_SEGMENT18	ACCT_SEGMENT19	ACCT_SEGMENT20	PROCESSED_FLAG	ACCOUNTING_DATE	SET_OF_BOOKS_ID	TRANSACTION_DATE	ENTERED_CR_AMOUNT	ENTERED_DR_AMOUNT	PRIM_CURRENCY_CODE	REFERENCE_TRACE_ID	CODE_COMBINATION_ID	USER_JE_SOURCE_NAME	USER_JE_CATEGORY_NAME	PRIM_ENTERED_CR_AMOUNT	PRIM_ENTERED_DR_AMOUNT	CURRENCY_CONVERSION_DATE	CURRENCY_CONVERSION_TYPE
Example values from field definitions	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	SAMPLE	SAMPLE	2026-01-01	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	S	2026-01-01	1	2026-01-01	1.0000	1.0000	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	1.0000	1.0000	2026-01-01	SAMPLE
default	3	PENDING-ALT	Stg FIF GL Data Secondary	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	3	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	S	Stg FIF GL Data	Stg FIF GL Data-002-ALT	2026-01-03	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	ALT-STG_FIF-002	1000000003	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	Stg FIF GL Data-002-ALT	S	2026-01-03	1000000003	2026-01-03	12.5000	12.5000	ALT-STG_FIF-002	ALT-STG_FIF-002	1000000003	Stg FIF GL Data Secondary	Stg FIF GL Data Secondary	12.5000	12.5000	2026-01-03	Stg FIF GL Data-002-ALT
default	5	ACTIVE-EDGE	Stg FIF GL Data Core	—	—	—	—	—	—	5	—	—	—	—	—	—	—	—	—	S	Stg FIF GL Data	—	2026-01-05	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	EDGE-STG_FIF-00	1000000005	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	Stg FIF GL Data-003-EDGE	S	2026-01-05	1000000005	2026-01-05	14.0000	14.0000	EDGE-STG_FIF-00	—	1000000005	Stg FIF GL Data Core	Stg FIF GL Data Core	14.0000	14.0000	2026-01-05	Stg FIF GL Data-003-EDGE

Example values from field definitions

ID: 1
STATUS: SAMPLE
PGM_NAME: SAMPLE
ATTRIBUTE1: SAMPLE
ATTRIBUTE2: SAMPLE
ATTRIBUTE3: SAMPLE
ATTRIBUTE4: SAMPLE
ATTRIBUTE5: SAMPLE
ATTRIBUTE6: SAMPLE
CREATED_BY: 1
REFERENCE1: SAMPLE
REFERENCE2: SAMPLE
REFERENCE3: SAMPLE
REFERENCE4: SAMPLE
REFERENCE5: SAMPLE
REFERENCE6: SAMPLE
REFERENCE7: SAMPLE
REFERENCE8: SAMPLE
REFERENCE9: SAMPLE
ACTUAL_FLAG: S
PERIOD_NAME: SAMPLE
REFERENCE10: SAMPLE
DATE_CREATED: 2026-01-01
ACCT_SEGMENT1: SAMPLE
ACCT_SEGMENT2: SAMPLE
ACCT_SEGMENT3: SAMPLE
ACCT_SEGMENT4: SAMPLE
ACCT_SEGMENT5: SAMPLE
ACCT_SEGMENT6: SAMPLE
ACCT_SEGMENT7: SAMPLE
ACCT_SEGMENT8: SAMPLE
ACCT_SEGMENT9: SAMPLE
CURRENCY_CODE: SAMPLE
FIN_GL_SEQ_ID: 1
ACCT_SEGMENT10: SAMPLE
ACCT_SEGMENT11: SAMPLE
ACCT_SEGMENT12: SAMPLE
ACCT_SEGMENT13: SAMPLE
ACCT_SEGMENT14: SAMPLE
ACCT_SEGMENT15: SAMPLE
ACCT_SEGMENT16: SAMPLE
ACCT_SEGMENT17: SAMPLE
ACCT_SEGMENT18: SAMPLE
ACCT_SEGMENT19: SAMPLE
ACCT_SEGMENT20: SAMPLE
PROCESSED_FLAG: S
ACCOUNTING_DATE: 2026-01-01
SET_OF_BOOKS_ID: 1
TRANSACTION_DATE: 2026-01-01
ENTERED_CR_AMOUNT: 1.0000
ENTERED_DR_AMOUNT: 1.0000
PRIM_CURRENCY_CODE: SAMPLE
REFERENCE_TRACE_ID: SAMPLE
CODE_COMBINATION_ID: 1
USER_JE_SOURCE_NAME: SAMPLE
USER_JE_CATEGORY_NAME: SAMPLE
PRIM_ENTERED_CR_AMOUNT: 1.0000
PRIM_ENTERED_DR_AMOUNT: 1.0000
CURRENCY_CONVERSION_DATE: 2026-01-01
CURRENCY_CONVERSION_TYPE: SAMPLE

default

ID: 3
STATUS: PENDING-ALT
PGM_NAME: Stg FIF GL Data Secondary
ATTRIBUTE1: Stg FIF GL Data-002-ALT
ATTRIBUTE2: Stg FIF GL Data-002-ALT
ATTRIBUTE3: Stg FIF GL Data-002-ALT
ATTRIBUTE4: Stg FIF GL Data-002-ALT
ATTRIBUTE5: Stg FIF GL Data-002-ALT
ATTRIBUTE6: Stg FIF GL Data-002-ALT
CREATED_BY: 3
REFERENCE1: Stg FIF GL Data-002-ALT
REFERENCE2: Stg FIF GL Data-002-ALT
REFERENCE3: Stg FIF GL Data-002-
REFERENCE4: Stg FIF GL Data-002-ALT
REFERENCE5: Stg FIF GL Data-002-
REFERENCE6: Stg FIF GL Data-002-ALT
REFERENCE7: Stg FIF GL Data-002-ALT
REFERENCE8: Stg FIF GL Data-002-ALT
REFERENCE9: Stg FIF GL Data-002-ALT
ACTUAL_FLAG: S
PERIOD_NAME: Stg FIF GL Data
REFERENCE10: Stg FIF GL Data-002-ALT
DATE_CREATED: 2026-01-03
ACCT_SEGMENT1: Stg FIF GL Data-002-ALT
ACCT_SEGMENT2: Stg FIF GL Data-002-ALT
ACCT_SEGMENT3: Stg FIF GL Data-002-ALT
ACCT_SEGMENT4: Stg FIF GL Data-002-ALT
ACCT_SEGMENT5: Stg FIF GL Data-002-ALT
ACCT_SEGMENT6: Stg FIF GL Data-002-ALT
ACCT_SEGMENT7: Stg FIF GL Data-002-ALT
ACCT_SEGMENT8: Stg FIF GL Data-002-ALT
ACCT_SEGMENT9: Stg FIF GL Data-002-ALT
CURRENCY_CODE: ALT-STG_FIF-002
FIN_GL_SEQ_ID: 1000000003
ACCT_SEGMENT10: Stg FIF GL Data-002-ALT
ACCT_SEGMENT11: Stg FIF GL Data-002-ALT
ACCT_SEGMENT12: Stg FIF GL Data-002-ALT
ACCT_SEGMENT13: Stg FIF GL Data-002-ALT
ACCT_SEGMENT14: Stg FIF GL Data-002-ALT
ACCT_SEGMENT15: Stg FIF GL Data-002-ALT
ACCT_SEGMENT16: Stg FIF GL Data-002-ALT
ACCT_SEGMENT17: Stg FIF GL Data-002-ALT
ACCT_SEGMENT18: Stg FIF GL Data-002-ALT
ACCT_SEGMENT19: Stg FIF GL Data-002-ALT
ACCT_SEGMENT20: Stg FIF GL Data-002-ALT
PROCESSED_FLAG: S
ACCOUNTING_DATE: 2026-01-03
SET_OF_BOOKS_ID: 1000000003
TRANSACTION_DATE: 2026-01-03
ENTERED_CR_AMOUNT: 12.5000
ENTERED_DR_AMOUNT: 12.5000
PRIM_CURRENCY_CODE: ALT-STG_FIF-002
REFERENCE_TRACE_ID: ALT-STG_FIF-002
CODE_COMBINATION_ID: 1000000003
USER_JE_SOURCE_NAME: Stg FIF GL Data Secondary
USER_JE_CATEGORY_NAME: Stg FIF GL Data Secondary
PRIM_ENTERED_CR_AMOUNT: 12.5000
PRIM_ENTERED_DR_AMOUNT: 12.5000
CURRENCY_CONVERSION_DATE: 2026-01-03
CURRENCY_CONVERSION_TYPE: Stg FIF GL Data-002-ALT

default

ID: 5
STATUS: ACTIVE-EDGE
PGM_NAME: Stg FIF GL Data Core
ATTRIBUTE1: —
ATTRIBUTE2: —
ATTRIBUTE3: —
ATTRIBUTE4: —
ATTRIBUTE5: —
ATTRIBUTE6: —
CREATED_BY: 5
REFERENCE1: —
REFERENCE2: —
REFERENCE3: —
REFERENCE4: —
REFERENCE5: —
REFERENCE6: —
REFERENCE7: —
REFERENCE8: —
REFERENCE9: —
ACTUAL_FLAG: S
PERIOD_NAME: Stg FIF GL Data
REFERENCE10: —
DATE_CREATED: 2026-01-05
ACCT_SEGMENT1: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT2: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT3: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT4: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT5: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT6: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT7: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT8: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT9: Stg FIF GL Data-003-EDGE
CURRENCY_CODE: EDGE-STG_FIF-00
FIN_GL_SEQ_ID: 1000000005
ACCT_SEGMENT10: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT11: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT12: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT13: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT14: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT15: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT16: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT17: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT18: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT19: Stg FIF GL Data-003-EDGE
ACCT_SEGMENT20: Stg FIF GL Data-003-EDGE
PROCESSED_FLAG: S
ACCOUNTING_DATE: 2026-01-05
SET_OF_BOOKS_ID: 1000000005
TRANSACTION_DATE: 2026-01-05
ENTERED_CR_AMOUNT: 14.0000
ENTERED_DR_AMOUNT: 14.0000
PRIM_CURRENCY_CODE: EDGE-STG_FIF-00
REFERENCE_TRACE_ID: —
CODE_COMBINATION_ID: 1000000005
USER_JE_SOURCE_NAME: Stg FIF GL Data Core
USER_JE_CATEGORY_NAME: Stg FIF GL Data Core
PRIM_ENTERED_CR_AMOUNT: 14.0000
PRIM_ENTERED_DR_AMOUNT: 14.0000
CURRENCY_CONVERSION_DATE: 2026-01-05
CURRENCY_CONVERSION_TYPE: Stg FIF GL Data-003-EDGE

Rule Validation Summary

Source Rule Count: 64
Governed Rule Count: 58

All objects