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(60)

Rules & Considerations(58)

Sample Load Data(4)

_scenario	IDRPK	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

Example values from field definitions

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

Rule Validation Summary

Source Rule Count: 64
Governed Rule Count: 58

All objects