Table: po_expense_line_attachment_ref

Previous: po_expense_line

Unanet Data Model

Next: po_expense_line_descriptor

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	po_attachment_reference_key	decimal(15)		po_summary_attachment_ref	fk_po_expense_line_att_ref1, fk_po_expense_line_att_ref4
2.	PK	po_expense_line_key	decimal(15)		po_expense_line	fk_po_expense_line_att_ref2
3.		po_key	decimal(15)		purchase_order	fk_po_expense_line_att_ref4, fk_po_expense_line_att_ref3

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
po_attachment_reference_key	attachment_reference	attachment_reference_key	fk_po_expense_line_att_ref1
po_expense_line_key	po_expense_line	po_expense_line_key	fk_po_expense_line_att_ref2
po_attachment_reference_key	po_summary_attachment_ref	po_attachment_reference_key	fk_po_expense_line_att_ref4
po_key		po_key
po_key	purchase_order	po_key	fk_po_expense_line_att_ref3

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_po_expense_line_att_ref	true	po_attachment_reference_key	Asc
		po_expense_line_key
idx_po_expense_line_att_ref1	false	po_expense_line_key	Asc
idx_po_expense_line_att_ref2	false	po_key	Asc