Vendor Subscription Contract #8063

Other table in Microsoft Dynamics 365 Business Central. 46 fields, 0 records in Cronus demo.

46
Fields
0
Records
1
Primary key
0
FlowFields
20
Relations
Open in Data Explorer →

Primary key

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

All fields (46)

Vendor Subscription Contract — FIELDS
NO.FIELDTYPECLASSRELATION
2 Buy-from Vendor No. Code Normal → Vendor #23
3 No. PK Code Normal
4 Pay-to Vendor No. Code Normal → Vendor #23
5 Pay-to Name Text Normal → Vendor #23
6 Pay-to Name 2 Text Normal
7 Pay-to Address Text Normal
8 Pay-to Address 2 Text Normal
9 Pay-to City Text Normal
10 Pay-to Contact Text Normal
11 Your Reference Text Normal
23 Payment Terms Code Code Normal → Payment Terms #3
29 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
30 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
32 Currency Code Code Normal → Currency #4
33 Default for Exclude from Price Update Boolean Normal
43 Purchaser Code Code Normal → Salesperson/Purchaser #13
79 Buy-from Vendor Name Text Normal → Vendor #23
80 Buy-from Vendor Name 2 Text Normal
81 Buy-from Address Text Normal
82 Buy-from Address 2 Text Normal
83 Buy-from City Text Normal
84 Buy-from Contact Text Normal
85 Pay-to ZIP Code Code Normal
86 Pay-to State Text Normal
87 Pay-to Country/Region Code Code Normal → Country/Region #9
88 Buy-from ZIP Code Code Normal
89 Buy-from State Text Normal
90 Buy-from Country/Region Code Code Normal → Country/Region #9
104 Payment Method Code Code Normal → Payment Method #289
107 No. Series Code Normal → No. Series #308
200 Description BLOB Normal
201 Description Preview Text Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5052 Buy-from Contact No. Code Normal → Contact #5050
5053 Pay-to Contact No. Code Normal → Contact #5050
8050 Create Contract Deferrals Boolean Normal
8051 Without Contract Deferrals Boolean Normal
8053 Billing Rhythm Filter DateFormula FlowFilter
9000 Assigned User ID Code Normal → User Setup #91
9500 Active Boolean Normal
9501 Contract Type Code Normal → Subscription Contract Type #8053
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 (13)

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

Vendor
#23 · Purchasing · via Buy-from Vendor No., Pay-to Vendor No., Pay-to Name, Buy-from Vendor Name
Payment Terms
#3 · General Ledger · via Payment Terms Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Currency
#4 · General Ledger · via Currency Code
Salesperson/Purchaser
#13 · General Ledger · via Purchaser Code
Country/Region
#9 · General Ledger · via Pay-to Country/Region Code, Buy-from Country/Region Code
Payment Method
#289 · Other · via Payment Method Code
No. Series
#308 · Other · via No. Series
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Contact
#5050 · Other · via Buy-from Contact No., Pay-to Contact No.
User Setup
#91 · Other · via Assigned User ID
Subscription Contract Type
#8053 · Other · via Contract Type