Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse MEDICAL INVOICES Table


Medical invoices including check numbers. This is a subset of financial detail documents, combined with payment information.


Field Name

Description

Data Type

Length

AMOUNT_PAID

XXX

NUMBER

22

CHECK_NUMBER

XXX

VARCHAR2

13

CLEARING_DOCUMENT_NUMBER

The document number associated with this transaction and its clearing date.

VARCHAR2

10

DOCUMENT_NUMBER

The number in SAP that uniquely identifies a detailed transaction document.

VARCHAR2

10

PAYMENT_DOCUMENT_NUMBER

XXX

VARCHAR2

10

PRINT_DATE

XXX

DATE

8

REFERENCE_DOCUMENT_NUMBER

For FINANCIAL_DETAIL: The reference number of the associated financial document. A value of %N means that there is no backup for the journal voucher. For COMMITMENT tables, the document number from which the commitment was generated.

VARCHAR2

16

RUN_DATE

XXX

DATE

8

VENDOR_KEY

Key identifying an entry in the VENDOR master table. This field should only be used for linking tables together, not for reporting.

VARCHAR2

11