BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 11000002 "Payment History Line" (NL)

NL country layer · Microsoft.Bank.Payment

Open in Claude11000002-nl.mdSource on GitHub

Across versions

  1. BC23-27not present
  2. BC28-30present

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

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

Properties

Property Value
Caption Payment History 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 Run No. Code[20] — TableRelation “Payment History”.“Run No.”; not editable
2 Line No. Integer — not editable
3 Account Type Option — OptionCaption: Customer,Vendor,Employee; not editable
4 Account No. Code[20] — TableRelation if (“Account Type” = const(Customer)) Customer.“No.” else if (“Account Type” = const(Vendor)) Vendor.“No.” else if (“Account Type” = const(Employee)) Employee.“No.”; not editable
5 Date Date — not editable
6 Amount Decimal — not editable
7 Bank 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.”)) else if (“Account Type” = const(Employee)) Employee.“No.” where(“Employee No….; not editable
8 Our Bank Code[20] — TableRelation “Bank Account”.“No.”; not editable
9 Order Option — OptionCaption: ,Debit,Credit; not editable
10 Currency Code Code[10] — TableRelation Currency; not editable
11 Description 1 Text[32] — not editable
12 Description 2 Text[32] — not editable
13 Description 3 Text[32] — not editable
14 Description 4 Text[32] — not editable
15 Identification Code[80] — not editable
16 Bank Account No. Text[30] — not editable
18 Transaction Mode Code[20] — TableRelation “Transaction Mode”.Code where(“Account Type” = field(“Account Type”)); not editable
19 Status Option — OptionCaption: New,Transmitted,Request for Cancellation,Rejected,Cancelled,Posted; not editable
20 Document No. Code[20] — not editable
21 Posting Date Date — not editable
23 Payment/Receipt Option — OptionCaption: Payment,Receipt; not editable
24 Amount Paymt. in Process (LCY) Decimal — not editable
25 Docket Boolean — not editable
100 Account Holder Name Text[100] — not editable
101 Account Holder Address Text[100] — not editable
102 Account Holder Post Code Code[20] — TableRelation “Post Code”.Code; not editable
103 Account Holder City Text[30] — TableRelation “Post Code”.City; not editable
104 Acc. Hold. Country/Region Code Code[10] — TableRelation “Country/Region”.Code; not editable
105 National Bank Code Code[10] — not editable
106 SWIFT Code Code[20] — not editable
110 Nature of the Payment Option — OptionCaption: ,Goods,Transito Trade,Invisible- and Capital Transactions,Transfer to Own Account,Other Registrated BFI
111 Registration No. DNB Text[8] —
112 Description Payment Text[30] —
113 Item No. Text[2] —
114 Traders No. Text[4] —
115 Urgent Boolean —
120 Bank Name Text[100] — not editable
121 Bank Address Text[100] — not editable
122 Bank City Text[30] — TableRelation “Post Code”.City; not editable
123 Bank Country/Region Code[10] — TableRelation “Country/Region”.Code; not editable
130 Transfer Cost Domestic Option — OptionCaption: Principal,Balancing Account Holder; not editable
131 Transfer Cost Foreign Option — OptionCaption: Principal,Balancing Account Holder; not editable
132 Abbrev. National Bank Code Code[3] —
133 IBAN Code[50] —
134 Direct Debit Mandate ID Code[35] — TableRelation “SEPA Direct Debit Mandate”.ID; not editable
135 Direct Debit Mandate Counter Integer — not editable
140 Sequence Type Option — OptionCaption: ’ ,OOFF,FRST,RCUR,FNAL’, Locked = true; not editable
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable
11400 Foreign Currency Code[10] —
11401 Foreign Amount Decimal —
11402 Global Dimension 1 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
11403 Global Dimension 2 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))

Keys

  • Key1: Our Bank, Run No., Line No. (clustered)
  • Key2: Our Bank, Status, Run No., Order, Date
  • Key3: Document No., Posting Date
  • Key4: Our Bank, Run No., Payment/Receipt, Date
  • Key5: Our Bank, Identification, Status
  • Key6: Date, Sequence Type

Events published

  • OnAfterGetUnstrRemitInfo(var PaymentHistoryLine: Record "Payment History Line"; var DetailLine: Record "Detail Line"; var UnstrRemitInfo: Text[140]) (integration)
  • OnBeforeGetUnstrRemitInfo(var PaymentHistoryLine: Record "Payment History Line"; var UnstrRemitInfo: Text[140]; var Delimiter: Text[2]; var IsHandled: Boolean) (integration)

Procedures

  • GetAppliedDocNoList(LenToCut: Integer): Text
  • DeletePaymentFileErrors()
  • WillBeSent()
  • GetSourceName(): Text
  • GetAccHolderPostalAddr(var AddrLine: array[3] of Text[70]): Boolean
  • GetUnstrRemitInfo(): Text[140]
  • AppendUnstrRemitInfo(var Info: Text[140]; var Delimiter: Text[2]; DocumentNo: Code[35]): Boolean
  • ShowDimensions()

Plus 2 local procedures.

Triggers

OnDelete

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 History Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A NL 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