Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: RA
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 Description RA_ID BIGINT NOT NULL Unique identifier. VENDOR_ID BIGINT NOT NULL Vendor that will be supplying the inventory for the order. STORE_ID INTEGER NOT NULL The Store that owns the order. ORDERDATE TIMESTAMP NOT NULL Date the order was created with the vendor. OPENINDICATOR CHAR(1) 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. DATECLOSED TIMESTAMP The date this record was closed. LASTUPDATE TIMESTAMP The time of the last update. EXTERNALID CHAR(20) An external identifier, usually supplied by the vendor, that can be used to reference this record. 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.CREATETIME TIMESTAMP NOT NULL The date and time the row was created. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000200 STORE_ID+VENDOR_ID+CREATETIME Unique Index SQL100520030420570 RA_ID Primary Key I0001275 VENDOR_ID Non-Unique Index
Constraints 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_657 RA_ID RADETAIL RA_ID Cascade
Related reference
_vcc_freeselect_bottom_