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

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

Table Relations From Other Tables

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