Skip to main content

zfinanceFD

Zuora

zfinanceFD

accountingCodeName

Name of the accounting code.

accountingCodeType

Accounting code type. The accounting code types are:

  • AccountsReceivable
  • Cash
  • OtherAssets
  • CustomerCashOnAccount 
  • DeferredRevenue
  • SalesTaxPayable
  • OtherLiabilities
  • SalesRevenue 
  • SalesDiscounts
  • OtherRevenue
  • OtherEquity
  • BadDebt  
  • OtherExpenses

accountingPeriodID

Accounting period ID.

accountID

An account ID.

accountingPeriodName

Name of the accounting period.

cf_pkn__c

One or more optional custom fields, where n is the maximum number of custom fields allowed. 

cf_txtn__c

One or more optional custom fields, where n is the maximum number of custom fields allowed.

currency

Currency used.

currencyCode

Currency used.

endDate

End date of the date range used to retrieve the list of journal entries.

executedOn

Date and time the journal run was executed.

glAccountName

The account name in the general ledger (GL) that corresponds to the accounting code.

glAccountNumber

The account number in the general ledger (GL) that corresponds to the accounting code.

homeCurrency

​Home currency used.

ID

NEED DEFINITION

jeDSfields

Represents a Zuora transaction recorded as a debit and credit. Includes the following fields:

  • Created By ID
  • Created Date
  • Currency
  • ID
  • Journal Entry Date
  • Notes
  • Number
  • [Segment Name]: One or more fields representing the name of each segment created. These fields become available for export on this data source only if they are used by the GL segmentation rule.
  • Status
  • Transaction Count
  • Transaction Type
  • Transfer Date
  • Transferred By
  • Transferred To Accounting
  • Update By ID
  • Updated Date

journalEntries

Key name that represents the list of journal entries.

journalEntryDate

Date of the journal entry.

journalEntryItems

Key name that represents the list of journal entry items.

journalEntryItems.amount

Journal entry item amount in transaction currency.

journalEntryItems.homeCurrencyAmount

Journal entry item amount in home currency.

jeID

Journal entry ID.

jeItemID

Journal entry item ID.

jeNumber

Journal entry number in the format JE-00000001.

journalRunNumber

​Journal run number.

journalRun.status

Status of the journal run. The possible values are:

  • Pending
  • Processing
  • Completed
  • Error
  • CancelInprogress
  • Cancelled
  • DeleteInprogress

jr-number

Journal run number. Must be a valid journal run number in the format JR-00000001

jrDSfields

Automated process for creating journal entries from Zuora transactions. Includes the following fields:

  • Created By ID
  • Created Date
  • ID
  • Number
  • Process End Date Time
  • Process Start Date Time
  • Status
  • Target Date Type
  • Target End Date
  • Target Start Date
  • Total Journal Entry Count
  • Updated By ID
  • Updated Date

nextPage

Provides hyperlinks to view the next pages.

notes

Additional information about this record.

pageSize

Must be an integer. Maximum page size is 100. If the value specified is > 100, it is reduced to 100. If parameter is missing or incorrect, it defaults to 50.

segments

List of segments that apply to the summary journal entry.

segmentName

​Name of segment.

segmentValue

​Value of segment in this summary journal entry.

segmentationRuleName

Name of GL segmentation rule used in the journal run.

startDate

Start date of date range to fetch list of journal entries.

status

Status of journal entry. An enum with the values Created or Cancelled.

success

Returns true if the request is successful. Otherwise, returns false.

targetEndDate

​The target end date of the journal run.

targetStartDate

​The target start date of the journal run.

timePeriodStart

​Start date of time period included in the journal entry.

timePeriodEnd

​End date of time period included in the journal entry.

totalJournalEntryCount

Total number of journal entries in the journal run.

transferDateTime

Date and time that transferredToAccounting was changed to Yes. This field is returned only when transferredToAccounting is Yes. Otherwise, this field is null.

transferredToAccounting

Status shows whether the journal entry has been transferred to an accounting system. The possible values are No, Processing, Yes, Error, Ignore.

transferredBy

User ID of the person who changed transferredToAccounting to Yes. This field is returned only when transferredToAccounting is Yes. Otherwise, this field is null.

transferToAccountingDate

​The date transferredToAccounting was set to Yes. NEED TO CONFIRM DEFINITION

transactionType

​Transaction type of the transactions included in the summary journal entry.

transactionTypes

Transaction types included in the journal run.

transactionTypes.type

Transaction type. The transaction types are:

  • Invoice Item
  • Taxation Item
  • Invoice Item Adjustment (Invoice)
  • Invoice Item Adjustment (Tax)
  • Invoice Adjustment (Invoice Adjustment is deprecated on Production. Zuora recommends that you use the Invoice Item Adjustment instead.)
  • Electronic Payment
  • External Payment
  • Electronic Refund
  • External Refund
  • Electronic Credit Balance Payment
  • External Credit Balance Payment
  • Electronic Credit Balance Refund
  • External Credit Balance Refund
  • Credit Balance Adjustment (Applied from Credit Balance)
  • Credit Balance Adjustment (Transferred to Credit Balance)
  • Revenue Event Item

type

Type of journal entry item. An enum with the value Credit or Debit.

update

Key name representing the list of journal entry items for the update operation.