Goods Fields

Set

Cmp is a set (a set card, data taken from the tabs Calculation, Main Parameters, Technology, Other and Period Attributes)
OnDate means as of the date (the Calculation area)
ISum is the cost price excl taxes (the Calculation area)
ITax1 is the VAT (the Calculation area)
ITax2 is the sales tax (the Calculation area)
IFSum is the cost price incl taxes (the Calculation area)
ESum is the selling amount excl taxes (the Calculation area)
ETax1 is the selling VAT (the Calculation area)
ETax2 is the selling sales tax (the Calculation area)
EFSum is the selling amount incl taxes (the Calculation area)
DiscountP is an extra charge, % (the Calculation area)
FoodsCostP is the cost price/selling amount, % (the Calculation area)
Discount is the extra charge amount (the Calculation area)
Norm is the stadardized ingredient quantity
CmpVHdrRid is the period identifier of a set
CmpVHdrStartDate is the period of a set (Period starting from)
CmpVHdrCooking is cooking technology (the Technology tab)
CmpHdrAttrs is the container for set validity period attributes (procedure field)
… next is the list of fields containing attributes of a set validity period (the Period Attributes tab) (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in itext, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
CmpHdrAttrsEx is the container for additional attributes of a set validity period (procedure field)
… next is the list of fields containing additional attributes of a set validity period (the Period Attributes tab) (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in itext, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field
CmpVHdrUseArea is the scope of application (the Other tab)
CmpVHdrRaw means requirements for raw materials (the Other tab)
CmpVHdrOutput is the yield (the Other tab)
CmpVHdrBasis is the production basis (the Other tab)
CmpVHdrDesign means requirements for presentation, sales and storage (the Other tab)
CmpVHdrOrganoleptic means organoleptic properties (the Other tab)
CmpVHdrMicroBio means microbiological properties (the Other tab)
CmpVHdrStopDate is the period of a set (Period ending on)
CmpVerRid is the version identifier of a set
CmpVerNum is a set version number
CmpVerName is a set version name
RID is the idenfitifier of a set
MUnitRid is the identifier of a UOM of the standardized ingredient quantity
MUnitName is the name of a UOM of the standardized ingredient quantity
CmpGroupRid is the identifier of a set group (the Main Parameters tab)
CmpGroupName is the name of a set group (the Main Parameters tab)
DepRid is a department identifier (the Calculation area)
DepName a department name (the Calculation area)
DepAttrs is the container for department attributes (procedure field)
… next is the list of fields containing attributes of a department (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in itext, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
DepAttrsEx is the container for additional attributes of a department (procedure field)
… next is the list of fields containing additional attributes of a department (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in itext, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field
DepLEntityRid is the identifier of a legal entity to which a department belongs (the Calculation area)
DepLEntityName is the name of a legal entity to which a department belongs (the Calculation area)
DepLEntityAttrsEx is the container for additional attributes of an internal legal entity to which a department belongs (procedure field)
… next is the list of fields containing additional attributes of an internal legal entity to which a department belongs (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in itext, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field
DepDivisionRid is the identifier of an enterprise to which a department belongs (the Calculation area)
DepDivisionName is the name of an enterprise to which a department belongs (the Calculation area)
DepDivisionAttrsEx is the container for additional attributes of an enterprise to which a department belongs (procedure field)
… next is the list of fields containing additional attributes of an enterprise (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in itext, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field
Name is the name of a set
CmpAttrs is the container for attributes of a set (procedure field)
… next is the list of fields containing attributes of a set (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in _itext_, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
CmpAttrsEx is the container for additional attributes of a set (procedure field)
… next is the list of fields containing additional attributes of a set (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in _itext_, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field
Code is the code of a set
CmpDetail means goods included in a set (a set card, data taken from the bottom part of the Calculation tab)
CmpDetail_F95 is the price excl taxes (base UOM)
CmpDetail_F96 is the price incl taxes (base UOM)
Rid is a specification identifier of a set
Flags is a checkbox (1 means that the Produce box is checked)
Order is the No.
Quant is the Gross weight
Perc1 - %1
Perc2 - %2
GoodsCmpRid is the identifier/code of a set that is indicated in the card of a given goods item
GoodsCmpName is the name of a set that is indicated in the card of a given goods item
GoodsRid is a goods identifier/code
GoodsMURid is a goods UOM identifier
GoodsMUName is a goods UOM name
GoodsMUAttrs is the contaiter of a ния товара (procedure field)
… next is the list of fields containing attributes of a goods UOM (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in itext, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
CmpDetail_F210\212#10\9 is the VAT (VAT%) rate (for example, if the rate is 10%, this field will contain 1000)
CmpDetail_F210\213#10\9 is the sales tax rate (sales tax%) (for example, if the rate is 10%, this field will contain 1000)
GoodsPerc1 is Processing 1(%) from the card of a given goods item (the Addl Parameters tab)
GoodsPerc2 is Processing 2(%) from the card of a given goods item (the Addl Parameters tab)
GoodsName is the name of a goods item (Product)
GoodsAttrs is the container for goods attributes (procedure field)
… next is the list of fields containing attributes of a goods item (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in itext, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
GoodsAttrsEx is the container for additional goods attributes (procedure field)
… next is the list of fields containing additional attributes of a goods item (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in itext, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field
CmpDetail_F210\206\1 is a base UOM identifier
CmpDetail_F210\206\3 is the name of a base UOM
CmpDetail_F500\1 a substitution group identifier
CmpDetail_F500\3 is a substitution group name
Attrs is the container for set specification attributes (procedure field)
… next is the list of fields containing attributes of a set specification (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in _itext_, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
AttrsEx - Контейнер is the container for additional attributes of a set specification (procedure field)
… next is the list of fields containing additional attributes of a set specification (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in _itext_, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field
ISum is the amount excl taxes (Cost price)
ITax1 is the VAT (Cost price)
ITax2 is the sales tax (Cost price)
IFSum is the amount incl taxes (Cost price)
IPrice is the price excl taxes (Cost price)
IFPrice is the price incl taxes (Cost price)
Quant1 is the net weight
Quant2 is the yield
CmpDetailEx means detailed data on the contents of a set (a set card, data taken from the Component Detailing tab, plus data on sets of those goods items that have a reference to a set in their cards)
DetRid is a specification identifier of a set
DetParent -is the identifier of the set parent specification (reference to the DetRid field)
Flags is a checkbox (1 means that the Produce box is checked)
Quant is the gross weight
Quant1 is the net weight
Quant2 is the yield
GoodsRid is a goods identifier/code
GoodsName is the name of a goods item (Product)
MURid is a goods UOM identifier
MUName is a goods UOM name
Level is a level
If a goods item has a reference to a set (in the goods card), the following fields show data on this goods set:
HdrRid is the period identifier of a set
HdrStartDate is the period of a set (Period starting from)
Cooking is the cooking technology
Attrs is the container for set validity period attributes (procedure field)
… next is the list of fields containing attributes of a set validity period (the Period Attributes tab) (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in _itext_, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field_
AttrsEx is the container for additional attributes of a set validity period (procedure field)
… next is the list of fields containing additional attributes of a set validity period (the Period Attributes tab) (if there are no additional attributes, there are no fields); there are two fields for additional attributes of the Enumeration type (the name of the first field ends in _itext_, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as for additional attributes with other data types, values of those attributes are just shown in the first field_
PropUseArea is the scope of application
PropRaw means requirements to raw materials
PropOutput is the yield
PropBasis means production basis
PropDesign means requirements for presentation, sales and storage
PropOrganoleptic means organoleptic properties
PropMicroBio means microbiological properties
CmpEnergy means the protein, fat and carbohydrate content of goods included in a set, plus their energy value (a set card, data taken from the Enery Value tab)
GoodsRid is a goods identifier/code
GoodsName is the name of a goods item (Product)
GoodsAttrs is the container for goods attributes (procedure field)
… next is the list of fields containing attributes of a goods item (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in itext, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
MUnitsRid is a goods UOM identifier
MUnitsName is a goods UOM name
MUnitsAttrs is the container for goods UOM attributes (procedure field)
…next is the list of fields containing attributes of a goods UOM (if there are no attributes, there are no fields); there are two fields for attributes of the Enumeration type (the name of the first field ends in itext, which is an attribute value; the second field without this ending is an attribute identifier); as for attributes with other data types, values of those attributes are just shown in the first field
Proteins_100gr means protein (g) (content in 100 g of a product)
Fats_100gr means fat (g) (content in 100 g of a product)
CHydr_100gr means carbohydrates (g) (content in 100 g of a product)
Energy100gr means kcal (the energy value of 100 g of a product)
Proteins means protein (g) (the content in the quantity of product from the Net column)
Fats means fat (g) (the content in the quantity of product from the Net column)
CHydr means carbohydrates (g) (the content in the quantity of product from the Net column)
Energy means kcal (the energy value of the product quantity from the Net column)
CmpEnergyOutput is the Net weight