Customer Templ. #1381

Other table in Microsoft Dynamics 365 Business Central. 87 fields, 3 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Code.

All fields (87)

Customer Templ. — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Code PK	Code	Normal
2	Description	Text	Normal
5	Address	Text	Normal
6	Address 2	Text	Normal
7	City	Text	Normal
9	Phone No.	Text	Normal
10	Telex No.	Text	Normal
11	Document Sending Profile	Code	Normal	→ Document Sending Profile #60
14	Our Account No.	Text	Normal
15	Territory Code	Code	Normal	→ Territory #286
16	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
17	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
18	Chain Name	Code	Normal
19	Budgeted Amount	Decimal	Normal
20	Credit Limit (LCY)	Decimal	Normal
21	Customer Posting Group	Code	Normal	→ Customer Posting Group #92
22	Currency Code	Code	Normal	→ Currency #4
23	Customer Price Group	Code	Normal	→ Customer Price Group #6
24	Language Code	Code	Normal	→ Language #8
26	Statistics Group	Integer	Normal
27	Payment Terms Code	Code	Normal	→ Payment Terms #3
28	Fin. Charge Terms Code	Code	Normal	→ Finance Charge Terms #5
29	Salesperson Code	Code	Normal	→ Salesperson/Purchaser #13
30	Shipment Method Code	Code	Normal	→ Shipment Method #10
31	Shipping Agent Code	Code	Normal	→ Shipping Agent #291
32	Place of Export	Code	Normal
33	Invoice Disc. Code	Code	Normal	→ Customer #18
34	Customer Disc. Group	Code	Normal	→ Customer Discount Group #340
35	Country/Region Code	Code	Normal	→ Country/Region #9
36	Collection Method	Code	Normal
37	Amount	Decimal	Normal
39	Blocked	Option	Normal
42	Print Statements	Boolean	Normal
45	Bill-to Customer No.	Code	Normal	→ Customer #18
47	Payment Method Code	Code	Normal	→ Payment Method #289
48	Format Region	Text	Normal
80	Application Method	Option	Normal
82	Prices Including VAT	Boolean	Normal
83	Location Code	Code	Normal	→ Location #14
84	Fax No.	Text	Normal
85	Telex Answer Back	Text	Normal
86	VAT Registration No.	Text	Normal
87	Combine Sales Shipments	Boolean	Normal
88	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
90	GLN	Code	Normal
91	Post Code	Code	Normal
92	County	Text	Normal
93	EORI Number	Text	Normal
95	Use GLN in Electronic Documents	Boolean	Normal
102	Email	Text	Normal
103	Home Page	Text	Normal
104	Reminder Terms Code	Code	Normal	→ Reminder Terms #292
107	No. Series	Code	Normal	→ No. Series #308
108	Tax Area Code	Code	Normal	→ Tax Area #318
109	Tax Liable	Boolean	Normal
110	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
115	Reserve	Option	Normal
116	Block Payment Tolerance	Boolean	Normal
119	IC Partner Code	Code	Normal	→ IC Partner #413
124	Prepayment %	Decimal	Normal
132	Partner Type	Option	Normal
133	Intrastat Partner Type	Option	Normal
150	Privacy Blocked	Boolean	Normal
160	Disable Search by Name	Boolean	Normal
175	Allow Multiple Posting Groups	Boolean	Normal
840	Cash Flow Payment Terms Code	Code	Normal	→ Payment Terms #3
4810	Default Trans. Type	Code	Normal	→ Transaction Type #258
4811	Default Trans. Type - Returns	Code	Normal	→ Transaction Type #258
4812	Default Transport Method	Code	Normal	→ Transport Method #259
5050	Contact Type	Option	Normal
5061	Mobile Phone No.	Text	Normal
5700	Responsibility Center	Code	Normal	→ Responsibility Center #5714
5750	Shipping Advice	Option	Normal
5790	Shipping Time	DateFormula	Normal
5792	Shipping Agent Service Code	Code	Normal	→ Shipping Agent Services #5790
5900	Service Zone Code	Code	Normal	→ Service Zone #5957
5930	Combine Service Shipments	Boolean	Normal
7000	Price Calculation Method	Option	Normal
7001	Allow Line Disc.	Boolean	Normal
7600	Base Calendar Code	Code	Normal	→ Base Calendar #7600
7601	Copy Sell-to Addr. to Qte From	Option	Normal
7602	Validate EU VAT Reg. No.	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal