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 Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000200 |
STORE_ID+VENDOR_ID+CREATETIME |
Unique Index |
SQL050212031303470 |
RA_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 Name(s) | Constraint Type |
F_657 |
RA_ID |
RADETAIL |
RA_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.