Diagrams

Table

Order Promising Line

DynamicsDocs.comOrder Promising Line«Table 99000880»Order Promising LineEntry No. [PK]Item No.Variant CodeLocation CodeQuantityUnit of Measure CodeQty. per Unit of MeasureUnavailable QuantityQuantity [Base]Unavailable Quantity [Base]Required Quantity [Base]Source Type; [,Sales,Requisition Line,...Source SubtypeSource IDSource Batch NameSource Line No.DescriptionRequired QuantityRequested Delivery DatePlanned Delivery DateOriginal Shipment DateEarliest Shipment DateRequested Shipment DateUnavailability Date«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...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight<Item No.><Variant Code><Location Code><Unit of Measure Code><Alternative Item No.><Location Filter><Variant Filter><Item No.><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 Entry No. (Entry No.) Integer
10 Item No. (Item No.) Code20
11 Variant Code (Variant Code) Code10 Editable: No
12 Location Code (Location Code) Code10 Editable: No
13 Quantity (Quantity) Decimal (0:5)
14 Unit of Measure Code (Unit of Measure Code) Code10 Editable: No
15 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5) Editable: No
16 Unavailable Quantity (Unavailable Quantity) Decimal (0:5)
17 Quantity (Base) (Quantity (Base)) Decimal (0:5)
18 Unavailable Quantity (Base) (Unavailable Quantity (Base)) Decimal (0:5)
19 Required Quantity (Base) (Required Quantity (Base)) Decimal (0:5)
20 Source Type (Source Type) Option
21 Source Subtype (Source Subtype) Integer
22 Source ID (Source ID) Code20
23 Source Batch Name (Source Batch Name) Code10
25 Source Line No. (Source Line No.) Integer
30 Description (Description) Text50
31 Required Quantity (Required Quantity) Decimal (0:5)
40 Requested Delivery Date (Requested Delivery Date) Date
41 Planned Delivery Date (Planned Delivery Date) Date
42 Original Shipment Date (Original Shipment Date) Date
43 Earliest Shipment Date (Earliest Shipment Date) Date
44 Requested Shipment Date (Requested Shipment Date) Date Editable: No
45 Unavailability Date (Unavailability Date) Date

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Requested Shipment Date (Requested Shipment Date)

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
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