Table 1861 "C5 VendTable" (DK)

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

Keys

PK: RecId (clustered)

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.

Table 1861 "C5 VendTable" (DK)

Across versions

Fields

Keys

Ask your agent

Evidence 1 sources