VendorPayments

Retrieves list of all the payments made to your vendor.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

VendorId supports the '=' comparison.
VendorName supports the '=' comparison.
Amount supports the '=,<,<=,>,>=' comparisons.
Date supports the '=,<,>' comparisons.
Description supports the '=' comparison.
LastModifiedTime supports the '=' comparison.
PaymentMode supports the '=' comparison.
PaymentNumber supports the '=' comparison.
ReferenceNumber supports the '=' comparison.
VendorPaymentFilter supports the '=' comparison.
Notes supports the '=' comparison.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM VendorPayments WHERE Amount >= 98 AND Date < '2019-07-07'

    SELECT * FROM VendorPayments WHERE PaymentNumber = 1;

    SELECT * FROM VendorPayments WHERE CONTAINS (PaymentMode, 'sh')

Columns


Name	Type	References	SupportedOperators	Description
PaymentId [KEY]	String			Id of a payment.
VendorId	String			Id of the vendor the vendor payment has been made. Search payments by vendor id.
VendorName	String			Name of the vendor the vendor payment has been made. Search payments by vendor name.
AchGwTransactionId	String			Id of a ACH GW Transaction.
Amount	Decimal		=,<,<=,>,>=	Payment amount made to the vendor. Search payments by payment amount.
Balance	Decimal			Balance of vendor payment.
BcyAmount	Decimal			Amount of Base Currency.
BcyBalance	Decimal			Balance of Base Currency.
CheckDetailsCheckId	String			Id of a check.
CheckDetailsCheckNumber	String			Number of a check.
Date	Date		=,<,>	Date the payment is made. Search payments by payment made date.
Description	String			Description of a vendor payment.
HasAttachment	Boolean			Check if a vendor payment has attachment.
LastModifiedTime	Datetime			Last Modified Time of the Vendor Payment.
PaymentMode	String			Mode through which payment is made. Search payments by payment mode.
PaymentNumber	String			Number through which payment is made. Search with Payment Number.
ReferenceNumber	String			Reference number of a a bill.
AchPaymentStatus	String			Status of ACH Payment.
CheckDetailsCheckStatus	String			Status of check.
CheckDetailsMemo	String			Memo of check details.
CreatedTime	Datetime			Time at which the vendor payment was created.
CurrencyCode	String			Currency code of the vendor payment.
CurrencyId	String	Currencies.CurrencyId		Currency Id of the vendor payment currency.
ExchangeRate	Decimal			Exchange rate of a vendor payment.
IsAchPayment	Boolean			Check if the payment is done with ACH payment.
IsAdvancePayment	Boolean			Check if the payment is an advance payment.
IsPaidViaPrintCheck	Boolean			Check if vendor payment paid via print check.
PaidThroughAccountId	String	BankAccounts.AccountId		Account Id from which vendor payment has been made.
PaidThroughAccountName	String			Account name from which vendor payment has been made.
ProductDescription	String			Description of the product.
Status	String			Status of the vendor payment.
BillNumbers	String			Bill numbers associated with the vendor payment.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
VendorPaymentFilter	String		Filter payments by mode. 使用できる値は次のとおりです。PaymentMode.All, PaymentMode.Check, PaymentMode.Cash, PaymentMode.BankTransfer, PaymentMode.Paypal, PaymentMode.CreditCard, PaymentMode.GoogleCheckout, PaymentMode.Credit, PaymentMode.Authorizenet, PaymentMode.BankRemittance, PaymentMode.Payflowpro, PaymentMode.Others.
Notes	String		Notes of vendor payments..

SSIS Components for Zoho Books

VendorPayments

Table Specific Information

Select

Columns

Pseudo-Columns