FIF GL Publish

In Scope

Technical: FIF_GL_PUBLISH | ID: OR-FIN-FIF_GL_PUBLISH-FIF_GL_PUBLISH

Stores the Stock Ledger information for RMS and Total ID information for ReSA to be sent across to the external financial system.

See how this object fits into Finance

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
FIF_GL_PUBLISH

Field Definitions(5)

Rules & Considerations(102)

Sample Load Data(4)

Example values from field definitions

FIF_GL_SEQ_NORPK
1
APPLICATION_NAMER
SAMPLE
CREATE_ID
SAMPLE
ATTRIBUTE1
SAMPLE
ATTRIBUTE2
SAMPLE
ATTRIBUTE3
SAMPLE
ATTRIBUTE4
SAMPLE
ATTRIBUTE5
SAMPLE
ATTRIBUTE6
SAMPLE
ATTRIBUTE7
SAMPLE
ATTRIBUTE8
SAMPLE
ATTRIBUTE9
SAMPLE
REFERENCE1
SAMPLE
REFERENCE2
SAMPLE
REFERENCE3
SAMPLE
REFERENCE4
SAMPLE
REFERENCE5
SAMPLE
REFERENCE6
SAMPLE
REFERENCE7
SAMPLE
REFERENCE8
SAMPLE
REFERENCE9
SAMPLE
ACTUAL_FLAG
S
ATTRIBUTE10
SAMPLE
ATTRIBUTE11
SAMPLE
ATTRIBUTE12
SAMPLE
ATTRIBUTE13
SAMPLE
ATTRIBUTE14
SAMPLE
ATTRIBUTE15
SAMPLE
ATTRIBUTE16
SAMPLE
ATTRIBUTE17
SAMPLE
ATTRIBUTE18
SAMPLE
ATTRIBUTE19
SAMPLE
ATTRIBUTE20
SAMPLE
LEDGER_NAME
SAMPLE
REFERENCE10
SAMPLE
REFERENCE21
SAMPLE
REFERENCE22
SAMPLE
REFERENCE23
SAMPLE
REFERENCE24
SAMPLE
REFERENCE25
SAMPLE
REFERENCE26
SAMPLE
REFERENCE27
SAMPLE
REFERENCE28
SAMPLE
REFERENCE29
SAMPLE
REFERENCE30
SAMPLE
STATUS_CODE
SAM
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
ACCT_SEGMENT21
SAMPLE
ACCT_SEGMENT22
SAMPLE
ACCT_SEGMENT23
SAMPLE
ACCT_SEGMENT24
SAMPLE
ACCT_SEGMENT25
SAMPLE
ACCT_SEGMENT26
SAMPLE
ACCT_SEGMENT27
SAMPLE
ACCT_SEGMENT28
SAMPLE
ACCT_SEGMENT29
SAMPLE
ACCT_SEGMENT30
SAMPLE
LAST_UPDATE_ID
SAMPLE
ACCOUNTING_DATE
2026-01-01
CREATE_DATETIME
2026-01-01
CLEARING_COMPANY
SAMPLE
ENTERED_CR_AMOUNT
1.0000
ENTERED_DR_AMOUNT
1.0000
STATISTICAL_AMOUNT
1.0000
CONVERTED_CR_AMOUNT
1.0000
CONVERTED_DR_AMOUNT
1.0000
ENCUMBRANCE_TYPE_ID
1
USER_JE_SOURCE_NAME
SAMPLE
AVERAGE_JOURNAL_FLAG
S
LAST_UPDATE_DATETIME
2026-01-01
USER_JE_CATEGORY_NAME
SAMPLE
EXTERNAL_LEDGER_REF_ID
SAMPLE
CURRENCY_CONVERSION_DATE
2026-01-01
CURRENCY_CONVERSION_RATE
1.0000
CURRENCY_CONVERSION_TYPE
SAMPLE
RECONCILIATION_REFERENCE
SAMPLE
JOURNAL_ENTRY_CREATE_DATE
2026-01-01
CONTEXT_FIELD_CAPTURED_INFO
SAMPLE
CONTEXT_FIELD_JOURNAL_ENTRY
SAMPLE

default

FIF_GL_SEQ_NORPK
4
APPLICATION_NAMER
FIF GL Publish Secondary
CREATE_ID
C LIENT_INFO
ATTRIBUTE1
FIF GL Publish-002-ALT
ATTRIBUTE2
FIF GL Publish-002-ALT
ATTRIBUTE3
FIF GL Publish-002-ALT
ATTRIBUTE4
FIF GL Publish-002-ALT
ATTRIBUTE5
FIF GL Publish-002-ALT
ATTRIBUTE6
FIF GL Publish-002-ALT
ATTRIBUTE7
FIF GL Publish-002-ALT
ATTRIBUTE8
FIF GL Publish-002-ALT
ATTRIBUTE9
FIF GL Publish-002-ALT
REFERENCE1
FIF GL Publish-002-ALT
REFERENCE2
FIF GL Publish-002-ALT
REFERENCE3
FIF GL Publish-002-ALT
REFERENCE4
FIF GL Publish-002-ALT
REFERENCE5
FIF GL Publish-002-ALT
REFERENCE6
FIF GL Publish-002-ALT
REFERENCE7
FIF GL Publish-002-ALT
REFERENCE8
FIF GL Publish-002-ALT
REFERENCE9
FIF GL Publish-002-ALT
ACTUAL_FLAG
F
ATTRIBUTE10
FIF GL Publish-002-ALT
ATTRIBUTE11
FIF GL Publish-002-ALT
ATTRIBUTE12
FIF GL Publish-002-ALT
ATTRIBUTE13
FIF GL Publish-002-ALT
ATTRIBUTE14
FIF GL Publish-002-ALT
ATTRIBUTE15
FIF GL Publish-002-ALT
ATTRIBUTE16
FIF GL Publish-002-ALT
ATTRIBUTE17
FIF GL Publish-002-ALT
ATTRIBUTE18
FIF GL Publish-002-ALT
ATTRIBUTE19
FIF GL Publish-002-ALT
ATTRIBUTE20
FIF GL Publish-002-ALT
LEDGER_NAME
FIF GL Publish Secondary
REFERENCE10
FIF GL Publish-002-ALT
REFERENCE21
FIF GL Publish-002-ALT
REFERENCE22
FIF GL Publish-002-ALT
REFERENCE23
FIF GL Publish-002-ALT
REFERENCE24
FIF GL Publish-002-ALT
REFERENCE25
FIF GL Publish-002-ALT
REFERENCE26
FIF GL Publish-002-ALT
REFERENCE27
FIF GL Publish-002-ALT
REFERENCE28
FIF GL Publish-002-ALT
REFERENCE29
FIF GL Publish-002-ALT
REFERENCE30
FIF GL Publish-002-ALT
STATUS_CODE
ALT
ACCT_SEGMENT1
FIF GL Publish-002-ALT
ACCT_SEGMENT2
FIF GL Publish-002-ALT
ACCT_SEGMENT3
FIF GL Publish-002-ALT
ACCT_SEGMENT4
FIF GL Publish-002-ALT
ACCT_SEGMENT5
FIF GL Publish-002-ALT
ACCT_SEGMENT6
FIF GL Publish-002-ALT
ACCT_SEGMENT7
FIF GL Publish-002-ALT
ACCT_SEGMENT8
FIF GL Publish-002-ALT
ACCT_SEGMENT9
FIF GL Publish-002-ALT
CURRENCY_CODE
ALT-FIF_GL-002
FIN_GL_SEQ_ID
1000000003
ACCT_SEGMENT10
FIF GL Publish-002-ALT
ACCT_SEGMENT11
FIF GL Publish-002-ALT
ACCT_SEGMENT12
FIF GL Publish-002-ALT
ACCT_SEGMENT13
FIF GL Publish-002-ALT
ACCT_SEGMENT14
FIF GL Publish-002-ALT
ACCT_SEGMENT15
FIF GL Publish-002-ALT
ACCT_SEGMENT16
FIF GL Publish-002-ALT
ACCT_SEGMENT17
FIF GL Publish-002-ALT
ACCT_SEGMENT18
FIF GL Publish-002-ALT
ACCT_SEGMENT19
FIF GL Publish-002-ALT
ACCT_SEGMENT20
FIF GL Publish-002-ALT
ACCT_SEGMENT21
FIF GL Publish-002-ALT
ACCT_SEGMENT22
FIF GL Publish-002-ALT
ACCT_SEGMENT23
FIF GL Publish-002-ALT
ACCT_SEGMENT24
FIF GL Publish-002-ALT
ACCT_SEGMENT25
FIF GL Publish-002-ALT
ACCT_SEGMENT26
FIF GL Publish-002-ALT
ACCT_SEGMENT27
FIF GL Publish-002-ALT
ACCT_SEGMENT28
FIF GL Publish-002-ALT
ACCT_SEGMENT29
FIF GL Publish-002-ALT
ACCT_SEGMENT30
FIF GL Publish-002-ALT
LAST_UPDATE_ID
C LIENT_INFO
ACCOUNTING_DATE
2026-01-03
CREATE_DATETIME
2026-01-03
CLEARING_COMPANY
FIF GL Publish-002-ALT
ENTERED_CR_AMOUNT
12.5000
ENTERED_DR_AMOUNT
12.5000
STATISTICAL_AMOUNT
12.5000
CONVERTED_CR_AMOUNT
12.5000
CONVERTED_DR_AMOUNT
12.5000
ENCUMBRANCE_TYPE_ID
1000000003
USER_JE_SOURCE_NAME
FIF GL Publish Secondary
AVERAGE_JOURNAL_FLAG
F
LAST_UPDATE_DATETIME
2026-01-03
USER_JE_CATEGORY_NAME
FIF GL Publish Secondary
EXTERNAL_LEDGER_REF_ID
ALT-FIF_GL-002
CURRENCY_CONVERSION_DATE
2026-01-03
CURRENCY_CONVERSION_RATE
12.5000
CURRENCY_CONVERSION_TYPE
FIF GL Publish-002-ALT
RECONCILIATION_REFERENCE
FIF GL Publish-002-ALT
JOURNAL_ENTRY_CREATE_DATE
2026-01-03
CONTEXT_FIELD_CAPTURED_INFO
FIF GL Publish-002-ALT
CONTEXT_FIELD_JOURNAL_ENTRY
FIF GL Publish-002-ALT

default

FIF_GL_SEQ_NORPK
6
APPLICATION_NAMER
FIF GL Publish Core
CREATE_ID
USE RENV
ATTRIBUTE1
—
ATTRIBUTE2
—
ATTRIBUTE3
—
ATTRIBUTE4
—
ATTRIBUTE5
—
ATTRIBUTE6
—
ATTRIBUTE7
—
ATTRIBUTE8
—
ATTRIBUTE9
—
REFERENCE1
—
REFERENCE2
—
REFERENCE3
—
REFERENCE4
—
REFERENCE5
—
REFERENCE6
—
REFERENCE7
—
REFERENCE8
—
REFERENCE9
—
ACTUAL_FLAG
F
ATTRIBUTE10
—
ATTRIBUTE11
—
ATTRIBUTE12
—
ATTRIBUTE13
—
ATTRIBUTE14
—
ATTRIBUTE15
—
ATTRIBUTE16
—
ATTRIBUTE17
—
ATTRIBUTE18
—
ATTRIBUTE19
—
ATTRIBUTE20
—
LEDGER_NAME
FIF GL Publish Core
REFERENCE10
—
REFERENCE21
—
REFERENCE22
—
REFERENCE23
—
REFERENCE24
—
REFERENCE25
—
REFERENCE26
—
REFERENCE27
—
REFERENCE28
—
REFERENCE29
—
REFERENCE30
—
STATUS_CODE
EDG
ACCT_SEGMENT1
FIF GL Publish-003-EDGE
ACCT_SEGMENT2
FIF GL Publish-003-EDGE
ACCT_SEGMENT3
FIF GL Publish-003-EDGE
ACCT_SEGMENT4
FIF GL Publish-003-EDGE
ACCT_SEGMENT5
FIF GL Publish-003-EDGE
ACCT_SEGMENT6
FIF GL Publish-003-EDGE
ACCT_SEGMENT7
FIF GL Publish-003-EDGE
ACCT_SEGMENT8
FIF GL Publish-003-EDGE
ACCT_SEGMENT9
FIF GL Publish-003-EDGE
CURRENCY_CODE
EDGE-FIF_GL-003
FIN_GL_SEQ_ID
1000000005
ACCT_SEGMENT10
FIF GL Publish-003-EDGE
ACCT_SEGMENT11
FIF GL Publish-003-EDGE
ACCT_SEGMENT12
FIF GL Publish-003-EDGE
ACCT_SEGMENT13
FIF GL Publish-003-EDGE
ACCT_SEGMENT14
FIF GL Publish-003-EDGE
ACCT_SEGMENT15
FIF GL Publish-003-EDGE
ACCT_SEGMENT16
FIF GL Publish-003-EDGE
ACCT_SEGMENT17
FIF GL Publish-003-EDGE
ACCT_SEGMENT18
FIF GL Publish-003-EDGE
ACCT_SEGMENT19
FIF GL Publish-003-EDGE
ACCT_SEGMENT20
FIF GL Publish-003-EDGE
ACCT_SEGMENT21
FIF GL Publish-003-EDGE
ACCT_SEGMENT22
FIF GL Publish-003-EDGE
ACCT_SEGMENT23
FIF GL Publish-003-EDGE
ACCT_SEGMENT24
FIF GL Publish-003-EDGE
ACCT_SEGMENT25
FIF GL Publish-003-EDGE
ACCT_SEGMENT26
FIF GL Publish-003-EDGE
ACCT_SEGMENT27
FIF GL Publish-003-EDGE
ACCT_SEGMENT28
FIF GL Publish-003-EDGE
ACCT_SEGMENT29
FIF GL Publish-003-EDGE
ACCT_SEGMENT30
FIF GL Publish-003-EDGE
LAST_UPDATE_ID
USE RENV
ACCOUNTING_DATE
2026-01-05
CREATE_DATETIME
2026-01-05
CLEARING_COMPANY
FIF GL Publish-003-EDGE
ENTERED_CR_AMOUNT
14.0000
ENTERED_DR_AMOUNT
14.0000
STATISTICAL_AMOUNT
14.0000
CONVERTED_CR_AMOUNT
14.0000
CONVERTED_DR_AMOUNT
14.0000
ENCUMBRANCE_TYPE_ID
1000000005
USER_JE_SOURCE_NAME
FIF GL Publish Core
AVERAGE_JOURNAL_FLAG
F
LAST_UPDATE_DATETIME
2026-01-05
USER_JE_CATEGORY_NAME
FIF GL Publish Core
EXTERNAL_LEDGER_REF_ID
EDGE-FIF_GL-003
CURRENCY_CONVERSION_DATE
2026-01-05
CURRENCY_CONVERSION_RATE
14.0000
CURRENCY_CONVERSION_TYPE
FIF GL Publish-003-EDGE
RECONCILIATION_REFERENCE
—
JOURNAL_ENTRY_CREATE_DATE
2026-01-05
CONTEXT_FIELD_CAPTURED_INFO
FIF GL Publish-003-EDGE
CONTEXT_FIELD_JOURNAL_ENTRY
FIF GL Publish-003-EDGE

Rule Validation Summary

Source Rule Count
111
Governed Rule Count
102