Diagrams

Table

Action Message Entry

DynamicsDocs.comAction Message Entry«Table 99000849»Action Message EntryEntry No. [PK]Type; [,New,Change Qty.,Reschedule,Res...Reservation EntryQuantityNew DateCalculation; [Sum,None]Suppressed Action Msg.Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Location CodeBin CodeVariant CodeItem No.«Table 337»Reservation EntryEntry No. [PK]Item No.Location CodeQuantity [Base]Reservation Status; [Reservation,Track...DescriptionCreation DateTransferred from Entry No.Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Item Ledger Entry No.Expected Receipt DateShipment DateSerial No.Created ByChanged ByPositive [PK]Qty. per Unit of MeasureQuantityAction Message AdjustmentBinding; [,Order-to-Order]Suppressed Action Msg.Planning Flexibility; [Unlimited,None]Appl.-to Item EntryWarranty DateExpiration DateQty. to Handle [Base]...«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«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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...<Reservation Entry><Location Code><Bin Code><Variant Code><Item No.><Item No.><Location Code><Transferred from Entry No.><Variant Code><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><Item Filter><Bin Filter><Item No.><Variant Filter><Alternative Item No.>

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 Reservation Entry (Reservation Entry) Integer
4 Quantity (Quantity) Decimal (0:5)
5 New Date (New Date) Date
6 Calculation (Calculation) Option
7 Suppressed Action Msg. (Suppressed Action Msg.) Boolean
10 Source Type (Source Type) Integer
11 Source Subtype (Source Subtype) Option
12 Source ID (Source ID) Code20
13 Source Batch Name (Source Batch Name) Code10
14 Source Prod. Order Line (Source Prod. Order Line) Integer
15 Source Ref. No. (Source Ref. No.) Integer
16 Location Code (Location Code) Code10
17 Bin Code (Bin Code) Code20
18 Variant Code (Variant Code) Code10
19 Item No. (Item No.) Code20

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Reservation Entry,Calculation (Reservation Entry,Calculation)
2 Source Type,Source Subtype,Source ID,Source Batch Name,Source Prod. Order Line,Source Ref. No.,Item No.,Location Code,Bin Code,Variant Code (Source Type,Source Subtype,Source ID,Source Batch Name,Source Prod. Order Line,Source Ref. No.,Item No.,Location Code,Bin Code,Variant Code)

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
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n
Reservation Entry (Reservation Entry) Reservation Entry Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field