Objects/Tables/Table 1381 Customer Templ.

Table 1381 Customer Templ. in 24

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

App: Base Application
Namespace: Microsoft.Sales.Customer

Fields, 76 Keys, 1 Procedures, 1 Events, 2

Versions17 18 19 20 21 22 232425 26 27 28 latest

Source29

Fields, 76

Id	Name	Type	Obsolete
1	Code	Code[20]	-
2	Description	Text[100]	-
5	Address	Text[100]	-
6	Address 2	Text[50]	-
7	City	Text[30]	-
9	Phone No.	Text[30]	-
10	Telex No.	Text[20]	-
11	Document Sending Profile	Code[20]	-
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]	-
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	-
39	Blocked	Enum Customer Blocked	-
42	Print Statements	Boolean	-
45	Bill-to Customer No.	Code[20]	-
47	Payment Method Code	Code[10]	-
48	Format Region	Text[80]	-
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]	-
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	-
102	E-Mail	Text[80]	-
103	Home Page	Text[80]	Pending 24.0
Field length will be increased to 255.
104	Reminder Terms Code	Code[10]	-
107	No. Series	Code[20]	-
108	Tax Area Code	Code[20]	-
109	Tax Liable	Boolean	-
110	VAT Bus. Posting Group	Code[20]	-
115	Reserve	Enum Reserve Method	-
116	Block Payment Tolerance	Boolean	-
119	IC Partner Code	Code[20]	-
124	Prepayment %	Decimal	-
132	Partner Type	Enum Partner Type	-
133	Intrastat Partner Type	Enum Partner Type	-
150	Privacy Blocked	Boolean	-
160	Disable Search by Name	Boolean	-
840	Cash Flow Payment Terms Code	Code[10]	-
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]	-
7001	Allow Line Disc.	Boolean	-
7600	Base Calendar Code	Code[10]	-
7601	Copy Sell-to Addr. to Qte From	Enum Contact Type	-
7602	Validate EU Vat Reg. No.	Boolean	-

Keys, 1

Name	Fields	Obsolete
Key1, clustered	Code	-

Procedures, 1

Name	Parameters	Returns	Access	Obsolete
CopyFromTemplate	(Record Customer Templ.)		public	-

Events, 2

Kind	Name	Parameters	Obsolete
Integration event	OnAfterCopyFromTemplate	(Record Customer Templ., var Record Customer Templ.)	-
Integration event	OnCopyTemplateOnBeforeModify	(Record Customer Templ., Record Customer Templ., var Record Customer Templ.)	-