Table 5137873 M365 Batch Quote Vendor Line

Table 5137873 M365 Batch Quote Vendor Line

LanguageCaption
de-DESerienanfrage Kreditorzeile
es-ESLínea de proveedores de oferta por lotes
en-USBatch Quote Vendor Line
it-CHRiga fornitore offerta batch
it-ITRiga fornitore offerta batch

Fields

Document No. (1)

Code[20]

TableRelation: "M365 Batch Quote Header"

LanguageCaption
de-DEBelegnr.
es-ESNo. Documento
en-USDocument No.
it-CHNr. documento
it-ITNr. documento

Item Line No. (2)

Integer

TableRelation: "M365 Batch Quote Item Line"."Line No." where("Document No." = field("Document No."), "Line No." = field("Item Line No."))

LanguageCaption
de-DEArtikelzeilennr.
es-ESNo. Producto Línea
en-USItem Line No.
it-CHNr. riga articolo
it-ITNr. riga articolo

Line No. (3)

Integer

LanguageCaption
de-DEZeilennr.
es-ESNo. Línea
en-USLine No.
it-CHNr. riga
it-ITNr. riga

Vendor No. (101)

Code[20]

TableRelation: Vendor

LanguageCaption
de-DEKreditorennr.
es-ESNo. Proveedor
en-USVendor No.
it-CHNr. fornitore
it-ITNr. fornitore

Name (110)

Text[100]

FieldClass: FlowField

CalcFormula: Lookup(Vendor.Name where("No." = field("Vendor No.")))

LanguageCaption
de-DEName
es-ESNombre
en-USName
it-CHNome
it-ITNome

Name 2 (115)

Text[50]

FieldClass: FlowField

CalcFormula: Lookup(Vendor."Name 2" where("No." = field("Vendor No.")))

LanguageCaption
de-DEName 2
es-ESNombre 2
en-USName 2
it-CHNome 2
it-ITNome 2

Address (120)

Text[100]

FieldClass: FlowField

CalcFormula: Lookup(Vendor.Address where("No." = field("Vendor No.")))

LanguageCaption
de-DEAdresse
es-ESDirección
en-USAddress
it-CHIndirizzo
it-ITIndirizzo

Address 2 (125)

Text[50]

FieldClass: FlowField

CalcFormula: Lookup(Vendor."Address 2" where("No." = field("Vendor No.")))

LanguageCaption
de-DEAdresse 2
es-ESDirección 2
en-USAddress 2
it-CHIndirizzo 2
it-ITIndirizzo 2

Post Code (130)

Code[20]

FieldClass: FlowField

CalcFormula: Lookup(Vendor."Post Code" where("No." = field("Vendor No.")))

LanguageCaption
de-DEPLZ-Code
es-ESCódigo Postal
en-USPost Code
it-CHCAP
it-ITCAP

City (135)

Text[30]

FieldClass: FlowField

CalcFormula: Lookup(Vendor.City where("No." = field("Vendor No.")))

TableRelation: if ("Country/Region Code" = const()) "Post Code".City else if ("Country/Region Code" = filter(<> '')) "Post Code".City where("Country/Region Code" = field("Country/Region Code"))

LanguageCaption
de-DEOrt
es-ESCiudad
en-USCity
it-CHCittà
it-ITCittà

County (137)

Text[30]

FieldClass: FlowField

CalcFormula: Lookup(Vendor.County where("No." = field("Vendor No.")))

LanguageCaption
de-DEBundesregion
es-ESCondado
en-USCounty
it-CHProvincia
it-ITProvincia

Country/Region Code (140)

Code[10]

FieldClass: FlowField

CalcFormula: Lookup(Vendor."Country/Region Code" where("No." = field("Vendor No.")))

TableRelation: "Country/Region"

LanguageCaption
de-DELänder-/Regionscode
es-ESCódigo de país/región
en-USCountry/Region Code
it-CHCod. paese
it-ITCod. paese

Contact (145)

Text[100]

FieldClass: FlowField

CalcFormula: Lookup(Vendor.Contact where("No." = field("Vendor No.")))

LanguageCaption
de-DEKontakt
es-ESContacto
en-USContact
it-CHContatto
it-ITContatto

Currency Code (150)

Code[10]

FieldClass: FlowField

CalcFormula: Lookup(Vendor."Currency Code" where("No." = field("Vendor No.")))

TableRelation: Currency

LanguageCaption
de-DEWährungscode
es-ESCódigo de divisa
en-USCurrency Code
it-CHCod. valuta
it-ITCod. valuta

Item Vendor Unit Cost (160)

Decimal

LanguageCaption
de-DEArtikellieferantenpreis
es-ESCosto unitario del proveedor del artículo
en-USItem Vendor Unit Cost
it-CHCosto unitario fornitore articolo
it-ITCosto unitario fornitore articolo

Document Type (1000)

Option

Quote (0) , "Order" (1)

LanguageCaption
de-DEBelegart
es-ESTipo de documento
en-USDocument Type
it-CHTipo di documento
it-ITTipo di documento

Methods

InsertItemVendorEntry

procedure InsertItemVendorEntry()

TestStatus

procedure TestStatus()

EOS Labs -