TABLE DETAIL REFERENCE: ItemInventory
(POS VERSION)
FIELD NAME | TYPE | TYPENAME | LENGTH | QUERYABLE | UPDATEABLE | INSERTABLE | REQUIRED ON INSERT |
VALIDATE | RELATES TO |
---|---|---|---|---|---|---|---|---|---|
ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | |
TimeCreated | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
TimeModified | 11 | TIMESTAMP | 16 | True | False | False | False | CCCC-MM-DDThh:mm:ssZ | |
ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
Attribute | 12 | VARCHAR | 8 | True | True | True | False | %s | |
COGSAccount | 12 | VARCHAR | 159 | True | True | True | False | %s | |
Cost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
DepartmentCode | 12 | VARCHAR | 3 | True | True | True | False | %s | |
DepartmentListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
Desc1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
Desc2 | 12 | VARCHAR | 8000 | True | True | True | False | %s | |
IncomeAccount | 12 | VARCHAR | 159 | True | True | True | False | %s | |
IsBelowReorder | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsEligibleForCommission | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsPrintingTags | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
IsUnorderable | -7 | BIT | 1 | True | True | True | False | 1 0 true false | |
ItemNumber | 4 | INTEGER | 4 | True | False | False | False | %11.0f | |
ItemType | 12 | VARCHAR | 13 | True | True | True | False | Inventory Non-Inventory Service Assembly Group SpecialOrder | |
Keywords | 12 | VARCHAR | 18 | True | True | True | False | %s | |
LastReceived | 9 | DATE | 6 | True | True | True | False | CCCC-MM-DD | |
MarginPercent | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
MarkupPercent | 4 | INTEGER | 4 | True | True | True | False | %11.0f | |
MSRP | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
OnHandStore01 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore02 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore03 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore04 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore05 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore06 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore07 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore08 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore09 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore10 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore11 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore12 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore13 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore14 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore15 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore16 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore17 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore18 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore19 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OnHandStore20 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
OrderByUnit | 12 | VARCHAR | 20 | True | True | True | False | %s | |
OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
QuantityOnCustomerOrder | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
QuantityOnHand | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
QuantityOnOrder | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
QuantityOnPendingOrder | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPoint | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore01 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore02 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore03 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore04 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore05 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore06 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore07 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore08 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore09 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore10 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore11 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore12 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore13 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore14 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore15 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore16 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore17 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore18 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore19 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
ReorderPointStore20 | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
SellByUnit | 12 | VARCHAR | 20 | True | True | True | False | %s | |
SerialFlag | 12 | VARCHAR | 8 | True | True | True | False | Optional Prompt | |
Size | 12 | VARCHAR | 12 | True | True | True | False | %s | |
StoreExchangeStatus | 12 | VARCHAR | 12 | True | True | True | False | Modified Sent Acknowledged | |
TaxCode | 12 | VARCHAR | 36 | True | True | True | False | %s | |
UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorCode | 12 | VARCHAR | 3 | True | True | True | False | %s | |
VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
WebDesc | 12 | VARCHAR | 18 | True | True | True | False | %s | |
WebPrice | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
Manufacturer | 12 | VARCHAR | 50 | True | True | True | False | %s | |
Weight | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
WebSKU | 12 | VARCHAR | 18 | True | True | True | False | %s | |
WebCategories | 12 | VARCHAR | 18 | True | True | True | False | %s | |
UnitOfMeasure1ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure1MSRP | 3 | DECIMAL | 13 | True | True | True | False | %7.5f | |
UnitOfMeasure1NumberOfBaseUnits | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
UnitOfMeasure1Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure1UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure1UPC | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure2ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure2MSRP | 3 | DECIMAL | 13 | True | True | True | False | %7.5f | |
UnitOfMeasure2NumberOfBaseUnits | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
UnitOfMeasure2Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure2UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure2UPC | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure3ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure3MSRP | 3 | DECIMAL | 13 | True | True | True | False | %7.5f | |
UnitOfMeasure3NumberOfBaseUnits | 3 | DECIMAL | 15 | True | True | True | False | %7.5f | |
UnitOfMeasure3Price1 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price2 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price3 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price4 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3Price5 | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
UnitOfMeasure3UnitOfMeasure | 12 | VARCHAR | 20 | True | True | True | False | %s | |
UnitOfMeasure3UPC | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo2ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo2OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo2UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo2VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
VendorInfo3ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo3OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo3UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo3VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
VendorInfo4ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo4OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo4UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo4VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | Yes |
VendorInfo5ALU | 12 | VARCHAR | 20 | True | True | True | False | %s | |
VendorInfo5OrderCost | 3 | DECIMAL | 16 | True | True | True | False | %8.5f | |
VendorInfo5UPC | 12 | VARCHAR | 18 | True | True | True | False | %s | |
VendorInfo5VendorListID | 12 | VARCHAR | 36 | True | True | True | False | %s | |
CustomFieldAlternateLoc1 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldAlternateLoc2 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldAlternateLoc3 | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldCatagory | 12 | VARCHAR | 30 | True | True | True | False | %s | |
CustomFieldPrimaryLocation | 12 | VARCHAR | 30 | True | True | True | False | %s |