Diagrams


Table

Inventory Page Data

DynamicsDocs.comInventory Page Data«Table 5531»Inventory Page DataCodeLine No. [PK]Period Type; [Day,Week,Month,Quarter,Y...Period StartPeriod EndPeriod No.LevelSource Line IDItem No.Variant CodeLocation CodeDescriptionAvailability DateType; [,Purchase,Sale,Purch. Return,Sa...Document No.SourceRemaining Quantity [Base]PositiveGross RequirementScheduled ReceiptForecastRemaining ForecastAction Message Qty.Action Message; [,New,Change Qty.,Resc...Source Document IDAttached to Line No.Ref. Order No.Projected InventoryForecasted Projected InventorySuggested Projected InventoryReserved Requirement...«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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...<Item No.><Variant Code><Location 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
1 Code (Code) Code20 Editable: No
2 Line No. (Line No.) Integer Editable: No
3 Period Type (Period Type) Option Editable: No
4 Period Start (Period Start) Date Editable: No
5 Period End (Period End) Date Editable: No
6 Period No. (Period No.) Integer Editable: No
7 Level (Level) Integer Editable: No
9 Source Line ID (Source Line ID) RecordID Editable: No
10 Item No. (Item No.) Code20 Editable: No
11 Variant Code (Variant Code) Code10 Editable: No
12 Location Code (Location Code) Code10 Editable: No
13 Description (Description) Text50 Editable: No
14 Availability Date (Availability Date) Date Editable: No
15 Type (Type) Option Editable: No
16 Document No. (Document No.) Code20 Editable: No
19 Source (Source) Text50 Editable: No
20 Remaining Quantity (Base) (Remaining Quantity (Base)) Decimal (0:5) BlankZero: Yes
Editable: No
21 Positive (Positive) Boolean Editable: No
22 Gross Requirement (Gross Requirement) Decimal (0:5) BlankZero: Yes
Editable: No
23 Scheduled Receipt (Scheduled Receipt) Decimal (0:5) BlankZero: Yes
Editable: No
24 Forecast (Forecast) Decimal (0:5) BlankZero: Yes
Editable: No
25 Remaining Forecast (Remaining Forecast) Decimal (0:5) BlankZero: Yes
Editable: No
26 Action Message Qty. (Action Message Qty.) Decimal (0:5) BlankZero: Yes
Editable: No
29 Action Message (Action Message) Option Editable: No
30 Source Document ID (Source Document ID) RecordID Editable: No
31 Attached to Line No. (Attached to Line No.) Integer Editable: No
34 Ref. Order No. (Ref. Order No.) Code20 Editable: No
36 Projected Inventory (Projected Inventory) Decimal (0:5) Editable: No
37 Forecasted Projected Inventory (Forecasted Projected Inventory) Decimal (0:5) Editable: No
38 Suggested Projected Inventory (Suggested Projected Inventory) Decimal (0:5) Editable: No
39 Reserved Requirement (Reserved Requirement) Decimal (0:5) BlankZero: Yes
Editable: No
40 Reserved Receipt (Reserved Receipt) Decimal (0:5) BlankZero: Yes
Editable: No

Keys

# Fields
0 Line No. (Line No.)
1 Code,Line No. (Code,Line No.) Clustered: Yes
2 Period Start,Line No. (Period Start,Line No.)

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