Table: journal_onetime_charge

Previous: journal_funding_cap_adjustment

Unanet Data Model

Next: journal_prebilled_labor

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	journal_key	decimal(15)
2.		journal_trans_date	datetime
3.		onetime_charge_key	decimal(15)		onetime_charge	fk_journal_onetime_charge1
4.		organization_key	decimal(15)		customer	fk_journal_onetime_charge4
5.		general_ledger_key	decimal(15)		general_ledger	fk_journal_onetime_charge5
6.		account_key	decimal(15)		account	fk_journal_onetime_charge2
7.		project_key	decimal(15)		project	fk_journal_onetime_charge3
8.		category	tinyint
9.		amount	decimal(18,2)
10.		extract_date	datetime

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
account_key	account	account_key	fk_journal_onetime_charge2
organization_key	customer	customer_key	fk_journal_onetime_charge4
general_ledger_key	general_ledger	general_ledger_key	fk_journal_onetime_charge5
onetime_charge_key	onetime_charge	onetime_charge_key	fk_journal_onetime_charge1
project_key	project	project_key	fk_journal_onetime_charge3

Check Constraints

Name	Definition
cc_jot_journal_trans_date	([journal_trans_date]>='1900-01-01' AND [journal_trans_date]<='2099-12-31')
cc_journal_onetime_charge_cat	([category]>=(1) AND [category]<=(99))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_journal_onetime_charge	true	journal_key	Asc
idx_journal_onetime_charge1	false	project_key	Asc
idx_journal_onetime_charge2	false	onetime_charge_key	Asc
idx_journal_onetime_charge3	false	organization_key	Asc
idx_journal_onetime_charge4	false	general_ledger_key	Asc
idx_journal_onetime_charge5	false	account_key	Asc

Dependent Views

View Name
journal_view