Table: onetime_charge_type

Previous: onetime_charge

Unanet Data Model

Next: onetime_charge_type_account

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	onetime_charge_type_key	decimal(15)
2.		name	varchar(50)
3.		debit_account_category	tinyint
4.		credit_account_category	tinyint
5.		active	char(1)

Referenced from

Table	Column	Foreign Key Name
onetime_charge	onetime_charge_type_key	fk_onetime_charge2
onetime_charge_type_account	onetime_charge_type_key	fk_onetime_charge_type_acct1
onetime_charge_type_invc_fltr	onetime_charge_type_key	fk_onetime_chrg_ty_invc_fltr2

Check Constraints

Name	Definition
cc_oct_credit_acct_cat	([credit_account_category]>=(1) AND [credit_account_category]<=(99))
cc_oct_debit_acct_cat	([debit_account_category]>=(1) AND [debit_account_category]<=(99))
cc_onetime_charge_type_active	([active]='N' OR [active]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_onetime_charge_type	true	onetime_charge_type_key	Asc
idx_onetime_charge_type1	true	name	Asc