Table: posting_group_source

Previous: posting_group

Unanet Data Model

Next: prebill_invc_sect_fmt

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	posting_group_source_key	decimal(15)
2.		posting_group_key	decimal(15)		posting_group	fk_posting_group_source1
3.		category	tinyint
4.		account_key	decimal(15)		account	fk_posting_group_source2
5.		account_source	char(1)	('0')
6.		org_source	char(1)	('0')
7.		legal_entity	char(1)	('N')
8.		pay_code	char(1)	('N')
9.		project_type	char(1)	('N')
10.		project	char(1)	('N')
11.		task	char(1)	('N')
12.		employee_type	char(1)	('N')
13.		labor_category	char(1)	('N')
14.		cost_element	char(1)	('N')
15.		person	char(1)	('N')
16.		expense_type	char(1)	('N')
17.		onetime_charge_type	char(1)	('N')
18.		payment_method	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
account_key	account	account_key	fk_posting_group_source2
posting_group_key	posting_group	posting_group_key	fk_posting_group_source1

Check Constraints

Name	Definition
cc_cost_element	([cost_element]='N' OR [cost_element]='Y')
cc_employee_type	([employee_type]='N' OR [employee_type]='Y')
cc_expense_type	([expense_type]='N' OR [expense_type]='Y')
cc_labor_category	([labor_category]='N' OR [labor_category]='Y')
cc_legal_entity	([legal_entity]='N' OR [legal_entity]='Y')
cc_onetime_charge_type	([onetime_charge_type]='N' OR [onetime_charge_type]='Y')
cc_pay_code	([pay_code]='N' OR [pay_code]='Y')
cc_payment_method	([payment_method]='N' OR [payment_method]='Y')
cc_person	([person]='N' OR [person]='Y')
cc_posting_group_src_account	([account_source]<>'0' OR [account_key] IS NOT NULL)
cc_posting_group_src_account1	([account_source]='1' OR [account_source]='0')
cc_posting_group_src_org	([org_source]='3' OR [org_source]='2' OR [org_source]='1' OR [org_source]='0')
cc_project	([project]='N' OR [project]='Y')
cc_project_type	([project_type]='N' OR [project_type]='Y')
cc_task	([task]='N' OR [task]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_posting_group_source	true	posting_group_source_key	Asc
idx_posting_group_source1	false	posting_group_key	Asc
idx_posting_group_source2	false	account_key	Asc