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