Table 18 Customer in 21

Jonas Paprotka, Base Application 21.5.53619.63803, checked 2026-09-20

App: Base Application

Fields, 169 Keys, 20 Procedures, 65 Events, 54

Versions17 18 19 202122 23 24 25 26 27 28 latest

Source29

Fields, 169

Id	Name	Type	Obsolete
1	No.	Code[20]	-
2	Name	Text[100]	-
3	Search Name	Code[100]	-
4	Name 2	Text[50]	-
5	Address	Text[100]	-
6	Address 2	Text[50]	-
7	City	Text[30]	-
8	Contact	Text[100]	-
9	Phone No.	Text[30]	-
10	Telex No.	Text[20]	-
11	Document Sending Profile	Code[20]	-
12	Ship-to Code	Code[10]	-
14	Our Account No.	Text[20]	-
15	Territory Code	Code[10]	-
16	Global Dimension 1 Code	Code[20]	-
17	Global Dimension 2 Code	Code[20]	-
18	Chain Name	Code[10]	-
19	Budgeted Amount	Decimal	-
20	Credit Limit (LCY)	Decimal	-
21	Customer Posting Group	Code[20]	-
22	Currency Code	Code[10]	-
23	Customer Price Group	Code[10]	-
24	Language Code	Code[10]	-
25	Registration Number	Text[50]	-
26	Statistics Group	Integer	-
27	Payment Terms Code	Code[10]	-
28	Fin. Charge Terms Code	Code[10]	-
29	Salesperson Code	Code[20]	-
30	Shipment Method Code	Code[10]	-
31	Shipping Agent Code	Code[10]	-
32	Place of Export	Code[20]	-
33	Invoice Disc. Code	Code[20]	-
34	Customer Disc. Group	Code[20]	-
35	Country/Region Code	Code[10]	-
36	Collection Method	Code[20]	-
37	Amount	Decimal	-
38	Comment	Boolean	-
39	Blocked	Enum Customer Blocked	-
40	Invoice Copies	Integer	-
41	Last Statement No.	Integer	-
42	Print Statements	Boolean	-
45	Bill-to Customer No.	Code[20]	-
46	Priority	Integer	-
47	Payment Method Code	Code[10]	-
53	Last Modified Date Time	DateTime	-
54	Last Date Modified	Date	-
55	Date Filter	Date	-
56	Global Dimension 1 Filter	Code[20]	-
57	Global Dimension 2 Filter	Code[20]	-
58	Balance	Decimal	-
59	Balance (LCY)	Decimal	-
60	Net Change	Decimal	-
61	Net Change (LCY)	Decimal	-
62	Sales (LCY)	Decimal	-
63	Profit (LCY)	Decimal	-
64	Inv. Discounts (LCY)	Decimal	-
65	Pmt. Discounts (LCY)	Decimal	-
66	Balance Due	Decimal	-
67	Balance Due (LCY)	Decimal	-
69	Payments	Decimal	-
70	Invoice Amounts	Decimal	-
71	Cr. Memo Amounts	Decimal	-
72	Finance Charge Memo Amounts	Decimal	-
74	Payments (LCY)	Decimal	-
75	Inv. Amounts (LCY)	Decimal	-
76	Cr. Memo Amounts (LCY)	Decimal	-
77	Fin. Charge Memo Amounts (LCY)	Decimal	-
78	Outstanding Orders	Decimal	-
79	Shipped Not Invoiced	Decimal	-
80	Application Method	Enum Application Method	-
82	Prices Including VAT	Boolean	-
83	Location Code	Code[10]	-
84	Fax No.	Text[30]	-
85	Telex Answer Back	Text[20]	-
86	VAT Registration No.	Text[20]	-
87	Combine Shipments	Boolean	-
88	Gen. Bus. Posting Group	Code[20]	-
89	Picture	Blob	Removed 19.0
Replaced by Image field
90	GLN	Code[13]	-
91	Post Code	Code[20]	-
92	County	Text[30]	-
93	EORI Number	Text[40]	-
95	Use GLN in Electronic Document	Boolean	-
97	Debit Amount	Decimal	-
98	Credit Amount	Decimal	-
99	Debit Amount (LCY)	Decimal	-
100	Credit Amount (LCY)	Decimal	-
102	E-Mail	Text[80]	-
103	Home Page	Text[80]	-
104	Reminder Terms Code	Code[10]	-
105	Reminder Amounts	Decimal	-
106	Reminder Amounts (LCY)	Decimal	-
107	No. Series	Code[20]	-
108	Tax Area Code	Code[20]	-
109	Tax Liable	Boolean	-
110	VAT Bus. Posting Group	Code[20]	-
111	Currency Filter	Code[10]	-
113	Outstanding Orders (LCY)	Decimal	-
114	Shipped Not Invoiced (LCY)	Decimal	-
115	Reserve	Enum Reserve Method	-
116	Block Payment Tolerance	Boolean	-
117	Pmt. Disc. Tolerance (LCY)	Decimal	-
118	Pmt. Tolerance (LCY)	Decimal	-
119	IC Partner Code	Code[20]	-
120	Refunds	Decimal	-
121	Refunds (LCY)	Decimal	-
122	Other Amounts	Decimal	-
123	Other Amounts (LCY)	Decimal	-
124	Prepayment %	Decimal	-
125	Outstanding Invoices (LCY)	Decimal	-
126	Outstanding Invoices	Decimal	-
130	Bill-to No. Of Archived Doc.	Integer	-
131	Sell-to No. Of Archived Doc.	Integer	-
132	Partner Type	Enum Partner Type	-
133	Intrastat Partner Type	Enum Partner Type	-
140	Image	Media	-
150	Privacy Blocked	Boolean	-
160	Disable Search by Name	Boolean	-
288	Preferred Bank Account Code	Code[20]	-
720	Coupled to CRM	Boolean	-
840	Cash Flow Payment Terms Code	Code[10]	-
5049	Primary Contact No.	Code[20]	-
5050	Contact Type	Enum Contact Type	-
5061	Mobile Phone No.	Text[30]	-
5700	Responsibility Center	Code[10]	-
5750	Shipping Advice	Enum Sales Header Shipping Advice	-
5790	Shipping Time	DateFormula	-
5792	Shipping Agent Service Code	Code[10]	-
5900	Service Zone Code	Code[10]	-
5902	Contract Gain/Loss Amount	Decimal	-
5903	Ship-to Filter	Code[10]	-
5910	Outstanding Serv. Orders (LCY)	Decimal	-
5911	Serv Shipped Not Invoiced(LCY)	Decimal	-
5912	Outstanding Serv.Invoices(LCY)	Decimal	-
7000	Price Calculation Method	Enum Price Calculation Method	-
7001	Allow Line Disc.	Boolean	-
7171	No. of Quotes	Integer	-
7172	No. of Blanket Orders	Integer	-
7173	No. of Orders	Integer	-
7174	No. of Invoices	Integer	-
7175	No. of Return Orders	Integer	-
7176	No. of Credit Memos	Integer	-
7177	No. of Pstd. Shipments	Integer	-
7178	No. of Pstd. Invoices	Integer	-
7179	No. of Pstd. Return Receipts	Integer	-
7180	No. of Pstd. Credit Memos	Integer	-
7181	No. of Ship-to Addresses	Integer	-
7182	Bill-To No. of Quotes	Integer	-
7183	Bill-To No. of Blanket Orders	Integer	-
7184	Bill-To No. of Orders	Integer	-
7185	Bill-To No. of Invoices	Integer	-
7186	Bill-To No. of Return Orders	Integer	-
7187	Bill-To No. of Credit Memos	Integer	-
7188	Bill-To No. of Pstd. Shipments	Integer	-
7189	Bill-To No. of Pstd. Invoices	Integer	-
7190	Bill-To No. of Pstd. Return R.	Integer	-
7191	Bill-To No. of Pstd. Cr. Memos	Integer	-
7600	Base Calendar Code	Code[10]	-
7601	Copy Sell-to Addr. to Qte From	Enum Contact Type	-
7602	Validate EU Vat Reg. No.	Boolean	-
8000	Id	Guid	Pending 15.0
This functionality will be replaced by the systemID field
8001	Currency Id	Guid	-
8002	Payment Terms Id	Guid	-
8003	Shipment Method Id	Guid	-
8004	Payment Method Id	Guid	-
9003	Tax Area ID	Guid	-
9004	Tax Area Display Name	Text[100]	Removed 15.0
This field is not needed and it should not be used.
9005	Contact ID	Guid	-
9006	Contact Graph Id	Text[250]	-

Keys, 20

Name	Fields	Obsolete
Key1, clustered	No.	-
Key2	Search Name	-
Key3	Customer Posting Group	-
Key4	Currency Code	-
Key5	Country/Region Code	-
Key6	Gen. Bus. Posting Group	-
Key7	Name, Address, City	-
Key8	VAT Registration No.	-
Key9	Name	-
Key10	City	-
Key11	Post Code	-
Key12	Phone No.	-
Key13	Contact	-
Key14	Blocked	-
Key15	Primary Contact No.	-
Key16	Salesperson Code	-
Key17	SystemModifiedAt	-
Key20	Partner Type, Country/Region Code	-
Key21	Coupled to CRM	-
Key22	IC Partner Code	-

Procedures, 65

Name	Parameters	Returns	Access	Obsolete
AssistEdit	(Record Customer)	Boolean	public	-
ValidateShortcutDimCode	(Integer, var Code[20])		public	-
ShowContact	()		public	-
SetInsertFromContact	(Boolean)		public	-
CheckBlockedCustOnDocs	(Record Customer, Enum Sales Document Type, Boolean, Boolean)		public	-
CheckBlockedCustOnJnls	(Record Customer, Enum Gen. Journal Document Type, Boolean)		public	-
CustBlockedErrorMessage	(Record Customer, Boolean)		public	-
CustPrivacyBlockedErrorMessage	(Record Customer, Boolean)		public	-
GetPrivacyBlockedGenericErrorText	(Record Customer)	Text[250]	public	-
DisplayMap	()		public	-
GetPriceCalculationMethod	()	Enum Price Calculation Method	public	-
GetTotalAmountLCY	()	Decimal	public	-
GetTotalAmountLCYUI	()	Decimal	public	-
GetSalesLCY	()	Decimal	public	-
CalcAvailableCredit	()	Decimal	public	-
CalcAvailableCreditUI	()	Decimal	public	-
CalcOverdueBalance	()	Decimal	public	-
GetLegalEntityType	()	Text	public	-
GetLegalEntityTypeLbl	()	Text	public	-
SetStyle	()	Text	public	-
HasValidDDMandate	(Date)	Boolean	public	-
GetReturnRcdNotInvAmountLCY	()	Decimal	public	-
GetInvoicedPrepmtAmountLCY	()	Decimal	public	-
CalcCreditLimitLCYExpendedPct	()	Decimal	public	-
CreateAndShowNewInvoice	()		public	-
CreateAndShowNewOrder	()		public	-
CreateAndShowNewCreditMemo	()		public	-
CreateAndShowNewQuote	()		public	-
GetBillToCustomerNo	()	Code[20]	public	-
HasAddressIgnoreCountryCode	()	Boolean	public	-
HasAddress	()	Boolean	public	-
HasDifferentAddress	(Record Customer)	Boolean	public	-
GetCustNo	(Text)	Text	public	-
GetCustNoOpenCard	(Text, Boolean, Boolean)	Code[20]	public	-
CreateNewCustomer	(Text[100], Boolean)	Code[20]	public	-
SelectCustomer	(var Record Customer)	Boolean	public	-
LookupCustomer	(var Record Customer)	Boolean	public	-
OpenCustomerLedgerEntries	(Boolean)		public	-
SetInsertFromTemplate	(Boolean)		public	-
IsLookupRequested	()	Boolean	public	-
IsBlocked	()	Boolean	public	-
HasAnyOpenOrPostedDocuments	()	Boolean	public	-
GetInsertFromContact	()	Boolean	public	-
GetInsertFromTemplate	()	Boolean	public	-
SetAddress	(Text[100], Text[50], Code[20], Text[30], Text[30], Code[10], Text[100])		public	-
FindByEmail	(var Record Customer, Text)	Boolean	public	-
UpdateReferencedIds	()		public	-
GetReferencedIds	(var Record Field)		public	-
SetForceUpdateContact	(Boolean)		public	-
UpdateCurrencyId	()		public	-
UpdatePaymentTermsId	()		public	-
UpdateShipmentMethodId	()		public	-
UpdatePaymentMethodId	()		public	-
UpdateTaxAreaId	()		public	-
CheckBlockedCustOnJnls	(Record Customer, var Record Gen. Journal Line, Boolean)		public	-
GetPrimaryContact	(Code[20], var Record Contact)		public	-
ToPriceSource	(var Record Price Source)		public	-
CopyFromNewCustomerTemplate	(Record Customer Templ.)		public	-
IsContactUpdateNeeded	()	Boolean	public	-
SetDefaultSalesperson	()		protected	-
VATRegistrationValidation	()		public	-
GetTopCustomerHeadlineQueryDocumentTypeFilter	()	Text	public	-
GetBalanceAsVendor	(var Code[20])	Decimal	public	-
GetLinkedVendor	()	Code[20]	public	-
SetLastModifiedDateTime	()		protected	-

Events, 54

Kind	Name	Parameters	Obsolete
Integration event	OnAfterHasAnyOpenOrPostedDocuments	(var Record Customer, var Boolean)	-
Integration event	OnAfterLookupCity	(var Record Customer, var Record Post Code)	-
Integration event	OnAfterSetLastModifiedDateTime	(var Record Customer)	-
Integration event	OnAfterValidateCity	(var Record Customer, Record Customer)	-
Integration event	OnAfterValidatePostCode	(var Record Customer, Record Customer)	-
Integration event	OnAfterValidateShortcutDimCode	(var Record Customer, var Record Customer, Integer, var Code[20])	-
Integration event	OnAssistEditOnBeforeExit	(var Record Customer)	-
Integration event	OnBeforeCheckBlockedCust	(Record Customer, Option, Option, Boolean, Boolean, var Boolean)	-
Integration event	OnBeforeCreateNewCustomer	(Text[100], Boolean, var Code[20], var Boolean)	-
Integration event	OnBeforeCalcOverdueBalance	(var Record Customer, var Decimal, var Boolean)	-
Integration event	OnBeforeGetInvoicedPrepmtAmountLCY	(var Record Customer, var Decimal, var Boolean)	-
Integration event	OnBeforeGetTotalAmountLCY	(var Record Customer, var Decimal, var Boolean)	-
Integration event	OnBeforeGetTotalAmountLCYUI	(var Record Customer)	-
Integration event	OnBeforeGetTotalAmountLCYCommon	(var Record Customer, var Decimal, var Boolean)	-
Integration event	OnBeforeGetSalesLCY	(var Record Customer, var Record Customer, var Decimal, var Boolean)	-
Integration event	OnBeforeInsert	(var Record Customer, var Boolean)	-
Integration event	OnBeforeLookupCity	(var Record Customer, var Record Post Code)	-
Integration event	OnBeforeLookupPostCode	(var Record Customer, var Record Post Code)	-
Integration event	OnBeforeOpenCustomerLedgerEntries	(var Record Customer, var Record Detailed Cust. Ledg. Entry, Boolean, var Boolean)	-
Integration event	OnBeforeSetDefaultSalesperson	(var Record Customer, var Boolean)	-
Integration event	OnBeforeValidateShortcutDimCode	(var Record Customer, var Record Customer, Integer, var Code[20], var Boolean)	-
Integration event	OnBeforeVATRegistrationValidation	(var Record Customer, var Boolean)	-
Integration event	OnGetCustNoOpenCardOnBeforeCustomerFindSet	(var Record Customer)	-
Integration event	OnGetCustNoOpenCardOnBeforeFilterCustomer	(var Record Customer)	-
Integration event	OnGetCustNoOpenCardOnAfterSetCustomerFilters	(var Record Customer, var Text)	-
Integration event	OnMarkCustomersWithSimilarNameOnBeforeCustomerFindSet	(var Record Customer)	-
Integration event	OnBeforeCheckCustomerContactRelation	(Record Contact, Record Contact Business Relation, var Boolean)	-
Integration event	OnBeforeValidateEmail	(var Record Customer, var Boolean, Record Customer)	-
Integration event	OnShowContactOnBeforeOpenContactCard	(var Record Contact, var Integer)	-
Integration event	OnShowContactOnBeforeOpenContactList	(var Record Contact, var Integer)	-
Integration event	OnBeforeIsContactUpdateNeeded	(Record Customer, Record Customer, var Boolean, Boolean)	-
Integration event	OnAfterCopyFromNewCustomerTemplate	(var Record Customer, Record Customer Templ.)	-
Integration event	OnAfterOnInsert	(var Record Customer, Record Customer)	-
Integration event	OnBeforeCheckBlockedCustOnJnls	(Record Customer, var Record Gen. Journal Line, Boolean, var Boolean)	-
Integration event	OnBeforeOnDelete	(var Record Customer, var Boolean)	-
Integration event	OnBeforeValidateVATRegistrationNo	(var Record Customer, Record Customer, Integer, var Boolean)	-
Integration event	OnGetCustNoOpenCardOnAfterOnAfterCustomerFilterFromStart	(var Record Customer)	-
Integration event	OnBeforeCustBlockedErrorMessage	(Record Customer, Boolean, var Boolean)	-
Integration event	OnBeforeGetCustNoOpenCard	(Text, Boolean, var Boolean, var Code[20], var Boolean)	-
Integration event	OnBeforeLookupContactList	(var Record Customer, var Boolean)	-
Integration event	OnBeforeTestNoSeries	(var Record Customer, Record Customer, var Boolean)	-
Integration event	OnBeforeUpdateDirectDebitPmtTermsCode	(var Record Customer, var Boolean)	-
Integration event	OnBeforeValidateContact	(var Boolean, var Record Customer)	-
Integration event	OnBeforeCalcAvailableCreditCommon	(var Record Customer, Boolean, var Decimal)	-
Integration event	OnAfterGetTopCustomerHeadlineQueryDocumentTypeFilter	(var Text)	-
Integration event	OnAfterHasAddressIgnoreCountryCode	(Record Customer, var Boolean)	-
Integration event	OnAfterHasDifferentAddress	(Record Customer, Record Customer, var Boolean)	-
Integration event	OnBeforeCheckIfOrderSalesLinesExist	(var Record Customer, var Boolean)	-
Integration event	OnBeforeOnRename	(var Record Customer, Record Customer, var Boolean)	-
Integration event	OnGetBalanceAsVendorOnBeforeCalcBalance	(var Record Vendor)	-
Integration event	OnAfterLookupPostCode	(var Record Customer, Record Customer, var Record Post Code)	-
Integration event	OnBeforeValidateCity	(var Record Customer, var Record Post Code, Integer, var Boolean)	-
Integration event	OnBeforeValidatePostCode	(var Record Customer, var Record Post Code, Integer, var Boolean)	-
Integration event	OnBeforeValidateRegistrationNumber	(var Record Customer, var Boolean)	-