FIF GL Setup

In Scope

Technical: FIF_GL_SETUP | ID: OR-FIN-FIF_GL_SETUP-FIF_GL_SETUP

This table is used to hold all the intial set-up information pertaining to Financial Application.

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_SETUP

Field Definitions(5)

Rules & Considerations(86)

validation

constraint

Sample Load Data(4)

Example values from field definitions

LAST_UPDATE_IDR
1
SET_OF_BOOKS_IDRPK
1
CREATE_ID
SAMPLE
CATEGORY_ID
1
PERIOD_NAME
SAMPLE
SOURCE_NAME
SAMPLE
CATEGORY_NAME
SAMPLE
CURRENCY_CODE
SAM
SEQUENCE1_DESC
SAMPLE
SEQUENCE2_DESC
SAMPLE
SEQUENCE3_DESC
SAMPLE
SEQUENCE4_DESC
SAMPLE
SEQUENCE5_DESC
SAMPLE
SEQUENCE6_DESC
SAMPLE
SEQUENCE7_DESC
SAMPLE
SEQUENCE8_DESC
SAMPLE
SEQUENCE9_DESC
SAMPLE
CREATE_DATETIME
2026-01-01
EXTERNAL_REF_ID
SAMPLE
SEQUENCE10_DESC
SAMPLE
SEQUENCE11_DESC
SAMPLE
SEQUENCE12_DESC
SAMPLE
SEQUENCE13_DESC
SAMPLE
SEQUENCE14_DESC
SAMPLE
SEQUENCE15_DESC
SAMPLE
SEQUENCE16_DESC
SAMPLE
SEQUENCE17_DESC
SAMPLE
SEQUENCE18_DESC
SAMPLE
SEQUENCE19_DESC
SAMPLE
SEQUENCE20_DESC
SAMPLE
RESA_SOURCE_NAME
SAMPLE
SET_OF_BOOKS_DESC
SAMPLE
RESA_CATEGORY_NAME
SAMPLE
DEBIT_CLEARING_ACCOUNT
1
DELIVER_TO_LOCATION_ID
1
CREDIT_CLEARING_ACCOUNT
1
DEBIT_CLEARING_SEGMENT1
SAMPLE
DEBIT_CLEARING_SEGMENT2
SAMPLE
DEBIT_CLEARING_SEGMENT3
SAMPLE
DEBIT_CLEARING_SEGMENT4
SAMPLE
DEBIT_CLEARING_SEGMENT5
SAMPLE
DEBIT_CLEARING_SEGMENT6
SAMPLE
DEBIT_CLEARING_SEGMENT7
SAMPLE
DEBIT_CLEARING_SEGMENT8
SAMPLE
DEBIT_CLEARING_SEGMENT9
SAMPLE
CREDIT_CLEARING_SEGMENT1
SAMPLE
CREDIT_CLEARING_SEGMENT2
SAMPLE
CREDIT_CLEARING_SEGMENT3
SAMPLE
CREDIT_CLEARING_SEGMENT4
SAMPLE
CREDIT_CLEARING_SEGMENT5
SAMPLE
CREDIT_CLEARING_SEGMENT6
SAMPLE
CREDIT_CLEARING_SEGMENT7
SAMPLE
CREDIT_CLEARING_SEGMENT8
SAMPLE
CREDIT_CLEARING_SEGMENT9
SAMPLE
DEBIT_CLEARING_SEGMENT10
SAMPLE
DEBIT_CLEARING_SEGMENT11
SAMPLE
DEBIT_CLEARING_SEGMENT12
SAMPLE
DEBIT_CLEARING_SEGMENT13
SAMPLE
DEBIT_CLEARING_SEGMENT14
SAMPLE
DEBIT_CLEARING_SEGMENT15
SAMPLE
DEBIT_CLEARING_SEGMENT16
SAMPLE
DEBIT_CLEARING_SEGMENT17
SAMPLE
DEBIT_CLEARING_SEGMENT18
SAMPLE
DEBIT_CLEARING_SEGMENT19
SAMPLE
DEBIT_CLEARING_SEGMENT20
SAMPLE
CREDIT_CLEARING_SEGMENT10
SAMPLE
CREDIT_CLEARING_SEGMENT11
SAMPLE
CREDIT_CLEARING_SEGMENT12
SAMPLE
CREDIT_CLEARING_SEGMENT13
SAMPLE
CREDIT_CLEARING_SEGMENT14
SAMPLE
CREDIT_CLEARING_SEGMENT15
SAMPLE
CREDIT_CLEARING_SEGMENT16
SAMPLE
CREDIT_CLEARING_SEGMENT17
SAMPLE
CREDIT_CLEARING_SEGMENT18
SAMPLE
CREDIT_CLEARING_SEGMENT19
SAMPLE
CREDIT_CLEARING_SEGMENT20
SAMPLE
DESTINATION_ORGANIZATION_ID
1

default

LAST_UPDATE_IDR
MDM_USER
SET_OF_BOOKS_IDRPK
1000000003
CREATE_ID
C LIENT_INFO
CATEGORY_ID
1000000003
PERIOD_NAME
FIF GL Setup Se
SOURCE_NAME
Oracle Retail
CATEGORY_NAME
Oracle Retail
CURRENCY_CODE
ALT
SEQUENCE1_DESC
FIF GL Setup-002-ALT
SEQUENCE2_DESC
FIF GL Setup-002-ALT
SEQUENCE3_DESC
FIF GL Setup-002-ALT
SEQUENCE4_DESC
FIF GL Setup-002-ALT
SEQUENCE5_DESC
FIF GL Setup-002-ALT
SEQUENCE6_DESC
FIF GL Setup-002-ALT
SEQUENCE7_DESC
FIF GL Setup-002-ALT
SEQUENCE8_DESC
FIF GL Setup-002-ALT
SEQUENCE9_DESC
FIF GL Setup-002-ALT
CREATE_DATETIME
2026-01-03
EXTERNAL_REF_ID
ALT-FIF_GL-002
SEQUENCE10_DESC
FIF GL Setup-002-ALT
SEQUENCE11_DESC
FIF GL Setup-002-ALT
SEQUENCE12_DESC
FIF GL Setup-002-ALT
SEQUENCE13_DESC
FIF GL Setup-002-ALT
SEQUENCE14_DESC
FIF GL Setup-002-ALT
SEQUENCE15_DESC
FIF GL Setup-002-ALT
SEQUENCE16_DESC
FIF GL Setup-002-ALT
SEQUENCE17_DESC
FIF GL Setup-002-ALT
SEQUENCE18_DESC
FIF GL Setup-002-ALT
SEQUENCE19_DESC
FIF GL Setup-002-ALT
SEQUENCE20_DESC
FIF GL Setup-002-ALT
RESA_SOURCE_NAME
Oracle Retail
SET_OF_BOOKS_DESC
FIF GL Setup-002-ALT
RESA_CATEGORY_NAME
Oracle Retail
DEBIT_CLEARING_ACCOUNT
3
DELIVER_TO_LOCATION_ID
1000000003
CREDIT_CLEARING_ACCOUNT
3
DEBIT_CLEARING_SEGMENT1
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT2
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT3
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT4
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT5
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT6
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT7
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT8
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT9
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT1
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT2
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT3
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT4
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT5
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT6
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT7
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT8
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT9
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT10
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT11
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT12
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT13
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT14
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT15
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT16
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT17
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT18
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT19
FIF GL Setup-002-ALT
DEBIT_CLEARING_SEGMENT20
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT10
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT11
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT12
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT13
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT14
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT15
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT16
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT17
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT18
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT19
FIF GL Setup-002-ALT
CREDIT_CLEARING_SEGMENT20
FIF GL Setup-002-ALT
DESTINATION_ORGANIZATION_ID
1000000003

default

LAST_UPDATE_IDR
BATCH_USER
SET_OF_BOOKS_IDRPK
1000000005
CREATE_ID
USE RENV
CATEGORY_ID
1000000005
PERIOD_NAME
FIF GL Setup Co
SOURCE_NAME
Oracle Retail
CATEGORY_NAME
Oracle Retail
CURRENCY_CODE
EDG
SEQUENCE1_DESC
FIF GL Setup-003-EDG
SEQUENCE2_DESC
FIF GL Setup-003-EDG
SEQUENCE3_DESC
FIF GL Setup-003-EDG
SEQUENCE4_DESC
FIF GL Setup-003-EDG
SEQUENCE5_DESC
FIF GL Setup-003-EDG
SEQUENCE6_DESC
FIF GL Setup-003-EDG
SEQUENCE7_DESC
FIF GL Setup-003-EDG
SEQUENCE8_DESC
FIF GL Setup-003-EDG
SEQUENCE9_DESC
FIF GL Setup-003-EDG
CREATE_DATETIME
2026-01-05
EXTERNAL_REF_ID
EDGE-FIF_GL-003
SEQUENCE10_DESC
FIF GL Setup-003-EDG
SEQUENCE11_DESC
FIF GL Setup-003-EDG
SEQUENCE12_DESC
FIF GL Setup-003-EDG
SEQUENCE13_DESC
FIF GL Setup-003-EDG
SEQUENCE14_DESC
FIF GL Setup-003-EDG
SEQUENCE15_DESC
FIF GL Setup-003-EDG
SEQUENCE16_DESC
FIF GL Setup-003-EDG
SEQUENCE17_DESC
FIF GL Setup-003-EDG
SEQUENCE18_DESC
FIF GL Setup-003-EDG
SEQUENCE19_DESC
FIF GL Setup-003-EDG
SEQUENCE20_DESC
FIF GL Setup-003-EDG
RESA_SOURCE_NAME
Oracle Retail
SET_OF_BOOKS_DESC
FIF GL Setup-003-EDGE
RESA_CATEGORY_NAME
Oracle Retail
DEBIT_CLEARING_ACCOUNT
5
DELIVER_TO_LOCATION_ID
1000000005
CREDIT_CLEARING_ACCOUNT
5
DEBIT_CLEARING_SEGMENT1
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT2
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT3
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT4
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT5
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT6
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT7
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT8
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT9
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT1
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT2
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT3
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT4
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT5
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT6
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT7
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT8
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT9
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT10
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT11
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT12
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT13
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT14
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT15
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT16
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT17
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT18
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT19
FIF GL Setup-003-EDGE
DEBIT_CLEARING_SEGMENT20
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT10
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT11
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT12
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT13
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT14
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT15
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT16
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT17
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT18
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT19
FIF GL Setup-003-EDGE
CREDIT_CLEARING_SEGMENT20
FIF GL Setup-003-EDGE
DESTINATION_ORGANIZATION_ID
1000000005

Rule Validation Summary

Source Rule Count
102
Governed Rule Count
86