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 |