Diagrams

Table

Availability Calc. Overview

DynamicsDocs.comAvailability Calc. Overview«Table 5830»Availability Calc. OverviewEntry No. [PK]Type; [Item,As of Date,Inventory,Suppl...DateItem No.Location CodeVariant CodeUnit of Measure CodeAttached to Entry No.LevelSource TypeSource Order StatusSource IDSource Batch NameSource Ref. No.Source Prod. Order LineDescriptionQuantityReserved QuantityInventory Running TotalSupply Running TotalDemand Running TotalRunning TotalMatches Criteria«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«Table 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......<Item No.><Location Code><Variant Code><Attached to Entry No.><Alternative Item No.><Location Filter><Variant Filter><Item No.><Item No.><Source No.><Originally Ordered No.><Location Code><Variant Code><Originally Ordered Var. Code>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 Type (Type) Option
3 Date (Date) Date
4 Item No. (Item No.) Code20
5 Location Code (Location Code) Code10
6 Variant Code (Variant Code) Code10
7 Unit of Measure Code (Unit of Measure Code) Code10
11 Attached to Entry No. (Attached to Entry No.) Integer
13 Level (Level) Integer
21 Source Type (Source Type) Integer
22 Source Order Status (Source Order Status) Integer
23 Source ID (Source ID) Code20
24 Source Batch Name (Source Batch Name) Code10
25 Source Ref. No. (Source Ref. No.) Integer
26 Source Prod. Order Line (Source Prod. Order Line) Integer
27 Description (Description) Text50
41 Quantity (Quantity) Decimal (0:5)
42 Reserved Quantity (Reserved Quantity) Decimal (0:5)
45 Inventory Running Total (Inventory Running Total) Decimal (0:5)
46 Supply Running Total (Supply Running Total) Decimal (0:5)
47 Demand Running Total (Demand Running Total) Decimal (0:5)
48 Running Total (Running Total) Decimal (0:5)
50 Matches Criteria (Matches Criteria) Boolean

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Item No.,Date,Attached to Entry No.,Type (Item No.,Date,Attached to Entry No.,Type)
2 Item No.,Variant Code,Location Code (Item No.,Variant Code,Location Code)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Attached to Entry No. (Attached to Entry No.) Item Ledger Entry Entry No. (Entry 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