SMART Messages

SMART Logo

 
MESSAGE 031711-01
DATE March 17, 2011
AUTHOR Data Warehouse
Subject New Subject Area is Now Available in the Data Warehouse
Message Text: Dear Colleague

We are pleased to announce that the following subject area is now available in the data warehouse:

SCM – PROC – KS P-Card
Data is based on P-Card information in SMART, including limited PO and voucher information, where applicable
P-Card numbers will only include the last four digits
Data extracted on weeknights
Data available is based on P-Card Holder Business Unit security

NOTE: To add totals to a Fact column, the Fact must be an aggregated column. Due to the granular nature of this subject area, Merchandise Amount, Quantity PO and Sales Tax Amount are aggregated columns. The Fact columns below come from the P-Card transaction line and should have the Transaction Number and Transaction Line Number included in the request. Without including the Transaction Line Number, the data will not be complete. See Help Desk Solution Article # 706.
· Dispute Amount
· Unit Price

In Includes:
P-Card details, including transaction line and transaction distribution line information
Purchase order information from the header, line, and distribution line levels when it exists related to the P-Card
Payment information when it exists relates to the P-Card
Transaction Status
Reconciliation Status
Merchant Information
P-Card issue and expiration dates
Dispute Amounts
Merchandise Amounts from the P-Card transaction

Example Reports:
P-Card transactions by PO
P-Card transactions by Status
P-Card transaction by Amount
P-Card transaction Amounts by Employee
P-Card transaction by Voucher

NOTE: THE DATA IN THE KS P-CARD SUBJECT AREA IS BASED ON THE LAST DATE THE DATA WAREHOUSE JOB WAS RUN. THE LAST DATE THE DATA WAREHOUSE JOB FINISHED WAS 3/15/2011 AT 3:07 AM. THE JOB STATUSES ARE FOUND ON THE DATA WAREHOUSE HOME DASHBOARD.

SMART Team

 

 

 

Quick Links

Search the Site

Contact Us

Send us an email

Sign Up

Sign up for the SMART InfoList