ODBC Driver for Zuora

Build 24.0.9062

InvoiceItem

A line item in an invoice.

Columns

Name Type Description
soldtocontactid String The 'soldtocontactid' column for the 'invoiceitem' table.
accountid String The 'accountid' column for the 'invoiceitem' table.
accountingcode String The 'accountingcode' column for the 'invoiceitem' table.
updateddate Datetime The 'updateddate' column for the 'invoiceitem' table.
productid String The 'productid' column for the 'invoiceitem' table.
invoiceid String The 'invoiceid' column for the 'invoiceitem' table.
chargeamount Decimal The 'chargeamount' column for the 'invoiceitem' table.
taxamount Decimal The 'taxamount' column for the 'invoiceitem' table.
subscriptionid String The 'subscriptionid' column for the 'invoiceitem' table.
createdbyid String The 'createdbyid' column for the 'invoiceitem' table.
taxcode String The 'taxcode' column for the 'invoiceitem' table.
revrecstartdate Date The 'revrecstartdate' column for the 'invoiceitem' table.
servicestartdate Date The 'servicestartdate' column for the 'invoiceitem' table.
taxexemptamount Decimal The 'taxexemptamount' column for the 'invoiceitem' table.
journalentryid String The 'journalentryid' column for the 'invoiceitem' table.
defaultpaymentmethodid String The 'defaultpaymentmethodid' column for the 'invoiceitem' table.
parentaccountid String The 'parentaccountid' column for the 'invoiceitem' table.
taxmode String The 'taxmode' column for the 'invoiceitem' table.
billtocontactsnapshotid String The 'billtocontactsnapshotid' column for the 'invoiceitem' table.
amendmentid String The 'amendmentid' column for the 'invoiceitem' table.
appliedtoinvoiceitemid String The 'appliedtoinvoiceitemid' column for the 'invoiceitem' table.
rateplanchargeid String The 'rateplanchargeid' column for the 'invoiceitem' table.
serviceenddate Date The 'serviceenddate' column for the 'invoiceitem' table.
updatedbyid String The 'updatedbyid' column for the 'invoiceitem' table.
deferredrevenueaccountingcodeid String The 'deferredrevenueaccountingcodeid' column for the 'invoiceitem' table.
productrateplanid String The 'productrateplanid' column for the 'invoiceitem' table.
quantity Decimal The 'quantity' column for the 'invoiceitem' table.
chargename String The 'chargename' column for the 'invoiceitem' table.
recognizedrevenueaccountingcodeid String The 'recognizedrevenueaccountingcodeid' column for the 'invoiceitem' table.
billtocontactid String The 'billtocontactid' column for the 'invoiceitem' table.
soldtocontactsnapshotid String The 'soldtocontactsnapshotid' column for the 'invoiceitem' table.
rateplanid String The 'rateplanid' column for the 'invoiceitem' table.
chargedate Datetime The 'chargedate' column for the 'invoiceitem' table.
uom String The 'uom' column for the 'invoiceitem' table.
unitprice Decimal The 'unitprice' column for the 'invoiceitem' table.
productrateplanchargeid String The 'productrateplanchargeid' column for the 'invoiceitem' table.
createddate Datetime The 'createddate' column for the 'invoiceitem' table.
processingtype String The 'processingtype' column for the 'invoiceitem' table.
id String The 'id' column for the 'invoiceitem' table.
sku String The 'sku' column for the 'invoiceitem' table.
balance Decimal The 'balance' column for the 'invoiceitem' table.
accountreceivableaccountingcodeid String The 'accountreceivableaccountingcodeid' column for the 'invoiceitem' table.

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