Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Procurement


Business area which contains Purchasing and Credit Card information


Follow the links in the Tables in Group column to see a list of all the tables used in the star/group, together with information on how to combine the tables in a query.

Follow the links in the Data Model Diagram column (if available) to see a pictorial representation of the star.

Star/Table Group

Description

Tables in Group

Data Model Diagram

Credit Card

PROTOTYPE: Details about MIT Credit Card transactions.

Credit Card tables


Purchasing Detail

This area provides a detailed view of purchase order data down to the account distribution level. In addition, summarized invoiced dollar amounts are included. Information can be limited and grouped by such categories as GL Account, Cost Object, Fiscal Period, Purchase Order Type. You will automatically be limited to viewing only those accounts you are authorized to see.

Purchasing Detail tables