tableFinanceofficial - Microsoftderived - from the source, no model textobsolete - pending

Table 10866 "Payment Line" (FR)

FR country layer · Microsoft.Bank.Payment

Across versionsobsolete pending since 28.0

  1. BC23-28not present
  2. BC29-30present

FR country layer · Microsoft.Bank.Payment · BC29-30 · source at ea08af5e · facts from BC29

An object of the FR localization, not part of W1.

Properties

Property Value
Caption Payment Line
DataClassification CustomerContent
ObsoleteState Pending
ObsoleteTag 28.0
ObsoleteReason Moved to the Payment Management FR first-party app

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 No. Code[20] — TableRelation Payment Header
2 Line No. Integer —
3 Amount Decimal —
4 Account Type enum “Gen. Journal Account Type” — enum Enum 81 “Gen. Journal Account Type”
5 Account No. Code[20] — TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset”
6 Posting Group Code[20] — TableRelation if (“Account Type” = const(Customer)) “Customer Posting Group” else if (“Account Type” = const(Vendor)) “Vendor Posting Group” else if (“Account Type” = const(“Fixed Asset”)) “FA Posting Group”; not editable
7 Copied To No. Code[20] —
8 Copied To Line Integer —
9 Due Date Date —
10 Acc. Type Last Entry Debit enum “Gen. Journal Account Type” — enum Enum 81 “Gen. Journal Account Type”; not editable
11 Acc. No. Last Entry Debit Code[20] — TableRelation if (“Acc. Type Last Entry Debit” = const(“G/L Account”)) “G/L Account” else if (“Acc. Type Last Entry Debit” = const(Customer)) Customer else if (“Acc. Type Last Entry Debit” = const(Vendor)) Vendor else if (“Acc. Type Last Entry Debit” = const(“Bank Account”)) “Bank Account” else if (“Acc. Type Las…; not editable
12 Acc. Type Last Entry Credit enum “Gen. Journal Account Type” — enum Enum 81 “Gen. Journal Account Type”; not editable
13 Acc. No. Last Entry Credit Code[20] — TableRelation if (“Acc. Type Last Entry Credit” = const(“G/L Account”)) “G/L Account” else if (“Acc. Type Last Entry Credit” = const(Customer)) Customer else if (“Acc. Type Last Entry Credit” = const(Vendor)) Vendor else if (“Acc. Type Last Entry Credit” = const(“Bank Account”)) “Bank Account” else if (“Acc. Type…; not editable
14 P. Group Last Entry Debit Code[20] — not editable
15 P. Group Last Entry Credit Code[20] — not editable
16 Payment Class Text[30] — TableRelation Payment Class
17 Status No. Integer — TableRelation “Payment Status”.Line where(“Payment Class” = field(“Payment Class”)); not editable
18 Status Name Text[50] — FlowField: lookup(“Payment Status”.Name where(“Payment Class” = field(“Payment Class”), Line = field(“Status No.”))); not editable
19 IsCopy Boolean —
20 Currency Code Code[10] — TableRelation Currency
21 Entry No. Debit Integer — not editable
22 Entry No. Credit Integer — not editable
23 Entry No. Debit Memo Integer — not editable
24 Entry No. Credit Memo Integer — not editable
25 Bank Account Code Code[20] — TableRelation if (“Account Type” = const(Customer)) “Customer Bank Account”.Code where(“Customer No.” = field(“Account No.”)) else if (“Account Type” = const(Vendor)) “Vendor Bank Account”.Code where(“Vendor No.” = field(“Account No.”))
26 Bank Branch No. Text[20] —
27 Bank Account No. Text[30] —
28 Agency Code Text[5] —
29 RIB Key Integer —
30 RIB Checked Boolean — not editable
31 Acceptation Code Option — OptionCaption: LCR,No,BOR,LCR NA
32 Document No. Code[20] —
33 Debit Amount Decimal —
34 Credit Amount Decimal —
35 Applies-to ID Code[50] —
36 Currency Factor Decimal —
37 Posted Boolean —
38 Correction Boolean —
39 Bank Account Name Text[100] —
40 Payment Address Code Code[10] — TableRelation “Payment Address”.Code where(“Account Type” = field(“Account Type”), “Account No.” = field(“Account No.”))
41 Applies-to Doc. Type Enum “Gen. Journal Document Type” — enum Enum 6 “Gen. Journal Document Type”; not editable
42 Applies-to Doc. No. Code[20] — not editable
43 External Document No. Code[35] —
44 Amount (LCY) Decimal — not editable
45 Drawee Reference Text[10] —
46 Bank City Text[30] —
47 Marked Boolean — not editable
48 Posting Date Date — not editable
50 Payment in Progress Boolean — not editable
51 Created from No. Code[20] —
55 IBAN Code[50] —
56 SWIFT Code Code[20] —
291 Has Payment Export Error Boolean — FlowField: exist(“Payment Jnl. Export Error Text” where(“Document No.” = field(“No.”), “Journal Line No.” = field(“Line No.”))); not editable
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable
1230 Direct Debit Mandate ID Code[35] — TableRelation if (“Account Type” = const(Customer)) “SEPA Direct Debit Mandate” where(“Customer No.” = field(“Account No.”))

Keys

  • Key1: No., Line No. (clustered)
  • Key2: Copied To No., Copied To Line
  • Key3: Account Type, Account No., Copied To Line, Payment in Progress
  • Key4: No., Account No., Bank Branch No., Agency Code, Bank Account No., Payment Address Code
  • Key5: Posting Date, Document No.

Events published

  • OnAfterSetUpNewLine(var PaymentLine: Record "Payment Line") (integration)
  • OnAfterUpdateEntry(var PaymentLine: Record "Payment Line") (integration)
  • OnBeforeDimensionCreate(var PaymentLine: Record "Payment Line"; var DefaultDimension: Record "Default Dimension"; var IsHandled: Boolean) (integration)
  • OnUpdateEntryOnBeforeDimensionSetup(var PaymentLine: Record "Payment Line") (integration)

Procedures

  • SetUpNewLine(LastGenJnlLine: Record "Payment Line"; BottomLine: Boolean)
  • ShowDimensions()
  • GetAppliedDocNoList(LenToCut: Integer): Text
  • GetAppliesToDocCustLedgEntry(var CustLedgEntry: Record "Cust. Ledger Entry")
  • GetCurrency()
  • InitBankAccount()
  • DimensionSetup()
  • DimensionCreate()
  • DeletePaymentFileErrors()
  • UpdateDueDate(DocumentDate: Date)
  • UpdateEntry(InsertRecord: Boolean)
  • ModifyCheck()

Plus 1 local procedures.

Triggers

OnDelete, OnInsert, OnModify

Deprecations

  • object: Pending 28.0 (#if not CLEANSCHEMA31), “Moved to the Payment Management FR first-party app”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Payment Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A FR country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.

Evidence 1 sources