Skip to main content

Mandatory fields of transactions

Zuora

Mandatory fields of transactions

You can upload the following types of transaction lines to RevPro for processing. In the uploaded file, different fields are required by different types of transactions. If the mandatory fields are missing in the uploaded file, the transaction data cannot be correctly processed by RevPro. Click the following transaction type name below to find the mandatory fields for it.

SO (sales order)

Field name Description
EXT_LST_PRC Extended list price
EXT_SLL_PRC Extended selling price
ORD_QTY The quantity of the order
CURR The currency of the order
F_CUR The functional currency of the order
SO_LINE_ID The ID of the sales order line
SO_DATE The creation date of the sales order

INV (invoice)

Field name Description
EXT_LST_PRC Extended list price
EXT_SLL_PRC Extended selling price
INV_QTY The quantity of the invoice
ORD_QTY The quantity of the order
CURR The currency of the invoice
F_CUR The functional currency of the invoice
INV_LINE_ID The ID of the invoice
INV_DATE The creation date of the invoice

CM (credit memo created)

Field name Description
EXT_SLL_PRC Extended selling price
INV_QTY The quantity of the invoice
CURR The currency of the credit memo
F_CUR The functional currency of the credit memo
INV_LINE_ID The ID of the credit memo
INV_DATE The creation date of the credit memo

CM-C (credit memo cancelation)

Field name Description
EXT_SLL_PRC Extended selling price
INV_QTY The quantity of the invoice
CURR The currency of the credit memo
F_CUR The functional currency of the credit memo
INV_LINE_ID The ID of the credit memo
INV_DATE The creation date of the credit memo

CM-R (credit memo for return)

Field name Description
EXT_LST_PRC Extended list price
EXT_SLL_PRC Extended selling price
INV_QTY The quantity of the invoice
CURR The currency of the credit memo
F_CUR The functional currency of the credit memo
INV_LINE_ID

The ID of the credit memo

INV_DATE The creation date of the credit memo

CM-RO (credit memo for reduction order)

Field name Description
EXT_SLL_PRC Extended selling price
CURR The currency of the credit memo
F_CUR The functional currency of the credit memo
SO_LINE_ID The ID of the sales order line
INV_LINE_ID The ID of the credit memo
INV_DATE The creation date of the credit memo

PORD (price change order)

Field name Description
EXT_SLL_PRC Extended selling price
ORD_QTY The quantity of the order
CURR The currency of the order
F_CUR The functional currency of the order
SO_LINE_ID The ID of the sales order line
SO_DATE The creation date of the sales order line

RORD (reduction order)

Field name Description
EXT_LST_PRC Extended list price (a negative value)
EXT_SLL_PRC Extended selling price (a negative value)
ORD_QTY The quantity of the reduction order (a positive value)
CURR The currency of the reduction order
F_CUR The functional currency of the reduction order
SO_LINE_ID The ID of the sales order line
SO_DATE The creation date of the sales order line
ORIG_SO_LINE_ID The ID of the original sales order line