Diagrams


Table

Transfer Shipment Header

DynamicsDocs.comTransfer Shipment Header«Table 5744»Transfer Shipment HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodeTransfer Order DatePosting DateCommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeTransfer Order No.No. SeriesShipment DateReceipt DateIn-Transit CodeTransfer-from ContactTransfer-to Contact...«Table 5740»Transfer HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodePosting DateShipment DateReceipt DateStatus; [Open,Released]CommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeIn-Transit CodeNo. SeriesLast Shipment No.Last Receipt No.Transfer-from Contact...«Table 7340»Posted Invt. Put-away HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Put-away No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateExternal Document No.2«Table 7342»Posted Invt. Pick HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt Pick No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Shipment DateExternal Document No.2«Table 7344»Registered Invt. Movement Hdr.No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Movement No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Shipment DateExternal Document No.2«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT SchemeLast Modified Date TimeId«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value IDIdLast Modified Date Time«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 5790»Shipping Agent ServicesShipping Agent Code [PK,NN]Code [PK,NN]DescriptionShipping TimeBase Calendar Code«Table 10»Shipment MethodCode [PK,NN]DescriptionLast Modified Date TimeId«Table 258»Transaction TypeCode [PK,NN]Description«Table 259»Transport MethodCode [PK,NN]Description«Table 282»Entry/Exit PointCode [PK,NN]Description«Table 284»AreaCode [PK,NN]Text«Table 285»Transaction SpecificationCode [PK,NN]Text«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Transfer-from Code><Transfer-to Code><In-Transit Code><Trsf.-from Country/Region Code><Trsf.-to Country/Region Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><No. Series><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Transaction Type><Transport Method><Entry/Exit Point><Area><Transaction Specification><Dimension Set ID><Last Shipment No.><Source No.><Source No.><Source No.><Transfer-from Code><Transfer-to Code><In-Transit Code><Location Filter><Trsf.-from Country/Region Code><Trsf.-to Country/Region Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><No. Series><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Transaction Type><Transport Method><Entry/Exit Point><Area><Transaction Specification><Dimension Set ID><Location Code><Destination No.><No. Series><Location Code><Destination No.><No. Series><Location Code><Destination No.><No. Series><Country/Region Code><Dimension Value Code><Shipping Agent Code>

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
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
8 Transfer-from City Text30
9 Transfer-from County Text30
10 Trsf.-from Country/Region Code Code10
11 Transfer-to Code Code10
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
17 Transfer-to City Text30
18 Transfer-to County Text30
19 Trsf.-to Country/Region Code Code10
20 Transfer Order Date Date
21 Posting Date Date
22 Comment Boolean Editable: No
FlowField
23 Shortcut Dimension 1 Code Code20
24 Shortcut Dimension 2 Code Code20
25 Transfer Order No. Code20
26 No. Series Code20
27 Shipment Date Date
28 Receipt Date Date
29 In-Transit Code Code10
30 Transfer-from Contact Text50
31 Transfer-to Contact Text50
32 External Document No. Code35
33 Shipping Agent Code Code10
34 Shipping Agent Service Code Code10
35 Shipment Method Code Code10
47 Transaction Type Code10
48 Transport Method Code10
59 Entry/Exit Point Code10
63 Area Code10
64 Transaction Specification Code10
70 Direct Transfer Boolean
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Area Area Code 1..n
Trsf.-to Country/Region Code Country/Region Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Entry/Exit Point Entry/Exit Point Code 1..n
In-Transit Code Location Code 1..n
No. Series No. Series Code 1..n
Shipment Method Code Shipment Method Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services Code 1..n
Transaction Specification Transaction Specification Code 1..n
Transaction Type Transaction Type Code 1..n
Transport Method Transport Method Code 1..n

Table Relations From Other Tables

From Table From Field
Posted Invt. Pick Header Source No. 1..n
Posted Invt. Put-away Header Source No. 1..n
Registered Invt. Movement Hdr. Source No. 1..n
Transfer Header Last Shipment No. 1..n