-
The RMA table has related tables for products received and products shipped.
The RMA table stores information on Return agreements with customers. This information is entered using the Infor CRM and includes the Account ID, shipping instructions such as how to ship, who to ship to, submitting date, person submitting, and other details.
|
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
RMAID (PK) |
STANDARDID(12) |
NOT NULL |
RMA_RMAID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
|
SHIPVIACODE (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
ACCOUNTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
RMADATE |
datetime(8) |
NULLS |
|
|
|
|
SUBMITTEDBY (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
TICKETID (FK) |
STANDARDID(12) |
NULLS |
RMA_TICKETID (IE) |
(Many) to (One) |
|
|
SHIPTOADDRESSID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
CLOSED |
BOOLEAN(1) |
NULLS |
|
|
|
|
CLOSEDDATE |
datetime |
NULLS |
|
|
|
|
PHONENUMBER |
varchar(32) |
NULLS |
|
|
|
|
SHORTRMANOTES |
varchar(255) |
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 |
|
|
|
|
RETURNEDBYCONTACTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
NOTES |
TEXTBLOB |
NULLS |
|
|
|
|
USERFIELD1 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD2 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD3 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD4 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD5 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD6 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD7 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD8 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD9 |
varchar(80) |
NULLS |
|
|
|
|
USERFIELD10 |
varchar(80) |
NULLS |
|
|
|
|
ALTERNATEKEYPREFIX |
varchar(8) |
NULLS |
RMA_ALTERNATEKEYPREFIX (IE) |
|
|
|
ALTERNATEKEYSUFFIX |
varchar(24) |
NULLS |
RMA_ALTERNATEKEYSUFFIX (IE) |
|
|
|
SHIPTOCONTACTID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
SHIPTOATTENTION |
varchar(80) |
NULLS |
|
|
|
|
SHIPTONAME |
varchar(80) |
NULLS |
|
|
|
|
RETURNBYADDRESSID (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
SHIPTRACKINGNUMBER |
varchar(32) |
NULLS |
|
|
|
|
RETURNDETAILNOTES |
text(16) |
NULLS |
|
|
|
|
PRIORITY |
varchar(32) |
NULLS |
|
|
|
|
STATUS |
varchar(32) |
NULLS |
|
|
|
|
RETURNTYPE |
varchar(32) |
NULLS |
|
|
|
|
SECCODEID (FK) |
char(12) |
NULLS |
|
|
|
|
EXPECTEDDATE |
datetime(8) |
NULLS |
|
|
|
|
ASSIGNEDTO (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
ASSIGNEDDATE |
datetime(8) |
NULLS |
|
|
|
|
CUSTOMERPO |
varchar(32) |
NULLS |
|
|
|
|
REASON |
varchar(64) |
NULLS |
|
|
|
|
CLOSEDBY (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATESOURCE |
varchar(64) |
NULLS |
|
|
|