ReSA Transaction Item Rev
In ScopeTechnical: SA_TRAN_ITEM_REV | ID: OR-RSA-SA_TRAN_ITEM_REV-RESA_TRANSACTION_ITEM_REV
This table will hold all revisions to the details for each item contained in a transaction.
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_ITEM_REV
Field Definitions(65)
Rules & Considerations(76)
Sample Load Data(4)
| _scenario | DAYR | STORER | REV_NOR | TAX_INDR | ERROR_INDR | ITEM_TYPER | ITEM_SEQ_NOR | ITEM_STATUSR | TRAN_SEQ_NORPK | UOM_QUANTITYR | DROP_SHIP_INDR | ITEM_SWIPED_INDR | UNIT_RETAIL_VAT_INCLR | QTY | DEPT | ITEM | PUMP | CLASS | REF_NO5 | REF_NO6 | REF_NO7 | REF_NO8 | MEDIA_ID | REF_ITEM | SUBCLASS | RETURN_WH | UNIQUE_ID | WASTE_PCT | ORIG_STORE | SALES_TYPE | VOUCHER_NO | WASTE_TYPE | SALESPERSON | SELLING_UOM | UNIT_RETAIL | INVENTORY_ID | ORIG_TRAN_NO | SELLING_ITEM | STANDARD_QTY | STANDARD_UOM | CUST_ORDER_NO | POSTING_STORE | NON_MERCH_ITEM | NO_INV_RET_IND | CATCHWEIGHT_IND | CUST_ORDER_DATE | EXPIRATION_DATE | FULFILLMENT_LOC | OVERRIDE_REASON | TOTAL_IGTAX_AMT | CONSIGNMENT_RATE | FULFILL_ORDER_NO | ORIG_UNIT_RETAIL | RETURN_DISPOSITION | RETURN_REASON_CODE | FULFILLMENT_LOC_TYPE | STANDARD_UNIT_RETAIL | CONSIGNMENT_UNIT_COST | CUSTOMER_ORDER_LINE_NO | ADJUSTED_CONSIGNMENT_RATE | CONSIGNMENT_REVIEW_STATUS | INVENTORY_IDENTIFIER_TYPE | STANDARD_ORIG_UNIT_RETAIL | CONSIGNMENT_STAGED_DATETIME | ADJUSTED_CONSIGNMENT_UNIT_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | S | S | SAMPLE | 1 | SAMPLE | 1 | 1 | S | S | S | 1.0000 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | 1.0000 | 1 | S | SAMPLE | SAMPLE | SAMPLE | SAMP | 1.0000 | SAMPLE | 1 | SAMPLE | 1.0000 | SAMP | SAMPLE | 1 | SAMPLE | S | S | 2026-01-01 | 2026-01-01 | 1 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SA | 1.0000 | 1.0000 | 1 | 1.0000 | S | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 |
Example values from field definitions
- DAYR
- 1
- STORER
- 1
- REV_NOR
- 1
- TAX_INDR
- S
- ERROR_INDR
- S
- ITEM_TYPER
- SAMPLE
- ITEM_SEQ_NOR
- 1
- ITEM_STATUSR
- SAMPLE
- TRAN_SEQ_NORPK
- 1
- UOM_QUANTITYR
- 1
- DROP_SHIP_INDR
- S
- ITEM_SWIPED_INDR
- S
- UNIT_RETAIL_VAT_INCLR
- S
- QTY
- 1.0000
- DEPT
- 1
- ITEM
- SAMPLE
- PUMP
- SAMPLE
- CLASS
- 1
- REF_NO5
- SAMPLE
- REF_NO6
- SAMPLE
- REF_NO7
- SAMPLE
- REF_NO8
- SAMPLE
- MEDIA_ID
- SAMPLE
- REF_ITEM
- SAMPLE
- SUBCLASS
- 1
- RETURN_WH
- 1
- UNIQUE_ID
- SAMPLE
- WASTE_PCT
- 1.0000
- ORIG_STORE
- 1
- SALES_TYPE
- S
- VOUCHER_NO
- SAMPLE
- WASTE_TYPE
- SAMPLE
- SALESPERSON
- SAMPLE
- SELLING_UOM
- SAMP
- UNIT_RETAIL
- 1.0000
- INVENTORY_ID
- SAMPLE
- ORIG_TRAN_NO
- 1
- SELLING_ITEM
- SAMPLE
- STANDARD_QTY
- 1.0000
- STANDARD_UOM
- SAMP
- CUST_ORDER_NO
- SAMPLE
- POSTING_STORE
- 1
- NON_MERCH_ITEM
- SAMPLE
- NO_INV_RET_IND
- S
- CATCHWEIGHT_IND
- S
- CUST_ORDER_DATE
- 2026-01-01
- EXPIRATION_DATE
- 2026-01-01
- FULFILLMENT_LOC
- 1
- OVERRIDE_REASON
- SAMPLE
- TOTAL_IGTAX_AMT
- 1.0000
- CONSIGNMENT_RATE
- 1.0000
- FULFILL_ORDER_NO
- SAMPLE
- ORIG_UNIT_RETAIL
- 1.0000
- RETURN_DISPOSITION
- SAMPLE
- RETURN_REASON_CODE
- SAMPLE
- FULFILLMENT_LOC_TYPE
- SA
- STANDARD_UNIT_RETAIL
- 1.0000
- CONSIGNMENT_UNIT_COST
- 1.0000
- CUSTOMER_ORDER_LINE_NO
- 1
- ADJUSTED_CONSIGNMENT_RATE
- 1.0000
- CONSIGNMENT_REVIEW_STATUS
- S
- INVENTORY_IDENTIFIER_TYPE
- SAMPLE
- STANDARD_ORIG_UNIT_RETAIL
- 1.0000
- CONSIGNMENT_STAGED_DATETIME
- 2026-01-01
- ADJUSTED_CONSIGNMENT_UNIT_COST
- 1.0000
Rule Validation Summary
- Source Rule Count
- 122
- Governed Rule Count
- 76