Other table in Microsoft Dynamics 365 Business Central. 71 fields, 7 records in Cronus demo.
The Resource table (ID 156) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 71 fields, with a primary key of No., and includes 15 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Resource table through TableRelation properties.