Resource #156

Other table in Microsoft Dynamics 365 Business Central. 71 fields, 7 records in Cronus demo.

71
Fields
7
Records
1
Primary key
15
FlowFields
19
Relations
Open in Data Explorer →

Primary key

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

All fields (71)

Resource — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Type Option Normal
3 Name Text Normal
4 Search Name Code Normal
5 Name 2 Text Normal
6 Address Text Normal
7 Address 2 Text Normal
8 City Text Normal
9 Social Security No. Text Normal
10 Job Title Text Normal
11 Education Text Normal
12 Contract Class Text Normal
13 Employment Date Date Normal
14 Resource Group No. Code Normal → Resource Group #152
16 Global Dimension 1 Code Code Normal → Dimension Value #349
17 Global Dimension 2 Code Code Normal → Dimension Value #349
18 Base Unit of Measure Code Normal → Unit of Measure #204
19 Direct Unit Cost Decimal Normal
20 Indirect Cost % Decimal Normal
21 Unit Cost Decimal Normal
22 Profit % Decimal Normal
23 Price/Profit Calculation Option Normal
24 Unit Price Decimal Normal
25 Vendor No. Code Normal → Vendor #23
26 Last Date Modified Date Normal
27 Comment ⚡ FLOW Boolean FlowField
38 Blocked Boolean Normal
39 Date Filter Date FlowFilter
40 Unit of Measure Filter Code FlowFilter → Unit of Measure #204
41 Capacity ⚡ FLOW Decimal FlowField
42 Qty. on Order (Project) ⚡ FLOW Decimal FlowField
43 Qty. Quoted (Project) ⚡ FLOW Decimal FlowField
44 Usage (Qty.) ⚡ FLOW Decimal FlowField
45 Usage (Cost) ⚡ FLOW Decimal FlowField
46 Usage (Price) ⚡ FLOW Decimal FlowField
47 Sales (Qty.) ⚡ FLOW Decimal FlowField
48 Sales (Cost) ⚡ FLOW Decimal FlowField
49 Sales (Price) ⚡ FLOW Decimal FlowField
50 Chargeable Filter Boolean FlowFilter
51 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
53 Post Code Code Normal
54 County Text Normal
55 Automatic Ext. Texts Boolean Normal
56 No. Series Code Normal → No. Series #308
57 Tax Group Code Code Normal → Tax Group #321
58 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
59 Country/Region Code Code Normal → Country/Region #9
60 IC Partner Purch. G/L Acc. No. Code Normal → IC G/L Account #410
61 Unit Group Exists ⚡ FLOW Boolean FlowField
140 Image Media Normal
150 Privacy Blocked Boolean Normal
721 Coupled to Dynamics 365 Sales ⚡ FLOW Boolean FlowField
900 Qty. on Assembly Order ⚡ FLOW Decimal FlowField
950 Use Time Sheet Boolean Normal
951 Time Sheet Owner User ID Code Normal → User Setup #91
952 Time Sheet Approver User ID Code Normal → User Setup #91
1700 Default Deferral Template Code Code Normal → Deferral Template #1700
5900 Qty. on Service Order ⚡ FLOW Decimal FlowField
5901 Service Zone Filter Code Normal → Service Zone #5957
5902 In Customer Zone ⚡ FLOW Boolean FlowField
6210 Default Sust. Account Code Normal → Sustainability Account #6210
6211 Default CO2 Emission Decimal Normal
6212 Default CH4 Emission Decimal Normal
6213 Default N2O Emission Decimal Normal
6214 CO2e per Unit Decimal Normal
6215 CO2e Last Date Modified Date 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 (15)

Tables referenced by fields on the Resource table through TableRelation properties.

Resource Group
#152 · Other · via Resource Group No.
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Unit of Measure
#204 · Other · via Base Unit of Measure, Unit of Measure Filter
Vendor
#23 · Purchasing · via Vendor No.
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
No. Series
#308 · Other · via No. Series
Tax Group
#321 · Other · via Tax Group Code
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Country/Region
#9 · General Ledger · via Country/Region Code
IC G/L Account
#410 · Other · via IC Partner Purch. G/L Acc. No.
User Setup
#91 · Other · via Time Sheet Owner User ID, Time Sheet Approver User ID
Deferral Template
#1700 · Other · via Default Deferral Template Code
Service Zone
#5957 · Service · via Service Zone Filter
Sustainability Account
#6210 · Other · via Default Sust. Account