This article provides descriptions for the fields available in the Customizable Payments Listing - Line Level Report. For more information about how to build this report, click here.Note: these fields are also applicable to any line-level 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 Description |
| ***** Row Break ***** | N | N | N | Inserts a row break between fields on 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 |
| Close Invoice | Y | Y | N | Invoice is closed indicator |
| Close Order | Y | Y | N | Order is closed indicator |
| Customer | Y | Y | N | Direct Customer |
| Customer ID | Y | Y | N | Direct Customer - ID |
| Difference | N | N | Y | Check Amount - Reconciled + Adjustment |
| Invoice Date | N | Y | N | The invoice date on the invoice |
| Invoice Earnings | N | N | Y | Earnings on the invoice |
| Invoice Number | Y | Y | N | Invoice number of a payment entry |
| Manufacturer | Y | Y | N | Manufacturer or brand |
| Manufacturer ID | Y | Y | N | Manufacturer or brand - ID |
| Paid Amount | N | N | Y | Amount of the overall check applied to the invoice |
| Payment ID | Y | Y | N | Behind the scenes ID for the Payment in OASIS |
| Payment Total Reconciled Amount | N | N | Y | Total reconciled amount in the payment |
| PMTLinkID | Y | Y | N | Internal unique OASIS number identifying an individual payment line |
| PO Date | N | Y | N | The order date on the order |
| PO Earnings | N | N | Y | Earnings on the order |
| PO Number | Y | Y | N | Order number of a payment entry |
| PO Receivable Earnings | N | N | Y | Earnings less any earnings received on the order |
| 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.