Dc FIF GL Setup
In ScopeTechnical: DC_FIF_GL_SETUP | ID: OR-CST-DC_FIF_GL_SETUP-DC_FIF_GL_SETUP
This table is a staging table for data conversion and will hold all the intial set-up information pertaining to Financial Application.
See how this object fits into Cost
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
- DC_FIF_GL_SETUP
Field Definitions(5)
Rules & Considerations(20)
Sample Load Data(4)
| _scenario | CATEGORY_ID | PERIOD_NAME | SOURCE_NAME | CATEGORY_NAME | CURRENCY_CODE | LAST_UPDATE_ID | SEQUENCE1_DESC | SEQUENCE2_DESC | SEQUENCE3_DESC | SEQUENCE4_DESC | SEQUENCE5_DESC | SEQUENCE6_DESC | SEQUENCE7_DESC | SEQUENCE8_DESC | SEQUENCE9_DESC | SEQUENCE10_DESC | SET_OF_BOOKS_ID | SET_OF_BOOKS_DESC | DELIVER_TO_LOCATION_ID | DESTINATION_ORGANIZATION_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | SAMPLE | SAM | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 |
| default | 1000000003 | Dc FIF GL Setup | Oracle Retail | Oracle Retail | ALT | MDM_USER | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | Dc FIF GL Setup-002- | 1000000003 | Dc FIF GL Setup-002-ALT | 1000000003 | 1000000003 |
| default | 1000000005 | Dc FIF GL Setup | Oracle Retail | Oracle Retail | EDG | BATCH_USER | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | Dc FIF GL Setup-003- | 1000000005 | Dc FIF GL Setup-003-EDGE | 1000000005 | 1000000005 |
Example values from field definitions
- CATEGORY_ID
- 1
- PERIOD_NAME
- SAMPLE
- SOURCE_NAME
- SAMPLE
- CATEGORY_NAME
- SAMPLE
- CURRENCY_CODE
- SAM
- LAST_UPDATE_ID
- 1
- 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
- SEQUENCE10_DESC
- SAMPLE
- SET_OF_BOOKS_ID
- 1
- SET_OF_BOOKS_DESC
- SAMPLE
- DELIVER_TO_LOCATION_ID
- 1
- DESTINATION_ORGANIZATION_ID
- 1
default
- CATEGORY_ID
- 1000000003
- PERIOD_NAME
- Dc FIF GL Setup
- SOURCE_NAME
- Oracle Retail
- CATEGORY_NAME
- Oracle Retail
- CURRENCY_CODE
- ALT
- LAST_UPDATE_ID
- MDM_USER
- SEQUENCE1_DESC
- Dc FIF GL Setup-002-
- SEQUENCE2_DESC
- Dc FIF GL Setup-002-
- SEQUENCE3_DESC
- Dc FIF GL Setup-002-
- SEQUENCE4_DESC
- Dc FIF GL Setup-002-
- SEQUENCE5_DESC
- Dc FIF GL Setup-002-
- SEQUENCE6_DESC
- Dc FIF GL Setup-002-
- SEQUENCE7_DESC
- Dc FIF GL Setup-002-
- SEQUENCE8_DESC
- Dc FIF GL Setup-002-
- SEQUENCE9_DESC
- Dc FIF GL Setup-002-
- SEQUENCE10_DESC
- Dc FIF GL Setup-002-
- SET_OF_BOOKS_ID
- 1000000003
- SET_OF_BOOKS_DESC
- Dc FIF GL Setup-002-ALT
- DELIVER_TO_LOCATION_ID
- 1000000003
- DESTINATION_ORGANIZATION_ID
- 1000000003
default
- CATEGORY_ID
- 1000000005
- PERIOD_NAME
- Dc FIF GL Setup
- SOURCE_NAME
- Oracle Retail
- CATEGORY_NAME
- Oracle Retail
- CURRENCY_CODE
- EDG
- LAST_UPDATE_ID
- BATCH_USER
- SEQUENCE1_DESC
- Dc FIF GL Setup-003-
- SEQUENCE2_DESC
- Dc FIF GL Setup-003-
- SEQUENCE3_DESC
- Dc FIF GL Setup-003-
- SEQUENCE4_DESC
- Dc FIF GL Setup-003-
- SEQUENCE5_DESC
- Dc FIF GL Setup-003-
- SEQUENCE6_DESC
- Dc FIF GL Setup-003-
- SEQUENCE7_DESC
- Dc FIF GL Setup-003-
- SEQUENCE8_DESC
- Dc FIF GL Setup-003-
- SEQUENCE9_DESC
- Dc FIF GL Setup-003-
- SEQUENCE10_DESC
- Dc FIF GL Setup-003-
- SET_OF_BOOKS_ID
- 1000000005
- SET_OF_BOOKS_DESC
- Dc FIF GL Setup-003-EDGE
- DELIVER_TO_LOCATION_ID
- 1000000005
- DESTINATION_ORGANIZATION_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 20