BILLING_IMPORT_INFO

Description:

This table stores items that contain billing details.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	VARCHAR	No
	The unique identifier (.1 item) for the document record.
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	BILL_INVOICE_NUM	VARCHAR	No
	This item stores the invoice number.
4	BILL_ICN	VARCHAR	No
	This item stores the ICN.
5	BILL_PMT_DPST_DATE	DATETIME	No
	This item stores the payment deposit date.
6	BILL_PMT_AMT	NUMERIC	No
	This item stores the payment amount.
7	BILL_PAGE_NUM	INTEGER	No
	This item stores the document page number.
8	BILL_PAYER_NM	VARCHAR	No
	This item stores the payer name in the scanned document.
9	BILL_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
10	BILL_ACCT_ID	NUMERIC	No
	This item stores the guarantor ID.
11	BILL_HSP_ACCOUNT_ID	NUMERIC	No
	This item stores the hospital account ID.
12	BILL_REF_NUM	VARCHAR	No
	This item stores the payment reference number on the scanned document.
13	BILL_STMT_NUM	VARCHAR	No
	This item stores the statement number.
14	BILL_BDC_ID	NUMERIC	No
	This item stores the BDC ID for lines associated with follow-up records.
15	BILL_IMPORT_ERRORS	VARCHAR	No
	This item stores list of errors for the given line of the import document received from import.