ReSA Store Ach
In ScopeTechnical: SA_STORE_ACH | ID: OR-RSA-SA_STORE_ACH-RESA_STORE_ACH
This table will contain one row for each store/day combination, which does not exist in the tables SA_CORP_CLOSE and SA_STORE_CLOSE. It will be used to hold the individual store/day information...
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_STORE_ACH
Field Definitions(5)
Rules & Considerations(14)
constraint
validation
Sample Load Data(4)
| _scenario | STORERPK | PARTNER_IDRPK | PARTNER_TYPERPK | BUSINESS_DATERPK | NEXT_DAY_DEPOSIT_EST | TODAY_ADJ_DEPOSIT_EST | NEXT_DAY_MAN_ADJ_DEPOSIT |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMPLE | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 |
| default | 1003 | ALT-SA_STO | SA Sto | 2026-01-03 | 12.5000 | 12.5000 | 12.5000 |
| default | 1005 | EDGE-SA_ST | SA Sto | 2026-01-05 | 14.0000 | 14.0000 | 14.0000 |
Example values from field definitions
- STORERPK
- 1
- PARTNER_IDRPK
- SAMPLE
- PARTNER_TYPERPK
- SAMPLE
- BUSINESS_DATERPK
- 2026-01-01
- NEXT_DAY_DEPOSIT_EST
- 1.0000
- TODAY_ADJ_DEPOSIT_EST
- 1.0000
- NEXT_DAY_MAN_ADJ_DEPOSIT
- 1.0000
default
- STORERPK
- 1003
- PARTNER_IDRPK
- ALT-SA_STO
- PARTNER_TYPERPK
- SA Sto
- BUSINESS_DATERPK
- 2026-01-03
- NEXT_DAY_DEPOSIT_EST
- 12.5000
- TODAY_ADJ_DEPOSIT_EST
- 12.5000
- NEXT_DAY_MAN_ADJ_DEPOSIT
- 12.5000
default
- STORERPK
- 1005
- PARTNER_IDRPK
- EDGE-SA_ST
- PARTNER_TYPERPK
- SA Sto
- BUSINESS_DATERPK
- 2026-01-05
- NEXT_DAY_DEPOSIT_EST
- 14.0000
- TODAY_ADJ_DEPOSIT_EST
- 14.0000
- NEXT_DAY_MAN_ADJ_DEPOSIT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 28
- Governed Rule Count
- 14
