m_rmaline

-1 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_inoutline.m_rmaline_id mrmaline_minoutline R
m_rmaline.ref_rmaline_id refrmaline_mrmaline 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_recalculatetax bpchar 1 'N'::bpchar
cof_pdevol numeric 0 √ null
cof_sourceqty numeric 0 √ null
cof_mprecebida_id numeric 10 √ NULL::numeric
cof_mprecebida.cof_mprecebida_id cofmprecebida_mrmaline R

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