Cmdlets for Zoho Books

Build 24.0.8963

VendorPaymentDetails

To list, add, update and delete details of a Vendor Payment.

Table Specific Information

Select

The 本製品 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 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963