Untracked Planning Element #99000855

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

20
Fields
0
Records
4
Primary key
0
FlowFields
8
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Track Line No..

All fields (20)

Untracked Planning Element — FIELDS
NO.FIELDTYPECLASSRELATION
1 Worksheet Template Name PK Code Normal → Req. Wksh. Template #244
2 Worksheet Batch Name PK Code Normal → Requisition Wksh. Name #245
3 Worksheet Line No. PK Integer Normal → Requisition Line #246
4 Track Line No. PK Integer Normal
11 Item No. Code Normal → Item #27
12 Variant Code Code Normal → Item Variant #5401
13 Location Code Code Normal → Location #14
21 Source Type Integer Normal
23 Source ID Code Normal
70 Parameter Value Decimal Normal
71 Untracked Quantity Decimal Normal
72 Track Quantity From Decimal Normal
73 Track Quantity To Decimal Normal
74 Source Text Normal
75 Warning Level Option 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 (7)

Tables referenced by fields on the Untracked Planning Element table through TableRelation properties.

Req. Wksh. Template
#244 · Setup · via Worksheet Template Name
Requisition Wksh. Name
#245 · Other · via Worksheet Batch Name
Requisition Line
#246 · Other · via Worksheet Line No.
Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Location
#14 · General Ledger · via Location Code