Job Archive #5135

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

The Job Archive table (ID 5135) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 102 fields, with a primary key of No., Version No., and includes 12 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

102

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (102)

Job Archive — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
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
1003	Bill-to Contact	Text	Normal
1004	Planning Date Filter	Date	FlowFilter
1008	WIP Posting Date	Date	Normal
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
1024	Next Invoice Date ⚡ FLOW	Date	FlowField
1025	Apply Usage Link	Boolean	Normal
1027	WIP Posting Method	Option	Normal
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
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
3998	Source Doc. Exists ⚡ FLOW	Boolean	FlowField
3999	Last Archived Date ⚡ FLOW	DateTime	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
5043	Interaction Exist	Boolean	Normal
5044	Time Archived	Time	Normal
5045	Date Archived	Date	Normal
5046	Archived By	Code	Normal
5047	Version No. PK	Integer	Normal
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