Diagrams

Table

Production Forecast Entry

DynamicsDocs.comProduction Forecast Entry«Table 99000852»Production Forecast EntryProduction Forecast NameEntry No. [PK]Item No.Forecast DateForecast QuantityUnit of Measure CodeQty. per Unit of MeasureForecast Quantity [Base]Location CodeComponent ForecastDescription«Table 99000851»Production Forecast NameName [PK,NN]Description«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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«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...<Production Forecast Name><Item No.><Unit of Measure Code><Location Code><Production Forecast Name><Alternative Item No.><Location Filter><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.>

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

Fields

# Name Type
1 Production Forecast Name (Production Forecast Name) Code10
2 Entry No. (Entry No.) Integer
3 Item No. (Item No.) Code20
4 Forecast Date (Forecast Date) Date
5 Forecast Quantity (Forecast Quantity) Decimal (0:5)
6 Unit of Measure Code (Unit of Measure Code) Code10
7 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
8 Forecast Quantity (Base) (Forecast Quantity (Base)) Decimal (0:5)
10 Location Code (Location Code) Code10
12 Component Forecast (Component Forecast) Boolean
13 Description (Description) Text50

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Production Forecast Name,Item No.,Location Code,Forecast Date,Component Forecast (Production Forecast Name,Item No.,Location Code,Forecast Date,Component Forecast)
2 Production Forecast Name,Item No.,Component Forecast,Forecast Date,Location Code (Production Forecast Name,Item No.,Component Forecast,Forecast Date,Location Code)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n
Production Forecast Name (Production Forecast Name) Production Forecast Name Name (Name) 1..n

Table Relations From Other Tables

From Table From Field