| cacctschema_mcost |
m_cost.c_acctschema_id |
c_acctschema.c_acctschema_id |
Cascade on delete |
| cacctschema_mcostdetail |
m_costdetail.c_acctschema_id |
c_acctschema.c_acctschema_id |
Restrict delete |
| cacctschema_mcostqueue |
m_costqueue.c_acctschema_id |
c_acctschema.c_acctschema_id |
Cascade on delete |
| cacctschema_mprodcatacct |
m_product_category_acct.c_acctschema_id |
c_acctschema.c_acctschema_id |
Cascade on delete |
| cacctschema_mproductacct |
m_product_acct.c_acctschema_id |
c_acctschema.c_acctschema_id |
Cascade on delete |
| cacctschema_mwarehouseacct |
m_warehouse_acct.c_acctschema_id |
c_acctschema.c_acctschema_id |
Cascade on delete |
| ccostelement_clandedcost |
c_landedcost.m_costelement_id |
m_costelement.m_costelement_id |
Restrict delete |
| cinvoice_callocationline |
c_allocationline.c_invoice_id |
c_invoice.c_invoice_id |
Restrict delete |
| cinvoice_cinvoiceline |
c_invoiceline.c_invoice_id |
c_invoice.c_invoice_id |
Cascade on delete |
| cinvoice_minout |
m_inout.c_invoice_id |
c_invoice.c_invoice_id |
Restrict delete |
| cinvoice_ref |
c_invoice.ref_invoice_id |
c_invoice.c_invoice_id |
Restrict delete |
| cinvoiceline_clandedcost |
c_landedcost.c_invoiceline_id |
c_invoiceline.c_invoiceline_id |
Cascade on delete |
| cinvoiceline_clandedcostalloc |
c_landedcostallocation.c_invoiceline_id |
c_invoiceline.c_invoiceline_id |
Restrict delete |
| cinvoiceline_mmatchpo |
m_matchpo.c_invoiceline_id |
c_invoiceline.c_invoiceline_id |
Restrict delete |
| convoiceline_mmatchinv |
m_matchinv.c_invoiceline_id |
c_invoiceline.c_invoiceline_id |
Restrict delete |
| convoiceline_ref |
c_invoiceline.ref_invoiceline_id |
c_invoiceline.c_invoiceline_id |
Restrict delete |
| corder_callocation |
c_allocationline.c_order_id |
c_order.c_order_id |
Restrict delete |
| corder_cinvoice |
c_invoice.c_order_id |
c_order.c_order_id |
Restrict delete |
| corder_corderlandedcost |
c_orderlandedcost.c_order_id |
c_order.c_order_id |
Restrict delete |
| corder_corderline |
c_orderline.c_order_id |
c_order.c_order_id |
Restrict delete |
| corder_minout |
m_inout.c_order_id |
c_order.c_order_id |
Restrict delete |
| corder_ref |
c_order.ref_order_id |
c_order.c_order_id |
Restrict delete |
| corderlandedcost_corderlandedc |
c_orderlandedcostallocation.c_orderlandedcost_id |
c_orderlandedcost.c_orderlandedcost_id |
Restrict delete |
| corderline_cinvoiceline |
c_invoiceline.c_orderline_id |
c_orderline.c_orderline_id |
Restrict delete |
| corderline_corderlandedcostall |
c_orderlandedcostallocation.c_orderline_id |
c_orderline.c_orderline_id |
Restrict delete |
| corderline_mcostdetail |
m_costdetail.c_orderline_id |
c_orderline.c_orderline_id |
Restrict delete |
| corderline_minout |
m_inoutline.c_orderline_id |
c_orderline.c_orderline_id |
Restrict delete |
| corderline_mmatchpo |
m_matchpo.c_orderline_id |
c_orderline.c_orderline_id |
Restrict delete |
| corderline_ref |
c_orderline.ref_orderline_id |
c_orderline.c_orderline_id |
Restrict delete |
| cprojectissue_cprojectissuema |
c_projectissuema.c_projectissue_id |
c_projectissue.c_projectissue_id |
Restrict delete |
| cprojectissue_mcostdetail |
m_costdetail.c_projectissue_id |
c_projectissue.c_projectissue_id |
Restrict delete |
| cprojectissue_mtransaction |
m_transaction.c_projectissue_id |
c_projectissue.c_projectissue_id |
Restrict delete |
| linkorder_corder |
c_order.link_order_id |
c_order.c_order_id |
Null on delete |
| linkorderline_corderline |
c_orderline.link_orderline_id |
c_orderline.c_orderline_id |
Null on delete |
| m_product_m_product_acct |
m_product_acct.m_product_id |
m_product.m_product_id |
Cascade on delete |
| m_product_productpo |
m_product_po.m_product_id |
m_product.m_product_id |
Cascade on delete |
| m_warehouse_locator |
m_locator.m_warehouse_id |
m_warehouse.m_warehouse_id |
Cascade on delete |
| m_warehouse_warehouse_acct |
m_warehouse_acct.m_warehouse_id |
m_warehouse.m_warehouse_id |
Cascade on delete |
| masi_clandedcostallocation |
c_landedcostallocation.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| masi_cprojectissuema |
c_projectissuema.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| masi_mcost |
m_cost.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Cascade on delete |
| masi_mcostdetail |
m_costdetail.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| masi_mcostqueue |
m_costqueue.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Cascade on delete |
| masi_minourlinema |
m_inoutlinema.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Cascade on delete |
| masi_minventorylinema |
m_inventorylinema.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Cascade on delete |
| masi_mmovementlinema |
m_movementlinema.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Cascade on delete |
| masi_mproductionlinema |
m_productionlinema.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Cascade on delete |
| masi_tinventoryvalue |
t_inventoryvalue.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Cascade on delete |
| mattributesetinstance_mcosthis |
m_costhistory.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattributesetinstance_mmatchin |
m_matchinv.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattributesetinstance_mmatchpo |
m_matchpo.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattributesetinstanceto_mmovem |
m_movementline.m_attributesetinstanceto_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_cinvoiceline |
c_invoiceline.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_corderline |
c_orderline.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_cprojectissue |
c_projectissue.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_minoutline |
m_inoutline.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_minventoryline |
m_inventoryline.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_mmovementline |
m_movementline.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_mproduct |
m_product.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_mproductionline |
m_productionline.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mattrsetinst_mtransaction |
m_transaction.m_attributesetinstance_id |
m_attributesetinstance.m_attributesetinstance_id |
Restrict delete |
| mcostdetail_matchinv |
m_costdetail.m_matchinv_id |
m_matchinv.m_matchinv_id |
Restrict delete |
| mcostdetail_mcosthistory |
m_costhistory.m_costdetail_id |
m_costdetail.m_costdetail_id |
Restrict delete |
| mcostelement_corderlandedcost |
c_orderlandedcost.m_costelement_id |
m_costelement.m_costelement_id |
Restrict delete |
| mcostelement_mcost |
m_cost.m_costelement_id |
m_costelement.m_costelement_id |
Cascade on delete |
| mcostelement_mcostdetail |
m_costdetail.m_costelement_id |
m_costelement.m_costelement_id |
Restrict delete |
| mcostelement_mcosthistory |
m_costhistory.m_costelement_id |
m_costelement.m_costelement_id |
Restrict delete |
| mcostelement_mcostqueue |
m_costqueue.m_costelement_id |
m_costelement.m_costelement_id |
Cascade on delete |
| mcostelement_mlandedcostalloc |
c_landedcostallocation.m_costelement_id |
m_costelement.m_costelement_id |
Restrict delete |
| mcostelement_tinventoryvalue |
t_inventoryvalue.m_costelement_id |
m_costelement.m_costelement_id |
Cascade on delete |
| mcosttype_cacctschema |
c_acctschema.m_costtype_id |
m_costtype.m_costtype_id |
Restrict delete |
| mcosttype_mcost |
m_cost.m_costtype_id |
m_costtype.m_costtype_id |
Cascade on delete |
| mcosttype_mcosthistory |
m_costhistory.m_costtype_id |
m_costtype.m_costtype_id |
Restrict delete |
| mcosttype_mcostqueue |
m_costqueue.m_costtype_id |
m_costtype.m_costtype_id |
Cascade on delete |
| minout_clandedcost |
c_landedcost.m_inout_id |
m_inout.m_inout_id |
Restrict delete |
| minout_minoutline |
m_inoutline.m_inout_id |
m_inout.m_inout_id |
Cascade on delete |
| minout_ref |
m_inout.ref_inout_id |
m_inout.m_inout_id |
Restrict delete |
| minoutline_cinvoiceline |
c_invoiceline.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_clandedcost |
c_landedcost.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_clandedcostallocati |
c_landedcostallocation.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_cprojectissue |
c_projectissue.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_mcostdetail |
m_costdetail.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_minoutlinema |
m_inoutlinema.m_inoutline_id |
m_inoutline.m_inoutline_id |
Cascade on delete |
| minoutline_mmatchinv |
m_matchinv.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_mmatchpo |
m_matchpo.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_mtransaction |
m_transaction.m_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minoutline_ref |
m_inoutline.ref_inoutline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| minventoryline_mcostdetail |
m_costdetail.m_inventoryline_id |
m_inventoryline.m_inventoryline_id |
Restrict delete |
| minventoryline_milinema |
m_inventorylinema.m_inventoryline_id |
m_inventoryline.m_inventoryline_id |
Cascade on delete |
| minventoryline_mtransaction |
m_transaction.m_inventoryline_id |
m_inventoryline.m_inventoryline_id |
Restrict delete |
| minvoiceline_mcostdetail |
m_costdetail.c_invoiceline_id |
c_invoiceline.c_invoiceline_id |
Restrict delete |
| mlocator_cprojectissue |
c_projectissue.m_locator_id |
m_locator.m_locator_id |
Restrict delete |
| mlocator_minoutline |
m_inoutline.m_locator_id |
m_locator.m_locator_id |
Restrict delete |
| mlocator_minventorycount |
m_transaction.m_locator_id |
m_locator.m_locator_id |
Restrict delete |
| mlocator_minventoryline |
m_inventoryline.m_locator_id |
m_locator.m_locator_id |
Restrict delete |
| mlocator_movementline |
m_movementline.m_locatorto_id |
m_locator.m_locator_id |
Restrict delete |
| mlocator_mproduct |
m_product.m_locator_id |
m_locator.m_locator_id |
Restrict delete |
| mlocator_mproductionline |
m_productionline.m_locator_id |
m_locator.m_locator_id |
Restrict delete |
| mlocatorto_mmovementline |
m_movementline.m_locator_id |
m_locator.m_locator_id |
Restrict delete |
| mmovementline_mcostdetail |
m_costdetail.m_movementline_id |
m_movementline.m_movementline_id |
Restrict delete |
| mmovementline_mmovementlinema |
m_movementlinema.m_movementline_id |
m_movementline.m_movementline_id |
Cascade on delete |
| mmovementline_mtransaction |
m_transaction.m_movementline_id |
m_movementline.m_movementline_id |
Restrict delete |
| mprodcat_mprodcatacct |
m_product_category_acct.m_product_category_id |
m_product_category.m_product_category_id |
Cascade on delete |
| mproduct_cinvoiceline |
c_invoiceline.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_clandedcost |
c_landedcost.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_clandedcostalloc |
c_landedcostallocation.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_corderline |
c_orderline.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_cprojectissue |
c_projectissue.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mcost |
m_cost.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mcostdetail |
m_costdetail.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mcosthistory |
m_costhistory.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mcostqueue |
m_costqueue.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_minoutline |
m_inoutline.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_minventorycount |
m_transaction.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_minventoryline |
m_inventoryline.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mmatchinv |
m_matchinv.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mmatchpo |
m_matchpo.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mmovementline |
m_movementline.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_mproductcategory |
m_product.m_product_category_id |
m_product_category.m_product_category_id |
Restrict delete |
| mproduct_mproductionline |
m_productionline.m_product_id |
m_product.m_product_id |
Restrict delete |
| mproduct_tinventoryvalue |
t_inventoryvalue.m_product_id |
m_product.m_product_id |
Cascade on delete |
| mproductcat_parentcat |
m_product_category.m_product_category_parent_id |
m_product_category.m_product_category_id |
Restrict delete |
| mproductionline_mcostdetail |
m_costdetail.m_productionline_id |
m_productionline.m_productionline_id |
Restrict delete |
| mproductionline_mplinema |
m_productionlinema.m_productionline_id |
m_productionline.m_productionline_id |
Cascade on delete |
| mproductionline_mtransaction |
m_transaction.m_productionline_id |
m_productionline.m_productionline_id |
Restrict delete |
| mreservelocator_mwarehouse |
m_warehouse.m_reservelocator_id |
m_locator.m_locator_id |
Restrict delete |
| mwarehouse_corder |
c_order.m_warehouse_id |
m_warehouse.m_warehouse_id |
Restrict delete |
| mwarehouse_corderline |
c_orderline.m_warehouse_id |
m_warehouse.m_warehouse_id |
Restrict delete |
| mwarehouse_minout |
m_inout.m_warehouse_id |
m_warehouse.m_warehouse_id |
Restrict delete |
| mwarehouse_sresource |
s_resource.m_warehouse_id |
m_warehouse.m_warehouse_id |
Restrict delete |
| mwarehouse_tinventoryvalue |
t_inventoryvalue.m_warehouse_id |
m_warehouse.m_warehouse_id |
Cascade on delete |
| mwarehousesource_mwarehouse |
m_warehouse.m_warehousesource_id |
m_warehouse.m_warehouse_id |
Restrict delete |
| quotationorder_corder |
c_order.quotationorder_id |
c_order.c_order_id |
Restrict delete |
| refmatchinv_mmatchinv |
m_matchinv.ref_matchinv_id |
m_matchinv.m_matchinv_id |
Restrict delete |
| refmatchpo_mmatchpo |
m_matchpo.ref_matchpo_id |
m_matchpo.m_matchpo_id |
Restrict delete |
| relatedinvoice_cinvoice |
c_invoice.relatedinvoice_id |
c_invoice.c_invoice_id |
Restrict delete |
| reversal_cinvoice |
c_invoice.reversal_id |
c_invoice.c_invoice_id |
Restrict delete |
| reversal_cprojectissue |
c_projectissue.reversal_id |
c_projectissue.c_projectissue_id |
Restrict delete |
| reversal_minout |
m_inout.reversal_id |
m_inout.m_inout_id |
Restrict delete |
| reversal_mmatchinv |
m_matchinv.reversal_id |
m_matchinv.m_matchinv_id |
Restrict delete |
| reversal_mmatchpo |
m_matchpo.reversal_id |
m_matchpo.m_matchpo_id |
Restrict delete |
| reversalline_minoutline |
m_inoutline.reversalline_id |
m_inoutline.m_inoutline_id |
Restrict delete |
| reversalline_minventoryline |
m_inventoryline.reversalline_id |
m_inventoryline.m_inventoryline_id |
Restrict delete |
| reversalline_mmovementline |
m_movementline.reversalline_id |
m_movementline.m_movementline_id |
Restrict delete |
| sresource_mproduct |
m_product.s_resource_id |
s_resource.s_resource_id |
Restrict delete |