Diagrams

Table

Posted Invt. Pick Line

DynamicsDocs.comPosted Invt. Pick Line«Table 7343»Posted Invt. Pick 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 Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«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 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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 99000773»FamilyNo. [PK,NN]DescriptionDescription 2Search NameBlockedLast Date ModifiedRouting No.«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«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]DescriptionLast Modified Date TimeId«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 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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«Table 7305»Special EquipmentCode [PK,NN]Description<Location Code><Destination No.><Item No.><Destination No.><Variant Code><Unit of Measure Code><Destination No.><Destination No.><Destination No.><Destination No.><Shipping Agent Code><Shipping Agent Service Code><Shipment Method Code><Bin Code><Bin Code><Zone Code><Special Equipment 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><Location Code><Location Filter><Location Code><Location Filter><Location Code><Location Code><Vendor No.><Alternative Item No.><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Special Equipment Code><Item No.><Variant Code><Unit of Measure Code><Unit of Measure Filter><Shipment Method Code><Shipping Agent Code><Pay-to Vendor No.><Shipment Method Code><Shipment Method Id><Shipping Agent Code><Bill-to Customer No.><Shipping Agent Service Code><Sell-to Customer No.><Bill-to Customer No.><Shipment Method Code><Shipping Agent Code><Shipping Agent Service Code><Shipping Agent Code><Zone Code><Special Equipment Code><Bin Code><Zone Code><Special Equipment Code>

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

Fields

# Name Type
2 No. (No.) Code20
3 Line No. (Line No.) Integer
4 Source Type (Source Type) Integer
5 Source Subtype (Source Subtype) Option
6 Source No. (Source No.) Code20
7 Source Line No. (Source Line No.) Integer BlankZero: Yes
8 Source Subline No. (Source Subline No.) Integer BlankZero: Yes
9 Source Document (Source Document) Option BlankZero: Yes
11 Location Code (Location Code) Code10
12 Shelf No. (Shelf No.) Code10
13 Sorting Sequence No. (Sorting Sequence No.) Integer
14 Item No. (Item No.) Code20
15 Variant Code (Variant Code) Code10
16 Unit of Measure Code (Unit of Measure Code) Code10
17 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
18 Description (Description) Text50
19 Description 2 (Description 2) Text50
20 Quantity (Quantity) Decimal (0:5)
21 Qty. (Base) (Qty. (Base)) Decimal (0:5)
31 Shipping Advice (Shipping Advice) Option
34 Due Date (Due Date) Date
39 Destination Type (Destination Type) Option
40 Destination No. (Destination No.) Code20
41 Whse. Activity No. (Whse. Activity No.) Code20
42 Shipping Agent Code (Shipping Agent Code) Code10
43 Shipping Agent Service Code (Shipping Agent Service Code) Code10
44 Shipment Method Code (Shipment Method Code) Code10
6500 Serial No. (Serial No.) Code20
6501 Lot No. (Lot No.) Code20
6502 Warranty Date (Warranty Date) Date
6503 Expiration Date (Expiration Date) Date
7300 Bin Code (Bin Code) Code20
7301 Zone Code (Zone Code) Code10
7305 Action Type (Action Type) Option Editable: No
7312 Special Equipment Code (Special Equipment Code) Code10

Keys

# Fields
0 No.,Line No. (No.,Line No.) Clustered: Yes
1 No.,Sorting Sequence No. (No.,Sorting Sequence No.)
2 Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No. (Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.)
3 Lot No. (Lot No.)
4 Serial No. (Serial No.)

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Bin Code (Bin Code) Bin Content Bin Code (Bin Code) 1..n
Destination No. (Destination No.) Customer No. (No.) 1..n
Destination No. (Destination No.) Family No. (No.) 1..n
Destination No. (Destination No.) Item No. (No.) 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
Destination No. (Destination No.) Location Code (Code) 1..n
Destination No. (Destination No.) Sales Header No. (No.) 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
Special Equipment Code (Special Equipment Code) Special Equipment Code (Code) 1..n
Destination No. (Destination No.) Vendor No. (No.) 1..n
Zone Code (Zone Code) Zone Code (Code) 1..n

Table Relations From Other Tables

From Table From Field