Diagrams


Table

Warehouse Receipt Line

DynamicsDocs.comWarehouse Receipt Line«Table 7317»Warehouse Receipt LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Bin CodeZone CodeItem No.QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to ReceiveQty. to Receive [Base]Qty. ReceivedQty. Received [Base]Unit of Measure CodeQty. per Unit of MeasureVariant CodeDescriptionDescription 2Status; [,Partially Received,Completel...Sorting Sequence No.Due DateStarting DateCubageWeight...«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 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«Table 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«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 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<Location Code><Bin Code><Cross-Dock Bin Code><Zone Code><Cross-Dock Zone Code><Item No.><Unit of Measure Code><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 Filter><Location Code><Zone Code><Item Filter><Bin Filter><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.>

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

Fields

# Name Type
1 No. Code20 Editable: No
2 Line No. Integer Editable: No
3 Source Type Integer Editable: No
4 Source Subtype Option Editable: No
6 Source No. Code20 Editable: No
7 Source Line No. Integer Editable: No
9 Source Document Option Editable: No
10 Location Code Code10 Editable: No
11 Shelf No. Code10
12 Bin Code Code20
13 Zone Code Code10
14 Item No. Code20 Editable: No
15 Quantity Decimal (0:5) Editable: No
16 Qty. (Base) Decimal (0:5) Editable: No
19 Qty. Outstanding Decimal (0:5) Editable: No
20 Qty. Outstanding (Base) Decimal (0:5) Editable: No
21 Qty. to Receive Decimal (0:5)
22 Qty. to Receive (Base) Decimal (0:5)
23 Qty. Received Decimal (0:5) Editable: No
24 Qty. Received (Base) Decimal (0:5) Editable: No
29 Unit of Measure Code Code10 Editable: No
30 Qty. per Unit of Measure Decimal (0:5) Editable: No
31 Variant Code Code10 Editable: No
32 Description Text50 Editable: No
33 Description 2 Text50 Editable: No
34 Status Option Editable: No
35 Sorting Sequence No. Integer Editable: No
36 Due Date Date
37 Starting Date Date
38 Cubage Decimal (0:5)
39 Weight Decimal (0:5)
48 Not upd. by Src. Doc. Post. Boolean Editable: No
49 Posting from Whse. Ref. Integer Editable: No
50 Qty. to Cross-Dock Decimal (0:5)
51 Qty. to Cross-Dock (Base) Decimal (0:5)
52 Cross-Dock Zone Code Code10
53 Cross-Dock Bin Code Code20

Keys

# Fields
0 No.,Line No. Clustered: Yes
MaintainSIFTIndex: No
1 Source Type,Source Subtype,Source No.,Source Line No. MaintainSIFTIndex: No
2 No.,Source Type,Source Subtype,Source No.,Source Line No. MaintainSQLIndex: No
3 No.,Sorting Sequence No. MaintainSQLIndex: No
4 No.,Shelf No. MaintainSQLIndex: No
5 No.,Item No. MaintainSQLIndex: No
6 No.,Source Document,Source No. MaintainSQLIndex: No
7 No.,Due Date MaintainSQLIndex: No
8 No.,Bin Code MaintainSQLIndex: No
9 Item No.,Location Code,Variant Code MaintainSIFTIndex: No
10 Bin Code,Location Code MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Cross-Dock Bin Code Bin Code 1..n
Item No. Item No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Location Code Location Code 1..n
Cross-Dock Zone Code Zone Code 1..n

Table Relations From Other Tables

From Table From Field