Table: onetime_charge

Previous: note_comment_attachment

Unanet Data Model

Next: onetime_charge_type

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	onetime_charge_key	decimal(15)
2.		onetime_charge_type_key	decimal(15)		onetime_charge_type	fk_onetime_charge2
3.		invoice_key	decimal(15)		invoice	fk_onetime_charge3
4.		project_key	decimal(15)		project	fk_onetime_charge1
5.		task_key	decimal(15)		task	fk_onetime_charge4
6.		description	varchar(128)
7.		amount	decimal(18,2)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
invoice_key	invoice	invoice_key	fk_onetime_charge3
onetime_charge_type_key	onetime_charge_type	onetime_charge_type_key	fk_onetime_charge2
project_key	project	project_key	fk_onetime_charge1
task_key	task	task_key	fk_onetime_charge4

Referenced from

Table	Column	Foreign Key Name
journal_onetime_charge	onetime_charge_key	fk_journal_onetime_charge1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_onetime_charge	true	onetime_charge_key	Asc
idx_onetime_charge1	false	project_key	Asc
idx_onetime_charge2	false	invoice_key	Asc
idx_onetime_charge3	false	onetime_charge_type_key	Asc
idx_onetime_charge4	false	task_key	Asc

Dependent Views

View Name
journal_view