Products
Services
Solutions
Support
OEM
Company
Blog
<a href="/cgi-bin/account/login.cgi">Log in</a> <a href="/cgi-bin/account/logout.cgi">Log out</a>/<a href="/cgi-bin/account/register.cgi">Register</a>
PriceLevel 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
ListID
12
VARCHAR
36
True
False
False
False
%s
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
PriceLevelFixedPercentage
2
NUMERIC
18
True
True
True
False
%10.5f
4.0
US, CA, UK
