PowerSchool ERP New York

Warrant Report - File Layout and Data Mapping

The default Warrant report file names are:

  • Excel: NY Warrant Report_<MMDDYYYY>_<hhmmss>.xlsx

  • PDF: NY Warrant Report_<MMDDYYYY>_<hhmmss>.pdf

The following table shows the columns and names for the Warrant report’s Excel file.

Column

Name

A

WARRANT NUMBER

B

FUND

C

VENDOR/PAYER NUMBER

D

VENDOR NAME

E

FULL ACCOUNT NUMBER

F

ACCOUNT NAME

G

PURCHASE ORDER NUMBER

H

TYPE

I

CHECK DATE

J

PAYMENT AMOUNT

K

CHECK NUMBER