Table 11000001 "Payment History" (NL)

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
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]	—	not editable
2	Status	Option	—	OptionCaption: New,Transmitted; not editable
3	Creation Date	Date	—	not editable
4	User ID	Code[50]	—	not editable; DataClassification EndUserIdentifiableInformation
5	Sent On	Date	—	not editable
6	Sent By	Code[50]	—	not editable; DataClassification EndUserIdentifiableInformation
7	Our Bank	Code[20]	—	TableRelation “Bank Account”.“No.”; not editable
8	Export Protocol	Code[20]	—	TableRelation “Export Protocol”.Code; not editable
9	No. of Transactions	Integer	—	not editable
10	Day Serial Nr.	Integer	—	not editable
11	File on Disk	Text[250]	—	not editable
12	Number of Copies	Integer	—	not editable
13	Remaining Amount	Decimal	—	FlowField: sum(“Payment History Line”.Amount where(“Run No.” = field(“Run No.”), Order = field(“Order Filter”), Date = field(“Date Filter”), “Our Bank” = field(“Our Bank”), Status = filter(New \| Transmitted \| “Request for Cancellation”))); not editable
14	Order Filter	Option	—	FlowFilter; OptionCaption: Receipt,Collection,Payment
15	Date Filter	Date	—	FlowFilter
16	No. Series	Code[20]	—	TableRelation “No. Series”.Code
17	Export	Boolean	—
18	Print Docket	Boolean	—
19	Checksum	Text[256]	—	not editable
50	Account No.	Text[30]	—	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; not editable
103	Account Holder City	Text[50]	—	not editable
104	Acc. Hold. Country/Region Code	Code[10]	—	TableRelation “Country/Region”.Code; not editable
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
11400	Global Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
11401	Global Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))

Keys

Key1: Our Bank, Run No. (clustered)
Key2: Our Bank, Export Protocol, Status, User ID
Key3: Export Protocol, Sent On, Day Serial Nr.
Key4: Our Bank, Status

Events published

OnBeforeGenerateExportfilename(PaymentHistory: Record "Payment History"; New: Boolean) (integration)

Procedures

ExportToPaymentFile()
GenerateExportfilename(New: Boolean): Text[250]
ShowDimensions()

Plus 2 local procedures.

Triggers

OnDelete, OnRename

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