---
id: object/table/1861-dk
type: object
title: Table 1861 "C5 VendTable" (DK)
summary: Table 1861 "C5 VendTable" (DK) in the DK country layer (Microsoft.DataMigration.C5). 74 fields. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - dk layer
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 8751683788c3db0bcbd8177c4ec0531052351b688889db9bc92dc454c058d025
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/DK/C52012DataMigration/app/src/vendors/C5VendTable.Table.al
    title: src/Apps/DK/C52012DataMigration/app/src/vendors/C5VendTable.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations:
    - localization/dk
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 1861
name: C5 VendTable
namespace: Microsoft.DataMigration.C5
app: C52012DataMigration
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
country: DK
counts:
  fields: 74
  procedures: 0
  events: 0
  subscribers: 0
relations:
  out: 0
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
---

# Table 1861 "C5 VendTable" (DK)

> Table 1861 "C5 VendTable" (DK) in the DK country layer (Microsoft.DataMigration.C5). 74 fields. Introduced in BC29, still in BC30.

DK country layer · Microsoft.DataMigration.C5 · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/DK/C52012DataMigration/app/src/vendors/C5VendTable.Table.al) · facts from BC29

An object of the [DK localization](../../localizations/dk.md), 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 <small>caption</small> |  |
| 2 | LastChanged | Date | Last changed <small>caption</small> |  |
| 3 | DEL_UserLock | Integer | Lock <small>caption</small> |  |
| 4 | Account | Code[10] | — | TableRelation Vendor |
| 5 | Name | Text[50] | — |  |
| 6 | Address1 | Text[50] | Address <small>caption</small> |  |
| 7 | Address2 | Text[50] | Address <small>caption</small> |  |
| 8 | ZipCity | Text[50] | Zip code/City <small>caption</small> |  |
| 9 | Country | Text[30] | Country/region <small>caption</small> |  |
| 10 | Attention | Text[30] | — |  |
| 11 | Phone | Text[20] | — |  |
| 12 | Fax | Text[20] | — |  |
| 13 | InvoiceAccount | Text[10] | Invoice a/c <small>caption</small> |  |
| 14 | Group | Code[10] | — |  |
| 15 | FixedDiscPct | Decimal | Fixed discount <small>caption</small> |  |
| 16 | DiscGroup | Code[10] | Discount group <small>caption</small> |  |
| 17 | CashDisc | Code[10] | Cash discount <small>caption</small> |  |
| 18 | Approved | Option | — |  |
| 19 | DEL_ExclDuty | Option | Excl. duty <small>caption</small> |  |
| 20 | InclVat | Option | Incl. VAT <small>caption</small> |  |
| 21 | Currency | Code[3] | — |  |
| 22 | Language_ | Option | Language <small>caption</small> |  |
| 23 | Payment | Code[10] | — |  |
| 24 | Delivery | Code[10] | — |  |
| 25 | Interest | Text[10] | — |  |
| 26 | Blocked | Option | Locked <small>caption</small> |  |
| 27 | Purchaser | Code[10] | — |  |
| 28 | Vat | Code[10] | VAT <small>caption</small> |  |
| 29 | DEL_StatType | Option | DELETEStatistics <small>caption</small> |  |
| 30 | ESRnumber | Text[10] | Nets no. <small>caption</small> |  |
| 31 | GiroNumber | Text[20] | FIK/Giro <small>caption</small> |  |
| 32 | OurAccount | Text[15] | Our a/c <small>caption</small> |  |
| 33 | BankAccount | Text[15] | Bank a/c <small>caption</small> |  |
| 34 | VatNumber | Text[25] | VAT No. <small>caption</small> |  |
| 35 | Department | Code[10] | — |  |
| 36 | OnetimeSupplier | Option | One-off vendor <small>caption</small> |  |
| 37 | ImageFile | Text[250] | Image <small>caption</small> |  |
| 38 | Inventory | Option | — |  |
| 39 | EDIAddress | Text[15] | EDI address <small>caption</small> |  |
| 40 | Balance | Decimal | — |  |
| 41 | Balance30 | Decimal | 0-30 days <small>caption</small> |  |
| 42 | Balance60 | Decimal | 31-60 days <small>caption</small> |  |
| 43 | Balance90 | Decimal | 61-90 days <small>caption</small> |  |
| 44 | Balance120 | Decimal | 91-120 days <small>caption</small> |  |
| 45 | Balance120Plus | Decimal | More than 120 days <small>caption</small> |  |
| 46 | AmountDue | Decimal | Due <small>caption</small> |  |
| 47 | CalculationDate | Date | Calculated <small>caption</small> |  |
| 48 | BalanceMax | Decimal | Max. balance <small>caption</small> |  |
| 49 | BalanceMST | Decimal | Balance LCY <small>caption</small> |  |
| 50 | SearchName | Text[30] | Search name <small>caption</small> |  |
| 51 | DEL_Transport | Option | DELETETransport <small>caption</small> |  |
| 52 | CashPayment | Option | Cash payment <small>caption</small> |  |
| 53 | PaymentMode | Text[10] | Paym. method <small>caption</small> |  |
| 54 | PaymSpec | Text[10] | Paym. spec. <small>caption</small> |  |
| 55 | Telex | Text[20] | — |  |
| 56 | PaymId | Text[20] | PaymID <small>caption</small> |  |
| 57 | PurchGroup | Code[10] | Purchase group <small>caption</small> |  |
| 58 | TradeCode | Text[10] | Transact. type <small>caption</small> |  |
| 59 | TransportCode | Code[10] | Transport <small>caption</small> |  |
| 60 | Email | Text[80] | — |  |
| 61 | URL | Text[80] | Homepage <small>caption</small> |  |
| 62 | CellPhone | Text[20] | Cell phone <small>caption</small> |  |
| 63 | KrakNumber | Text[15] | Krak no. <small>caption</small> |  |
| 64 | Centre | Code[10] | Cost centre <small>caption</small> |  |
| 65 | Purpose | Code[10] | — |  |
| 66 | LastInvoiceDate | Date | Invoice date <small>caption</small> |  |
| 67 | LastPaymentDate | Date | Payment <small>caption</small> |  |
| 68 | LastInvoiceNumber | Text[20] | Invoice <small>caption</small> |  |
| 69 | XMLImport | Option | XML import <small>caption</small> |  |
| 70 | EanNumber | Text[14] | EAN <small>caption</small> |  |
| 71 | VatGroup | Code[10] | VAT group <small>caption</small> |  |
| 72 | CardType | Text[2] | Card type <small>caption</small> |  |
| 73 | StdAccount | Option | Default <small>caption</small> |  |
| 74 | VatNumberType | Text[10] | VAT number type <small>caption</small> |  |

## Keys

- PK: RecId (clustered)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## 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 VendTable")`, 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.
