Table 3010832 "LSV Journal" (CH)

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

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

Properties

Property	Value
Caption	LSV Journal
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	LSV Journal Description	Text[150]	—
5	LSV Status	Option	—	OptionCaption: Edit,Released,File Created,Finished; not editable
10	Credit Date	Date	—
12	LSV Bank Code	Code[20]	—	TableRelation LSV Setup
30	Collection Completed On	Date	—
40	File Written On	Date	—
50	No. Of Entries	Integer	—
51	No. Of Entries Plus	Integer	—	FlowField: count(“LSV Journal Line” where(“LSV Journal No.” = field(“No.”)))
52	Amount	Decimal	—
53	Amount Plus	Decimal	—	FlowField: sum(“LSV Journal Line”.“Collection Amount” where(“LSV Journal No.” = field(“No.”)))
54	Currency Code	Code[10]	—	TableRelation Currency
100	Collection Completed By	Code[50]	—	TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
130	DebitDirect Orderno.	Code[2]	—
1200	Partner Type	Option	—	OptionCaption: ,Company,Person

Keys

Key1: No. (clustered)

Procedures

CreateDirectDebitFile()

Plus 2 local procedures.

Triggers

OnDelete, OnInsert

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

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