PriceLevel Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ListID12VARCHAR36TrueFalseFalseFalse%s4.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ4.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ4.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s4.0US, CA, UK
Name12VARCHAR31TrueTrueTrueTrue%s4.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
4.0US, CA, UK
PriceLevelType12VARCHAR15TrueFalseFalseFalse
FixedPercentage
PerItem
4.0US, CA, UK
PriceLevelFixedPercentage2NUMERIC18TrueTrueTrueFalse%10.5f4.0US, CA, UK