ReSA Transaction Discount Rev
In ScopeTechnical: SA_TRAN_DISC_REV | ID: OR-RSA-SA_TRAN_DISC_REV-RESA_TRANSACTION_DISCOUNT_REV
Stores all revisions to discount values associated with an item.
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_TRAN_DISC_REV
Field Definitions(5)
Rules & Considerations(44)
Sample Load Data(4)
| _scenario | DAYRPK | STORERPK | ITEM_SEQ_NORPK | TRAN_SEQ_NORPK | DISCOUNT_SEQ_NORPK | QTY | REV_NO | REF_NO13 | REF_NO14 | REF_NO15 | REF_NO16 | COUPON_NO | DISC_TYPE | ERROR_IND | PROMOTION | PROMO_COMP | STANDARD_QTY | UOM_QUANTITY | COUPON_REF_NO | RMS_PROMO_TYPE | CATCHWEIGHT_IND | UNIT_DISCOUNT_AMT | STANDARD_UNIT_DISC_AMT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | 1 | 1.0000 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1 | 1 | 1.0000 | 1.0000 | SAMPLE | SAMPLE | S | 1.0000 | 1.0000 |
| default | 3 | 1003 | 4 | 4 | 4 | 12.5000 | 4 | SA Tran Disc Rev-002-ALT | SA Tran Disc Rev-002-ALT | SA Tran Disc Rev-002-ALT | SA Tran Disc Rev-002-ALT | SA Tran Disc Rev-002-ALT | SA Tra | S | 3 | 3 | 12.5000 | 12.5000 | SA Tran Disc Rev | SA Tra | S | 12.5000 | 12.5000 |
| default | 5 | 1005 | 6 | 6 | 6 | 14.0000 | 6 | SA Tran Disc Rev-003-EDGE | SA Tran Disc Rev-003-EDGE | SA Tran Disc Rev-003-EDGE | SA Tran Disc Rev-003-EDGE | SA Tran Disc Rev-003-EDGE | SA Tra | S | 5 | 5 | 14.0000 | 14.0000 | SA Tran Disc Rev | SA Tra | S | 14.0000 | 14.0000 |
Example values from field definitions
- DAYRPK
- 1
- STORERPK
- 1
- ITEM_SEQ_NORPK
- 1
- TRAN_SEQ_NORPK
- 1
- DISCOUNT_SEQ_NORPK
- 1
- QTY
- 1.0000
- REV_NO
- 1
- REF_NO13
- SAMPLE
- REF_NO14
- SAMPLE
- REF_NO15
- SAMPLE
- REF_NO16
- SAMPLE
- COUPON_NO
- SAMPLE
- DISC_TYPE
- SAMPLE
- ERROR_IND
- S
- PROMOTION
- 1
- PROMO_COMP
- 1
- STANDARD_QTY
- 1.0000
- UOM_QUANTITY
- 1.0000
- COUPON_REF_NO
- SAMPLE
- RMS_PROMO_TYPE
- SAMPLE
- CATCHWEIGHT_IND
- S
- UNIT_DISCOUNT_AMT
- 1.0000
- STANDARD_UNIT_DISC_AMT
- 1.0000
default
- DAYRPK
- 3
- STORERPK
- 1003
- ITEM_SEQ_NORPK
- 4
- TRAN_SEQ_NORPK
- 4
- DISCOUNT_SEQ_NORPK
- 4
- QTY
- 12.5000
- REV_NO
- 4
- REF_NO13
- SA Tran Disc Rev-002-ALT
- REF_NO14
- SA Tran Disc Rev-002-ALT
- REF_NO15
- SA Tran Disc Rev-002-ALT
- REF_NO16
- SA Tran Disc Rev-002-ALT
- COUPON_NO
- SA Tran Disc Rev-002-ALT
- DISC_TYPE
- SA Tra
- ERROR_IND
- S
- PROMOTION
- 3
- PROMO_COMP
- 3
- STANDARD_QTY
- 12.5000
- UOM_QUANTITY
- 12.5000
- COUPON_REF_NO
- SA Tran Disc Rev
- RMS_PROMO_TYPE
- SA Tra
- CATCHWEIGHT_IND
- S
- UNIT_DISCOUNT_AMT
- 12.5000
- STANDARD_UNIT_DISC_AMT
- 12.5000
default
- DAYRPK
- 5
- STORERPK
- 1005
- ITEM_SEQ_NORPK
- 6
- TRAN_SEQ_NORPK
- 6
- DISCOUNT_SEQ_NORPK
- 6
- QTY
- 14.0000
- REV_NO
- 6
- REF_NO13
- SA Tran Disc Rev-003-EDGE
- REF_NO14
- SA Tran Disc Rev-003-EDGE
- REF_NO15
- SA Tran Disc Rev-003-EDGE
- REF_NO16
- SA Tran Disc Rev-003-EDGE
- COUPON_NO
- SA Tran Disc Rev-003-EDGE
- DISC_TYPE
- SA Tra
- ERROR_IND
- S
- PROMOTION
- 5
- PROMO_COMP
- 5
- STANDARD_QTY
- 14.0000
- UOM_QUANTITY
- 14.0000
- COUPON_REF_NO
- SA Tran Disc Rev
- RMS_PROMO_TYPE
- SA Tra
- CATCHWEIGHT_IND
- S
- UNIT_DISCOUNT_AMT
- 14.0000
- STANDARD_UNIT_DISC_AMT
- 14.0000
Rule Validation Summary
- Source Rule Count
- 50
- Governed Rule Count
- 44