A retail item for which instances can be sold.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
ONHANDQUANTITY
|
int
|
false
|
|
The on hand quantity for the product instance.
|
|
ISACTIVE
|
bit
|
false
|
|
The active status of the product.
|
|
PICTURE
|
varbinary
|
true
|
|
A photo or emblem for this constituent.
|
|
PICTURETHUMBNAIL
|
varbinary
|
true
|
|
|
|
ISDISCOUNTABLE
|
bit
|
false
|
|
The discountable status of the product.
|
