TX_NDC_INFORMATION

Description:

This table contains Medical National Drug Code (NDC) information. Since one transaction may be associated with multiple NDC codes, each row in this table represents one NDC code and is identified by the transaction ID and line number. The data for this table is extracted using a KB_SQL query.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique accounts receivable transaction record ID.
2	LINE	INTEGER	No
	Line number to identify each row of Medical National Drug Code (NDC) data associated with an individual transaction.
3	NDC_CODES_ID	VARCHAR	No
	The ID of the Medical National Drug Code (NDC) associated with a transaction.
4	NDC_CODES_ID_NDC_CODE	VARCHAR	No
	The external code for the National Drug Code (NDC). An NDC represents packages of medications.
5	NDC_CODES_ADMIN_AMT	NUMERIC	No
	The NDC amount associated with this charge.
6	NDC_CODES_UNIT_C_NAME	VARCHAR	No
	The Medical National Drug Code (NDC) unit associated with the charge. May contain organization-specific values: No Category Entries: Milliliters Milligrams Grams International Units Units