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

Table 1892 "C5 CustTrans" (DK)

DK country layer · Microsoft.DataMigration.C5

Open in Claude1892-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 InvoiceNumber Text[20] Invoice caption
8 Voucher Integer —
9 Txt Text[40] Text caption
10 TransType Option Entry type caption
11 AmountMST Decimal Amount in LCY caption
12 AmountCur Decimal Amount in currency caption
13 Currency Code[3] —
14 Vat Code[10] VAT caption
15 VatAmount Decimal VAT amount caption
16 Approved Option —
17 ApprovedBy Text[10] Approved by caption DataClassification EndUserIdentifiableInformation
18 CashDiscAmount Decimal Cash discount caption
19 CashDiscDate Date Cash disc. date caption
20 DueDate Date Due caption
21 Open Option —
22 ExchRate Decimal Exch. rate caption
23 RESERVED2 Decimal —
24 RESERVED3 Decimal —
25 PostedDiffAmount Decimal Diff. posted caption
26 RefRecID Integer —
27 Transaction Integer —
28 ReminderCode Option Reminder code caption
29 CashDisc Text[10] Cash discount caption
30 RemindedDate Date Reminder date caption
31 ExchRateTri Decimal Tri rate caption
32 PaymentId Text[30] Payment ID caption
33 Centre Code[10] Cost centre caption
34 Purpose Code[10] —
35 PaymentMode Text[10] Paym. method caption

Keys

  • PK: RecId (clustered)
  • AccounttKey: 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 CustTrans"), 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