m_product_acct

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_product_id numeric 10 null
m_product.m_product_id m_product_m_product_acct C
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_mproductacct C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
p_revenue_acct numeric 10 null
c_validcombination.c_validcombination_id vc_prevenue_mproduct R
p_expense_acct numeric 10 null
c_validcombination.c_validcombination_id vc_pexpense_mproduct R
p_asset_acct numeric 10 null
c_validcombination.c_validcombination_id vc_passet_mproduct R
p_purchasepricevariance_acct numeric 10 null
c_validcombination.c_validcombination_id vc_ppurchasepv_mproduct R
p_invoicepricevariance_acct numeric 10 null
c_validcombination.c_validcombination_id vc_pinvoicepv_mproduct R
p_cogs_acct numeric 10 null
c_validcombination.c_validcombination_id vc_pcogs_mproduct R
p_tradediscountrec_acct numeric 10 null
c_validcombination.c_validcombination_id vc_ptdiscountrec_mproduct R
p_tradediscountgrant_acct numeric 10 null
c_validcombination.c_validcombination_id vc_ptdiscountgrant_mproduct R
p_inventoryclearing_acct numeric 10 √ null
c_validcombination.c_validcombination_id pinventoryclearing_mproductacc R
p_costadjustment_acct numeric 10 √ null
c_validcombination.c_validcombination_id pcostadjustment_mproductacct R
p_wip_acct numeric 10 √ null
c_validcombination.c_validcombination_id pwip_mproductacct R
p_methodchangevariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pmethodchangevariance_mproduct R
p_usagevariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pusagevariance_mproductacct R
p_ratevariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pratevariance_mproductacct R
p_mixvariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pmixvariance_mproductacct R
p_floorstock_acct numeric 10 √ null
c_validcombination.c_validcombination_id pfloorstock_mproductacct R
p_costofproduction_acct numeric 10 √ null
c_validcombination.c_validcombination_id pcostofproduction_mproductacct R
p_labor_acct numeric 10 √ null
c_validcombination.c_validcombination_id plabor_mproductacct R
p_burden_acct numeric 10 √ null
c_validcombination.c_validcombination_id pburden_mproductacct R
p_outsideprocessing_acct numeric 10 √ null
c_validcombination.c_validcombination_id poutsideprocessing_mproductacc R
p_overhead_acct numeric 10 √ null
c_validcombination.c_validcombination_id poverhead_mproductacct R
p_scrap_acct numeric 10 √ null
c_validcombination.c_validcombination_id pscrap_mproductacct R
p_averagecostvariance_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id paveragecostvariance_mproducta R
m_product_acct_uu varchar 36 √ NULL::character varying
p_landedcostclearing_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id plandedcostclearingvc_mprodacc R
cof_p_inventoryclearing_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id cofpinventoryclearingacct_mproductacct R
cof_p_estoqueemterceiro_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id cofpestoqueemterceiroacct_mproductacct R
cof_p_estoqueterceiro_acct numeric 10 √ null
c_validcombination.c_validcombination_id cofpestoqueterceiroacct_mproductacct R

Indexes

Constraint Name Type Sort Column(s)
m_product_acct_pkey Primary key Asc/Asc m_product_id + c_acctschema_id
m_product_acct_uu_idx Must be unique Asc m_product_acct_uu

Check Constraints

Constraint Name Constraint
m_product_acct_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation