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(5)
Rules & Considerations(68)
constraint
validation
Sample Load Data(4)
| _scenario | SET_OF_BOOKS_IDR | FIF_GL_CROSS_REF_IDRPK | DEPT | CLASS | CR_CCID | DR_CCID | BASE_IND | GROUP_ID | LOCATION | PRIORITY | SUBCLASS | LINE_TYPE | TRAN_CODE | 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 | COST_RETAIL_FLAG |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | 1 | S | 1 | 1 | 1 | 1 | SAMPLE | 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 | S |
| default | 1000000003 | 1000000003 | 1003 | 1103 | 3 | 3 | F | 100003 | 3 | 3 | 1113 | FIF GL | 3 | 2 | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | FIF GL Cross Ref-002-ALT | F |
| default | 1000000005 | 1000000005 | 1005 | 1105 | 5 | 5 | F | 100005 | 5 | 5 | 1115 | FIF GL | 5 | 2 | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | FIF GL Cross Ref-003-EDGE | F |
Example values from field definitions
- SET_OF_BOOKS_IDR
- 1
- FIF_GL_CROSS_REF_IDRPK
- 1
- DEPT
- 1
- CLASS
- 1
- CR_CCID
- 1
- DR_CCID
- 1
- BASE_IND
- S
- GROUP_ID
- 1
- LOCATION
- 1
- PRIORITY
- 1
- SUBCLASS
- 1
- LINE_TYPE
- SAMPLE
- TRAN_CODE
- 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
- COST_RETAIL_FLAG
- S
default
- SET_OF_BOOKS_IDR
- 1000000003
- FIF_GL_CROSS_REF_IDRPK
- 1000000003
- DEPT
- 1003
- CLASS
- 1103
- CR_CCID
- 3
- DR_CCID
- 3
- BASE_IND
- F
- GROUP_ID
- 100003
- LOCATION
- 3
- PRIORITY
- 3
- SUBCLASS
- 1113
- LINE_TYPE
- FIF GL
- TRAN_CODE
- 3
- UPDATE_IND
- 2
- TRAN_REF_NO
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE1
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE2
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE3
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE4
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE5
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE6
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE7
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE8
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE9
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE1
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE2
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE3
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE4
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE5
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE6
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE7
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE8
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE9
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE10
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE11
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE12
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE13
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE14
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE15
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE16
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE17
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE18
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE19
- FIF GL Cross Ref-002-ALT
- CR_SEQUENCE20
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE10
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE11
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE12
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE13
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE14
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE15
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE16
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE17
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE18
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE19
- FIF GL Cross Ref-002-ALT
- DR_SEQUENCE20
- FIF GL Cross Ref-002-ALT
- COST_RETAIL_FLAG
- F
default
- SET_OF_BOOKS_IDR
- 1000000005
- FIF_GL_CROSS_REF_IDRPK
- 1000000005
- DEPT
- 1005
- CLASS
- 1105
- CR_CCID
- 5
- DR_CCID
- 5
- BASE_IND
- F
- GROUP_ID
- 100005
- LOCATION
- 5
- PRIORITY
- 5
- SUBCLASS
- 1115
- LINE_TYPE
- FIF GL
- TRAN_CODE
- 5
- UPDATE_IND
- 2
- TRAN_REF_NO
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE1
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE2
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE3
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE4
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE5
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE6
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE7
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE8
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE9
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE1
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE2
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE3
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE4
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE5
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE6
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE7
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE8
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE9
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE10
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE11
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE12
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE13
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE14
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE15
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE16
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE17
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE18
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE19
- FIF GL Cross Ref-003-EDGE
- CR_SEQUENCE20
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE10
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE11
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE12
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE13
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE14
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE15
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE16
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE17
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE18
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE19
- FIF GL Cross Ref-003-EDGE
- DR_SEQUENCE20
- FIF GL Cross Ref-003-EDGE
- COST_RETAIL_FLAG
- F
Rule Validation Summary
- Source Rule Count
- 74
- Governed Rule Count
- 68