INV_PROC_LIST

Description:

This table holds a list of procedures associated with the invoice.

Primary Key

Column Name	Ordinal Position
INVOICE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	INVOICE_ID	NUMERIC	No
	The internal ID of the invoice number.
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	PROC_CODES_UB	VARCHAR	No
	The procedure code. This item is only set on UB claims.
4	PROC_ID_PROC_NAME	VARCHAR	No
	The name of each procedure.
5	INV_EXT_ID	VARCHAR	No
	The unique external ID of the invoice number.
6	INV_NUM_100_GRP_LN	INTEGER	No
	Claim line number that the diagnosis entry applies to. This is the line number that links the INV_PROC_LIST table with the LINE column in the INV_BASIC_INFO table.