Diagrams

Table

Transfer Header

DynamicsDocs.comTransfer Header«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 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«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 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 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 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«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<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><Last Shipment No.><Last Receipt No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Transaction Type><Transport Method><Entry/Exit Point><Area><Transaction Specification><Dimension Set ID><Assigned User ID><Source No.><Location Code><Destination No.><Shipment Method Code><Shipping Agent Code><Country/Region Code><Transfer-from Code><Transfer-to Code><In-Transit Code><Transfer-from Code><Transfer-to Code><In-Transit Code><Trsf.-from Country/Region Code><Trsf.-to Country/Region Code><Trsf.-from Country/Region Code><Trsf.-to Country/Region Code><Dimension Value Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><No. Series><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><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Transaction Type><Transport Method><Entry/Exit Point><Area><Transaction Specification><Dimension Set ID><Shipping Agent Code><Approver ID><Substitute>

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 Posting Date (Posting Date) Date
21 Shipment Date (Shipment Date) Date
22 Receipt Date (Receipt Date) Date
23 Status (Status) Option Editable: No
24 Comment (Comment) Boolean Editable: No
FlowField
25 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
26 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
27 In-Transit Code (In-Transit Code) Code10
28 No. Series (No. Series) Code10
29 Last Shipment No. (Last Shipment No.) Code20 Editable: No
30 Last Receipt No. (Last Receipt No.) Code20 Editable: No
31 Transfer-from Contact (Transfer-from Contact) Text50
32 Transfer-to Contact (Transfer-to Contact) Text50
33 External Document No. (External Document No.) Code35
34 Shipping Agent Code (Shipping Agent Code) Code10
35 Shipping Agent Service Code (Shipping Agent Service Code) Code10
36 Shipping Time (Shipping Time) DateFormula
37 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
5750 Shipping Advice (Shipping Advice) Option
5751 Posting from Whse. Ref. (Posting from Whse. Ref.) Integer
5752 Completely Shipped (Completely Shipped) Boolean Editable: No
FlowField
5753 Completely Received (Completely Received) Boolean Editable: No
FlowField
5754 Location Filter (Location Filter) Code10 FlowFilter
5793 Outbound Whse. Handling Time (Outbound Whse. Handling Time) DateFormula
5794 Inbound Whse. Handling Time (Inbound Whse. Handling Time) DateFormula
5796 Date Filter (Date Filter) Date FlowFilter
9000 Assigned User ID (Assigned User ID) Code50

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
Location Filter (Location Filter) 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
Last Receipt No. (Last Receipt No.) Transfer Receipt Header No. (No.) 1..n
Last Shipment No. (Last Shipment No.) Transfer Shipment Header No. (No.) 1..n
Transport Method (Transport Method) Transport Method Code (Code) 1..n
Assigned User ID (Assigned User ID) User Setup User ID (User ID) 1..n

Table Relations From Other Tables

From Table From Field
Warehouse Request Source No. (Source No.) 1..n