DynamicsDocs.com

Diagrams

Table

Standard Item Journal Line

Fields |
Keys |
Relations To |
Relations From

Fields

#	Name	Type
1	Journal Template Name	Code10	TableRelation: "Item Journal Template"	NotBlank: Yes
2	Line No.	Integer		NotBlank: Yes Editable: No
3	Item No.	Code20	TableRelation: Item
5	Entry Type	Option	[Purchase,Sale,Positive Adjmt.,Negative Adjmt.,Transfer,Consumption,Output, ,Assembly Consumption,Assembly Output]
8	Description	Text50
9	Location Code	Code10	TableRelation: Location
10	Inventory Posting Group	Code20	TableRelation: "Inventory Posting Group"	Editable: No
13	Quantity	Decimal (0:5)
16	Unit Amount	Decimal	AutoFormatType: 2
17	Unit Cost	Decimal	AutoFormatType: 2
18	Amount	Decimal	AutoFormatType: 1
23	Salespers./Purch. Code	Code20	TableRelation: Salesperson/Purchaser
26	Source Code	Code10	TableRelation: "Source Code"	Editable: No
34	Shortcut Dimension 1 Code	Code20	CaptionClass: '1,2,1' TableRelation: "Dimension Value".Code WHERE (Global Dimension No.=CONST(1))
35	Shortcut Dimension 2 Code	Code20	CaptionClass: '1,2,2' TableRelation: "Dimension Value".Code WHERE (Global Dimension No.=CONST(2))
37	Indirect Cost %	Decimal (0:5)
41	Standard Journal Code	Code10	TableRelation: "Standard Item Journal".Code
42	Reason Code	Code10	TableRelation: "Reason Code"
47	Transaction Type	Code10	TableRelation: "Transaction Type"
48	Transport Method	Code10	TableRelation: "Transport Method"
49	Country/Region Code	Code10	TableRelation: Country/Region
53	Qty. (Calculated)	Decimal (0:5)		Editable: No
54	Qty. (Phys. Inventory)	Decimal (0:5)
56	Phys. Inventory	Boolean		Editable: No
57	Gen. Bus. Posting Group	Code20	TableRelation: "Gen. Business Posting Group"
58	Gen. Prod. Posting Group	Code20	TableRelation: "Gen. Product Posting Group"
59	Entry/Exit Point	Code10	TableRelation: "Entry/Exit Point"
63	Area	Code10	TableRelation: Area
64	Transaction Specification	Code10	TableRelation: "Transaction Specification"
65	Posting No. Series	Code20	TableRelation: "No. Series"
480	Dimension Set ID	Integer	TableRelation: "Dimension Set Entry"	Editable: No
5402	Variant Code	Code10	TableRelation: "Item Variant".Code WHERE (Item No.=FIELD(Item No.))
5403	Bin Code	Code20	TableRelation: IF (Entry Type=FILTER(Purchase\|Positive Adjmt.\|Output), Quantity=FILTER(>=0)) Bin.Code WHERE (Location Code=FIELD(Location Code), Item Filter=FIELD(Item No.), Variant Filter=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Purchase\|Positive Adjmt.\|Output), Quantity=FILTER(<0)) "Bin Content"."Bin Code" WHERE (Location Code=FIELD(Location Code), Item No.=FIELD(Item No.), Variant Code=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Sale\|Negative Adjmt.\|Transfer\|Consumption), Quantity=FILTER(>0)) "Bin Content"."Bin Code" WHERE (Location Code=FIELD(Location Code), Item No.=FIELD(Item No.), Variant Code=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Sale\|Negative Adjmt.\|Transfer\|Consumption), Quantity=FILTER(<=0)) Bin.Code WHERE (Location Code=FIELD(Location Code), Item Filter=FIELD(Item No.), Variant Filter=FIELD(Variant Code));
5404	Qty. per Unit of Measure	Decimal (0:5)	InitValue: 1	Editable: No
5407	Unit of Measure Code	Code10	TableRelation: "Item Unit of Measure".Code WHERE (Item No.=FIELD(Item No.))
5413	Quantity (Base)	Decimal (0:5)
5701	Originally Ordered No.	Code20	TableRelation: Item
5702	Originally Ordered Var. Code	Code10	TableRelation: "Item Variant".Code WHERE (Item No.=FIELD(Originally Ordered No.))
5704	Item Category Code	Code20	TableRelation: "Item Category"
5705	Nonstock	Boolean
5706	Purchasing Code	Code10	TableRelation: Purchasing
5707	Product Group Code	Code10	TableRelation: [ValidateTableRelation: No] "Product Group".Code WHERE (Item Category Code=FIELD(Item Category Code))
5800	Value Entry Type	Option	[Direct Cost,Revaluation,Rounding,Indirect Cost,Variance]
5801	Item Charge No.	Code20	TableRelation: "Item Charge"
5817	Correction	Boolean
5839	Work Center No.	Code20	TableRelation: "Work Center"	Editable: No
6600	Return Reason Code	Code10	TableRelation: "Return Reason"
99000755	Overhead Rate	Decimal (0:5)

Keys

#	Fields
0	Journal Template Name,Standard Journal Code,Line No.		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
Area	Area	Code	TableRelation: Area	1..n
Bin Code	Bin	Code	TableRelation: IF (Entry Type=FILTER(Purchase\|Positive Adjmt.\|Output), Quantity=FILTER(>=0)) Bin.Code WHERE (Location Code=FIELD(Location Code), Item Filter=FIELD(Item No.), Variant Filter=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Purchase\|Positive Adjmt.\|Output), Quantity=FILTER(<0)) "Bin Content"."Bin Code" WHERE (Location Code=FIELD(Location Code), Item No.=FIELD(Item No.), Variant Code=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Sale\|Negative Adjmt.\|Transfer\|Consumption), Quantity=FILTER(>0)) "Bin Content"."Bin Code" WHERE (Location Code=FIELD(Location Code), Item No.=FIELD(Item No.), Variant Code=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Sale\|Negative Adjmt.\|Transfer\|Consumption), Quantity=FILTER(<=0)) Bin.Code WHERE (Location Code=FIELD(Location Code), Item Filter=FIELD(Item No.), Variant Filter=FIELD(Variant Code));	1..n
Bin Code	Bin Content	Bin Code	TableRelation: IF (Entry Type=FILTER(Purchase\|Positive Adjmt.\|Output), Quantity=FILTER(>=0)) Bin.Code WHERE (Location Code=FIELD(Location Code), Item Filter=FIELD(Item No.), Variant Filter=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Purchase\|Positive Adjmt.\|Output), Quantity=FILTER(<0)) "Bin Content"."Bin Code" WHERE (Location Code=FIELD(Location Code), Item No.=FIELD(Item No.), Variant Code=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Sale\|Negative Adjmt.\|Transfer\|Consumption), Quantity=FILTER(>0)) "Bin Content"."Bin Code" WHERE (Location Code=FIELD(Location Code), Item No.=FIELD(Item No.), Variant Code=FIELD(Variant Code)) ELSE IF (Entry Type=FILTER(Sale\|Negative Adjmt.\|Transfer\|Consumption), Quantity=FILTER(<=0)) Bin.Code WHERE (Location Code=FIELD(Location Code), Item Filter=FIELD(Item No.), Variant Filter=FIELD(Variant Code));	1..n
Country/Region Code	Country/Region	Code	TableRelation: Country/Region	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
Entry/Exit Point	Entry/Exit Point	Code	TableRelation: "Entry/Exit Point"	1..n
Gen. Bus. Posting Group	Gen. Business Posting Group	Code	TableRelation: "Gen. Business Posting Group"	1..n
Gen. Prod. Posting Group	Gen. Product Posting Group	Code	TableRelation: "Gen. Product Posting Group"	1..n
Inventory Posting Group	Inventory Posting Group	Code	TableRelation: "Inventory Posting Group"	1..n
Originally Ordered No.	Item	No.	TableRelation: Item	1..n
Item Category Code	Item Category	Code	TableRelation: "Item Category"	1..n
Item Charge No.	Item Charge	No.	TableRelation: "Item Charge"	1..n
Journal Template Name	Item Journal Template	Name	TableRelation: "Item Journal Template"	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
Originally Ordered Var. Code	Item Variant	Code	TableRelation: "Item Variant".Code WHERE (Item No.=FIELD(Originally Ordered No.))	1..n
Location Code	Location	Code	TableRelation: Location	1..n
Posting No. Series	No. Series	Code	TableRelation: "No. Series"	1..n
Purchasing Code	Purchasing	Code	TableRelation: Purchasing	1..n
Reason Code	Reason Code	Code	TableRelation: "Reason Code"	1..n
Return Reason Code	Return Reason	Code	TableRelation: "Return Reason"	1..n
Salespers./Purch. Code	Salesperson/Purchaser	Code	TableRelation: Salesperson/Purchaser	1..n
Source Code	Source Code	Code	TableRelation: "Source Code"	1..n
Standard Journal Code	Standard Item Journal	Code	TableRelation: "Standard Item Journal".Code	1..n
Transaction Specification	Transaction Specification	Code	TableRelation: "Transaction Specification"	1..n
Transaction Type	Transaction Type	Code	TableRelation: "Transaction Type"	1..n
Transport Method	Transport Method	Code	TableRelation: "Transport Method"	1..n
Work Center No.	Work Center	No.	TableRelation: "Work Center"	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

Standard Item Journal Line

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables