Ordloc

In Scope

Technical: ORDLOC | ID: OR-PUR-ORDLOC-ORDLOC

Stores one row for each order/SKU/store or warehouse combination that has been placed by the company. When an order header is purged all associated rows in this table are also...

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

Field Definitions(5)

Rules & Considerations(41)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	LOCATIONRPK	LOC_TYPER	ORDER_NORPK	UNIT_RETAILR	CANCEL_ID	CREATE_ID	UNIT_COST	CANCEL_CODE	CANCEL_DATE	COST_SOURCE	QTY_ORDERED	QTY_RECEIVED	LAST_RECEIVED	NON_SCALE_IND	QTY_CANCELLED	QTY_PRESCALED	LAST_UPDATE_ID	TSF_PO_LINK_NO	UNIT_COST_INIT	CREATE_DATETIME	LAST_ROUNDED_QTY	UNIT_COST_BACKUP	ORIGINAL_REPL_QTY	LAST_GRP_ROUNDED_QTY	LAST_UPDATE_DATETIME	ESTIMATED_INSTOCK_DATE
Example values from field definitions	SAMPLE	1	S	1	1.0000	SAMPLE	SAMPLE	1.0000	S	2026-01-01	SAMP	1.0000	1.0000	1.0000	S	1.0000	1.0000	SAMPLE	1	1.0000	2026-01-01	1.0000	1.0000	1.0000	1.0000	2026-01-01	2026-01-01
default	Ordloc-002-ALT	3	S	4	12.5000	ALT-ORDLOC-002	C LIENT_INFO	12.5000	A	2026-01-03	NORM	12.5000	12.5000	12.5000	N	12.5000	12.5000	C LIENT_INFO	4	12.5000	2026-01-03	12.5000	12.5000	12.5000	12.5000	2026-01-03	2026-01-03
default	Ordloc-003-EDGE	5	S	6	14.0000	EDGE-ORDLOC-003	USE RENV	14.0000	E	2026-01-05	NORM	14.0000	14.0000	14.0000	Y	14.0000	14.0000	USE RENV	6	14.0000	2026-01-05	14.0000	14.0000	14.0000	14.0000	2026-01-05	2026-01-05

Example values from field definitions

ITEMRPK: SAMPLE
LOCATIONRPK: 1
LOC_TYPER: S
ORDER_NORPK: 1
UNIT_RETAILR: 1.0000
CANCEL_ID: SAMPLE
CREATE_ID: SAMPLE
UNIT_COST: 1.0000
CANCEL_CODE: S
CANCEL_DATE: 2026-01-01
COST_SOURCE: SAMP
QTY_ORDERED: 1.0000
QTY_RECEIVED: 1.0000
LAST_RECEIVED: 1.0000
NON_SCALE_IND: S
QTY_CANCELLED: 1.0000
QTY_PRESCALED: 1.0000
LAST_UPDATE_ID: SAMPLE
TSF_PO_LINK_NO: 1
UNIT_COST_INIT: 1.0000
CREATE_DATETIME: 2026-01-01
LAST_ROUNDED_QTY: 1.0000
UNIT_COST_BACKUP: 1.0000
ORIGINAL_REPL_QTY: 1.0000
LAST_GRP_ROUNDED_QTY: 1.0000
LAST_UPDATE_DATETIME: 2026-01-01
ESTIMATED_INSTOCK_DATE: 2026-01-01

default

ITEMRPK: Ordloc-002-ALT
LOCATIONRPK: 3
LOC_TYPER: S
ORDER_NORPK: 4
UNIT_RETAILR: 12.5000
CANCEL_ID: ALT-ORDLOC-002
CREATE_ID: C LIENT_INFO
UNIT_COST: 12.5000
CANCEL_CODE: A
CANCEL_DATE: 2026-01-03
COST_SOURCE: NORM
QTY_ORDERED: 12.5000
QTY_RECEIVED: 12.5000
LAST_RECEIVED: 12.5000
NON_SCALE_IND: N
QTY_CANCELLED: 12.5000
QTY_PRESCALED: 12.5000
LAST_UPDATE_ID: C LIENT_INFO
TSF_PO_LINK_NO: 4
UNIT_COST_INIT: 12.5000
CREATE_DATETIME: 2026-01-03
LAST_ROUNDED_QTY: 12.5000
UNIT_COST_BACKUP: 12.5000
ORIGINAL_REPL_QTY: 12.5000
LAST_GRP_ROUNDED_QTY: 12.5000
LAST_UPDATE_DATETIME: 2026-01-03
ESTIMATED_INSTOCK_DATE: 2026-01-03