RMA Line
M_RMALine
Return Material Authorization Line
Overview
| Table Name | M_RMALine |
|---|---|
| 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 (28)
| 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 |
C_Charge_ID |
Table Direct(22) | No | - | Additional document charges |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
C_Tax_ID |
Table Direct(10) | Yes | - | Tax identifier |
Description |
String(255) | No | - | Optional short description of the record |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
M_Product_ID |
Search(10) | No | - | Product, Service, Item |
M_RMALine_ID |
ID(22) | Yes | - | Return Material Authorization Line |
M_RMAResolution_ID |
Table Direct(10) | No | - | - |
M_RMAResolutionText |
String(255) | No | - | - |
M_RMAStatus_ID |
Table Direct(10) | No | - | - |
Processed |
Yes-No(1) | Yes | - | The document has been processed |
Qty |
Quantity(22) | Yes | - | Quantity |
QtyDelivered |
Quantity(22) | No | - | Delivered Quantity |
QtyInvoiced |
Quantity(22) | No | 0 | Invoiced Quantity |
QtyToInvoice |
Quantity(22) | No | 0 | - |
Ref_RMALine_ID |
ID(22) | No | - | - |
Returned_C_OrderLine_ID |
Search(10) | No | - | This field links a RMA to the order line that is returned from it. |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
M_RMA_ID |
Search(22) | Yes | - | Return Material Authorization |
M_InOutLine_ID |
Search(22) | No | - | Line on Shipment or Receipt document |
Line |
Integer(22) | No | @SQL=SELECT NVL(MAX(Line),0)+10 AS DefaultValue FROM M_RMALine WHERE M_RMA_ID=@M_RMA_ID@ | Unique line for this document |
Amt |
Amount(22) | No | - | Amount |
LineNetAmt |
Amount(22) | No | - | Line Extended Amount (Quantity x Actual Price) without Freight and Charges |
M_RMALine_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_Charge_ID |
C_Charge.C_Charge_ID | Additional document charges |
C_Tax_ID |
C_Tax.C_Tax_ID | Tax identifier |
M_Product_ID |
M_Product.M_Product_ID | Product, Service, Item |
M_RMAResolution_ID |
M_RMAResolution.M_RMAResolution_ID | - |
M_RMAStatus_ID |
M_RMAStatus.M_RMAStatus_ID | - |
Ref_RMALine_ID |
Ref_RMALine.Ref_RMALine_ID | - |
Returned_C_OrderLine_ID |
Returned_C_OrderLine.Returned_C_OrderLine_ID | This field links a RMA to the order line that is returned from it. |
M_RMA_ID |
M_RMA.M_RMA_ID | Return Material Authorization |
M_InOutLine_ID |
M_InOutLine.M_InOutLine_ID | Line on Shipment or Receipt document |
Generated on 2026-05-03T16:42:05.121097229Z