Table: account

Unanet Data Model Next: accrual_period
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK account_key decimal(15)      
2.   account_code varchar(25)      
3.   description varchar(128)      
4.   type char(1)      
5.   active char(1)      
6.   entry_allowed char(1) ('N')    
7.   begin_date datetime      
8.   end_date datetime      
9.   project_required char(1) ('N')    
10.   hide_income_stmt_hdr char(1) ('N')    
11.   category_1099 varchar(5)      
Referenced from
Table Column Foreign Key Name
acct_cost_pool_tree node_key fk_acct_cost_pool_tree1
acct_cost_pool_tree parent_key fk_acct_cost_pool_tree2
acct_fin_tree node_key fk_acct_fin_tree1
acct_fin_tree parent_key fk_acct_fin_tree2
acct_org_access account_key fk_acct_org_access1
bank_account account_key fk_bank_account1
budget_detail account_key fk_budget_detail2
cost_element_account account_key fk_cost_element_account2
cost_pool_basis account_key fk_cost_pool_basis2
cost_pool_basis post_account_key fk_cost_pool_basis4
cost_pool_basis_calc account_key fk_cost_pool_basis_calc2
cost_pool_basis_calc post_account_key fk_cost_pool_basis_calc4
cost_pool_source account_key fk_cost_pool_source2
cost_pool_source post_account_key fk_cost_pool_source4
cost_pool_source_calc account_key fk_cost_pool_source_calc2
cost_pool_source_calc post_account_key fk_cost_pool_source_calc4
customer_account account_key fk_customer_account2
customer_payment account_key fk_customer_payment8
customer_payment_unapplied account_key fk_customer_payment_unapplied3
deposit account_key fk_deposit3
employee_type_account account_key fk_employee_type_account2
expense_data_allocation cost_account_key fk_expense_data_allocation9
expense_type cost_account_key fk_expense_type3
expense_type_account account_key fk_expense_type_account2
fin_document_detail account_key fk_fin_document_detail2
general_ledger account_key fk_general_ledger2
invoice billed_account_key fk_invoice11
journal_cost_plus_detail account_key fk_journal_cost_plus_detail2
journal_document_expense account_key fk_journal_document_expense2
journal_document_item account_key fk_journal_document_item2
journal_document_labor account_key fk_journal_document_labor2
journal_expense account_key fk_journal_expense2
journal_fee_cap_adjustment account_key fk_journal_fee_cap_adjust2
journal_fixed_price account_key fk_journal_fixed_price2
journal_funding_cap_adjustment account_key fk_journal_funding_cap_adj2
journal_onetime_charge account_key fk_journal_onetime_charge2
journal_prebilled_labor account_key fk_journal_prebilled_labor2
journal_time account_key fk_journal_time2
labor_category_account account_key fk_labor_category_account2
onetime_charge_type_account account_key fk_onetime_charge_type_acct2
pay_code_account account_key fk_pay_code_account2
payment_method_account account_key fk_payment_method_account2
person_account account_key fk_person_account2
po_expense_line_descriptor account_key fk_po_expense_line_descr4
po_item_line_descriptor account_key fk_po_item_line_descr4
po_labor_line_descriptor account_key fk_po_labor_line_descr4
posting_group_source account_key fk_posting_group_source2
pr_expense_line_descriptor account_key fk_pr_expense_line_descr3
pr_item_line_descriptor account_key fk_pr_item_line_descr3
pr_labor_line_descriptor account_key fk_pr_labor_line_descr3
project_account account_key fk_project_account1
project_type_account account_key fk_project_type_account2
project_type_exp_type_acct account_key fk_project_type_exp_type_acct3
task_account account_key fk_task_account2
vendor_invoice account_key fk_vendor_invoice4
vendor_payment account_key fk_vendor_payment7
vendor_payment_unapplied account_key fk_vendor_payment_unapplied3
vi_funding_cap_adjustment account_key fk_vi_funding_cap_adjustment6
vi_included_expense account_key fk_vi_included_expense3
vi_included_time account_key fk_vi_included_time3
Check Constraints
Name Definition
cc_account_active ([active]='N' OR [active]='Y')
cc_account_begin_date ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_account_category_1099 ([category_1099]='16b' OR [category_1099]='16a' OR [category_1099]='15b' OR [category_1099]='15a' OR [category_1099]='14' OR [category_1099]='13' OR [category_1099]='10' OR [category_1099]='9' OR [category_1099]='8' OR [category_1099]='7' OR [category_1099]='6' OR [category_1099]='5' OR [category_1099]='4' OR [category_1099]='3' OR [category_1099]='2' OR [category_1099]='1')
cc_account_end_date ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
cc_account_entry_allowed ([entry_allowed]='N' OR [entry_allowed]='Y')
cc_account_hide_income_stmt ([hide_income_stmt_hdr]='N' OR [hide_income_stmt_hdr]='Y')
cc_account_project_required ([project_required]='N' OR [project_required]='Y')
cc_account_type ([type]='L' OR [type]='R' OR [type]='E' OR [type]='A')
Indices
Index Name Unique Column Name Asc Or Desc
pk_account true account_key Asc
idx_account1 true account_code Asc
Dependent Views
View Name
journal_view
vendor_payment_1099_view