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.