m_rmaline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_rmaline_id numeric 10 null
c_invoiceline.m_rmaline_id mrmaline_cinvoiceline R
m_inout_line_v.m_rmaline_id Implied Constraint R
m_inout_line_vt.m_rmaline_id Implied Constraint R
m_inoutline.m_rmaline_id mrmaline_minoutline R
m_rmaline.ref_rmaline_id refrmaline_mrmaline R
rv_c_invoiceline.m_rmaline_id Implied Constraint R
rv_commissionrundetail.c_invoiceline_m_rmaline_id Implied Constraint R
rv_inoutdetails.m_rmaline_id Implied Constraint R
rv_transaction.m_inoutline_m_rmaline_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
m_rma_id numeric 10 null
m_rma.m_rma_id mrma_mrmaline C
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutline_mrmaline R
qty numeric 0 0
description varchar 255 √ null
processed bpchar 1 'N'::bpchar
amt numeric 0 √ null
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_mrmaline R
line numeric 10 0
linenetamt numeric 0 √ null
qtydelivered numeric 0 √ null
qtyinvoiced numeric 0 √ null
ref_rmaline_id numeric 10 √ NULL::numeric
m_rmaline.m_rmaline_id refrmaline_mrmaline R
m_rmaline_uu varchar 36 √ NULL::character varying
c_tax_id numeric 10 NULL::numeric
c_tax.c_tax_id ctax_mrmaline R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id mproduct_mrmaline R
lbr_tax_id numeric 10 √ NULL::numeric
lbr_tax.lbr_tax_id Implied Constraint R
lbr_recalculatetax bpchar 1 'N'::bpchar
cof_pdevol numeric 0 √ null
cof_sourceqty numeric 0 √ null

Indexes

Constraint Name Type Sort Column(s)
m_rmaline_pkey Primary key Asc m_rmaline_id
m_rmaline_uu_idx Must be unique Asc m_rmaline_uu

Check Constraints

Constraint Name Constraint
m_rmaline_lbr_recalculatetax_check ((lbr_recalculatetax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation