Diagrams


Table

Reservation Entry

DynamicsDocs.comReservation Entry«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 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 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 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......«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Item No.><Location Code><Transferred from Entry No.><Item Ledger Entry No.><Created By><Changed By><Variant Code><Reservation Entry><Location Code><Variant Code><Item 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. Integer AutoIncrement: Yes
2 Item No. Code20
3 Location Code Code10
4 Quantity (Base) Decimal (0:5)
5 Reservation Status Option
7 Description Text50
8 Creation Date Date
9 Transferred from Entry No. Integer
10 Source Type Integer
11 Source Subtype Option
12 Source ID Code20
13 Source Batch Name Code10
14 Source Prod. Order Line Integer
15 Source Ref. No. Integer
16 Item Ledger Entry No. Integer Editable: No
22 Expected Receipt Date Date
23 Shipment Date Date
24 Serial No. Code20
25 Created By Code50
27 Changed By Code50
28 Positive Boolean Editable: No
29 Qty. per Unit of Measure Decimal (0:5) Editable: No
30 Quantity Decimal (0:5)
31 Action Message Adjustment Decimal (0:5) Editable: No
FlowField
32 Binding Option Editable: No
33 Suppressed Action Msg. Boolean
34 Planning Flexibility Option
38 Appl.-to Item Entry Integer
40 Warranty Date Date Editable: No
41 Expiration Date Date Editable: No
50 Qty. to Handle (Base) Decimal (0:5)
51 Qty. to Invoice (Base) Decimal (0:5)
53 Quantity Invoiced (Base) Decimal (0:5)
80 New Serial No. Code20 Editable: No
81 New Lot No. Code20 Editable: No
900 Disallow Cancellation Boolean
5400 Lot No. Code20
5401 Variant Code Code10
5811 Appl.-from Item Entry Integer
5817 Correction Boolean
6505 New Expiration Date Date Editable: No
6510 Item Tracking Option Editable: No

Keys

# Fields
0 Entry No.,Positive Clustered: Yes
1 Source ID,Source Ref. No.,Source Type,Source Subtype,Source Batch Name,Source Prod. Order Line,Reservation Status,Shipment Date,Expected Receipt Date
2 Item No.,Variant Code,Location Code MaintainSIFTIndex: No
3 Item No.,Variant Code,Location Code,Reservation Status,Shipment Date,Expected Receipt Date,Serial No.,Lot No. MaintainSIFTIndex: No
4 Item No.,Source Type,Source Subtype,Reservation Status,Location Code,Variant Code,Shipment Date,Expected Receipt Date,Serial No.,Lot No. MaintainSQLIndex: No
MaintainSIFTIndex: No
5 Item No.,Variant Code,Location Code,Item Tracking,Reservation Status,Lot No.,Serial No. MaintainSQLIndex: No
MaintainSIFTIndex: No
6 Lot No.
7 Serial No.

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Item Ledger Entry No. Item Ledger Entry Entry No. 1..n
Variant Code Item Variant Code 1..n
Location Code Location Code 1..n
Transferred from Entry No. Reservation Entry Entry No. 1..n
Changed By User User Name 1..n

Table Relations From Other Tables

From Table From Field
Action Message Entry Reservation Entry 1..n
Reservation Entry Transferred from Entry No. 1..n