DynamicsDocs.com

Diagrams

Table

Transfer Header

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	No.	Code20
2	Transfer-from Code	Code10	TableRelation: Location WHERE (Use As In-Transit=CONST(No))
3	Transfer-from Name	Text50
4	Transfer-from Name 2	Text50
5	Transfer-from Address	Text50
6	Transfer-from Address 2	Text50
7	Transfer-from Post Code	Code20	TableRelation: [ValidateTableRelation: No; TestTableRelation: No] IF (Trsf.-from Country/Region Code=CONST()) "Post Code" ELSE IF (Trsf.-from Country/Region Code=FILTER(<>'')) "Post Code" WHERE (Country/Region Code=FIELD(Trsf.-from Country/Region Code));
8	Transfer-from City	Text30	TableRelation: [ValidateTableRelation: No; TestTableRelation: No] IF (Trsf.-from Country/Region Code=CONST()) "Post Code".City ELSE IF (Trsf.-from Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Trsf.-from Country/Region Code));
9	Transfer-from County	Text30
10	Trsf.-from Country/Region Code	Code10	TableRelation: Country/Region
11	Transfer-to Code	Code10	TableRelation: Location WHERE (Use As In-Transit=CONST(No))
12	Transfer-to Name	Text50
13	Transfer-to Name 2	Text50
14	Transfer-to Address	Text50
15	Transfer-to Address 2	Text50
16	Transfer-to Post Code	Code20	TableRelation: [ValidateTableRelation: No; TestTableRelation: No] "Post Code"
17	Transfer-to City	Text30	TableRelation: [ValidateTableRelation: No; TestTableRelation: No] IF (Trsf.-to Country/Region Code=CONST()) "Post Code".City ELSE IF (Trsf.-to Country/Region Code=FILTER(<>'')) "Post Code".City WHERE (Country/Region Code=FIELD(Trsf.-to Country/Region Code));
18	Transfer-to County	Text30
19	Trsf.-to Country/Region Code	Code10	TableRelation: Country/Region
20	Posting Date	Date
21	Shipment Date	Date
22	Receipt Date	Date
23	Status	Option	[Open,Released]	Editable: No
24	Comment	Boolean	CalcFormula: Exist("Inventory Comment Line" WHERE (Document Type=CONST(Transfer Order), No.=FIELD(No.)));	Editable: No FlowField
25	Shortcut Dimension 1 Code	Code20	CaptionClass: '1,2,1' TableRelation: "Dimension Value".Code WHERE (Global Dimension No.=CONST(1))
26	Shortcut Dimension 2 Code	Code20	CaptionClass: '1,2,2' TableRelation: "Dimension Value".Code WHERE (Global Dimension No.=CONST(2))
27	In-Transit Code	Code10	TableRelation: Location WHERE (Use As In-Transit=CONST(Yes))
28	No. Series	Code10	TableRelation: "No. Series"
29	Last Shipment No.	Code20	TableRelation: "Transfer Shipment Header"	Editable: No
30	Last Receipt No.	Code20	TableRelation: "Transfer Receipt Header"	Editable: No
31	Transfer-from Contact	Text50
32	Transfer-to Contact	Text50
33	External Document No.	Code35
34	Shipping Agent Code	Code10	AccessByPermission: TableData 5790=R TableRelation: "Shipping Agent"
35	Shipping Agent Service Code	Code10	TableRelation: "Shipping Agent Services".Code WHERE (Shipping Agent Code=FIELD(Shipping Agent Code))
36	Shipping Time	DateFormula	AccessByPermission: TableData 5790=R
37	Shipment Method Code	Code10	TableRelation: "Shipment Method"
47	Transaction Type	Code10	TableRelation: "Transaction Type"
48	Transport Method	Code10	TableRelation: "Transport Method"
59	Entry/Exit Point	Code10	TableRelation: "Entry/Exit Point"
63	Area	Code10	TableRelation: Area
64	Transaction Specification	Code10	TableRelation: "Transaction Specification"
480	Dimension Set ID	Integer	TableRelation: "Dimension Set Entry"	Editable: No
5750	Shipping Advice	Option	[Partial,Complete]
5751	Posting from Whse. Ref.	Integer
5752	Completely Shipped	Boolean	CalcFormula: Min("Transfer Line"."Completely Shipped" WHERE (Document No.=FIELD(No.), Shipment Date=FIELD(Date Filter), Transfer-from Code=FIELD(Location Filter), Derived From Line No.=CONST(0)));	Editable: No FlowField
5753	Completely Received	Boolean	CalcFormula: Min("Transfer Line"."Completely Received" WHERE (Document No.=FIELD(No.), Receipt Date=FIELD(Date Filter), Transfer-to Code=FIELD(Location Filter), Derived From Line No.=CONST(0)));	Editable: No FlowField
5754	Location Filter	Code10	TableRelation: Location	FlowFilter
5793	Outbound Whse. Handling Time	DateFormula
5794	Inbound Whse. Handling Time	DateFormula
5796	Date Filter	Date		FlowFilter
9000	Assigned User ID	Code50	TableRelation: "User Setup"

Keys

#	Fields
0	No.		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
Area	Area	Code	TableRelation: Area	1..n
Trsf.-to 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
Location Filter	Location	Code	TableRelation: Location	1..n
No. Series	No. Series	Code	TableRelation: "No. Series"	1..n
Shipment Method Code	Shipment Method	Code	TableRelation: "Shipment Method"	1..n
Shipping Agent Code	Shipping Agent	Code	TableRelation: "Shipping Agent"	1..n
Shipping Agent Service Code	Shipping Agent Services	Code	TableRelation: "Shipping Agent Services".Code WHERE (Shipping Agent Code=FIELD(Shipping Agent Code))	1..n
Transaction Specification	Transaction Specification	Code	TableRelation: "Transaction Specification"	1..n
Transaction Type	Transaction Type	Code	TableRelation: "Transaction Type"	1..n
Last Receipt No.	Transfer Receipt Header	No.	TableRelation: "Transfer Receipt Header"	1..n
Last Shipment No.	Transfer Shipment Header	No.	TableRelation: "Transfer Shipment Header"	1..n
Transport Method	Transport Method	Code	TableRelation: "Transport Method"	1..n
Assigned User ID	User Setup	User ID	TableRelation: "User Setup"	1..n

Table Relations From Other Tables

From Table	From Field
Warehouse Request	Source No.	TableRelation: IF (Source Document=CONST(Sales Order)) "Sales Header".No. WHERE (Document Type=CONST(Order), No.=FIELD(Source No.)) ELSE IF (Source Document=CONST(Sales Return Order)) "Sales Header".No. WHERE (Document Type=CONST(Return Order), No.=FIELD(Source No.)) ELSE IF (Source Document=CONST(Purchase Order)) "Purchase Header".No. WHERE (Document Type=CONST(Order), No.=FIELD(Source No.)) ELSE IF (Source Document=CONST(Purchase Return Order)) "Purchase Header".No. WHERE (Document Type=CONST(Return Order), No.=FIELD(Source No.)) ELSE IF (Source Type=CONST(5741)) "Transfer Header".No. WHERE (No.=FIELD(Source No.)) ELSE IF (Source Type=FILTER(5406\|5407)) "Production Order".No. WHERE (Status=CONST(Released), No.=FIELD(Source No.)) ELSE IF (Source Type=FILTER(901)) "Assembly Header".No. WHERE (Document Type=CONST(Order), No.=FIELD(Source No.));	1..n

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

Transfer Header

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables