SA Rounding Rule Detail (Service Layer)

In Scope

Technical: SVC_SA_ROUNDING_RULE_DETAIL | ID: OR-FND-SVC_SA_ROUNDING_RULE_DETAIL-SA_ROUNDING_RULE_DETAIL_SERVICE_LAYER

This is the staging table for holding the details of the rounding rules. It is used to temporarily hold data before it is uploaded/updated in SA_ROUNDING_RULE_DETAIL.

See how this object fits into Foundation Data

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_ROUNDING_RULE_DETAIL

Field Definitions(5)

Rules & Considerations(15)

constraint

validation

Sample Load Data(4)

Example values from field definitions

ROW_SEQR
1
CHUNK_IDR
1
PROCESS_IDRPK
1
ACTION
SAMPLE
CREATE_ID
SAMPLE
ROUND_AMT
1.0000
LAST_UPD_ID
SAMPLE
LOW_ENDING_AMT
1.0000
PROCESS$STATUS
SAMPLE
CREATE_DATETIME
2026-01-01
HIGH_ENDING_AMT
1.0000
ROUNDING_RULE_ID
SAMPLE
LAST_UPD_DATETIME
2026-01-01

default

ROW_SEQR
3
CHUNK_IDR
1000000003
PROCESS_IDRPK
1000000003
ACTION
Svc SA Rou
CREATE_ID
C LIENT_INFO
ROUND_AMT
12.5000
LAST_UPD_ID
C LIENT_INFO
LOW_ENDING_AMT
12.5000
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-03
HIGH_ENDING_AMT
12.5000
ROUNDING_RULE_ID
ALT-SVC_SA
LAST_UPD_DATETIME
2026-01-03

default

ROW_SEQR
5
CHUNK_IDR
1000000005
PROCESS_IDRPK
1000000005
ACTION
Svc SA Rou
CREATE_ID
USE RENV
ROUND_AMT
14.0000
LAST_UPD_ID
USE RENV
LOW_ENDING_AMT
14.0000
PROCESS$STATUS
N
CREATE_DATETIME
2026-01-05
HIGH_ENDING_AMT
14.0000
ROUNDING_RULE_ID
EDGE-SVC_S
LAST_UPD_DATETIME
2026-01-05

Rule Validation Summary

Source Rule Count
21
Governed Rule Count
15