Diagrams


Table

Transfer Line

DynamicsDocs.comTransfer Line«Table 5741»Transfer LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureQty. to ShipQty. to ReceiveQuantity ShippedQuantity ReceivedStatus; [Open,Released]Shortcut Dimension 1 CodeShortcut Dimension 2 CodeDescriptionGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Outstanding Qty. [Base]Qty. to Ship [Base]Qty. Shipped [Base]Qty. to Receive [Base]Qty. Received [Base]Qty. per Unit of MeasureUnit of Measure CodeOutstanding QuantityGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2In-Transit Code...«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 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 94»Inventory Posting GroupCode [PK,NN]DescriptionUsed in ItemsUsed in Value Entries«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 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 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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas ChildrenLast Modified Date TimeId«Table 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated<Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Gen. Prod. Posting Group><Inventory Posting Group><Unit of Measure Code><Variant Code><In-Transit Code><Transfer-from Code><Transfer-to Code><Derived From Line No.><Shipping Agent Code><Shipping Agent Service Code><Dimension Set ID><Item Category Code><Transfer-from Bin Code><Transfer-To Bin Code><Dimension Value Code><Unit of Measure Code><Unit of Measure Filter><Variant Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Location Code><Shipping Agent Code><Parent Category><Bin Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Document No. Code20
2 Line No. Integer
3 Item No. Code20
4 Quantity Decimal (0:5)
5 Unit of Measure Text10
6 Qty. to Ship Decimal (0:5)
7 Qty. to Receive Decimal (0:5)
8 Quantity Shipped Decimal (0:5) Editable: No
9 Quantity Received Decimal (0:5) Editable: No
10 Status Option Editable: No
11 Shortcut Dimension 1 Code Code20
12 Shortcut Dimension 2 Code Code20
13 Description Text50
14 Gen. Prod. Posting Group Code20
15 Inventory Posting Group Code20
16 Quantity (Base) Decimal (0:5)
17 Outstanding Qty. (Base) Decimal (0:5) Editable: No
18 Qty. to Ship (Base) Decimal (0:5)
19 Qty. Shipped (Base) Decimal (0:5) Editable: No
20 Qty. to Receive (Base) Decimal (0:5)
21 Qty. Received (Base) Decimal (0:5) Editable: No
22 Qty. per Unit of Measure Decimal (0:5) Editable: No
23 Unit of Measure Code Code10
24 Outstanding Quantity Decimal (0:5) Editable: No
25 Gross Weight Decimal (0:5)
26 Net Weight Decimal (0:5)
27 Unit Volume Decimal (0:5)
30 Variant Code Code10
31 Units per Parcel Decimal (0:5)
32 Description 2 Text50
33 In-Transit Code Code10 Editable: No
34 Qty. in Transit Decimal (0:5) Editable: No
35 Qty. in Transit (Base) Decimal (0:5) Editable: No
36 Transfer-from Code Code10 Editable: No
37 Transfer-to Code Code10 Editable: No
38 Shipment Date Date
39 Receipt Date Date
40 Derived From Line No. Integer
41 Shipping Agent Code Code10
42 Shipping Agent Service Code Code10
43 Appl.-to Item Entry Integer
50 Reserved Quantity Inbnd. Decimal (0:5) Editable: No
FlowField
51 Reserved Quantity Outbnd. Decimal (0:5) Editable: No
FlowField
52 Reserved Qty. Inbnd. (Base) Decimal (0:5) Editable: No
FlowField
53 Reserved Qty. Outbnd. (Base) Decimal (0:5) Editable: No
FlowField
54 Shipping Time DateFormula
55 Reserved Quantity Shipped Decimal (0:5) Editable: No
FlowField
56 Reserved Qty. Shipped (Base) Decimal (0:5) Editable: No
FlowField
70 Direct Transfer Boolean
480 Dimension Set ID Integer Editable: No
5704 Item Category Code Code20
5707 Product Group Code Code10
5750 Whse. Inbnd. Otsdg. Qty (Base) Decimal (0:5) BlankZero: Yes
Editable: No
FlowField
5751 Whse Outbnd. Otsdg. Qty (Base) Decimal (0:5) BlankZero: Yes
Editable: No
FlowField
5752 Completely Shipped Boolean Editable: No
5753 Completely Received Boolean Editable: No
5793 Outbound Whse. Handling Time DateFormula
5794 Inbound Whse. Handling Time DateFormula
7300 Transfer-from Bin Code Code20
7301 Transfer-To Bin Code Code20
99000755 Planning Flexibility Option

Keys

# Fields
0 Document No.,Line No. Clustered: Yes
1 Transfer-to Code,Status,Derived From Line No.,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Receipt Date,In-Transit Code MaintainSIFTIndex: No
2 Transfer-from Code,Status,Derived From Line No.,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Shipment Date,In-Transit Code MaintainSIFTIndex: No
3 Item No.,Variant Code

Table Relations To Other Tables

Field Related Table Related Field
Transfer-To Bin Code Bin Code 1..n
Transfer-from Bin Code Bin Content Bin Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Inventory Posting Group Inventory Posting Group Code 1..n
Item Category Code Item Category Code 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Transfer-to Code Location Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Shipping Agent Service Code Shipping Agent Services Code 1..n
Derived From Line No. Transfer Line Line No. 1..n

Table Relations From Other Tables

From Table From Field
Transfer Line Derived From Line No. 1..n