Goods Fields
Set
Cmp is — a set (a set card , — data taken from the tabs Calculation, Main Parameters, Technology, Other, and Period Attributes tabs)
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 /or selling amount, % (the Calculation area)
Discount is — the extra charge amount (the Calculation area)
Norm is — the stadardized standardized 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 . 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.
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 . 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.
CmpVHdrUseArea is — the scope of application (the Other tab)
CmpVHdrRaw means — requirements for raw materials (the Other tab)
CmpVHdrOutput is — the yield ready output (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 identifier 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 . 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.
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 . 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 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.
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 . 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 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.
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 . 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 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.
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 . 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.
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 . 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.
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.cosequtive number
Quant is — the Gross 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 ния товара 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.
CmpDetail_F210\212#10\9 is — the VAT rate (VAT%) rate (for . 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 . 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 Add. Parameters tab)
GoodsPerc2 is — Processing 2(%) from the card of a given goods item (the Addl Add. 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 . 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.
GoodsAttrsEx is — the container for additional goods attributes (procedure field)
… next is the list of fields containing additional attributes of a goods item (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.
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 . 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