Vendor Templ. #1383

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

70
Fields
3
Records
1
Primary key
0
FlowFields
31
Relations
Open in Data Explorer →

Primary key

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

All fields (70)

Vendor Templ. — FIELDS
NO.FIELDTYPECLASSRELATION
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
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
19 Budgeted Amount Decimal Normal
21 Vendor Posting Group Code Normal → Vendor Posting Group #93
22 Currency Code Code Normal → Currency #4
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 Purchaser Code Code Normal → Salesperson/Purchaser #13
30 Shipment Method Code Code Normal → Shipment Method #10
31 Shipping Agent Code Code Normal → Shipping Agent #291
33 Invoice Disc. Code Code Normal → Vendor #23
35 Country/Region Code Code Normal → Country/Region #9
39 Blocked Option Normal
45 Pay-to Vendor No. Code Normal → Vendor #23
46 Priority Integer Normal
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
84 Fax No. Text Normal
85 Telex Answer Back Text Normal
86 VAT Registration No. Text 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
102 Email Text Normal
103 Home Page Text Normal
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
116 Block Payment Tolerance Boolean Normal
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
170 Creditor No. Code 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
5701 Location Code Code Normal → Location #14
7000 Price Calculation Method Option Normal
7600 Base Calendar Code Code Normal → Base Calendar #7600
7601 Document Sending Profile Code Normal → Document Sending Profile #60
7602 Validate EU VAT Reg. No. Boolean Normal
8510 Over-Receipt Code Code Normal → Over-Receipt Code #8510
10501 Exclude from Payment Practices Report 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

Related tables (26)

Tables referenced by fields on the Vendor Templ. table through TableRelation properties.

Territory
#286 · Other · via Territory Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Vendor Posting Group
#93 · Other · via Vendor Posting Group
Currency
#4 · General Ledger · via Currency Code
Language
#8 · General Ledger · via Language Code
Payment Terms
#3 · General Ledger · via Payment Terms Code, Cash Flow Payment Terms Code
Finance Charge Terms
#5 · General Ledger · via Fin. Charge Terms Code
Salesperson/Purchaser
#13 · General Ledger · via Purchaser Code
Shipment Method
#10 · General Ledger · via Shipment Method Code
Shipping Agent
#291 · Other · via Shipping Agent Code
Vendor
#23 · Purchasing · via Invoice Disc. Code, Pay-to Vendor No.
Country/Region
#9 · General Ledger · via Country/Region Code
Payment Method
#289 · Other · via Payment Method Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
No. Series
#308 · Other · via No. Series
Tax Area
#318 · Other · via Tax Area Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
Transaction Type
#258 · Other · via Default Trans. Type, Default Trans. Type - Returns
Transport Method
#259 · Other · via Default Transport Method
Responsibility Center
#5714 · Other · via Responsibility Center
Location
#14 · General Ledger · via Location Code
Base Calendar
#7600 · Other · via Base Calendar Code
Document Sending Profile
#60 · Other · via Document Sending Profile
Over-Receipt Code
#8510 · Other · via Over-Receipt Code