Table 2000001 "Payment Journal Line" (BE)

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

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

Properties

Property	Value
Caption	Payment Journal 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	Journal Template Name	Code[10]	—	TableRelation Payment Journal Template
2	Line No.	Integer	—
3	Account Type	Option	—	OptionCaption: ,Customer,Vendor
4	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor
5	Posting Date	Date	—
7	External Document No.	Code[35]	—
8	Payment Message	Text[100]	—
9	Standard Format Message	Boolean	—
10	Description	Text[100]	—
12	Currency Code	Code[10]	—	TableRelation Currency; not editable
13	Currency Factor	Decimal	—
14	Amount	Decimal	—
15	Pmt. Disc. Possible	Decimal	—
16	Amount (LCY)	Decimal	—	not editable
17	Pmt. Disc. Possible (LCY)	Decimal	—	not editable
18	Pmt. Discount Date	Date	—
19	Beneficiary Bank Account	Code[20]	—	TableRelation if (“Account Type” = filter(Customer)) “Customer Bank Account”.Code where(“Customer No.” = field(“Account No.”)) else if (“Account Type” = filter(Vendor)) “Vendor Bank Account”.Code where(“Vendor No.” = field(“Account No.”))
20	Beneficiary Bank Account No.	Text[50]	—	not editable
22	Bank Account	Code[20]	—	TableRelation Bank Account
23	Payment Method Code	Code[10]	—	TableRelation Payment Method
24	Shortcut Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
25	Shortcut Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
29	Source Code	Code[10]	—	TableRelation Source Code; not editable
35	Applies-to Doc. Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
36	Applies-to Doc. No.	Code[20]	—
37	Applies-to ID	Code[50]	—
39	Code Payment Method	Option	—	OptionCaption: ,TLX,CDC,CDD,CHC,CHD,MAN,EUR
40	Code Expenses	Option	—	OptionCaption: ,SHA,BEN,OUR
45	IBLC/BLWI Code	Code[3]	—	TableRelation IBLC/BLWI Transaction Code
46	IBLC/BLWI Justification	Text[50]	—
51	Journal Batch Name	Code[10]	—	TableRelation “Paym. Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”))
52	Reason Code	Code[10]	—	TableRelation Reason Code
53	Status	Option	—	OptionCaption: Created,,Processed,Posted; not editable
54	Processing	Boolean	—	not editable
55	System-Created Entry	Boolean	—	not editable
60	ISO Currency Code	Code[3]	—	not editable
61	Bank Country/Region Code	Code[10]	—	TableRelation Country/Region; not editable
62	Bank ISO Country/Region Code	Code[2]	—	not editable
63	Original Remaining Amount	Decimal	—	not editable
64	Ledger Entry No.	Integer	—	TableRelation if (“Account Type” = const(Vendor)) “Vendor Ledger Entry” where(“Entry No.” = field(“Ledger Entry No.”)) else if (“Account Type” = const(Customer)) “Cust. Ledger Entry” where(“Entry No.” = field(“Ledger Entry No.”))
65	Partial Payment	Boolean	—
66	Separate Line	Boolean	—
67	SWIFT Code	Code[20]	—	not editable
69	Salespers./Purch. Code	Code[20]	—
75	Export Protocol Code	Code[20]	—	TableRelation “Export Protocol”.Code
80	Instruction Priority	Option	—	OptionCaption: Normal,High
81	Beneficiary IBAN	Code[50]	—
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
500	Exported To File	Boolean	—

Keys

Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
Key2: Account Type, Account No., Currency Code, Applies-to ID, Separate Line, Applies-to Doc. Type, Applies-to Doc. No.
Key3: ISO Currency Code
Key4: Bank Account, Beneficiary Bank Account No., Status, Account Type, Account No., Currency Code, Posting Date, Instruction Priority, Code Expenses
Key5: Journal Template Name, Journal Batch Name, Account Type, Account No., Export Protocol Code, Bank Account

Events published

OnAfterCustUpdatePayment(var PaymentJournalLine: Record "Payment Journal Line"; CustLedgerEntry: Record "Cust. Ledger Entry") (integration)
OnAfterVendUpdatePayment(var PaymentJournalLine: Record "Payment Journal Line"; VendorLedgerEntry: Record "Vendor Ledger Entry") (integration)

Procedures

InitCurrencyCode()
GetISOCurrencyCode(): Code[3]
VendUpdatePayment()
CustUpdatePayment()
CreateDim(Type1: Integer; No1: Code[20]; Type2: Integer; No2: Code[20]; Type3: Integer; No3: Code[20])
ValidateShortcutDimCode(FieldNo: Integer; var ShortcutDimCode: Code[20])
LookupShortcutDimCode(FieldNo: Integer; var ShortcutDimCode: Code[20])
ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
ShowDimensions()
TypeToTableID2000001(Type: Option " ",Customer,Vendor): Integer
DeletePaymentFileErrors()

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

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