Table 18123250 EOS Purch. Request Line

Table 18123250 EOS Purch. Request Line

LanguageCaption
da-DKRekvisitionslinje
de-ATBestellvorschlagszeile
de-CHBestellvorschlagszeile
de-DEBestellvorschlagszeile
en-AURequest Line
en-CARequest Line
en-GBRequest Line
en-NZRequest Line
es-ESRequest Line
es-MXRequest Line
fr-BELigne demande achat
fr-CALigne demande achat
fr-CHLigne demande achat
fr-FRLigne demande achat
en-USRequest Line
it-CHRighe richiesta
it-ITRighe richiesta
nl-BEBehoefteregel
nl-NLBehoefteregel

Fields

EOS Purch. Requisition No. (1)

Code[20]

TableRelation: "EOS Purch. Request Header"."EOS No."

The number of the purchase request

LanguageCaption
da-DKKøb Anmodning Header
de-ATEinkaufsanfragennr.
de-CHEinkaufsanfragennr.
de-DEEinkaufsanfragennr.
en-AUPurch. Request No.
en-CAPurch. Request No.
en-GBPurch. Request No.
en-NZPurch. Request No.
es-ESCompr. Solicitud Nº
es-MXCompr. Solicitud Nº
fr-BEAch. Demande No.
fr-CAAch. Demande No.
fr-CHAch. Demande No.
fr-FRAch. Demande No.
en-USPurch. Request No.
it-CHNr. richiesta di acquisto
it-ITNr. richiesta di acquisto
nl-BEInkoop verzoek Header
nl-NLInkoop verzoek Header

EOS Line No. (3)

Integer

Line No. of the purchase request

LanguageCaption
da-DKLinjenr.
de-ATZeilennr.
de-CHZeilennr.
de-DEZeilennr.
en-AULine No.
en-CALine No.
en-GBLine No.
en-NZLine No.
es-ESLínea nº
es-MXLínea nº
fr-BEN° ligne
fr-CAN° ligne
fr-CHN° ligne
fr-FRN° ligne
en-USLine No.
it-CHNr. riga
it-ITNr. riga
nl-BERegelnr.
nl-NLRegelnr.

EOS Type (4)

Enum "EOS PRQ Line Type"

The Type of the purchase request line: it can be G/L Account or Item

LanguageCaption
da-DKType
de-ATArt
de-CHArt
de-DEArt
en-AUType
en-CAType
en-GBType
en-NZType
es-ESTipo
es-MXTipo
fr-BEType
fr-CAType
fr-CHType
fr-FRType
en-USType
it-CHTipo
it-ITTipo
nl-BESoort
nl-NLSoort

EOS No. (5)

Code[20]

TableRelation: if ("EOS Type" = const("G/L Account")) "G/L Account" else if ("EOS Type" = const(Item)) Item else if ("EOS Type" = const(Resource)) Resource else if ("EOS Type" = const("Fixed Asset")) "Fixed Asset"

The No. of the Item or G/L Account

LanguageCaption
da-DKNummer
de-ATNr.
de-CHNr.
de-DENr.
en-AUNo.
en-CANo.
en-GBNo.
en-NZNo.
es-ESNo.
es-MXNo.
fr-BEN°
fr-CAN°
fr-CHN°
fr-FRN°
en-USNo.
it-CHNr.
it-ITNr.
nl-BENr.
nl-NLNr.

EOS Description (6)

Text[100]

Description

LanguageCaption
da-DKBeskrivelse
de-ATBeschreibung
de-CHBeschreibung
de-DEBeschreibung
en-AUDescription
en-CADescription
en-GBDescription
en-NZDescription
es-ESDescripción
es-MXDescripción
fr-BEDescription
fr-CADescription
fr-CHDescription
fr-FRDescription
en-USDescription
it-CHDescrizione
it-ITDescrizione
nl-BEOmschrijving
nl-NLOmschrijving

EOS Description 2 (7)

Text[50]

Description 2

LanguageCaption
da-DKBeskrivelse 2
de-ATBeschreibung 2
de-CHBeschreibung 2
de-DEBeschreibung 2
en-AUDescription 2
en-CADescription 2
en-GBDescription 2
en-NZDescription 2
es-ESDescripción 2
es-MXDescripción 2
fr-BEDescription 2
fr-CADescription 2
fr-CHDescription 2
fr-FRDescription 2
en-USDescription 2
it-CHDescrizione 2
it-ITDescrizione 2
nl-BEOmschrijving 2
nl-NLOmschrijving 2

EOS Quantity (8)

Decimal

Quantity

LanguageCaption
da-DKAntal
de-ATMenge
de-CHMenge
de-DEMenge
en-AUQuantity
en-CAQuantity
en-GBQuantity
en-NZQuantity
es-ESCantidad
es-MXCantidad
fr-BEQuantité
fr-CAQuantité
fr-CHQuantité
fr-FRQuantité
en-USQuantity
it-CHQuantità
it-ITQuantità
nl-BEAantal
nl-NLAantal

EOS Vendor No. (9)

Code[20]

TableRelation: Vendor

The Vendor’s number

LanguageCaption
da-DKKreditornr.
de-ATKreditorennr.
de-CHKreditorennr.
de-DEKreditorennr.
en-AUVendor No.
en-CAVendor No.
en-GBVendor No.
en-NZVendor No.
es-ESProveedor No.
es-MXProveedor No.
fr-BEN° fournisseur
fr-CAN° fournisseur
fr-CHN° fournisseur
fr-FRN° fournisseur
en-USVendor No.
it-CHNr. fornitore
it-ITNr. fornitore
nl-BELeveranciersnr.
nl-NLLeveranciersnr.

EOS Direct Unit Cost (10)

Decimal

Direct Unit Cost

LanguageCaption
da-DKKøbspris
de-ATEK-Preis
de-CHEK-Preis
de-DEEK-Preis
en-AUDirect Unit Cost
en-CADirect Unit Cost
en-GBDirect Unit Cost
en-NZDirect Unit Cost
es-ESCosto unitario directo
es-MXCosto unitario directo
fr-BECoût unitaire direct
fr-CACoût unitaire direct
fr-CHCoût unitaire direct
fr-FRCoût unitaire direct
en-USDirect Unit Cost
it-CHCosto unitario diretto
it-ITCosto unitario diretto
nl-BEDirecte kostprijs
nl-NLDirecte kostprijs

EOS Due Date (12)

Date

Due Date (will be transferred to “Requested Receipt Date” in purchase line)

LanguageCaption
da-DKForfaldsdato
de-ATFälligkeitsdatum
de-CHFälligkeitsdatum
de-DEFälligkeitsdatum
en-AUDue Date
en-CADue Date
en-GBDue Date
en-NZDue Date
es-ESFecha de vencimiento
es-MXFecha de vencimiento
fr-BEDate d’échéance
fr-CADate d’échéance
fr-CHDate d’échéance
fr-FRDate d’échéance
en-USDue Date
it-CHData scadenza
it-ITData scadenza
nl-BEVervaldatum
nl-NLVervaldatum

EOS Requester ID (13)

Code[50]

TableRelation: User."User Name"

Requester ID

LanguageCaption
da-DKBestiller-id
de-ATBesteller-ID
de-CHBesteller-ID
de-DEBesteller-ID
en-AURequester ID
en-CARequester ID
en-GBRequester ID
en-NZRequester ID
es-ESsolicitante ID
es-MXsolicitante ID
fr-BEID demandeur
fr-CAID demandeur
fr-CHID demandeur
fr-FRID demandeur
en-USRequester ID
it-CHID richiedente
it-ITID richiedente
nl-BEAanvrager-id
nl-NLAanvrager-id

EOS Shortcut Dimension 1 Code (15)

Code[20]

TableRelation: "Dimension Value".Code where("Global Dimension No." = const(1))

Shortcut Dimension 1 Code

LanguageCaption
da-DKGenvejsdimension 1-kode
de-ATShortcutdimensionscode 1
de-CHShortcutdimensionscode 1
de-DEShortcutdimensionscode 1
en-AUShortcut Dimension 1 Code
en-CAShortcut Dimension 1 Code
en-GBShortcut Dimension 1 Code
en-NZShortcut Dimension 1 Code
es-ESDimensión de acceso directo 1 Código
es-MXDimensión de acceso directo 1 Código
fr-BECode raccourci axe 1
fr-CACode raccourci axe 1
fr-CHCode raccourci axe 1
fr-FRCode raccourci axe 1
en-USShortcut Dimension 1 Code
it-CHCod. colleg. dimen. 1
it-ITCod. colleg. dimen. 1
nl-BEShortcutdimensie 1
nl-NLShortcutdimensie 1

EOS Shortcut Dimension 2 Code (16)

Code[20]

TableRelation: "Dimension Value".Code where("Global Dimension No." = const(2))

Shortcut Dimension 2 Code

LanguageCaption
da-DKGenvejsdimension 2-kode
de-ATShortcutdimensionscode 2
de-CHShortcutdimensionscode 2
de-DEShortcutdimensionscode 2
en-AUShortcut Dimension 2 Code
en-CAShortcut Dimension 2 Code
en-GBShortcut Dimension 2 Code
en-NZShortcut Dimension 2 Code
es-ESDimensión de acceso directo 2 Código
es-MXDimensión de acceso directo 2 Código
fr-BECode raccourci axe 2
fr-CACode raccourci axe 2
fr-CHCode raccourci axe 2
fr-FRCode raccourci axe 2
en-USShortcut Dimension 2 Code
it-CHCod. colleg. dimen. 2
it-ITCod. colleg. dimen. 2
nl-BEShortcutdimensie 2
nl-NLShortcutdimensie 2

EOS Location Code (17)

Code[10]

TableRelation: Location where("Use As In-Transit" = const(false))

Location Code

LanguageCaption
da-DKLokationskode
de-ATLagerortcode
de-CHLagerortcode
de-DELagerortcode
en-AULocation Code
en-CALocation Code
en-GBLocation Code
en-NZLocation Code
es-ESCódigo de localización
es-MXCódigo de localización
fr-BECode magasin
fr-CACode magasin
fr-CHCode magasin
fr-FRCode magasin
en-USLocation Code
it-CHCod. ubicazione
it-ITCod. ubicazione
nl-BEVestiging
nl-NLVestiging

EOS Order Date (21)

Date

Order Date

LanguageCaption
da-DKOrdredato
de-ATAuftragsdatum
de-CHAuftragsdatum
de-DEAuftragsdatum
en-AUOrder Date
en-CAOrder Date
en-GBOrder Date
en-NZOrder Date
es-ESFecha de orden
es-MXFecha de orden
fr-BEDate commande
fr-CADate commande
fr-CHDate commande
fr-FRDate commande
en-USOrder Date
it-CHData ordine
it-ITData ordine
nl-BEOrderdatum
nl-NLOrderdatum

EOS Vendor Item No. (22)

Text[50]

Vendor Item No.

LanguageCaption
da-DKLeverandørs varenr.
de-ATKred.-Artikelnr.
de-CHKred.-Artikelnr.
de-DEKred.-Artikelnr.
en-AUVendor Item No.
en-CAVendor Item No.
en-GBVendor Item No.
en-NZVendor Item No.
es-ESArtículo Vendor No.
es-MXArtículo Vendor No.
fr-BERéférence fournisseur
fr-CARéférence fournisseur
fr-CHRéférence fournisseur
fr-FRRéférence fournisseur
en-USVendor Item No.
it-CHNr. articolo fornitore
it-ITNr. articolo fornitore
nl-BEArtikelnr. leverancier
nl-NLArtikelnr. leverancier

EOS Sales Order No. (23)

Code[20]

TableRelation: "Sales Header"."No." where("Document Type" = const(Order))

Sales Order No.

LanguageCaption
da-DKSalgsordrenr.
de-ATVerkaufsauftragsnr.
de-CHVerkaufsauftragsnr.
de-DEVerkaufsauftragsnr.
en-AUSales Order No.
en-CASales Order No.
en-GBSales Order No.
en-NZSales Order No.
es-ESOrden No. de venta
es-MXOrden No. de venta
fr-BEN° commande vente
fr-CAN° commande vente
fr-CHN° commande vente
fr-FRN° commande vente
en-USSales Order No.
it-CHNr. ordine di vendita
it-ITNr. ordine di vendita
nl-BEVerk.-ordernr.
nl-NLVerk.-ordernr.

EOS Sales Order Line No. (24)

Integer

Sales Order Line No.

LanguageCaption
da-DKSalgsordrelinjenr.
de-ATVerkaufsauftragszeilennr.
de-CHVerkaufsauftragszeilennr.
de-DEVerkaufsauftragszeilennr.
en-AUSales Order Line No.
en-CASales Order Line No.
en-GBSales Order Line No.
en-NZSales Order Line No.
es-ESNº de venta Línea de pedidos
es-MXNº de venta Línea de pedidos
fr-BEN° ligne commande vente
fr-CAN° ligne commande vente
fr-CHN° ligne commande vente
fr-FRN° ligne commande vente
en-USSales Order Line No.
it-CHNr. riga ordine vendita
it-ITNr. riga ordine vendita
nl-BEVerk.-orderregelnr.
nl-NLVerk.-orderregelnr.

EOS Sell-to Customer No. (25)

Code[20]

TableRelation: Customer

Sell to Customer No.

LanguageCaption
da-DKKundenr.
de-ATVerk. an Deb.-Nr.
de-CHVerk. an Deb.-Nr.
de-DEVerk. an Deb.-Nr.
en-AUSell-to Customer No.
en-CASell-to Customer No.
en-GBSell-to Customer No.
en-NZSell-to Customer No.
es-ESSell-a Número de cliente
es-MXSell-a Número de cliente
fr-BEN° donneur d’ordre
fr-CAN° donneur d’ordre
fr-CHN° donneur d’ordre
fr-FRN° donneur d’ordre
en-USSell-to Customer No.
it-CHVendere a - Nr. cliente
it-ITVendere a - Nr. cliente
nl-BEOrderklantnr.
nl-NLOrderklantnr.

EOS Ship-to Code (26)

Code[10]

TableRelation: "Ship-to Address".Code where("Customer No." = field("EOS Sell-to Customer No."))

Ship to Code

LanguageCaption
da-DKLeveringsadressekode
de-ATLief. an Code
de-CHLief. an Code
de-DELief. an Code
en-AUShip-to Code
en-CAShip-to Code
en-GBShip-to Code
en-NZShip-to Code
es-ESBuque-Código
es-MXBuque-Código
fr-BECode destinataire
fr-CACode destinataire
fr-CHCode destinataire
fr-FRCode destinataire
en-USShip-to Code
it-CHSpedire a - Codice
it-ITSpedire a - Codice
nl-BEVerzendcode
nl-NLVerzendcode

EOS Currency Code (29)

Code[10]

TableRelation: Currency

Currency Code

LanguageCaption
da-DKValutakode
de-ATWährungscode
de-CHWährungscode
de-DEWährungscode
en-AUCurrency Code
en-CACurrency Code
en-GBCurrency Code
en-NZCurrency Code
es-ESCódigo de moneda
es-MXCódigo de moneda
fr-BECode devise
fr-CACode devise
fr-CHCode devise
fr-FRCode devise
en-USCurrency Code
it-CHCod. valuta
it-ITCod. valuta
nl-BEValutacode
nl-NLValutacode

EOS Currency Factor (30)

Decimal

Currency Factor

LanguageCaption
da-DKValutafaktor
de-ATWährungsfaktor
de-CHWährungsfaktor
de-DEWährungsfaktor
en-AUCurrency Factor
en-CACurrency Factor
en-GBCurrency Factor
en-NZCurrency Factor
es-ESFactor de divisas
es-MXFactor de divisas
fr-BEFacteur devise
fr-CAFacteur devise
fr-CHFacteur devise
fr-FRFacteur devise
en-USCurrency Factor
it-CHFattore valuta
it-ITFattore valuta
nl-BEValutafactor
nl-NLValutafactor

Line Amount (40)

Decimal

LanguageCaption
da-DKLinjebeløb
de-ATZeilenbetrag
de-CHZeilenbetrag
de-DEZeilenbetrag
en-AULine Amount
en-CALine Amount
en-GBLine Amount
en-NZLine Amount
es-ESImporte de la línea
es-MXImporte de la línea
fr-BEMontant ligne
fr-CAMontant ligne
fr-CHMontant ligne
fr-FRMontant ligne
en-USLine Amount
it-CHImporto riga
it-ITImporto riga
nl-BERegelbedrag
nl-NLRegelbedrag

Line Amount (LCY) (41)

Decimal

LanguageCaption
da-DKLinjebeløb (RV)
de-ATZeilenbetrag (MW)
de-CHZeilenbetrag (MW)
de-DEZeilenbetrag (MW)
en-AULine Amount (LCY)
en-CALine Amount (LCY)
en-GBLine Amount (LCY)
en-NZLine Amount (LCY)
es-ESImporte de línea (LCY)
es-MXImporte de línea (LCY)
fr-BEMontant de ligne (LCY)
fr-CAMontant de ligne (LCY)
fr-CHMontant de ligne (LCY)
fr-FRMontant de ligne (LCY)
en-USLine Amount (LCY)
it-CHImporto riga (VL)
it-ITImporto riga (VL)
nl-BERegelbedrag (LCY)
nl-NLRegelbedrag (LCY)

EOS Record-ID (100)

Code[50]

Record-ID

LanguageCaption
da-DKRecord-id
de-ATDatensatz-ID
de-CHDatensatz-ID
de-DEDatensatz-ID
en-AURecord-ID
en-CARecord-ID
en-GBRecord-ID
en-NZRecord-ID
es-ESRecord-ID
es-MXRecord-ID
fr-BEID d’enregistrement
fr-CAID d’enregistrement
fr-CHID d’enregistrement
fr-FRID d’enregistrement
en-USRecord-ID
it-CHID Record
it-ITID Record
nl-BERecord-id
nl-NLRecord-id

EOS Dimension Set ID (480)

Integer

TableRelation: "Dimension Set Entry"

Dimension Set ID

LanguageCaption
da-DKDimensionsgruppe-id
de-ATDimensionssatz-ID
de-CHDimensionssatz-ID
de-DEDimensionssatz-ID
en-AUDimension Set ID
en-CADimension Set ID
en-GBDimension Set ID
en-NZDimension Set ID
es-ESDimensión Set ID
es-MXDimensión Set ID
fr-BEID ensemble de dimensions
fr-CAID ensemble de dimensions
fr-CHID ensemble de dimensions
fr-FRID ensemble de dimensions
en-USDimension Set ID
it-CHID set di dimensioni
it-ITID set di dimensioni
nl-BEDimensieset-id
nl-NLDimensieset-id

EOS Variant Code (5402)

Code[10]

TableRelation: if ("EOS Type" = const(Item)) "Item Variant".Code where("Item No." = field("EOS No."))

Variant Code

LanguageCaption
da-DKVariantkode
de-ATVariantencode
de-CHVariantencode
de-DEVariantencode
en-AUVariant Code
en-CAVariant Code
en-GBVariant Code
en-NZVariant Code
es-ESCódigo variante
es-MXCódigo variante
fr-BECode variante
fr-CACode variante
fr-CHCode variante
fr-FRCode variante
en-USVariant Code
it-CHCod. variante
it-ITCod. variante
nl-BEVariant
nl-NLVariant

EOS Qty. per Unit of Measure (5404)

Decimal

Quantity per Unit of Measure

LanguageCaption
da-DKAntal pr. enhed
de-ATMenge pro Einheit
de-CHMenge pro Einheit
de-DEMenge pro Einheit
en-AUQty. per Unit of Measure
en-CAQty. per Unit of Measure
en-GBQty. per Unit of Measure
en-NZQty. per Unit of Measure
es-ESCant. por unidad de medida
es-MXCant. por unidad de medida
fr-BEQuantité par unité
fr-CAQuantité par unité
fr-CHQuantité par unité
fr-FRQuantité par unité
en-USQty. per Unit of Measure
it-CHQtà per unità di misura
it-ITQtà per unità di misura
nl-BEAantal per eenheid
nl-NLAantal per eenheid

EOS Unit of Measure Code (5407)

Code[10]

TableRelation: if ("EOS Type" = const(Item)) "Item Unit of Measure".Code where("Item No." = field("EOS No.")) else "Unit of Measure"

Unit of Measure Code

LanguageCaption
da-DKEnhedskode
de-ATEinheitencode
de-CHEinheitencode
de-DEEinheitencode
en-AUUnit of Measure Code
en-CAUnit of Measure Code
en-GBUnit of Measure Code
en-NZUnit of Measure Code
es-ESUnidad de Medida Código
es-MXUnidad de Medida Código
fr-BECode unité
fr-CACode unité
fr-CHCode unité
fr-FRCode unité
en-USUnit of Measure Code
it-CHCod. unità di misura
it-ITCod. unità di misura
nl-BEEenheidscode
nl-NLEenheidscode

EOS Quantity (Base) (5408)

Decimal

Quantity (Base)

LanguageCaption
da-DKAntal (basis)
de-ATMenge (Basis)
de-CHMenge (Basis)
de-DEMenge (Basis)
en-AUQuantity (Base)
en-CAQuantity (Base)
en-GBQuantity (Base)
en-NZQuantity (Base)
es-ESCantidad (Base)
es-MXCantidad (Base)
fr-BEQuantité (base)
fr-CAQuantité (base)
fr-CHQuantité (base)
fr-FRQuantité (base)
en-USQuantity (Base)
it-CHQuantità (base)
it-ITQuantità (base)
nl-BEAantal (Basis)
nl-NLAantal (Basis)

EOS Original Item No. (5553)

Code[20]

TableRelation: Item

Original Item No.

LanguageCaption
da-DKOprindeligt varenr.
de-ATOriginalartikelnr.
de-CHOriginalartikelnr.
de-DEOriginalartikelnr.
en-AUOriginal Item No.
en-CAOriginal Item No.
en-GBOriginal Item No.
en-NZOriginal Item No.
es-ESArtículo original No.
es-MXArtículo original No.
fr-BEN° de l’article initial
fr-CAN° de l’article initial
fr-CHN° de l’article initial
fr-FRN° de l’article initial
en-USOriginal Item No.
it-CHNr. articolo originale
it-ITNr. articolo originale
nl-BEOorspronkelijk artikelnr.
nl-NLOorspronkelijk artikelnr.

EOS Original Variant Code (5554)

Code[10]

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

Original Variant Code

LanguageCaption
da-DKOprindelig variantkode
de-ATOriginalvariantencode
de-CHOriginalvariantencode
de-DEOriginalvariantencode
en-AUOriginal Variant Code
en-CAOriginal Variant Code
en-GBOriginal Variant Code
en-NZOriginal Variant Code
es-ESCódigo de versión original
es-MXCódigo de versión original
fr-BECode variante initial
fr-CACode variante initial
fr-CHCode variante initial
fr-FRCode variante initial
en-USOriginal Variant Code
it-CHCodice variante originale
it-ITCodice variante originale
nl-BEOorspronkelijke variant
nl-NLOorspronkelijke variant

EOS Level (5560)

Integer

Level

LanguageCaption
da-DKNiveau
de-ATEbene
de-CHEbene
de-DEEbene
en-AULevel
en-CALevel
en-GBLevel
en-NZLevel
es-ESNivel
es-MXNivel
fr-BENiveau
fr-CANiveau
fr-CHNiveau
fr-FRNiveau
en-USLevel
it-CHLivello
it-ITLivello
nl-BENiveau
nl-NLNiveau

EOS User ID (5590)

Code[50]

TableRelation: User."User Name"

User ID

LanguageCaption
da-DKBruger-id
de-ATBenutzer-ID
de-CHBenutzer-ID
de-DEBenutzer-ID
en-AUUser ID
en-CAUser ID
en-GBUser ID
en-NZUser ID
es-ESID de usuario
es-MXID de usuario
fr-BECode utilisateur
fr-CACode utilisateur
fr-CHCode utilisateur
fr-FRCode utilisateur
en-USUser ID
it-CHID utente
it-ITID utente
nl-BEGebruikers-id
nl-NLGebruikers-id

EOS Item Category Code (5701)

Code[20]

TableRelation: if ("EOS Type" = const(Item)) "Item Category"

Item Category Code

LanguageCaption
da-DKVarekategorikode
de-ATArtikelkategoriencode
de-CHArtikelkategoriencode
de-DEArtikelkategoriencode
en-AUItem Category Code
en-CAItem Category Code
en-GBItem Category Code
en-NZItem Category Code
es-ESArtículo Código de categoría
es-MXArtículo Código de categoría
fr-BECode catégorie article
fr-CACode catégorie article
fr-CHCode catégorie article
fr-FRCode catégorie article
en-USItem Category Code
it-CHCodice categoria articolo
it-ITCodice categoria articolo
nl-BEArtikelcategoriecode
nl-NLArtikelcategoriecode

EOS Purchasing Code (5703)

Code[10]

TableRelation: Purchasing

Purchasing Code

LanguageCaption
da-DKIndkøbskode
de-ATEinkaufscode
de-CHEinkaufscode
de-DEEinkaufscode
en-AUPurchasing Code
en-CAPurchasing Code
en-GBPurchasing Code
en-NZPurchasing Code
es-ESCódigo de compra
es-MXCódigo de compra
fr-BEcode des Achats
fr-CAcode des Achats
fr-CHcode des Achats
fr-FRcode des Achats
en-USPurchasing Code
it-CHCodice acquisto
it-ITCodice acquisto
nl-BEInkoopcode
nl-NLInkoopcode

EOS Line Discount % (7002)

Decimal

Line Discount %

LanguageCaption
da-DKLinjerabatpct.
de-ATZeilenrabatt %
de-CHZeilenrabatt %
de-DEZeilenrabatt %
en-AULine Discount %
en-CALine Discount %
en-GBLine Discount %
en-NZLine Discount %
es-ESLínea de Descuento %
es-MXLínea de Descuento %
fr-BE% remise ligne
fr-CA% remise ligne
fr-CH% remise ligne
fr-FR% remise ligne
en-USLine Discount %
it-CH% sconto riga
it-IT% sconto riga
nl-BERegelkorting %
nl-NLRegelkorting %

EOS Discount Text (7003)

Text[30]

Discount Text

LanguageCaption

EOS Status (9000)

Option

Open (0) , Completed (1) , Approved (2) , Close (3)

Status: it can be Open, Completed,Approved,Close

LanguageCaption

Status (9001)

Enum "EOS046 Status"

Status: it can be Open, Awaiting Approval,Approved,Close

LanguageCaption
da-DKStatus
de-ATStatus
de-CHStatus
de-DEStatus
en-AUStatus
en-CAStatus
en-GBStatus
en-NZStatus
es-ESEstado
es-MXEstado
fr-BEStatut
fr-CAStatut
fr-CHStatut
fr-FRStatut
en-USStatus
it-CHStato
it-ITStato
nl-BEStatus
nl-NLStatus

EOS Document Type (18004281)

Option

Quote (0) , "Order" (1) , Invoice (2) , "Credit Memo" (3) , "Blanket Order" (4) , "Return Order" (5)

Document Type it can be: Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order

LanguageCaption
da-DKBilagstype
de-ATBelegart
de-CHBelegart
de-DEBelegart
en-AUDocument Type
en-CADocument Type
en-GBDocument Type
en-NZDocument Type
es-ESTipo de Documento
es-MXTipo de Documento
fr-BEType document
fr-CAType document
fr-CHType document
fr-FRType document
en-USDocument Type
it-CHTipo di documento
it-ITTipo di documento
nl-BEDocumenttype
nl-NLDocumenttype

EOS Document No. (18004282)

Code[20]

TableRelation: "Purchase Header"."No." where("Document Type" = field("EOS Document Type"))

Document No.

LanguageCaption
da-DKBilagsnr.
de-ATBelegnr.
de-CHBelegnr.
de-DEBelegnr.
en-AUDocument No.
en-CADocument No.
en-GBDocument No.
en-NZDocument No.
es-ESDocumento núm.:
es-MXDocumento núm.:
fr-BEN° document
fr-CAN° document
fr-CHN° document
fr-FRN° document
en-USDocument No.
it-CHNr. documento
it-ITNr. documento
nl-BEDocumentnr.
nl-NLDocumentnr.

EOS Document Line No. (18004283)

Integer

TableRelation: "Purchase Line"."Line No." where("Document Type" = field("EOS Document Type"), "Document No." = field("EOS Document No."))

Document Line No.

LanguageCaption
da-DKDokumentlinjenr.
de-ATBelegzeilennr.
de-CHBelegzeilennr.
de-DEBelegzeilennr.
en-AUDocument Line No.
en-CADocument Line No.
en-GBDocument Line No.
en-NZDocument Line No.
es-ESNº documento Linea
es-MXNº documento Linea
fr-BEN° ligne document
fr-CAN° ligne document
fr-CHN° ligne document
fr-FRN° ligne document
en-USDocument Line No.
it-CHNr. riga documento
it-ITNr. riga documento
nl-BEDocumentregelnr.
nl-NLDocumentregelnr.

EOS Selected (18004284)

Boolean

Selected

LanguageCaption
da-DKMarkeret
de-ATAusgewählt
de-CHAusgewählt
de-DEAusgewählt
en-AUSelected
en-CASelected
en-GBSelected
en-NZSelected
es-ESSeleccionado
es-MXSeleccionado
fr-BESélectionné
fr-CASélectionné
fr-CHSélectionné
fr-FRSélectionné
en-USSelected
it-CHSelezionato
it-ITSelezionato
nl-BEGeselecteerd
nl-NLGeselecteerd

EOS Job No. (18004287)

Code[20]

TableRelation: Job

Job No.

LanguageCaption
da-DKSagsnr.
de-ATProjektnr.
de-CHProjektnr.
de-DEProjektnr.
en-AUProject No.
en-CAProject No.
en-GBProject No.
en-NZProject No.
es-ESTrabajo no.
es-MXTrabajo no.
fr-BEN° projet
fr-CAN° projet
fr-CHN° projet
fr-FRN° projet
en-USProject No.
it-CHNr. progetto
it-ITNr. progetto
nl-BEProjectnr.
nl-NLProjectnr.

EOS Job Task No. (18004288)

Code[20]

TableRelation: "Job Task"."Job Task No." where("Job No." = field("EOS Job No."))

LanguageCaption
da-DKSagsopgavenr.
de-ATProjektaufgabennr.
de-CHProjektaufgabennr.
de-DEProjektaufgabennr.
en-AUProject Task No.
en-CAProject Task No.
en-GBProject Task No.
en-NZProject Task No.
es-ESTarea de trabajo No.
es-MXTarea de trabajo No.
fr-BEN° tâche projet
fr-CAN° tâche projet
fr-CHN° tâche projet
fr-FRN° tâche projet
en-USProject Task No.
it-CHNr. attività di progetto
it-ITNr. attività di progetto
nl-BEProjecttaaknr.
nl-NLProjecttaaknr.

EOS Job Planning Line No. (18004289)

Integer

LanguageCaption
da-DKSagsplanlægningslinjenr.
de-ATProjektplanzeilennr.
de-CHProjektplanzeilennr.
de-DEProjektplanzeilennr.
en-AUProject Planning Line No.
en-CAProject Planning Line No.
en-GBProject Planning Line No.
en-NZProject Planning Line No.
es-ESLínea de planificación de trabajos No.
es-MXLínea de planificación de trabajos No.
fr-BEN° ligne planning projet
fr-CAN° ligne planning projet
fr-CHN° ligne planning projet
fr-FRN° ligne planning projet
en-USProject Planning Line No.
it-CHNr. riga pianificazione progetto
it-ITNr. riga pianificazione progetto
nl-BERegelnr. taakplanning
nl-NLRegelnr. taakplanning

EOS Job Line Type (18004290)

Option

" " (0) , Budget (1) , Billable (2) , "Both Budget and Billable" (3)

LanguageCaption
da-DKLinjetype for sag
de-ATProjektzeilenart
de-CHProjektzeilenart
de-DEProjektzeilenart
en-AUProject Line Type
en-CAProject Line Type
en-GBProject Line Type
en-NZProject Line Type
es-ESTipo de línea de trabajo
es-MXTipo de línea de trabajo
fr-BEType ligne projet
fr-CAType ligne projet
fr-CHType ligne projet
fr-FRType ligne projet
en-USProject Line Type
it-CHTipo riga progetto
it-ITTipo riga progetto
nl-BERegelsoort project
nl-NLRegelsoort project

Methods

FindNextLineNo

procedure FindNextLineNo(): Integer

Find a new line number

Parameters / Return Value

  • Returns Integer

    Integer: the new line No

CalcLineAmount

procedure CalcLineAmount(): Decimal

Parameters / Return Value

  • Returns Decimal

CreateDim

procedure CreateDim(Type1: Integer; No1: Code[20]; Type2: Integer; No2: Code[20])

Parameters / Return Value

  • Type1 Integer

  • No1 Code[20]

  • Type2 Integer

  • No2 Code[20]

ShowDimensions

procedure ShowDimensions()

Show Dimensions

ValidateShortcutDimCode

procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])

Validate Shortcut Dimension Code

Parameters / Return Value

  • FieldNumber Integer

    Integer: the field number

  • ShortcutDimCode Code[20]

    Code[20]: the shortcut code to validate

LookupShortcutDimCode

procedure LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])

Lookup Shortcut Dimension Code

Parameters / Return Value

  • FieldNumber Integer

    Integer

  • ShortcutDimCode Code[20]

    Code[20]

ShowShortcutDimCode

procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])

Show Shortcut Dimension Code

Parameters / Return Value

  • ShortcutDimCode Code[20]

    Code[20]

Events

OnBeforeCreateDim

local procedure OnBeforeCreateDim(Type1: Integer; No1: Code[20]; Type2: Integer; No2: Code[20]; var isHandled: Boolean)

Raised on before create Dim.

Parameters / Return Value

  • Type1 Integer

    Table ID

  • No1 Code[20]

    Value

  • Type2 Integer

    Table ID

  • No2 Code[20]

    Value

  • isHandled Boolean

    IsHandled parameter.

OnAfterCreateDimTableID

local procedure OnAfterCreateDimTableID(Rec: Record "EOS Purch. Request Line"; CurrFieldNo: Integer; var DimSource: List of [Dictionary of [Integer, Code[20]]])

Raised after the creation of the Array for dimensions.

Parameters / Return Value

  • Rec Record "EOS Purch. Request Line"

    Current Record.

  • CurrFieldNo Integer

    Current field No.

  • DimSource List[Dictionary]

    List of dimensions source.

OnAfterCreateDim

local procedure OnAfterCreateDim(Rec: Record "EOS Purch. Request Line"; CurrFieldNo: Integer)

Raised after the Creation of Dimension.

Parameters / Return Value

  • Rec Record "EOS Purch. Request Line"

    Current Record.

  • CurrFieldNo Integer

    Current field No.

OnBeforeShowDimensions

local procedure OnBeforeShowDimensions(Rec: Record "EOS Purch. Request Line"; xRec: Record "EOS Purch. Request Line"; var isHandled: Boolean)

Raised on before ShowDimension.

Parameters / Return Value

  • Rec Record "EOS Purch. Request Line"

    Current Record.

  • xRec Record "EOS Purch. Request Line"

    Current xRecord.

  • isHandled Boolean

    IsHandled parameter.

OnAfterShowDimensions

local procedure OnAfterShowDimensions(Rec: Record "EOS Purch. Request Line"; xRec: Record "EOS Purch. Request Line")

Raised on after ShowDimension.

Parameters / Return Value

  • Rec Record "EOS Purch. Request Line"

    Current Record.

  • xRec Record "EOS Purch. Request Line"

    Current xRecord.

OnBeforeValidateShortcutDimCode

local procedure OnBeforeValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]; var isHandled: Boolean)

Raised on before Validate Shortcut Dimension Code.

Parameters / Return Value

  • FieldNumber Integer

    Shortcut dimension code field No.

  • ShortcutDimCode Code[20]

    ShortcutDimCode value.

  • isHandled Boolean

    IsHandled parameter.

OnAfterValidateShortcutDimCode

local procedure OnAfterValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]; var Rec: Record "EOS Purch. Request Line")

Raised on after Validate Shortcut Dimension Code.

Parameters / Return Value

  • FieldNumber Integer

    Shortcut dimension code field No.

  • ShortcutDimCode Code[20]

    ShortcutDimCode value.

  • Rec Record "EOS Purch. Request Line"

    The current record

OnBeforeLookupShortcutDimCode

local procedure OnBeforeLookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]; var isHandled: Boolean)

Raised on before Lookup Shortcut Dimension Code.

Parameters / Return Value

  • FieldNumber Integer

    Shortcut dimension code field No.

  • ShortcutDimCode Code[20]

    ShortcutDimCode value.

  • isHandled Boolean

    IsHandled parameter.

OnAfterLookupShortcutDimCode

local procedure OnAfterLookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])

Raised on after lookup Shortcut Dimension Code.

Parameters / Return Value

  • FieldNumber Integer

    Shortcut dimension code field No.

  • ShortcutDimCode Code[20]

    ShortcutDimCode value.

OnBeforeShowShortcutDimCode

local procedure OnBeforeShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20]; var isHandled: Boolean)

Raised on before show Shortcut Dimension Code.

Parameters / Return Value

  • ShortcutDimCode Code[20]

    ShortcutDimCode array.

  • isHandled Boolean

    IsHandled parameter.

OnAfterShowShortcutDimCode

local procedure OnAfterShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])

Raised on after show Shortcut Dimension Code.

Parameters / Return Value

  • ShortcutDimCode Code[20]

    ShortcutDimCode array.

OnBeforeInitJobFields

local procedure OnBeforeInitJobFields(var PurchReqLine: Record "EOS Purch. Request Line"; var xPurchReqLine: Record "EOS Purch. Request Line"; var IsHandled: Boolean)

Raised before the code in InitJobFields is executed

Parameters / Return Value

  • PurchReqLine Record "EOS Purch. Request Line"

    Current record

  • xPurchReqLine Record "EOS Purch. Request Line"

    Previous version of the current record

  • IsHandled Boolean

    Set this to true to skip the business logic

OnBeforeGetDirectCost

local procedure OnBeforeGetDirectCost(var Rec: Record "EOS Purch. Request Line"; xRec: Record "EOS Purch. Request Line"; CalledByFieldNo: Integer; var isHandled: Boolean)

Parameters / Return Value

  • Rec Record "EOS Purch. Request Line"

  • xRec Record "EOS Purch. Request Line"

  • CalledByFieldNo Integer

  • isHandled Boolean

OnAfterFindReqLinePriceDiscOnBeforeDirectUnitCostValidate

local procedure OnAfterFindReqLinePriceDiscOnBeforeDirectUnitCostValidate(var ReqLine: Record "Requisition Line"; var Rec: Record "EOS Purch. Request Line"; xRec: Record "EOS Purch. Request Line"; CalledByFieldNo: Integer; var isHandled: Boolean)

Parameters / Return Value

  • ReqLine Record "Requisition Line"

  • Rec Record "EOS Purch. Request Line"

  • xRec Record "EOS Purch. Request Line"

  • CalledByFieldNo Integer

  • isHandled Boolean

OnBeforeCreateDim2

local procedure OnBeforeCreateDim2(var Rec: Record "EOS Purch. Request Line"; Type1: Integer; No1: Code[20]; Type2: Integer; No2: Code[20]; var isHandled: Boolean)

Parameters / Return Value

  • Rec Record "EOS Purch. Request Line"

  • Type1 Integer

  • No1 Code[20]

  • Type2 Integer

  • No2 Code[20]

  • isHandled Boolean

OnCreateDimOnBeforeAskDimChanged

local procedure OnCreateDimOnBeforeAskDimChanged(var Rec: Record "EOS Purch. Request Line"; Type1: Integer; No1: Code[20]; Type2: Integer; No2: Code[20]; var ChangeDimQst: Enum "EOS066 TriState Boolean")

Use this to bypass the confirm message whenever the dimensions have changed.

Parameters / Return Value

  • Rec Record "EOS Purch. Request Line"

    The current line

  • Type1 Integer

    Dim1

  • No1 Code[20]

    Dim1

  • Type2 Integer

    Dim2

  • No2 Code[20]

    Dim2

  • ChangeDimQst Enum "EOS066 TriState Boolean"

    Undefined: As defautl, True: Will change, False: Won’t change


EOS Labs -