m_product_category_acct

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_product_category_id numeric 10 null
m_product_category.m_product_category_id mprodcat_mprodcatacct C
c_acctschema_id numeric 10 null
c_acctschema.c_acctschema_id cacctschema_mprodcatacct 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_mproductcategory R
p_expense_acct numeric 10 null
c_validcombination.c_validcombination_id vc_pexpense_mproductcategory R
p_asset_acct numeric 10 null
c_validcombination.c_validcombination_id vc_passet_mproductcategory R
p_cogs_acct numeric 10 null
c_validcombination.c_validcombination_id vc_pcogs_mproductcategory R
p_purchasepricevariance_acct numeric 10 null
c_validcombination.c_validcombination_id vc_ppurchasepv_mproductcategor R
p_invoicepricevariance_acct numeric 10 null
c_validcombination.c_validcombination_id vc_pinvoicepv_mproductcategory R
p_tradediscountrec_acct numeric 10 null
c_validcombination.c_validcombination_id vc_ptdiscountrec_mproductcateg R
p_tradediscountgrant_acct numeric 10 null
c_validcombination.c_validcombination_id vc_ptdiscountgrant_mproductcat R
processing bpchar 1 √ null
costingmethod bpchar 1 √ null
costinglevel bpchar 1 √ null
p_inventoryclearing_acct numeric 10 √ null
c_validcombination.c_validcombination_id pinventoryclearing_mproductcat R
p_costadjustment_acct numeric 10 √ null
c_validcombination.c_validcombination_id pcostadjustment_mproductcatego R
p_floorstock_acct numeric 10 √ null
c_validcombination.c_validcombination_id pfloorstock_mproductcategoryac R
p_wip_acct numeric 10 √ null
c_validcombination.c_validcombination_id pwip_mproductcategoryacct R
p_methodchangevariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pmethodchangevariance_mprodcat R
p_usagevariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pusagevariance_mproductcategor R
p_ratevariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pratevariance_mproductcategory R
p_mixvariance_acct numeric 10 √ null
c_validcombination.c_validcombination_id pmixvariance_mproductcategorya R
p_costofproduction_acct numeric 10 √ null
c_validcombination.c_validcombination_id pcostofproduction_mproductcate R
p_labor_acct numeric 10 √ null
c_validcombination.c_validcombination_id plabor_mproductcategoryacct R
p_burden_acct numeric 10 √ null
c_validcombination.c_validcombination_id pburden_mproductcategoryacct R
p_outsideprocessing_acct numeric 10 √ null
c_validcombination.c_validcombination_id poutsideprocessing_mproductcat R
p_overhead_acct numeric 10 √ null
c_validcombination.c_validcombination_id poverhead_mproductcategoryacct R
p_scrap_acct numeric 10 √ null
c_validcombination.c_validcombination_id pscrap_mproductcategoryacct R
p_averagecostvariance_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id paveragecostvariance_mproductc R
m_product_category_acct_uu varchar 36 √ NULL::character varying
p_landedcostclearing_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id plandedcostclearingvc_mprcatac R
cof_p_inventoryclearing_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id cofpinventoryclearingacct_mproductcategoryacct R
cof_p_estoqueemterceiro_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id cofpestoqueemterceiroacct_mproductcategoryacct R
cof_p_estoqueterceiro_acct numeric 10 √ NULL::numeric
c_validcombination.c_validcombination_id cofpestoqueterceiroacct_mproductcategoryacct R

Indexes

Constraint Name Type Sort Column(s)
m_product_category_acct_pkey Primary key Asc/Asc m_product_category_id + c_acctschema_id
m_product_category_acct_uu_idx Must be unique Asc m_product_category_acct_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation