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 |
|---|---|---|---|---|---|---|
GL Account & Cost Element Dimension. Roughly equivalent to the old Object Code |
Dimension |
SAP Financial |
MIT ONLY |
Daily |
18-APR-2024 |
|
Credit card Transactions. Taken from table BSEG in SAP. |
Fact |
SAP Financial |
SENSITIVE |
Daily |
17-APR-2024 |
|
Contains information about credit cards and their users. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
17-APR-2024 |
|
Contains information about credit card verifiers. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
17-APR-2024 |
|
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 |
18-APR-2024 |
|
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 |
18-APR-2024 |
|
Contains information about default account assignment rules for credit cards. |
Dimension |
SAP Financial |
SENSITIVE |
Daily |
17-APR-2024 |
|
Monthly calendar information. For use in joining tables to include a time dimension to the report. Use the Time_Month_Key to join. |
Dimension |
PUBLIC |
As Needed |
18-APR-2024 |