Table: pr_attachment_reference

Previous: posting_group_source

Unanet Data Model

Next: pr_cust_approval_status

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	attachment_reference_key	decimal(15)		attachment_reference	fk_pr_attachment_reference2
2.		orig_pr_key	decimal(15)		purchase_requisition	fk_pr_attachment_reference1
3.		copy_to_po	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
attachment_reference_key	attachment_reference	attachment_reference_key	fk_pr_attachment_reference2
orig_pr_key	purchase_requisition	pr_key	fk_pr_attachment_reference1

Check Constraints

Name	Definition
cc_pr_attachment_reference	([copy_to_po]='N' OR [copy_to_po]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_pr_attachment_reference	true	attachment_reference_key	Asc
idx_pr_attachment_reference	false	orig_pr_key	Asc