...
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 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 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 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 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 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 — 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 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 — 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 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 — the name of a set
CmpAttrs — the container for attributes of a set (service 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 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 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 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 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 — 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 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 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 procedure field)
… next is the list of fields containing attributes of a set specification. If there are no attributes, there are no fields); there . There are two fields for attributes of the Enumeration type (: the name of the first field ends in _with itext_, which is an attribute value; the second field without this ending is an attribute identifier); as . 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 . If there are no additional attributes, there are no fields); there . There are two fields for additional attributes of the Enumeration type (: the name of the first field ends in _with itext_, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as . 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 set contents of a set (a set card, : the 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 BOM (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 — the 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 . If there are no attributes, there are no fields); there . There are two fields for attributes of the Enumeration type (: the name of the first field ends in _with itext_, which is an attribute value; the second field without this ending is an attribute identifier); as . 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 . If there are no additional attributes, there are no fields); there . There are two fields for additional attributes of the Enumeration type (: the name of the first field ends in _with itext_, which is an additional attribute value; the second field without this ending is an additional attribute identifier); as . 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— the usage area
PropRaw means — requirements to raw materials
PropOutput is — the yieldproducts output
PropBasis means — production basis
PropDesign means — requirements for to 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 . If there are no attributes, there are no fields); there . 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 . 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 . If there are no attributes, there are no fields); there . 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 . 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 product quantity of product from the Net column)
Fats means — fat (g) (the content in the product quantity of product from the Net column)
CHydr means — carbohydrates (g) (the content in the product 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