kdravie 7/21/2015 5:44:11 PM

Check Number and Check Date

I have a report requirement that wants me to list the Check Number, the Check Date (the Date the Check was issued), theTEN99AMNT and other stuff for a period of time.

I have a couple of questions having never done anything GP and looking at tables with cryptic names.

1. What field represent the Check Number? I would've thought PM30200.DOCNUMBR but I am seeing some weird things in there like January 2008 or Rent xxxx

2. What field represent the Check Date. Date Check was printed/Issued. PM30200 has DOCDATE, POSTEDDT, PSTGDATE that look like OK candidates for me but the user is telling me she is certain those aren't it.

Version: Unknown or N/A
Section: SQL Scripts, SSRS


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3