Table idempiere9.adempiere.c_acctschema_default
C_AcctSchema_Default

 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
c_acctschema_id numeric 10
c_acctschema.c_acctschema_id cacctschema_default 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
w_inventory_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_winventory_cschemadefault R
Warehouse Inventory Asset Account - Currently not used
w_invactualadjust_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_winvactualadjust_cschemadef R
Account for Inventory value adjustments for Actual Costing
w_differences_acct numeric 10
c_validcombination.c_validcombination_id vc_wdifferences_cschemadefault R
Warehouse Differences Account
w_revaluation_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_wrevaluation_cschemadefault R
Account for Inventory Revaluation
p_revenue_acct numeric 10
c_validcombination.c_validcombination_id vc_prevenue_cschemadefault R
Account for Product Revenue (Sales Account)
p_expense_acct numeric 10
c_validcombination.c_validcombination_id vc_pexpense_cschemadefault R
Account for Product Expense
p_asset_acct numeric 10
c_validcombination.c_validcombination_id vc_passet_cschemadefault R
Account for Product Asset (Inventory)
p_purchasepricevariance_acct numeric 10
c_validcombination.c_validcombination_id vc_ppurchasepv_cschemadefault R
Difference between Standard Cost and Purchase Price (PPV)
p_invoicepricevariance_acct numeric 10
c_validcombination.c_validcombination_id vc_pinvoicepv_cschemadefault R
Difference between Costs and Invoice Price (IPV)
p_tradediscountrec_acct numeric 10
c_validcombination.c_validcombination_id vc_ptdiscountrec_cschemadefaul R
Trade Discount Receivable Account
p_tradediscountgrant_acct numeric 10
c_validcombination.c_validcombination_id vc_ptdiscountgrant_cschemadefa R
Trade Discount Granted Account
p_cogs_acct numeric 10
c_validcombination.c_validcombination_id vc_pcogs_cschemadefault R
Account for Cost of Goods Sold
c_receivable_acct numeric 10
c_validcombination.c_validcombination_id vc_creceivable_cschemadefault R
Account for Customer Receivables
c_prepayment_acct numeric 10
c_validcombination.c_validcombination_id vc_cprepayment_cschemadefault R
Account for customer prepayments
v_liability_acct numeric 10
c_validcombination.c_validcombination_id vc_vliability_cschemadefault R
Account for Vendor Liability
v_liability_services_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_vliabilityservices_cschemad R
Account for Vendor Service Liability
v_prepayment_acct numeric 10
c_validcombination.c_validcombination_id vc_vprepayment_cschemadefault R
Account for Vendor Prepayments
paydiscount_exp_acct numeric 10
c_validcombination.c_validcombination_id vc_paydiscountexp_cschemadefau R
Payment Discount Expense Account
writeoff_acct numeric 10
c_validcombination.c_validcombination_id vc_writeoff_cschemadefault R
Account for Receivables write-off
paydiscount_rev_acct numeric 10
c_validcombination.c_validcombination_id vc_paydiscountrev_cschemadefau R
Payment Discount Revenue Account
unrealizedgain_acct numeric 10
c_validcombination.c_validcombination_id vc_unrealizedgain_cschemadefau R
Unrealized Gain Account for currency revaluation
unrealizedloss_acct numeric 10
c_validcombination.c_validcombination_id vc_unrealizedloss_cschemadefau R
Unrealized Loss Account for currency revaluation
realizedgain_acct numeric 10
c_validcombination.c_validcombination_id vc_realizedgain_cschemadefault R
Realized Gain Account
realizedloss_acct numeric 10
c_validcombination.c_validcombination_id vc_realizedloss_cschemadefault R
Realized Loss Account
withholding_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_withholding_cschemadefault R
Account for Withholdings
e_prepayment_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_eprepayment_cschemadefault R
Account for Employee Expense Prepayments
e_expense_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_eexpense_cschemadefault R
Account for Employee Expenses
pj_asset_acct numeric 10
c_validcombination.c_validcombination_id vc_pjasset_cschemadefault R
Project Asset Account
pj_wip_acct numeric 10
c_validcombination.c_validcombination_id vc_pjwip_cschemadefault R
Account for Work in Progress
t_expense_acct numeric 10
c_validcombination.c_validcombination_id vc_texpense_cschemadefault R
Account for paid tax you cannot reclaim
t_liability_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_tliability_cschemadefault R
Account for Tax declaration liability
t_receivables_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_trec_cschemadefault R
Account for Tax credit after tax declaration
t_due_acct numeric 10
c_validcombination.c_validcombination_id vc_tdue_cschemadefault R
Account for Tax you have to pay
t_credit_acct numeric 10
c_validcombination.c_validcombination_id vc_tcredit_cschemadefault R
Account for Tax you can reclaim
b_intransit_acct numeric 10
c_validcombination.c_validcombination_id vc_bintransit_cschemadefault R
Bank In Transit Account
b_asset_acct numeric 10
c_validcombination.c_validcombination_id vc_basset_cschemadefault R
Bank Asset Account
b_expense_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_bexpense_cschemadefault R
Bank Expense Account
b_interestrev_acct numeric 10
c_validcombination.c_validcombination_id vc_binterestrev_cschemadefault R
Bank Interest Revenue Account
b_interestexp_acct numeric 10
c_validcombination.c_validcombination_id vc_binterestexp_cschemadefault R
Bank Interest Expense Account
b_unidentified_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_bunidentified_cschemadefaul R
Bank Unidentified Receipts Account
b_unallocatedcash_acct numeric 10
c_validcombination.c_validcombination_id vc_bunallocatedcash_cschemadef R
Unallocated Cash Clearing Account
b_paymentselect_acct numeric 10
c_validcombination.c_validcombination_id vc_bpaymentselect_cschemadefau R
AP Payment Selection Clearing Account
b_settlementgain_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_bsettlementgain_cschemadefa R
Bank Settlement Gain Account
b_settlementloss_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_bsettlementloss_cschemadefa R
Bank Settlement Loss Account
b_revaluationgain_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_brevaluationgain_cschemadef R
Bank Revaluation Gain Account
b_revaluationloss_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_brevaluationloss_cschemadef R
Bank Revaluation Loss Account
ch_expense_acct numeric 10
c_validcombination.c_validcombination_id vc_chexpense_cschemadefault R
Charge Account
ch_revenue_acct numeric 10  √  null
c_validcombination.c_validcombination_id chrevenue_cacctschemadefault R
Charge Revenue Account
unearnedrevenue_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_unearnedrevenue_cschemadefa R
Account for unearned revenue
notinvoicedreceivables_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_notinvoicedrec_cschemadefau R
Account for not invoiced Receivables
notinvoicedrevenue_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_notinvoicedrevenue_cschemad R
Account for not invoiced Revenue
notinvoicedreceipts_acct numeric 10
c_validcombination.c_validcombination_id vc_notinvoicedreceipts_cschema R
Account for not-invoiced Material Receipts
cb_asset_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_cbasset_cschemadefault R
Cash Book Asset Account
cb_cashtransfer_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_cbcashtransfer_cschemadefau R
Cash Transfer Clearing Account
cb_differences_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_cbdifferences_cschemadefaul R
Cash Book Differences Account
cb_expense_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_cbexpense_cschemadefault R
Cash Book Expense Account
cb_receipt_acct numeric 10  √  null
c_validcombination.c_validcombination_id vc_cbreceipt_cschemadefault R
Cash Book Receipts Account
processing bpchar 1  √  null Process Now
c_receivable_services_acct numeric 10  √  null
c_validcombination.c_validcombination_id creceivableservices_cacctschem R
Customer Accounts Receivables Services Account
p_inventoryclearing_acct numeric 10
c_validcombination.c_validcombination_id pinventoryclearing_cacctschema R
Product Inventory Clearing Account
p_costadjustment_acct numeric 10
c_validcombination.c_validcombination_id pcostadjustment_cacctschemadef R
Product Cost Adjustment Account
p_wip_acct numeric 10  √  null
c_validcombination.c_validcombination_id pwip_cacctschemadefault R
The Work in Process account is the account used Manufacturing Order
p_methodchangevariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pmethodchangevariance_cacctsch R
The Method Change Variance account is the account used Manufacturing Order
p_usagevariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pusagevariance_cacctschemadefa R
The Usage Variance account is the account used Manufacturing Order
p_ratevariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pratevariance_cacctschemadefau R
The Rate Variance account is the account used Manufacturing Order
p_mixvariance_acct numeric 10  √  null
c_validcombination.c_validcombination_id pmixvariance_cacctschemadefaul R
The Mix Variance account is the account used Manufacturing Order
p_floorstock_acct numeric 10  √  null
c_validcombination.c_validcombination_id pfloorstock_cacctschemadefault R
The Floor Stock account is the account used Manufacturing Order
p_costofproduction_acct numeric 10  √  null
c_validcombination.c_validcombination_id pcostofproduction_cacctschemad R
The Cost Of Production account is the account used Manufacturing Order
p_labor_acct numeric 10  √  null
c_validcombination.c_validcombination_id plabor_cacctschemadefault R
The Labor account is the account used Manufacturing Order
p_burden_acct numeric 10  √  null
c_validcombination.c_validcombination_id pburden_cacctschemadefault R
The Burden account is the account used Manufacturing Order
p_outsideprocessing_acct numeric 10  √  null
c_validcombination.c_validcombination_id poutsideprocessing_cacctschema R
The Outside Processing Account is the account used in Manufacturing Order
p_overhead_acct numeric 10  √  null
c_validcombination.c_validcombination_id poverhead_cacctschemadefault R
The Overhead account is the account used in Manufacturing Order
p_scrap_acct numeric 10  √  null
c_validcombination.c_validcombination_id pscrap_cacctschemadefault R
The Scrap account is the account used in Manufacturing Order
p_averagecostvariance_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id paveragecostvariance_cacctsche R
Average Cost Variance
c_acctschema_default_uu varchar 36  √  NULL::character varying C_AcctSchema_Default_UU
p_landedcostclearing_acct numeric 10  √  NULL::numeric
c_validcombination.c_validcombination_id plandedcostclearingvc_cacctsch R
Product Landed Cost Clearing Account

Table contained 2 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_acctschema_id Primary key Asc c_acctschema_default_pkey
c_acctschema_default_uu Must be unique Asc c_acctschema_default_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.