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 |