BC Observatoryunofficial, made by waldo
tableAdministration & Setupofficial - Microsoftderived - from the source, no model text

Table 1894 "C5 VendTrans" (DK)

DK country layer · Microsoft.DataMigration.C5

Open in Claude1894-dk.mdSource on GitHub

Across versions

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

DK country layer · Microsoft.DataMigration.C5 · BC29-30 · source at ea08af5e · facts from BC29

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

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 RecId Integer Row number caption
2 LastChanged Date Last changed caption
3 BudgetCode Option Budget code caption
4 Account Code[10] —
5 Department Code[10] —
6 Date_ Date Date caption
7 Voucher Integer —
8 Txt Text[40] Text caption
9 TransType Option Entry type caption
10 AmountMST Decimal Amount in LCY caption
11 AmountCur Decimal Amount in currency caption
12 Currency Code[3] —
13 Vat Code[10] VAT caption
14 VatAmount Decimal VAT amount caption
15 Approved Option —
16 ApprovedBy Text[10] Approved by caption DataClassification EndUserIdentifiableInformation
17 CashDiscAmount Decimal Cash discount caption
18 CashDiscDate Date Cash disc. date caption
19 DueDate Date Due caption
20 Open Option —
21 ExchRate Decimal Exch. rate caption
22 RESERVED3 Decimal —
23 RESERVED4 Decimal —
24 PostedDiffAmount Decimal Diff. posted caption
25 InvoiceNumber Text[20] Invoice caption
26 RESERVED1 Option —
27 RefRecId Integer RefRecID caption
28 Transaction Integer —
29 RESERVED6 Option —
30 PaymId Text[20] Identification caption
31 ProcessingDate Date Processing date caption
32 CashDisc Text[10] Cash discount caption
33 PaymentMode Text[10] Paym. method caption
34 PaymSpec Text[10] Paym. spec. caption
35 ExchRateTri Decimal Tri rate caption
36 Centre Code[10] Cost centre caption
37 Purpose Code[10] —

Keys

  • PK: RecId (clustered)
  • AccountKey: Account

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

A DK 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