SA System Options

In Scope

Technical: SA_SYSTEM_OPTIONS | ID: OR-MFCS-SA_SYSTEM_OPTIONS

Stores all user-defined parameters which will be accessed by the sales audit system to control the various processing options available. This table is populated during installation of the system and…

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

Target Structure

Load Approach
Table
Target Objects
SA_SYSTEM_OPTIONS

Field Definitions(38)

Rules & Considerations(143)

Sample Load Data(4)

default

COMP_NO_DAYSR
001
PARTNER_TYPEPK
SA System Options-001
UNIT_OF_WORKR
SA System Options-001
CASH_MGMT_INDR
Y
DAY_POST_SALER
001
COMP_BASE_DATER
2026-01-01
OVER_THRESHOLDR
11.0000
CC_NO_MASK_CHARR
SA System Options-001
OPEN_STORE_DAYSR
01
OPEN_TRAN_ERRORR
01
SHORT_THRESHOLDR
11.0000
PART_PAYMENT_INDR
Y
BALANCE_LEVEL_INDR
SA System Options-001
DAYS_BEFORE_PURGER
001
LOCKING_LEVEL_INDR
S
OVER_SHORT_SUMMARYR
01
AUDIT_AFTER_IMP_INDR
SA System Options-001
CHECK_DUP_MISS_TRANR
Y
POSITIVE_GL_POSTINGR
N
TRAN_NAVIGATION_INDR
R
INV_RESV_LAYAWAY_INDR
N
MISSING_TRAN_BIG_GAPR
001
CREATE_STORE_DAY_PRIORR
1
DOCUMENTATION_SUMM_INDR
N
INV_RESV_FROM_STORE_INDR
N
TAX_INCL_CUST_ORD_PAYMTR
POS
INPROGRESS_SALES_RUN_TYPER
ASYNC
WKSTATION_TRAN_APPEND_INDR
N
FUEL_DEPT
1001
PARTNER_ID
STD-SA_SYSTEM-001
ESCHEAT_IND
SA System Options-001
DAYS_POST_EOM
0
ORACLE_POS_IND
N
MAX_DAYS_COMPARE_DUPS
001
EXPDW_EXPORT_PURGE_DAYS
90
EXPSIM_EXPORT_PURGE_DAYS
90
RESA_TO_RMS_DIRECT_EXP_IND
N
CONSIGNMENT_SALES_REVIEW_PERIOD
0
SA System Options | undefined | Oracle Retail