EXCHORDERS

Each row in this table represents a relationship between an exchanged Order and its associated return merchandise authorization (RMA).

Column Descriptions:

NameTypeDescription
EX_ORD_IDBIGINT NOT NULLThe identifier associated to the new exchange Order.
RMA_IDBIGINT NOT NULLThe identifier associated to the Return related to this Exchange.
CROSS_SHIPCHAR (1) NOT NULL DEFAULT 'N'A flag that tells if the Exchange has an associated cross shipment. 'Y' means that a cross shipment exists 'N' means that a cross shipment does not exist
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>EX_ORD_ID+RMA_IDPrimary Key
I0001257RMA_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1118EX_ORD_IDORDERSORDERS_IDCascade
F_1119RMA_IDRMARMA_IDCascade