MEDICAL INVOICES Table
View exposing medical-invoice payment detail including document identifiers, vendor, check number, payment document, amount paid, print date, and run date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AMOUNT_PAID |
Amount paid associated with the record. |
NUMBER |
17,2 |
CHECK_NUMBER |
Check number associated with the record. |
VARCHAR2 |
13 |
CLEARING_DOCUMENT_NUMBER |
Clearing document number associated with the record. |
VARCHAR2 |
10 |
DOCUMENT_NUMBER |
Document number associated with the record. |
VARCHAR2 |
10 |
PAYMENT_DOCUMENT_NUMBER |
Payment document number associated with the record. |
VARCHAR2 |
10 |
PRINT_DATE |
Date associated with print. |
DATE |
|
REFERENCE_DOCUMENT_NUMBER |
Reference document number associated with the record. |
VARCHAR2 |
30 |
RUN_DATE |
Date associated with run. |
DATE |
|
VENDOR_KEY |
Surrogate key identifying the vendor. |
VARCHAR2 |
11 |