Controls: show
Library Folder

Comments:

[log in] or [register] to leave a comment for this folder.

Go to: all folders

Go to: folder treetops

return to container details page
previous display
next display
Cover page Folder details

·7· City of Toronto PCard Expenditure Report Descriptors

Setup: 10-Sep-2012 [6080]

Consolidated transaction data is available in a google fusion table.

Field definitions from Open Toronto:

PCARD EXPENDITURES

Field Description
DIVISION Name of City of Toronto division
BATCH-TRANSACTION ID Unique identifier assigned by credit card company
TRANSACTION DATE Date of purchase
CARD POSTING DT Date purchase posted by credit card company
MERCHANT NAME Name of vendor where purchase was made
TRANSACTION AMOUNT Amount of purchase in Canadian currency (including amounts after conversion from other currencies)
TRANSACTION CURRENCY Currency of country
ORIGINAL AMOUNT Amount of Purchase in the currency of purchase (pre-exchange)
ORIGINAL CURRENCY Currency in which purchase was made
G/L ACCOUNT Description of the type of expense made and to be recorded
G/L ACCOUNT DESCRIPTION Long text description of the expense
COST CENTRE/WBS ELEMENT Represents the Organization Unit or the "where" a Division/Program tracks its revenues and expenditures
COST CENTRE/WBS ELEMENT DESCRIPTION Description of the Organization Unit or the "where" a Division/Program recorded its expenditure
MERCHANT TYPE (MCC) A four-digit number assigned by MasterCard and VISA to a merchant. The MCC is used to classify the business by goods/services it provides.
MERCHANT TYPE DESCRIPTION Description of the MCC assigned to the merchant
PURPOSE Free-form text describing purchase by the cardholder

·7· City of Toronto PCard Expenditure Report Descriptors

Setup: 10-Sep-2012 [6080]

-- Details --
Sorted by: ·custom order· (if any), title (asc). Page 1 of 1 (items 1-18 of 18)

PCard_Expenses_012011_FINAL.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_012011_FINAL.pdf) [6081]

PCard_Expenses_022011_FINAL.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_022011_FINAL.pdf) [6082]

PCard_Expenses_032011_FINAL.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_032011_FINAL.pdf) [6083]

PCard_Expenses_042011_FINAL.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_042011_FINAL.pdf) [6084]

PCard_Expenses_052011_FINAL.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_052011_FINAL.pdf) [6085]

PCard_Expenses_062011_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_062011_Final.pdf) [6086]

PCard_Expenses_072011_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_072011_Final.pdf) [6087]

PCard_Expenses_082011_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_082011_Final.pdf) [6088]

PCard_Expenses_092011_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_092011_Final.pdf) [6089]

PCard_Expenses_102011_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_102011_Final.pdf) [6090]

PCard_Expenses_112011_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_112011_Final.pdf) [6091]

PCard_Expenses_122011_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_122011_Final.pdf) [6092]

PCard_Expenses_201201_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_201201_Final.pdf) [6093]

PCard_Expenses_201202_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_201202_Final.pdf) [6094]

PCard_Expenses_201203_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_201203_Final.pdf) [6095]

PCard_Expenses_201204_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_201204_Final.pdf) [6096]

PCard_Expenses_201205_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (PCard_Expenses_201205_Final.pdf) [6097]

pCard_Expenses_201206_Final.pdf

Part of: City of Toronto PCard Expenditure Report Descriptors

Date: 10-Sep-2012 Source: google spreadsheet direct link (pCard_Expenses_201206_Final.pdf) [6098]

page 1 of 1 (items 1-18 of 18) per page: