The RMASHIPPEDPRODUCT table stores information on the products shipped for Returns. This information is entered using Infor CRMand contains the account product ID, shipping description, ship date, and the product ID.
|
Field |
Datatype(Length) |
Allow Nulls |
Indexes |
Relationship |
Related Table and Field |
|
RMASHIPPEDPRODUCTID (PK) |
STANDARDID(12) |
NOT NULL |
RMASHIPPEDPRODUCT_ID_PK (AK) |
|
|
|
RMAID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
RMARECEIVEDPRODUCTID (FK) |
STANDARDID(12) |
NULLS |
RMASHIPPEDPRODUCT_RMAIRECEIVEDPRODUCTID (CA) |
(Many) to (One) |
RMARECEIVEDPRODUCT.RMARECEIVEDPRODUCTID |
|
ACCOUNTPRODUCTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
SHIPPEDDESC |
varchar(80) |
NULLS |
|
|
|
|
SHIPPEDDATE |
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 |
|
|
|
|
RETURNEDEXISTING |
BOOLEAN(1) |
NULLS |
|
|
|
|
PRODUCTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
SHIPPED |
char(1) |
NULLS |
|
|
|
|
SHIPPEDBY (FK) |
char(12) |
NULLS |
|
(Many) to (One) |