Rep_PaymentsView
Reference No: 26157
(V 02.00.19-00)
Rep_PaymentsView
Details
Rep_PaymentsView displays the details of Payment Details of the Order. The details of the columns in this view are given in Table 1.0.
Table 1.0 Details of Columns in Rep_PaymentsView
Column Name | Description |
PAYMENTIID | Unique IID for the Payment |
PAYMENTAMOUNT | Payment Amount |
PAYMENTDATE | Payment Date |
MOP | Method of Payment. 0 - Cash 1 - Card |
STATUS | Status of Payment. 0 - Open 1 - Void 2 - Posted |
TYPE | Payment Type. 0 - Advance 1 - Deposit 2 - Cash |
METHODNO | Method No. of the Payments table |
PAYTYPE | Order Pay Type. 0 - Bill 1 - Cash 2 - Cash Only |
CONTACTIID | Contact IID |