Table 32000001 "Ref. Payment - Imported" (FI)

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

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

Properties

Property	Value
Caption	Ref. Payment - Imported
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.	Integer	—
2	Record ID	Integer	—
5	Bank Code	Text[2]	—
6	Agent Code	Text[9]	—
7	Currency Code	Text[1]	—
8	Account Owner Code	Text[9]	—
9	Account No.	Text[15]	—
10	Banks Posting Date	Date	—
11	Banks Payment Date	Date	—
12	Filing Code	Text[16]	—
13	Reference No.	Code[20]	—
14	Payers Name	Text[12]	—
15	Currency Code 2	Text[1]	—
16	Name Source	Text[1]	—
17	Amount	Decimal	—
18	Correction Code	Text[1]	—
19	Delivery Method	Text[1]	—
20	Feedback Code	Text[1]	—
21	Transaction Qty.	Text[6]	—
22	Payments Qty.	Decimal	—
23	Corrections Qty.	Text[6]	—
24	Corrections Amount	Decimal	—
25	Failed Direct Debiting Qty.	Text[6]	—
26	Failed Direct Debiting Amount	Decimal	—
28	Matched	Boolean	—
29	Matched Date	Date	—
30	Matched Time	Time	—
31	Entry No.	Integer	—	TableRelation “Cust. Ledger Entry”.“Entry No.” where(Open = const(true), “Customer No.” = field(“Customer No.”))
35	Bank Account Code	Code[20]	—	TableRelation Bank Account
36	Document No.	Code[20]	—
37	Customer No.	Code[20]	—	TableRelation Customer.“No.”
38	Description	Text[35]	—
40	Posted to G/L	Boolean	—	not editable
41	Posting Date	Date	—
42	Batch No.	Integer	—

Keys

Key1: No. (clustered)
Key2: Filing Code, Record ID
Key3: Banks Payment Date, Filing Code, Customer No.
Key4: Banks Posting Date, Bank Code, Document No.

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: "Ref. Payment - Imported"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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