View Design fields: Inventory (IN)

General tab

Inventory data—General
Manager label:Available field:Length:
IdID15
Sales Tax CategorySALESTAXCATEGORY15
LabelLABEL32
TypeTYPE15
SubtypeSUBTYPE15
CategoryCATEGORY15
SKUSKUNUMBER32
Created DateCREATIONDATE10
Last UpdatedLASTUPDATED10
Time UpdatedTIMEUPDATED8
Futures DateFUTURESDATE10
NameNAME100
DescriptionDESCRIPTION200
Display on Shopping CartDISPLAYONCART15
Item Counting EnabledITEMCOUNTING15
VendorVENDOR50
DepartmentDEPARTMENT50
Retail Unit PricePRICE16
Wholesale Unit PriceWHOLESALEPRICE16
Unit Cost PriceCOGSPRICE16
WeightWEIGHT15
Case PriceCASEPRICE16
Brand KeyBRAND32
TaxableTAXABLE15
Do Not DiscountDONOTDISCOUNT15
Do Not Allow Customers to Delete SelectionALLOWSELECTIONDELETE15
Product DiscountCLUBDISCOUNT16
Is AlcoholISALCOHOL15
Alcohol PackagingALCOHOLPACKAGING15
LitersLITERSOFALCOHOL13
Volume of AlcoholVOLUMEOFALCOHOL12
Tax ClassTAXCLASS15
No of BottlesNOOFBOTTLES7
Bottles Per CaseBOTTLESPERCASE12
Cases Per PalletCASESPERPALLET12
VintageVINTAGE12
Library WineLIBRARYWINE15
Reserve WineRESERVEWINE15
Wine TypeWINETYPE25
VarietalVARIETAL25

Attributes tab

Inventory data—Attributes
Manager label:Available field:Length:
Attribute (1–10)ATTRIBUTE(1–10)15


Notes tab

Inventory data—Notes
Manager label:Available field:Length:
Cart Text LineCATALOGTEXTLINE100
Club Discount Price TextCATALOGCLUBDISCOUNTTEXT100
Club PriceCATALOGCLUBPRICE16
NotesNOTES10000


Wine Specs tab

Inventory data—Wine Specs
Manager label:Available field:Length:
AppellationAPPELLATION25
Harvest DateHARVESTDATE25
Cases ProducedCASESPRODUCED32
Clonal SelectionCLONALSELECTION40
BarcodeBARCODE32
PercentageVARIETAL(1–6)COMPPERCENT12
DescriptionVARIETAL(1–6)COMPDESC40
SpanBARRELAGING(1–4)SPAN15
PercentBARRELAGING(1–4)PERC12
Barrel TypeBARRELAGING(1–4)TYPE40
HonorAWARD(1–5)HONOR32
DescriptionAWARD(1–5)DESC40


Images tab

Inventory data—Images
Manager label:Available field:Length:
Name of Large Image FileIMAGE254
Name of Thumbnail Image FileTHUMBNAILIMAGE254


Setup tab

Inventory data—Setup
Manager label:Available field:Length:
AllocatedALLOCATED12
AvailableAVAILABLE12
External Ref DateEXTERNALREFDATE10
External ReferenceEXTERNALREFERENCE20
External Ref TimeEXTERNALREFTIME8
Inventory IdINVENTORYID15
Inventory NameINVENTORYNAME500
Location/RUNTIMEGROUPNAME50
Maximum Quantity for SelectionsMAXSELECTIONAMOUNT7
On HandONHAND12
On OrderONORDER12
Type NameGROUPTYPENAME15

QuickBooks tab

Inventory data—QuickBooks
Manager label:Available field:Length:
Income AccountACCOUNTNAME100
Cost AccountCOGSACCOUNTNAME100
Asset AccountASSETACCOUNTNAME100
Case Product Income AccountCASEINCOMEACCOUNTNAME100
Case Product Cost AccountCASECOGSACCOUNTNAME100
Case Product Asset AccountCASEASSETACCOUNTNAME100

Available linked tables:

IAInventory Stock
ILInventory Location


Related topic:

View Design field names