SA FIF GL Cross Reference (Service Layer)

In Scope

Technical: 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(60)

Rules & Considerations(62)

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

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

Rule Validation Summary

Source Rule Count: 74
Governed Rule Count: 62

All objects