INV_NUM_TX_PIECES

Description: |
Each line in this table corresponds to a transaction (ETR) composing a line on an invoice from item INV 381. Each line can contain a comma-delimited list of transactions composing a claim line. When a transaction is bundled, data will be split out to its own line via the TX_PIECE column.
This table is used as a bridge between transaction- and invoice- based tables.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INV_ID | 1 |
LINE | 2 |
TX_PIECE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INV_ID | NUMERIC | No |
This column contains the internal invoice ID.
2 | LINE | INTEGER | No |
This column contains the line number for any multiple-response item.
3 | TX_PIECE | INTEGER | No |
This column contains the position of the transaction ID in the comma-delimited list of ETR ID's for a given line of INV-381. For example, if a certain line of INV-381 has three transactions, then TX_PIECE will contain 1, 2, and 3 for that line.
4 | TX_ID | NUMERIC | No |
This column contains each individual transaction ID from the list of ETR ID's stored on each line of INV-381. So, if a given line of INV-381 has more than one transaction (separated by a comma-delimited list), then each ETR ID will appear on a separate row of the extract table. In other words, one and only one ETR ID will appear in each row of the TX_ID column.