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. (Entry No.) Integer AutoIncrement: Yes
2 Item No. (Item No.) Code20
3 Location Code (Location Code) Code10
4 Quantity (Base) (Quantity (Base)) Decimal (0:5)
5 Reservation Status (Reservation Status) Option
7 Description (Description) Text50
8 Creation Date (Creation Date) Date
9 Transferred from Entry No. (Transferred from Entry No.) Integer
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 Item Ledger Entry No. (Item Ledger Entry No.) Integer Editable: No
22 Expected Receipt Date (Expected Receipt Date) Date
23 Shipment Date (Shipment Date) Date
24 Serial No. (Serial No.) Code20
25 Created By (Created By) Code50
27 Changed By (Changed By) Code50
28 Positive (Positive) Boolean Editable: No
29 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
30 Quantity (Quantity) Decimal (0:5)
31 Action Message Adjustment (Action Message Adjustment) Decimal (0:5) Editable: No
FlowField
32 Binding (Binding) Option Editable: No
33 Suppressed Action Msg. (Suppressed Action Msg.) Boolean
34 Planning Flexibility (Planning Flexibility) Option
38 Appl.-to Item Entry (Appl.-to Item Entry) Integer
40 Warranty Date (Warranty Date) Date Editable: No
41 Expiration Date (Expiration Date) Date Editable: No
50 Qty. to Handle (Base) (Qty. to Handle (Base)) Decimal (0:5)
51 Qty. to Invoice (Base) (Qty. to Invoice (Base)) Decimal (0:5)
53 Quantity Invoiced (Base) (Quantity Invoiced (Base)) Decimal (0:5)
80 New Serial No. (New Serial No.) Code20 Editable: No
81 New Lot No. (New Lot No.) Code20 Editable: No
900 Disallow Cancellation (Disallow Cancellation) Boolean
5400 Lot No. (Lot No.) Code20
5401 Variant Code (Variant Code) Code10
5811 Appl.-from Item Entry (Appl.-from Item Entry) Integer
5817 Correction (Correction) Boolean
6505 New Expiration Date (New Expiration Date) Date Editable: No
6510 Item Tracking (Item Tracking) Option Editable: No

Keys

# Fields
0 Entry No.,Positive (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 (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 (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. (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. (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. (Item No.,Variant Code,Location Code,Item Tracking,Reservation Status,Lot No.,Serial No.) MaintainSQLIndex: No
MaintainSIFTIndex: No
6 Lot No. (Lot No.)
7 Serial No. (Serial No.)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Item Ledger Entry No. (Item Ledger 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
Transferred from Entry No. (Transferred from Entry No.) Reservation Entry Entry No. (Entry No.) 1..n
Changed By (Changed By) User User Name (User Name) 1..n

Table Relations From Other Tables

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