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

NameTypeDescription
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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>RA_IDPrimary Key
I0000200STORE_ID+VENDOR_ID+CREATETIMEUnique Index
I0001275VENDOR_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_650STORE_IDSTORESTORE_IDCascade
F_651VENDOR_IDVENDORVENDOR_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_657RA_IDRADETAILRA_IDCascade