Table 70094424 EOS083 SIAN Item Attributes

Table 70094424 EOS083 SIAN Item Attributes

Table “EOS083 SIAN Item Attributes” contains info about SIAN Item Attributes

Language	Caption
en-GB	SIAN Item Attributes
en-US	SIAN Item Attributes
it-IT	Attributi articolo SIAN

Fields

Primary Code (`1`)

Code[15]

“Primary Code” specifies first code that compose primary key

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

Secondary Code (`2`)

Code[15]

“Secondary Code” specifies second code that compose primary key

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

Item No. (`3`)

Code[20]

TableRelation: Item."No."

“Item No.” contains the item which attributes refers

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

Blocked (`4`)

Boolean

Blocked specifies if this item attributes is blocked

Language	Caption
de-DE	Gesperrt
en-GB	Blocked
en-US	Blocked
it-IT	Bloccato

SIAN Category (`5`)

Code[20]

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

“SIAN Category” contains SIAN Category of item attributes

Language	Caption
en-GB	SIAN Category
en-US	SIAN Category
it-IT	Categoria

SIAN Wine Growing Zone (`6`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const("Wine Growing Zone"))

“SIAN Wine Growing Zone” specifies SIAN Zone where wine was grown

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

SIAN Classification (`7`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const(Classification))

“SIAN Classification” specifies SIAN Classfication of Item Attributes

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

SIAN Color (`8`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const(Color))

“SIAN Color” specifies SIAN Color of wine

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

SIAN Origin (`9`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const(Origin))

“SIAN Origin” specifies SIAN origin of wine

Language	Caption
en-GB	SIAN Origin
en-US	SIAN Origin
it-IT	Origine

SIAN Physical State (`10`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const("Physical State"))

“SIAN Physical State” specifies SIAN Physical State of wine

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

SIAN E-Bacchus (`11`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const("E-Bacchus"))

“SIAN E-Bacchus” contains E-bacchus code of wine

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

SIAN Organic (`12`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const(Organic))

“SIAN Organic” specifies if wine is organic

Language	Caption
en-GB	SIAN Organic
en-US	SIAN Organic
it-IT	Biologico

SIAN Act Certification (`13`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const("Act Certification"))

“SIAN Act Certification” specifies SIAN Act Certification

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

SIAN Subzone (`14`)

Code[20]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const(Subzone))

“SIAN Subzone” specifies code of Act certification

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

SIAN DOPIGP (`15`)

Code[20]

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

“SIAN DOPIGP” contains SIAN DOPIGP code

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

DOP Cert. Date (`16`)

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. (`17`)

Text[250]

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

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

Year (`18`)

Integer

Year specifies the year of wine

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

SIAN Grapes Origin (`19`)

Code[3]

TableRelation: "EOS083 SIAN Tables".code where("Table Type" = const("Countries of Origin"))

“SIAN Grapes Origin” specifies the origin of grapes with the wine was made

Language	Caption
en-GB	SIAN Grapes Origin
en-US	SIAN Grapes Origin
it-IT	Origine Uve

SIAN Mass (`20`)

Decimal

“SIAN Mass” specifies Mass of wine

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

SIAN Batch Code (`21`)

Text[30]

“SIAN Batch Code” specifies SIAN Batch Code

Language	Caption
en-GB	SIAN Batch Code
en-US	SIAN Batch Code
it-IT	Partita

SIAN Vineyard Code (`22`)

Code[30]

TableRelation: "EOS083 SIAN Vineyard".Code

“SIAN Vineyard Code” specifies SIAN code of Vineyard

Language	Caption
en-GB	SIAN Vineyard Code
en-US	SIAN Vineyard Code
it-IT	Codice Vigna

SIAN Subject (`23`)

Integer

FieldClass: FlowField

CalcFormula: lookup("EOS083 SIAN Subject Header"."Entry No." where("Subject Type" = const(Item), "Subject Code" = Field("Primary Code")))

“SIAN Subject” specifies code of SIAN subject

Language	Caption
de-DE	SIAN Subjekt
en-GB	SIAN Subject
en-US	SIAN Subject
it-IT	Soggetto SIAN

Present On Lot No. Info. (`24`)

Integer

FieldClass: FlowField

CalcFormula: Count("Lot No. Information" where("EOS EX080 SIAN Primary Code" = field("Primary Code"), "EOS EX080 SIAN Secondary Code" = field("Secondary Code")))

“Present On Lot No. Info.” specifies whether the item is present in the Lot No. Info.

Language	Caption
en-GB	Present On Lot No. Info.
en-US	Present On Lot No. Info.
it-IT	Presente in info nr. lotto

SIAN Mentions (`25`)

Boolean

FieldClass: FlowField

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

“SIAN Mentions” specifies if exist SIAN Mentions on correspond Item attribute values

Language	Caption
en-GB	SIAN Mentions
en-US	SIAN Mentions
it-IT	Menzioni tradizionali

SIAN Countries of Origin (`26`)

Boolean

FieldClass: FlowField

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

“SIAN Countries of Origin” specifies if exist SIAN Countries of Origin on correspond Item attribute values

Language	Caption
en-GB	SIAN Countries of Origin
en-US	SIAN Countries of Origin
it-IT	Paesi provenienza

SIAN Variety (`27`)

Boolean

FieldClass: FlowField

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

“SIAN Variety” specifies if exist SIAN Variety on correspond Item attribute values

Language	Caption
en-GB	SIAN Variety
en-US	SIAN Variety
it-IT	Varietà

SIAN Enological Practices (`28`)

Boolean

FieldClass: FlowField

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

“SIAN Enological Practices” specifies if exist SIAN Enological Practices on correspond Item attribute values

Language	Caption
en-GB	SIAN Enological Practices
en-US	SIAN Enological Practices
it-IT	(EWI) Pratiche enologiche SIAN

DOP Due Date (`29`)

Date

“DOP Due Date” specifies DOP Due Date

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

Description (`30`)

Text[100]

“Description” specifies attribute description

Language	Caption
de-DE	Beschreibung
en-GB	Description
en-US	Description
it-IT	Descrizione

Methods

SetLotNoInformation

procedure SetLotNoInformation(DOPCertDate: Date; DOPCertNo: Text[250])

Set certification date for item attributes

Parameters / Return Value

DOPCertDate Date
Parameter of type Date.
DOPCertNo Text[250]
Parameter of type Text[250].

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 - 02.07.2024

Table 70094424 EOS083 SIAN Item Attributes

Fields

Primary Code (1)

Secondary Code (2)

Item No. (3)

Blocked (4)

SIAN Category (5)

SIAN Wine Growing Zone (6)

SIAN Classification (7)

SIAN Color (8)

SIAN Origin (9)

SIAN Physical State (10)

SIAN E-Bacchus (11)

SIAN Organic (12)

SIAN Act Certification (13)

SIAN Subzone (14)

SIAN DOPIGP (15)

DOP Cert. Date (16)

DOP Cert. No. (17)

Year (18)

SIAN Grapes Origin (19)

SIAN Mass (20)

SIAN Batch Code (21)

SIAN Vineyard Code (22)

SIAN Subject (23)

Present On Lot No. Info. (24)

SIAN Mentions (25)

SIAN Countries of Origin (26)

SIAN Variety (27)

SIAN Enological Practices (28)

DOP Due Date (29)

Description (30)

Methods

SetLotNoInformation

Parameters / Return Value

Feedback

Primary Code (`1`)

Secondary Code (`2`)

Item No. (`3`)

Blocked (`4`)

SIAN Category (`5`)

SIAN Wine Growing Zone (`6`)

SIAN Classification (`7`)

SIAN Color (`8`)

SIAN Origin (`9`)

SIAN Physical State (`10`)

SIAN E-Bacchus (`11`)

SIAN Organic (`12`)

SIAN Act Certification (`13`)

SIAN Subzone (`14`)

SIAN DOPIGP (`15`)

DOP Cert. Date (`16`)

DOP Cert. No. (`17`)

Year (`18`)

SIAN Grapes Origin (`19`)

SIAN Mass (`20`)

SIAN Batch Code (`21`)

SIAN Vineyard Code (`22`)

SIAN Subject (`23`)

Present On Lot No. Info. (`24`)

SIAN Mentions (`25`)

SIAN Countries of Origin (`26`)

SIAN Variety (`27`)

SIAN Enological Practices (`28`)

DOP Due Date (`29`)

Description (`30`)