|
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. |
|
|