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 |
Comments
0 commentsPlease sign in to leave a comment.