TX_INVOICES

Description:

This table maps a link from the CLARITY_TDL table via TX_ID to the Invoice tables via INVOICE_ID.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction record.
2	LINE	INTEGER	No
	The line number for the invoice associated with this transaction. Multiple invoices can be associated with this transaction.
3	ETR_BC_TYPE_C_NAME	VARCHAR	No
	Indicates whether the transaction is on a bill or a claim. May contain organization-specific values: No Category Entries: Claim Bill
4	BC_ACCEPT_DATE	DATETIME	No
	The date the bill or claim was accepted.
5	INVOICE_NUM	VARCHAR	No
	The invoice number for the transaction.
6	INVOICE_ID	NUMERIC	No
	The unique internal identifier of the invoice.