m_attributesetinstance

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_attributesetinstance_id numeric 10 null
a_asset.m_attributesetinstance_id mattributesetinstance_aasset R
a_asset_addition.m_attributesetinstance_id mattributesetinstance_aassetad R
a_asset_product.m_attributesetinstance_id mattributesetinstance_aassetpr R
c_invoiceline.m_attributesetinstance_id mattrsetinst_cinvoiceline R
c_landedcostallocation.m_attributesetinstance_id masi_clandedcostallocation R
c_orderline.m_attributesetinstance_id mattrsetinst_corderline R
c_projectissue.m_attributesetinstance_id mattrsetinst_cprojectissue R
c_projectissuema.m_attributesetinstance_id masi_cprojectissuema R
c_rfqline.m_attributesetinstance_id masetinstance_crfqline R
cof_ajusteqtdcontabil.m_attributesetinstance_id mattributesetinstance_cofajust R
cof_label.m_attributesetinstance_id mattributesetinstance_coflabel R
cof_mprecebida.m_attributesetinstance_id mattributesetinstance_cofmprecebida R
cof_ordemservico.m_attributesetinstance_id mattributesetinstance_cofordem R
dd_orderline.m_attributesetinstance_id mattributesetinstance_ddorderl R
dd_orderline.m_attributesetinstanceto_id mattributesetinstanceto_ddorde R
i_asset.m_attributesetinstance_id mattributesetinstance_iasset R
m_bomproduct.m_attributesetinstance_id masi_mbomproduct R
m_cost.m_attributesetinstance_id masi_mcost C
m_costdetail.m_attributesetinstance_id masi_mcostdetail R
m_costhistory.m_attributesetinstance_id mattributesetinstance_mcosthis R
m_costqueue.m_attributesetinstance_id masi_mcostqueue C
m_inoutline.m_attributesetinstance_id mattrsetinst_minoutline R
m_inoutlinema.m_attributesetinstance_id masi_minourlinema C
m_inventoryline.m_attributesetinstance_id mattrsetinst_minventoryline R
m_inventorylinema.m_attributesetinstance_id masi_minventorylinema C
m_matchinv.m_attributesetinstance_id mattributesetinstance_mmatchin R
m_matchpo.m_attributesetinstance_id mattributesetinstance_mmatchpo R
m_movementline.m_attributesetinstance_id mattrsetinst_mmovementline R
m_movementline.m_attributesetinstanceto_id mattributesetinstanceto_mmovem R
m_movementlinema.m_attributesetinstance_id masi_mmovementlinema C
m_productionline.m_attributesetinstance_id mattrsetinst_mproductionline R
m_productionlinema.m_attributesetinstance_id masi_mproductionlinema C
m_qualitytestresult.m_attributesetinstance_id mattributesetinstance_mquality R
m_requisitionline.m_attributesetinstance_id mattributesetinstance_mrequisi R
m_storageonhand.m_attributesetinstance_id mattributesetinstance_mstoraoh R
m_storagereservation.m_attributesetinstance_id mattributesetinstance_mstorare R
m_storagereservationlog.m_attributesetinstance_id mattributesetinstance_mstorage R
m_transaction.m_attributesetinstance_id mattrsetinst_mtransaction R
m_transactionallocation.m_attributesetinstance_id mattributesetinst_mtrxalloc R
pp_cost_collector.m_attributesetinstance_id mattributesetinstance_ppcostco R
pp_cost_collectorma.m_attributesetinstance_id mattributesetinstance_ppcostma R
pp_order.m_attributesetinstance_id mattributesetinstance_pporder R
pp_order_bom.m_attributesetinstance_id mattributesetinstance_pporderb R
pp_order_bomline.m_attributesetinstance_id mattributesetinstance_ppordbl R
pp_order_cost.m_attributesetinstance_id mattributesetinstance_pporderc R
pp_product_bom.m_attributesetinstance_id mattributesetinstance_ppproduc R
pp_product_bomline.m_attributesetinstance_id mattributesetinstance_ppprodbl R
t_inventorytrxsummary.m_attributesetinstance_id mattributesetinstance_tinvento R
t_inventoryvalue.m_attributesetinstance_id masi_tinventoryvalue C
t_transaction.m_attributesetinstance_id masi_ttransaction C
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_attributeset_id numeric 10 √ null
m_attributeset.m_attributeset_id mattributeset_mattribsetinst R
serno varchar 40 √ null
lot varchar 40 √ null
guaranteedate timestamp 29,6 √ null
description varchar 1023 √ null
m_lot_id numeric 10 √ null
m_lot.m_lot_id mlot_mattributesetinstance R
m_attributesetinstance_uu varchar 36 √ NULL::character varying
movementdate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
m_attributesetinstance_pkey Primary key Asc m_attributesetinstance_id
m_attributesetinstance_uu_idx Must be unique Asc m_attributesetinstance_uu

Check Constraints

Constraint Name Constraint
m_attributesetinstance_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation