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 |
|---|---|---|---|---|---|---|
Contains codes and descriptions for all MIT's Purchasing Organizations |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Contains codes and descriptions of material groups used in categorizing items ordered through Purchase Orders. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Contains codes, descriptions and phone numbers for MIT's Purchasing Groups |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Contains both Project information from SAP and additional information from COEUS |
Dimension |
OSP - MIT Office of Sponsored Programs |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Contains data about each sponsor. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
02-MAY-2015 |
|
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 |
01-JAN-2025 |
|
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Sub set of cost collectors which represent balance sheet accounts. |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
01-JAN-2025 |
|
Daily calendar information. For use in joining tables to include a time dimension to the report. |
Dimension |
PUBLIC |
As Needed |
01-JAN-2025 |
||
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 |
01-JAN-2025 |
|
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 |
01-JAN-2025 |
|
Internal Order Dimension. Contains Master data about all Internal Orders |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
01-JAN-2025 |
|
Contains information about the type of purchase order. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
31-DEC-2024 |