This table contains detailed information about
items on an expected inventory record.
Column Descriptions:
| Name | Type | Description |
| RADETAIL_ID | BIGINT NOT NULL | Unique identifier. |
| RA_ID | BIGINT NOT NULL | Expected inventory record identifier. |
| FFMCENTER_ID | INTEGER | FulfillmentCenter identifier. |
| ITEMSPC_ID | BIGINT NOT NULL | Item identifier. |
| QTYORDERED | INTEGER NOT NULL DEFAULT 0 | Quantity ordered from vendor in this expected
inventory record. |
| QTYRECEIVED | INTEGER NOT NULL DEFAULT 0 | Quantity received to date from the vendor for
this expected inventory record. |
| QTYREMAINING | INTEGER NOT NULL DEFAULT 0 | Quantity still expected from vendor for this
expected inventory record. This quantity should usually be equal to
the quantity ordered minus the quantity received. But it could be
different if the vendor is unable to ship the total quantity. |
| QTYALLOCATED | INTEGER NOT NULL DEFAULT 0 | Quantity of expected inventory that has been
allocated to backorders. |
| EXPECTEDDATE | TIMESTAMP NOT NULL | Date the inventory is expected. |
| RADETAILCOMMENT | VARCHAR (254) | Comment. |
| LASTUPDATE | TIMESTAMP | Timestamp of last update. |
| MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if this row has been marked for
deletion:
0 = No.
1 = Yes, this row has been marked for deletion and should not
be used. |
| 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> | RADETAIL_ID | Primary Key |
| I0000201 | RA_ID+FFMCENTER_ID+ITEMSPC_ID+EXPECTEDDATE | Unique Index |
| I0000202 | RA_ID+RADETAIL_ID+EXPECTEDDATE | Non-Unique Index |
| I0000712 | ITEMSPC_ID | Non-Unique Index |
| I0000713 | FFMCENTER_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_655 | FFMCENTER_ID | FFMCENTER | FFMCENTER_ID | Cascade |
| F_656 | ITEMSPC_ID | ITEMSPC | ITEMSPC_ID | Cascade |
| F_657 | RA_ID | RA | RA_ID | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_652 | RADETAIL_ID | RABACKALLO | RADETAIL_ID | Cascade |
| F_660 | RADETAIL_ID | RECEIPT | RADETAIL_ID | Cascade |