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(5)

Rules & Considerations(31)

Sample Load Data(4)

_scenario	IDRPK	STORE_IDR	REQUEST_IDR	EXTERNAL_IDR	EPC	UIN	TYPE	REASON	ITEM_ID	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	TRANSACTION_EXTENDED_ID
Example values from field definitions	1	1	1	SAMPLE	SAMPLE	SAMPLE	1	1	SAMPLE	SAMPLE	1.0000	S	1	1	S	SAMPLE	SAMPLE	SAMP	2026-01-01	2026-01-01	1	1	SAMPLE	SAMPLE	1	2026-01-01	SAMPLE
default	3	1000000003	1000000003	ALT-POS_TRANSA-002	POS Transaction-002-ALT	POS Transaction-002-ALT	3	3	ALT-POS_TRANSA-002	POS Transaction-002-ALT	12.5000	P	2	2	P	ALT-POS_TRANSA-002	POS Transaction-002-ALT	POS	2026-01-03	2026-01-03	1	2	POS Transaction-002-ALT	ALT-POS_TRANSA-002	3	2026-01-03	ALT-POS_TRANSA-002
default	5	1000000005	1000000005	EDGE-POS_TRANSA-003	POS Transaction-003-EDGE	POS Transaction-003-EDGE	5	5	EDGE-POS_TRANSA-003	POS Transaction-003-EDGE	14.0000	P	1	1	P	EDGE-POS_TRANSA-003	POS Transaction-003-EDGE	POS	2026-01-05	2026-01-05	2	3	POS Transaction-003-EDGE	EDGE-POS_TRANSA-003	5	2026-01-05	EDGE-POS_TRANSA-003

Example values from field definitions

IDRPK: 1
STORE_IDR: 1
REQUEST_IDR: 1
EXTERNAL_IDR: SAMPLE
EPC: SAMPLE
UIN: SAMPLE
TYPE: 1
REASON: 1
ITEM_ID: SAMPLE
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
TRANSACTION_EXTENDED_ID: SAMPLE

default

IDRPK: 3
STORE_IDR: 1000000003
REQUEST_IDR: 1000000003
EXTERNAL_IDR: ALT-POS_TRANSA-002
EPC: POS Transaction-002-ALT
UIN: POS Transaction-002-ALT
TYPE: 3
REASON: 3
ITEM_ID: ALT-POS_TRANSA-002
COMMENTS: POS Transaction-002-ALT
QUANTITY: 12.5000
DROP_SHIP: P
SOURCE_TYPE: 2
ITEM_ID_TYPE: 2
RESA_CREATED: P
CUST_ORDER_ID: ALT-POS_TRANSA-002
EXTERNAL_USER: POS Transaction-002-ALT
UNIT_OF_MEASURE: POS
FILE_CREATE_DATE: 2026-01-03
UPDATE_DATE_TIME: 2026-01-03
PROCESSING_STATUS: 1
CUST_ORDER_TYPE_ID: 2
CUST_ORDER_COMMENTS: POS Transaction-002-ALT
FUL_ORD_EXTERNAL_ID: ALT-POS_TRANSA-002
FUL_ORD_LINE_NUMBER: 3
TRANSACTION_DATE_TIME: 2026-01-03
TRANSACTION_EXTENDED_ID: ALT-POS_TRANSA-002

default

IDRPK: 5
STORE_IDR: 1000000005
REQUEST_IDR: 1000000005
EXTERNAL_IDR: EDGE-POS_TRANSA-003
EPC: POS Transaction-003-EDGE
UIN: POS Transaction-003-EDGE
TYPE: 5
REASON: 5
ITEM_ID: EDGE-POS_TRANSA-003
COMMENTS: POS Transaction-003-EDGE
QUANTITY: 14.0000
DROP_SHIP: P
SOURCE_TYPE: 1
ITEM_ID_TYPE: 1
RESA_CREATED: P
CUST_ORDER_ID: EDGE-POS_TRANSA-003
EXTERNAL_USER: POS Transaction-003-EDGE
UNIT_OF_MEASURE: POS
FILE_CREATE_DATE: 2026-01-05
UPDATE_DATE_TIME: 2026-01-05
PROCESSING_STATUS: 2
CUST_ORDER_TYPE_ID: 3
CUST_ORDER_COMMENTS: POS Transaction-003-EDGE
FUL_ORD_EXTERNAL_ID: EDGE-POS_TRANSA-003
FUL_ORD_LINE_NUMBER: 5
TRANSACTION_DATE_TIME: 2026-01-05
TRANSACTION_EXTENDED_ID: EDGE-POS_TRANSA-003

Rule Validation Summary

Source Rule Count: 43
Governed Rule Count: 31