Table 70094429 EOS083 SIAN Operation Line

Table 70094429 EOS083 SIAN Operation Line

Table “EOS083 SIAN Operation Line” contains details of SIAN Operations

Language	Caption
en-GB	SIAN Operation Line
en-US	SIAN Operation Line
it-IT	Righe operazioni SIAN

Fields

Entry No. (`1`)

Integer

“Entry No.” compose part of primary key

Language	Caption
de-DE	Lfd. Nr.
en-GB	Entry No.
en-US	Entry No.
it-IT	Nr. movimento

SIAN Operation Entry No. (`2`)

Integer

“SIAN Operation Entry No.” refers to Entry No. of related header and compose primary key

Language	Caption
de-DE	SIAN Operation Lfd. Nr.
en-GB	SIAN Operation Entry No.
en-US	SIAN Operation Entry No.
it-IT	Nr. movimento Operazione SIAN

Product Number (`3`)

Integer

“Product Number” specifies number of product

Language	Caption
de-DE	Produktnummer
en-GB	Product Number
en-US	Product Number
it-IT	Numero Prodotto

Item No. (`4`)

Code[20]

TableRelation: Item."No."

“Item No.” specifies number of item

Language	Caption
de-DE	Artikelnr.
en-GB	Item No.
en-US	Item No.
it-IT	Nr. Articolo

Item Category Code (`5`)

Code[10]

“Item Category Code” specifies code of item category

Language	Caption
de-DE	Artikelkategoriencode
en-GB	Item Category Code
en-US	Item Category Code
it-IT	Codice categoria articolo

Wine Type (`6`)

Enum "EOS EX080 Wine Type"

“Wine Type” specifies type of wine

Language	Caption
de-DE	Weinart
en-GB	Wine Type
en-US	Wine Type
it-IT	Tipo Vino

Operation Type (`7`)

enum "EOS083 Operation Type"

“Opeartion Type” specifies type of operation

Language	Caption
de-DE	Operationstyp
en-GB	Operation Type
en-US	Operation Type
it-IT	Tipo Operazione

SIAN Item Attribute Code (`8`)

Code[10]

TableRelation: "EOS083 SIAN Item Attributes"."Primary Code"

“SIAN Item Attribute Code” specifies code of related SIAN Item Attribute

Language	Caption
de-DE	SIAN Artikeleigenschaftencode
en-GB	SIAN Item Attribute Code
en-US	SIAN Item Attribute Code
it-IT	Codice attributi articoli SIAN

Category (`9`)

Code[30]

TableRelation: "EOS083 SIAN Tables".Code where("Table Type" = const(Category))

Category specifies SIAN Category

Language	Caption
de-DE	Kategorie
en-GB	Category
en-US	Category
it-IT	Categoria

Act Certification (`10`)

Code[30]

“Act Certification” specifies SIAN Act Certification

Language	Caption
en-GB	Act Certification
en-US	Act Certification
it-IT	Atto/certificato

Classification (`11`)

Code[30]

Classification specifies SIAN classification

Language	Caption
de-DE	Klassifizierung
en-GB	Classification
en-US	Classification
it-IT	Classificazione

DOPIGP (`12`)

Code[30]

TableRelation: "EOS083 SIAN Tables".Code where("Table Type" = const(DOPIGP))

DOPIGP specifies DOP IGP Code

Language	Caption
en-GB	DOPIGP
en-US	DOPIGP
it-IT	DOPIGP

IGP % (`13`)

Decimal

IGP% specifies IGP percentual

Language	Caption
en-GB	IGP %
en-US	IGP %
it-IT	% IGP

E-Bacchus (`14`)

Code[30]

E-Bacchus specifies E-Bacchus Code

Language	Caption
en-GB	E_Bacchus
en-US	E_Bacchus
it-IT	E-Bacchus

Origin (`15`)

Code[30]

Origin specifies origin code

Language	Caption
de-DE	Herkunft
en-GB	Origin
en-US	Origin
it-IT	Provenienza

Grape Origin (`16`)

Code[3]

Grape Origin specifies origin of grape

Language	Caption
en-GB	Grape Origin
en-US	Grape Origin
it-IT	Origine Uve

Has Country Origins (`17`)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS083 SIAN Item Attr. Val." where("Primary Code" = field("Primary Product Code"), "Secondary Code" = field("Secondary Product Code"), "SIAN Table Type" = const("Countries of Origin")))

“Has Country Origins” specifies if exists country origins for current primary and secondary product into SIAN Item Attribute values

Language	Caption
en-GB	Has Country Origins
en-US	Has Country Origins
it-IT	Paese provenienza

Wine Growing Zone (`18`)

Code[30]

“Wine Growing Zone” specifies zone where wine was grown

Language	Caption
en-GB	Wine Growing Zone
en-US	Wine Growing Zone
it-IT	Zona viticola

Has Varieties (`19`)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS083 SIAN Item Attr. Val." where("Primary Code" = field("Primary Product Code"), "Secondary Code" = field("Secondary Product Code"), "SIAN Table Type" = const(Variety)))

Description for OnInsert.

Language	Caption
en-GB	Has Varieties
en-US	Has Varieties
it-IT	Varietà

Other Varieties (`20`)

Text[250]

“Has Varieties” specifies if exists varieties for current primary and secondary product into SIAN Item Attribute values

Language	Caption
en-GB	Other Varieties
en-US	Other Varieties
it-IT	Altre varietà

Subzone (`21`)

Code[30]

Subzone specifies subzone of wine growing zone

Language	Caption
en-GB	Subzone
en-US	Subzone
it-IT	Sottozona

Vineyard (`22`)

Code[30]

Vineyard specifies code of SIAN vineyard

Language	Caption
en-GB	Vineyard
en-US	Vineyard
it-IT	Vigna

Color (`23`)

Code[30]

Color specifies color of wine

Language	Caption
en-GB	Color
en-US	Color
it-IT	Colore

Has Mentions (`24`)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS083 SIAN Item Attr. Val." where("Primary Code" = field("Primary Product Code"), "Secondary Code" = field("Secondary Product Code"), "SIAN Table Type" = const(Mention)))

“Has Mentions” specifies if exists mentions for current primary and secondary product into SIAN Item Attribute values

Language	Caption
en-GB	Has Mentions
en-US	Has Mentions
it-IT	Menzioni Tradizionali

Biological (`25`)

Code[30]

Biological specifies if wine is biologic

Language	Caption
en-GB	Biological
en-US	Biological
it-IT	Biologico

Sugar Content (`26`)

Code[30]

“Sugar Content” specifies sugar content of wine

Language	Caption
en-GB	Sugar Content
en-US	Sugar Content
it-IT	Tenore zuccheri

Has Enological Practices (`27`)

Boolean

FieldClass: FlowField

“Has Enological Practices” specifies if exists Enological Practices for current primary and secondary product into SIAN Item Attribute values

Language	Caption
en-GB	Has Enological Practices
en-US	Has Enological Practices
it-IT	Pratica enologica

Enological Practices Method (`28`)

Code[30]

“Enological Practices Method” specifies if exists Enological Practice method for current primary and secondary product into SIAN Item Attribute values

Language	Caption
en-GB	Enological Practices Method
en-US	Enological Practices Method
it-IT	Metodo Pratiche Enologiche

Delivery Code (`29`)

Text[30]

“Delivery code” specifies code of delivery

Language	Caption
en-GB	Delivery Code
en-US	Delivery Code
it-IT	Codice partita

Year (`30`)

Integer

Year specifies year of wine

Language	Caption
de-DE	Jahrgang
en-GB	Year
en-US	Year
it-IT	Annata

Year Perc. (`31`)

Decimal

“Year Perc.” specifies which percent in year

Language	Caption
en-GB	Year Perc.
en-US	Year Perc.
it-IT	% Annata

Volumic Mass (`32`)

Decimal

“Volumic Mass” specifies volumic mass of wine

Language	Caption
en-GB	Volumic Mass
en-US	Volumic Mass
it-IT	Massa volumica

Potential Alc. Strength (`33`)

Decimal

“Potential Alc. Strength” specifies

Language	Caption
en-GB	Potential Alc. Strength
en-US	Potential Alc. Strength
it-IT	Titolo alcolometrico potenziale

Actual Alc. Strength (`34`)

Decimal

“Actual Alc. Strength” specifies actual alcoholic strength of wine

Language	Caption
en-GB	Actual Alc. Strength
en-US	Actual Alc. Strength
it-IT	Titolo alcolometrico effettivo

Total Alc. Strength (`35`)

Decimal

“Total Alc. Strength” specifies total alcoholic strength of wine

Language	Caption
en-GB	Total Alc. Strength
en-US	Total Alc. Strength
it-IT	Titolo alcolometrico totale

Physical State (`36`)

Code[30]

“Physical State” specifies physical state

Language	Caption
en-GB	Physical State
en-US	Physical State
it-IT	Stato fisico

DOP Cert. Date (`37`)

Date

“Dop Cert. Date” specifies date of DOP certificate

Language	Caption
en-GB	DOP Cert. Date
en-US	DOP Cert. Date
it-IT	Data Certificato DOP

DOP Cert. No. (`38`)

Text[250]

“DOP Cert. No.” specifies number of DOP certificate

Language	Caption
en-GB	DOP Cert. No.
en-US	DOP Cert. No.
it-IT	Numero Certificato DOP

Container (`39`)

Text[250]

Container specifies wine container

Language	Caption
de-DE	Container
en-GB	Container
en-US	Container
it-IT	Contenitore

Quantity (`40`)

Decimal

Quantity specifies quantity of product

Language	Caption
de-DE	Menge
en-GB	Quantity
en-US	Quantity
it-IT	Quantità

Quantity Lost (`41`)

Decimal

“Quantity Lost” specifies product quantity losted

Language	Caption
en-GB	Quantity Lost
en-US	Quantity Lost
it-IT	Quantità perdita

Nominal Volume (`42`)

Decimal

“Nominal Volume” specifies value of nominal volume

Language	Caption
en-GB	Nominal Volume
en-US	Nominal Volume
it-IT	Volume Nominale

Packages (`43`)

Integer

Packages specifies number of packages

Language	Caption
de-DE	Anzahl Packungen
en-GB	Packages
en-US	Packages
it-IT	Numero confezioni

Serial No. (`44`)

Text[250]

“Serial No.” specifies Serial number of product

Language	Caption
de-DE	Seriennr.
en-GB	Serial No.
en-US	Serial No.
it-IT	Numero di Serie

Initial Mark No. (`45`)

Text[250]

“Inital Mark no.”

Language	Caption
de-DE	Startnummer Markierungen
en-GB	Initial Mark No.
en-US	Initial Mark No.
it-IT	Numero inziale contrassegni

Final Mark No. (`46`)

Text[250]

“Final Mark no.”

Language	Caption
de-DE	Endnummer Markierungen
en-GB	Final Mark No.
en-US	Final Mark No.
it-IT	Numero finale contrassegni

Lot No. (`47`)

Text[250]

“Lot No.” specifies Lot Number of product

Language	Caption
de-DE	Chargennr.
en-GB	Lot No.
en-US	Lot No.
it-IT	Lotto di appartenenza

Aging Days (`48`)

Integer

“Aging days” of wine specifies aging days of wine

Language	Caption
en-GB	Aging Days
en-US	Aging Days
it-IT	Giorni di invecchiamento

Acidity Degree (`49`)

Decimal

“Acidity Degree” specifies acidity degree of wine

Language	Caption
en-GB	Acidity Degree
en-US	Acidity Degree
it-IT	Gradi acidità

Mount Degrees (`50`)

Decimal

“Mount Degree” specifies mount degree of wine

Language	Caption
en-GB	Mount Degrees
en-US	Mount Degrees
it-IT	Montegradi

Batch Code (`51`)

Text[30]

“Batch Code” specifies batch code of wine

Language	Caption
en-GB	Batch Code
en-US	Batch Code
it-IT	Codice partita

ICQRF Code (`52`)

Code[10]

TableRelation: "EOS083 SIAN ICQRF".Code

“ICQRF Code” specifies ICQRF code of operation line

Language	Caption
de-DE	ICQRF Code
en-GB	ICQRF Code
en-US	ICQRF Code
it-IT	Codice ICQRF

ICQRF Credential Code (`53`)

Code[10]

TableRelation: "EOS083 SIAN ICQRF Cred.".Code

“ICQRF Credential Code” specifies code of ICQRF Credential of operation line

Language	Caption
en-GB	ICQRF Credential Code
en-US	ICQRF Credential Code
it-IT	Codice credenziale ICQRF

Treatment (`54`)

Code[30]

TableRelation: "EOS083 SIAN Tables".Code where("Table Type" = const(Treatments))

“Treatment” specifies which type of treatment the wine was subjected to

Language	Caption
de-DE	Behandlung
en-GB	Treatment
en-US	Treatment
it-IT	Trattamento

Unit of Measure Code (`55`)

Code[30]

“Unit of Measure Code” specifies code of Unit of Measure

Language	Caption
de-DE	Einheitencode
en-GB	Unit of Measure Code
en-US	Unit of Measure Code
it-IT	Codice Unità di misura

Variant Code (`56`)

Code[10]

TableRelation: "Item Variant".Code where("Item No." = field("Item No."))

“Variant Code” specifies code of variant of product

Language	Caption
de-DE	Variantencode
en-GB	Variant Code
en-US	Variant Code
it-IT	Cod. variante

Primary Product Code (`57`)

Code[15]

“Primary Product Code” is first identifier for SIAN Product

Language	Caption
de-DE	Primärer Produktcode
en-GB	Primary Product Code
en-US	Primary Product Code
it-IT	Codice prodotto primario

Secondary Product Code (`58`)

Code[15]

“Secondary Product Code” is second identifier for SIAN Product

Language	Caption
de-DE	Sekundärer Produktcode
en-GB	Secondary Product Code
en-US	Secondary Product Code
it-IT	Codice prodotto secondario

Product Created (`59`)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS083 SIAN Subject Header" where("Subject Type" = const(Item), "Subject Code" = field("Primary Product Code"), "ICQRF Code" = field("ICQRF Code"), "ICQRF Credential Code" = field("ICQRF Credential Code")))

“Product Created” specifies if product has been created on SIAN Subject

Language	Caption
en-GB	Product Created
en-US	Product Created
it-IT	Prodotto creato

Product Accepted (`60`)

Boolean

FieldClass: FlowField

CalcFormula: lookup("EOS083 SIAN Subject Header".Accepted where("Subject Type" = const(Item), "Subject Code" = field("Primary Product Code"), "ICQRF Code" = field("ICQRF Code"), "ICQRF Credential Code" = field("ICQRF Credential Code")))

“Product Accepted” specifies if product has been accepted on SIAN Subject

Language	Caption
en-GB	Product Accepted
en-US	Product Accepted
it-IT	Prodotto accettato

DOP Certificate Due Date (`61`)

Date

Language	Caption
en-GB	DOP Certificate Due Date
en-US	DOP Certificate Due Date
it-IT	Data scadenza certificato DOP

Methods

CalcOperationQuantity

procedure CalcOperationQuantity()

Determine operation quantity

CreateAndOpenSIANProduct

procedure CreateAndOpenSIANProduct()

Create product from SIAN Subject header

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.

EOS Labs - 21.11.2024

Table 70094429 EOS083 SIAN Operation Line

Fields

Entry No. (1)

SIAN Operation Entry No. (2)

Product Number (3)

Item No. (4)

Item Category Code (5)

Wine Type (6)

Operation Type (7)

SIAN Item Attribute Code (8)

Category (9)

Act Certification (10)

Classification (11)

DOPIGP (12)

IGP % (13)

E-Bacchus (14)

Origin (15)

Grape Origin (16)

Has Country Origins (17)

Wine Growing Zone (18)

Has Varieties (19)

Other Varieties (20)

Subzone (21)

Vineyard (22)

Color (23)

Has Mentions (24)

Biological (25)

Sugar Content (26)

Has Enological Practices (27)

Enological Practices Method (28)

Delivery Code (29)

Year (30)

Year Perc. (31)

Volumic Mass (32)

Potential Alc. Strength (33)

Actual Alc. Strength (34)

Total Alc. Strength (35)

Physical State (36)

DOP Cert. Date (37)

DOP Cert. No. (38)

Container (39)

Quantity (40)

Quantity Lost (41)

Nominal Volume (42)

Packages (43)

Serial No. (44)

Initial Mark No. (45)

Final Mark No. (46)

Lot No. (47)

Aging Days (48)

Acidity Degree (49)

Mount Degrees (50)

Batch Code (51)

ICQRF Code (52)

ICQRF Credential Code (53)

Treatment (54)

Unit of Measure Code (55)

Variant Code (56)

Primary Product Code (57)

Secondary Product Code (58)

Product Created (59)

Product Accepted (60)

DOP Certificate Due Date (61)

Methods

CalcOperationQuantity

CreateAndOpenSIANProduct

Feedback

Entry No. (`1`)

SIAN Operation Entry No. (`2`)

Product Number (`3`)

Item No. (`4`)

Item Category Code (`5`)

Wine Type (`6`)

Operation Type (`7`)

SIAN Item Attribute Code (`8`)

Category (`9`)

Act Certification (`10`)

Classification (`11`)

DOPIGP (`12`)

IGP % (`13`)

E-Bacchus (`14`)

Origin (`15`)

Grape Origin (`16`)

Has Country Origins (`17`)

Wine Growing Zone (`18`)

Has Varieties (`19`)

Other Varieties (`20`)

Subzone (`21`)

Vineyard (`22`)

Color (`23`)

Has Mentions (`24`)

Biological (`25`)

Sugar Content (`26`)

Has Enological Practices (`27`)

Enological Practices Method (`28`)

Delivery Code (`29`)

Year (`30`)

Year Perc. (`31`)

Volumic Mass (`32`)

Potential Alc. Strength (`33`)

Actual Alc. Strength (`34`)

Total Alc. Strength (`35`)

Physical State (`36`)

DOP Cert. Date (`37`)

DOP Cert. No. (`38`)

Container (`39`)

Quantity (`40`)

Quantity Lost (`41`)

Nominal Volume (`42`)

Packages (`43`)

Serial No. (`44`)

Initial Mark No. (`45`)

Final Mark No. (`46`)

Lot No. (`47`)

Aging Days (`48`)

Acidity Degree (`49`)

Mount Degrees (`50`)

Batch Code (`51`)

ICQRF Code (`52`)

ICQRF Credential Code (`53`)

Treatment (`54`)

Unit of Measure Code (`55`)

Variant Code (`56`)

Primary Product Code (`57`)

Secondary Product Code (`58`)

Product Created (`59`)

Product Accepted (`60`)

DOP Certificate Due Date (`61`)