Table idempiere9.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 Client/Tenant for this installation.
ad_org_id numeric 10 Organizational entity within client
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 Account for Product Revenue (Sales Account)
p_expense_acct numeric 10 Account for Product Expense
p_asset_acct numeric 10 Account for Product Asset (Inventory)
p_purchasepricevariance_acct numeric 10 Difference between Standard Cost and Purchase Price (PPV)
p_invoicepricevariance_acct numeric 10 Difference between Costs and Invoice Price (IPV)
p_cogs_acct numeric 10 Account for Cost of Goods Sold
p_tradediscountrec_acct numeric 10 Trade Discount Receivable Account
p_tradediscountgrant_acct numeric 10 Trade Discount Granted Account
p_inventoryclearing_acct numeric 10  √  null Product Inventory Clearing Account
p_costadjustment_acct numeric 10  √  null Product Cost Adjustment Account
p_wip_acct numeric 10  √  null The Work in Process account is the account used Manufacturing Order
p_methodchangevariance_acct numeric 10  √  null The Method Change Variance account is the account used Manufacturing Order
p_usagevariance_acct numeric 10  √  null The Usage Variance account is the account used Manufacturing Order
p_ratevariance_acct numeric 10  √  null The Rate Variance account is the account used Manufacturing Order
p_mixvariance_acct numeric 10  √  null The Mix Variance account is the account used Manufacturing Order
p_floorstock_acct numeric 10  √  null The Floor Stock account is the account used Manufacturing Order
p_costofproduction_acct numeric 10  √  null The Cost Of Production account is the account used Manufacturing Order
p_labor_acct numeric 10  √  null The Labor account is the account used Manufacturing Order
p_burden_acct numeric 10  √  null The Burden account is the account used Manufacturing Order
p_outsideprocessing_acct numeric 10  √  null The Outside Processing Account is the account used in Manufacturing Order
p_overhead_acct numeric 10  √  null The Overhead account is the account used in Manufacturing Order
p_scrap_acct numeric 10  √  null The Scrap account is the account used in Manufacturing Order
p_averagecostvariance_acct numeric 10  √  NULL::numeric Average Cost Variance
m_product_acct_uu varchar 36  √  NULL::character varying M_Product_Acct_UU
p_landedcostclearing_acct numeric 10  √  NULL::numeric Product Landed Cost Clearing Account

Table contained 110 rows at 2021-12-25 14:46 +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

Close relationships  within of separation: