FIF GL Data
In ScopeTechnical: FIF_GL_DATA | ID: OR-FIN-FIF_GL_DATA-FIF_GL_DATA
This table is used for staging data from MONTH_DATA and TRAN_DATA to a General Ledger in an 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_DATA
Field Definitions(5)
Rules & Considerations(13)
Sample Load Data(4)
| _scenario | SKU | DEPT | CLASS | AMOUNT | ADJ_CODE | LOCATION | LOC_TYPE | REF_NO_1 | REF_NO_2 | SUBCLASS | TRAN_CODE | TRAN_DATE | CURRENCY_CODE | COST_RETAIL_FLAG |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1.0000 | S | 1 | S | SAMPLE | SAMPLE | 1 | 1 | 2026-01-01 | SAM | S |
| default | 3 | 1003 | 1103 | 12.5000 | A | 3 | W | FIF GL Data-002-ALT | FIF GL Data-002-ALT | 1113 | 3 | 2026-01-03 | ALT | F |
| default | 5 | 1005 | 1105 | 14.0000 | E | 5 | E | FIF GL Data-003-EDGE | FIF GL Data-003-EDGE | 1115 | 5 | 2026-01-05 | EDG | F |
Example values from field definitions
- SKU
- 1
- DEPT
- 1
- CLASS
- 1
- AMOUNT
- 1.0000
- ADJ_CODE
- S
- LOCATION
- 1
- LOC_TYPE
- S
- REF_NO_1
- SAMPLE
- REF_NO_2
- SAMPLE
- SUBCLASS
- 1
- TRAN_CODE
- 1
- TRAN_DATE
- 2026-01-01
- CURRENCY_CODE
- SAM
- COST_RETAIL_FLAG
- S
default
- SKU
- 3
- DEPT
- 1003
- CLASS
- 1103
- AMOUNT
- 12.5000
- ADJ_CODE
- A
- LOCATION
- 3
- LOC_TYPE
- W
- REF_NO_1
- FIF GL Data-002-ALT
- REF_NO_2
- FIF GL Data-002-ALT
- SUBCLASS
- 1113
- TRAN_CODE
- 3
- TRAN_DATE
- 2026-01-03
- CURRENCY_CODE
- ALT
- COST_RETAIL_FLAG
- F
default
- SKU
- 5
- DEPT
- 1005
- CLASS
- 1105
- AMOUNT
- 14.0000
- ADJ_CODE
- E
- LOCATION
- 5
- LOC_TYPE
- E
- REF_NO_1
- FIF GL Data-003-EDGE
- REF_NO_2
- FIF GL Data-003-EDGE
- SUBCLASS
- 1115
- TRAN_CODE
- 5
- TRAN_DATE
- 2026-01-05
- CURRENCY_CODE
- EDG
- COST_RETAIL_FLAG
- F
Rule Validation Summary
- Source Rule Count
- 21
- Governed Rule Count
- 13