Stg FIF GL Data

In Scope

Technical: STG_FIF_GL_DATA | ID: OR-MFCS-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

Target Structure

Load Approach
Table
Target Objects
STG_FIF_GL_DATA

Field Definitions(60)

Rules & Considerations(125)

Sample Load Data(4)

default

IDRPK
1
STATUS
ACTIVE
PGM_NAME
Stg FIF GL Data Primary
ATTRIBUTE1
Stg FIF GL Data-001
ATTRIBUTE2
Stg FIF GL Data-001
ATTRIBUTE3
Stg FIF GL Data-001
ATTRIBUTE4
Stg FIF GL Data-001
ATTRIBUTE5
Stg FIF GL Data-001
ATTRIBUTE6
Stg FIF GL Data-001
CREATED_BY
1
REFERENCE1
Stg FIF GL Data-001
REFERENCE2
Stg FIF GL Data-001
REFERENCE3
Stg FIF GL Data-001
REFERENCE4
Stg FIF GL Data-001
REFERENCE5
Stg FIF GL Data-001
REFERENCE6
Stg FIF GL Data-001
REFERENCE7
Stg FIF GL Data-001
REFERENCE8
Stg FIF GL Data-001
REFERENCE9
Stg FIF GL Data-001
ACTUAL_FLAG
Stg FIF GL Data-001
PERIOD_NAME
Stg FIF GL Data Primary
REFERENCE10
Stg FIF GL Data-001
DATE_CREATED
2026-01-01
ACCT_SEGMENT1
Stg FIF GL Data-001
ACCT_SEGMENT2
Stg FIF GL Data-001
ACCT_SEGMENT3
Stg FIF GL Data-001
ACCT_SEGMENT4
Stg FIF GL Data-001
ACCT_SEGMENT5
Stg FIF GL Data-001
ACCT_SEGMENT6
Stg FIF GL Data-001
ACCT_SEGMENT7
Stg FIF GL Data-001
ACCT_SEGMENT8
Stg FIF GL Data-001
ACCT_SEGMENT9
Stg FIF GL Data-001
CURRENCY_CODE
STD-STG_FIF-001
FIN_GL_SEQ_ID
1000000001
ACCT_SEGMENT10
Stg FIF GL Data-001
ACCT_SEGMENT11
Stg FIF GL Data-001
ACCT_SEGMENT12
Stg FIF GL Data-001
ACCT_SEGMENT13
Stg FIF GL Data-001
ACCT_SEGMENT14
Stg FIF GL Data-001
ACCT_SEGMENT15
Stg FIF GL Data-001
ACCT_SEGMENT16
Stg FIF GL Data-001
ACCT_SEGMENT17
Stg FIF GL Data-001
ACCT_SEGMENT18
Stg FIF GL Data-001
ACCT_SEGMENT19
Stg FIF GL Data-001
ACCT_SEGMENT20
Stg FIF GL Data-001
PROCESSED_FLAG
Stg FIF GL Data-001
ACCOUNTING_DATE
2026-01-01
SET_OF_BOOKS_ID
1000000001
TRANSACTION_DATE
2026-01-01
ENTERED_CR_AMOUNT
11.0000
ENTERED_DR_AMOUNT
11.0000
PRIM_CURRENCY_CODE
STD-STG_FIF-001
REFERENCE_TRACE_ID
STD-STG_FIF-001
CODE_COMBINATION_ID
1000000001
USER_JE_SOURCE_NAME
Stg FIF GL Data Primary
USER_JE_CATEGORY_NAME
Stg FIF GL Data Primary
PRIM_ENTERED_CR_AMOUNT
11.0000
PRIM_ENTERED_DR_AMOUNT
11.0000
CURRENCY_CONVERSION_DATE
2026-01-01
CURRENCY_CONVERSION_TYPE
Stg FIF GL Data-001