Each row in this table represents a relationship
between an exchanged Order and its associated return merchandise
authorization (RMA).
Column Descriptions:
Name | Type | Description |
EX_ORD_ID | BIGINT NOT NULL | The identifier associated to the new exchange
Order. |
RMA_ID | BIGINT NOT NULL | The identifier associated to the Return related
to this Exchange. |
CROSS_SHIP | CHAR (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 |
OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | EX_ORD_ID+RMA_ID | Primary Key |
I0001257 | RMA_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_1118 | EX_ORD_ID | ORDERS | ORDERS_ID | Cascade |
F_1119 | RMA_ID | RMA | RMA_ID | Cascade |