RMA
M_RMA
Return Material Authorization
Overview
| Table Name | M_RMA |
|---|---|
| Access Level | Organization Only |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_Client |
| Wiki | View on iDempiere Wiki |
Columns (46)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
Amt |
Amount(22) | No | - | Amount |
C_BPartner_ID |
Search(22) | Yes | - | Identifies a Business Partner |
C_BPartner_Location_ID |
Table Direct(10) | No | - | Identifies the (ship to) address for this Business Partner |
C_Currency_ID |
Table Direct(22) | No | - | The Currency for this record |
C_DocType_ID |
Table(22) | Yes | -1 | Document type or rules |
CloseDate |
Date(7) | No | - | Close Date |
C_Order_ID |
Search(22) | No | - | Order |
C_POS_ID |
Table Direct(10) | No | - | Point of Sales Terminal |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
CreateFrom |
Button(1) | No | - | Process which will generate a new document lines based on an existing document |
CreateLinesFrom |
Button(1) | No | - | Process which will generate a new document lines based on an existing document |
CurrencyRoundAmt |
Amount(14) | No | 0 | - |
CustomerReturnLocatorBehaviour |
List(3) | No | - | Define Locator behaviour, will be set as default on Return |
DateAuthorized |
Date(7) | Yes | @#Date@ | Date of Authorized |
Description |
String(255) | No | - | Optional short description of the record |
DocAction |
Button(2) | Yes | CO | The targeted status of the document |
DocStatus |
List(2) | Yes | DR | The current status of the document |
GenerateTo |
Button(1) | No | - | Generate To |
GrandTotal |
Amount(131089) | No | - | Total amount of document |
Help |
Text(2000) | No | - | Comment or Hint |
InOut_ID |
Search(22) | No | - | MaterialShipment Document |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsApproved |
Yes-No(1) | Yes | - | Indicates if this document requires approval |
IsSOTrx |
Yes-No(1) | Yes | @IsSOTrx@ | This is a Sales Transaction |
M_RMA_ID |
ID(22) | Yes | - | Return Material Authorization |
M_RMAResolution_ID |
Table Direct(10) | No | - | - |
M_RMAResolutionText |
String(255) | No | - | - |
M_RMAStatus_ID |
Table Direct(10) | No | - | - |
M_RMAType_ID |
Table Direct(22) | Yes | - | Return Material Authorization Type |
M_Warehouse_ID |
Table Direct(10) | No | @#M_Warehouse_ID@ | Storage Warehouse and Service Point |
Name |
String(60) | No | - | Alphanumeric identifier of the entity |
PaymentRule |
Payment(1) | No | - | How you pay the invoice |
POReference |
String(50) | No | - | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner |
Processed |
Yes-No(1) | Yes | - | The document has been processed |
Processing |
Yes-No(1) | No | - | - |
Ref_RMA_ID |
Search(22) | No | - | - |
Returned_C_Order_ID |
Search(10) | No | - | This field links a RMA to the order that is returned from it. |
RMAAuthorizedBy_ID |
Table(10) | No | - | RMA Representative or Company Agent |
SalesRep_ID |
Search(22) | Yes | - | Sales Representative or Company Agent |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
DocumentNo |
String(30) | Yes | - | Document sequence number of the document |
M_RMA_UU |
String(36) | No | - | - |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
C_BPartner_ID |
C_BPartner.C_BPartner_ID | Identifies a Business Partner |
C_BPartner_Location_ID |
C_BPartner_Location.C_BPartner_Location_ID | Identifies the (ship to) address for this Business Partner |
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
C_DocType_ID |
C_DocType.C_DocType_ID | Document type or rules |
C_Order_ID |
C_Order.C_Order_ID | Order |
C_POS_ID |
C_POS.C_POS_ID | Point of Sales Terminal |
InOut_ID |
InOut.InOut_ID | MaterialShipment Document |
M_RMAResolution_ID |
M_RMAResolution.M_RMAResolution_ID | - |
M_RMAStatus_ID |
M_RMAStatus.M_RMAStatus_ID | - |
M_RMAType_ID |
M_RMAType.M_RMAType_ID | Return Material Authorization Type |
M_Warehouse_ID |
M_Warehouse.M_Warehouse_ID | Storage Warehouse and Service Point |
Ref_RMA_ID |
Ref_RMA.Ref_RMA_ID | - |
Returned_C_Order_ID |
Returned_C_Order.Returned_C_Order_ID | This field links a RMA to the order that is returned from it. |
RMAAuthorizedBy_ID |
RMAAuthorizedBy.RMAAuthorizedBy_ID | RMA Representative or Company Agent |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
Generated on 2026-05-03T16:41:04.889671188Z