Svc SA FIF GL Cross Ref
In ScopeTechnical: SVC_SA_FIF_GL_CROSS_REF | ID: OR-MFCS-SVC_SA_FIF_GL_CROSS_REF
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
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_SA_FIF_GL_CROSS_REF
Field Definitions(60)
Rules & Considerations(20)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1000000001 | 1000000001 | 1001 | Svc SA FIF GL Cross Ref-001 | 1 | 1 | STD-SVC_SA-001 | USERENV | USERENV | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | N | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | Svc SA FIF GL Cross Ref-001 | 2026-01-01 | 1000000001 | 2026-01-01 |
default
- ROW_SEQR
- 1
- CHUNK_IDR
- 1000000001
- PROCESS_IDRPK
- 1000000001
- STORE
- 1001
- ACTION
- Svc SA FIF GL Cross Ref-001
- CR_CCID
- 1
- DR_CCID
- 1
- TOTAL_ID
- STD-SVC_SA-001
- CREATE_ID
- USERENV
- LAST_UPD_ID
- USERENV
- CR_SEQUENCE1
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE2
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE3
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE4
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE5
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE6
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE7
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE8
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE9
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE1
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE2
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE3
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE4
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE5
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE6
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE7
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE8
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE9
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE10
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE11
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE12
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE13
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE14
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE15
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE16
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE17
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE18
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE19
- Svc SA FIF GL Cross Ref-001
- CR_SEQUENCE20
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE10
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE11
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE12
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE13
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE14
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE15
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE16
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE17
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE18
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE19
- Svc SA FIF GL Cross Ref-001
- DR_SEQUENCE20
- Svc SA FIF GL Cross Ref-001
- ATTRIBUTE3_MAP
- Svc SA FIF GL Cross Ref-001
- ATTRIBUTE4_MAP
- Svc SA FIF GL Cross Ref-001
- ATTRIBUTE5_MAP
- Svc SA FIF GL Cross Ref-001
- PROCESS$STATUS
- N
- ROLLUP_LEVEL_1
- Svc SA FIF GL Cross Ref-001
- ROLLUP_LEVEL_2
- Svc SA FIF GL Cross Ref-001
- ROLLUP_LEVEL_3
- Svc SA FIF GL Cross Ref-001
- CREATE_DATETIME
- 2026-01-01
- SET_OF_BOOKS_ID
- 1000000001
- LAST_UPD_DATETIME
- 2026-01-01