POS Transaction

In Scope

Technical: POS_TRANSACTION | ID: OR-STO-POS_TRANSACTION-POS_TRANSACTION

this table will hold the details of the pos transaction header and the line items in the transaction.

See how this object fits into Store Operations

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: POS_TRANSACTION

Field Definitions(28)

Rules & Considerations(31)

Sample Load Data(4)

_scenario	IDRPK	ITEM_IDR	STORE_IDR	REQUEST_IDR	EXTERNAL_IDR	TRANSACTION_EXTENDED_IDR	EPC	UIN	TYPE	REASON	COMMENTS	QUANTITY	DROP_SHIP	SOURCE_TYPE	ITEM_ID_TYPE	RESA_CREATED	CUST_ORDER_ID	EXTERNAL_USER	UNIT_OF_MEASURE	FILE_CREATE_DATE	UPDATE_DATE_TIME	PROCESSING_STATUS	CUST_ORDER_TYPE_ID	CUST_ORDER_COMMENTS	FUL_ORD_EXTERNAL_ID	FUL_ORD_LINE_NUMBER	TRANSACTION_DATE_TIME
Example values from field definitions	1	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1	SAMPLE	1.0000	S	1	1	S	SAMPLE	SAMPLE	SAMP	2026-01-01	2026-01-01	1	1	SAMPLE	SAMPLE	1	2026-01-01

Example values from field definitions

IDRPK: 1
ITEM_IDR: SAMPLE
STORE_IDR: 1
REQUEST_IDR: 1
EXTERNAL_IDR: SAMPLE
TRANSACTION_EXTENDED_IDR: SAMPLE
EPC: SAMPLE
UIN: SAMPLE
TYPE: 1
REASON: 1
COMMENTS: SAMPLE
QUANTITY: 1.0000
DROP_SHIP: S
SOURCE_TYPE: 1
ITEM_ID_TYPE: 1
RESA_CREATED: S
CUST_ORDER_ID: SAMPLE
EXTERNAL_USER: SAMPLE
UNIT_OF_MEASURE: SAMP
FILE_CREATE_DATE: 2026-01-01
UPDATE_DATE_TIME: 2026-01-01
PROCESSING_STATUS: 1
CUST_ORDER_TYPE_ID: 1
CUST_ORDER_COMMENTS: SAMPLE
FUL_ORD_EXTERNAL_ID: SAMPLE
FUL_ORD_LINE_NUMBER: 1
TRANSACTION_DATE_TIME: 2026-01-01

Rule Validation Summary

Source Rule Count: 43
Governed Rule Count: 31