VendorPaymentDetails

List, add, update and delete details of a Vendor Payment.

Table Specific Information

Select

The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

PaymentId supports the '=' and IN operators.

NOTE: PaymentId is required to query VendorPaymentDetails.

The rest of the filter is executed client-side in the connector.

For example:

    SELECT * FROM VendorPaymentDetails WHERE PaymentId = '1894553000000085277'
	SELECT * FROM VendorPaymentDetails WHERE PaymentId IN (SELECT PaymentId FROM VendorPayments)
	SELECT * FROM VendorPaymentDetails WHERE PaymentId IN ('1894553000000085277','1894553000000085278')

Insert

INSERT can be executed by specifying the VendorId and Amount columns. The columns that are not read-only can be inserted optionally. The following is an example of how to insert into this table.

INSERT INTO VendorPaymentDetails (VendorId, Amount) VALUES ('3285934000000104023', '500')

Update

UPDATE can be executed by specifying the PaymentId in the WHERE Clause. The columns that are not read-only can be updated. For example:

UPDATE VendorPaymentDetails SET VendorId = '3285934000000104023', Amount = '1000' WHERE PaymentId = '3350895000000089005'

Delete

DELETE can be executed by specifying the PaymentId in the WHERE Clause For example:

DELETE FROM VendorPaymentDetails WHERE PaymentId = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	SupportedOperators	Description
PaymentId [KEY]	String	True	VendorPayments.PaymentId		Id of a payment.
VendorId	String	False	VendorPayments.VendorId		Id of the vendor the vendor payment has been made.
VendorName	String	True			Name of the vendor the vendor payment has been made.
VendorpaymentRefunds	String	True			Refunds of a vendor payment.
AchPaymentStatus	String	True			Status of ACH Payment.
Amount	Decimal	False			Amount of the vendor payments.
ApproverId	String	True	Users.UserId		Id of an approver.
ApproversList	String	True			List of Id of an approver.
Balance	Decimal	True			Total amount of a vendor payment.
Bills	String	False			Individual bill payment details as array.
BillingAddress	String	True			Billing address of a vendor payment.
BillingAddressAttention	String	True			Name of a person in billing address.
BillingAddressCity	String	True			City of a billing address.
BillingAddressCountry	String	True			Country of a billing address.
BillingAddressFax	String	True			Fax of a billing address.
BillingAddressPhone	String	True			Phone number of a billing address.
BillingAddressState	String	True			State of a billing address.
BillingAddressStreet2	String	True			Street two of a billing address.
BillingAddressZip	String	True			ZIP code of a billing address.
CheckDetailsAmountInWords	String	False			Checking details with amount in words.
CheckDetailsCheckId	String	False			Id of check.
CheckDetailsCheckNumber	String	False			Number if check.
CheckDetailsCheckStatus	String	False			Status of check.
CheckDetailsMemo	String	False			Memo of check details.
CheckDetailsTemplateId	String	False			Template Id of a vendor payment in check.
Comments	String	True			Comments.
CreatedTime	Datetime	True			Time at which the vendor payment was created.
CreditAccountId	String	True			CreditAccountId.
CurrencyCode	String	True			CurrencyCode.
CurrencyId	String	True	Currencies.CurrencyId		Currency Id of the customer's currency.
CurrencySymbol	String	True			Currency symbol of the customer's currency.
CustomFields	String	False			Custom Fields.
Date	Date	False			Date of a vendor payment.
Description	String	False			Description of the vendor payment.
Documents	String	False			Documents.
ExchangeRate	Decimal	False			Exchange rate of a vendor payment.
ImportedTransactions	String	True			Imported bank transations.
IsAchPayment	Boolean	True			Check if the payment if done with ACH payment.
IsPaidViaPrintCheck	Boolean	False			Check if vendor payment paid via print check.
IsPreGst	Boolean	True			Check if vendor payment includes pre GST.
IsTdsAmountInPercent	Boolean	True			Check if the TDS amount is in percent.
IsAdvancePayment	Boolean	True			IsAdvancePayment.
IsOnlinePayment	Boolean	True			IsOnlinePayment.
LastModifiedTime	Datetime	True			The time of last modification of the vendor payment.
OffsetAccountId	String	True	BankAccounts.AccountId		Id of an offset account.
OffsetAccountName	String	True			Name of an offset account.
PaidThroughAccountId	String	False	BankAccounts.AccountId		Account Id from which vendor payment has been made.
PaidThroughAccountName	String	True			Account name from which vendor payment has been made.
PaidThroughAccountType	String	True			Account type from which vendor payment has been made.
PaymentMode	String	False			Mode through which payment is made.
PaymentNumber	String	True			Number through which payment is made.
ProductDescription	String	True			Description of the product.
PurposeCode	String	True			Purpose code of vendor payment.
ReferenceNumber	String	False			Reference number of a vendor payment.
SubmittedBy	String	True			SubmittedBy.
SubmittedByEmail	String	True			SubmittedByEmail.
SubmittedByName	String	True			SubmittedByName.
SubmittedDate	Date	True			SubmittedDate.
Status	String	True			Status.
TaxAccountId	String	True	BankAccounts.AccountId		Id of a tax account.
TaxAccountName	String	True			Name of a tax account.
TaxAmountWithheld	Decimal	True			Amount withheld for tax.
TdsTaxId	String	True			Id of a TDS tax.