Goods Fields
Set
Cmp — a set (a set card — data taken from the Calculation, Main Parameters, Technology, Other, and Period Attributes tabs)
OnDate — as of the date (the Calculation area)
ISum — the cost price excl taxes (the Calculation area)
ITax1 — the VAT (the Calculation area)
ITax2 — the sales tax (the Calculation area)
IFSum — the cost price incl taxes (the Calculation area)
ESum — the selling amount excl taxes (the Calculation area)
ETax1 — the selling VAT (the Calculation area)
ETax2 — the selling sales tax (the Calculation area)
EFSum — the selling amount incl taxes (the Calculation area)
DiscountP — an extra charge, % (the Calculation area)
FoodsCostP — the cost price or selling amount, % (the Calculation area)
Discount — the extra charge amount (the Calculation area)
Norm — the standardized ingredient quantity
CmpVHdrRid — the period identifier of a set
CmpVHdrStartDate — the period of a set (Period starting from)
CmpVHdrCooking — cooking technology (the Technology tab)
CmpHdrAttrs — the container for set validity period attributes (service 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 with 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 — the container for additional attributes of a set validity period (service 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 with 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 — the scope of application (the Other tab)
CmpVHdrRaw — requirements for raw materials (the Other tab)
CmpVHdrOutput — the ready output (the Other tab)
CmpVHdrBasis — the production basis (the Other tab)
CmpVHdrDesign — requirements for presentation, sales, and storage (the Other tab)
CmpVHdrOrganoleptic — organoleptic properties (the Other tab)
CmpVHdrMicroBio — microbiological properties (the Other tab)
CmpVHdrStopDate — the period of a set (Period ending on)
CmpVerRid — the version identifier of a set
CmpVerNum — a set version number
CmpVerName — a set version name
RID — the identifier of a set
MUnitRid — the identifier of a UOM of the standardized ingredient quantity
MUnitName — the name of a UOM of the standardized ingredient quantity
CmpGroupRid — the identifier of a set group (the Main Parameters tab)
CmpGroupName — the name of a set group (the Main Parameters tab)
DepRid — a department identifier (the Calculation area)
DepName — a department name (the Calculation area)
DepAttrs — 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 with 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 — the container for additional attributes of a department (service 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 — the identifier of a legal entity to which a department belongs (the Calculation area)
DepLEntityName — the name of a legal entity to which a department belongs (the Calculation area)
DepLEntityAttrsEx — the container for additional attributes of an internal legal entity to which a department belongs (service 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 — the identifier of an enterprise to which a department belongs (the Calculation area)
DepDivisionName — the name of an enterprise to which a department belongs (the Calculation area)
DepDivisionAttrsEx — the container for additional attributes of an enterprise to which a department belongs (service 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 — the name of a set
CmpAttrs — the container for attributes of a set (service 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 with 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 — the container for additional attributes of a set (service 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 with 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 — the code of a set
CmpDetail — goods included in a set (a set card, data taken from the bottom part of the Calculation tab)
CmpDetail_F95 — the price excl taxes (base UOM)
CmpDetail_F96 — the price incl taxes (base UOM)
Rid — a specification identifier of a set
Flags — a checkbox (1 means that the Produce box is checked)
Order — the cosequtive number
Quant — the gross weight
Perc1 — %1
Perc2 — %2
GoodsCmpRid — the identifier/code of a set that is indicated in the card of a given goods item
GoodsCmpName — the name of a set that is indicated in the card of a given goods item
GoodsRid — a goods identifier/code
GoodsMURid — a goods UOM identifier
GoodsMUName — a goods UOM name
GoodsMUAttrs — the contaiter of a goods UOM attributes (service 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 — the VAT rate (VAT%). For example, if the rate is 10%, this field will contain 1000.
CmpDetail_F210\213#10\9 — the sales tax rate (sales tax%). For example, if the rate is 10%, this field will contain 1000.
GoodsPerc1 — Processing 1(%) from the card of a given goods item (the Add. Parameters tab)
GoodsPerc2 — Processing 2(%) from the card of a given goods item (the Add. Parameters tab)
GoodsName — the name of a goods item (Product)
GoodsAttrs — the container for goods attributes (service 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 with 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 — 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 with 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 — a base UOM identifier
CmpDetail_F210\206\3 — the name of a base UOM
CmpDetail_F500\1 — a substitution group identifier
CmpDetail_F500\3 — a substitution group name
Attrs — the container for set specification attributes (service 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