PriceLevelPerItem Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 75 4.0 US, CA, UK
ListID 12 VARCHAR 36 True False False False %s ListID 4.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 4.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 4.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 4.0 US, CA, UK
Name 12 VARCHAR 31 True True True True %s 4.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 4.0 US, CA, UK
PriceLevelType 12 VARCHAR 15 True False False False
FixedPercentage
PerItem
 4.0 US, CA, UK
PriceLevelPerItem_SeqNo 4 INTEGER 9 True False False False SeqNo 1.0 US, CA, UK
PriceLevelPerItem_ItemRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
PriceLevelPerItem_ItemRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
PriceLevelPerItem_CustomPrice 2 NUMERIC 18 True True True False %10.5f 1.0 US, CA, UK
PriceLevelPerItem_CustomPricePercent 2 NUMERIC 18 True True True False %10.5f 1.0 US, CA, UK
PriceLevelPerItem_AdjustPercentage 2 NUMERIC 15 True True True False %10.5f 1.0 US, CA, UK
PriceLevelPerItem_AdjustRelativeTo 12 VARCHAR 15 True True True False
StandardPrice
Cost
CurrentCustomPrice
 4.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True True True False %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 159 True True True False %s Name 8.0 US, CA, UK
RQUseCachedID -7 BIT 2 4.0 US, CA, UK

Back to list of tables.