tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 14927 "VAT Document Entry Buffer" (RU)

RU country layer

Across versions

  1. BC23-28not present
  2. BC29-30present

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 Document Entry Buffer
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 Entry No. Integer — DataClassification SystemMetadata
3 CV No. Code[20] — TableRelation if (“Entry Type” = const(Sale)) Customer else if (“Entry Type” = const(Purchase)) Vendor; DataClassification SystemMetadata
4 Posting Date Date — DataClassification SystemMetadata
5 Document Type Enum “Gen. Journal Document Type” — enum Enum 6 “Gen. Journal Document Type”; DataClassification SystemMetadata
6 Document No. Code[20] — DataClassification SystemMetadata
7 Description Text[100] — DataClassification SystemMetadata
8 CV Name Text[100] — DataClassification SystemMetadata
11 Currency Code Code[10] — TableRelation Currency; DataClassification SystemMetadata
13 Amount Decimal — DataClassification SystemMetadata
14 Remaining Amount Decimal — DataClassification SystemMetadata
15 Original Amt. (LCY) Decimal — DataClassification SystemMetadata
16 Remaining Amt. (LCY) Decimal — DataClassification SystemMetadata
17 Amount (LCY) Decimal — DataClassification SystemMetadata
18 Sales/Purchase (LCY) Decimal — DataClassification SystemMetadata
19 Profit (LCY) Decimal — DataClassification SystemMetadata
20 Inv. Discount (LCY) Decimal — DataClassification SystemMetadata
21 Bill-to/Pay-to CV No. Code[20] — TableRelation Customer; DataClassification SystemMetadata
22 CV Posting Group Code[20] — TableRelation Customer Posting Group; DataClassification SystemMetadata
23 Global Dimension 1 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); DataClassification SystemMetadata
24 Global Dimension 2 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); DataClassification SystemMetadata
25 Salesperson Code Code[20] — TableRelation Salesperson/Purchaser; DataClassification SystemMetadata
27 User ID Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
28 Source Code Code[10] — TableRelation Source Code; DataClassification SystemMetadata
33 On Hold Code[3] — DataClassification SystemMetadata
34 Applies-to Doc. Type Enum “Gen. Journal Document Type” — enum Enum 6 “Gen. Journal Document Type”; DataClassification SystemMetadata
35 Applies-to Doc. No. Code[20] — DataClassification SystemMetadata
36 Open Boolean — DataClassification SystemMetadata
37 Due Date Date — DataClassification SystemMetadata
38 Pmt. Discount Date Date — DataClassification SystemMetadata
39 Original Pmt. Disc. Possible Decimal — DataClassification SystemMetadata
40 Pmt. Disc. Given (LCY) Decimal — DataClassification SystemMetadata
43 Positive Boolean — DataClassification SystemMetadata
44 Closed by Entry No. Integer — TableRelation Cust. Ledger Entry; DataClassification SystemMetadata
45 Closed at Date Date — DataClassification SystemMetadata
46 Closed by Amount Decimal — DataClassification SystemMetadata
47 Applies-to ID Code[50] — DataClassification SystemMetadata
49 Journal Batch Name Code[10] — DataClassification SystemMetadata
50 Reason Code Code[10] — TableRelation Reason Code; DataClassification SystemMetadata
51 Bal. Account Type enum “Gen. Journal Account Type” — enum Enum 81 “Gen. Journal Account Type”; DataClassification SystemMetadata
52 Bal. Account No. Code[20] — TableRelation if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account” else if (“Bal. Account Type” = const(“Fixed Asset”)) “Fixed…; DataClassification SystemMetadata
53 Transaction No. Integer — DataClassification SystemMetadata
54 Closed by Amount (LCY) Decimal — DataClassification SystemMetadata
58 Debit Amount Decimal — DataClassification SystemMetadata
59 Credit Amount Decimal — DataClassification SystemMetadata
60 Debit Amount (LCY) Decimal — DataClassification SystemMetadata
61 Credit Amount (LCY) Decimal — DataClassification SystemMetadata
62 Document Date Date — DataClassification SystemMetadata
63 External Document No. Code[35] — DataClassification SystemMetadata
67 Closed by Currency Code Code[10] — TableRelation Currency; DataClassification SystemMetadata
68 Closed by Currency Amount Decimal — DataClassification SystemMetadata
70 Rounding Currency Code[10] — DataClassification SystemMetadata
71 Rounding Amount Decimal — DataClassification SystemMetadata
72 Rounding Amount (LCY) Decimal — DataClassification SystemMetadata
73 Adjusted Currency Factor Decimal — DataClassification SystemMetadata
74 Original Currency Factor Decimal — DataClassification SystemMetadata
75 Original Amount Decimal — DataClassification SystemMetadata
76 Date Filter Date — FlowFilter
77 Remaining Pmt. Disc. Possible Decimal — DataClassification SystemMetadata
78 Pmt. Disc. Tolerance Date Date — DataClassification SystemMetadata
79 Max. Payment Tolerance Decimal — DataClassification SystemMetadata
80 Last Issued Reminder Level Integer — DataClassification SystemMetadata
81 Accepted Payment Tolerance Decimal — DataClassification SystemMetadata
82 Accepted Pmt. Disc. Tolerance Boolean — DataClassification SystemMetadata
83 Pmt. Tolerance (LCY) Decimal — DataClassification SystemMetadata
84 Amount to Apply Decimal — DataClassification SystemMetadata
85 IC Partner Code Code[20] — TableRelation IC Partner; DataClassification SystemMetadata
86 Applying Entry Boolean — DataClassification SystemMetadata
87 Reversed Boolean — DataClassification SystemMetadata
88 Reversed by Entry No. Integer — TableRelation Cust. Ledger Entry; DataClassification SystemMetadata
89 Reversed Entry No. Integer — TableRelation Cust. Ledger Entry; DataClassification SystemMetadata
90 Prepayment Boolean — DataClassification SystemMetadata
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable; DataClassification SystemMetadata
12401 Prepmt. Diff. Appln. Entry No. Integer — not editable; DataClassification SystemMetadata
12402 Prepmt. Diff. Vend. Entry No. Integer — DataClassification SystemMetadata
12425 Prepayment Document No. Code[20] — DataClassification SystemMetadata
12426 Prepayment Status Option — OptionCaption: ,Set,Reset; DataClassification SystemMetadata
12430 Vendor VAT Invoice No. Code[30] — DataClassification SystemMetadata
12431 Vendor VAT Invoice Date Date — DataClassification SystemMetadata
12432 Vendor VAT Invoice Rcvd Date Date — DataClassification SystemMetadata
12470 Vendor Receipts No. Code[20] — DataClassification SystemMetadata
12471 Vendor Receipts Date Date — DataClassification SystemMetadata
12485 VAT Adjusted Boolean — not editable; DataClassification SystemMetadata
12490 Agreement No. Code[20] — DataClassification SystemMetadata
14925 Realized VAT Amount Decimal — FlowField: sum(“VAT Entry”.Amount where(“CV Ledg. Entry No.” = field(“Entry No.”), Type = field(“Entry Type”), “Posting Date” = field(“Date Filter”), “VAT Settlement Type” = field(“Type Filter”), “Manual VAT Settlement” = const(true), “VAT Bus. Posting Group” = field(“VAT Bus. Posting Group Filter”), “VAT Prod…
14926 Unrealized VAT Amount Decimal — FlowField: sum(“VAT Entry”.“Unrealized Amount” where(Type = field(“Entry Type”), “CV Ledg. Entry No.” = field(“Entry No.”), “Posting Date” = field(“Date Filter”), “VAT Settlement Type” = field(“Type Filter”), “Manual VAT Settlement” = const(true), “VAT Bus. Posting Group” = field(“VAT Bus. Posting Group Filter…
14927 Realized VAT Base Decimal — FlowField: sum(“VAT Entry”.Base where(“CV Ledg. Entry No.” = field(“Entry No.”), Type = field(“Entry Type”), “Posting Date” = field(“Date Filter”), “VAT Settlement Type” = field(“Type Filter”), “Manual VAT Settlement” = const(true), “VAT Bus. Posting Group” = field(“VAT Bus. Posting Group Filter”), “VAT Prod. …
14928 Unrealized VAT Base Decimal — FlowField: sum(“VAT Entry”.“Unrealized Base” where(Type = field(“Entry Type”), “CV Ledg. Entry No.” = field(“Entry No.”), “Posting Date” = field(“Date Filter”), “VAT Settlement Type” = field(“Type Filter”), “Manual VAT Settlement” = const(true), “VAT Bus. Posting Group” = field(“VAT Bus. Posting Group Filter”)…
14929 VAT Amount To Allocate Decimal — FlowField: sum(“VAT Allocation Line”.Amount where(“CV Ledger Entry No.” = field(“Entry No.”), “VAT Settlement Type” = field(“Type Filter”), “VAT Bus. Posting Group” = field(“VAT Bus. Posting Group Filter”), “VAT Prod. Posting Group” = field(“VAT Prod. Posting Group Filter”)))
14930 Entry Type Enum “General Posting Type” — enum Enum 57 “General Posting Type”; DataClassification SystemMetadata
14931 Table ID Integer — DataClassification SystemMetadata
14932 Allocated VAT Amount Decimal — DataClassification SystemMetadata
14933 Type Filter Option — FlowFilter; OptionCaption: ,by Act,Future Expenses
14934 Changed Vendor VAT Invoice Boolean — not editable; DataClassification SystemMetadata
14935 VAT Bus. Posting Group Filter Code[20] — TableRelation VAT Business Posting Group; FlowFilter
14936 VAT Prod. Posting Group Filter Code[20] — TableRelation VAT Product Posting Group; FlowFilter

Keys

  • Key1: Entry No. (clustered)

Procedures

  • GetRemainingVATAmount(Type: Option Full,Base,Amount): Decimal
  • ShowCVEntry()
  • SetChangedVATInvoice()
  • ShowDimensions()

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 Document Entry Buffer"), 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.

Evidence 1 sources