Skip to main content

Debit Memo from Invoice - Data dictionary

Zuora

Debit Memo from Invoice - Data dictionary

This article details the various fields associated with Debit Memos from the Invoice data dictionary. Read more on Debit Memos here

Note: Fields with an asterisk mark indicate mandatory fields. 

Name Description Values
IsNewDebitMemo Marker Column TRUE
Invoice Id* The ID of the invoice that the debit memo is created from. String
Auto Pay Whether debit memos are automatically picked up for processing in the corresponding payment run. By default, debit memos are automatically picked up for processing in the corresponding payment run Boolean
Auto Post Default: false,Whether to automatically post the debit memo after it is created. Setting this field to true, you do not need to separately call the Post debit memo operation to post the debit memo. Boolean
Comment Comments about the debit memo String (0 to 255 characters)
Effective Date The date when the debit memo takes effect String -date
Integration Id NS ID of the corresponding object in NetSuite. Only available if you have installed the Zuora Connector for NetSuite String <=255 characters
Integration Status NS Status of the debit memo's synchronization with NetSuite. Only available if you have installed the Zuora Connector for NetSuite String <=255 characters
Reason Code It is captured from the Tenant Level Configurations in Settings>Payments>Reason Codes String
Sync Date NS Date when the debit memo was synchronized with NetSuite. Only available if you have installed the Zuora Connector for NetSuite String <=255 characters
Tax Auto Calculation Default: true ,Whether to automatically calculate taxes in the debit memo Boolean
IsNewInvoiceItem Marker Column TRUE/ FALSE
Invoice Item Amount* The amount of the debit memo item Number- Double
Invoice Item SKU Name* The name of the charge associated with the invoice. String
Invoice Item Description The description of the debit memo item. String
Invoice Item Id The ID of the invoice item String
Invoice Item Quantity The number of units for the debit memo item Number- Double
Invoice Item Service End Date The service end date of the debit memo item. String-date
Invoice Item Service Start Date The service start date of the debit memo item String-date
Invoice Item Tax Mode Default: "TaxExclusive",The tax mode of the debit memo item, indicating whether the amount of the debit memo item includes tax String
Invoice Item Unit Of Measure The definable unit that you measure when determining charges String
Invoice Item Finance Deferred Revenue Accounting Code The accounting code for the deferred revenue, such as Monthly Recurring Liability. It is captured from the Tenant level Configurations in Settings> Payments> Accounting Codes String (0 to 100 characters)
Invoice Item Finance Recognized Revenue Accounting Code The accounting code for the recognized revenue, such as Monthly Recurring Charges or Overage Charges. It is captured from the Tenant level Configurations in Settings> Payments> Accounting Codes String (0 to 100 characters)
Invoice Item Finance Revenue Recognition Rule Name The name of the revenue recognition rule governing the revenue schedule. It is captured from the Tenant level Configurations in Settings> Payments> Accounting Codes String (0 to 100 characters)
IsNewInvoiceItemTaxItem Marker Column TRUE/ FALSE
Invoice Item Finance Amount* The amount of the debit memo taxation item Number- Double
Invoice Item Finance Tax Exempt Amount* The calculated tax amount excluded due to the exemption Number- Double
Invoice Item Finance Tax Rate* The tax rate applied to the debit memo Number- Double
Invoice Item Finance Jurisdiction The jurisdiction that applies the tax or VAT. This value is typically a state, province, county, or city String
Invoice Item Finance Location Code The identifier for the location based on the value of the taxCode field String
Invoice Item Finance Source Tax Item Id The ID of the source taxation item String
Invoice Item Finance Tax Code The tax code identifies which tax rules and tax rates to apply to a specific debit memo String
Invoice Item Finance Tax Code Description The description of the tax code String
Invoice Item Finance Tax Date The date that the tax is applied to the debit memo, in yyyy-mm-dd format String-date
Invoice Item Finance Tax Name The name of taxation String
Invoice Item Finance Tax Rate Description The description of the tax rate String
Invoice Item Finance Tax Rate Type The type of the tax rate applied to the debit memo.Enum: "Percentage" "FlatFee" String
Invoice Item Finance Finance Sales Tax Payable Accounting Code The accounting code for the sales taxes payable String (0 to 100 characters)
IsNewCustomRate Marker Column TRUE/ FALSE
Custom Rate Currency Code* The currency code for either Reporting or Home currency String
Custom Rate FX Rate* The Custom FX conversion rate between home currency and transactional currency items Number-decimal
Custom Rate Date The date on which a particular currency rate is fixed or obtained on String-date