c_acctschema

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_acctschema_id numeric 10 null
a_asset_acct.c_acctschema_id cacctschema_aassetacct R
a_asset_change.c_acctschema_id cacctschema_aassetchange R
a_asset_change_amt.c_acctschema_id cacctschema_aassetchangeamt R
a_asset_group_acct.c_acctschema_id cacctschema_aassetgroupacct R
a_asset_reval_entry.c_acctschema_id cacctschema_aassetrevalentry R
a_asset_transfer.c_acctschema_id cacctschema_aassettransfer R
a_depreciation_entry.c_acctschema_id cacctschema_adepreciationentry R
a_depreciation_exp.c_acctschema_id cacctschema_adepreciationexp C
a_depreciation_workfile.c_acctschema_id cacctschema_adepreciationworkf C
a_fundingmode_acct.c_acctschema_id cacctschema_afundingmodeacct R
ad_clientinfo.c_acctschema1_id cacctschema1_adclientinfo R
c_acctprocessor.c_acctschema_id cacctschema_cacctprocessor R
c_acctschema_default.c_acctschema_id cacctschema_default C
c_acctschema_element.c_acctschema_id cacctschema_caschemaelement C
c_acctschema_gl.c_acctschema_id cacctschema_cacctschemagl C
c_bankaccount_acct.c_acctschema_id cacctschema_cbankaccountacct C
c_bp_customer_acct.c_acctschema_id cacctschema_cbpcustomeracct C
c_bp_employee_acct.c_acctschema_id cacctschema_cbpemployeeacct C
c_bp_group_acct.c_acctschema_id cacctschema_cbpgroupacct C
c_bp_vendor_acct.c_acctschema_id cacctschema_cbpvendoracct C
c_cashbook_acct.c_acctschema_id cacctschema_ccashbookacct C
c_charge_acct.c_acctschema_id cacctschema_cchargeacct C
c_currency_acct.c_acctschema_id cacctschema_ccurrencyacct C
c_interorg_acct.c_acctschema_id cacctschema_cinterorgacct C
c_project_acct.c_acctschema_id cacctschema_cprojectacct C
c_revenuerecognition_plan.c_acctschema_id cacctschema_crevrecplan R
c_tax_acct.c_acctschema_id cacctschema_ctaxacct C
c_taxdeclarationacct.c_acctschema_id cacctschema_ctaxdeclacct C
c_validcombination.c_acctschema_id cacctschema_cvalidcombination C
c_withholding_acct.c_acctschema_id cacctschema_cwithholdingacct C
cof_ajusteqtdcontabil.c_acctschema_id cacctschema_cofajusteqtdcontab C
cof_c_acct_ignoreelement.c_acctschema_id cacctschema_cofcacctignoreelem C
cof_c_sped_contabil.c_acctschema_id cacctschema_cofcspedcontabil R
cof_c_sped_fiscal.c_acctschema_id cacctschema_cofcspedfiscal R
fact_acct.c_acctschema_id cacctschema_factacct C
fact_acct_summary.c_acctschema_id cacctschema_factacctsummary R
gl_budgetcontrol.c_acctschema_id cacctschema_glbudgetcontrol R
gl_distribution.c_acctschema_id cacctschema_gldist R
gl_fund.c_acctschema_id cacctschema_glfund R
gl_journal.c_acctschema_id c_acctschema_gl_journal R
gl_journalgenerator.c_acctschema_id cacctschema_qssjournalgenerato R
hr_concept_acct.c_acctschema_id cacctschema_hrconceptacct R
i_asset.c_acctschema_id cacctschema_iasset R
i_fajournal.c_acctschema_id cacctschema_ifajournal R
i_fixedasset.c_acctschema_id cacctschema_ifixedasset C
i_gljournal.c_acctschema_id cacctschema_igljournal N
m_cost.c_acctschema_id cacctschema_mcost C
m_costdetail.c_acctschema_id cacctschema_mcostdetail R
m_costqueue.c_acctschema_id cacctschema_mcostqueue C
m_product_acct.c_acctschema_id cacctschema_mproductacct C
m_product_category_acct.c_acctschema_id cacctschema_mprodcatacct C
m_warehouse_acct.c_acctschema_id cacctschema_mwarehouseacct C
pa_ratio.c_acctschema_id cacctschema_paratio R
pa_report.c_acctschema_id cacctschema_pareport R
pp_order_cost.c_acctschema_id cacctschema_ppordercost R
ad_client_id numeric 10 null
ad_client.ad_client_id ad_client_c_acctschema R
ad_org_id numeric 10 null
ad_org.ad_org_id ad_org_c_acctschema R
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 √ null
gaap bpchar 2 null
isaccrual bpchar 1 'Y'::bpchar
costingmethod bpchar 1 null
c_currency_id numeric 10 null
c_currency.c_currency_id c_currency_c_acctschema R
autoperiodcontrol bpchar 1 'N'::bpchar
c_period_id numeric 10 √ null
c_period.c_period_id cperiod_cacctschema R
period_openhistory numeric 10 √ null
period_openfuture numeric 10 √ null
separator bpchar 1 null
hasalias bpchar 1 'Y'::bpchar
hascombination bpchar 1 'Y'::bpchar
istradediscountposted bpchar 1 'N'::bpchar
isdiscountcorrectstax bpchar 1 'N'::bpchar
m_costtype_id numeric 10 √ null
m_costtype.m_costtype_id mcosttype_cacctschema R
costinglevel bpchar 1 'C'::bpchar
isadjustcogs bpchar 1 'N'::bpchar
ad_orgonly_id numeric 10 √ null
ad_org.ad_org_id adorgonly_cacctschema R
ispostservices bpchar 1 'N'::bpchar
isexplicitcostadjustment bpchar 1 'N'::bpchar
commitmenttype bpchar 1 'N'::bpchar
processing bpchar 1 √ null
taxcorrectiontype bpchar 1 √ null
isallownegativeposting bpchar 1 √ 'Y'::bpchar
ispostifclearingequal bpchar 1 √ 'Y'::bpchar
c_acctschema_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_acctschema_pkey Primary key Asc c_acctschema_id
c_acctschema_name Must be unique Asc/Asc ad_client_id + name
c_acctschema_uu_idx Must be unique Asc c_acctschema_uu

Check Constraints

Constraint Name Constraint
c_acctschema_istradediscountposted_check ((istradediscountposted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_isdiscountcorrectstax_check ((isdiscountcorrectstax = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_isaccrual_check ((isaccrual = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_hascombination_check ((hascombination = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_isallownegativeposting_check ((isallownegativeposting = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_ispostifclearingequal_check ((ispostifclearingequal = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_autoperiodcontrol_check ((autoperiodcontrol = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_acctschema_hasalias_check ((hasalias = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation