Table 70094427 EOS083 SIAN Subject Line

Table 70094427 EOS083 SIAN Subject Line

Table “EOS083 SIAN Subject Line” .

LanguageCaption
en-GBSIAN Subject Line
en-USSIAN Subject Line
it-ITRighe Soggetti 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

Line No. (2)

Integer

“Line No.” specifies line number, compose part of primary key

LanguageCaption
de-DEZeilennr.
en-GBLine No.
en-USLine No.
it-ITNr. riga

SIAN Item Attribute Code (3)

Code[20]

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

“SIAN Item Attribute Code” contains code of SIAN Item attribute

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

Subject Code (4)

Code[30]

“Subject Code” specifies code of SIAN Subject

LanguageCaption
de-DESubjektcode
en-GBSubject Code
en-USSubject Code
it-ITCodice soggetto

Physical Person (5)

Text[16]

“Physical Person” specifies Physical Person to which it refers

LanguageCaption
en-GBPhysical Person
en-USPhysical Person
it-ITPersona fisica

Text[11]

“Legal Person” specifies Legal Person to which it refers

LanguageCaption
en-GBLegal Person
en-USLegal Person
it-ITPersona legale

Subject Type (7)

enum "EOS083 Subject Type Line"

“Subject Type” specifies line Subject Type

LanguageCaption
de-DESubjekttyp
en-GBSubject Type
en-USSubject Type
it-ITTipo Soggetto

Firstname (8)

Text[50]

Firstname contains the first name of Subject

LanguageCaption
en-GBFirstname
en-USFirstname
it-ITNome

Surname (9)

Text[50]

Surname contains the surname of Subject

LanguageCaption
de-DENachname
en-GBSurname
en-USSurname
it-ITCognome

Company Name (10)

Text[150]

“Company Name” contains name of company

LanguageCaption
de-DEMandantenname
en-GBCompany Name
en-USCompany Name
it-ITNome società

Postal Code (11)

Text[5]

“Postal Code” contains postal code of the subject residence

LanguageCaption
en-GBPostal Code
en-USPostal Code
it-ITCAP

Address (12)

Text[250]

Address specifies the address of the subject residence

LanguageCaption
de-DEAdresse
en-GBAddress
en-USAddress
it-ITIndirizzo

Province (13)

Text[3]

Province specifies the province of the subject residence

LanguageCaption
en-GBProvince
en-USProvince
it-ITProvincia

City (14)

Text[3]

City specifies the province of the subject residence

LanguageCaption
de-DEOrt
en-GBCity
en-USCity
it-ITCittà

Country (15)

Text[3]

Country specifies the Country of the subject residence

LanguageCaption
de-DELand
en-GBCountry
en-USCountry
it-ITPaese

Vase Code (16)

Code[30]

“Vase Code” specifies the code of SIAN vase

LanguageCaption
en-GBVase Code
en-USVase Code
it-ITCodice Vasca

Vase Type (17)

Code[30]

“Vase Type” specifies the type of SIAN vase

LanguageCaption
en-GBVase Type
en-USVase Type
it-ITTipo Vasca

Vase Description (18)

Text[200]

“Vase Description” specifies the description of SIAN vase

LanguageCaption
en-GBVase Description
en-USVase Description
it-ITDescrizione Vasca

Vase Volume (19)

Decimal

“Vase Volume” specifies the volume of SIAN vase

LanguageCaption
en-GBVase Volume
en-USVase Volume
it-ITVolume HL Vasca

Vineyard Code (20)

Code[30]

“Vineyard Code” specifies code of SIAN vineyard

LanguageCaption
en-GBVineyard Code
en-USVineyard Code
it-ITCodice vigna

Vineyard Description (21)

Text[200]

“Vineyard Description” specifies description of SIAN vineyard

LanguageCaption
en-GBVineyard Description
en-USVineyard Description
it-ITDescrizione vigna

Item Attribute Code (22)

Code[30]

TableRelation: "EOS083 SIAN Item Attributes"

“Item Attribute Code” specifies code of Item Attribute

LanguageCaption
de-DEArtikeleigenschaftencode
en-GBItem Attribute Code
en-USItem Attribute Code
it-ITCodice attributi articolo

Category (23)

Code[30]

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

Category specifies the category of item attribute

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

Act Certification (24)

Code[30]

“Act certification” specifies the act certification

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

Classification (25)

Code[30]

Classification specifies the classification of item attribute

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

DOPIGP (26)

Code[30]

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

DOPIGP specifies code of DOP IGP

LanguageCaption
en-GBDOPIGP
en-USDOPIGP
it-ITDOPIGP

E-Bacchus (27)

Code[30]

E-Bacchus specifies code of E-Bacchus

LanguageCaption
en-GBE-Bacchus
en-USE-Bacchus
it-ITE-Bacchus

Origin (28)

Code[30]

Origin specifies the origin of item attribute

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

Grape Origin (29)

Code[3]

Grape Origin specifies the origin of grape

LanguageCaption
en-GBGrape Origin
en-USGrape Origin
it-ITOrigine Uve

Has Country Origins (30)

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 (31)

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 (32)

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

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

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

Other Varieties (33)

Text[250]

“Other Varieties” specifies other different varieties different between variety

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

Subzone (34)

Code[30]

Subzone specifies subzone of wine growing zone

LanguageCaption
en-GBSubzone
en-USSubzone
it-ITSottozona

Vineyard (35)

Code[30]

Vineyard specifies code of SIAN vineyard

LanguageCaption
en-GBVineyard
en-USVineyard
it-ITVigna

Color (36)

Code[30]

Color specifies color of wine

LanguageCaption
en-GBColor
en-USColor
it-ITColore

Has Mentions (37)

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 (38)

Code[30]

Biological specifies if wine is biologic

LanguageCaption
en-GBBiological
en-USBiological
it-ITBiologico

Sugar Content (39)

Code[30]

“Sugar Content” specifies sugar content of wine

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

Has Enological Practices (40)

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 (41)

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

Year (42)

Integer

Year specifies year of wine

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

Year Perc. (43)

Decimal

“Year Perc.” specifies which percent in year

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

Volumic Mass (44)

Decimal

“Volumic Mass” specifies volumic mass of wine

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

Physical State (45)

Code[30]

“Physical State” specifies physical state of wine

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

DOP Cert. Date (46)

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. (47)

Text[250]

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

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

Delivery Code (48)

Text[30]

“Delivery code” specifies code of delivery

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

Primary Product Code (49)

Text[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 (50)

Text[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

DOP Due Date (51)

Date

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

EOS Labs -