INV_ATTACHMENTS

Description:

This table stores invoice-level attachment information.

Primary Key

Column Name	Ordinal Position
INVOICE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	INVOICE_ID	NUMERIC	No
	The invoice record ID.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	INV_ATTACH_INV_NUM	VARCHAR	No
	Invoice number for the related group.
4	INV_ATTACH_ROI_ID	VARCHAR	No
	The request for information record for the invoice.
5	INV_ATTACHMENT_CONTROL_NUM	VARCHAR	No
	The attachment control number.
6	INV_ATTACHMENT_GENERATED_YN	VARCHAR	No
	Identifies if an attachment was generated. May contain organization-specific values: No Category Entries: No Yes
7	INV_ATTACH_EDITED_YN	VARCHAR	No
	Identifies if an attachment was edited. The category values for this column were already listed for column: INV_ATTACHMENT_GENERATED_YN
8	INV_ATTACH_REMOVED_YN	VARCHAR	No
	Identifies if a user removed the attachment from a workqueue. The category values for this column were already listed for column: INV_ATTACHMENT_GENERATED_YN