ReSA Transaction Item
In ScopeTechnical: SA_TRAN_ITEM | ID: OR-RSA-SA_TRAN_ITEM-RESA_TRANSACTION_ITEM
This table is used to hold the details about 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
Field Definitions(5)
Rules & Considerations(80)
Sample Load Data(4)
| _scenario | DAYRPK | STORERPK | ITEM_SEQ_NORPK | ITEM_STATUSR | TRAN_SEQ_NORPK | QTY | DEPT | ITEM | PUMP | CLASS | REF_NO5 | REF_NO6 | REF_NO7 | REF_NO8 | TAX_IND | MEDIA_ID | REF_ITEM | SUBCLASS | ERROR_IND | ITEM_TYPE | 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 | UOM_QUANTITY | CUST_ORDER_NO | DROP_SHIP_IND | POSTING_STORE | NON_MERCH_ITEM | NO_INV_RET_IND | CATCHWEIGHT_IND | CUST_ORDER_DATE | EXPIRATION_DATE | FULFILLMENT_LOC | ITEM_SWIPED_IND | OVERRIDE_REASON | TOTAL_IGTAX_AMT | CONSIGNMENT_RATE | FULFILL_ORDER_NO | ORIG_UNIT_RETAIL | RETURN_DISPOSITION | RETURN_REASON_CODE | FULFILLMENT_LOC_TYPE | STANDARD_UNIT_RETAIL | UNIT_RETAIL_VAT_INCL | 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 | SAMPLE | 1 | 1.0000 | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | 1 | SAMPLE | 1 | S | SAMPLE | 1 | SAMPLE | 1.0000 | 1 | S | SAMPLE | SAMPLE | SAMPLE | SAMP | 1.0000 | SAMPLE | 1 | SAMPLE | 1.0000 | SAMP | 1.0000 | SAMPLE | S | 1 | SAMPLE | S | S | 2026-01-01 | 2026-01-01 | 1 | S | SAMPLE | 1.0000 | 1.0000 | SAMPLE | 1.0000 | SAMPLE | SAMPLE | SA | 1.0000 | S | 1.0000 | 1 | 1.0000 | S | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 |
| default | 3 | 1003 | 4 | PENDIN | 4 | 12.5000 | 1003 | SA Tran Item-002-ALT | SA Tran | 1103 | SA Tran Item-002-ALT | SA Tran Item-002-ALT | SA Tran Item-002-ALT | SA Tran Item-002-ALT | S | 1000000003 | SA Tran Item-002-ALT | 1113 | S | SA Tra | 9003 | ALT-SA_TRAN-002 | 12.5000 | 1003 | R | SA Tran Item-002-ALT | SL | SA Tran It | SA T | 12.5000 | ALT-SA_TRAN-002 | 4 | SA Tran Item-002-ALT | 12.5000 | SA T | 12.5000 | SA Tran Item-002-ALT | S | 1003 | SA Tran Item-002-ALT | S | N | 2026-01-03 | 2026-01-03 | 3 | k | SA Tra | 12.5000 | 12.5000 | SA Tran Item-002-ALT | 12.5000 | SA Tran It | ALT-SA | SA | 12.5000 | N | 12.5000 | 4 | 12.5000 | P | L | 12.5000 | 2026-01-03 | 12.5000 |
| default | 5 | 1005 | 6 | ACTIVE | 6 | 14.0000 | 1005 | SA Tran Item-003-EDGE | SA Tran | 1105 | SA Tran Item-003-EDGE | SA Tran Item-003-EDGE | SA Tran Item-003-EDGE | SA Tran Item-003-EDGE | S | 1000000005 | SA Tran Item-003-EDGE | 1115 | S | SA Tra | 9005 | EDGE-SA_TRAN-003 | 14.0000 | 1005 | R | SA Tran Item-003-EDGE | SL | SA Tran It | SA T | 14.0000 | EDGE-SA_TRAN-003 | 6 | SA Tran Item-003-EDGE | 14.0000 | SA T | 14.0000 | SA Tran Item-003-EDGE | S | 1005 | SA Tran Item-003-EDGE | S | Y | 2026-01-05 | 2026-01-05 | 5 | k | SA Tra | 14.0000 | 14.0000 | SA Tran Item-003-EDGE | 14.0000 | SA Tran It | EDGE-S | SA | 14.0000 | N | 14.0000 | 6 | 14.0000 | A | E | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- DAYRPK
- 1
- STORERPK
- 1
- ITEM_SEQ_NORPK
- 1
- ITEM_STATUSR
- SAMPLE
- TRAN_SEQ_NORPK
- 1
- QTY
- 1.0000
- DEPT
- 1
- ITEM
- SAMPLE
- PUMP
- SAMPLE
- CLASS
- 1
- REF_NO5
- SAMPLE
- REF_NO6
- SAMPLE
- REF_NO7
- SAMPLE
- REF_NO8
- SAMPLE
- TAX_IND
- S
- MEDIA_ID
- 1
- REF_ITEM
- SAMPLE
- SUBCLASS
- 1
- ERROR_IND
- S
- ITEM_TYPE
- SAMPLE
- 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
- UOM_QUANTITY
- 1.0000
- CUST_ORDER_NO
- SAMPLE
- DROP_SHIP_IND
- S
- 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
- ITEM_SWIPED_IND
- S
- 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
- UNIT_RETAIL_VAT_INCL
- S
- 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
default
- DAYRPK
- 3
- STORERPK
- 1003
- ITEM_SEQ_NORPK
- 4
- ITEM_STATUSR
- PENDIN
- TRAN_SEQ_NORPK
- 4
- QTY
- 12.5000
- DEPT
- 1003
- ITEM
- SA Tran Item-002-ALT
- PUMP
- SA Tran
- CLASS
- 1103
- REF_NO5
- SA Tran Item-002-ALT
- REF_NO6
- SA Tran Item-002-ALT
- REF_NO7
- SA Tran Item-002-ALT
- REF_NO8
- SA Tran Item-002-ALT
- TAX_IND
- S
- MEDIA_ID
- 1000000003
- REF_ITEM
- SA Tran Item-002-ALT
- SUBCLASS
- 1113
- ERROR_IND
- S
- ITEM_TYPE
- SA Tra
- RETURN_WH
- 9003
- UNIQUE_ID
- ALT-SA_TRAN-002
- WASTE_PCT
- 12.5000
- ORIG_STORE
- 1003
- SALES_TYPE
- R
- VOUCHER_NO
- SA Tran Item-002-ALT
- WASTE_TYPE
- SL
- SALESPERSON
- SA Tran It
- SELLING_UOM
- SA T
- UNIT_RETAIL
- 12.5000
- INVENTORY_ID
- ALT-SA_TRAN-002
- ORIG_TRAN_NO
- 4
- SELLING_ITEM
- SA Tran Item-002-ALT
- STANDARD_QTY
- 12.5000
- STANDARD_UOM
- SA T
- UOM_QUANTITY
- 12.5000
- CUST_ORDER_NO
- SA Tran Item-002-ALT
- DROP_SHIP_IND
- S
- POSTING_STORE
- 1003
- NON_MERCH_ITEM
- SA Tran Item-002-ALT
- NO_INV_RET_IND
- S
- CATCHWEIGHT_IND
- N
- CUST_ORDER_DATE
- 2026-01-03
- EXPIRATION_DATE
- 2026-01-03
- FULFILLMENT_LOC
- 3
- ITEM_SWIPED_IND
- k
- OVERRIDE_REASON
- SA Tra
- TOTAL_IGTAX_AMT
- 12.5000
- CONSIGNMENT_RATE
- 12.5000
- FULFILL_ORDER_NO
- SA Tran Item-002-ALT
- ORIG_UNIT_RETAIL
- 12.5000
- RETURN_DISPOSITION
- SA Tran It
- RETURN_REASON_CODE
- ALT-SA
- FULFILLMENT_LOC_TYPE
- SA
- STANDARD_UNIT_RETAIL
- 12.5000
- UNIT_RETAIL_VAT_INCL
- N
- CONSIGNMENT_UNIT_COST
- 12.5000
- CUSTOMER_ORDER_LINE_NO
- 4
- ADJUSTED_CONSIGNMENT_RATE
- 12.5000
- CONSIGNMENT_REVIEW_STATUS
- P
- INVENTORY_IDENTIFIER_TYPE
- L
- STANDARD_ORIG_UNIT_RETAIL
- 12.5000
- CONSIGNMENT_STAGED_DATETIME
- 2026-01-03
- ADJUSTED_CONSIGNMENT_UNIT_COST
- 12.5000
default
- DAYRPK
- 5
- STORERPK
- 1005
- ITEM_SEQ_NORPK
- 6
- ITEM_STATUSR
- ACTIVE
- TRAN_SEQ_NORPK
- 6
- QTY
- 14.0000
- DEPT
- 1005
- ITEM
- SA Tran Item-003-EDGE
- PUMP
- SA Tran
- CLASS
- 1105
- REF_NO5
- SA Tran Item-003-EDGE
- REF_NO6
- SA Tran Item-003-EDGE
- REF_NO7
- SA Tran Item-003-EDGE
- REF_NO8
- SA Tran Item-003-EDGE
- TAX_IND
- S
- MEDIA_ID
- 1000000005
- REF_ITEM
- SA Tran Item-003-EDGE
- SUBCLASS
- 1115
- ERROR_IND
- S
- ITEM_TYPE
- SA Tra
- RETURN_WH
- 9005
- UNIQUE_ID
- EDGE-SA_TRAN-003
- WASTE_PCT
- 14.0000
- ORIG_STORE
- 1005
- SALES_TYPE
- R
- VOUCHER_NO
- SA Tran Item-003-EDGE
- WASTE_TYPE
- SL
- SALESPERSON
- SA Tran It
- SELLING_UOM
- SA T
- UNIT_RETAIL
- 14.0000
- INVENTORY_ID
- EDGE-SA_TRAN-003
- ORIG_TRAN_NO
- 6
- SELLING_ITEM
- SA Tran Item-003-EDGE
- STANDARD_QTY
- 14.0000
- STANDARD_UOM
- SA T
- UOM_QUANTITY
- 14.0000
- CUST_ORDER_NO
- SA Tran Item-003-EDGE
- DROP_SHIP_IND
- S
- POSTING_STORE
- 1005
- NON_MERCH_ITEM
- SA Tran Item-003-EDGE
- NO_INV_RET_IND
- S
- CATCHWEIGHT_IND
- Y
- CUST_ORDER_DATE
- 2026-01-05
- EXPIRATION_DATE
- 2026-01-05
- FULFILLMENT_LOC
- 5
- ITEM_SWIPED_IND
- k
- OVERRIDE_REASON
- SA Tra
- TOTAL_IGTAX_AMT
- 14.0000
- CONSIGNMENT_RATE
- 14.0000
- FULFILL_ORDER_NO
- SA Tran Item-003-EDGE
- ORIG_UNIT_RETAIL
- 14.0000
- RETURN_DISPOSITION
- SA Tran It
- RETURN_REASON_CODE
- EDGE-S
- FULFILLMENT_LOC_TYPE
- SA
- STANDARD_UNIT_RETAIL
- 14.0000
- UNIT_RETAIL_VAT_INCL
- N
- CONSIGNMENT_UNIT_COST
- 14.0000
- CUSTOMER_ORDER_LINE_NO
- 6
- ADJUSTED_CONSIGNMENT_RATE
- 14.0000
- CONSIGNMENT_REVIEW_STATUS
- A
- INVENTORY_IDENTIFIER_TYPE
- E
- STANDARD_ORIG_UNIT_RETAIL
- 14.0000
- CONSIGNMENT_STAGED_DATETIME
- 2026-01-05
- ADJUSTED_CONSIGNMENT_UNIT_COST
- 14.0000
Rule Validation Summary
- Source Rule Count
- 124
- Governed Rule Count
- 80