ReSA Comments History

In Scope

Technical: SA_COMMENTS_HIST | ID: OR-RSA-SA_COMMENTS_HIST-RESA_COMMENTS_HISTORY

Stores historical records for SA comments hist in Oracle Retail Merchandising, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and traceability of sales audit...

See how this object fits into Sales Audit

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: SA_COMMENTS_HIST

Field Definitions(5)

Rules & Considerations(12)

validation

constraint

Sample Load Data(4)

_scenario	USER_IDR	COMMENTSR	COMMENT_KEYR	COMMENT_TYPER	COMMENT_SEQ_NOR	DATETIME	HIST_WRITTEN_DATE
Example values from field definitions	SAMPLE	SAMPLE	1	SAMPLE	1	2026-01-01	2026-01-01
default	ALT-SA_COMMENT-002	SA Comments Hist-002-ALT	3	SA Com	4	2026-01-03	2026-01-03
default	EDGE-SA_COMMENT-003	SA Comments Hist-003-EDGE	5	SA Com	6	2026-01-05	2026-01-05

Example values from field definitions

USER_IDR: SAMPLE
COMMENTSR: SAMPLE
COMMENT_KEYR: 1
COMMENT_TYPER: SAMPLE
COMMENT_SEQ_NOR: 1
DATETIME: 2026-01-01
HIST_WRITTEN_DATE: 2026-01-01

default

USER_IDR: ALT-SA_COMMENT-002
COMMENTSR: SA Comments Hist-002-ALT
COMMENT_KEYR: 3
COMMENT_TYPER: SA Com
COMMENT_SEQ_NOR: 4
DATETIME: 2026-01-03
HIST_WRITTEN_DATE: 2026-01-03