Diagrams

Table

Transfer Receipt Header

DynamicsDocs.comTransfer Receipt Header«Table 5746»Transfer Receipt 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 Scheme«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 ID«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]Description«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 Receipt 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. (No.) Code20
2 Transfer-from Code (Transfer-from Code) Code10
3 Transfer-from Name (Transfer-from Name) Text50
4 Transfer-from Name 2 (Transfer-from Name 2) Text50
5 Transfer-from Address (Transfer-from Address) Text50
6 Transfer-from Address 2 (Transfer-from Address 2) Text50
7 Transfer-from Post Code (Transfer-from Post Code) Code20
8 Transfer-from City (Transfer-from City) Text30
9 Transfer-from County (Transfer-from County) Text30
10 Trsf.-from Country/Region Code (Trsf.-from Country/Region Code) Code10
11 Transfer-to Code (Transfer-to Code) Code10
12 Transfer-to Name (Transfer-to Name) Text50
13 Transfer-to Name 2 (Transfer-to Name 2) Text50
14 Transfer-to Address (Transfer-to Address) Text50
15 Transfer-to Address 2 (Transfer-to Address 2) Text50
16 Transfer-to Post Code (Transfer-to Post Code) Code20
17 Transfer-to City (Transfer-to City) Text30
18 Transfer-to County (Transfer-to County) Text30
19 Trsf.-to Country/Region Code (Trsf.-to Country/Region Code) Code10
20 Transfer Order Date (Transfer Order Date) Date
21 Posting Date (Posting Date) Date
22 Comment (Comment) Boolean Editable: No
FlowField
23 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
24 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
25 Transfer Order No. (Transfer Order No.) Code20
26 No. Series (No. Series) Code10
27 Shipment Date (Shipment Date) Date
28 Receipt Date (Receipt Date) Date
29 In-Transit Code (In-Transit Code) Code10
30 Transfer-from Contact (Transfer-from Contact) Text50
31 Transfer-to Contact (Transfer-to Contact) Text50
32 External Document No. (External Document No.) Code35
33 Shipping Agent Code (Shipping Agent Code) Code10
34 Shipping Agent Service Code (Shipping Agent Service Code) Code10
35 Shipment Method Code (Shipment Method Code) Code10
47 Transaction Type (Transaction Type) Code10
48 Transport Method (Transport Method) Code10
59 Entry/Exit Point (Entry/Exit Point) Code10
63 Area (Area) Code10
64 Transaction Specification (Transaction Specification) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 No. (No.) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

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