ODBC Driver for Zuora

Build 24.0.9062

Invoice

An invoice represents a bill to a customer.

Columns

Name Type Description
accountid String The 'accountid' column for the 'invoice' table.
updateddate Datetime The 'updateddate' column for the 'invoice' table.
includesrecurring Bool The 'includesrecurring' column for the 'invoice' table.
sourceid String The 'sourceid' column for the 'invoice' table.
transferredtoaccounting String The 'transferredtoaccounting' column for the 'invoice' table.
taxmessage String The 'taxmessage' column for the 'invoice' table.
paymentamount Decimal The 'paymentamount' column for the 'invoice' table.
source String The 'source' column for the 'invoice' table.
taxamount Decimal The 'taxamount' column for the 'invoice' table.
createdbyid String The 'createdbyid' column for the 'invoice' table.
postedby String The 'postedby' column for the 'invoice' table.
adjustmentamount Decimal The 'adjustmentamount' column for the 'invoice' table.
taxexemptamount Decimal The 'taxexemptamount' column for the 'invoice' table.
invoicedate Date The 'invoicedate' column for the 'invoice' table.
invoicenumber String The 'invoicenumber' column for the 'invoice' table.
duedate Date The 'duedate' column for the 'invoice' table.
billtocontactsnapshotid String The 'billtocontactsnapshotid' column for the 'invoice' table.
lastemailsentdate Datetime The 'lastemailsentdate' column for the 'invoice' table.
status String The 'status' column for the 'invoice' table.
comments String The 'comments' column for the 'invoice' table.
updatedbyid String The 'updatedbyid' column for the 'invoice' table.
amount Decimal The 'amount' column for the 'invoice' table.
includesusage Bool The 'includesusage' column for the 'invoice' table.
refundamount Decimal The 'refundamount' column for the 'invoice' table.
autopay Bool The 'autopay' column for the 'invoice' table.
soldtocontactsnapshotid String The 'soldtocontactsnapshotid' column for the 'invoice' table.
reversed Bool The 'reversed' column for the 'invoice' table.
targetdate Date The 'targetdate' column for the 'invoice' table.
createddate Datetime The 'createddate' column for the 'invoice' table.
includesonetime Bool The 'includesonetime' column for the 'invoice' table.
posteddate Datetime The 'posteddate' column for the 'invoice' table.
taxstatus String The 'taxstatus' column for the 'invoice' table.
amountwithouttax Decimal The 'amountwithouttax' column for the 'invoice' table.
creditbalanceadjustmentamount Decimal The 'creditbalanceadjustmentamount' column for the 'invoice' table.
id String The 'id' column for the 'invoice' table.
balance Decimal The 'balance' column for the 'invoice' table.
retrystatus_c String The 'retrystatus__c' column for the 'invoice' table.

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