PowerSchool ERP New York

Pre-Warrant Report - File Layout and Data Mapping

The default Pre-Warrant report file names are:

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

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

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

Column

Name

A

WARRANT NUMBER

B

FUND

C

VENDOR/PAYER NUMBER

D

VENDOR NAME

E

ACCOUNT NUMBER

F

ACCOUNT NAME

G

PURCHASE ORDER NUMBER

H

TYPE

I

CHECK DATE

J

PAYMENT AMOUNT

K

CHECK NUMBER