Records general information about inventory expected from a vendor. "RA" stands for Replenishment Advisement. However, the term "Expected Inventory Record" is used to mean the same thing.
Column Name | Column Type | Column Description |
---|---|---|
CREATETIME | TIMESTAMP NOT NULL |
The date and time the row was created. |
DATECLOSED | TIMESTAMP NULL |
The date this record was closed. |
EXTERNALID | CHARACTER (20) NULL |
An external identifier, usually supplied by the vendor, that can be used to reference this record. |
LASTUPDATE | TIMESTAMP NULL |
The time of the 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. |
OPENINDICATOR | CHARACTER (1) NULL |
Y = Expected inventory may still be received and allocated to backorders. N = No further inventory will be received. Expected inventory may not be allocated to backorders. |
ORDERDATE | TIMESTAMP NOT NULL |
Date the order was created with the vendor. |
RA_ID | BIGINT NOT NULL |
Unique identifier. |
STORE_ID | INTEGER NOT NULL |
The Store that owns the order. |
VENDOR_ID | BIGINT NOT NULL |
Vendor that will be supplying the inventory for the order. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000200 | STORE_ID, VENDOR_ID, CREATETIME | Unique Index |
SQL030416035047480 | RA_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_650 | STORE_ID | STORE | STORE_ID | Cascade |
F_651 | VENDOR_ID | VENDOR | VENDOR_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_657 | RA_ID | RADETAIL | RA_ID | Cascade |