XPT / Schema / Job

Job #167

Other table in Microsoft Dynamics 365 Business Central. 114 fields, 3 records in Cronus demo.

114
Fields
3
Records
1
Primary key
29
FlowFields
30
Relations
Open in Data Explorer →

Primary key

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

All fields (114)

Job — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Search Description Code Normal
3 Description Text Normal
4 Description 2 Text Normal
5 Bill-to Customer No. Code Normal → Customer #18
12 Creation Date Date Normal
13 Starting Date Date Normal
14 Ending Date Date Normal
19 Status Option Normal
20 Person Responsible Code Normal → Resource #156
21 Global Dimension 1 Code Code Normal → Dimension Value #349
22 Global Dimension 2 Code Code Normal → Dimension Value #349
23 Project Posting Group Code Normal → Job Posting Group #208
24 Blocked Option Normal
29 Last Date Modified Date Normal
30 Comment ⚡ FLOW Boolean FlowField
31 Customer Disc. Group Code Normal → Customer Discount Group #340
32 Customer Price Group Code Normal → Customer Price Group #6
35 Location Code Code Normal → Location #14
36 Bin Code Code Normal → Bin #7354
41 Language Code Code Normal → Language #8
49 Scheduled Res. Qty. ⚡ FLOW Decimal FlowField
50 Resource Filter Code FlowFilter → Resource #156
51 Posting Date Filter Date FlowFilter
55 Resource Gr. Filter Code FlowFilter → Resource Group #152
56 Scheduled Res. Gr. Qty. ⚡ FLOW Decimal FlowField
58 Bill-to Name Text Normal → Customer #18
59 Bill-to Address Text Normal
60 Bill-to Address 2 Text Normal
61 Bill-to City Text Normal
63 Bill-to County Text Normal
64 Bill-to Post Code Code Normal
66 No. Series Code Normal → No. Series #308
67 Bill-to Country/Region Code Code Normal → Country/Region #9
68 Bill-to Name 2 Text Normal
80 Task Billing Method Option Normal
117 Reserve Option Normal
140 Image Media Normal
210 Ship-to Phone No. Text Normal
1000 WIP Method Code Normal → Job WIP Method #1006
1001 Currency Code Code Normal → Currency #4
1002 Bill-to Contact No. Code Normal → Contact #5050
1003 Bill-to Contact Text Normal
1004 Planning Date Filter Date FlowFilter
1005 Total WIP Cost Amount ⚡ FLOW Decimal FlowField
1006 Total WIP Cost G/L Amount ⚡ FLOW Decimal FlowField
1007 WIP Entries Exist ⚡ FLOW Boolean FlowField
1008 WIP Posting Date Date Normal
1009 WIP G/L Posting Date ⚡ FLOW Date FlowField
1011 Invoice Currency Code Code Normal → Currency #4
1012 Exch. Calculation (Cost) Option Normal
1013 Exch. Calculation (Price) Option Normal
1014 Allow Budget/Billable Lines Boolean Normal
1015 Complete Boolean Normal
1017 Recog. Sales Amount ⚡ FLOW Decimal FlowField
1018 Recog. Sales G/L Amount ⚡ FLOW Decimal FlowField
1019 Recog. Costs Amount ⚡ FLOW Decimal FlowField
1020 Recog. Costs G/L Amount ⚡ FLOW Decimal FlowField
1021 Total WIP Sales Amount ⚡ FLOW Decimal FlowField
1022 Total WIP Sales G/L Amount ⚡ FLOW Decimal FlowField
1023 WIP Completion Calculated ⚡ FLOW Boolean FlowField
1024 Next Invoice Date ⚡ FLOW Date FlowField
1025 Apply Usage Link Boolean Normal
1026 WIP Warnings ⚡ FLOW Boolean FlowField
1027 WIP Posting Method Option Normal
1028 Applied Costs G/L Amount ⚡ FLOW Decimal FlowField
1029 Applied Sales G/L Amount ⚡ FLOW Decimal FlowField
1030 Calc. Recog. Sales Amount ⚡ FLOW Decimal FlowField
1031 Calc. Recog. Costs Amount ⚡ FLOW Decimal FlowField
1032 Calc. Recog. Sales G/L Amount ⚡ FLOW Decimal FlowField
1033 Calc. Recog. Costs G/L Amount ⚡ FLOW Decimal FlowField
1034 WIP Completion Posted ⚡ FLOW Boolean FlowField
1035 Over Budget Boolean Normal
1036 Project Manager Code Normal → User Setup #91
2000 Sell-to Customer No. Code Normal → Customer #18
2001 Sell-to Customer Name Text Normal → Customer #18
2002 Sell-to Customer Name 2 Text Normal
2003 Sell-to Address Text Normal
2004 Sell-to Address 2 Text Normal
2005 Sell-to City Text Normal
2006 Sell-to Contact Text Normal
2007 Sell-to Post Code Code Normal
2008 Sell-to County Text Normal
2009 Sell-to Country/Region Code Code Normal → Country/Region #9
2010 Sell-to Phone No. Text Normal
2011 Email Text Normal
2012 Sell-to Contact No. Code Normal → Contact #5050
3000 Ship-to Code Code Normal → Ship-to Address #222
3001 Ship-to Name Text Normal
3002 Ship-to Name 2 Text Normal
3003 Ship-to Address Text Normal
3004 Ship-to Address 2 Text Normal
3005 Ship-to City Text Normal
3006 Ship-to Contact Text Normal
3007 Ship-to Post Code Code Normal
3008 Ship-to County Text Normal
3009 Ship-to Country/Region Code Code Normal → Country/Region #9
3997 No. of Archived Versions ⚡ FLOW Integer FlowField
4000 External Document No. Code Normal
4001 Payment Method Code Code Normal → Payment Method #289
4002 Payment Terms Code Code Normal → Payment Terms #3
4003 Your Reference Text Normal
6210 Resource (Total CO2e) ⚡ FLOW Decimal FlowField
6211 Item (Total CO2e) ⚡ FLOW Decimal FlowField
6212 G/L Account (Total CO2e) ⚡ FLOW Decimal FlowField
6213 Total CO2e ⚡ FLOW Decimal FlowField
7000 Price Calculation Method Option Normal
7001 Cost Calculation Method Option Normal
7300 Completely Picked ⚡ FLOW Boolean FlowField
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 (20)

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

Customer
#18 · Sales · via Bill-to Customer No., Bill-to Name, Sell-to Customer No., Sell-to Customer Name
Resource
#156 · Other · via Person Responsible, Resource Filter
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Job Posting Group
#208 · Other · via Project Posting Group
Customer Discount Group
#340 · Other · via Customer Disc. Group
Customer Price Group
#6 · General Ledger · via Customer Price Group
Location
#14 · General Ledger · via Location Code
Bin
#7354 · Warehouse · via Bin Code
Language
#8 · General Ledger · via Language Code
Resource Group
#152 · Other · via Resource Gr. Filter
No. Series
#308 · Other · via No. Series
Country/Region
#9 · General Ledger · via Bill-to Country/Region Code, Sell-to Country/Region Code, Ship-to Country/Region Code
Job WIP Method
#1006 · Jobs · via WIP Method
Currency
#4 · General Ledger · via Currency Code, Invoice Currency Code
Contact
#5050 · Other · via Bill-to Contact No., Sell-to Contact No.
User Setup
#91 · Other · via Project Manager
Ship-to Address
#222 · Other · via Ship-to Code
Payment Method
#289 · Other · via Payment Method Code
Payment Terms
#3 · General Ledger · via Payment Terms Code

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms