SSIS Components for Zuora

Build 24.0.9060

Subscription

Each row of this table represents a subscription.

Columns

Name Type Description
currenttermperiodtype String The 'currenttermperiodtype' column for the 'subscription' table.
quotenumber_qt String The 'quotenumber__qt' column for the 'subscription' table.
subscriptionstartdate Date The 'subscriptionstartdate' column for the 'subscription' table.
accountid String The 'accountid' column for the 'subscription' table.
opportunityname_qt String The 'opportunityname__qt' column for the 'subscription' table.
updateddate Datetime The 'updateddate' column for the 'subscription' table.
partnerid_c String The 'partnerid__c' column for the 'subscription' table.
autorenew Bool The 'autorenew' column for the 'subscription' table.
creatorinvoiceownerid String The 'creatorinvoiceownerid' column for the 'subscription' table.
renewaltermperiodtype String The 'renewaltermperiodtype' column for the 'subscription' table.
serviceactivationdate Date The 'serviceactivationdate' column for the 'subscription' table.
creatoraccountid String The 'creatoraccountid' column for the 'subscription' table.
termtype String The 'termtype' column for the 'subscription' table.
name String The 'name' column for the 'subscription' table.
contracteffectivedate Date The 'contracteffectivedate' column for the 'subscription' table.
subscriptionversionamendmentid String The 'subscriptionversionamendmentid' column for the 'subscription' table.
contractacceptancedate Date The 'contractacceptancedate' column for the 'subscription' table.
createdbyid String The 'createdbyid' column for the 'subscription' table.
version String The 'version' column for the 'subscription' table.
currentterm String The 'currentterm' column for the 'subscription' table.
rampid String The 'rampid' column for the 'subscription' table.
cpqbundlejsonid_qt String The 'cpqbundlejsonid__qt' column for the 'subscription' table.
quotetype_qt String The 'quotetype__qt' column for the 'subscription' table.
initialterm String The 'initialterm' column for the 'subscription' table.
notes String The 'notes' column for the 'subscription' table.
cancelleddate Date The 'cancelleddate' column for the 'subscription' table.
status String The 'status' column for the 'subscription' table.
quotebusinesstype_qt String The 'quotebusinesstype__qt' column for the 'subscription' table.
previoussubscriptionid String The 'previoussubscriptionid' column for the 'subscription' table.
originalid String The 'originalid' column for the 'subscription' table.
updatedbyid String The 'updatedbyid' column for the 'subscription' table.
renewalsetting String The 'renewalsetting' column for the 'subscription' table.
isinvoiceseparate Bool The 'isinvoiceseparate' column for the 'subscription' table.
opportunityclosedate_qt Date The 'opportunityclosedate__qt' column for the 'subscription' table.
subscriptionenddate Date The 'subscriptionenddate' column for the 'subscription' table.
revision String The 'revision' column for the 'subscription' table.
termstartdate Date The 'termstartdate' column for the 'subscription' table.
createddate Datetime The 'createddate' column for the 'subscription' table.
renewalterm String The 'renewalterm' column for the 'subscription' table.
id String The 'id' column for the 'subscription' table.
originalcreateddate Datetime The 'originalcreateddate' column for the 'subscription' table.
initialtermperiodtype String The 'initialtermperiodtype' column for the 'subscription' table.
invoiceownerid String The 'invoiceownerid' column for the 'subscription' table.
termenddate Date The 'termenddate' column for the 'subscription' table.

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