Job WIP Total #1021

Jobs table in Microsoft Dynamics 365 Business Central. 26 fields, 0 records in Cronus demo.

26
Fields
0
Records
1
Primary key
1
FlowFields
5
Relations
Open in Data Explorer →

Primary key

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

All fields (26)

Job WIP Total — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Project No. Code Normal → Job #167
3 Project Task No. Code Normal → Job Task #1001
4 WIP Method Code Normal → Job WIP Method #1006
5 WIP Posting Date Date Normal
6 WIP Posting Date Filter Text Normal
7 WIP Planning Date Filter Text Normal
8 WIP Warnings ⚡ FLOW Boolean FlowField
9 Posted to G/L Boolean Normal
10 Budget (Total Cost) Decimal Normal
11 Budget (Total Price) Decimal Normal
12 Usage (Total Cost) Decimal Normal
13 Usage (Total Price) Decimal Normal
14 Billable (Total Cost) Decimal Normal
15 Billable (Total Price) Decimal Normal
16 Billable (Invoiced Price) Decimal Normal
17 Billable (Invoiced Cost) Decimal Normal
20 Calc. Recog. Sales Amount Decimal Normal
21 Calc. Recog. Costs Amount Decimal Normal
30 Cost Completion % Decimal Normal
31 Invoiced % Decimal 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 (4)

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

Job
#167 · Other · via Project No.
Job Task
#1001 · Jobs · via Project Task No.
Job WIP Method
#1006 · Jobs · via WIP Method