Table 12404 "VAT Ledger" (RU)

RU country layer · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	VAT Ledger
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	Type	Option	—	OptionCaption: Purchase,Sales
2	Code	Code[20]	—
3	Description	Text[100]	—
4	Start Date	Date	—
5	End Date	Date	—
6	From No.	Integer	—	FlowField: min(“VAT Ledger Line”.“Line No.” where(Type = field(Type), Code = field(Code))); not editable
7	To No.	Integer	—	FlowField: max(“VAT Ledger Line”.“Line No.” where(Type = field(Type), Code = field(Code))); not editable
8	No. Series	Code[10]	—	not editable
9	Accounting Period	Date	—	TableRelation Accounting Period
10	Start Page No.	Integer	—
20	C/V Filter	Text[250]	—	TableRelation if (Type = const(Purchase)) Vendor else if (Type = const(Sales)) Customer
21	VAT Product Group Filter	Text[250]	—	TableRelation VAT Product Posting Group
22	VAT Business Group Filter	Text[250]	—	TableRelation VAT Business Posting Group
23	Purchase Sorting	Option	—	OptionCaption: ,Document Date,Document No.,Last Date
24	Sales Sorting	Option	—	OptionCaption: ,Document Date,Document No.,Customer No.
25	Use External Doc. No.	Boolean	—
26	Clear Lines	Boolean	—
27	Start Numbering	Integer	—
28	Other Rates	Option	—	OptionCaption: Do Not Show,Summarized,Detailed
29	Show Realized VAT	Boolean	—
30	Show Unrealized VAT	Boolean	—
31	Show Amount Differences	Boolean	—
32	Show Customer Prepayments	Boolean	—
33	Show Vendor Prepayments	Boolean	—
34	Show VAT Reinstatement	Boolean	—
35	Total VAT Amt VAT Purch Ledger	Decimal	—
36	Tot Base18 Amt VAT Sales Ledg	Decimal	—
37	Tot Base 10 Amt VAT Sales Ledg	Decimal	—
38	Tot Base 0 Amt VAT Sales Ledg	Decimal	—
39	Total VAT18 Amt VAT Sales Ledg	Decimal	—
40	Total VAT10 Amt VAT Sales Ledg	Decimal	—
41	Total VATExempt Amt VAT S Ledg	Decimal	—
42	Tot Base20 Amt VAT Sales Ledg	Decimal	—
43	Total VAT20 Amt VAT Sales Ledg	Decimal	—

Keys

Key1: Type, Code (clustered)
Key2: Type, Start Date

Procedures

AssistEdit(OldVATLedger: Record "VAT Ledger"): Boolean
ComposeDescription()
CheckVATLedgerStatus()
CreateVATLedger()
CreateAddSheet()

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

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