Stg FIF GL Data
In ScopeTechnical: 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)
| _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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | ACTIVE | Stg FIF GL Data Primary | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | 1 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data Primary | Stg FIF GL Data-001 | 2026-01-01 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | STD-STG_FIF-001 | 1000000001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | Stg FIF GL Data-001 | 2026-01-01 | 1000000001 | 2026-01-01 | 11.0000 | 11.0000 | STD-STG_FIF-001 | STD-STG_FIF-001 | 1000000001 | Stg FIF GL Data Primary | Stg FIF GL Data Primary | 11.0000 | 11.0000 | 2026-01-01 | Stg FIF GL Data-001 |
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
