Skip to content Accesskey=4Skip to sub-navigation Accesskey=3View our Accessibility Options MIT Information Services and Technology Home About IS&T Contact IS&T Site Map Search Advanced Search
Getting StartedGetting Services by Topic or Alphabetically Getting Help

data warehouse logo

 
Related Links:
 

Data and Reporting Services


Credit Card

 

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

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

05-JUL-2009

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.

Dimension

SAP Financial

MIT ONLY

Daily

05-JUL-2009

TIME_MONTH

Monthly calendar information. For use in joining tables to include a time dimension to the report. Use the Time_Month_Key to join.

Dimension

Data Warehouse

PUBLIC

As Needed

14-JUN-2003

CREDIT_CARD_MASTER

Contains information about credit cards and their users.

Dimension

SAP Financial

SENSITIVE

Daily

05-JUL-2009

CREDIT_CARD_DETAIL

Credit card Transactions. Taken from table BSEG in SAP.

Fact

SAP Financial

SENSITIVE

Daily

05-JUL-2009

GL_ACCOUNT

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

Dimension

SAP Financial

SENSITIVE

Daily

05-JUL-2009

CREDIT_CARD_ACCT_ASSIGNMENT

Contains information about default account assignment rules for credit cards.

Dimension

SAP Financial

SENSITIVE

Daily

05-JUL-2009

CREDIT_CARD_VERIFIER

Contains information about credit card verifiers.

Dimension

SAP Financial

SENSITIVE

Daily

05-JUL-2009

MIT Home | Getting Started | Getting Services | Getting Help | About IS&T | Accessibility
Ask a technology question or send a comment about this web page.