Diagrams

Table

Transfer Receipt Line

DynamicsDocs.comTransfer Receipt Line«Table 5747»Transfer Receipt LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureDescriptionShortcut Dimension 1 CodeShortcut Dimension 2 CodeGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Qty. per Unit of MeasureUnit of Measure CodeGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2Transfer Order No.Receipt DateShipping Agent CodeShipping Agent Service CodeIn-Transit CodeTransfer-from CodeTransfer-to CodeItem Rcpt. Entry No.Shipping TimeDimension Set IDItem Category CodeProduct Group Code...«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«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 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 94»Inventory Posting GroupCode [PK,NN]Description«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 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 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 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 Children«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<Item No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Gen. Prod. Posting Group><Inventory Posting Group><Unit of Measure Code><Variant Code><Shipping Agent Code><Shipping Agent Service Code><In-Transit Code><Transfer-from Code><Transfer-to Code><Dimension Set ID><Item Category Code><Transfer-To Bin Code><Inventory Posting Group><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Gen. Prod. Posting Group><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Item Category Code><Dimension Value Code><Shipping Agent 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><Parent Category>

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

Fields

# Name Type
1 Document No. (Document No.) Code20
2 Line No. (Line No.) Integer
3 Item No. (Item No.) Code20
4 Quantity (Quantity) Decimal (0:5)
5 Unit of Measure (Unit of Measure) Text10
7 Description (Description) Text50
8 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
9 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
10 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
11 Inventory Posting Group (Inventory Posting Group) Code10
12 Quantity (Base) (Quantity (Base)) Decimal (0:5)
14 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
15 Unit of Measure Code (Unit of Measure Code) Code10
16 Gross Weight (Gross Weight) Decimal (0:5)
17 Net Weight (Net Weight) Decimal (0:5)
18 Unit Volume (Unit Volume) Decimal (0:5)
21 Variant Code (Variant Code) Code10
22 Units per Parcel (Units per Parcel) Decimal (0:5)
23 Description 2 (Description 2) Text50
24 Transfer Order No. (Transfer Order No.) Code20
25 Receipt Date (Receipt Date) Date
26 Shipping Agent Code (Shipping Agent Code) Code10
27 Shipping Agent Service Code (Shipping Agent Service Code) Code10
28 In-Transit Code (In-Transit Code) Code10 Editable: No
29 Transfer-from Code (Transfer-from Code) Code10 Editable: No
30 Transfer-to Code (Transfer-to Code) Code10 Editable: No
31 Item Rcpt. Entry No. (Item Rcpt. Entry No.) Integer
32 Shipping Time (Shipping Time) DateFormula
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
5704 Item Category Code (Item Category Code) Code20
5707 Product Group Code (Product Group Code) Code10
7301 Transfer-To Bin Code (Transfer-To Bin Code) Code20

Keys

# Fields
0 Document No.,Line No. (Document No.,Line No.) Clustered: Yes
1 Transfer Order No.,Item No.,Receipt Date (Transfer Order No.,Item No.,Receipt Date)

Table Relations To Other Tables

Field Related Table Related Field
Transfer-To Bin Code (Transfer-To Bin Code) Bin 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
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Inventory Posting Group (Inventory Posting Group) Inventory Posting Group Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Item Category Code (Item Category Code) Item Category Code (Code) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Transfer-to Code (Transfer-to Code) Location () 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

Table Relations From Other Tables

From Table From Field