Table 2000041 "CODA Statement Line" (BE)

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

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

Properties

Property	Value
Caption	CODA Statement 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	Bank Account No.	Code[20]	—	TableRelation Bank Account
2	Statement No.	Code[20]	—	TableRelation “CODA Statement”.“Statement No.” where(“Bank Account No.” = field(“Bank Account No.”))
3	Statement Line No.	Integer	—
4	ID	Option	—	OptionCaption: ,,Movement,Information,Free Message; not editable
5	Type	Option	—	OptionCaption: Global,Detail; not editable
6	Description	Text[100]	—
9	Bank Reference No.	Text[21]	—	not editable
10	Ext. Reference No.	Text[8]	—	not editable
11	Statement Amount	Decimal	—	not editable
12	Transaction Date	Date	—	not editable
13	Transaction Type	Integer	—	not editable
14	Transaction Family	Integer	—	not editable
15	Transaction	Integer	—	not editable
16	Transaction Category	Integer	—	not editable
17	Message Type	Option	—	OptionCaption: Non standard format,Standard format; not editable
18	Type Standard Format Message	Integer	—	not editable
19	Statement Message	Text[250]	—	not editable
20	Statement Message (cont.)	Text[250]	—	not editable
21	Posting Date	Date	—	not editable
22	Globalisation Code	Integer	—	not editable
23	Customer Reference	Text[35]	—	not editable
24	Bank Account No. Other Party	Text[34]	—	not editable
25	Internal Codes Other Party	Text[10]	—	not editable
26	Ext. Acc. No. Other Party	Text[15]	—	not editable
27	Name Other Party	Text[35]	—	not editable
28	Address Other Party	Text[35]	—	not editable
29	City Other Party	Text[35]	—	not editable
30	Attached to Line No.	Integer	—	not editable
31	Information	Integer	—	FlowField: count(“CODA Statement Line” where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), ID = const(Information), “Attached to Line No.” = field(“Statement Line No.”))); not editable
37	System-Created Entry	Boolean	—
38	Application Information	Text[80]	—
39	Application Status	Option	—	OptionCaption: ,Partly applied,Applied,Indirectly applied
40	Account Type	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
41	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset”
42	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
43	Document No.	Code[20]	—
44	Amount	Decimal	—
45	Currency Code	Code[10]	—	TableRelation Currency
46	Currency Factor	Decimal	—
47	Amount (LCY)	Decimal	—	not editable
48	Unapplied Amount	Decimal	—	not editable
49	Applies-to ID	Code[50]	—
50	Journal Template Name	Code[10]	—	TableRelation Gen. Journal Template; not editable
51	Journal Batch Name	Code[10]	—	TableRelation “Gen. Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)); not editable
52	Line No.	Integer	—	not editable
53	Account Name	Text[100]	—
60	Original Transaction Currency	Code[3]	—	not editable
61	Original Transaction Amount	Decimal	—	not editable
62	SWIFT Address	Text[11]	—

Keys

Key1: Bank Account No., Statement No., Statement Line No. (clustered)
Key2: Bank Account No., Statement No., Attached to Line No.
Key3: Bank Account No., Statement No., ID, Attached to Line No., Type
Key4: Bank Account No., Statement No., Application Status

Events published

OnUpdateStatusOnAfterUpdateApplicationFields(var CODAStatementLine: Record "CODA Statement Line"; xCODAStatementLine: Record "CODA Statement Line") (integration)

Procedures

UpdateStatus()

Triggers

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: "CODA Statement 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.