Table 1860 "C5 CustTable" (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 Customer
5	Name	Text[50]	—
6	Address1	Text[50]	Address 1 caption
7	Address2	Text[50]	Address 2 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	Code[10]	Invoice a/c caption
14	Group	Code[10]	—
15	FixedDiscPct	Decimal	Fixed discount pct. caption
16	Approved	Option	—
17	PriceGroup	Code[10]	Price group caption
18	DiscGroup	Code[10]	Discount group caption
19	CashDisc	Code[10]	Cash discount caption
20	ImageFile	Text[250]	Image caption
21	Currency	Code[3]	—
22	Language_	Option	Language caption
23	Payment	Code[10]	—
24	Delivery	Code[10]	—
25	Blocked	Option	Locked caption
26	SalesRep	Code[10]	Sales rep. caption
27	Vat	Code[10]	VAT caption
28	DEL_StatType	Option	DELETEStatistics caption
29	GiroNumber	Text[20]	FIK/Giro caption
30	VatNumber	Text[25]	VAT No. caption
31	Interest	Text[10]	—
32	Department	Code[10]	—
33	ReminderCode	Option	Max. reminder caption
34	OnetimeCustomer	Option	One-off customer caption
35	Inventory	Option	—
36	EDIAddress	Text[15]	EDI address caption
37	Balance	Decimal	—
38	Balance30	Decimal	0-30 days caption
39	Balance60	Decimal	31-60 days caption
40	Balance90	Decimal	61-90 days caption
41	Balance120	Decimal	91-120 days caption
42	Balance120Plus	Decimal	More than 120 days caption
43	AmountDue	Decimal	Due caption
44	CalculationDate	Date	Calculated caption
45	BalanceMax	Decimal	Max. balance caption
46	BalanceMST	Decimal	Balance LCY caption
47	SearchName	Text[30]	Search name caption
48	DEL_Transport	Option	DELETETransport caption
49	CashPayment	Option	Cash payment caption
50	PaymentMode	Text[10]	Paym. method caption
51	SalesGroup	Code[10]	Order group caption
52	ProjGroup	Code[10]	Project group caption
53	TradeCode	Text[10]	Transact. type caption
54	TransportCode	Text[10]	Transport caption
55	Email	Text[80]	—
56	URL	Text[80]	Homepage caption
57	CellPhone	Text[20]	Cell phone caption
58	KrakNumber	Text[15]	Krak no. caption
59	Centre	Code[10]	Cost centre caption
60	Purpose	Code[10]	—
61	EanNumber	Text[14]	EAN caption
62	DimAccountCode	Text[35]	A/c dimension caption
63	XMLInvoice	Option	OIOXML caption
64	LastInvoiceDate	Date	Invoice date caption
65	LastPaymentDate	Date	Payment caption
66	LastReminderDate	Date	Reminder caption
67	LastInterestDate	Date	Last Interest Date caption
68	LastInvoiceNumber	Text[20]	Invoice caption
69	XMLImport	Option	XML import caption
70	VatGroup	Code[10]	VAT group caption
71	StdAccount	Option	Default caption
72	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 CustTable"), 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 1860 "C5 CustTable" (DK)

Across versions

Fields

Keys

Ask your agent

Evidence 1 sources