DynamicsDocs.com

Diagrams

Table

Planning Component

Fields |
Keys |
Relations To |
Relations From

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	Worksheet Template Name	Code10	TableRelation: "Req. Wksh. Template"
2	Worksheet Batch Name	Code10	TableRelation: "Requisition Wksh. Name".Name WHERE (Worksheet Template Name=FIELD(Worksheet Template Name))
3	Worksheet Line No.	Integer	TableRelation: "Requisition Line"."Line No." WHERE (Worksheet Template Name=FIELD(Worksheet Template Name), Journal Batch Name=FIELD(Worksheet Batch Name));
5	Line No.	Integer		BlankZero: Yes
11	Item No.	Code20	TableRelation: Item WHERE (Type=CONST(Inventory))
12	Description	Text50
13	Unit of Measure Code	Code10	TableRelation: "Item Unit of Measure".Code WHERE (Item No.=FIELD(Item No.))
14	Quantity	Decimal (0:5)		Editable: No
15	Position	Code10
16	Position 2	Code10
17	Position 3	Code10
18	Lead-Time Offset	DateFormula
19	Routing Link Code	Code10	TableRelation: "Routing Link"
20	Scrap %	Decimal (0:5)	MaxValue: 100	BlankNumbers: BlankNeg
21	Variant Code	Code10	TableRelation: "Item Variant".Code WHERE (Item No.=FIELD(Item No.))
25	Expected Quantity	Decimal (0:5)		Editable: No
28	Flushing Method	Option	[Manual,Forward,Backward,Pick + Forward,Pick + Backward]
30	Location Code	Code10	TableRelation: Location WHERE (Use As In-Transit=CONST(No))
31	Shortcut Dimension 1 Code	Code20	CaptionClass: '1,2,1' TableRelation: "Dimension Value".Code WHERE (Global Dimension No.=CONST(1))
32	Shortcut Dimension 2 Code	Code20	CaptionClass: '1,2,2' TableRelation: "Dimension Value".Code WHERE (Global Dimension No.=CONST(2))
33	Bin Code	Code20	TableRelation: Bin.Code WHERE (Location Code=FIELD(Location Code))
35	Supplied-by Line No.	Integer	TableRelation: "Requisition Line"."Line No." WHERE (Worksheet Template Name=FIELD(Worksheet Template Name), Journal Batch Name=FIELD(Worksheet Batch Name), Line No.=FIELD(Supplied-by Line No.));
36	Planning Level Code	Integer		Editable: No
37	Ref. Order Status	Option	[Simulated,Planned,Firm Planned,Released]
38	Ref. Order No.	Code20
39	Ref. Order Line No.	Integer
40	Length	Decimal (0:5)
41	Width	Decimal (0:5)
42	Weight	Decimal (0:5)
43	Depth	Decimal (0:5)
44	Calculation Formula	Option	[ ,Length,Length * Width,Length * Width * Depth,Weight]
45	Quantity per	Decimal (0:5)
46	Ref. Order Type	Option	[ ,Purchase,Prod. Order,Transfer,Assembly]	Editable: No
50	Unit Cost	Decimal	AutoFormatType: 1
51	Cost Amount	Decimal	AutoFormatType: 2
52	Due Date	Date
53	Due Time	Time
55	Direct Unit Cost	Decimal (2:5)
56	Indirect Cost %	Decimal (0:5)
57	Overhead Rate	Decimal (0:5)
58	Direct Cost Amount	Decimal (2:2)
59	Overhead Amount	Decimal (2:2)
60	Qty. per Unit of Measure	Decimal (0:5)		Editable: No
62	Quantity (Base)	Decimal (0:5)
63	Reserved Qty. (Base)	Decimal (0:5)	CalcFormula: -Sum("Reservation Entry"."Quantity (Base)" WHERE (Source ID=FIELD(Worksheet Template Name), Source Ref. No.=FIELD(Line No.), Source Type=CONST(99000829), Source Subtype=CONST(0), Source Batch Name=FIELD(Worksheet Batch Name), Source Prod. Order Line=FIELD(Worksheet Line No.), Reservation Status=CONST(Reservation)));	Editable: No FlowField
71	Reserved Quantity	Decimal (0:5)	CalcFormula: -Sum("Reservation Entry".Quantity WHERE (Source ID=FIELD(Worksheet Template Name), Source Ref. No.=FIELD(Line No.), Source Type=CONST(99000829), Source Subtype=CONST(0), Source Batch Name=FIELD(Worksheet Batch Name), Source Prod. Order Line=FIELD(Worksheet Line No.), Reservation Status=CONST(Reservation)));	Editable: No FlowField
73	Expected Quantity (Base)	Decimal (0:5)		Editable: No
74	Original Expected Qty. (Base)	Decimal (0:5)		BlankZero: Yes Editable: No
75	Net Quantity (Base)	Decimal (0:5)		Editable: No
76	Due Date-Time	DateTime
480	Dimension Set ID	Integer	TableRelation: "Dimension Set Entry"	Editable: No
99000875	Critical	Boolean
99000915	Planning Line Origin	Option	[ ,Action Message,Planning,Order Planning]	Editable: No

Keys

#	Fields
0	Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Line No.	SumIndexFields: Cost Amount	Clustered: Yes MaintainSIFTIndex: No
1	Item No.,Variant Code,Location Code,Due Date,Planning Line Origin	SumIndexFields: Expected Quantity (Base),Cost Amount	MaintainSIFTIndex: No
2	Item No.,Variant Code,Location Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Planning Line Origin,Due Date	SumIndexFields: Expected Quantity (Base),Cost Amount	MaintainSQLIndex: No MaintainSIFTIndex: No
3	Worksheet Template Name,Worksheet Batch Name,Worksheet Line No.,Item No.		MaintainSQLIndex: No

Table Relations To Other Tables

Field	Related Table	Related Field
Bin Code	Bin	Code	TableRelation: Bin.Code WHERE (Location Code=FIELD(Location Code))	1..n
Dimension Set ID	Dimension Set Entry		TableRelation: "Dimension Set Entry"	1..n
Shortcut Dimension 2 Code	Dimension Value	Code	TableRelation: "Dimension Value".Code WHERE (Global Dimension No.=CONST(2))	1..n
Item No.	Item		TableRelation: Item WHERE (Type=CONST(Inventory))	1..n
Unit of Measure Code	Item Unit of Measure	Code	TableRelation: "Item Unit of Measure".Code WHERE (Item No.=FIELD(Item No.))	1..n
Variant Code	Item Variant	Code	TableRelation: "Item Variant".Code WHERE (Item No.=FIELD(Item No.))	1..n
Location Code	Location		TableRelation: Location WHERE (Use As In-Transit=CONST(No))	1..n
Worksheet Template Name	Req. Wksh. Template	Name	TableRelation: "Req. Wksh. Template"	1..n
Supplied-by Line No.	Requisition Line	Line No.	TableRelation: "Requisition Line"."Line No." WHERE (Worksheet Template Name=FIELD(Worksheet Template Name), Journal Batch Name=FIELD(Worksheet Batch Name), Line No.=FIELD(Supplied-by Line No.));	1..n
Worksheet Batch Name	Requisition Wksh. Name	Name	TableRelation: "Requisition Wksh. Name".Name WHERE (Worksheet Template Name=FIELD(Worksheet Template Name))	1..n
Routing Link Code	Routing Link	Code	TableRelation: "Routing Link"	1..n

Table Relations From Other Tables

From Table	From Field

Diagrams

Tables A-Z

a

b

c

d

e

f

g

h

i

j

l

m

n

o

p

q

r

s

t

u

v

w

x

z

Table

Planning Component

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables