tableFinanceofficial - Microsoftderived - from the source, no model text

Table 10837 "Payment Line FR" (FR)

FR country layer · Microsoft.Bank.Payment

Across versions

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

FR country layer · Microsoft.Bank.Payment · captioned “Payment Line” · 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

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 FR
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 FR
17 Status No. Integer — TableRelation “Payment Status FR”.Line where(“Payment Class” = field(“Payment Class”)); not editable
18 Status Name Text[50] — FlowField: lookup(“Payment Status FR”.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 FR”.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.
  • Key6: Payment Class

Events published

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

Procedures

  • SetUpNewLine(LastGenJnlLine: Record "Payment Line FR"; 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

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 FR"), 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