Table idempiere9.adempiere.m_costdetail
Cost Detail Information

Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
m_costdetail_id numeric 10
m_costhistory.m_costdetail_id mcostdetail_mcosthistory R
Cost Detail Information
ad_client_id numeric 10
ad_client.ad_client_id adclient_mcostdetail R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id adorg_mcostdetail R
Organizational entity within client
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_mcostdetail R
Rules for accounting
m_product_id numeric 10
m_product.m_product_id mproduct_mcostdetail R
Product, Service, Item
m_attributesetinstance_id numeric 10
m_attributesetinstance.m_attributesetinstance_id masi_mcostdetail R
Product Attribute Set Instance
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
m_costelement_id numeric 10  √  null
m_costelement.m_costelement_id mcostelement_mcostdetail R
Product Cost Element
c_orderline_id numeric 10  √  null
c_orderline.c_orderline_id corderline_mcostdetail R
Sales Order Line
m_inoutline_id numeric 10  √  null
m_inoutline.m_inoutline_id minoutline_mcostdetail R
Line on Shipment or Receipt document
c_invoiceline_id numeric 10  √  null
c_invoiceline.c_invoiceline_id minvoiceline_mcostdetail R
Invoice Detail Line
m_movementline_id numeric 10  √  null
m_movementline.m_movementline_id mmovementline_mcostdetail R
Inventory Move document Line
m_inventoryline_id numeric 10  √  null
m_inventoryline.m_inventoryline_id minventoryline_mcostdetail R
Unique line in an Inventory document
m_productionline_id numeric 10  √  null
m_productionline.m_productionline_id mproductionline_mcostdetail R
Document Line representing a production
c_projectissue_id numeric 10  √  null
c_projectissue.c_projectissue_id cprojectissue_mcostdetail R
Project Issues (Material, Labor)
issotrx bpchar 1 'Y'::bpchar This is a Sales Transaction
amt numeric 0 0 Amount
qty numeric 0 0 Quantity
deltaamt numeric 0  √  0 Difference Amount
deltaqty numeric 0  √  0 Quantity Difference
description varchar 255  √  null Optional short description of the record
processed bpchar 1 'N'::bpchar The document has been processed
pp_cost_collector_id numeric 10  √  null
pp_cost_collector.pp_cost_collector_id ppcostcollector_mcostdetail R
Manufacturing Cost Collector
currentcostprice numeric 0  √  null The currently used cost price
currentqty numeric 0  √  null Current Quantity
cumulatedamt numeric 0  √  null Total Amount
cumulatedqty numeric 0  √  null Total Quantity
m_costdetail_uu varchar 36  √  NULL::character varying M_CostDetail_UU
m_matchinv_id numeric 10  √  NULL::numeric
m_matchinv.m_matchinv_id mcostdetail_matchinv R
Match Shipment/Receipt to Invoice

Table contained 0 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
m_costdetail_id Primary key Asc m_costdetail_pkey
m_attributesetinstance_id Performance Asc m_costdetail_asi
m_product_id + processed Performance Asc/Asc m_costdetail_product
m_costdetail_uu Must be unique Asc m_costdetail_uu_idx


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.