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 |