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 (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 (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 (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 (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 (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 (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 (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 (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 (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 (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 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.
AttrsEx — 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 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.
ISum — the amount excl taxes (Cost price)
ITax1 — VAT (Cost price)
ITax2 — the sales tax (Cost price)
IFSum — the amount incl taxes (Cost price)
IPrice — the price excl taxes (Cost price)
IFPrice — the price incl taxes (Cost price)
Quant1 — the net weight
Quant2 — the yield
CmpDetailEx — detailed data on the set contents (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 — a specification identifier of a set
DetParent — the identifier of the set parent BOM (reference to the DetRid field)
Flags — a checkbox (1 means that the Produce box is checked)
Quant — the gross weight
Quant1 — the net weight
Quant2 — the yield
GoodsRid — the goods identifier/code
GoodsName — the name of a goods item (Product)
MURid — a goods UOM identifier
MUName — a goods UOM name
Level — 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 — the period identifier of a set
HdrStartDate — the period of a set (Period starting from)
Cooking — the cooking technology
Attrs — 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 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.
AttrsEx — 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 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.
PropUseArea — the usage area
PropRaw — requirements to raw materials
PropOutput — the products output
PropBasis — production basis
PropDesign — requirements to presentation, sales, and storage
PropOrganoleptic — organoleptic properties
PropMicroBio — microbiological properties
CmpEnergy — 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 — a goods identifier/code
GoodsName — the name of a goods item (Product)
GoodsAttrs — 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 — a goods UOM identifier
MUnitsName — a goods UOM name
MUnitsAttrs — 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 — protein (g) (content in 100 g of a product)
Fats_100gr — fat (g) (content in 100 g of a product)
CHydr_100gr — carbohydrates (g) (content in 100 g of a product)
Energy100gr — kcal (the energy value of 100 g of a product)
Proteins — protein (g) (the content in the product quantity from the Net column)
Fats — fat (g) (the content in the product quantity from the Net column)
CHydr — carbohydrates (g) (the content in the product quantity from the Net column)
Energy — kcal (the energy value of the product quantity from the Net column)
CmpEnergyOutput — the Net weight