Diagrams

Table

Bin Content Buffer

DynamicsDocs.comBin Content Buffer«Table 7330»Bin Content BufferLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Variant Code [PK]Unit of Measure Code [PK]CubageWeightBase Unit of MeasureQty. to Handle [Base]Qty. Outstanding [Base]Lot No. [PK]Serial No. [PK]«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 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 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<Location Code><Zone Code><Bin Code><Item No.><Variant Code><Unit of Measure Code><Base Unit of Measure><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 Location Code (Location Code) Code10 NotBlank: Yes
2 Zone Code (Zone Code) Code10 NotBlank: Yes
3 Bin Code (Bin Code) Code20 NotBlank: Yes
4 Item No. (Item No.) Code20 NotBlank: Yes
5 Variant Code (Variant Code) Code10
6 Unit of Measure Code (Unit of Measure Code) Code10
10 Cubage (Cubage) Decimal (0:5)
11 Weight (Weight) Decimal (0:5)
12 Base Unit of Measure (Base Unit of Measure) Code10
50 Qty. to Handle (Base) (Qty. to Handle (Base)) Decimal (0:5) Editable: No
51 Qty. Outstanding (Base) (Qty. Outstanding (Base)) Decimal (0:5)
6500 Lot No. (Lot No.) Code20
6501 Serial No. (Serial No.) Code20

Keys

# Fields
0 Location Code,Bin Code,Item No.,Variant Code,Unit of Measure Code,Lot No.,Serial No. (Location Code,Bin Code,Item No.,Variant Code,Unit of Measure Code,Lot No.,Serial No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Base Unit of Measure (Base Unit of Measure) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n
Zone Code (Zone Code) Zone Code (Code) 1..n

Table Relations From Other Tables

From Table From Field