Table: general_ledger

Previous: general_alert_prefs Unanet Data Model Next: holiday
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK general_ledger_key decimal(15)      
2.   feature tinyint      
3.   post_date datetime      
4.   fiscal_month_key decimal(15)   fiscal_month fk_general_ledger1
5.   account_key decimal(15)   account fk_general_ledger2
6.   organization_key decimal(15)   customer fk_general_ledger3
7.   document_number varchar(50)      
8.   reference varchar(25)      
9.   description varchar(128)      
10.   transaction_date datetime      
11.   quantity decimal(18,3)      
12.   debit_amount decimal(18,2) ((0))    
13.   credit_amount decimal(18,2) ((0))    
14.   project_key decimal(15)   project fk_general_ledger4
15.   person_key decimal(15)   person fk_general_ledger5
16.   customer_key decimal(15)   customer fk_general_ledger6
Foreign Keys
Column References Foreign Key Name
Table Column
account_key account account_key fk_general_ledger2
organization_key customer customer_key fk_general_ledger3
customer_key customer customer_key fk_general_ledger6
fiscal_month_key fiscal_month fiscal_month_key fk_general_ledger1
person_key person person_key fk_general_ledger5
project_key project project_key fk_general_ledger4
Referenced from
Table Column Foreign Key Name
bank_reconciliation_detail general_ledger_key fk_bank_rec_dtl2
customer_payment general_ledger_key fk_customer_payment5
customer_payment_included_inv applied_general_ledger_key fk_cust_payment_included_inv3
customer_payment_included_inv discount_general_ledger_key fk_cust_payment_included_inv4
customer_payment_included_inv writeoff_general_ledger_key fk_cust_payment_included_inv5
customer_payment_included_pmt applied_general_ledger_key fk_cust_payment_included_pmt3
customer_payment_unapplied general_ledger_key fk_customer_payment_unapplied4
deposit general_ledger_key fk_deposit5
deposit_included general_ledger_key fk_deposit_included3
fin_document_detail general_ledger_key fk_fin_document_detail5
journal_cost_plus_detail general_ledger_key fk_journal_cost_plus_detail7
journal_document_expense general_ledger_key fk_journal_document_expense7
journal_document_item general_ledger_key fk_journal_document_item7
journal_document_labor general_ledger_key fk_journal_document_labor7
journal_expense general_ledger_key fk_journal_expense7
journal_fee_cap_adjustment general_ledger_key fk_journal_fee_cap_adjust7
journal_fixed_price general_ledger_key fk_journal_fixed_price7
journal_funding_cap_adjustment general_ledger_key fk_journal_funding_cap_adj7
journal_onetime_charge general_ledger_key fk_journal_onetime_charge5
journal_prebilled_labor general_ledger_key fk_journal_prebilled_labor7
journal_time general_ledger_key fk_journal_time7
vendor_invoice general_ledger_key fk_vendor_invoice6
vendor_payment general_ledger_key fk_vendor_payment4
vendor_payment_included applied_general_ledger_key fk_vendor_payment_included3
vendor_payment_included discount_general_ledger_key fk_vendor_payment_included4
vendor_payment_unapplied general_ledger_key fk_vendor_payment_unapplied4
vi_funding_cap_adjustment general_ledger_key fk_vi_funding_cap_adjustment8
vi_included_expense general_ledger_key fk_vi_included_expense5
vi_included_time general_ledger_key fk_vi_included_time5
Check Constraints
Name Definition
cc_gl_amount (NOT ([debit_amount]<>(0) AND [credit_amount]<>(0)))
cc_gl_feature ([feature]>=(0) AND [feature]<=(99))
cc_gl_transaction_date ([transaction_date]>='1900-01-01' AND [transaction_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_general_ledger true general_ledger_key Asc
idx_general_ledger1 false fiscal_month_key Asc
idx_general_ledger2 false organization_key Asc
    account_key  
idx_general_ledger3 false document_number Asc
idx_general_ledger4 false project_key Asc
idx_general_ledger5 false account_key Asc