Table 2000042 "CODA Statement Source 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 Source 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	Line No.	Integer	—
4	ID	Option	—	OptionCaption: Header,Old Balance,Movement,Information,Free Message,,,,New Balance,Trailer
5	Data	Text[128]	—
6	Item Code	Text[1]	—
7	Sequence No.	Integer	—
8	Detail No.	Integer	—
9	Bank Reference No.	Text[21]	—
10	Ext. Reference No.	Text[8]	—
11	Amount	Decimal	—
12	Transaction Date	Date	—
13	Transaction Type	Integer	—
14	Transaction Family	Integer	—
15	Transaction	Integer	—
16	Transaction Category	Integer	—
17	Message Type	Option	—	OptionCaption: Non standard format,Standard format
18	Type Standard Format Message	Integer	—
19	Statement Message	Text[105]	—
20	Posting Date	Date	—
21	Globalisation Code	Integer	—
22	Customer Reference	Text[35]	—
23	Bank Account No. Other Party	Text[34]	—
24	Internal Codes Other Party	Text[10]	—
25	Ext. Acc. No. Other Party	Text[15]	—
26	Name Other Party	Text[35]	—
27	Address Other Party	Text[35]	—
28	City Other Party	Text[35]	—
29	Sequence Code	Integer	—
30	Binding Code	Integer	—
40	CODA Statement No.	Integer	—
50	Transferred	Boolean	—
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., Line No. (clustered)
Key2: ID, Sequence No., Detail 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: "CODA Statement Source 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.