ReSA Inprogress Sales

In Scope

Technical: SA_INPROGRESS_SALES | ID: OR-RSA-SA_INPROGRESS_SALES-RESA_INPROGRESS_SALES

This table will hold the sold quantity for the item-location combination for which the sales is still in-progress in ReSA and is yet to be integrated to RMS.

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_INPROGRESS_SALES

Field Definitions(5)

Rules & Considerations(13)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	LOCATIONR	PACK_NO	QUANTITY	REF_ITEM	SALES_QTY	SELLING_UOM	BUSINESS_DATE	SELLING_LOCATION	STORE_DAY_SEQ_NO	XFORM_SELLABLE_ITEM
Example values from field definitions	SAMPLE	1	SAMPLE	1.0000	SAMPLE	1.0000	SAMP	2026-01-01	1	1	SAMPLE
default	SA Inprogress Sales-002-A	3	SA Inprogress Sales-002-A	12.5000	SA Inprogress Sales-002-A	12.5000	SA I	2026-01-03	3	4	SA Inprogress Sales-002-A
default	SA Inprogress Sales-003-E	5	SA Inprogress Sales-003-E	14.0000	SA Inprogress Sales-003-E	14.0000	SA I	2026-01-05	5	6	SA Inprogress Sales-003-E

Example values from field definitions

ITEMR: SAMPLE
LOCATIONR: 1
PACK_NO: SAMPLE
QUANTITY: 1.0000
REF_ITEM: SAMPLE
SALES_QTY: 1.0000
SELLING_UOM: SAMP
BUSINESS_DATE: 2026-01-01
SELLING_LOCATION: 1
STORE_DAY_SEQ_NO: 1
XFORM_SELLABLE_ITEM: SAMPLE

default

ITEMR: SA Inprogress Sales-002-A
LOCATIONR: 3
PACK_NO: SA Inprogress Sales-002-A
QUANTITY: 12.5000
REF_ITEM: SA Inprogress Sales-002-A
SALES_QTY: 12.5000
SELLING_UOM: SA I
BUSINESS_DATE: 2026-01-03
SELLING_LOCATION: 3
STORE_DAY_SEQ_NO: 4
XFORM_SELLABLE_ITEM: SA Inprogress Sales-002-A