FIF GL Cross Ref
In ScopeTechnical: FIF_GL_CROSS_REF | ID: OR-MFCS-FIF_GL_CROSS_REF
Will be populated by the form glcrossr.fmt. It maps Oracle Retail mapping fields (dept, class, subclass, location, tran_code, and cost/retail flag) to Oracle sequence numbers and CCIDs.
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
Target Structure
- Load Approach
- Table
- Target Objects
- FIF_GL_CROSS_REF
Field Definitions(56)
Rules & Considerations(20)
Sample Load Data(4)
| _scenario | LINE_TYPER | TRAN_CODER | SET_OF_BOOKS_IDRPK | COST_RETAIL_FLAGR | FIF_GL_CROSS_REF_IDRPK | DEPT | CLASS | CR_CCID | DR_CCID | BASE_IND | GROUP_ID | LOCATION | PRIORITY | SUBCLASS | UPDATE_IND | TRAN_REF_NO | CR_SEQUENCE1 | CR_SEQUENCE2 | CR_SEQUENCE3 | CR_SEQUENCE4 | CR_SEQUENCE5 | CR_SEQUENCE6 | CR_SEQUENCE7 | CR_SEQUENCE8 | CR_SEQUENCE9 | DR_SEQUENCE1 | DR_SEQUENCE2 | DR_SEQUENCE3 | DR_SEQUENCE4 | DR_SEQUENCE5 | DR_SEQUENCE6 | DR_SEQUENCE7 | DR_SEQUENCE8 | DR_SEQUENCE9 | CR_SEQUENCE10 | CR_SEQUENCE11 | CR_SEQUENCE12 | CR_SEQUENCE13 | CR_SEQUENCE14 | CR_SEQUENCE15 | CR_SEQUENCE16 | CR_SEQUENCE17 | CR_SEQUENCE18 | CR_SEQUENCE19 | CR_SEQUENCE20 | DR_SEQUENCE10 | DR_SEQUENCE11 | DR_SEQUENCE12 | DR_SEQUENCE13 | DR_SEQUENCE14 | DR_SEQUENCE15 | DR_SEQUENCE16 | DR_SEQUENCE17 | DR_SEQUENCE18 | DR_SEQUENCE19 | DR_SEQUENCE20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | FIF GL Cross Ref-001 | 0001 | 1000000001 | FIF GL Cross Ref-001 | 1000000001 | 1001 | 1101 | 1 | 1 | FIF GL Cross Ref-001 | 100001 | 1 | 000001 | 1111 | 2026-01-01 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 | FIF GL Cross Ref-001 |
default
- LINE_TYPER
- FIF GL Cross Ref-001
- TRAN_CODER
- 0001
- SET_OF_BOOKS_IDRPK
- 1000000001
- COST_RETAIL_FLAGR
- FIF GL Cross Ref-001
- FIF_GL_CROSS_REF_IDRPK
- 1000000001
- DEPT
- 1001
- CLASS
- 1101
- CR_CCID
- 1
- DR_CCID
- 1
- BASE_IND
- FIF GL Cross Ref-001
- GROUP_ID
- 100001
- LOCATION
- 1
- PRIORITY
- 000001
- SUBCLASS
- 1111
- UPDATE_IND
- 2026-01-01
- TRAN_REF_NO
- FIF GL Cross Ref-001
- CR_SEQUENCE1
- FIF GL Cross Ref-001
- CR_SEQUENCE2
- FIF GL Cross Ref-001
- CR_SEQUENCE3
- FIF GL Cross Ref-001
- CR_SEQUENCE4
- FIF GL Cross Ref-001
- CR_SEQUENCE5
- FIF GL Cross Ref-001
- CR_SEQUENCE6
- FIF GL Cross Ref-001
- CR_SEQUENCE7
- FIF GL Cross Ref-001
- CR_SEQUENCE8
- FIF GL Cross Ref-001
- CR_SEQUENCE9
- FIF GL Cross Ref-001
- DR_SEQUENCE1
- FIF GL Cross Ref-001
- DR_SEQUENCE2
- FIF GL Cross Ref-001
- DR_SEQUENCE3
- FIF GL Cross Ref-001
- DR_SEQUENCE4
- FIF GL Cross Ref-001
- DR_SEQUENCE5
- FIF GL Cross Ref-001
- DR_SEQUENCE6
- FIF GL Cross Ref-001
- DR_SEQUENCE7
- FIF GL Cross Ref-001
- DR_SEQUENCE8
- FIF GL Cross Ref-001
- DR_SEQUENCE9
- FIF GL Cross Ref-001
- CR_SEQUENCE10
- FIF GL Cross Ref-001
- CR_SEQUENCE11
- FIF GL Cross Ref-001
- CR_SEQUENCE12
- FIF GL Cross Ref-001
- CR_SEQUENCE13
- FIF GL Cross Ref-001
- CR_SEQUENCE14
- FIF GL Cross Ref-001
- CR_SEQUENCE15
- FIF GL Cross Ref-001
- CR_SEQUENCE16
- FIF GL Cross Ref-001
- CR_SEQUENCE17
- FIF GL Cross Ref-001
- CR_SEQUENCE18
- FIF GL Cross Ref-001
- CR_SEQUENCE19
- FIF GL Cross Ref-001
- CR_SEQUENCE20
- FIF GL Cross Ref-001
- DR_SEQUENCE10
- FIF GL Cross Ref-001
- DR_SEQUENCE11
- FIF GL Cross Ref-001
- DR_SEQUENCE12
- FIF GL Cross Ref-001
- DR_SEQUENCE13
- FIF GL Cross Ref-001
- DR_SEQUENCE14
- FIF GL Cross Ref-001
- DR_SEQUENCE15
- FIF GL Cross Ref-001
- DR_SEQUENCE16
- FIF GL Cross Ref-001
- DR_SEQUENCE17
- FIF GL Cross Ref-001
- DR_SEQUENCE18
- FIF GL Cross Ref-001
- DR_SEQUENCE19
- FIF GL Cross Ref-001
- DR_SEQUENCE20
- FIF GL Cross Ref-001