BC Observatoryunofficial, made by waldo
tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 14901 "Vendor Agreement" (RU)

RU country layer

Open in Claude14901-ru.mdSource on GitHub

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 Vendor Agreement
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 Vendor No. Code[20] — TableRelation Vendor
2 No. Code[20] —
3 Description Text[250] —
4 External Agreement No. Text[30] —
5 Agreement Date Date —
6 Active Boolean —
7 Starting Date Date —
8 Expire Date Date —
9 Agreement Group Code[20] — TableRelation “Agreement Group”.Code where(Type = const(Purchases))
12 Comment Boolean — FlowField: exist(“Purch. Comment Line” where(“Document Type” = const(Agreement), “No.” = field(“No.”)))
14 Contact Text[100] —
15 Phone No. Text[30] —
16 Global Dimension 1 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
17 Global Dimension 2 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
21 Vendor Posting Group Code[20] — TableRelation Vendor Posting Group
22 Currency Code Code[10] — TableRelation Currency
24 Language Code Code[10] — TableRelation Language
27 Payment Terms Code Code[10] — TableRelation Payment Terms
29 Purchaser Code Code[20] — TableRelation Salesperson/Purchaser
35 Prices Including VAT Boolean —
39 Blocked Enum “Vendor Blocked” — enum Enum 140 “Vendor Blocked”
46 Priority Integer —
47 Payment Method Code Code[10] — TableRelation Payment Method
55 Date Filter Date — FlowFilter
56 Global Dimension 1 Filter Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1)); FlowFilter
57 Global Dimension 2 Filter Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2)); FlowFilter
58 Balance Decimal — FlowField: - sum(“Detailed Vendor Ledg. Entry”.Amount where(“Vendor No.” = field(“Vendor No.”), “Agreement No.” = field(“No.”))); not editable
59 Balance (LCY) Decimal — FlowField: - sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“Vendor No.”), “Agreement No.” = field(“No.”))); not editable
60 Net Change Decimal — FlowField: sum(“Detailed Vendor Ledg. Entry”.Amount where(“Vendor No.” = field(“Vendor No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Agreement No.” = field(“No.”))); not editable
61 Net Change (LCY) Decimal — FlowField: sum(“Detailed Vendor Ledg. Entry”.“Amount (LCY)” where(“Vendor No.” = field(“Vendor No.”), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filter”), “Agreement No.” = field(“No.”))); not editable
88 Gen. Bus. Posting Group Code[20] — TableRelation Gen. Business Posting Group
95 Order Address Code Code[10] — TableRelation “Order Address”.Code where(“Vendor No.” = field(“Vendor No.”))
97 Debit Amount Decimal — FlowField: sum(“Detailed Vendor Ledg. Entry”.“Debit Amount” where(“Vendor No.” = field(“Vendor No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filte…; not editable
98 Credit Amount Decimal — FlowField: sum(“Detailed Vendor Ledg. Entry”.“Credit Amount” where(“Vendor No.” = field(“Vendor No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date Filt…; not editable
99 Debit Amount (LCY) Decimal — FlowField: sum(“Detailed Vendor Ledg. Entry”.“Debit Amount (LCY)” where(“Vendor No.” = field(“Vendor No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Date…; not editable
100 Credit Amount (LCY) Decimal — FlowField: sum(“Detailed Vendor Ledg. Entry”.“Credit Amount (LCY)” where(“Vendor No.” = field(“Vendor No.”), “Entry Type” = filter(<> Application), “Initial Entry Global Dim. 1” = field(“Global Dimension 1 Filter”), “Initial Entry Global Dim. 2” = field(“Global Dimension 2 Filter”), “Posting Date” = field(“Dat…; not editable
102 E-Mail Text[80] Email caption
107 No. Series Code[20] — TableRelation No. Series
110 VAT Bus. Posting Group Code[20] — TableRelation VAT Business Posting Group
5700 Responsibility Center Code[10] — TableRelation Responsibility Center
5701 Location Code Code[10] — TableRelation Location where(“Use As In-Transit” = const(false))
12400 Default Bank Code Code[20] — TableRelation “Vendor Bank Account”.Code where(“Vendor No.” = field(“Vendor No.”))
12411 VAT Agent Prod. Posting Group Code[20] — TableRelation VAT Product Posting Group
12412 VAT Payment Source Type Option — OptionCaption: Vendor Funds,Internal Funds
12414 Tax Authority No. Code[20] — TableRelation Vendor where(“Vendor Type” = const(“Tax Authority”))
12425 G/L Account Filter Code[20] — TableRelation G/L Account; FlowFilter
12426 G/L Starting Date Filter Date — FlowFilter
12427 G/L Starting Balance Decimal — FlowField: sum(“G/L Entry”.Amount where(“Source Type” = const(Vendor), “Source No.” = field(“Vendor No.”), “Agreement No.” = field(“No.”), “G/L Account No.” = field(“G/L Account Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filte…; not editable
12428 G/L Net Change Decimal — FlowField: sum(“G/L Entry”.Amount where(“Source Type” = const(Vendor), “Source No.” = field(“Vendor No.”), “Agreement No.” = field(“No.”), “G/L Account No.” = field(“G/L Account Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filte…; not editable
12429 G/L Debit Amount Decimal — FlowField: sum(“G/L Entry”.“Debit Amount” where(“Source Type” = const(Vendor), “Source No.” = field(“Vendor No.”), “G/L Account No.” = field(“G/L Account Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Agreement No.” = f…; not editable
12430 G/L Credit Amount Decimal — FlowField: sum(“G/L Entry”.“Credit Amount” where(“Source Type” = const(Vendor), “Source No.” = field(“Vendor No.”), “G/L Account No.” = field(“G/L Account Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Agreement No.” = …; not editable
12431 G/L Balance to Date Decimal — FlowField: sum(“G/L Entry”.Amount where(“Source Type” = const(Vendor), “Source No.” = field(“Vendor No.”), “G/L Account No.” = field(“G/L Account Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Filter”), “Agreement No.” = field(“No…; not editable

Keys

  • Key1: Vendor No., No. (clustered)
  • Key2: Agreement Group, No.
  • Key3: No.

Procedures

  • AssistEdit(OldVendAgreement: Record "Vendor Agreement"): Boolean
  • ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
  • LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
  • CheckBlockedVendOnDocs(Vend2: Record Vendor; Transaction: Boolean)
  • CheckBlockedVendOnJnls(Vend2: Record Vendor; DocType: Option " ",Payment,Invoice,"Credit Memo","Finance Charge",Reminder,Refund; Transaction: Boolean)
  • VendBlockedErrorMessage(Vend2: Record Vendor; Transaction: Boolean)
  • VendPrivacyBlockedErrorMessage(Vend2: Record Vendor; Transaction: Boolean)
  • VendTransferFields()
  • VendTransferDimensions()
  • CheckDates()
  • GetDefaultDimSetID(DimSetID: Integer; var ShortcutDim1Code: Code[20]; var ShortcutDim2Code: Code[20]): Integer

Triggers

OnDelete, OnInsert, OnModify, OnRename

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: "Vendor Agreement"), 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