Skip to main content

Update Standalone Invoices - Data dictionary

Zuora

Update Standalone Invoices - Data dictionary

Describes Data Loader's functionality and benefits in Zuora Tenant.

 

This article lists all the fields associated with updating a Standalone invoice in Zuora. Read more on Standalone Invoices here.

Note: Fields with an asterisk mark indicate mandatory fields.

Name Description Value
IsNewInvoice Marker Column TRUE
Id* The ID of the invoice to be updated. string
Auto pay Whether invoices are automatically picked up for processing in the corresponding payment run.
By default, invoices are automatically picked up for processing in the corresponding payment run.
boolean
Due Date The date by which the payment for this invoice is due. string <date>
Invoice Comments Additional information related to the invoice that a Zuora user added to the invoice. string <= 255 characters
Invoice Date The new invoice date of the invoice. The new invoice date cannot fall in a closed accounting period.
You can only specify invoiceDate or dueDate in one request. Otherwise, an error occurs.
string <date>
Transferred To Accounting Whether the invoice was transferred to an external accounting system.
Enum: "Processing" "Yes" "Error" "Ignore"
string
IsNewInvoiceItem Marker Column TRUE/ FALSE
Invoice Item Id* The unique ID of the invoice item. string
Invoice Item Accounting Code The accounting code associated with the invoice item. string
Invoice Item Adjustment Liability Accounting Code The accounting code for adjustment liability.
Note: This field is only available if you have the Billing - Revenue Integration feature enabled.
string
Invoice Item Adjustment Revenue Accounting Code The accounting code for adjustment revenue.
Note: This field is only available if you have the Billing - Revenue Integration feature enabled.
string
Invoice Item Amount The amount of the invoice item.
For tax-inclusive invoice items, the amount indicates the invoice item amount including tax.
For tax-exclusive invoice items, the amount indicates the invoice item amount excluding tax.
string <number>
Invoice Item Charge Date The date when the invoice item is charged, in yyyy-mm-dd hh:mm:ss format. string <date-time>
Invoice Item Charge Name The name of the charge associated with the invoice item.
This field is required if the productRatePlanChargeId field is not specified in the request.
string
Invoice Item Contract Asset Accounting Code The accounting code for contract asset.
Note: This field is only available if you have the Billing - Revenue Integration feature enabled.
string
Invoice Item Contract Liability Accounting Code The accounting code for contract liability.
Note: This field is only available if you have the Billing - Revenue Integration feature enabled.
string
Invoice Item Contract Recognized Revenue Accounting Code The accounting code for contract recognized revenue.
Note: This field is only available if you have the Billing - Revenue Integration feature enabled.
string
Invoice Item Deferred Revenue Accounting Code The accounting code for the deferred revenue, such as Monthly Recurring Liability.
Note: This field is only available if you have Zuora Finance enabled.
string
Invoice Item Description The description of the invoice item. string
Invoice Item Item Type The type of the invoice item. string
Invoice Item Product Rate Plan Charge Id    
Invoice Item Purchase Order Number The purchase order number associated the invoice item. string
Invoice Item Quantity The number of units for the invoice item. string <number>
Invoice Item Recognized Revenue Accounting Code The accounting code for the recognized revenue, such as Monthly Recurring Charges or Overage Charges.
Note: This field is only available if you have Zuora Finance enabled.
string
Invoice Item Revenue Recognition Code The revenue recognition code. string
Invoice Item Revenue Recognition Rule Name The name of the revenue recognition rule governing the revenue schedule.
Note: This field is only available if you have Zuora Finance enabled.
string
Invoice Item Revenue Recognition Trigger Condition The date when revenue recognition is triggered.
Enum: "ContractEffectiveDate" "ServiceActivationDate" "CustomerAcceptanceDate"
string
Invoice Item SKU The SKU of the invoice item. The SKU of the invoice item must be different from the SKU of any existing product. string
Invoice Item Service End Date The service end date of the invoice item. string <date>
Invoice Item Service Start Date The service start date of the invoice item. string <date>
Invoice Item Tax Code The tax code identifies which tax rules and tax rates to apply to the invoice item.
Note:
This field is only available if you have Taxation enabled.
string
Invoice Item Tax Mode The tax mode of the invoice item, indicating whether the amount of the invoice item includes tax.
Note:
This field is only available if you have Taxation enabled.
string
Invoice Item UOM The unit of measure. string
Invoice Item Unbilled Receivables Accounting Code The accounting code for unbilled receivables.
Note: This field is only available if you have the Billing - Revenue Integration feature enabled.
string
Invoice Item Unit Price The per-unit price of the invoice item. string <number>
IsNewInvoiceItemDiscountItem Marker Column TRUE/ FALSE
Discount Item Id* The unique ID of the discount item. string
Discount Item Accounting Code The accounting code associated with the discount item. string
Discount Item Adjustment Liability Accounting Code The accounting code for adjustment liability. Note: This field is only available if you have the Billing - Revenue Integration feature enabled. string
Discount Item Adjustment Revenue Accounting Code The accounting code for adjustment revenue. Note: This field is only available if you have the Billing - Revenue Integration feature enabled. string
Discount Item Amount The amount of the discount item.
Should be a negative number. For example, -10.
Always a fixed amount no matter whether the discount charge associated with the discount item uses the fixed-amount model or percentage model.
For tax-exclusive discount items, this amount indicates the discount item amount excluding tax.
For tax-inclusive discount items, this amount indicates the discount item amount including tax.
string <number>
Discount Item Charge Date The date when the discount item is charged, in yyyy-mm-dd hh:mm:ss format. string <date-time>
Discount Item Charge Name The name of the charge associated with the discount item. This field is required if the productRatePlanChargeId field is not specified in the request. string
Discount Item Contract Asset Accounting Code The accounting code for contract asset. Note: This field is only available if you have the Billing - Revenue Integration feature enabled. string
Discount Item Contract Liability Accounting Code The accounting code for contract liability. Note: This field is only available if you have the Billing - Revenue Integration feature enabled. string
Discount Item Contract Recognition Revenue Accounting Code The accounting code for contract recognized revenue. Note: This field is only available if you have the Billing - Revenue Integration feature enabled. string
Discount Item Deferred Revenue Accounting Code The accounting code for the deferred revenue, such as Monthly Recurring Liability. Note: This field is only available if you have Zuora Finance enabled. string
Discount Item Description The description of the discount item. string
Discount Item Item Type The type of the discount item. string
Discount Item Purchase Order Number The purchase order number associated with the discount item. string
Discount Item Recognized Revenue Accounting Code

The accounting code for the recognized revenue, such as Monthly Recurring Charges or Overage Charges. Note: This field is only available if you have Zuora Finance enabled.
string
Discount Item Reference Of The Discount Item The revenue recognition code. string
Discount Item Revenue Recognition Code The revenue recognition code. string
Discount Item Revenue Recognition Rule Name The name of the revenue recognition rule governing the revenue schedule. Note: This field is only available if you have Zuora Finance enabled. string
Discount Item Revenue Recognition Trigger Condition The date when revenue recognition is triggered.
Enum: "ContractEffectiveDate" "ServiceActivationDate" "CustomerAcceptanceDate"
string
Discount Item SKU The SKU of the invoice item. The SKU of the discount item must be different from the SKU of any existing product. string
Discount Item Unbilled Receivables Accounting Code The accounting code for unbilled receivables. Note: This field is only available if you have the Billing - Revenue Integration feature enabled. string
Discount Item Unit Price The per-unit price of the discount item. If the discount charge associated with the discount item uses the percentage model, the unit price will display as a percentage amount in PDF. For example: if unit price is 5.00, it will display as 5.00% in PDF. string <number>
IntegrationId__NS ID of the corresponding object in NetSuite. Only available if you have installed the Zuora Connector for NetSuite. string <= 255 characters
IntegrationStatus__NS Status of the invoice item's synchronization with NetSuite. Only available if you have installed the Zuora Connector for NetSuite. string <= 255 characters
SyncDate__NS Date when the invoice item was synchronized with NetSuite. Only available if you have installed the Zuora Connector for NetSuite. string <= 255 characters