Get a Transaction Line

get

/rest/v7/commerceDocuments{ProcessVarName}{MainDocVarName}/{_id}/{subDocVarName}/{subDocNumber}

This operation retrieves the specified Transaction Line.

Request

Supported Media Types
Path Parameters
Back to Top

Response

Supported Media Types

Default Response

Body ()
Root Schema : commerceTransactionLine
Type: object
Show Source
Nested Schema : Model Base Price
Type: object
Title: Model Base Price
Base price of the model
Show Source
Nested Schema : Part Base Price
Type: object
Title: Part Base Price
Price of the part
Show Source
Nested Schema : Configurable Price
Type: object
Title: Configurable Price
Original price as per catalog (inclusive of discount and premium)
Show Source
Nested Schema : Item Price
Type: object
Title: Item Price
The starting price. For Parts it will be the base price or price book price. For models it may be the base model price or the pricing rule or attribute value prices.
Show Source
Nested Schema : List Price
Type: object
Title: List Price
Will usually be the same value as the Item Price, unless a recommended item price applies.
Show Source
Nested Schema : Net Price
Type: object
Title: Net Price
Net price is subtotal minus the total discount
Show Source
Nested Schema : Override Discount
Type: object
Title: Override Discount
Override original discount
Show Source
Nested Schema : Override Price
Type: object
Title: Override Price
Override original list price
Show Source
Nested Schema : Total Discount
Type: object
Title: Total Discount
Total discount amount
Show Source
Nested Schema : Unit Price
Type: object
Title: Unit Price
Will usually be the same value as the List Price, unless a contract price applies.
Show Source
Nested Schema : Pricing Rule Price
Type: object
Title: Pricing Rule Price
Currently the customer level pricing. (Not applicable for Models)
Show Source
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
    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
    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.
  • Title: Deletable
    Boolean value that specifies whether the row can be deleted.
  • 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.
  • Title: Has Error
    Boolean value that specifies whether any error that occurred has been assigned to the row itself.
  • Title: Has Warning
    Boolean value that specifies whether any warning that was issued has been assigned to the row itself.
  • Title: Hidden
    Boolean value that specifies whether the row can be hidden.
  • Messages
    Title: Messages
    Array of messages that have been generated for a specific object.
  • Title: Updatable
    Boolean value that specifies whether the row can be updated.
Nested Schema : Actual Amount
Type: object
Title: Actual Amount
The actual amount billed to the customer.
Show Source
Nested Schema : Annual Discount
Type: object
Title: Annual Discount
The annual discount on the recurring charges on this line.
Show Source
Nested Schema : Annual Value
Type: object
Title: Annual Value
The annual contract value of the recurring charges on this line.
Show Source
Nested Schema : Cancel Reason
Type: object
Title: Cancel Reason
The reason why the customer cancelled this line.
Show Source
Nested Schema : Contract Discount
Type: object
Title: Contract Discount
The total discount of this line including all one - time and recurring charges.
Show Source
Nested Schema : Contract Value
Type: object
Title: Contract Value
The total contract value of this line including all one - time and recurring charges.
Show Source
Nested Schema : Cost Amount
Type: object
Title: Cost Amount
The total cost of this line.
Show Source
Nested Schema : Custom Discount Amount
Type: object
Title: Custom Discount Amount
The amount by which to adjust the list price because of a custom discount.
Show Source
Nested Schema : Discount Type
Type: object
Title: Discount Type
The type of custom discount to apply to this line.
Show Source
Nested Schema : Amount(Discount)
Type: object
Title: Amount(Discount)
The discount amount for this line.
Show Source
Nested Schema : Fulfillment Status
Type: object
Title: Fulfillment Status
The status for this line supplied by the fulfillment system after the transaction is submitted as a sales order.
Show Source
Nested Schema : Amount (List)
Type: object
Title: Amount (List)
The extended list amount for this line.
Show Source
Nested Schema : Price (List)
Type: object
Title: Price (List)
The list price of the item.
Show Source
Nested Schema : Amount (Net)
Type: object
Title: Amount (Net)
The extended list amount minus any discounts for this line.
Show Source
Nested Schema : Price (Net)
Type: object
Title: Price (Net)
The price paid by the customer for the item.
Show Source
Nested Schema : Period
Type: object
Title: Period
The period of service purchased at this price.
Show Source
Nested Schema : Price Type
Type: object
Title: Price Type
Indicates whether the amount on this line is charged once or periodically.
Show Source
Nested Schema : Unit of Measure
Type: object
Title: Unit of Measure
The unit of measure of the item requested by the customer (e.g. "Cases").
Show Source
Nested Schema : Status
Type: object
Title: Status
The status of this line.
Show Source
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 from the value on the transaction.
Show Source
Nested Schema : Unit Cost
Type: object
Title: Unit Cost
The unit cost of the item.
Show Source
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 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 : Messages
Type: array
Title: Messages
Array of messages that have been generated for a specific object.
Show Source
Back to Top

Examples

The following example shows how to access a particular line item on a Transaction 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/36365444/transactionLine/2

Response Body Sample

The following example shows the contents of the response body in JSON format, including the line item:

{
  "_part_custom_field29" : "",
  "_price_book_var_name" : "_default_price_book",
  "_model_attributes" : "",
  "_model_bom" : "",
  "_part_supplier_company_id" : "4118171",
  "_price_item_price_each" : "199.99",
  "annualValue_l" : "0",
  "_price_total_discount" : "0",
  "_config_attributes" : "",
  "_price_list_price_each" : "199.99",
  "statusQuantity_l" : null,
  "_part_custom_field30" : "",
  "requestedUnitOfMeasure_l" : "",
  "_original_document_number" : "-1",
  "status_l" : null,
  "requestedQuantity_l" : "1",
  "costAmount_l" : "100",
  "createdDate_l" : "2016-02-25 12:19:00",
  "pricePeriod_l" : "",
  "_part_id" : "36285771",
  "customDiscountAmount_l" : "0",
  "priceType_l" : "One Time",
  "_price_component_prices" : "",
  "_part_supplier_company_name" : "pm",
  "_document_number" : "2",
  "_is_line_item_mandatory" : "false",
  "_reconfiguration_date" : "1970-01-01 00:00:00",
  "_price_unit_price_each" : "199.99",
  "_config_attr_info" : "",
  "_price_configurable_price" : "199.99",
  "taxExempt_l" : "false",
  "_date_added" : "2016-02-25 12:19:07.0",
  "displayedItemName_l" : "Alliance Business Software",
  "_document_number9" : "",
  "_date_modified" : "2016-02-25 13:00:22.0",
  "_parent_line_item" : "",
  "_model_segment_name" : "",
  "canChangeQuantity_l" : "false",
  "_price_subtotal" : "199.99",
  "_part_desc" : "Alliance Business Software",
  "_is_part_pricing_rule_price" : "false",
  "_model_id" : "",
  "_partner_entity_id" : "",
  "_config_attr_text" : "",
  "_id" : "36365446",
  "_part_units" : "",
  "_model_product_line_id" : "",
  "statusDate_l" : null,
  "statusPartial_l" : "false",
  "createdBy_l" : "Super User",
  "customDiscountValue_l" : null,
  "_last_modified_date" : "2016-02-25 13:00:22",
  "_price_discount_comment" : "",
  "_model_product_line_name" : "",
  "_price_override_discount" : "None",
  "_part_drawing_position" : "",
  "itemInstanceId_l" : "",
  "netPrice_l" : "199.99",
  "_model_segment_id" : "",
  "_model_product_line_var_name" : "",
  "firstRecurringInvoiceDate_l" : "",
  "_model_supplier_company_id" : "",
  "_price_discount_percent" : "0.00",
  "_model_segment_var_name" : "",
  "contractStartDate_l" : "2016-02-25 00:00:00",
  "unitCost_l" : "100",
  "_part_direct_buy" : "1",
  "_pricing_rule_price_each" : "0",
  "_model_variable_name" : "",
  "_part_number" : "AS00100",
  "_document_var_name" : "transactionLine",
  "_model_supplier_company_name" : "",
  "_bs_id" : "36365444",
  "_price_override_quantity" : "false",
  "_price_net_price" : "199.99",
  "netAmount_l" : "199.99",
  "_line_item_spare_rule_var_name" : "",
  "listPrice_l" : "199.99",
  "customDiscountType_l" : "%",
  "_part_custom_field12" : "",
  "_part_custom_field13" : "No",
  "taxExemptReason_l" : "",
  "_part_custom_field10" : "",
  "lastUpdatedBy_l" : "Super User",
  "lineNumber_l" : "",
  "_part_custom_field11" : "",
  "_part_custom_field16" : "",
  "_part_custom_field17" : "",
  "_part_custom_field14" : "LAP",
  "_part_custom_field15" : "",
  "_model_base_price" : "",
  "_line_item_comment" : "",
  "_parent_doc_number" : "",
  "parentLineNumber_l" : "",
  "_part_custom_field2" : "",
  "listAmount_l" : "199.99",
  "_model_product_line_attributes" : "",
  "canChangeConfiguration_l" : "false",
  "_part_custom_field1" : "Software",
  "_part_custom_field4" : "",
  "_part_custom_field3" : "19",
  "priceWithinPolicy_l" : "true",
  "customerItemName_l" : "",
  "_part_custom_field6" : "253209",
  "_model_name" : "",
  "_part_custom_field5" : "100.0",
  "_part_custom_field8" : "One Time",
  "_part_custom_field7" : "",
  "_price_quantity" : "1",
  "contractedPeriods_l" : "1",
  "_part_custom_field21" : "",
  "_part_custom_field22" : "",
  "transactionID_l" : "CPQ-63",
  "_part_custom_field23" : "",
  "_part_custom_field24" : "",
  "_part_custom_field25" : "",
  "_part_custom_field26" : "",
  "_part_custom_field27" : "",
  "_part_custom_field28" : "",
  "_part_custom_field9" : "38",
  "lastUpdatedDate_l" : "",
  "contractValue_l" : "199.99",
  "_part_custom_field20" : "",
  "_part_base_price" : "199.99",
  "_is_recommended_price" : "false",
  "_part_custom_field19" : "",
  "_part_custom_field18" : "",
  "_part_extended_desc_1" : "",
  "_part_lead_time" : "N/A",
  "_price_override_price" : "No",
  "_part_extended_desc_2" : "",
  "links" : [ {
    "rel" : "self",
    "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36365444/transactionLine/2"
  }, {
    "rel" : "parent",
    "href" : "https://sitename.oracle.com/rest/v7/commerceDocumentsOraclecpqoTransaction/36365444"
  } ]
}
Back to Top