Table 18122511 EOS001 DTI Entry

Table 18122511 EOS001 DTI Entry

LanguageCaption
de-DEBelegfakt.-Posten
en-USDocument Invoice Entry
it-ITMov. doc. da fatturare

Fields

Entry No. (1)

Integer

LanguageCaption
de-DEEintrag Nr.
en-USEntry No.
it-ITNr. movimento

Sales/Purchase (2)

Option

" " (0) , Sales (1) , Purchase (2)

LanguageCaption
de-DEVerkauf/Einkauf
en-USSales/Purchase
it-ITVendite/Acquisti

Entry Type (3)

Option

"Shipment" (0) , "Invoice" (1) , "Settlement" (2)

LanguageCaption
de-DEPostenart
en-USEntry Type
it-ITTipo movimento

Expected (4)

Boolean

Indicates that this entry is expected. An expected entry is an entry that has not yet been posted and is not considered in reports.

LanguageCaption
de-DEErwartet
en-USExpected
it-ITPrevisto

Document No. (5)

Code[20]

LanguageCaption
de-DEDokument Nr.
en-USDocument No.
it-ITNr.. documento

Posting Date (6)

Date

LanguageCaption
de-DEBuchungsdatum
en-USPosting Date
it-ITData di registrazione

Document Type (10)

Integer

LanguageCaption
de-DEDokumenttyp
en-USDocument Type
it-ITTipo di documento

Document Line No. (11)

Integer

LanguageCaption
de-DEBelegzeile Nr.
en-USDocument Line No.
it-ITNr. riga documento

Type (15)

Option

" " (0) , "G/L Account" (1) , "Item" (2) , "Resource" (3) , "Fixed Asset" (4) , "Charge (Item)" (5)

LanguageCaption
de-DEArt
en-USType
it-ITTipo

No. (16)

Code[20]

LanguageCaption
de-DENr.
en-USNo.
it-ITNr.

Credit Document (17)

Boolean

LanguageCaption
de-DEStornobeleg
en-USCredit Document
it-ITDocumento storno

G/L Account No. (20)

Code[20]

TableRelation: "G/L Account"."No."

LanguageCaption
de-DESachkonto-Nr.
en-USG/L Account No.
it-ITNr. conto C/G

Description (25)

Text[100]

LanguageCaption
de-DEBeschreibung
en-USDescription
it-ITDescrizione

Description 2 (26)

Text[50]

LanguageCaption
de-DEBeschreibung 2
en-USDescription 2
it-ITDescrizione 2

Quantity (30)

Decimal

LanguageCaption
de-DEMenge
en-USQuantity
it-ITQuantità

Quantity (Base) (31)

Decimal

LanguageCaption
de-DEMenge (Basis)
en-USQuantity (Base)
it-ITQuantità (base)

Unit of Measure Code (32)

Code[10]

TableRelation: "Unit of Measure".Code

LanguageCaption
de-DEEinheitencode
en-USUnit of Measure Code
it-ITCod. unità di misura

Qty. Per Unit of Measure (33)

Decimal

LanguageCaption
de-DEMenge pro Einheit
en-USQty. Per Unit of Measure
it-ITQtà per unità di misura

Sell-to Cust./Vend. (40)

Code[20]

TableRelation: IF ("Sales/Purchase" = CONST(Sales)) Customer."No." ELSE IF ("Sales/Purchase" = CONST(Purchase)) Vendor."No."

LanguageCaption
de-DEVerk. an Debitor/Kreditor
en-USSell-to Cust./Vend.
it-ITVendere a cliente/fornitore

Bill-to Cust./Vend. (41)

Code[20]

TableRelation: IF ("Sales/Purchase" = CONST(Sales)) Customer."No." ELSE IF ("Sales/Purchase" = CONST(Purchase)) Vendor."No."

LanguageCaption
de-DERech. an Debitor/Kreditor
en-USBill-to Cust./Vend.
it-ITBill-to cliente/fornitore

Cust./Vend. Posting Group (42)

Code[20]

TableRelation: if ("Sales/Purchase" = const(Sales)) "Customer Posting Group".Code else if ("Sales/Purchase" = const(Purchase)) "Vendor Posting Group".Code

LanguageCaption
de-DEDebitoren-/Kreditorenbuchungsgruppe
en-USCust./Vend. Posting Group
it-ITCat. reg. cliente/fornitore

Line Posting Group (45)

Code[20]

TableRelation: IF ("Sales/Purchase" = CONST(Purchase)) "Vendor Posting Group".Code ELSE IF ("Sales/Purchase" = CONST(Sales)) "Customer Posting Group".Code

LanguageCaption
de-DEBuchungsgruppe
en-USPosting Group
it-ITCategoria registrazione

Gen. Bus. Posting Group (46)

Code[20]

TableRelation: "Gen. Business Posting Group".Code

LanguageCaption
de-DEGeschäftsbuchungsgruppe
en-USGen. Bus. Posting Group
it-ITCat. reg. business

Gen. Prod. Posting Group (47)

Code[20]

TableRelation: "Gen. Product Posting Group".Code

LanguageCaption
de-DEProduktbuchungsgruppe
en-USGen. Prod. Posting Group
it-ITCat. reg. articolo/servizio

Amount (LCY) (50)

Decimal

LanguageCaption
de-DEBetrag (LCY)
en-USAmount (LCY)
it-ITImporto (VL)

Amount per Unit (LCY) (51)

Decimal

LanguageCaption
de-DEBetrag pro Einheit (MW)
en-USAmount per Unit (LCY)
it-ITImporto per unità (VL)

Amount (55)

Decimal

LanguageCaption
de-DEBetrag
en-USAmount
it-ITImporto

Amount per Unit (56)

Decimal

LanguageCaption
de-DEBetrag pro Einheit
en-USAmount per Unit
it-ITImporto per unità

Currency Code (60)

Code[10]

TableRelation: Currency.Code

LanguageCaption
de-DEWährungscode
en-USCurrency Code
it-ITCod. valuta

Currency Factor (61)

Decimal

LanguageCaption
de-DEWährungsfaktor
en-USCurrency Factor
it-ITFattore valuta

Inv. Document Type (70)

Integer

LanguageCaption
de-DERech.-Belegart
en-USInv. Document Type
it-ITTipo di documento fattura

Inv. Document No. (71)

Code[20]

LanguageCaption
de-DERech.-Belegnr.
en-USInv. Document No.
it-ITNr. documento fattura

Inv. Document Line No. (72)

Integer

LanguageCaption
de-DERech.-Belegzeilennr.
en-USInv. Document Line No.
it-ITNr. riga documento fattura

Settlement ID (73)

Guid

LanguageCaption
de-DEAbrechnungs-ID
en-USSettlement ID
it-ITID liquidazione

Correction (75)

Boolean

LanguageCaption
de-DEKorrektur
en-USCorrection
it-ITCorrezione

Last DTI Calc. Date (108)

Date

LanguageCaption
de-DEDatum letzte ZFB-Berechnung
en-USLast DTI Calc. Date
it-ITData ultimo calcolo DDF

DTI Account No. (110)

Code[20]

TableRelation: "G/L Account"

LanguageCaption
de-DEZFB-Sachkontonr.
en-USDTI Account No.
it-ITNr conto C/G DDF

DTI Bal. Account No. (111)

Code[20]

TableRelation: "G/L Account"

LanguageCaption
de-DEZFB-Gegenkontonr.
en-USDTI Bal. Account No.
it-ITNr. contropartita DDF

VAT Bus. Posting Group (160)

Code[20]

TableRelation: "VAT Business Posting Group"

LanguageCaption
de-DEMwSt.-Geschäftsbuchungsgruppe
en-USVAT Bus. Posting Group
it-ITCat. reg. business IVA

VAT Prod. Posting Group (170)

Code[20]

TableRelation: "VAT Product Posting Group"

LanguageCaption
de-DEMwSt.-Produktbuchungsgruppe
en-USVAT Prod. Posting Group
it-ITCat. reg. art./serv. IVA

Global Dimension 1 Code (480)

Code[20]

TableRelation: "Dimension Value".Code WHERE("Global Dimension No." = CONST(1))

LanguageCaption
de-DEGlobaler Dimensionscode 1
en-USGlobal Dimension 1 Code
it-ITCod. dimensione globale 1

Global Dimension 2 Code (481)

Code[20]

TableRelation: "Dimension Value".Code WHERE("Global Dimension No." = CONST(2))

LanguageCaption
de-DEGlobaler Dimensionscode 2
en-USGlobal Dimension 2 Code
it-ITCod. dimensione globale 2

Dimension Set ID (485)

Integer

TableRelation: "Dimension Set Entry"

LanguageCaption
de-DEDimensionssatz-ID
en-USDimension Set ID
it-ITID set di dimensioni

CWS Shipment No. (500)

Code[20]

LanguageCaption
de-DECWS Versand-Nr.
en-USCWS Shipment No.
it-ITNr. spedizione CWS

Vendor Shipment No. (510)

Code[35]

LanguageCaption
de-DEKred.-Lieferungsnr.
en-USVendor Shipment No.
it-ITNr. doc. trasp. for.

To Be Reversed (1000)

Boolean

For internal use only.

LanguageCaption

Methods

GetShipmentHeaderRecRef

procedure GetShipmentHeaderRecRef(var RecRef: RecordRef; DTIEntry: Record "EOS001 DTI Entry")

Parameters / Return Value

  • RecRef RecordRef

  • DTIEntry Record "EOS001 DTI Entry"


ShowDimensions

procedure ShowDimensions()

GetDocumentTypeName

procedure GetDocumentTypeName(): Text

Parameters / Return Value

  • Returns Text[]

CopyFromSalesShptLineCorrection

procedure CopyFromSalesShptLineCorrection(OldDocLine: Record "Sales Shipment Line"; NewDocLine: Record "Sales Shipment Line"): Boolean

Parameters / Return Value

  • OldDocLine Record "Sales Shipment Line"

  • NewDocLine Record "Sales Shipment Line"

  • Returns Boolean


CopyFromSalesShptLine

procedure CopyFromSalesShptLine(SalesLine: Record "Sales Line";SalesShptLine: Record "Sales Shipment Line"): Boolean

Parameters / Return Value

  • SalesLine Record "Sales Line"

  • SalesShptLine Record "Sales Shipment Line"

  • Returns Boolean


CopyFromReturnRcptLineCorrection

procedure CopyFromReturnRcptLineCorrection(OldDocLine: Record "Return Receipt Line"; NewDocLine: Record "Return Receipt Line"): Boolean

Parameters / Return Value

  • OldDocLine Record "Return Receipt Line"

  • NewDocLine Record "Return Receipt Line"

  • Returns Boolean


CopyFromReturnRcptLine

procedure CopyFromReturnRcptLine(SalesLine: Record "Sales Line";ReturnRcptLine: Record "Return Receipt Line"): Boolean

Parameters / Return Value

  • SalesLine Record "Sales Line"

  • ReturnRcptLine Record "Return Receipt Line"

  • Returns Boolean


CopyFromSalesInvLine

procedure CopyFromSalesInvLine(SalesLine: Record "Sales Line";SalesInvLine: Record "Sales Invoice Line";SalesShptLine: Record "Sales Shipment Line";QtyToInvoice: Decimal): Boolean

Parameters / Return Value

  • SalesLine Record "Sales Line"

  • SalesInvLine Record "Sales Invoice Line"

  • SalesShptLine Record "Sales Shipment Line"

  • QtyToInvoice Decimal

  • Returns Boolean


CopyFromSalesCrMemoLine

procedure CopyFromSalesCrMemoLine(SalesLine: Record "Sales Line";SalesCrMemoLine: Record "Sales Cr.Memo Line";ReturnRcptLine: Record "Return Receipt Line";QtyToInvoice: Decimal): Boolean

Parameters / Return Value

  • SalesLine Record "Sales Line"

  • SalesCrMemoLine Record "Sales Cr.Memo Line"

  • ReturnRcptLine Record "Return Receipt Line"

  • QtyToInvoice Decimal

  • Returns Boolean


CopyFromPurchRcptLineCorrection

procedure CopyFromPurchRcptLineCorrection(OldDocLine: Record "Purch. Rcpt. Line"; NewDocLine: Record "Purch. Rcpt. Line"): Boolean

Parameters / Return Value

  • OldDocLine Record "Purch. Rcpt. Line"

  • NewDocLine Record "Purch. Rcpt. Line"

  • Returns Boolean


CopyFromPurchRcptLine

procedure CopyFromPurchRcptLine(PurchLine: Record "Purchase Line";PurchRcptLine: Record "Purch. Rcpt. Line"): Boolean

Parameters / Return Value

  • PurchLine Record "Purchase Line"

  • PurchRcptLine Record "Purch. Rcpt. Line"

  • Returns Boolean


CopyFromReturnShptLineCorrection

procedure CopyFromReturnShptLineCorrection(OldDocLine: Record "Return Shipment Line"; NewDocLine: Record "Return Shipment Line"): Boolean

Parameters / Return Value

  • OldDocLine Record "Return Shipment Line"

  • NewDocLine Record "Return Shipment Line"

  • Returns Boolean


CopyFromReturnShptLine

procedure CopyFromReturnShptLine(PurchLine: Record "Purchase Line";ReturnShptLine: Record "Return Shipment Line"): Boolean

Parameters / Return Value

  • PurchLine Record "Purchase Line"

  • ReturnShptLine Record "Return Shipment Line"

  • Returns Boolean


CopyFromPurchInvLine

procedure CopyFromPurchInvLine(PurchLine: Record "Purchase Line";PurchInvLine: Record "Purch. Inv. Line";PurchRcptLine: Record "Purch. Rcpt. Line";QtyToInvoice: Decimal): Boolean

Parameters / Return Value

  • PurchLine Record "Purchase Line"

  • PurchInvLine Record "Purch. Inv. Line"

  • PurchRcptLine Record "Purch. Rcpt. Line"

  • QtyToInvoice Decimal

  • Returns Boolean


CopyFromPurchCrMemoLine

procedure CopyFromPurchCrMemoLine(PurchLine: Record "Purchase Line";PurchCrMemoLine: Record "Purch. Cr. Memo Line";ReturnShptLine: Record "Return Shipment Line";QtyToInvoice: Decimal): Boolean

Parameters / Return Value

  • PurchLine Record "Purchase Line"

  • PurchCrMemoLine Record "Purch. Cr. Memo Line"

  • ReturnShptLine Record "Return Shipment Line"

  • QtyToInvoice Decimal

  • Returns Boolean


GetCustVendAccNo

procedure GetCustVendAccNo(): Code[20]

Parameters / Return Value

  • Returns Code[20]

CalcSettledAmount

procedure CalcSettledAmount(): Decimal

Parameters / Return Value

  • Returns Decimal

GetByDocument

procedure GetByDocument(DocumentLine: Variant): Boolean

Parameters / Return Value

  • DocumentLine Variant

  • Returns Boolean


GetByDocument

procedure GetByDocument(DocumentLine: Variant; WithError: Boolean): Boolean

Parameters / Return Value

  • DocumentLine Variant

  • WithError Boolean

  • Returns Boolean


FilterByDocument

procedure FilterByDocument(DocumentLine: Variant)

Parameters / Return Value

  • DocumentLine Variant

GetSettlementEntry

procedure GetSettlementEntry(var DtiEntry: Record "EOS001 DTI Entry"): Boolean

Attempts to find the settlement entry for this DTI entry. A single shipment entry can only be settled once and therefore only one (or none) entry must exist. As such: this will only work if the current DTI entry is a shipment entry.

Parameters / Return Value

  • DtiEntry Record "EOS001 DTI Entry"

    The found settlement entry.

  • Returns Boolean

    true if a settlement entry was found.


HasSettlement

procedure HasSettlement(var SettlementDtiEntry: Record "EOS001 DTI Entry"): Boolean

Parameters / Return Value

  • SettlementDtiEntry Record "EOS001 DTI Entry"

  • Returns Boolean


HasSettlement

procedure HasSettlement(): Boolean

Specifies if the current entry has been settled. This will only work if the entry is a shipment entry.

Parameters / Return Value

  • Returns Boolean

Events

OnBeforeGetGlAccSales

local procedure OnBeforeGetGlAccSales(SalesLine: Record "Sales Line"; var GlAccountNo: Code[20]; var Handled: Boolean)

Parameters / Return Value

  • SalesLine Record "Sales Line"

  • GlAccountNo Code[20]

  • Handled Boolean


OnBeforeGetGlAccPurch

local procedure OnBeforeGetGlAccPurch(PurchLine: Record "Purchase Line"; var GlAccountNo: Code[20]; var Handled: Boolean)

Parameters / Return Value

  • PurchLine Record "Purchase Line"

  • GlAccountNo Code[20]

  • Handled Boolean


OnAfterCopyFromSalesShptLine

local procedure OnAfterCopyFromSalesShptLine(SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; SalesShptLine: Record "Sales Shipment Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • SalesHeader Record "Sales Header"

  • SalesLine Record "Sales Line"

  • SalesShptLine Record "Sales Shipment Line"

  • CanInsertEntry Boolean


OnAfterCopyFromSalesInvLine

local procedure OnAfterCopyFromSalesInvLine(SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; SalesInvLine: Record "Sales Invoice Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • SalesHeader Record "Sales Header"

  • SalesLine Record "Sales Line"

  • SalesInvLine Record "Sales Invoice Line"

  • CanInsertEntry Boolean


OnAfterCopyFromReturnRcptLine

local procedure OnAfterCopyFromReturnRcptLine(SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; ReturnRcptLine: Record "Return Receipt Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • SalesHeader Record "Sales Header"

  • SalesLine Record "Sales Line"

  • ReturnRcptLine Record "Return Receipt Line"

  • CanInsertEntry Boolean


OnAfterCopyFromSalesCrMemoLine

local procedure OnAfterCopyFromSalesCrMemoLine(SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; SalesCrMemoLine: Record "Sales Cr.Memo Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • SalesHeader Record "Sales Header"

  • SalesLine Record "Sales Line"

  • SalesCrMemoLine Record "Sales Cr.Memo Line"

  • CanInsertEntry Boolean


OnAfterCopyFromPurchRcptLine

local procedure OnAfterCopyFromPurchRcptLine(PurchHeader: Record "Purchase Header"; PurchLine: Record "Purchase Line"; PurchRcptLine: Record "Purch. Rcpt. Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • PurchHeader Record "Purchase Header"

  • PurchLine Record "Purchase Line"

  • PurchRcptLine Record "Purch. Rcpt. Line"

  • CanInsertEntry Boolean


OnAfterCopyFromPurchInvLine

local procedure OnAfterCopyFromPurchInvLine(PurchHeader: Record "Purchase Header"; PurchLine: Record "Purchase Line"; PurchInvLine: Record "Purch. Inv. Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • PurchHeader Record "Purchase Header"

  • PurchLine Record "Purchase Line"

  • PurchInvLine Record "Purch. Inv. Line"

  • CanInsertEntry Boolean


OnAfterCopyFromReturnShptLine

local procedure OnAfterCopyFromReturnShptLine(PurchHeader: Record "Purchase Header"; PurchLine: Record "Purchase Line"; ReturnShptLine: Record "Return Shipment Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • PurchHeader Record "Purchase Header"

  • PurchLine Record "Purchase Line"

  • ReturnShptLine Record "Return Shipment Line"

  • CanInsertEntry Boolean


OnAfterCopyFromPurchCrMemoLine

local procedure OnAfterCopyFromPurchCrMemoLine(PurchHeader: Record "Purchase Header"; PurchLine: Record "Purchase Line"; PurchCrMemoLine: Record "Purch. Cr. Memo Line"; var CanInsertEntry: Boolean)

Parameters / Return Value

  • PurchHeader Record "Purchase Header"

  • PurchLine Record "Purchase Line"

  • PurchCrMemoLine Record "Purch. Cr. Memo Line"

  • CanInsertEntry Boolean


OnAfterFilterByDocument

local procedure OnAfterFilterByDocument(DocumentVariant: Variant)

Parameters / Return Value

  • DocumentVariant Variant

OnBeforeGetCustVendAccountNo

local procedure OnBeforeGetCustVendAccountNo(DocEntry: Record "EOS001 DTI Entry"; var GlAccountNo: Code[20]; var Handled: Boolean)

Parameters / Return Value

  • DocEntry Record "EOS001 DTI Entry"

  • GlAccountNo Code[20]

  • Handled Boolean


OnAfterGetCustVendAccountNo

local procedure OnAfterGetCustVendAccountNo(DocEntry: Record "EOS001 DTI Entry"; var GlAccountNo: Code[20])

Parameters / Return Value

  • DocEntry Record "EOS001 DTI Entry"

  • GlAccountNo Code[20]


OnAfterUpdateAmounts

local procedure OnAfterUpdateAmounts()

OnAfterAdjustForRoundingResidue

local procedure OnAfterAdjustForRoundingResidue(OrigDtiEntry: Record "EOS001 DTI Entry"; var DtiEntry: Record "EOS001 DTI Entry")

Raised whenever the amounts of an invoice DTI entry have been adjusted to compensate for possible rounding residuals.

Parameters / Return Value

  • OrigDtiEntry Record "EOS001 DTI Entry"

    The DTI entry before the adjustment was applied.

  • DtiEntry Record "EOS001 DTI Entry"

    The DTI entry. The adjustment has already been applied here.


OnAfterGetLineAmountExclVat

local procedure OnAfterGetLineAmountExclVat(SourceDocumentLine: Variant; var AmountExclVat: Decimal)

Raised after documemnt-to-invoice amount for a given source document line has been calculated. Use this to manually override or modify the amount.

Parameters / Return Value

  • SourceDocumentLine Variant

    The source document line.

  • AmountExclVat Decimal

    The calculated line amount excluding VAT. Modify this if you need to change teh amount.



EOS Labs -