Ordsku Rev

In Scope

Technical: ORDSKU_REV | ID: OR-PUR-ORDSKU_REV-ORDSKU_REV

This table will contain EDI order revision and order information that relates to the ORDSKU table. Orders submitted from Oracle Retail will be held here, as will as order revisions...

See how this object fits into Purchasing

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

Field Definitions(5)

Rules & Considerations(29)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	REV_NORPK	ORDER_NORPK	ORIGIN_TYPERPK	STATUS	REF_ITEM	REV_DATE	PICKUP_NO	PICKUP_LOC	NON_SCALE_IND	SUPP_PACK_SIZE	LATEST_SHIP_DATE	ORIGIN_COUNTRY_ID	EARLIEST_SHIP_DATE
Example values from field definitions	SAMPLE	1	1	S	1	SAMPLE	2026-01-01	SAMPLE	SAMPLE	S	1.0000	2026-01-01	SAM	2026-01-01
default	Ordsku Rev-002-ALT	4	4	O	0	Ordsku Rev-002-ALT	2026-01-03	Ordsku Rev-002-ALT	Ordsku Rev-002-ALT	N	12.5000	2026-01-03	ALT	2026-01-03
default	Ordsku Rev-003-EDGE	6	6	O	0	Ordsku Rev-003-EDGE	2026-01-05	Ordsku Rev-003-EDGE	Ordsku Rev-003-EDGE	Y	14.0000	2026-01-05	EDG	2026-01-05

Example values from field definitions

ITEMRPK: SAMPLE
REV_NORPK: 1
ORDER_NORPK: 1
ORIGIN_TYPERPK: S
STATUS: 1
REF_ITEM: SAMPLE
REV_DATE: 2026-01-01
PICKUP_NO: SAMPLE
PICKUP_LOC: SAMPLE
NON_SCALE_IND: S
SUPP_PACK_SIZE: 1.0000
LATEST_SHIP_DATE: 2026-01-01
ORIGIN_COUNTRY_ID: SAM
EARLIEST_SHIP_DATE: 2026-01-01

default

ITEMRPK: Ordsku Rev-002-ALT
REV_NORPK: 4
ORDER_NORPK: 4
ORIGIN_TYPERPK: O
STATUS: 0
REF_ITEM: Ordsku Rev-002-ALT
REV_DATE: 2026-01-03
PICKUP_NO: Ordsku Rev-002-ALT
PICKUP_LOC: Ordsku Rev-002-ALT
NON_SCALE_IND: N
SUPP_PACK_SIZE: 12.5000
LATEST_SHIP_DATE: 2026-01-03
ORIGIN_COUNTRY_ID: ALT
EARLIEST_SHIP_DATE: 2026-01-03