Diagrams

Table

Serial No. Information

DynamicsDocs.comSerial No. Information«Table 6504»Serial No. InformationItem No. [PK,NN]Variant Code [PK]Serial No. [PK,NN]DescriptionBlockedCommentInventoryDate FilterLocation FilterBin FilterExpired Inventory«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 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<Item No.><Variant Code><Location Filter><Bin Filter><Alternative Item No.><Location Filter><Bin Filter><Item Filter><Variant Filter><Item No.><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>

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

Fields

# Name Type
1 Item No. (Item No.) Code20 NotBlank: Yes
2 Variant Code (Variant Code) Code10
3 Serial No. (Serial No.) Code20 NotBlank: Yes
10 Description (Description) Text50
13 Blocked (Blocked) Boolean
14 Comment (Comment) Boolean Editable: No
FlowField
20 Inventory (Inventory) Decimal (0:5) Editable: No
FlowField
21 Date Filter (Date Filter) Date FlowFilter
22 Location Filter (Location Filter) Code10 FlowFilter
23 Bin Filter (Bin Filter) Code20 FlowFilter
24 Expired Inventory (Expired Inventory) Decimal (0:5) Editable: No
FlowField

Keys

# Fields
0 Item No.,Variant Code,Serial No. (Item No.,Variant Code,Serial No.) Clustered: Yes
1 Serial No. (Serial No.)

Table Relations To Other Tables

Field Related Table Related Field
Bin Filter (Bin Filter) Bin Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Filter (Location Filter) Location Code (Code) 1..n

Table Relations From Other Tables

From Table From Field