Diagrams

Table

Item Journal Buffer

DynamicsDocs.comItem Journal Buffer«Table 5803»Item Journal BufferLine No. [PK]Item No.Location CodeQuantityVariant CodeInventory Value [Calculated]«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 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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Item No.><Location Code><Variant Code><Alternative Item No.><Location Filter><Variant Filter><Item No.>

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

Fields

# Name Type
2 Line No. (Line No.) Integer
3 Item No. (Item No.) Code20
8 Location Code (Location Code) Code10
12 Quantity (Quantity) Decimal (0:5)
5402 Variant Code (Variant Code) Code10
5802 Inventory Value (Calculated) (Inventory Value (Calculated)) Decimal Editable: No

Keys

# Fields
0 Line No. (Line No.) Clustered: Yes
1 Item No.,Location Code,Variant Code (Item No.,Location Code,Variant Code)
2 Item No.,Variant Code (Item No.,Variant Code)

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field