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 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.
Indexes:
Index Name Indexed Column Names Index Type
I0000200 STORE_ID, VENDOR_ID, CREATETIME Unique Index
SQL030416035047480 RA_ID Primary Key
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