Table 14927 "VAT Document Entry Buffer" (RU)
RU country layer
Across versions
- BC23-28not present
- 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): DecimalShowCVEntry()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.