PCard Expenses
Dataset description:
This dataset contains details of all purchases made by City staff members using City-issued credit cards also referred to as PCards or purchasing cards. Council PCard expenses are not...
ምንጭ: PCard Expenditures
ለዚህ የመረጃ ምንጭ የተፈጠረ እይታ ገና የለም።
የመረጃ መዝገበ-ቃላት
- 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 |
| ልዕለ-መረጃ ለመጨረሻ ጊዜ የተሻሻለው | 27 ኦገስት 2026 |
| ተፈጥሯል | 26 ጁን 2026 |
| ቅርጸት | XLS |
| ፈቃድ | License not specified |
| Datastore active | True |
| Datastore cache | {'CSV': '24b9c441-e6e6-4f81-aea0-315f613c1e6e', 'XML': '5e9f5649-eb68-402e-9497-73b2d8cc47e0', 'JSON': 'ba56c887-3539-4bc9-9c8b-d2be1ddb1ad3'} |
| Datastore cache last update | ከ2 ሳምንታት በፊት |
| Extract job | Airflow: Integration Pipeline pcard-expenditures |
| Has views | False |
| Id | 92b1fb6d-a79c-4994-aef2-eccd940cd6e5 |
| Is preview | True |
| Mimetype | application/vnd.ms-excel |
| Package id | ebc3f9c2-2f80-4405-bf4f-5fb309581485 |
| Position | 0 |
| Record count | 866,457 |
| State | active |
| Url type | datastore |
| Extract Job | Airflow: Integration Pipeline pcard-expenditures |
| Is Datastore Cache File? | |
| Datastore Cache |
|
| Datastore Cache Last Updated | |
| Datastore resource's ID |