Table: acct_org_access

Previous: acct_fin_tree

Unanet Data Model

Next: acct_org_access_hierarchy

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	account_key	decimal(15)		account	fk_acct_org_access1
2.		global_access	char(1)	('Y')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
account_key	account	account_key	fk_acct_org_access1

Referenced from

Table	Column	Foreign Key Name
acct_org_access_hierarchy	account_key	fk_acct_org_access_hierarchy1
acct_org_access_parent	account_key	fk_acct_org_access_parent1

Check Constraints

Name	Definition
cc_aoa_global_access	([global_access]='N' OR [global_access]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_acct_org_access	true	account_key	Asc