FIF GL Cross Reference
In ScopeTechnical: FIF_GL_CROSS_REF | ID: OR-FIN-FIF_GL_CROSS_REF-FIF_GL_CROSS_REFERENCE
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- FIF_GL_CROSS_REF
Field Definitions(56)
Rules & Considerations(67)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTR | CLASSR | LOCATIONR | SUBCLASSR | LINE_TYPER | TRAN_CODER | SET_OF_BOOKS_IDRPK | COST_RETAIL_FLAGR | FIF_GL_CROSS_REF_IDRPK | CR_CCID | DR_CCID | BASE_IND | GROUP_ID | PRIORITY | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | SAMPLE | 1 | 1 | S | 1 | 1 | 1 | S | 1 | 1 | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE |
Example values from field definitions
- DEPTR
- 1
- CLASSR
- 1
- LOCATIONR
- 1
- SUBCLASSR
- 1
- LINE_TYPER
- SAMPLE
- TRAN_CODER
- 1
- SET_OF_BOOKS_IDRPK
- 1
- COST_RETAIL_FLAGR
- S
- FIF_GL_CROSS_REF_IDRPK
- 1
- CR_CCID
- 1
- DR_CCID
- 1
- BASE_IND
- S
- GROUP_ID
- 1
- PRIORITY
- 1
- UPDATE_IND
- S
- TRAN_REF_NO
- SAMPLE
- CR_SEQUENCE1
- SAMPLE
- CR_SEQUENCE2
- SAMPLE
- CR_SEQUENCE3
- SAMPLE
- CR_SEQUENCE4
- SAMPLE
- CR_SEQUENCE5
- SAMPLE
- CR_SEQUENCE6
- SAMPLE
- CR_SEQUENCE7
- SAMPLE
- CR_SEQUENCE8
- SAMPLE
- CR_SEQUENCE9
- SAMPLE
- DR_SEQUENCE1
- SAMPLE
- DR_SEQUENCE2
- SAMPLE
- DR_SEQUENCE3
- SAMPLE
- DR_SEQUENCE4
- SAMPLE
- DR_SEQUENCE5
- SAMPLE
- DR_SEQUENCE6
- SAMPLE
- DR_SEQUENCE7
- SAMPLE
- DR_SEQUENCE8
- SAMPLE
- DR_SEQUENCE9
- SAMPLE
- CR_SEQUENCE10
- SAMPLE
- CR_SEQUENCE11
- SAMPLE
- CR_SEQUENCE12
- SAMPLE
- CR_SEQUENCE13
- SAMPLE
- CR_SEQUENCE14
- SAMPLE
- CR_SEQUENCE15
- SAMPLE
- CR_SEQUENCE16
- SAMPLE
- CR_SEQUENCE17
- SAMPLE
- CR_SEQUENCE18
- SAMPLE
- CR_SEQUENCE19
- SAMPLE
- CR_SEQUENCE20
- SAMPLE
- DR_SEQUENCE10
- SAMPLE
- DR_SEQUENCE11
- SAMPLE
- DR_SEQUENCE12
- SAMPLE
- DR_SEQUENCE13
- SAMPLE
- DR_SEQUENCE14
- SAMPLE
- DR_SEQUENCE15
- SAMPLE
- DR_SEQUENCE16
- SAMPLE
- DR_SEQUENCE17
- SAMPLE
- DR_SEQUENCE18
- SAMPLE
- DR_SEQUENCE19
- SAMPLE
- DR_SEQUENCE20
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 73
- Governed Rule Count
- 67