| Line 54... |
Line 54... |
| 54 |
isWarehousePreferenceSticky = Field(Boolean)
|
54 |
isWarehousePreferenceSticky = Field(Boolean)
|
| 55 |
preferredVendor = Field(Integer)
|
55 |
preferredVendor = Field(Integer)
|
| 56 |
type = Field(Enum('SERIALIZED', 'NON_SERIALIZED'), default = 'NON_SERIALIZED', server_default='NON_SERIALIZED')
|
56 |
type = Field(Enum('SERIALIZED', 'NON_SERIALIZED'), default = 'NON_SERIALIZED', server_default='NON_SERIALIZED')
|
| 57 |
hasItemNo = Field(Boolean)
|
57 |
hasItemNo = Field(Boolean)
|
| 58 |
activeOnStore = Field(Boolean)
|
58 |
activeOnStore = Field(Boolean)
|
| 59 |
vatPercentage = Field(Float)
|
- |
|
| 60 |
showSellingPrice = Field(Boolean)
|
59 |
showSellingPrice = Field(Boolean)
|
| 61 |
preferredInsurer = Field(Integer)
|
60 |
preferredInsurer = Field(Integer)
|
| 62 |
asin = Field(String(20))
|
61 |
asin = Field(String(20))
|
| 63 |
holdInventory = Field(Integer, default=0, server_default="0")
|
62 |
holdInventory = Field(Integer, default=0, server_default="0")
|
| 64 |
defaultInventory = Field(Integer, default=0, server_default="0")
|
63 |
defaultInventory = Field(Integer, default=0, server_default="0")
|
| Line 66... |
Line 65... |
| 66 |
using_table_options(mysql_engine="InnoDB")
|
65 |
using_table_options(mysql_engine="InnoDB")
|
| 67 |
|
66 |
|
| 68 |
def __repr__(self):
|
67 |
def __repr__(self):
|
| 69 |
return "<Item>%d</item>" % (self.id)
|
68 |
return "<Item>%d</item>" % (self.id)
|
| 70 |
|
69 |
|
| - |
|
70 |
class ItemVatMaster(Entity):
|
| - |
|
71 |
itemId = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
72 |
stateId = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
73 |
vatPercentage = Field(Float)
|
| - |
|
74 |
using_options(shortnames=True)
|
| - |
|
75 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
76 |
|
| - |
|
77 |
|
| 71 |
class ItemChangeLog(Entity):
|
78 |
class ItemChangeLog(Entity):
|
| 72 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
79 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
| 73 |
old_status = Field(Integer)
|
80 |
old_status = Field(Integer)
|
| 74 |
new_status = Field(Integer)
|
81 |
new_status = Field(Integer)
|
| 75 |
timestamp = Field(DateTime)
|
82 |
timestamp = Field(DateTime)
|
| Line 132... |
Line 139... |
| 132 |
amount = Field(Integer, default=0, server_default="0")
|
139 |
amount = Field(Integer, default=0, server_default="0")
|
| 133 |
using_options(shortnames=True)
|
140 |
using_options(shortnames=True)
|
| 134 |
using_table_options(mysql_engine="InnoDB")
|
141 |
using_table_options(mysql_engine="InnoDB")
|
| 135 |
|
142 |
|
| 136 |
class CategoryVatMaster(Entity):
|
143 |
class CategoryVatMaster(Entity):
|
| 137 |
categoryId = Field(Integer, primary_key=True)
|
144 |
categoryId = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
145 |
stateId = Field(Integer, primary_key=True, autoincrement=False)
|
| 138 |
minVal = Field(Integer, primary_key=True)
|
146 |
minVal = Field(Integer, primary_key=True, autoincrement=False)
|
| 139 |
maxVal = Field(Integer, primary_key=True)
|
147 |
maxVal = Field(Integer, primary_key=True, autoincrement=False)
|
| 140 |
vatPercent = Field(Float)
|
148 |
vatPercent = Field(Float)
|
| 141 |
using_options(shortnames=True)
|
149 |
using_options(shortnames=True)
|
| 142 |
using_table_options(mysql_engine="InnoDB")
|
150 |
using_table_options(mysql_engine="InnoDB")
|
| 143 |
|
151 |
|
| 144 |
class OOSTracker(Entity):
|
152 |
class OOSTracker(Entity):
|