The RMARECEIVEDPRODUCT table stores information on the products received for Returns.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
RMARECEIVEDPRODUCTID (PK) |
STANDARDID(12) |
NOT NULL |
RMARECEIVEDPRODUCT_ID_PK (AK) |
(One) to (Many) |
|
|
RMAID (FK) |
STANDARDID(12) |
NOT NULL |
RMARECEIVEDPRODUCT_RMAID (CA) |
(Many) to (One) |
|
|
ACCOUNTPRODUCTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
RECEIVEDDESC |
varchar(80) |
NULLS |
|
|
|
|
RECEIVEDDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
RECEIVED |
char(1) |
NULLS |
|
|
|
|
RECEIVEDBY (FK) |
char(12) |
NULLS |
|
(Many) to (One) |