Λεξικό Δεδομένων

ID
Division
Τύπος
text
Περιγραφή

Name of City of Toronto division

ID
Batch-Transaction ID
Τύπος
text
Περιγραφή

Unique identifier assigned by credit card company

ID
Transaction Date
Τύπος
text
Περιγραφή

Date of purchase

ID
Card Posting Dt
Τύπος
text
Περιγραφή

Date purchase posted by credit card company

ID
Merchant Name
Τύπος
text
Περιγραφή

Name of vendor where purchase was made

ID
Transaction Amt.
Τύπος
text
Περιγραφή

Amount of purchase in Canadian currency (including amounts after conversion from other currencies)

ID
Transaction Currency
Τύπος
text
Περιγραφή

Currency of country

ID
Original Amount
Τύπος
text
Περιγραφή

Amount of Purchase in the currency of purchase (pre-exchange)

ID
Original Currency
Τύπος
text
Περιγραφή

Currency in which purchase was made

ID
G/L Account
Τύπος
text
Περιγραφή

Description of the type of expense made and to be recorded

ID
G/L Account Description
Τύπος
text
Περιγραφή

Long text description of the expense

ID
Cost Centre / WBS Element / Order Number
Τύπος
text
Περιγραφή

Represents the Organization Unit or the "where" a Division/Program tracks its revenues and expenditures

ID
Cost Centre / WBS Element / Order Number Description
Τύπος
text
Περιγραφή

Description of the Organization Unit or the "where" a Division/Program recorded its expenditure

ID
Merchant Type
Τύπος
text
Περιγραφή

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.

ID
Merchant Type Description
Τύπος
text
Περιγραφή

Description of the MCC assigned to the merchant

ID
Purpose
Τύπος
text
Περιγραφή

Free-form text describing purchase by the cardholder

Πρόσθετες Πληροφορίες

Πεδίο Τιμή
Προσφάτως ενημερωμένα δεδομένα 26 Ιουνίου 2026
Προσφάτως ενημερωμένα μεταδεδομένα 26 Ιουνίου 2026
Δημιουργήθηκε 26 Ιουνίου 2026
Διαμόρφωση XLS
Άδεια License not specified
Datastore activeTrue
Datastore cache{'CSV': '24b9c441-e6e6-4f81-aea0-315f613c1e6e', 'XML': '5e9f5649-eb68-402e-9497-73b2d8cc47e0', 'JSON': 'ba56c887-3539-4bc9-9c8b-d2be1ddb1ad3'}
Datastore cache last updateπριν από 5 ημέρες
Extract jobAirflow: Integration Pipeline pcard-expenditures
Has viewsTrue
Id92b1fb6d-a79c-4994-aef2-eccd940cd6e5
Is previewTrue
Mimetypeapplication/vnd.ms-excel
Package idebc3f9c2-2f80-4405-bf4f-5fb309581485
Position0
Record count819.993
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline pcard-expenditures
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID