Mandatory Fields of Transactions

Knowledge Center > Zuora RevPro > File Upload > Mandatory Fields of Transactions

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)

Table 1: Mandatory Fields for SO
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)

Table 2: Mandatory Fields for INV
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)

Table 3: Mandatory Fields for CM
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)

Table 4: Mandatory Fields for CM-C
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)

Table 5: Mandatory Fields for CM-R
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)

Table 6: Mandatory Fields for CM-RO
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)

Table 7: Mandatory Fields for PORD
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)

Table 8: Mandatory Fields for RORD
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
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
Last modified

Tags

This page has no custom tags.

Classifications

(not set)