Table idempiere11.adempiere.m_product_acct
Product Acct

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 m_product_m_product_acct C
Product, Service, Item
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_mproductacct C
Rules for accounting
ad_client_id numeric 10 Tenant for this installation.
ad_org_id numeric 10 Organizational entity within tenant
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
p_revenue_acct numeric 10
c_validcombination.c_validcombination_id vc_prevenue_mproduct R
Account for Product Revenue (Sales Account)
p_expense_acct numeric 10
c_validcombination.c_validcombination_id vc_pexpense_mproduct R
Account for Product Expense
p_asset_acct numeric 10
c_validcombination.c_validcombination_id vc_passet_mproduct R
Account for Product Asset (Inventory)
p_purchasepricevariance_acct numeric 10
c_validcombination.c_validcombination_id vc_ppurchasepv_mproduct R
Difference between Standard Cost and Purchase Price (PPV)
p_invoicepricevariance_acct numeric 10
c_validcombination.c_validcombination_id vc_pinvoicepv_mproduct R
Difference between Costs and Invoice Price (IPV)
p_cogs_acct numeric 10
c_validcombination.c_validcombination_id vc_pcogs_mproduct R
Account for Cost of Goods Sold
p_tradediscountrec_acct numeric 10
c_validcombination.c_validcombination_id vc_ptdiscountrec_mproduct R
Trade Discount Receivable Account
p_tradediscountgrant_acct numeric 10
c_validcombination.c_validcombination_id vc_ptdiscountgrant_mproduct R
Trade Discount Granted Account
p_inventoryclearing_acct numeric 10  √  null
c_validcombination.c_validcombination_id pinventoryclearing_mproductacc R
Product Inventory Clearing Account
p_costadjustment_acct numeric 10  √  null
c_validcombination.c_validcombination_id pcostadjustment_mproductacct R
Product Cost Adjustment Account
p_wip_acct numeric 10  √  null
c_validcombination.c_validcombination_id pwip_mproductacct R
The Work in Process account is the account used Manufacturing Order
p_methodchangevariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pmethodchangevariance_mproduct R
The Method Change Variance account is the account used Manufacturing Order
p_usagevariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pusagevariance_mproductacct R
The Usage Variance account is the account used Manufacturing Order
p_ratevariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pratevariance_mproductacct R
The Rate Variance account is the account used Manufacturing Order
p_mixvariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pmixvariance_mproductacct R
The Mix Variance account is the account used Manufacturing Order
p_floorstock_acct numeric 10  √  null
c_validcombination.c_validcombination_id pfloorstock_mproductacct R
The Floor Stock account is the account used Manufacturing Order
p_costofproduction_acct numeric 10  √  null
c_validcombination.c_validcombination_id pcostofproduction_mproductacct R
The Cost Of Production account is the account used Manufacturing Order
p_labor_acct numeric 10  √  null
c_validcombination.c_validcombination_id plabor_mproductacct R
The Labor account is the account used Manufacturing Order
p_burden_acct numeric 10  √  null
c_validcombination.c_validcombination_id pburden_mproductacct R
The Burden account is the account used Manufacturing Order
p_outsideprocessing_acct numeric 10  √  null
c_validcombination.c_validcombination_id poutsideprocessing_mproductacc R
The Outside Processing Account is the account used in Manufacturing Order
p_overhead_acct numeric 10  √  null
c_validcombination.c_validcombination_id poverhead_mproductacct R
The Overhead account is the account used in Manufacturing Order
p_scrap_acct numeric 10  √  null
c_validcombination.c_validcombination_id pscrap_mproductacct R
The Scrap account is the account used in Manufacturing Order
p_averagecostvariance_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id paveragecostvariance_mproducta R
Average Cost Variance
m_product_acct_uu varchar 36  √  NULL::character varying M_Product_Acct_UU
p_landedcostclearing_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id plandedcostclearingvc_mprodacc R
Product Landed Cost Clearing Account

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

Indexes:
Column(s) Type Sort Constraint Name
m_product_id + c_acctschema_id Primary key Asc/Asc m_product_acct_pkey
m_product_acct_uu Must be unique Asc m_product_acct_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.