SA FIF GL Cross Reference (Service Layer)
In ScopeTechnical: SVC_SA_FIF_GL_CROSS_REF | ID: OR-ITM-SVC_SA_FIF_GL_CROSS_REF-SA_FIF_GL_CROSS_REFERENCE_SERVICE_LAYER
This is the staging table for the data that is used to associate an Oracle account code with the different types of totals that can be calculated by Sales Audit....
See how this object fits into Item Management
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
- SVC_SA_FIF_GL_CROSS_REF
Field Definitions(5)
Rules & Considerations(62)
constraint
validation
Sample Load Data(4)
| _scenario | ROW_SEQR | CHUNK_IDR | PROCESS_IDRPK | STORE | ACTION | CR_CCID | DR_CCID | TOTAL_ID | CREATE_ID | LAST_UPD_ID | 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 | ATTRIBUTE3_MAP | ATTRIBUTE4_MAP | ATTRIBUTE5_MAP | PROCESS$STATUS | ROLLUP_LEVEL_1 | ROLLUP_LEVEL_2 | ROLLUP_LEVEL_3 | CREATE_DATETIME | SET_OF_BOOKS_ID | LAST_UPD_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | SAMPLE | 1 | 1 | 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 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 1 | 2026-01-01 |
| default | 3 | 1000000003 | 1000000003 | 1003 | Svc SA FIF | 3 | 3 | ALT-SVC_SA | C LIENT_INFO | C LIENT_INFO | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-002-AL | Svc SA FIF GL Cross Ref-002-AL | Svc SA FIF GL Cross Ref-002-AL | N | Svc SA FIF GL Cross Ref-002-ALT | Svc SA FIF GL Cross Ref-002-ALT | Svc SA FIF GL Cross Ref-002-ALT | 2026-01-03 | 1000000003 | 2026-01-03 |
| default | 5 | 1000000005 | 1000000005 | 1005 | Svc SA FIF | 5 | 5 | EDGE-SVC_S | USE RENV | USE RENV | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | Svc SA FIF GL Cross Ref-0 | — | — | — | N | Svc SA FIF GL Cross Ref-003-EDGE | Svc SA FIF GL Cross Ref-003-EDGE | Svc SA FIF GL Cross Ref-003-EDGE | 2026-01-05 | 1000000005 | 2026-01-05 |
Example values from field definitions
- ROW_SEQR
- 1
- CHUNK_IDR
- 1
- PROCESS_IDRPK
- 1
- STORE
- 1
- ACTION
- SAMPLE
- CR_CCID
- 1
- DR_CCID
- 1
- TOTAL_ID
- SAMPLE
- CREATE_ID
- SAMPLE
- LAST_UPD_ID
- 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
- ATTRIBUTE3_MAP
- SAMPLE
- ATTRIBUTE4_MAP
- SAMPLE
- ATTRIBUTE5_MAP
- SAMPLE
- PROCESS$STATUS
- SAMPLE
- ROLLUP_LEVEL_1
- SAMPLE
- ROLLUP_LEVEL_2
- SAMPLE
- ROLLUP_LEVEL_3
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- SET_OF_BOOKS_ID
- 1
- LAST_UPD_DATETIME
- 2026-01-01
default
- ROW_SEQR
- 3
- CHUNK_IDR
- 1000000003
- PROCESS_IDRPK
- 1000000003
- STORE
- 1003
- ACTION
- Svc SA FIF
- CR_CCID
- 3
- DR_CCID
- 3
- TOTAL_ID
- ALT-SVC_SA
- CREATE_ID
- C LIENT_INFO
- LAST_UPD_ID
- C LIENT_INFO
- CR_SEQUENCE1
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE2
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE3
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE4
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE5
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE6
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE7
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE8
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE9
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE1
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE2
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE3
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE4
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE5
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE6
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE7
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE8
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE9
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE10
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE11
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE12
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE13
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE14
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE15
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE16
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE17
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE18
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE19
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE20
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE10
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE11
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE12
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE13
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE14
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE15
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE16
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE17
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE18
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE19
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE20
- Svc SA FIF GL Cross Ref-0
- ATTRIBUTE3_MAP
- Svc SA FIF GL Cross Ref-002-AL
- ATTRIBUTE4_MAP
- Svc SA FIF GL Cross Ref-002-AL
- ATTRIBUTE5_MAP
- Svc SA FIF GL Cross Ref-002-AL
- PROCESS$STATUS
- N
- ROLLUP_LEVEL_1
- Svc SA FIF GL Cross Ref-002-ALT
- ROLLUP_LEVEL_2
- Svc SA FIF GL Cross Ref-002-ALT
- ROLLUP_LEVEL_3
- Svc SA FIF GL Cross Ref-002-ALT
- CREATE_DATETIME
- 2026-01-03
- SET_OF_BOOKS_ID
- 1000000003
- LAST_UPD_DATETIME
- 2026-01-03
default
- ROW_SEQR
- 5
- CHUNK_IDR
- 1000000005
- PROCESS_IDRPK
- 1000000005
- STORE
- 1005
- ACTION
- Svc SA FIF
- CR_CCID
- 5
- DR_CCID
- 5
- TOTAL_ID
- EDGE-SVC_S
- CREATE_ID
- USE RENV
- LAST_UPD_ID
- USE RENV
- CR_SEQUENCE1
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE2
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE3
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE4
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE5
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE6
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE7
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE8
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE9
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE1
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE2
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE3
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE4
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE5
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE6
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE7
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE8
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE9
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE10
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE11
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE12
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE13
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE14
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE15
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE16
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE17
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE18
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE19
- Svc SA FIF GL Cross Ref-0
- CR_SEQUENCE20
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE10
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE11
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE12
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE13
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE14
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE15
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE16
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE17
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE18
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE19
- Svc SA FIF GL Cross Ref-0
- DR_SEQUENCE20
- Svc SA FIF GL Cross Ref-0
- ATTRIBUTE3_MAP
- —
- ATTRIBUTE4_MAP
- —
- ATTRIBUTE5_MAP
- —
- PROCESS$STATUS
- N
- ROLLUP_LEVEL_1
- Svc SA FIF GL Cross Ref-003-EDGE
- ROLLUP_LEVEL_2
- Svc SA FIF GL Cross Ref-003-EDGE
- ROLLUP_LEVEL_3
- Svc SA FIF GL Cross Ref-003-EDGE
- CREATE_DATETIME
- 2026-01-05
- SET_OF_BOOKS_ID
- 1000000005
- LAST_UPD_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 74
- Governed Rule Count
- 62