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.