ODBC Driver for Oracle Sales

Build 21.0.7930


The following table describes the default response for this task.


Name Type ReadOnly References Description
ProductNum [KEY] String False

The number of the product.

RevnId String False

OptyNumber String False

ActiveFlag Boolean False

Indicates if the product is Active.

Description String False

The description of the product associated with the opportunity.

EndDate Datetime False

The effective end date of the product.

InventoryItemId Long False

The unique identifier of the product inventory item associated with the opportunity.

InvOrgId Long False

The unique identifier of the inventory organization.

LastUpdateDate Datetime False

The date the product was last updated.

LongDescription String False

Text to describe the product.

ProdGroupId Long False

The unique identifier of the Product Group.

ProductType String False

The type of the product.

StartDate Datetime False

The effective start date of the product.

Text String False

The text or keywords associated with the product.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
RecordSet String

Input specifying the resource type.

Finder String

Input specifying the Finder type.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930