WebSphere Commerce database table: EXCHORDERS

WebSphere Commerce database table: EXCHORDERS

IBM Internal Use Only.

Column Descriptions
Column Name Column Type Description

EX_ORD_ID BIGINT NOT NULL IBM Internal Use Only.

RMA_ID BIGINT NOT NULL IBM Internal Use Only.

CROSS_SHIP CHAR(1) NOT NULL DEFAULT 'N' IBM Internal Use Only

OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235156740 EX_ORD_ID+RMA_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type

F_1118 EX_ORD_ID ORDERS ORDERS_ID Cascade

F_1119 RMA_ID RMA RMA_ID Cascade

Column Name	Column Type	Description
EX_ORD_ID	BIGINT NOT NULL	IBM Internal Use Only.
RMA_ID	BIGINT NOT NULL	IBM Internal Use Only.
CROSS_SHIP	CHAR(1) NOT NULL DEFAULT 'N'	IBM Internal Use Only
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1118	EX_ORD_ID	ORDERS	ORDERS_ID	Cascade
F_1119	RMA_ID	RMA	RMA_ID	Cascade