-
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. This table corresponds to the Return entity in the Entity Model.
|
|
|
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
RMAID (PK) RETURNID in the Entity Model |
STANDARDID(12) |
NOT NULL |
RMA_RMAID_PK (CA) |
(One) to (Many) |
|
|
(One) to (Many) |
|||||
|
(One) to (Many) |
|||||
| (One) to (Many) | ERPRETURNPRODUCT.RETURNID | ||||
|
(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) RETURNADDRESSID in Entity Model |
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 |
|
|
|
| ERPRETURNNUMBER |
varchar(100) |
NULLS | |||
| ERPDOCUMENTDATE | datetime(8) | NULLS | |||
| ERPEXTID |
varchar(100) |
NULLS | |||
| ERPACCOUNTINGENTITYID |
varchar(22) |
NULLS | |||
| ERPLOGICALID |
varchar(255) |
NULLS | |||
| ERPLOCATION |
varchar(22) |
NULLS | |||
| ERPDOCREFTYPE |
varchar(100) |
NULLS | |||
| ERPDOCREF |
varchar(100) |
NULLS | |||
| ERPDOCREFACCTENTITYID |
varchar(22) |
NULLS | |||
| ERPDOCLOCATION |
varchar(22) |
NULLS | |||
| ERPEXTENDEDAMOUNT |
float |
NULLS | |||
| ERPSHIPTOID |
varchar(12) |
NULLS | ERPSHIPTO.ERPSHIPTOID | ||
| ERPSTATUS |
varchar(64) |
NULLS | |||
| ERPGRANDTOTAL |
float |
NULLS | |||
| ERPUNIQUEID |
varchar(377) |
NULLS | |||
| ERPBILLTOID |
varchar(12) |
NULLS | (Many) to (One) | ERPBILLTO.ERPBILLTOID | |
| ERPCARRIERPARTY |
varchar(64) |
NULLS | |||
| PROMISEDRETURNDATE |
datetime(8) |
NULLS | |||
| REQUIREDRETURNDATE |
datetime(8) |
NULLS | |||
| RETURNREASONCODE |
varchar(64) |
NULLS | |||
| ERPVARIATIONID |
varchar(22) |
NULLS | |||
| SLXLOCATIONID (FK) |
varchar(12) |
NULLS | (One) to (Many) | SLXLOCATION.SLXLOCATIONID | |
| PROMISEDSHIPDATE |
datetime(8) |
NULLS | |||
| BILLINGADDRESSID (FK) |
varchar(12) |
NULLS | (Many) to (One) |
RETURNADDRESS in the Entity Model |
|
| SHIPPINGADDRESSID (FK) |
varchar(12) |
NULLS | (Many) to (One) | ||
| ERPINCOTERM |
varchar(64) |
NULLS | |||
| ERPLASTMODIFIEDDATE |
datetime(8) |
NULLS | |||
| CURRENCYCODE |
varchar(64) |
NULLS | |||
| BASECURRENCYCODE |
varchar(64) |
NULLS | |||
| ERPEXTENDEDBASEAMOUNT |
float |
NULLS | |||
| ERPBASECURRENCYAMOUNT |
float |
NULLS | |||
| ERPTOTALBASEAMOUNT |
float |
NULLS | |||
| CARRIERID | varchar(12) | NULLS | (One) to (Many) | CARRIER.CARRIERID | |
|
ERPNOTES |
text |
NULLS |
|||
|
ISNORMALIZED |
nchar(12) |
NULLS |