Table 32000002 "Ref. Payment - Exported" (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 - Exported
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	Vendor No.	Code[20]	—	TableRelation Vendor.“No.”
4	Payment Account	Code[20]	—	TableRelation “Bank Account”.“No.” where(“Country/Region Code” = filter(‘’ \| ‘FI’))
5	Due Date	Date	—
6	Payment Date	Date	—
7	Document Type	Option	—	OptionCaption: ,Payment,Invoice,Credit Memo; not editable
8	Document No.	Code[20]	—
9	Currency Code	Code[10]	—	TableRelation Currency.Code
10	Amount	Decimal	—
11	Amount (LCY)	Decimal	—
12	Vendor Account	Code[20]	—	TableRelation “Vendor Bank Account”.Code where(“Vendor No.” = field(“Vendor No.”))
13	Message Type	Option	—	OptionCaption: Reference No.,Invoice Information,Message,Long Message,Tax Message
14	Invoice Message	Text[250]	—
15	Applies-to ID	Code[50]	—
16	External Document No.	Code[35]	—
17	Batch Code	Code[35]	—
18	Transferred	Boolean	—
19	Transfer Date	Date	—
20	Transfer Time	Time	—
21	Foreign Payment	Boolean	—	not editable
22	Posting Date	Date	—
23	Foreign Payment Method	Code[1]	—	TableRelation “Foreign Payment Types”.Code where(“Code Type” = const(“Payment Method”))
24	Foreign Banks Service Fee	Code[1]	—	TableRelation “Foreign Payment Types”.Code where(“Code Type” = const(“Service Fee”))
25	Entry No.	Integer	—	TableRelation “Vendor Ledger Entry”.“Entry No.” where(“Vendor No.” = field(“Vendor No.”), Open = const(true))
26	Applied Payments	Boolean	—
27	Exchange Rate	Decimal	—
28	Currency Factor	Decimal	—	not editable
29	Posted to G/L	Boolean	—	not editable
30	Type	Option	—	OptionCaption: Payment,Detail,Message
31	Affiliated to Line	Integer	—
32	Invoice Message 2	Text[250]	—
33	Picked to Journal	Boolean	—
34	Payment Execution Date	Date	—
35	File Name	Text[250]	—
36	SEPA Payment	Boolean	—
37	Remittance Information	Option	—	OptionCaption: Structured,Unstructured
38	Description 2	Text[250]	Description caption

Keys

Key1: No. (clustered)
Key2: Transferred, Applied Payments, Foreign Payment, SEPA Payment
Key3: Payment Date, Vendor No., Entry No.
Key4: Payment Account, Payment Date

Procedures

GetLastEntryNo(): Integer
SetDefaultTypes()
CheckFixedCurrency(): Boolean
UpdateLines()
UpdateRemittanceInfo()
ExistsNotTransferred(): Boolean
SetUsePaymentDisc(NewUsePaymentDisc: Boolean)
SetUsePaymentDiscTolerance(NewUsePmtDiscTolerance: Boolean)
GetLastLineNo(): Integer
MarkAffiliatedAsTransferred()
ExportToFile()

Plus 4 local procedures.

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