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. |