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

Table 1890 "C5 InvenTrans" (DK)

DK country layer · Microsoft.DataMigration.C5

Open in Claude1890-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 ItemNumber Text[20] Item number caption
4 BudgetCode Option Budget code caption
5 InvenLocation Text[10] Location caption
6 Date_ Date Date caption
7 Qty Decimal —
8 DutyAmount Decimal Duty amount caption
9 Discount Decimal —
10 AmountMST Decimal Amount in LCY caption
11 AmountCur Decimal Amount in currency caption
12 Currency Code[3] —
13 Voucher Integer —
14 InvoiceNumber Text[20] Invoice caption
15 Module Option —
16 Number Text[10] —
17 Account Text[10] —
18 Department Code[10] —
19 Employee Text[10] —
20 Txt Text[40] Text caption
21 InOutflow Option Movement caption
22 CostAmount Decimal Cost value in LCY caption
23 SerialNumber Code[20] Serial/Batch number caption
24 SettledQty Decimal Settled qty caption
25 SettledAmount Decimal Settled amount caption
26 InvestTax Decimal Invest. duty caption
27 PostedDiffAmount Decimal Adjustment caption
28 Open Option —
29 InvenTransType Option Entry type caption
30 RefRecId Integer EntryRef caption
31 Transaction Integer —
32 InvenStatus Option Status caption
33 PackingSlip Text[20] Packing slip caption
34 InvenItemGroup Code[10] Item group caption
35 CustVendGroup Code[10] Cust./Vend. Group caption
36 DiscAmount Decimal Disc. amount caption
37 LedgerAccount Text[10] G/L account caption
38 CostType Text[10] Cost type caption
39 CommissionAmount Decimal Commission amount caption
40 CommissionSettled Option Commission settled caption
41 Vat Code[10] VAT caption
42 ProjCostPLPosted Decimal P/L posted in project caption
43 ProjCostPLAcc Text[10] Cost P/L a/c caption
44 COGSAccount Text[10] COGS account caption
45 InventoryAcc Text[10] Inventory a/c caption
46 ProfitLossAmount Decimal Loss/Profit caption
47 DEL_DutyCode Text[10] DELETEDuty caption
48 ExchRate Decimal Exch. rate caption
49 ExchRateTri Decimal Tri rate caption
50 DELETED Decimal Deleted caption
51 Centre Code[10] Cost centre caption
52 Purpose Code[10] —
53 LineNumber Decimal Orig linenumber caption
54 ReversedQty Decimal Reversed quantity caption
55 ReversedAmount Decimal Reversed amount caption
56 TmpFunction Integer Tmp function caption
57 CollectNumber Text[10] Collective number caption
58 SkipSettle Option Exclude from settlement caption

Keys

  • PK: RecId (clustered)
  • ItemNumberKey: ItemNumber

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 InvenTrans"), 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