Table idempiere11.adempiere.pp_cost_collector
Manufacturing Cost Collector

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_product_id numeric 10
m_product.m_product_id mproduct_ppcostcollector R
Product, Service, Item
ad_orgtrx_id numeric 10  √  null
ad_org.ad_org_id adorgtrx_ppcostcollector R
Performing or initiating organization
ad_org_id numeric 10 Organizational entity within tenant
ad_user_id numeric 10  √  null
ad_user.ad_user_id aduser_ppcostcollector R
User within the system - Internal or Business Partner Contact
c_activity_id numeric 10  √  null
c_activity.c_activity_id cactivity_ppcostcollector R
Business Activity
c_campaign_id numeric 10  √  null
c_campaign.c_campaign_id ccampaign_ppcostcollector R
Marketing Campaign
c_doctypetarget_id numeric 10
c_doctype.c_doctype_id cdoctypetarget_ppcostcollector R
Target document type for conversing documents
c_doctype_id numeric 10
c_doctype.c_doctype_id cdoctype_ppcostcollector R
Document type or rules
c_project_id numeric 10  √  null
c_project.c_project_id cproject_ppcostcollector R
Financial Project
c_uom_id numeric 10  √  null
c_uom.c_uom_id cuom_ppcostcollector R
Unit of Measure
created timestamp 29,6 statement_timestamp() Date this record was created
createdby numeric 10 User who created this records
dateacct timestamp 29,6 Accounting Date
description varchar 255  √  null Optional short description of the record
docaction bpchar 2  √  'CO'::bpchar The targeted status of the document
docstatus bpchar 2  √  'DR'::bpchar The current status of the document
durationreal numeric 0  √  null Duration Real
isactive bpchar 1 The record is active in the system
isbatchtime bpchar 1  √  'N'::bpchar Is Batch Time
m_attributesetinstance_id numeric 10  √  null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_ppcostco R
Product Attribute Set Instance
m_locator_id numeric 10
m_locator.m_locator_id mlocator_ppcostcollector R
Warehouse Locator
m_warehouse_id numeric 10
m_warehouse.m_warehouse_id mwarehouse_ppcostcollector R
Storage Warehouse and Service Point
movementdate timestamp 29,6 Date a product was moved in or out of inventory
movementqty numeric 0 (0)::numeric Quantity of a product moved.
pp_cost_collector_id numeric 10
c_orderline.pp_cost_collector_id ppcostcollector_corderline R
hr_movement.pp_cost_collector_id ppcostcollector_hrmovement R
m_costdetail.pp_cost_collector_id ppcostcollector_mcostdetail R
m_transaction.pp_cost_collector_id ppcostcollector_mtransaction R
pp_cost_collector.reversal_id reversal_ppcostcollector R
pp_cost_collectorma.pp_cost_collector_id ppcostcollector_ppccma R
Manufacturing Cost Collector
pp_order_bomline_id numeric 10  √  null
pp_order_bomline.pp_order_bomline_id pporderbomline_ppcostcollector R
Manufacturing Order BOM Line
pp_order_id numeric 10
pp_order.pp_order_id pporder_ppcostcollector R
Manufacturing Order
pp_order_node_id numeric 10  √  null
pp_order_node.pp_order_node_id ppordernode_ppcostcollector R
Workflow Node (activity), step or process
pp_order_workflow_id numeric 10  √  null
pp_order_workflow.pp_order_workflow_id pporderworkflow_ppcostcollecto R
Manufacturing Order Workflow
posted bpchar 1 Posting status
processed bpchar 1 The document has been processed
processing bpchar 1  √  null Process Now
qtyreject numeric 0  √  (0)::numeric Qty Reject
s_resource_id numeric 10
s_resource.s_resource_id sresource_ppcostcollector R
Resource
scrappedqty numeric 0  √  (0)::numeric The Quantity scrapped due to QA issues
setuptimereal numeric 0  √  (0)::numeric Setup Time Real
updated timestamp 29,6 statement_timestamp() Date this record was updated
updatedby numeric 10 User who updated this records
user1_id numeric 10  √  null
ad_user.ad_user_id user1_ppcostcollector R
User defined list element #1
ad_client_id numeric 10 Tenant for this installation.
user2_id numeric 10  √  null
ad_user.ad_user_id user2_ppcostcollector R
User defined list element #2
reversal_id numeric 10  √  null
pp_cost_collector.pp_cost_collector_id reversal_ppcostcollector R
ID of document reversal
costcollectortype varchar 3 Transaction Type for Manufacturing Management
issubcontracting bpchar 1  √  null Is Subcontracting
documentno varchar 30 Document sequence number of the document
processedon numeric 0  √  null The date+time (expressed in decimal format) when the document has been processed
pp_cost_collector_uu varchar 36  √  NULL::character varying PP_Cost_Collector_UU

Table contained 0 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
pp_cost_collector_id Primary key Asc pp_cost_collector_key
posted + processed + processedon + ad_client_id Performance Asc/Asc/Asc/Asc idxpp_cost_collector_proc_on
pp_cost_collector_uu Must be unique Asc pp_cost_collector_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.