ADO.NET Provider for Reckon Accounts Hosted

Build 24.0.9060

PriceLevelPerItem

Create and query Reckon Price Levels Per Item. Only Reckon Premier and Enterprise support Per-Item Price Levels. Note that while Price Levels can be added from this table, you may only add Per-Item Price Levels from this table. Price Levels may be deleted from the PriceLevels table.

Columns

Name Type ReadOnly References Description
ID [KEY] String True

The unique identifier.

PriceLevelID String False

PriceLevels.ID

The unique identifier of the price level.

Name String False

The name of the price level.

PriceLevelType String True

The type of price level.

The allowed values are FixedPercentage, PerItem.

IsActive Boolean False

A boolean determining if the price level is active.

PriceLevelPerItemRet_ItemRef_ListID String False

Items.ID

A reference to the Id of the item. Either the Id or FullName property of the item is required on insertion.

PriceLevelPerItemRet_ItemRef_FullName String False

Items.FullName

A reference to the name of the item. Either the Id or FullName property of the item is required on insertion.

PriceLevelPerItemRet_CustomPrice Double False

A fixed amount for the price.

PriceLevelPerItemRet_CustomPricePercent Double False

A fixed discount percentage.

TimeCreated Datetime True

The datetime the transaction was made.

TimeModified Datetime True

The last datetime the transaction was modified.

EditSequence String True

An identifier used for versioning for this copy of the object.

Pseudo-Columns

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
StartTxnDate String

This pseudo column is deprecated and should no longer be used. Earliest transaction date to search for.

EndTxnDate String

This pseudo column is deprecated and should no longer be used. Latest transaction date to search for.

StartModifiedDate String

This pseudo column is deprecated and should no longer be used. Earliest modified date to search for.

EndModifiedDate String

This pseudo column is deprecated and should no longer be used. Latest modified date to search for.

NameMatchType String

This pseudo column is deprecated and should no longer be used. Type of match to perform on name.

The allowed values are EXACT, STARTSWITH, ENDSWITH, CONTAINS.

The default value is CONTAINS.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060