| Name | Description | Type | Additional information |
|---|---|---|---|
| CatalogID |
Primary key. Auto-incremented. database reference = products.catalogid |
integer |
None. |
| SKU |
database reference = products.id |
string |
String length: inclusive between 0 and 255 |
| Name |
database reference = products.name |
string |
String length: inclusive between 0 and 255 |
| Cost |
database reference = products.cost |
decimal number |
None. |
| Price |
database reference = products.price |
decimal number |
None. |
| Currency |
Dynamically generated field. No database reference. |
string |
None. |
| RetailPrice |
database reference = products.price2 |
decimal number |
None. |
| SalePrice |
database reference = products.saleprice |
decimal number |
None. |
| OnSale |
database reference = products.onsale |
boolean |
None. |
| Stock |
database reference = products.stock |
decimal number |
None. |