Skip to main content
City of Albuquerque eWeb Logo

 

Go Search
Home
Human Resource Policies
Employee Services
Jobs and Training
IT Services
Templates
City Travel
City of Albuquerque IPRA
Administrative Instructions
  
City Of Albuquerque > IT Services > Data  

Data

Modify settings and columns
  
View: 
Sort by AttachmentsUse SHIFT+ENTER to open the menu (new window).
Short DescriptionFilterFull Non-Technical DescriptionFilterDataset CitationsFilterCommentsFilterDataset Definition/FormatFilterDataset Technical DescriptionFilterDataset AssumptionsFilterWho Produced the DatasetFilterWho Owns the DataFilterWhy was the Dataset CreatedFilterHow was the Dataset CreatedFilterWhat Similar or Related Data Should the User be Aware ofFilterHow Reliable are the DataFilterHow Well Have the Observations Been CheckedFilter
City CheckbookUse SHIFT+ENTER to open the menu (new window).
Castaneda, Naydene Y.DFAS - Accounts Payable(505) 768-3229ncastaneda@cabq.gov
Report lists invoices paid to a vendor by pay reference and invoice number
Data is updated daily, which shows the invoices paid to a vendor. Information is sorted by Payment Reference Number, Invoice Number, Invoice Date, Payment Date and Invoice Amount. 
7/1/2010PresentDailyNANA
The files are in a XML and CSV format.

Field Name

Format

Description

XML Format

NAME1

xs:string length=82

Vendor Name

PAYMENT REFERENCE NUMBER

xs:string length=42

 

City Check number

INVOICE NUMBER

xs:string length=62

Vendor Invoice Number

INVOICE DATE

xs:dateTime

Vendor Invoice Date

PAYMENT DATE

xs:dateTime

Payment Date

INVOICE AMOUNT

xs:decimal scale=3 precision=26

Vendor Invoice amount

CSV Format

NAME1

string

Vendor Name

PAYMENT REFERENCE NUMBER

string

City Check number

INVOICE NUMBER

string

Vendor Invoice Number

INVOICE DATE

dateTime

Vendor Invoice Date

PAYMENT DATE

dateTime

Payment Date

INVOICE AMOUNT

double

Vendor Invoice amount

File Name

File Description

VendorCheckBookCABQ-en-us.csv

File contains the listing of payments made to vendors in CSV format.

VendorCheckBookCABQ-en-us.xml

File contains the listing of payments made to vendors in XML format.

  1. Data is updated daily
  2. Data does not include secured information (e.g. garnishments)

The ERP Division of the Department of Financial and Administrative Services produces this dataset.

The Accounts Payable Section, Accounting Division of the Department of Financial and Administrative Services owns this data.

The dataset was created to allow applications to list payments made to vendors.

This dataset was created using an application called IBM Cognos using data from the PeopleSoft ERP application. The data is updated daily.

None.

The data is very reliable.

This data is produced from the production data used to pay the vendors and is as accurate as the accounts payable system in ERP.

The data was verified by the data owners, ITSD Division, and ERP Division.

Any restrictions on the information is covered at the following URL: http://www.cabq.gov/about/legalThe City's standard copyright, disclaimers and legal statements may be found at http://www.cabq.gov/about/legal.  The City data policy governing data.cabq.gov may be found at http://data.cabq.gov/policy/.Approved for Implementation
Go to Public Website (www.cabq.gov)
2007 Copyright/Disclaimer/Privacy Notice
Feedback