| Previous: general_alert_prefs | Unanet Data Model | Next: holiday |
| 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 | ||
| 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 |
| 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_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 |
| 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') |
| 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 |