Table 70094429 EOS083 SIAN Operation Line

Table 70094429 EOS083 SIAN Operation Line

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

LanguageCaption
en-GBSIAN Operation Line
en-USSIAN Operation Line
it-ITRighe operazioni SIAN

Fields

Entry No. (1)

Integer

“Entry No.” compose part of primary key

LanguageCaption
de-DELfd. Nr.
en-GBEntry No.
en-USEntry No.
it-ITNr. movimento

SIAN Operation Entry No. (2)

Integer

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

LanguageCaption
de-DESIAN Operation Lfd. Nr.
en-GBSIAN Operation Entry No.
en-USSIAN Operation Entry No.
it-ITNr. movimento Operazione SIAN

Product Number (3)

Integer

“Product Number” specifies number of product

LanguageCaption
de-DEProduktnummer
en-GBProduct Number
en-USProduct Number
it-ITNumero Prodotto

Item No. (4)

Code[20]

TableRelation: Item."No."

“Item No.” specifies number of item

LanguageCaption
de-DEArtikelnr.
en-GBItem No.
en-USItem No.
it-ITNr. Articolo

Item Category Code (5)

Code[10]

“Item Category Code” specifies code of item category

LanguageCaption
de-DEArtikelkategoriencode
en-GBItem Category Code
en-USItem Category Code
it-ITCodice categoria articolo

Wine Type (6)

Enum "EOS EX080 Wine Type"

“Wine Type” specifies type of wine

LanguageCaption
de-DEWeinart
en-GBWine Type
en-USWine Type
it-ITTipo Vino

Operation Type (7)

enum "EOS083 Operation Type"

“Opeartion Type” specifies type of operation

LanguageCaption
de-DEOperationstyp
en-GBOperation Type
en-USOperation Type
it-ITTipo 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

LanguageCaption
de-DESIAN Artikeleigenschaftencode
en-GBSIAN Item Attribute Code
en-USSIAN Item Attribute Code
it-ITCodice attributi articoli SIAN

Category (9)

Code[30]

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

Category specifies SIAN Category

LanguageCaption
de-DEKategorie
en-GBCategory
en-USCategory
it-ITCategoria

Act Certification (10)

Code[30]

“Act Certification” specifies SIAN Act Certification

LanguageCaption
en-GBAct Certification
en-USAct Certification
it-ITAtto/certificato

Classification (11)

Code[30]

Classification specifies SIAN classification

LanguageCaption
de-DEKlassifizierung
en-GBClassification
en-USClassification
it-ITClassificazione

DOPIGP (12)

Code[30]

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

DOPIGP specifies DOP IGP Code

LanguageCaption
en-GBDOPIGP
en-USDOPIGP
it-ITDOPIGP

IGP % (13)

Decimal

IGP% specifies IGP percentual

LanguageCaption
en-GBIGP %
en-USIGP %
it-IT% IGP

E-Bacchus (14)

Code[30]

E-Bacchus specifies E-Bacchus Code

LanguageCaption
en-GBE_Bacchus
en-USE_Bacchus
it-ITE-Bacchus

Origin (15)

Code[30]

Origin specifies origin code

LanguageCaption
de-DEHerkunft
en-GBOrigin
en-USOrigin
it-ITProvenienza

Grape Origin (16)

Code[3]

Grape Origin specifies origin of grape

LanguageCaption
en-GBGrape Origin
en-USGrape Origin
it-ITOrigine 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

LanguageCaption
en-GBHas Country Origins
en-USHas Country Origins
it-ITPaese provenienza

Wine Growing Zone (18)

Code[30]

“Wine Growing Zone” specifies zone where wine was grown

LanguageCaption
en-GBWine Growing Zone
en-USWine Growing Zone
it-ITZona 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.

LanguageCaption
en-GBHas Varieties
en-USHas Varieties
it-ITVarietà

Other Varieties (20)

Text[250]

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

LanguageCaption
en-GBOther Varieties
en-USOther Varieties
it-ITAltre varietà

Subzone (21)

Code[30]

Subzone specifies subzone of wine growing zone

LanguageCaption
en-GBSubzone
en-USSubzone
it-ITSottozona

Vineyard (22)

Code[30]

Vineyard specifies code of SIAN vineyard

LanguageCaption
en-GBVineyard
en-USVineyard
it-ITVigna

Color (23)

Code[30]

Color specifies color of wine

LanguageCaption
en-GBColor
en-USColor
it-ITColore

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

LanguageCaption
en-GBHas Mentions
en-USHas Mentions
it-ITMenzioni Tradizionali

Biological (25)

Code[30]

Biological specifies if wine is biologic

LanguageCaption
en-GBBiological
en-USBiological
it-ITBiologico

Sugar Content (26)

Code[30]

“Sugar Content” specifies sugar content of wine

LanguageCaption
en-GBSugar Content
en-USSugar Content
it-ITTenore zuccheri

Has Enological Practices (27)

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("Enological Practices")))

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

LanguageCaption
en-GBHas Enological Practices
en-USHas Enological Practices
it-ITPratica 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

LanguageCaption
en-GBEnological Practices Method
en-USEnological Practices Method
it-ITMetodo Pratiche Enologiche

Delivery Code (29)

Text[30]

“Delivery code” specifies code of delivery

LanguageCaption
en-GBDelivery Code
en-USDelivery Code
it-ITCodice partita

Year (30)

Integer

Year specifies year of wine

LanguageCaption
de-DEJahrgang
en-GBYear
en-USYear
it-ITAnnata

Year Perc. (31)

Decimal

“Year Perc.” specifies which percent in year

LanguageCaption
en-GBYear Perc.
en-USYear Perc.
it-IT% Annata

Volumic Mass (32)

Decimal

“Volumic Mass” specifies volumic mass of wine

LanguageCaption
en-GBVolumic Mass
en-USVolumic Mass
it-ITMassa volumica

Potential Alc. Strength (33)

Decimal

“Potential Alc. Strength” specifies

LanguageCaption
en-GBPotential Alc. Strength
en-USPotential Alc. Strength
it-ITTitolo alcolometrico potenziale

Actual Alc. Strength (34)

Decimal

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

LanguageCaption
en-GBActual Alc. Strength
en-USActual Alc. Strength
it-ITTitolo alcolometrico effettivo

Total Alc. Strength (35)

Decimal

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

LanguageCaption
en-GBTotal Alc. Strength
en-USTotal Alc. Strength
it-ITTitolo alcolometrico totale

Physical State (36)

Code[30]

“Physical State” specifies physical state

LanguageCaption
en-GBPhysical State
en-USPhysical State
it-ITStato fisico

DOP Cert. Date (37)

Date

“Dop Cert. Date” specifies date of DOP certificate

LanguageCaption
en-GBDOP Cert. Date
en-USDOP Cert. Date
it-ITData Certificato DOP

DOP Cert. No. (38)

Text[250]

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

LanguageCaption
en-GBDOP Cert. No.
en-USDOP Cert. No.
it-ITNumero Certificato DOP

Container (39)

Text[250]

Container specifies wine container

LanguageCaption
de-DEContainer
en-GBContainer
en-USContainer
it-ITContenitore

Quantity (40)

Decimal

Quantity specifies quantity of product

LanguageCaption
de-DEMenge
en-GBQuantity
en-USQuantity
it-ITQuantità

Quantity Lost (41)

Decimal

“Quantity Lost” specifies product quantity losted

LanguageCaption
en-GBQuantity Lost
en-USQuantity Lost
it-ITQuantità perdita

Nominal Volume (42)

Decimal

“Nominal Volume” specifies value of nominal volume

LanguageCaption
en-GBNominal Volume
en-USNominal Volume
it-ITVolume Nominale

Packages (43)

Integer

Packages specifies number of packages

LanguageCaption
de-DEAnzahl Packungen
en-GBPackages
en-USPackages
it-ITNumero confezioni

Serial No. (44)

Text[250]

“Serial No.” specifies Serial number of product

LanguageCaption
de-DESeriennr.
en-GBSerial No.
en-USSerial No.
it-ITNumero di Serie

Initial Mark No. (45)

Text[250]

“Inital Mark no.”

LanguageCaption
de-DEStartnummer Markierungen
en-GBInitial Mark No.
en-USInitial Mark No.
it-ITNumero inziale contrassegni

Final Mark No. (46)

Text[250]

“Final Mark no.”

LanguageCaption
de-DEEndnummer Markierungen
en-GBFinal Mark No.
en-USFinal Mark No.
it-ITNumero finale contrassegni

Lot No. (47)

Text[250]

“Lot No.” specifies Lot Number of product

LanguageCaption
de-DEChargennr.
en-GBLot No.
en-USLot No.
it-ITLotto di appartenenza

Aging Days (48)

Integer

“Aging days” of wine specifies aging days of wine

LanguageCaption
en-GBAging Days
en-USAging Days
it-ITGiorni di invecchiamento

Acidity Degree (49)

Decimal

“Acidity Degree” specifies acidity degree of wine

LanguageCaption
en-GBAcidity Degree
en-USAcidity Degree
it-ITGradi acidità

Mount Degrees (50)

Decimal

“Mount Degree” specifies mount degree of wine

LanguageCaption
en-GBMount Degrees
en-USMount Degrees
it-ITMontegradi

Batch Code (51)

Text[30]

“Batch Code” specifies batch code of wine

LanguageCaption
en-GBBatch Code
en-USBatch Code
it-ITCodice partita

ICQRF Code (52)

Code[10]

TableRelation: "EOS083 SIAN ICQRF".Code

“ICQRF Code” specifies ICQRF code of operation line

LanguageCaption
de-DEICQRF Code
en-GBICQRF Code
en-USICQRF Code
it-ITCodice ICQRF

ICQRF Credential Code (53)

Code[10]

TableRelation: "EOS083 SIAN ICQRF Cred.".Code

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

LanguageCaption
en-GBICQRF Credential Code
en-USICQRF Credential Code
it-ITCodice 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

LanguageCaption
de-DEBehandlung
en-GBTreatment
en-USTreatment
it-ITTrattamento

Unit of Measure Code (55)

Code[30]

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

LanguageCaption
de-DEEinheitencode
en-GBUnit of Measure Code
en-USUnit of Measure Code
it-ITCodice 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

LanguageCaption
de-DEVariantencode
en-GBVariant Code
en-USVariant Code
it-ITCod. variante

Primary Product Code (57)

Code[15]

“Primary Product Code” is first identifier for SIAN Product

LanguageCaption
de-DEPrimärer Produktcode
en-GBPrimary Product Code
en-USPrimary Product Code
it-ITCodice prodotto primario

Secondary Product Code (58)

Code[15]

“Secondary Product Code” is second identifier for SIAN Product

LanguageCaption
de-DESekundärer Produktcode
en-GBSecondary Product Code
en-USSecondary Product Code
it-ITCodice 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

LanguageCaption
en-GBProduct Created
en-USProduct Created
it-ITProdotto 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

LanguageCaption
en-GBProduct Accepted
en-USProduct Accepted
it-ITProdotto accettato

DOP Certificate Due Date (61)

Date

LanguageCaption
en-GBDOP Certificate Due Date
en-USDOP Certificate Due Date
it-ITData scadenza certificato DOP

Methods

CalcOperationQuantity

procedure CalcOperationQuantity()

Determine operation quantity

CreateAndOpenSIANProduct

procedure CreateAndOpenSIANProduct()

Create product from SIAN Subject header


EOS Labs -