Price Book Lines

The Price Book Line resource is used to view, create, update, and delete the item identifier, unique identifier, and unique identifier of the item selected in the price book. It also includes the description, price and unit of measurement of the item.

Resource Plural Label

Price Book Lines

Resource Name

PriceBookItem

Get All Price Book Items

Request: GET

URI: /crmRestApi/resources/11.13.18.05/priceBookHeaders/{priceBookId}/child/PriceBookItem

Request Path Parameters

This table summarizes the request path parameters:

Name Type Description

priceBookId

Integer

The unique identifier of the Price Book.

Request Query Parameters

Use the listed finder parameters to query the resource:

Finder Name Description

PrimaryKey

Finds a Price Book Item with the specified primary key.

Finder Variables:

  • priceBookItemId: The unique identifier of the Price Book Item.
    • Type: Integer

Request Body

There are no elements in the request body for this task.

Response Body

This table summarizes the supported response body content types:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Create a Price Book Item

Request: POST

URI: /crmRestApi/resources/11.13.18.05/priceBookHeaders/{priceBookId}/child/PriceBookItem

Request Path Parameters

This table summarizes the request path parameters:

Name Type Description

priceBookId

Integer

The unique identifier of the Price Book.

Request Body

This table summarizes the supported request body content types:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Response Body

This table summarizes the supported response body content types:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Get a Price Book Item

Request: GET

URI: /crmRestApi/resources/11.13.18.05/priceBookHeaders/{priceBookId}/child/PriceBookItem/{priceBookItemId}

Request Path Parameters

This table summarizes the request path parameters:

Name Type Description

priceBookId

Integer

The unique identifier of the Price Book.

priceBookItemId

Integer

The unique identifier of the Price Book Item.

Request Body

There are no elements in the request body for this task.

Response Body

This table summarizes the supported response body content types:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Update a Price Book Item

Request: PATCH

URI: /crmRestApi/resources/11.13.18.05/priceBookHeaders/{priceBookId}/child/PriceBookItem/{priceBookItemId}

Request Path Parameters

This table summarizes the request path parameters:

Name Type Description

priceBookId

Integer

The unique identifier of the Price Book.

priceBookItemId

Integer

The unique identifier of the Pricebook Item.

Request Body

This table summarizes the request path parameters:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Response Body

This table summarizes the supported response body content types:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Replace a Price Book Item

Request: PUT

URI: /crmRestApi/resources/11.13.18.05/priceBookHeaders/{priceBookId}/child/PriceBookItem/{priceBookItemId}

Request Path Parameters

This table summarizes the request path parameters:

Name Type Description

priceBookId

Integer

The unique identifier of the Price Book.

priceBookItemId

Integer

The unique identifier of the Price Book Item.

Request Body

This table summarizes the request path parameters:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Response Body

This table summarizes the supported response body content types:

Media Type

application/vnd.oracle.adf.resourcecollection+json

Delete a Price Book Item

Request: DELETE

URI: /crmRestApi/resources/11.13.18.05/priceBookHeaders/{priceBookId}/child/PriceBookItem/{priceBookItemId}

Request Path Parameters

This table summarizes the request path parameters:

Name Type Description

priceBookId

Integer

The unique identifier of the Price Book.

priceBookItemId

Integer

The unique identifier of the Price Book Item.

Request Body

There are no elements in the request body for this task.

Response Body

There are no elements in the response body for this task.

List of Values

This table lists all the list of values of the resource.

LOV Name Source Attribute in LOV Target Attribute in Resource

SalesCatalogProductsLovVA

Description

ItemDescription

SalesCatalogProductsLovVA

InventoryItemId

InvItemId

SalesCatalogProductsLovVA

InvOrgId

InvOrgId

SalesCatalogProductsLovVA

PrimaryUomCode

PriceUOMCode

ItemUnitOfMeasureLovVA

UOMCode

PriceUOMCode

Resource Attributes

This table lists all the attributes of the resource.

Attribute Name Attribute Type Description

PricebookItemId

integer

The unique item identifier of the price book.

PricebookId

integer

The unique identifier of the price book.

InvItemId

integer

The unique identifier of the item selected in the price book.

ItemDescription

string

The description of the item.

UI Label:

Name

InvOrgId

integer

The unique identifier of the inventory organistation.

ListPrice

integer

The price of the item.

UI Label:

List Price

CreatedBy

string

The user who created the price book item.

Properties:

The maximum length is 64.

CreationDate

datetime

The date and time when the price book item was created.

LastUpdateDate

datetime

The date and time when the price book item was last updated.

LastUpdateLogin

string

The login of the user who last updated the price book item.

Properties:

The maximum length is 32.

LastUpdatedBy

string

The user who last updated the price book item.

Properties:

The maximum length is 64.

CurrencyCode

string

The currency the price book amount is based on.

PriceUOMCode

string

The unit of measurement of the item.

Properties:

The maximum length is 30.

UI Label:

UOM

ItemExternalSource

string

The source for the external key of the price book item.

Properties:

The maximum length is 120.

UI Label:

External Source

ItemExternalKey

string

The external key value for the price book item.

Properties:

The maximum length is 120.

UI Label:

External Key

__ORACO__Tax1Amount_c

number

The actual tax amount for the first tax.

UI Label:

Tax 1 Amount

__ORACO__Tax1Percentage_c

number

The actual tax percentage for the first tax.

UI Label:

Tax 1 Percentage

__ORACO__Tax2Amount_c

number

The actual tax amount for the second tax.

UI Label:

Tax 2 Amount

__ORACO__Tax2Percentage_c

number

The actual tax percentage for the second tax.

UI Label:

Tax 2 Percentage