Docstoc

Sample Data Request Form

Document Sample
Sample Data Request Form Powered By Docstoc
					                          Sample Data Request Form

Data Required
All procurement card transaction data for the year 2008 and card master data.

Format
Please provide data in one of the following formats (in order of preference),
• Delimited (use ~ or | as delimiter)
• MS Excel
• ODBC compatible format

File Transfer
Data can be provided via CD, DVD, FTP. Large files can be compressed using an application
such as WinZip.

Required Data
Please supply the following data elements in a single file or multiple files sharing at least
one common key field such as Card Number. Please include the information below to
ensure data completeness and accuracy.
1. A file layout or data definition describing each column, type (numeric, text, etc), any any
   other critical information such as date format or decimal places.
2. The total record count and a control total for the files.


Card Transaction - Required Data

Required        Description / Information                      Field Name in File Provided
Fields
Card Number The card used for the transaction.                 <please complete this section>

Transaction     Date the transaction was conducted.
Date
Merchant        Name of the merchant where the
Name            purchases were made.
Total Amount Total amount of the transaction.



Card Master Information – Required Data

Required        Description                                    Field Name in File Provided
Fields
Card Number The card used for the transaction.                 <please complete this section>




                                                                               Page 1 of 2
                        Sample Data Request Form

Cardholder     First & Last name are preferred.
Name           Personal information can be excluded
               from reporting, however names are
               required for card management analysis.
Card Limit –   Required for single purchase limit
Single         analysis.
Purchase
Card Limit –   Required for monthly purchase limit
Monthly        analysis.
Card Billing   Only required if the billing address is the
Address        employee’s home address.




                                                             Page 2 of 2

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:19
posted:2/22/2011
language:English
pages:2