SalesLeadsSalesLeadProducts
The sales lead products resource is used to view the products associated with a sales lead.
Columns
| Name | Type | References | Description |
| LeadProductId [KEY] | Long | Primary Key that represents the ID of the current Lead Product | |
| LeadId [KEY] | Long |
SalesLeads.LeadId | The unique identifier of the sales lead for this sales lead product. |
| Amount | Decimal | Amount associated with the sales lead product. | |
| AverageTimeToClose | Double | Indicates average time to close for this sales lead product. | |
| ConflictId | Long | The conflict identifier for row uniqueness across databases. | |
| CreatedBy | String | Indicates the user who created this record. | |
| CreationDate | Datetime | Indicates the date and time when this record is created. | |
| CurrencyCode | String | Currency code associated with the lead product line amount. | |
| Description | String | Product Description where the product is associated with the lead. | |
| EstimatedUnitPrice | Decimal | Estimated unit price for this lead product. | |
| InventoryItemId | Long | Inventory item identifier associated with the lead product. | |
| ItemNumber | String | The alternate key for the referenced inventory item. | |
| LastUpdateDate | Datetime | System field that indicates the date and time of the last update of the row. | |
| LastUpdateLogin | String | The login of the user who last updated the record. | |
| LastUpdatedBy | String | System field that indicates the user who last updated the row. | |
| LeadNumber | String | The alternate unique identifier of the lead. | |
| LeadProductNumber | String | This is a public surrogate key for the table and is defaulted with a unique number. It cannot be null. | |
| LongDescription | String | Long description of the sales lead product. | |
| OrganizationId | Long | Inventory organization identifier associated with this lead product. | |
| PrimaryFlag | Bool | Indicates whether this product is a primary product for this lead. | |
| ProductGroupDescription | String | Description of the product group. | |
| ProductGroupId | Long | The unique identifier of the product group. | |
| ProductGroupName | String | Name of the product group if this record represents a product group. | |
| ProductGroupReferenceNumber | String | The alternate key for the referenced product group. | |
| ProductType | String | Indicates if this record represents a product or a product group. | |
| Quantity | Double | The product quantity identified for this product on the lead. | |
| UOMCode | String | Unit of measure associated with this sales lead product line. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| Finder | String | Input specifying the Finder type. | |
| ContactId | Integer | The unique identifier of the Contact. | |
| SysEffectiveDate | String | SysEffectiveDate. | |
| ResourcePartyIdRest | Integer | The unique identifier of the Resource. | |
| RestCreationDateLower | String | Finds the leads that are created before the date specified. | |
| RestCreationDateUpper | String | Finds the leads with the specified creation date. | |
| RestRecordSet | String | Finds the leads with the specified record set value. | |
| RestStatusCode | String | Finds the leads with the specified status code. | |
| Name | String | Finds the leads with the specified lead name. |