Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Purchasing Detail


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

PURCHASING_ORG

Contains codes and descriptions for all MIT's Purchasing Organizations

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

VENDOR

Contains data about vendors: vendor name, address, vendor number in SAP, telephone and fax numbers, and other contact information.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

COST_COLLECTOR

Contains Master data information about all three types of cost collectors (Cost Centers, Internal Orders, & Projects/WBS Elements). It only contains the fields common to all three. Cost Collector is a term synonymous with Cost Object.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

COST_CENTER

Contains MIT Cost Center Ids and related information. It can be used for browsing, establishing limits on fact table queries, and providing descriptive information about Cost Centers.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

MATERIAL_GROUP

Contains codes and descriptions of material groups used in categorizing items ordered through Purchase Orders.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

PURCHASING_GROUP

Contains codes, descriptions and phone numbers for MIT's Purchasing Groups

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

PROJECT_OSP

Contains both Project information from SAP and additional information from COEUS

Dimension

OSP - MIT Office of Sponsored Programs

MIT ONLY

Daily

08-JAN-2020

SPONSOR

Contains data about each sponsor.

Dimension

SAP Financial

MIT ONLY

Daily

02-MAY-2015

PURCHASING_DETAIL

The Purchasing Detail table provides a detailed view of purchase order information, right down to the Account Distribution (or Account Assignment) level. Thus each record in this table represents the fraction of a PO Line Item that was assigned to a single account (or more accurately a given Cost Collector/GL Account pair). A record in this table is uniquely identified by the combination of PO Number, PO Line Number and Account Assignment Number. The only additive fields in this table are ordered qty & amount (representing qty & dollars on the PO assigned to the account), commitment qty &amount (the current open commitment qty & dollar amount for this record) and invoiced qty &amount (the qty & dollar amount for this record which has been invoiced). All other numeric amounts on the table are informational only - they should not be summed on a report.

Fact

SAP Financial

SENSITIVE

Daily

08-JAN-2020

GL_ACCOUNT

GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

FUND_ACCOUNT

Subset of cost collectors defined as Sponsored or Non-Sponsored Funds. (This table should not be confused with SAP funds or fund centers.)

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

BALANCE_SHEET_ACCOUNT

Sub set of cost collectors which represent balance sheet accounts.

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

TIME_DAY

Daily calendar information. For use in joining tables to include a time dimension to the report.

Dimension

PUBLIC

As Needed

14-JUN-2003

PROJECT

Contains a record for each project work breakdown structure element (WBS Element). Can be used for browsing, establishing limits on fact table queries and providing descriptive information about WBS Elements.

Dimension

SAP Financial

SENSITIVE

Daily

08-JAN-2020

GL_ACCOUNT_REPORT

GL Account and Cost Element Dimension with built-in mechanism for organizing in preset Cost Element (GL Account) groups, derived from Cost Element Hierarchies (groups) in SAP. The value in the field Report-Type describes the type of grouping as it is defined in SAP. IMPORTANT: "REPORT TYPE" MUST BE SPECIFIED as a limit, for the query to return correct results. For more details see: GL Account Overview

Dimension

SAP Financial

MIT ONLY

Daily

08-JAN-2020

INTERNAL_ORDER

Internal Order Dimension. Contains Master data about all Internal Orders

Dimension

SAP Financial

SENSITIVE

Daily

08-JAN-2020

PURCHASE_ORDER_TYPE

Contains information about the type of purchase order.

Dimension

SAP Financial

SENSITIVE

Daily

08-JAN-2020