Table 18091202 EOS IPL Invoice Plan Line

Table 18091202 EOS IPL Invoice Plan Line

Language	Caption
de-AT	Zahlplanzeilen
de-CH	Zahlplanzeilen
de-DE	Zahlplanzeilen
en-AU	Invoice Plan Line
en-CA	Invoice Plan Line
en-GB	Invoice Plan Line
en-NZ	Invoice Plan Line
en-US	Invoice Plan Line
it-CH	Riga Piano fatturazione
it-IT	Riga Piano fatturazione

Fields

Invoice Plan No. (`5`)

Code[20]

TableRelation: "EOS IPL Invoice Plan Header"

Language	Caption
de-AT	Zahlplannr.
de-CH	Zahlplannr.
de-DE	Zahlplannr.
en-AU	Invoice Plan No.
en-CA	Invoice Plan No.
en-GB	Invoice Plan No.
en-NZ	Invoice Plan No.
en-US	Invoice Plan No.
it-CH	Nr. Piano fatturazione
it-IT	Nr. Piano fatturazione

Line No. (`10`)

Integer

Language	Caption
de-AT	Zeilennr.
de-CH	Zeilennr.
de-DE	Zeilennr.
en-AU	Line No.
en-CA	Line No.
en-GB	Line No.
en-NZ	Line No.
en-US	Line No.
it-CH	Nr. riga
it-IT	Nr. riga

Planned Invoice Date (`15`)

Date

Language	Caption
de-AT	Geplantes Rechnungsdatum
de-CH	Geplantes Rechnungsdatum
de-DE	Geplantes Rechnungsdatum
en-AU	Planned Invoice Date
en-CA	Planned Invoice Date
en-GB	Planned Invoice Date
en-NZ	Planned Invoice Date
en-US	Planned Invoice Date
it-CH	Data fatturazione prevista
it-IT	Data fatturazione prevista

Document Date (`16`)

Date

Language	Caption
de-AT	Belegdatum
de-CH	Belegdatum
de-DE	Belegdatum
en-AU	Document Date
en-CA	Document Date
en-GB	Document Date
en-NZ	Document Date
en-US	Document Date
it-CH	Data documento
it-IT	Data documento

Share in % (`20`)

Decimal

Language	Caption
de-AT	Anteil in %
de-CH	Anteil in %
de-DE	Anteil in %
en-AU	Share in %
en-CA	Share in %
en-GB	Share in %
en-NZ	Share in %
en-US	Share in %
it-CH	Quota in %
it-IT	Quota in %

Amount (`25`)

Decimal

Language	Caption
de-AT	Betrag
de-CH	Betrag
de-DE	Betrag
en-AU	Amount
en-CA	Amount
en-GB	Amount
en-NZ	Amount
en-US	Amount
it-CH	Importo
it-IT	Importo

Gen. Bus. Posting Group (`29`)

Code[20]

TableRelation: "Gen. Business Posting Group"

Language	Caption
de-AT	Geschäftsbuchungsgruppe
de-CH	Geschäftsbuchungsgruppe
de-DE	Geschäftsbuchungsgruppe
en-AU	Gen. Bus. Posting Group
en-CA	Gen. Bus. Posting Group
en-GB	Gen. Bus. Posting Group
en-NZ	Gen. Bus. Posting Group
en-US	Gen. Bus. Posting Group
it-CH	Cat. reg. business
it-IT	Cat. reg. business

Gen. Prod. Posting Group (`30`)

Code[20]

TableRelation: "Gen. Product Posting Group"

Language	Caption
de-AT	Produktbuchungsgruppe
de-CH	Produktbuchungsgruppe
de-DE	Produktbuchungsgruppe
en-AU	Gen. Prod. Posting Group
en-CA	Gen. Prod. Posting Group
en-GB	Gen. Prod. Posting Group
en-NZ	Gen. Prod. Posting Group
en-US	Gen. Prod. Posting Group
it-CH	Cat. reg. articolo/servizio
it-IT	Cat. reg. articolo/servizio

VAT Prod. Posting Group (`31`)

Code[20]

TableRelation: "VAT Product Posting Group"

Language	Caption
de-AT	MwSt.-Produktbuchungsgruppe
de-CH	MwSt.-Produktbuchungsgruppe
de-DE	MwSt.-Produktbuchungsgruppe
en-AU	VAT Prod. Posting Group
en-CA	VAT Prod. Posting Group
en-GB	VAT Prod. Posting Group
en-NZ	VAT Prod. Posting Group
en-US	VAT Prod. Posting Group
it-CH	Cat. reg. art./serv. IVA
it-IT	Cat. reg. art./serv. IVA

VAT Bus. Posting Group (`32`)

Code[20]

TableRelation: "VAT Business Posting Group"

Language	Caption
de-AT	MwSt.-Geschäftsbuchungsgruppe
de-CH	MwSt.-Geschäftsbuchungsgruppe
de-DE	MwSt.-Geschäftsbuchungsgruppe
en-AU	VAT Bus. Posting Group
en-CA	VAT Bus. Posting Group
en-GB	VAT Bus. Posting Group
en-NZ	VAT Bus. Posting Group
en-US	VAT Bus. Posting Group
it-CH	Cat. reg. business IVA
it-IT	Cat. reg. business IVA

Posted Invoice (`35`)

Boolean

Language	Caption
de-AT	Gebuchte Rechnung
de-CH	Gebuchte Rechnung
de-DE	Gebuchte Rechnung
en-AU	Posted Invoice
en-CA	Posted Invoice
en-GB	Posted Invoice
en-NZ	Posted Invoice
en-US	Posted Invoice
it-CH	Fattura Registrata
it-IT	Fattura Registrata

Execute Action (`40`)

Boolean

Language	Caption
de-AT	Execute-Aktion
de-CH	Execute-Aktion
de-DE	Execute-Aktion
en-AU	Execute Action
en-CA	Execute Action
en-GB	Execute Action
en-NZ	Execute Action
en-US	Execute Action
it-CH	Esegui azione
it-IT	Esegui azione

Description (`50`)

Text[250]

Language	Caption
de-AT	Beschreibung
de-CH	Beschreibung
de-DE	Beschreibung
en-AU	Description
en-CA	Description
en-GB	Description
en-NZ	Description
en-US	Description
it-CH	Descrizione
it-IT	Descrizione

Texts Exist (`100`)

Boolean

FieldClass: FlowField

CalcFormula: exist("EOS IPL Invoice Plan Text" where("Invoice Plan No." = field("Invoice Plan No."), "Invoice Plan Line No." = field("Line No.")))

Language	Caption
de-AT	Text existiert
de-CH	Text existiert
de-DE	Text existiert
en-AU	Text Exists
en-CA	Text Exists
en-GB	Text Exists
en-NZ	Text Exists
en-US	Text Exists
it-CH	Testo esiste
it-IT	Testo esiste

Job No. (`120`)

Code[20]

FieldClass: FlowField

CalcFormula: lookup("EOS IPL Invoice Plan Header"."Job No." where("No." = field("Invoice Plan No.")))

Language	Caption
de-AT	Projektnr.
de-CH	Projektnr.
de-DE	Job-Nr.
en-AU	Job No.
en-CA	Job No.
en-GB	Job No.
en-NZ	Job No.
en-US	Job No.
it-CH	Nr. commessa
it-IT	Nr. commessa

Invoice Type (`130`)

Enum "EOS IPL Invoice Type"

Language	Caption
de-AT	Rechnungsart
de-CH	Rechnungsart
de-DE	Rechnungsart
en-AU	Invoice Type
en-CA	Invoice Type
en-GB	Invoice Type
en-NZ	Invoice Type
en-US	Invoice Type
it-CH	Tipo fattura
it-IT	Tipo fattura

Unit of Measure Code (`140`)

Code[10]

TableRelation: "Unit of Measure"

Language	Caption
de-AT	Einheitencode
de-CH	Einheitencode
de-DE	Einheitencode
en-AU	Unit of Measure Code
en-CA	Unit of Measure Code
en-GB	Unit of Measure Code
en-NZ	Unit of Measure Code
en-US	Unit of Measure Code
it-CH	Cod. unità di misura
it-IT	Cod. unità di misura

Payment Terms Code (`150`)

Code[10]

TableRelation: "Payment Terms"

Language	Caption
de-AT	Zlg.-Bedingungscode
de-CH	Zlg.-Bedingungscode
de-DE	Zlg.-Bedingungscode
en-AU	Payment Terms Code
en-CA	Payment Terms Code
en-GB	Payment Terms Code
en-NZ	Payment Terms Code
en-US	Payment Terms Code
it-CH	Cod. condizioni pagam.
it-IT	Cod. condizioni pagam.

Invoiced G/L Account (`800`)

Code[20]

TableRelation: "G/L Account"

Language	Caption
de-AT	Fakturiertes Sachkonto
de-CH	Fakturiertes Sachkonto
de-DE	Fakturiertes Sachkonto
en-AU	Invoiced G/L Account
en-CA	Invoiced G/L Account
en-GB	Invoiced G/L Account
en-NZ	Invoiced G/L Account
en-US	Invoiced G/L Account
it-CH	Conto C/G fatturazione
it-IT	Conto C/G fatturazione

Invoice No. (`801`)

Code[20]

TableRelation: if ("Source Type" = const("Sales Order")) "Sales Invoice Header" else if ("Source Type" = const("Service Order")) "Service Invoice Header"

Language	Caption
de-AT	Rechnungsnr.
de-CH	Rechnungsnr.
de-DE	Rechnungsnr.
en-AU	Invoice No.
en-CA	Invoice No.
en-GB	Invoice No.
en-NZ	Invoice No.
en-US	Invoice No.
it-CH	Nr. fattura
it-IT	Nr. fattura

Invoice Line No. (`802`)

Integer

Language	Caption
de-AT	Rechnung Zeilennr.
de-CH	Rechnung Zeilennr.
de-DE	Rechnung Zeilennr.
en-AU	Invoice Line No.
en-CA	Invoice Line No.
en-GB	Invoice Line No.
en-NZ	Invoice Line No.
en-US	Invoice Line No.
it-CH	Nr. Riga Fattura
it-IT	Nr. Riga Fattura

Partial Closing Invoice No. (`804`)

Code[20]

TableRelation: if ("Source Type" = const("Sales Order")) "Sales Header" where("Document Type" = const(Invoice)) else if ("Source Type" = const("Service Order")) "Service Header" where("Document Type" = const(Invoice))

Language	Caption
de-AT	Teilweise Abschlussrechnung Nr.
de-CH	Teilweise Abschlussrechnung Nr.
de-DE	Teilweise Abschlussrechnung Nr.
en-AU	Partial Closing Invoice No.
en-CA	Partial Closing Invoice No.
en-GB	Partial Closing Invoice No.
en-NZ	Partial Closing Invoice No.
en-US	Partial Closing Invoice No.
it-CH	Nr. fattura chiusura parziale
it-IT	Nr. fattura chiusura parziale

Reversed Amount (`810`)

Decimal

Language	Caption
de-AT	Umgekehrter Betrag
de-CH	Umgekehrter Betrag
de-DE	Umgekehrter Betrag
en-AU	Reversed Amount
en-CA	Reversed Amount
en-GB	Reversed Amount
en-NZ	Reversed Amount
en-US	Reversed Amount
it-CH	Importo Stornato
it-IT	Importo Stornato

Credit Memo No. (`901`)

Code[20]

TableRelation: if ("Source Type" = const("Sales Order")) "Sales Cr.Memo Header" else if ("Source Type" = const("Service Order")) "Service Cr.Memo Header"

Language	Caption
de-AT	Gutschriftsnr.
de-CH	Gutschriftsnr.
de-DE	Gutschriftsnr.
en-AU	Credit Memo No.
en-CA	Credit Memo No.
en-GB	Credit Memo No.
en-NZ	Credit Memo No.
en-US	Credit Memo No.
it-CH	Nr. nota credito
it-IT	Nr. nota credito

Credit Memo Line No. (`902`)

Integer

Language	Caption
de-AT	Gutschrift S.-Nr.
de-CH	Gutschrift S.-Nr.
de-DE	Gutschrift S.-Nr.
en-AU	Credit Memo Line No.
en-CA	Credit Memo Line No.
en-GB	Credit Memo Line No.
en-NZ	Credit Memo Line No.
en-US	Credit Memo Line No.
it-CH	Nr. riga nota credito
it-IT	Nr. riga nota credito

Posted Credit Memo (`903`)

Boolean

Language	Caption
de-AT	Gebuchte Gutschrift
de-CH	Gebuchte Gutschrift
de-DE	Gebuchte Gutschrift
en-AU	Posted Credit Memo
en-CA	Posted Credit Memo
en-GB	Posted Credit Memo
en-NZ	Posted Credit Memo
en-US	Posted Credit Memo
it-CH	Nota Credito registrata
it-IT	Nota Credito registrata

Credit Memo Amount (`904`)

Decimal

Language	Caption
de-AT	Gutschriftsbetrag
de-CH	Gutschriftsbetrag
de-DE	Gutschriftsbetrag
en-AU	Credit Memo Amount
en-CA	Credit Memo Amount
en-GB	Credit Memo Amount
en-NZ	Credit Memo Amount
en-US	Credit Memo Amount
it-CH	Importo nota credito
it-IT	Importo nota credito

Net Amount (`1000`)

Decimal

Language	Caption
de-AT	Nettobetrag
de-CH	Nettobetrag
de-DE	Nettobetrag
en-AU	Net Amount
en-CA	Net Amount
en-GB	Net Amount
en-NZ	Net Amount
en-US	Net Amount
it-CH	Importo netto
it-IT	Importo netto

Invoiced Net Amount (`1001`)

Decimal

Language	Caption
de-AT	Fakturierter Nettobetrag
de-CH	Fakturierter Nettobetrag
de-DE	Fakturierter Nettobetrag
en-AU	Invoiced Net Amount
en-CA	Invoiced Net Amount
en-GB	Invoiced Net Amount
en-NZ	Invoiced Net Amount
en-US	Invoiced Net Amount
it-CH	Importo anticipo Detratto
it-IT	Importo anticipo Detratto

Payment Method Code (`2000`)

Code[10]

TableRelation: "Payment Method"

Language	Caption
de-AT	Zahlungsformcode
de-CH	Zahlungsformcode
de-DE	Zahlungsformcode
en-AU	Payment Method Code
en-CA	Payment Method Code
en-GB	Payment Method Code
en-NZ	Payment Method Code
en-US	Payment Method Code
it-CH	Cod. metodo di pagamento
it-IT	Cod. metodo di pagamento

Posting Date (`2001`)

Date

Language	Caption
de-AT	Buchungsdatum
de-CH	Buchungsdatum
de-DE	Buchungsdatum
en-AU	Posting Date
en-CA	Posting Date
en-GB	Posting Date
en-NZ	Posting Date
en-US	Posting Date
it-CH	Data di registrazione
it-IT	Data di registrazione

Invoiced Amount (`2002`)

Decimal

Language	Caption
de-AT	Fakturierter Betrag
de-CH	Fakturierter Betrag
de-DE	Fakturierter Betrag
en-AU	Invoiced Amount
en-CA	Invoiced Amount
en-GB	Invoiced Amount
en-NZ	Invoiced Amount
en-US	Invoiced Amount
it-CH	Importo fatturato
it-IT	Importo fatturato

Shipment No. Filter (`2003`)

Text[250]

Language	Caption
de-AT	Versand-Nr. Filter
de-CH	Versand-Nr. Filter
de-DE	Versand-Nr. Filter
en-AU	Shipment No. Filter
en-CA	Shipment No. Filter
en-GB	Shipment No. Filter
en-NZ	Shipment No. Filter
en-US	Shipment No. Filter
it-CH	Nr. spedizione ﬁltro
it-IT	Nr. spedizione ﬁltro

Shipment Amount (`2004`)

Decimal

Language	Caption
de-AT	Versandmenge
de-CH	Versandmenge
de-DE	Versandmenge
en-AU	Shipment Amount
en-CA	Shipment Amount
en-GB	Shipment Amount
en-NZ	Shipment Amount
en-US	Shipment Amount
it-CH	Importo spedizione
it-IT	Importo spedizione

Source Document No. (`2005`)

Code[20]

Language	Caption
de-AT	Herkunftsbelegnr.
de-CH	Herkunftsbelegnr.
de-DE	Herkunftsbelegnr.
en-AU	Source Document No.
en-CA	Source Document No.
en-GB	Source Document No.
en-NZ	Source Document No.
en-US	Source Document No.
it-CH	Nr. documento origine
it-IT	Nr. documento origine

Source Document Line No. (`2006`)

Integer

Language	Caption
de-AT	Herkunft Belegzeilennr.
de-CH	Herkunft Belegzeilennr.
de-DE	Herkunft Belegzeilennr.
en-AU	Source Document Line No.
en-CA	Source Document Line No.
en-GB	Source Document Line No.
en-NZ	Source Document Line No.
en-US	Source Document Line No.
it-CH	Nr. riga documento di origine
it-IT	Nr. riga documento di origine

Source Type (`2007`)

Enum "EOS IPL Source Type"

Language	Caption
de-AT	Herkunftsart
de-CH	Herkunftsart
de-DE	Herkunftsart
en-AU	Source Type
en-CA	Source Type
en-GB	Source Type
en-NZ	Source Type
en-US	Source Type
it-CH	Tipo origine
it-IT	Tipo origine

G/L Account (`3000`)

Code[20]

TableRelation: "G/L Account"

Language	Caption
de-AT	Sachkonto
de-CH	Sachkonto
de-DE	Sachkonto
en-AU	G/L Account
en-CA	G/L Account
en-GB	G/L Account
en-NZ	G/L Account
en-US	G/L Account
it-CH	Conto C/G
it-IT	Conto C/G

Methods

AssignedAmount

procedure AssignedAmount(): Decimal

Parameters / Return Value

Returns Decimal

CheckInvoiceType

procedure CheckInvoiceType()

CheckShareIn

procedure CheckShareIn()

GetDescription

procedure GetDescription(UseXrec: Boolean) Result: Text

Parameters / Return Value

UseXrec Boolean
Returns Text[]

GetUnpostedDocumentNo

procedure GetUnpostedDocumentNo(ShowError: Boolean): Code[20]

Parameters / Return Value

ShowError Boolean
Returns Code[20]

InitRecord

procedure InitRecord()

LookUpDocumentLineNo

procedure LookUpDocumentLineNo()

ShowInvoices

procedure ShowInvoices()

ShowPostedCreditMemo

procedure ShowPostedCreditMemo()

ShowPostedInvoices

procedure ShowPostedInvoices()

ShowPostedServiceInvoices

procedure ShowPostedServiceInvoices()

UpdateCompletelyAccountedFor

procedure UpdateCompletelyAccountedFor()

UpdateNetAmounts

procedure UpdateNetAmounts()

UpdateShipmentAmount

procedure UpdateShipmentAmount()

UpdateServiceShipmentAmount

procedure UpdateServiceShipmentAmount()

ValidateCreditMemoValues

procedure ValidateCreditMemoValues()

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

Table 18091202 EOS IPL Invoice Plan Line

Fields

Invoice Plan No. (5)

Line No. (10)

Planned Invoice Date (15)

Document Date (16)

Share in % (20)

Amount (25)

Gen. Bus. Posting Group (29)

Gen. Prod. Posting Group (30)

VAT Prod. Posting Group (31)

VAT Bus. Posting Group (32)

Posted Invoice (35)

Execute Action (40)

Description (50)

Texts Exist (100)

Job No. (120)

Invoice Type (130)

Unit of Measure Code (140)

Payment Terms Code (150)

Invoiced G/L Account (800)

Invoice No. (801)

Invoice Line No. (802)

Partial Closing Invoice No. (804)

Reversed Amount (810)

Credit Memo No. (901)

Credit Memo Line No. (902)

Posted Credit Memo (903)

Credit Memo Amount (904)

Net Amount (1000)

Invoiced Net Amount (1001)

Payment Method Code (2000)

Posting Date (2001)

Invoiced Amount (2002)

Shipment No. Filter (2003)

Shipment Amount (2004)

Source Document No. (2005)

Source Document Line No. (2006)

Source Type (2007)

G/L Account (3000)

Methods

AssignedAmount

Parameters / Return Value

CheckInvoiceType

CheckShareIn

GetDescription

Parameters / Return Value

GetUnpostedDocumentNo

Parameters / Return Value

InitRecord

LookUpDocumentLineNo

ShowInvoices

ShowPostedCreditMemo

ShowPostedInvoices

ShowPostedServiceInvoices

UpdateCompletelyAccountedFor

UpdateNetAmounts

UpdateShipmentAmount

UpdateServiceShipmentAmount

ValidateCreditMemoValues

Feedback

Invoice Plan No. (`5`)

Line No. (`10`)

Planned Invoice Date (`15`)

Document Date (`16`)

Share in % (`20`)

Amount (`25`)

Gen. Bus. Posting Group (`29`)

Gen. Prod. Posting Group (`30`)

VAT Prod. Posting Group (`31`)

VAT Bus. Posting Group (`32`)

Posted Invoice (`35`)

Execute Action (`40`)

Description (`50`)

Texts Exist (`100`)

Job No. (`120`)

Invoice Type (`130`)

Unit of Measure Code (`140`)

Payment Terms Code (`150`)

Invoiced G/L Account (`800`)

Invoice No. (`801`)

Invoice Line No. (`802`)

Partial Closing Invoice No. (`804`)

Reversed Amount (`810`)

Credit Memo No. (`901`)

Credit Memo Line No. (`902`)

Posted Credit Memo (`903`)

Credit Memo Amount (`904`)

Net Amount (`1000`)

Invoiced Net Amount (`1001`)

Payment Method Code (`2000`)

Posting Date (`2001`)

Invoiced Amount (`2002`)

Shipment No. Filter (`2003`)

Shipment Amount (`2004`)

Source Document No. (`2005`)

Source Document Line No. (`2006`)

Source Type (`2007`)

G/L Account (`3000`)