Imported Cust. Sub. Contract #8010

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

30
Fields
0
Records
1
Primary key
0
FlowFields
17
Relations
Open in Data Explorer →

Primary key

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

All fields (30)

Imported Cust. Sub. Contract — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Subscription Contract No. Code Normal
3 Sell-to Customer No. Code Normal → Customer #18
4 Sell-to Contact No. Code Normal → Contact #5050
5 Bill-to Customer No. Code Normal → Customer #18
6 Bill-to Contact No. Code Normal → Contact #5050
7 Contract Type Code Normal → Subscription Contract Type #8053
8 Description Text Normal
11 Your Reference Text Normal
12 Salesperson Code Code Normal → Salesperson/Purchaser #13
13 Assigned User ID Code Normal → User Setup #91
14 Without Contract Deferrals Boolean Normal
15 Detail Overview Option Normal
16 Dimension from Project No. Code Normal → Job #167
17 Ship-to Code Code Normal → Ship-to Address #222
18 Payment Terms Code Code Normal → Payment Terms #3
19 Payment Method Code Code Normal → Payment Method #289
20 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
21 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
22 Currency Code Code Normal → Currency #4
100 Contract created Boolean Normal
101 Error Text Text Normal
102 Processed by Code Normal → User Setup #91
103 Processed at DateTime Normal
8050 Create Contract Deferrals 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 (12)

Tables referenced by fields on the Imported Cust. Sub. Contract table through TableRelation properties.

Customer
#18 · Sales · via Sell-to Customer No., Bill-to Customer No.
Contact
#5050 · Other · via Sell-to Contact No., Bill-to Contact No.
Subscription Contract Type
#8053 · Other · via Contract Type
Salesperson/Purchaser
#13 · General Ledger · via Salesperson Code
User Setup
#91 · Other · via Assigned User ID, Processed by
Job
#167 · Other · via Dimension from Project No.
Ship-to Address
#222 · Other · via Ship-to Code
Payment Terms
#3 · General Ledger · via Payment Terms Code
Payment Method
#289 · Other · via Payment Method Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Currency
#4 · General Ledger · via Currency Code