TABLE DETAIL REFERENCE: PriceLevel
(Australia ,New Zealand,Singapore Southeast Asia VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PriceLevelType12 VARCHAR 15TrueFalseFalseFalse
FixedPercentage
PerItem
PriceLevelFixedPercentage3 DECIMAL 15TrueTrueTrueFalse%7.5f