Power BI Connector for Zoho Books

Build 24.0.9062

RetainerInvoiceDetails

List, add, update and delete of a retainer invoice.

Table Specific Information

Select

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

  • RetainerInvoiceId supports the '=' and IN operators.

NOTE: RetainerInvoiceId is required to query RetainerInvoiceDetails.

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

For example: 

    SELECT * FROM RetainerInvoiceDetails WHERE RetainerInvoiceId = '1894663000000085023'
	SELECT * FROM RetainerInvoiceDetails WHERE RetainerInvoiceId IN (SELECT RetainerInvoiceId FROM RetainerInvoices)
	SELECT * FROM RetainerInvoiceDetails WHERE RetainerInvoiceId IN ('1894663000000085023','1894663000000085024')

Insert

INSERT can be executed by specifying the CustomerId and LineItems 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 RetainerInvoiceLineItems#TEMP (description,rate) VALUES ('Cloth description','1700') 

INSERT INTO RetainerInvoiceDetails (CustomerId, LineItems) VALUES ('3285934000000104002',RetainerInvoiceLineItems#TEMP )

INSERT can also be executed by specifying the LineItems column as a JSON array. The following is an example of how to insert using JSON array into this table. 

INSERT INTO RetainerInvoiceDetails (CustomerId, LineItems) VALUES ('3285934000000104023', '[{"Description":"Cloth description", "Rate":"1700"}]')

Update

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

INSERT INTO RetainerInvoiceLineItems#TEMP (description,rate) VALUES ('Cloth description updated','1700') 

UPDATE RetainerInvoiceDetails SET CustomerId = '3285934000000104002', LineItems = 'RetainerInvoiceLineItems#TEMP' WHERE RetainerINVOICEID = '3285934000000268036'

UPDATE can also be executed by specifying the LineItems column as a JSON array. The following is an example of how to update using JSON array into this table. 

UPDATE RetainerInvoiceDetails SET CustomerId = '3285934000000085043', LineItems = '[{"Description":"Cloth description updated", "Rate":"1700"}]' WHERE RetainerInvoiceId = '3285934000000268036'

Delete

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

DELETE FROM RetainerInvoiceDetails WHERE RetainerINVOICEID = '3285934000000268036'

Columns

Name Type ReadOnly References SupportedOperators Description
RetainerInvoiceId [KEY] String True

RetainerInvoices.RetainerInvoiceId

Id of retainer invoice.

RetainerinvoiceNumber String True

Number of a retainer invoice.

AllowPartialPayments Boolean True

Check if the retainer invoice allows partial payments.

AttachmentName String True

Name of the attachment.

Balance Decimal True

Total amount left.

BillingAddress String True

Billing address of a retainer invoice.

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.

CanSendInMail Boolean True

Check if retainer invoice can be send in mail.

ClientViewedTime Datetime True

Last time when client viewed retainer invoice.

ColorCode String True

Color code of retainer invoice.

ContactPersons String False

Contact Persons.

CreatedById String True

Users.UserId

Id of a user who has created retainer invoice.

CreatedTime Datetime True

Time at which the retainer invoice was created.

CurrencyCode String True

Currency code of the customer's currency.

CurrencyId String False

Currencies.CurrencyId

Currency Id of the customer's currency.

CurrencySymbol String True

Symbol of currency used for retainer invoice.

CurrentSubStatus String True

Current sub status of a retainer invoice.

CurrentSubStatusId String True

Current sub status Id of a retainer invoice.

CustomerId String False

Contacts.ContactId

Id of the customer or vendor.

CustomerName String True

Name of the customer or vendor.

Date Date False

Date of a retainer invoice.

ExchangeRate Decimal False

Exchange rate of the currency.

InvoiceUrl String True

URL of invoice.

IsEmailed Boolean True

Check if the retainer invoice is emailed.

IsInclusiveTax Boolean True

Check if the retainer invoice is inclusive of tax.

IsPreGst Boolean True

Check if the retainer invoice is applied by pre GST.

IsViewedByClient Boolean True

Check if retainer invoice is viewed by client.

LastModifiedById String True

Users.UserId

Id of a user who has last modified the retainer invoice.

LastModifiedTime Datetime True

The time of last modification of the retainer invoice.

LastPaymentDate Date True

Date of payment which was last paid.

Notes String False

Notes of retainer invoice.

Orientation String True

Orientation of a page.

PageHeight String True

Height of a page.

PageWidth String True

Width of a page.

PaymentDrawn Decimal True

The payment which was drawn for retainer invoice.

PaymentOptionPaymentGateways String False

Payment options for the retainer invoice, online payment gateways and bank accounts.

PaymentMade Decimal True

Payment which was made for the invoice.

PricePrecision Integer True

The precision for the price.

ReferenceNumber String False

Reference number of a retainer invoice.

RoundoffValue Decimal True

Round Off value.

ShippingAddress String True

Shipment Address.

ShippingAddressAttention String True

Name of a person of shipping address.

ShippingAddressCity String True

City of a shipping address.

ShippingAddressCountry String True

Country of a shipping address.

ShippingAddressFax String True

Fax of a shipping address.

ShippingAddressPhone String True

Phone number of a shipping address.

ShippingAddressState String True

State of a shipping address.

ShippingAddressStreet2 String True

Street two details of a shipping address.

ShippingAddressZip String True

Zip code of a shipping address.

Status String False

Status of the retainer invoice.

SubTotal Decimal True

Sub total of retainer invoices.

SubmittedBy String True

Detail of the user who has submitted the retainer invoice.

SubmittedDate Date True

Date of submission of retainer invoice.

TemplateId String False

Id of a template.

TemplateName String True

Name of a template.

TemplateType String True

Type of a template.

Terms String False

Terms and Conditions apply of a retainer invoice.

Total Decimal True

Total of retainer invoices.

TransactionRoundingType String True

Type of round off used for transaction.

VatTreatment String True

VAT treatment for the retainer invoice.

PlaceOfSupply String False

The place of supply is where a transaction is considered to have occurred for VAT purposes.

TaxSpecification String True

Working of tax when specifying special tax options and tax methods for earnings codes.

UnusedRetainerPayments Decimal True

Payment of the retainer invoice which is unused.

LineItems String False

Line items of an estimate.

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