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_project_details_v.m_attributesetinstance_id Implied Constraint R
c_project_details_vt.m_attributesetinstance_id Implied Constraint 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
c_rfqresponseline_v.m_attributesetinstance_id Implied Constraint R
c_rfqresponseline_vt.m_attributesetinstance_id Implied Constraint R
cof_ajusteqtdcontabil.m_attributesetinstance_id mattributesetinstance_cofajust R
cof_label.m_attributesetinstance_id mattributesetinstance_coflabel R
cof_ordemservico.m_attributesetinstance_id mattributesetinstance_cofordem R
cof_rv_detalhesmovimentocusto.m_attributesetinstance_id Implied Constraint R
cof_rv_detalhesordemservico.m_attributesetinstance_id Implied Constraint R
cof_rv_detalhesordemservicoapontamento.m_attributesetinstance_id Implied Constraint R
cof_rv_detalhesproducao.m_attributesetinstance_id Implied Constraint R
cof_rv_docfiscal.m_attributesetinstance_id Implied Constraint R
cof_rv_ordemservico.m_attributesetinstance_id Implied Constraint R
cof_rv_productsmanufacturedandsold.m_attributesetinstance_id Implied Constraint R
cof_selection.m_attributesetinstance_id Implied Constraint 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
i_inout.m_attributesetinstance_id Implied Constraint R
lbr_docfiscal_line.m_attributesetinstance_id Implied Constraint 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_costmovement_v.m_attributesetinstance_id Implied Constraint R
m_costqueue.m_attributesetinstance_id masi_mcostqueue C
m_inout_line_v.m_attributesetinstance_id Implied Constraint R
m_inout_line_vt.m_attributesetinstance_id Implied Constraint R
m_inout_lineconfirm_v.m_attributesetinstance_id Implied Constraint R
m_inout_lineconfirm_vt.m_attributesetinstance_id Implied Constraint R
m_inoutline.m_attributesetinstance_id mattrsetinst_minoutline R
m_inoutlinema.m_attributesetinstance_id masi_minourlinema C
m_inoutlinema_returned.m_attributesetinstance_id Implied Constraint R
m_inoutlinema_v.m_attributesetinstance_id Implied Constraint R
m_inoutlinema_vt.m_attributesetinstance_id Implied Constraint R
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_movementlinema_v.m_attributesetinstance_id Implied Constraint R
m_movementlinema_vt.m_attributesetinstance_id Implied Constraint R
m_product.m_attributesetinstance_id Implied Constraint R
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_rma_createfrom_v.m_attributesetinstance_id Implied Constraint R
m_storage.m_attributesetinstance_id Implied Constraint 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_transaction_v.m_attributesetinstance_id Implied Constraint 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_bom_header_v.m_attributesetinstance_id Implied Constraint R
pp_order_bom_header_vt.m_attributesetinstance_id Implied Constraint R
pp_order_bomline.m_attributesetinstance_id mattributesetinstance_ppordbl R
pp_order_bomline_v.m_attributesetinstance_id Implied Constraint R
pp_order_bomline_vt.m_attributesetinstance_id Implied Constraint R
pp_order_cost.m_attributesetinstance_id mattributesetinstance_pporderc R
pp_order_header_v.m_attributesetinstance_id Implied Constraint R
pp_order_header_vt.m_attributesetinstance_id Implied Constraint R
pp_product_bom.m_attributesetinstance_id mattributesetinstance_ppproduc R
pp_product_bomline.m_attributesetinstance_id mattributesetinstance_ppprodbl R
pp_product_bomline_v.m_attributesetinstance_id Implied Constraint R
pp_product_bomline_vt.m_attributesetinstance_id Implied Constraint R
rv_c_invoiceline.m_attributesetinstance_id Implied Constraint R
rv_c_rfqresponse.m_attributesetinstance_id Implied Constraint R
rv_cof_detalhesestoquefisico.m_attributesetinstance_id Implied Constraint R
rv_cost.m_attributesetinstance_id Implied Constraint R
rv_costdetail.m_attributesetinstance_id Implied Constraint R
rv_dd_orderdetail.m_attributesetinstance_id Implied Constraint R
rv_inoutdetails.m_attributesetinstance_id Implied Constraint R
rv_inoutlineconfirm.m_attributesetinstance_id Implied Constraint R
rv_m_transaction.m_attributesetinstance_id Implied Constraint R
rv_orderdetail.m_attributesetinstance_id Implied Constraint R
rv_pp_order.m_attributesetinstance_id Implied Constraint R
rv_pp_order_receipt_issue.m_attributesetinstance_id Implied Constraint R
rv_pp_order_storage.m_attributesetinstance_id Implied Constraint R
rv_pp_product_bomline.m_attributesetinstance_id Implied Constraint R
rv_storage.m_attributesetinstance_id Implied Constraint R
rv_transaction.m_attributesetinstance_id Implied Constraint R
t_bomline_costs.m_attributesetinstance_id Implied Constraint 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 255 √ 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