SSIS Components for Zuora

Build 24.0.9062

BillingRun

Each row of this table represents a billing run.

Columns

Name Type Description
executeddate Datetime The 'executeddate' column for the 'billingrun' table.
numberofaccounts String The 'numberofaccounts' column for the 'billingrun' table.
accountid String The 'accountid' column for the 'billingrun' table.
runtime String The 'runtime' column for the 'billingrun' table.
updateddate Datetime The 'updateddate' column for the 'billingrun' table.
repeatto String The 'repeatto' column for the 'billingrun' table.
autoemail Bool The 'autoemail' column for the 'billingrun' table.
targetdateoffset String The 'targetdateoffset' column for the 'billingrun' table.
startdate Datetime The 'startdate' column for the 'billingrun' table.
invoicedateoffset String The 'invoicedateoffset' column for the 'billingrun' table.
chargetypetoexclude String The 'chargetypetoexclude' column for the 'billingrun' table.
createdbyid String The 'createdbyid' column for the 'billingrun' table.
autopost Bool The 'autopost' column for the 'billingrun' table.
billcycleday String The 'billcycleday' column for the 'billingrun' table.
lastemailsenttime Datetime The 'lastemailsenttime' column for the 'billingrun' table.
targettype String The 'targettype' column for the 'billingrun' table.
totaltime String The 'totaltime' column for the 'billingrun' table.
noemailforzeroamountinvoice Bool The 'noemailforzeroamountinvoice' column for the 'billingrun' table.
invoicedate Date The 'invoicedate' column for the 'billingrun' table.
monthlyonday String The 'monthlyonday' column for the 'billingrun' table.
numberofcreditmemos String The 'numberofcreditmemos' column for the 'billingrun' table.
billingruntype String The 'billingruntype' column for the 'billingrun' table.
numberofinvoices String The 'numberofinvoices' column for the 'billingrun' table.
status String The 'status' column for the 'billingrun' table.
updatedbyid String The 'updatedbyid' column for the 'billingrun' table.
weeklyonday String The 'weeklyonday' column for the 'billingrun' table.
repeatfrom String The 'repeatfrom' column for the 'billingrun' table.
enddate Datetime The 'enddate' column for the 'billingrun' table.
invoicesemailed Bool The 'invoicesemailed' column for the 'billingrun' table.
timezone String The 'timezone' column for the 'billingrun' table.
autorenewal Bool The 'autorenewal' column for the 'billingrun' table.
targetdate Date The 'targetdate' column for the 'billingrun' table.
createddate Datetime The 'createddate' column for the 'billingrun' table.
billingrunnumber String The 'billingrunnumber' column for the 'billingrun' table.
posteddate Datetime The 'posteddate' column for the 'billingrun' table.
batches String The 'batches' column for the 'billingrun' table.
repeattype String The 'repeattype' column for the 'billingrun' table.
id String The 'id' column for the 'billingrun' table.
errormessage String The 'errormessage' column for the 'billingrun' table.

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