Get All Transactions
get
/rest/v7/commerceDocuments{ProcessVarName}{MainDocVarName}
This operation retrieves all Transactions.
Request
Path Parameters
-
MainDocVarName: string
The variable name of the main document, the first letter must be capitalized
-
ProcessVarName: string
The variable name of the Commerce process, the first letter must be capitalized
Query Parameters
-
fields: string
Restrict which fields shall be returned. The value is a comma delimited string and each token is a field name.
-
limit: integer
The requested page size, which limits the number of elements the collection should max return.
-
offset: integer
The offset of the page. By default, offset is 0, which means first page will be returned.
-
q: string
Allows to specify one or more filtering criteria. By default, no filtering is applied.
Response
Default Response
Root Schema : commerceTransaction-collection
Type:
Show Source
object
-
_state(optional):
object state
Title:
state
Captures the current state of the resource collection. Of available properties, only those that are applicable and whose values are known in the current context are included. -
items(optional):
array items
Nested Schema : state
Type:
object
Title:
state
Captures the current state of the resource collection. Of available properties, only those that are applicable and whose values are known in the current context are included.
Show Source
-
actions(optional):
object Actions
Title:
Actions
Captures the current state of each action whose state was requested. The object contains one property per action, where the property name is the variable name for the action. -
attributes(optional):
object Attributes
Title:
Attributes
Captures the composite state of each attribute whose state was requested. The object contains one property per group, where the property name is the resource field name for the attribute. -
defaultRowState(optional):
object state
Title:
state
Captures the current state of the resource row. Of available properties, only those that are applicable and whose values are known in the current context are included. -
hasError(optional):
boolean
Title:
Has Error
Boolean value that specifies whether any error that occurred has been assigned to the collection itself. -
hasWarning(optional):
boolean
Title:
Has Warning
Boolean value that specifies whether any warning that was issued has been assigned to the collection itself. -
insertable(optional):
boolean
Title:
Insertable
Boolean value that specifies whether new rows can be inserted into the collection. -
messages(optional):
array Messages
Title:
Messages
Array of messages that have been generated for a specific object. -
queryable(optional):
boolean
Title:
Queryable
Boolean value that specifies whether the rows in the collection can be queried. -
sortable(optional):
boolean
Title:
Sortable
Boolean value that specifies whether the rows in the collection can be sorted. -
statistics(optional):
array Statistics
Title:
Statistics
Contains the sum of a given attributes.
Nested Schema : Actions
Type:
object
Title:
Actions
Captures the current state of each action whose state was requested. The object contains one property per action, where the property name is the variable name for the action.
Nested Schema : Attributes
Type:
object
Title:
Attributes
Captures the composite state of each attribute whose state was requested. The object contains one property per group, where the property name is the resource field name for the attribute.
Nested Schema : state
Type:
object
Title:
state
Captures the current state of the resource row. Of available properties, only those that are applicable and whose values are known in the current context are included.
Show Source
-
actions(optional):
object Actions
Title:
Actions
Captures the current state of each action whose state was requested. The object contains one property per action, where the property name is the variable name for the action. -
attributes(optional):
object Attributes
Title:
Attributes
Captures the current state of each attribute whose state was requested. The object contains one property per group, where the property name is the resource field name for the attribute. -
deletable(optional):
boolean
Title:
Deletable
Boolean value that specifies whether the row can be deleted. -
groups(optional):
object Groups
Title:
Groups
Captures the current state of each group whose state was requested. The object contains one property per group, where the property name is the expression string that uniquely identifies the group. -
hasError(optional):
boolean
Title:
Has Error
Boolean value that specifies whether any error that occurred has been assigned to the row itself. -
hasWarning(optional):
boolean
Title:
Has Warning
Boolean value that specifies whether any warning that was issued has been assigned to the row itself. - hidden(optional): boolean
-
messages(optional):
array Messages
Title:
Messages
Array of messages that have been generated for a specific object. -
updatable(optional):
boolean
Title:
Updatable
Boolean value that specifies whether the row can be updated.
Nested Schema : Messages
Type:
array
Title:
Messages
Array of messages that have been generated for a specific object.
Show Source
-
Array of:
string
An error, warning, or informational message.
Nested Schema : Statistics
Type:
array
Title:
Statistics
Contains the sum of a given attributes.
Show Source
-
Array of:
object Statistics State
Title:
Statistics State
Contains the attribute name and sum of the attribute across the full collection.
Nested Schema : Attributes
Type:
object
Title:
Attributes
Captures the current state of each attribute whose state was requested. The object contains one property per group, where the property name is the resource field name for the attribute.
Nested Schema : Groups
Type:
object
Title:
Groups
Captures the current state of each group whose state was requested. The object contains one property per group, where the property name is the expression string that uniquely identifies the group.
Nested Schema : Statistics State
Type:
object
Title:
Statistics State
Contains the attribute name and sum of the attribute across the full collection.
Show Source
-
attributeName(optional):
string
Title:
Attribute Name
Variable name of the attribute. -
unfilteredTotal(optional):
Title:
Unfiltered Total
sum of a given attribute across the full collection.
Nested Schema : commerceTransaction
Type:
Show Source
object
-
_buyer_company_name(optional):
string
Title:
Buyer Company Name
The name of the buyer company. -
_currency_pref(optional):
object
Title:
-
_customer_id(optional):
string
Title:
Customer Id
This is the special Customer ID (with attribute type = Customer ID) used in CPQ-platform-supplied CRM integrations. This attribute is associated with the automatically-created Autofill, Browse, Select Alternate Address, and View Actions. -
_customer_t_address(optional):
string
Title:
Customer Address
Address of the customer. -
_customer_t_address_2(optional):
string
Title:
Customer Address
Address of the customer. -
_customer_t_city(optional):
string
Title:
Customer City
Name of the city associated with the customer address. -
_customer_t_company_name(optional):
string
Title:
Customer Company Name
Company name of the customer. -
_customer_t_company_name_2(optional):
string
Title:
Customer Company Name 2
Address of the customer. -
_customer_t_country(optional):
object Customer Country
Title:
Customer Country
Name of the country associated with the customer address. -
_customer_t_email(optional):
string
Title:
Customer Email
Email address of the customer. -
_customer_t_fax(optional):
string
Title:
Customer Fax
Fax number of the customer. -
_customer_t_first_name(optional):
string
Title:
Customer First Name
First name of the customer. -
_customer_t_last_name(optional):
string
Title:
Customer Last Name
Last name of the customer. -
_customer_t_phone(optional):
string
Title:
Customer Phone
Phone number of the customer. -
_customer_t_state(optional):
object Customer State
Title:
Customer State
Name of the state associated with the customer address. -
_customer_t_zip(optional):
string
Title:
Customer Zip
Zip code associated with the customer address. -
_date_added(optional):
string
Title:
Date Added
The date when the transaction record got added. -
_date_modified(optional):
string
Title:
Date Last Modified
The date when the transaction record got modified. -
_document_number(optional):
string
Title:
Document Number
Unique doc number to be used as document identifier in a process -
_document_var_name(optional):
string
Title:
Document Variable Name
This is the document variable name. A document can either be a 'Main Document' or 'SubDocument - Transaction Line'. Variable name for the main document is 'transaction' and for the sub document, it is 'transactionLine'. Main (Header Level) Commerce Document serves as Quote/Order depending on step in process flow. -
_eSignatureAttributeSet_esig_date_modified(optional):
string
Title:
eSignature Date Modified[eSignature Attribute Set]
The Date Modified field contains the date of the most recently performed action on this document -
_eSignatureAttributeSet_esig_envelope_id(optional):
string
Title:
eSignature Envelope ID[eSignature Attribute Set]
The Envelope ID is a hidden field that is sent along with the document to the eSignature Vendor -
_eSignatureAttributeSet_esig_file_attachment(optional):
object eSignature File Attachment[eSignature Attribute Set]
Title:
eSignature File Attachment[eSignature Attribute Set]
The File Attachment attribute holds the documents to be sent to the eSignature Vendor -
_eSignatureAttributeSet_esig_recipients(optional):
string
Title:
eSignature Recipients[eSignature Attribute Set]
The Recipients holds the emails and names of the intended recipients -
_eSignatureAttributeSet_esig_status(optional):
object eSignature Status (eSignature Attribute Set)
Title:
eSignature Status (eSignature Attribute Set)
The Status field contains the current status of this document -
_id(optional):
integer
Title:
Id
Current unique user-side ID. This is the internal identifier for a transaction within a CPQ site. -
_invoiceTo_t_address(optional):
string
Title:
Invoice To Address
Address on the invoice. -
_invoiceTo_t_address_2(optional):
string
Title:
Invoice To Address 2
Address on the invoice. -
_invoiceTo_t_city(optional):
string
Title:
Invoice To City
Name of the city on the invoice address. -
_invoiceTo_t_company_name(optional):
string
Title:
Invoice To Company Name
Company name on the invoice. -
_invoiceTo_t_company_name_2(optional):
string
Title:
Invoice To Company Name 2
Company name on the invoice. -
_invoiceTo_t_country(optional):
object Invoice To Country
Title:
Invoice To Country
Name of the country on the invoice address. -
_invoiceTo_t_email(optional):
string
Title:
Invoice To Email
Email address on the invoice. -
_invoiceTo_t_fax(optional):
string
Title:
Invoice To Fax
Fax number on the invoice. -
_invoiceTo_t_first_name(optional):
string
Title:
Invoice To First Name
First name on the invoice. -
_invoiceTo_t_last_name(optional):
string
Title:
Invoice To Last Name
Last name on the invoice. -
_invoiceTo_t_phone(optional):
string
Title:
Invoice To Phone
Phone number on the invoice. -
_invoiceTo_t_state(optional):
object Invoice To State
Title:
Invoice To State
Name of the state on the invoice address. -
_invoiceTo_t_zip(optional):
string
Title:
Invoice To Zip
Zip code on the invoice address. -
_last_document_number(optional):
integer
Title:
Last Document Number
Unique document identifier of the last document in the transaction. -
_price_book_var_name(optional):
string
Title:
Price Book Variable Name
Variable Name of the Price Book used to get the price for this line item -
_process_var_name(optional):
string
Title:
Commerce Process Name
The process variable name of the commerce process. For the reference commerce process, the process variable name is oraclecpqo. -
_shipTo_t_address(optional):
string
Title:
Ship To Address
Address associated with the shipping address. -
_shipTo_t_address_2(optional):
string
Title:
Ship To Address 2
Address associated with the shipping address. -
_shipTo_t_city(optional):
string
Title:
Ship To City
Name of the city associated with the shipping address. -
_shipTo_t_company_name(optional):
string
Title:
Ship To Company Name
Company name associated with the shipping address. -
_shipTo_t_company_name_2(optional):
string
Title:
Ship To Company Name 2
Company name associated with the shipping address. -
_shipTo_t_country(optional):
object Ship To Country
Title:
Ship To Country
Name of the country associated with the shipping address. -
_shipTo_t_email(optional):
string
Title:
Ship To Email
Email address associated with the shipping address. -
_shipTo_t_fax(optional):
string
Title:
Invoice To Fax
Fax number on the invoice. -
_shipTo_t_first_name(optional):
string
Title:
Ship To First Name
First name associated with the shipping address. -
_shipTo_t_last_name(optional):
string
Title:
Ship To Last Name
Last name associated with the shipping address. -
_shipTo_t_phone(optional):
string
Title:
Ship To Phone
Phone number associated with the shipping address. -
_shipTo_t_state(optional):
object Ship To State
Title:
Ship To State
Name of the state associated with the shipping address. -
_shipTo_t_zip(optional):
string
Title:
Ship To Zip
Zip code associated with the shipping address. -
_soldTo_t_address(optional):
string
Title:
Ship To Address
Address associated with the shipping address. -
_soldTo_t_address_2(optional):
string
Title:
Sold To Address 2
Address associated with the Sold To party. -
_soldTo_t_city(optional):
string
Title:
Sold To City
Name of the city associated with the Sold To party. -
_soldTo_t_company_name(optional):
string
Title:
Sold To Company Name
Company name associated with the Sold To party. -
_soldTo_t_company_name_2(optional):
string
Title:
Sold To Company Name 2
Company name associated with the Sold To party. -
_soldTo_t_country(optional):
object Sold To Country
Title:
Sold To Country
Name of the country associated with the Sold To party. -
_soldTo_t_email(optional):
string
Title:
Sold To Email
Email address associated with the Sold To party. -
_soldTo_t_fax(optional):
string
Title:
Invoice To Fax
Fax number on the invoice. -
_soldTo_t_first_name(optional):
string
Title:
Sold To First Name
First name associated with the Sold To party. -
_soldTo_t_last_name(optional):
string
Title:
Sold To Last Name
Last name associated with the Sold To party. -
_soldTo_t_phone(optional):
string
Title:
Sold To Phone
Phone number associated with the Sold To party. -
_soldTo_t_state(optional):
object Sold To State
Title:
Sold To State
Name of the state associated with the Sold To party. -
_soldTo_t_zip(optional):
string
Title:
Sold To State
Name of the state associated with the Sold To party. -
_state(optional):
object state
Title:
state
Captures the current state of the resource row. Of available properties, only those that are applicable and whose values are known in the current context are included. -
_step_var_name(optional):
string
Title:
Current Step Variable Name
This is the variable name of the transaction's current commerce process step. For example, for 'Start' step, the step variable name is 'start_step'. -
_submitted_by_submit_t(optional):
string
Title:
Submitted By[Submit]
Login of Submitter. Only populated after corresponding submit action is performed. -
_supplier_company_name(optional):
string
Title:
Supplier Company Name
The name of the supplier company. -
_transaction_total(optional):
object Transaction Total
Title:
Transaction Total
The Transaction Total. The total value of this transaction including all one-time, recurring and shipping charges over the duration of the contract. Synonymous with the Total Contract Value. -
approval_history_submit_t(optional):
string
Title:
Approval History[Submit]
This attribute records approval history of a transaction. If a reason is reset, it is erased from the approval history. -
approval_revision_submit_t(optional):
integer
Title:
Approval Revision[Submit]
This attribute tracks the number of times a quote has been revised -
approval_status_submit_t(optional):
string
Title:
Approval Status[Submit]
This attribute lists all currently pending active approvals for a transaction. -
approve_reject_icon_submit_t(optional):
object My Approval[Submit]
Title:
My Approval[Submit]
This attribute lists all approval currently pending for current logged in user. This is not available as rule input. -
bs_id(optional):
string
Title:
Transaction Internal ID
Current Unique Buy-side ID. This is the internal identifier for a transaction within a CPQ site. -
cancelReason_t(optional):
object Cancel Reason
Title:
Cancel Reason
The reason expressed by the customer for canceling this order. -
coverLetter_t(optional):
string
Title:
Cover Letter
The cover letter to be attached to the proposal document for this transaction. -
createdBy_t(optional):
string
Title:
Created By
The person that created the transaction. -
createdDate_t(optional):
string
Title:
Created Date
The date when the transaction was created. -
currency_t(optional):
object Currency
Title:
Currency
The currency used to price and invoice this transaction. -
currentStepForTesting_tempDisplay_t(optional):
string
Title:
Current Step
This attribute is exposed only to the Administrator to assist in debugging modifications to the Commerce Process Steps and Transition Rules. -
customerID_t(optional):
string
Title:
Customer ID
The Customer ID to be used in package and custom integrations other than the CPQ-platform-supplied CRM integrations. In BASE Commerce Process this attribute defaults to the value for the CPQ-platform-supplied integration attribute _customer_id. -
customerPartyID_t(optional):
string
Title:
Customer Party ID
The Party ID for the CRM Customer. This attribute is used when a generalized Party object is used to identify customer parties in addition to the Customer ID. -
customerPartySiteID_t(optional):
string
Title:
Customer Party Site ID
The ID for the Party Site or Address of the CRM Customer. -
defaultRequestDate_t(optional):
string
Title:
Default Request Date
The date on which the user requests that fulfillment occur for this transaction. -
fulfillmentStatus_t(optional):
object Fulfillment Status
Title:
Fulfillment Status
This is the most advanced fulfillment status for any line on the transaction. The value for this attribute is derived from that supplied for each line by the fulfillment system after the transaction is submitted as a sales order. -
hasRecurringPricing_t(optional):
boolean
Title:
Has Recurring Pricing
Indicates whether this transaction uses recurring pricing. This is used to hide the recurrence period column in the line item grid. -
invoiceToPartyID_t(optional):
string
Title:
Invoice To Party ID
The Party ID for the Invoice To Customer. This attribute is used when a generalized Party object is used to identify customer parties. The Invoice To Party may differ from the CRM Customer and Sold To Parties. -
invoiceToPartySiteID_t(optional):
string
Title:
Invoice To Party Site ID
The ID for the Party Site or Address of the Invoice To party. -
lastPricedDate_t(optional):
string
Title:
Last Priced
The date and time that this transaction was last re-priced. -
lastUpdatedBy_t(optional):
string
Title:
Last Updated By
The person that last updated this transaction. -
lastUpdatedDate_t(optional):
string
Title:
Last Updated
The date and time the transaction was last updated. -
opportunityID_t(optional):
string
Title:
Opportunity ID
The identifier of the parent opportunity. -
opportunityName_t(optional):
string
Title:
Opportunity
The name of the parent opportunity. -
opportunityNumber_t(optional):
string
Title:
Opportunity Number
The user or public identifier for the opportunity associated to this transaction. -
orderDate_t(optional):
string
Title:
Order Date
The date and time the order was placed for fulfillment. -
orderPlacedBy_t(optional):
string
Title:
Ordered By
Records the Current User when the Create Order Action is triggered -
owner_t(optional):
string
Title:
Owner
The person that owns this transaction. -
parent_transaction_id_versionTransaction_t(optional):
string
Title:
Parent Transaction Id[Version Transaction]
This Attribute contains the parent transaction id. -
paymentTerms_t(optional):
object Payment Terms
Title:
Payment Terms
The payment terms the customer will receive on their invoice. -
priceExpirationDate_t(optional):
string
Title:
Price Expiration Date
The date the price quote will expire. -
priceWithinPolicy_t(optional):
boolean
Title:
Price Within Policy
Indicates whether the prices in this transaction are all within their discount authority. -
proposalPreparedByCell_t(optional):
string
Title:
Proposal Prepared By Cell
The cell phone number of the person who prepared the proposal attached to this transaction. -
proposalPreparedByEmail_t(optional):
string
Title:
Proposal Prepared By Email
The email address of the person who prepared the proposal attached to this transaction. -
proposalPreparedByName_t(optional):
string
Title:
Proposal Prepared By Name
The name of the person who prepared the proposal attached to this transaction. -
proposalPreparedByPhone_t(optional):
string
Title:
Proposal Prepared By Phone
The phone number of the person who prepared the proposal attached to this transaction. -
proposalPreparedByTitle_t(optional):
string
Title:
Proposal Prepared By Title
The title of the person who prepared the proposal attached to this transaction. -
purchaseOrderNumber_t(optional):
string
Title:
PO Number
The purchase order number provided by the customer. -
refApReleaseDate(optional):
string
Title:
Reference Application Release Date
The date/time on which this version of the Base Reference Application was released. -
rejectExplanation_t(optional):
string
Title:
Reject Explanation
A detailed explanation of why the customer rejected the deal. -
rejectReason_t(optional):
object Reject Reason
Title:
Reject Reason
The reason expressed by customer for rejecting this deal. -
requireApprovalIfChecked_temporary_t(optional):
boolean
Title:
Require Approval If Checked
This attribute is exposed only to the Administrator to assist in debugging of approval flows. Checking and unchecking the attribute allows the Administrator to more easily test flows requiring or not requiring approvals. -
salesChannel_t(optional):
object Sales Channel
Title:
Sales Channel
The channel that originated the transaction. -
shipToPartyID_t(optional):
string
Title:
Ship To Party ID
The Party ID for the Ship To Customer. This attribute is used when a generalized Party object is used to identify customer parties. The Invoice To Party may differ from the CRM Customer, Sold To, and Invoice To Parties. -
shipToPartySiteID_t(optional):
string
Title:
Ship To Party Site ID
The ID for the Party Site or Address of the Ship To party. -
soldToPartyID_t(optional):
string
Title:
Sold To Party ID
The Party ID for the Sold To Party / ERP Customer. This attribute is used when a generalized Party object is used to identify customer parties. The Sold To Party / ERP Customer may differ from the CRM Customer Party. -
soldToPartySiteID_t(optional):
string
Title:
Sold To Party Site ID
The ID for the Party Site or Address of the Sold To party. -
status_t(optional):
object Status
Title:
Status
The most advanced milestone reached by lines of this transaction. -
statusDate_t(optional):
string
Title:
Status As Of
Date and time when the fulfillment status changed to its current status. -
statusPartial_t(optional):
boolean
Title:
Partial
Indicates whether all lines have reached the most advanced milestone. -
taxExempt_t(optional):
boolean
Title:
Tax Exempt
Flag indicating if the Transaction is tax-exempt -
taxExemptReason_t(optional):
object Tax Exempt Reason
Title:
Tax Exempt Reason
The reason why this transaction is exempt from sales tax. For example, in the U.S. goods purchased for re-sale are not taxed. This value defaults to the line items where it can be overridden. -
TotalAnnualDiscount_t(optional):
object Annual Contract Discount
Title:
Annual Contract Discount
The total value each year of the discounts on recurring charges for the transaction. -
totalAnnualValue_t(optional):
object Annual Contract Value
Title:
Annual Contract Value
The total value of recurring charges each year. -
totalContractDiscount_t(optional):
object Total Contract Discount
Title:
Total Contract Discount
The total discount on this transaction including discounts on all one-time, recurring and shipping charges for the duration of the contract. -
totalContractValue_t(optional):
object Total Contract Value
Title:
Total Contract Value
The total value of this transaction including all one-time, recurring and shipping charges over the duration of the contract. -
totalMonthlyDiscount_t(optional):
object Total Discount Per Month
Title:
Total Discount Per Month
The total of discounts off monthly recurring charges. -
totalMonthlyListAmount_t(optional):
object Total (List) Per Month
Title:
Total (List) Per Month
The total of all monthly list amounts on the lines. -
totalMonthlyNetAmount_t(optional):
object Total (Net) Per Month
Title:
Total (Net) Per Month
The total of all monthly net amounts on the lines. -
totalOneTimeDiscount_t(optional):
object Total Discount
Title:
Total Discount
The total of all extended discount amounts for one time pricing/charges. -
totalOneTimeListAmount_t(optional):
object Total (List)
Title:
Total (List)
The total of all one-time charges on the lines. -
totalOneTimeNetAmount_t(optional):
object Total (Net)
Title:
Total (Net)
The total one time net charge. -
transactionDescription_t(optional):
string
Title:
Transaction Description
Description of the CPQ Transaction. -
transactionID_t(optional):
string
Title:
Transaction Number
The number or public unique identifier of the transaction. -
transactionName_t(optional):
string
Title:
Transaction Name
Attribute which captures the user entered Transaction Name -
userKey_t(optional):
string
Title:
Number
The transaction ID and version number concatenated together to make a single user key value or Number that uniquely identifies this transaction version. -
version_number_versionTransaction_t(optional):
string
Title:
Version Number
This Attribute Lists the Version Number for a document. -
version_t(optional):
integer
Title:
Version
The transaction ID combined with the version number are the unique key for the document. When a transaction is versioned this number is incremented. This is the Commerce Process-defined Version that defaults to the CPQ-Platform-created Version Number (version_number_versionTransaction).
Nested Schema :
Type:
object
Title:
Show Source
-
currencyCode(optional):
string
Title:
Currency Code
Unique currency code for the currency. -
id(optional):
integer
Title:
Id
Primary Key of the currency resource.
Nested Schema : Customer Country
Type:
object
Title:
Customer Country
Name of the country associated with the customer address.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for customer country -
value(optional):
string
Title:
value
The customer country name
Nested Schema : Customer State
Type:
object
Title:
Customer State
Name of the state associated with the customer address.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for customer state -
value(optional):
string
Title:
value
The customer state value
Nested Schema : eSignature File Attachment[eSignature Attribute Set]
Type:
object
Title:
eSignature File Attachment[eSignature Attribute Set]
The File Attachment attribute holds the documents to be sent to the eSignature Vendor
Nested Schema : eSignature Status (eSignature Attribute Set)
Type:
object
Title:
eSignature Status (eSignature Attribute Set)
The Status field contains the current status of this document
Show Source
-
displayValue(optional):
string
Title:
displayValue
Display value of the eSignature status. -
value(optional):
string
Title:
value
Value of the eSignature status.
Nested Schema : Invoice To Country
Type:
object
Title:
Invoice To Country
Name of the country on the invoice address.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for invoice country -
value(optional):
string
Title:
value
The invoice country value
Nested Schema : Invoice To State
Type:
object
Title:
Invoice To State
Name of the state on the invoice address.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for invoice state -
value(optional):
string
Title:
value
The invoice state value
Nested Schema : Ship To Country
Type:
object
Title:
Ship To Country
Name of the country associated with the shipping address.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for Country -
value(optional):
string
Title:
value
The country value
Nested Schema : Ship To State
Type:
object
Title:
Ship To State
Name of the state associated with the shipping address.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for ship to state -
value(optional):
string
Title:
value
The ship to state value
Nested Schema : Sold To Country
Type:
object
Title:
Sold To Country
Name of the country associated with the Sold To party.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for the sold to sountry -
value(optional):
string
Title:
value
The sold to sountry value
Nested Schema : Sold To State
Type:
object
Title:
Sold To State
Name of the state associated with the Sold To party.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for sold to state -
value(optional):
string
Title:
value
The sold to state value
Nested Schema : Transaction Total
Type:
object
Title:
Transaction Total
The Transaction Total. The total value of this transaction including all one-time, recurring and shipping charges over the duration of the contract. Synonymous with the Total Contract Value.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for transaction total -
value(optional):
number
Title:
value
The transaction total value
Nested Schema : My Approval[Submit]
Type:
object
Title:
My Approval[Submit]
This attribute lists all approval currently pending for current logged in user. This is not available as rule input.
Nested Schema : Cancel Reason
Type:
object
Title:
Cancel Reason
The reason expressed by the customer for canceling this order.
Show Source
-
displayValue(optional):
string
Title:
displayValue
Display value of the reason for canceling this deal. -
value(optional):
string
Title:
value
Value of the reason for canceling this deal.
Nested Schema : Currency
Type:
object
Title:
Currency
The currency used to price and invoice this transaction.
Show Source
-
displayValue(optional):
string
Title:
displayValue
Display value of the currency. -
value(optional):
string
Title:
value
Value of the currency.
Nested Schema : Fulfillment Status
Type:
object
Title:
Fulfillment Status
This is the most advanced fulfillment status for any line on the transaction. The value for this attribute is derived from that supplied for each line by the fulfillment system after the transaction is submitted as a sales order.
Show Source
-
displayValue(optional):
string
Title:
displayValue
Dislay value of the fulfillment status. -
value(optional):
string
Title:
value
Value of the fulfillment status.
Nested Schema : Payment Terms
Type:
object
Title:
Payment Terms
The payment terms the customer will receive on their invoice.
Show Source
-
displayValue(optional):
string
Title:
displayValue
Display value of the payment term. -
value(optional):
string
Title:
value
Value of the payment term.
Nested Schema : Reject Reason
Type:
object
Title:
Reject Reason
The reason expressed by customer for rejecting this deal.
Show Source
-
displayValue(optional):
string
Title:
displayValue
Display value of the reason for rejecting this deal. -
value(optional):
string
Title:
value
Value of the reason for rejecting this deal.
Nested Schema : Sales Channel
Type:
object
Title:
Sales Channel
The channel that originated the transaction.
Show Source
-
displayValue(optional):
string
Title:
displayValue
Display value of the sales channel. -
value(optional):
string
Title:
value
Value of the sales channel.
Nested Schema : Status
Type:
object
Title:
Status
The most advanced milestone reached by lines of this transaction.
Show Source
-
displayValue(optional):
string
Title:
displayValue
Display value of the status. -
value(optional):
string
Title:
value
Value of the status.
Nested Schema : Tax Exempt Reason
Type:
object
Title:
Tax Exempt Reason
The reason why this transaction is exempt from sales tax. For example, in the U.S. goods purchased for re-sale are not taxed. This value defaults to the line items where it can be overridden.
Show Source
-
displayValue(optional):
string
Title:
displayValue
The display value for the tax exempt reason -
value(optional):
string
Title:
value
The tax exempt reason value
Nested Schema : Annual Contract Discount
Type:
object
Title:
Annual Contract Discount
The total value each year of the discounts on recurring charges for the transaction.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total annual discount. -
value(optional):
number
Title:
value
Amount value for the total annual discount.
Nested Schema : Annual Contract Value
Type:
object
Title:
Annual Contract Value
The total value of recurring charges each year.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total annual value. -
value(optional):
number
Title:
value
Amount value for the total annual value.
Nested Schema : Total Contract Discount
Type:
object
Title:
Total Contract Discount
The total discount on this transaction including discounts on all one-time, recurring and shipping charges for the duration of the contract.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total contract discount. -
value(optional):
number
Title:
value
Amount value for the total contract discount.
Nested Schema : Total Contract Value
Type:
object
Title:
Total Contract Value
The total value of this transaction including all one-time, recurring and shipping charges over the duration of the contract.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total contract value. -
value(optional):
number
Title:
value
Amount value for the total contract value.
Nested Schema : Total Discount Per Month
Type:
object
Title:
Total Discount Per Month
The total of discounts off monthly recurring charges.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total monthly discount. -
value(optional):
number
Title:
value
Amount value for the total monthly discount.
Nested Schema : Total (List) Per Month
Type:
object
Title:
Total (List) Per Month
The total of all monthly list amounts on the lines.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total monthly list amount. -
value(optional):
number
Title:
value
Amount value for the total monthly list amount.
Nested Schema : Total (Net) Per Month
Type:
object
Title:
Total (Net) Per Month
The total of all monthly net amounts on the lines.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total monthly net amount. -
value(optional):
number
Title:
value
Amount value for the total monthly net amount.
Nested Schema : Total Discount
Type:
object
Title:
Total Discount
The total of all extended discount amounts for one time pricing/charges.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total one time discount. -
value(optional):
number
Title:
value
Amount value for the total one time discount.
Nested Schema : Total (List)
Type:
object
Title:
Total (List)
The total of all one-time charges on the lines.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total one time list amount. -
value(optional):
number
Title:
value
Amount value for the total one time list amount.
Nested Schema : Total (Net)
Type:
object
Title:
Total (Net)
The total one time net charge.
Show Source
-
currency(optional):
string
Title:
currency
Currency code for the total one time net amount. -
value(optional):
number
Title:
value
Amount value for the total one time net amount.
Examples
The following example shows how to access all Transactions in a Commerce Process by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.
curl -X GET -i -H "Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQg" -H "Accept: application/json" https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction?limit=3&q={status_t:'CREATED'}
Response Body Sample
The following example shows the contents of the response body in JSON format, including the Transactions:
{ "hasMore" : true, "limit" : 3, "count" : 3, "items" : [ { "_last_document_number" : "1", "totalContractValue_t" : "236133.32", "_buyer_company_name" : "cpq", "totalOneTimeNetAmount_t" : "60045.28", "totalMonthlyDiscount_t" : "0", "totalOneTimeListAmount_t" : "60355.28", "_id" : "36365138", "_step_var_name" : "start_step", "transactionName_t" : "TestCo1 #1", "priceWithinPolicy_t" : "true", "_supplier_company_name" : "cpq", "status_t" : "CREATED", "owner_t" : "Anna Howell", "totalOneTimeDiscount_t" : "310", "lastUpdatedDate_t" : "2015-02-26 10:23:00", "_document_var_name" : "transaction", "transactionID_t" : "CPQ-3", "createdDate_t" : "2015-02-26 00:00:00", "_currency_pref" : "USD", "totalMonthlyNetAmount_t" : "4899.89", "lastPricedDate_t" : "2015-02-26 10:15:00", "version_number_versionTransaction_t" : "2", "_customer_t_company_name" : "TestCo1", "_date_added" : "2015-11-15 19:49:25.0", "_process_var_name" : "oraclecpqo", "_date_modified" : "2015-11-15 21:05:41.0", "totalMonthlyListAmount_t" : "4899.89", "totalAnnualValue_t" : "118843.96", "links" : [ { "rel" : "self", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36365138" }, { "name" : "transactionLine", "rel" : "child", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36365138/transactionLine", "kind" : "" } ] }, { "_last_document_number" : "52", "totalContractValue_t" : "0", "_buyer_company_name" : "cpq", "totalOneTimeNetAmount_t" : "3169.84", "totalMonthlyDiscount_t" : "0", "totalOneTimeListAmount_t" : "3169.84", "_id" : "36312277", "_step_var_name" : "pending_process", "transactionName_t" : "TestCo1 #2", "priceWithinPolicy_t" : "true", "_supplier_company_name" : "cpq", "status_t" : "CREATED", "owner_t" : "Anna Howell", "totalOneTimeDiscount_t" : "0", "lastUpdatedDate_t" : "2015-02-26 10:24:00", "_document_var_name" : "transaction", "transactionID_t" : "CPQ-4", "createdDate_t" : "2015-02-26 00:00:00", "_currency_pref" : "USD", "totalMonthlyNetAmount_t" : "485", "lastPricedDate_t" : "2015-02-26 10:23:00", "version_number_versionTransaction_t" : "1", "_customer_t_company_name" : "TestCo1", "_date_added" : "2015-02-26 10:23:59.0", "_process_var_name" : "oraclecpqo", "_date_modified" : "2015-02-26 10:27:57.0", "totalMonthlyListAmount_t" : "485", "totalAnnualValue_t" : "5820", "links" : [ { "rel" : "self", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36312277" }, { "name" : "transactionLine", "rel" : "child", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36312277/transactionLine", "kind" : "" } ] }, { "_last_document_number" : "46", "totalContractValue_t" : "126460.77", "_buyer_company_name" : "cpq", "totalOneTimeNetAmount_t" : "38006.85", "totalMonthlyDiscount_t" : "0", "totalOneTimeListAmount_t" : "38006.85", "_id" : "36312562", "_step_var_name" : "pending_process", "transactionName_t" : "TestCo2 #1", "priceWithinPolicy_t" : "true", "_supplier_company_name" : "cpq", "status_t" : "CREATED", "owner_t" : "Allen Robinson", "totalOneTimeDiscount_t" : "0", "lastUpdatedDate_t" : "2015-02-26 10:32:00", "_document_var_name" : "transaction", "transactionID_t" : "CPQ-5", "createdDate_t" : "2015-02-26 00:00:00", "_currency_pref" : "USD", "totalMonthlyNetAmount_t" : "2456.97", "lastPricedDate_t" : "2015-02-26 10:29:00", "version_number_versionTransaction_t" : "1", "_customer_t_company_name" : "TestCo2", "_date_added" : "2015-02-26 10:29:53.0", "_process_var_name" : "oraclecpqo", "_date_modified" : "2015-11-13 10:32:22.0", "totalMonthlyListAmount_t" : "2456.97", "totalAnnualValue_t" : "67490.49", "links" : [ { "rel" : "self", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36312562" }, { "name" : "transactionLine", "rel" : "child", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36312562/transactionLine", "kind" : "" } ] } ], "links" : [ { "rel" : "canonical", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction" }, { "rel" : "next", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction?limit=3&offset=3" }, { "rel" : "self", "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction?limit=3&offset=0" } ], "offset" : 0 }