Bin Creation Worksheet Line

DynamicsDocs.comBin Creation Worksheet Line«Table 7338»Bin Creation Worksheet LineWorksheet Template Name [PK]Name [PK]Line No. [PK]Type; [Bin,Bin Content]Location Code [PK,NN]Zone CodeBin Code [NN]Item No. [NN]DescriptionBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Special Equipment CodeBin RankingMaximum CubageMaximum WeightFixedDefaultCross-Dock BinUser IDVariant CodeQty. per Unit of MeasureUnit of Measure Code [NN]Dedicated«Table 7337»Bin Creation Wksh. NameWorksheet Template Name [PK,NN]Name [PK,NN]DescriptionLocation Code [PK,NN]Template Type; [Put-away,Pick,Movement...«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 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 7303»Bin TypeCode [PK,NN]DescriptionReceiveShipPut AwayPick«Table 7304»Warehouse ClassCode [PK,NN]Description«Table 7305»Special EquipmentCode [PK,NN]Description«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«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<Name><Location Code><Zone Code><Item No.><Bin Type Code><Warehouse Class Code><Special Equipment Code><User ID><Variant Code><Unit of Measure Code><Location Code><Location Filter><Location Code><Bin Type Code><Warehouse Class Code><Special Equipment Code><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Special Equipment Code>

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


# Name Type
1 Worksheet Template Name (Worksheet Template Name) Code10
2 Name (Name) Code10
3 Line No. (Line No.) Integer
4 Type (Type) Option
5 Location Code (Location Code) Code10 NotBlank: Yes
6 Zone Code (Zone Code) Code10
7 Bin Code (Bin Code) Code20 NotBlank: Yes
8 Item No. (Item No.) Code20 NotBlank: Yes
9 Description (Description) Text50
10 Bin Type Code (Bin Type Code) Code10
11 Warehouse Class Code (Warehouse Class Code) Code10
12 Block Movement (Block Movement) Option
15 Min. Qty. (Min. Qty.) Decimal (0:5)
16 Max. Qty. (Max. Qty.) Decimal (0:5)
20 Special Equipment Code (Special Equipment Code) Code10
21 Bin Ranking (Bin Ranking) Integer
22 Maximum Cubage (Maximum Cubage) Decimal (0:5) BlankZero: Yes
23 Maximum Weight (Maximum Weight) Decimal (0:5) BlankZero: Yes
37 Fixed (Fixed) Boolean
38 Default (Default) Boolean
40 Cross-Dock Bin (Cross-Dock Bin) Boolean
67 User ID (User ID) Code50 Editable: No
5402 Variant Code (Variant Code) Code10
5404 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
5407 Unit of Measure Code (Unit of Measure Code) Code10 NotBlank: Yes
5408 Dedicated (Dedicated) Boolean


# Fields
0 Worksheet Template Name,Name,Location Code,Line No. (Worksheet Template Name,Name,Location Code,Line No.) Clustered: Yes
1 Location Code,Zone Code,Bin Code,Item No.,Variant Code (Location Code,Zone Code,Bin Code,Item No.,Variant Code)

Table Relations To Other Tables

Field Related Table Related Field
Name (Name) Bin Creation Wksh. Name Name (Name) 1..n
Bin Type Code (Bin Type Code) Bin Type Code (Code) 1..n
Item No. (Item 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
Location Code (Location Code) Location () 1..n
Special Equipment Code (Special Equipment Code) Special Equipment Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
Warehouse Class Code (Warehouse Class Code) Warehouse Class Code (Code) 1..n
Zone Code (Zone Code) Zone Code (Code) 1..n

Table Relations From Other Tables

From Table From Field