Table 12405 "VAT Ledger Line" (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 Line
DataClassification	CustomerContent
Permissions	tabledata “VAT Ledger Line Tariff No.” = d, tabledata “VAT Ledger Line CD No.” = d, tabledata “VAT Ledger Connection” = d

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	—	TableRelation “VAT Ledger”.Type; OptionCaption: Purchase,Sales
2	Code	Code[20]	—	TableRelation “VAT Ledger”.Code where(Type = field(Type))
3	Line No.	Integer	—
4	C/V No.	Code[20]	—	TableRelation if (“C/V Type” = const(Vendor)) Vendor else if (“C/V Type” = const(Customer)) Customer
5	C/V Name	Text[250]	—
6	C/V VAT Reg. No.	Code[20]	—
7	Document Date	Date	—
8	Document Type	Enum “Gen. Journal Document Type”	—	enum Enum 6 “Gen. Journal Document Type”
9	Document No.	Code[30]	—
10	Amount Including VAT	Decimal	—
11	Base20	Decimal	—
12	Amount20	Decimal	—
13	Base10	Decimal	—
14	Amount10	Decimal	—
15	Base0	Decimal	—
16	Base VAT Exempt	Decimal	—
17	Full VAT Amount	Decimal	—
18	Excise Amount	Decimal	—
19	VAT Percent	Decimal	—
20	Method	Option	—	OptionCaption: Shipment,Payment
22	Transaction/Entry No.	Integer	—
23	Unreal. VAT Entry Date	Date	—
24	Real. VAT Entry Date	Date	—
25	C/V Posting Group	Code[20]	—
26	VAT Product Posting Group	Code[20]	—	TableRelation VAT Product Posting Group
27	VAT Business Posting Group	Code[20]	—	TableRelation VAT Business Posting Group
28	Origin. Document No.	Code[20]	—
29	Prepayment	Boolean	—
30	Receipt Date	Date	—
31	Country/Region of Origin Code	Code[10]	—
32	CD No.	Code[50]	Package No. caption	not editable
33	Payment Doc. No.	Code[20]	—
34	Payment Date	Date	—
35	Amt. Diff. VAT	Boolean	—
36	Full Sales Tax Amount	Decimal	—
37	Sales Tax Amount	Decimal	—
38	Sales Tax Base	Decimal	—
39	No. of Sales Ledger Lines	Integer	—	FlowField: count(“VAT Ledger Connection” where(“Connection Type” = const(Line), “Purch. Ledger Code” = field(Code), “Purch. Ledger Line No.” = field(“Line No.”))); not editable
40	No. of Purch. Ledger Lines	Integer	—	FlowField: count(“VAT Ledger Connection” where(“Connection Type” = const(Line), “Sales Ledger Code” = field(Code), “Sales Ledger Line No.” = field(“Line No.”))); not editable
41	No. of VAT Sales Entries	Integer	—	FlowField: count(“VAT Ledger Connection” where(“Connection Type” = const(Sales), “Sales Ledger Code” = field(Code), “Sales Ledger Line No.” = field(“Line No.”))); not editable
42	No. of VAT Purch. Entries	Integer	—	FlowField: count(“VAT Ledger Connection” where(“Connection Type” = const(Purchase), “Purch. Ledger Code” = field(Code), “Purch. Ledger Line No.” = field(“Line No.”)))
43	Base18	Decimal	—
44	Amount18	Decimal	—
45	Reg. Reason Code	Code[10]	—
50	C/V Type	Option	—	OptionCaption: Vendor,Customer
51	Tariff No.	Code[20]	—	not editable
12464	VAT Correction	Boolean	—
12480	Partial	Boolean	—
12481	Last Date	Date	—
12482	Additional Sheet	Boolean	—
12483	Corr. VAT Entry Posting Date	Date	—
12484	Initial Document No.	Code[20]	—
12485	Correction	Boolean	—
12486	Correction No.	Code[30]	—
12487	Correction Date	Date	—
12488	Revision No.	Code[30]	—
12489	Revision Date	Date	—
12490	Revision of Corr. No.	Code[20]	—
12491	Revision of Corr. Date	Date	—
12492	Print Revision	Boolean	—
12493	VAT Entry Type	Code[15]	—	TableRelation “VAT Entry Type”.Code
12494	Currency Code	Code[10]	—
12495	External Document No.	Code[35]	—
12496	Amount	Decimal	—

Keys

Key1: Type, Code, Line No. (clustered)
Key2: Document No., Document Date
Key3: Document Date
Key4: Real. VAT Entry Date
Key5: Last Date
Key6: C/V No.
Key7: Corr. VAT Entry Posting Date
Key8: Additional Sheet

Procedures

IsCorrection(): Boolean
GetPmtVendorDtldLedgerLines(EndDate: Date; var TempVendorLedgerEntry: Record "Vendor Ledger Entry" temporary)
GetVATAgentVATAmountFCY(): Decimal
GetCDNoListString(): Text

Triggers

OnDelete

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 Line"), 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.