Payments table overview

The Payments table offers a lot of information in a condensed amount of space.  

Columns 1 -5 are imported from the marketplace.

• Paid On - The date the payment is posted
• Marketplace
• Remittance ID - Note: Not all marketplaces have remittance id's.  Ex:  Gametime
• Invoice ID 
• Payment Amt

Columns 6 -8 are imported from the POS

• POS Invoice No.
• POS Amt - This can be a different value than what's in Payment Amt, which comes from the marketplace 
• Trx Date - The date of the original invoice transaction

Columns 9 - 10 help to categorize the transactions.

• Type
  • Payment - Payments are associated directly with the sale of the tickets.
  • Credit Payment - Payments made from applying credits that your POS currently holds from the cancellations of other events.
  • Adjustment - Adjustments can be either positive or negative.
  • Fee - Fees refer to marketplace fees.
  • Rounding Adjustment - To correct for certain marketplaces that have rounding differences since they calculate beyond two decimal places.

• Status 
  • Completed - The POS invoice has been successfully updated.
  • Pending - The adjustment still requires processing.  Adjustments can be cancellations, penalties, or both.
  • Not Found - This status still requires processing.  The invoice could not be found in the POS.  The user must type in the proper POS Invoice No., and Apply Payments.  
  • Voided - This is a final status whereby TicketUtils has already voided the status in their POS.  At this point, we can not update the transaction anymore.
  • Skipped - This status means that the invoice was already marked paid when we went to pay it.  This status is considered Completed and will not show up under Needs Attention.