Customer Subscription Contract #8052

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

67
Fields
0
Records
1
Primary key
0
FlowFields
25
Relations
Open in Data Explorer →

Primary key

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

All fields (67)

Customer Subscription Contract — FIELDS
NO.FIELDTYPECLASSRELATION
2 Sell-to Customer No. Code Normal → Customer #18
3 No. PK Code Normal
4 Bill-to Customer No. Code Normal → Customer #18
5 Bill-to Name Text Normal → Customer #18
6 Bill-to Name 2 Text Normal
7 Bill-to Address Text Normal
8 Bill-to Address 2 Text Normal
9 Bill-to City Text Normal
10 Bill-to Contact Text Normal
11 Your Reference Text Normal
12 Ship-to Code Code Normal → Ship-to Address #222
13 Ship-to Name Text Normal
14 Ship-to Name 2 Text Normal
15 Ship-to Address Text Normal
16 Ship-to Address 2 Text Normal
17 Ship-to City Text Normal
18 Ship-to Contact 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
34 Customer Price Group Code Normal → Customer Price Group #6
43 Salesperson Code Code Normal → Salesperson/Purchaser #13
79 Sell-to Customer Name Text Normal → Customer #18
80 Sell-to Customer Name 2 Text Normal
81 Sell-to Address Text Normal
82 Sell-to Address 2 Text Normal
83 Sell-to City Text Normal
84 Sell-to Contact Text Normal
85 Bill-to ZIP Code Code Normal → Post Code #225
86 Bill-to State Text Normal
87 Bill-to Country/Region Code Code Normal → Country/Region #9
88 Sell-to ZIP Code Code Normal
89 Sell-to State Text Normal
90 Sell-to Country/Region Code Code Normal → Country/Region #9
91 Ship-to ZIP Code Code Normal
92 Ship-to State Text Normal
93 Ship-to 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
171 Sell-to Phone No. Text Normal
172 Email Text Normal
200 Description BLOB Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5052 Sell-to Contact No. Code Normal → Contact #5050
5053 Bill-to Contact No. Code Normal → Contact #5050
8050 Create Contract Deferrals Boolean Normal
8051 Without Contract Deferrals Boolean Normal
8052 Detail Overview Option Normal
8053 Billing Rhythm Filter DateFormula FlowFilter
8054 Dimension from Project No. Code Normal → Job #167
8055 Billing Base Date Date Normal
8056 Default Billing Rhythm DateFormula Normal
8057 Next Billing From Date Normal
8058 Next Billing To Date Normal
8059 Contractor Name in collective Invoice Boolean Normal
8060 Recipient Name in collective Invoice Boolean Normal
9000 Assigned User ID Code Normal → User Setup #91
9500 Active Boolean Normal
9501 Contract Type Code Normal → Subscription Contract Type #8053
9502 Description Preview Text 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 (17)

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

Customer
#18 · Sales · via Sell-to Customer No., Bill-to Customer No., Bill-to Name, Sell-to Customer Name
Ship-to Address
#222 · Other · via Ship-to Code
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
Customer Price Group
#6 · General Ledger · via Customer Price Group
Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
Post Code
#225 · Other · via Bill-to ZIP Code
Country/Region
#9 · General Ledger · via Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to 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 Sell-to Contact No., Bill-to Contact No.
Job
#167 · Other · via Dimension from Project No.
User Setup
#91 · Other · via Assigned User ID
Subscription Contract Type
#8053 · Other · via Contract Type