Customizable Payments Listing Report- Field Descriptions

Have more questions? Submit a request

This article provides descriptions for the fields available in the Customizable Payment Listing Report. For more information about how to build this report, click here. Note: these fields are also applicable to any payments report that has the "Customize" option available. For a full list of reports, click here. 

  • Field Name- the name of the field
  • Group- whether the field can be grouped
  • Split- whether the field can be split using the "Adjust Values" checkbox
  • Total- whether the field can be totaled
  • Field Descriptions- the description of the field

A column with an "N" represents "No", whereas a column with a "Y" represents "Yes."

Field Name  Group Split Total Field Descriptions
***** Row Break ***** N N N Inserts a row break between fields in the report
Adjustment Amount N N Y Total adjustment amount in the payment
Adjustment Description Y N N Payment adjustment description
Applied Amount N N Y Total applied amount in the payment
Check Amount N N Y Total amount of the payment
Check Date N Y N The create date of the payment
Check Number Y Y N Payment check number
Customer Y Y N Direct Customer
Customer ID Y Y N Direct Customer - ID
Difference N N Y Check Amount - Reconciled + Adjustment
Manufacturer Y Y N Manufacturer or brand
Manufacturer ID Y Y N Manufacturer or brand - ID
Parent Manufacturer Y Y N Parent manufacturer or brand
Payment ID Y Y N Behind the scenes ID for the Payment in OASIS
PaymentURIs Y Y Y Payment URIs
PMTLinkID Y Y N Internal unique OASIS number identifying an individual payment line
Posted Y Y N Is the payment posted - Y/N
Posted Date N Y N The date the payment was posted
Received Date N Y N Date the check was received
Received Month Y Y N Month the check was received
Received Year Y Y N Year the check was received
Reconciled Amount N N Y Total reconciled amount in the payment
Sales Account Y Y N Sales account on the invoice
Sales Account Workgroup Y Y N The workgroup for the sales account on the payment
Sales Account(List) N Y N Sales account on the invoice (including %)
Ship City Y Y N Shipping address city
Ship Country Y Y N Shipping address country
Ship State Y Y N Shipping address state
Ship ZIP code Y Y N Shipping address ZIP code
Update User Y Y N User that last updated the payment
WorkGroup Y Y N Name of Workgroup the related order was created in

Articles in this section

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.