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 Descriptions:

RA_IDBIGINT NOT NULLUnique identifier.
VENDOR_IDBIGINT NOT NULLVendor that will be supplying the inventory for the order.
STORE_IDINTEGER NOT NULLThe Store that owns the order.
ORDERDATETIMESTAMP NOT NULLDate the order was created with the vendor.
OPENINDICATORCHAR (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.
DATECLOSEDTIMESTAMPThe date this record was closed.
LASTUPDATETIMESTAMPThe time of the last update.
EXTERNALIDCHAR (20)An external identifier, usually supplied by the vendor, that can be used to reference this record.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this row has been marked for deletion: 0 = No. 1 = Yes, this row has been marked for deletion and should not be used.
CREATETIMETIMESTAMP NOT NULLThe date and time the row was created.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0001275VENDOR_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType