Diagrams

Table

Sales Planning Line

DynamicsDocs.comSales Planning Line«Table 99000800»Sales Planning LineSales Order No. [PK]Sales Order Line No. [PK]Item No.DescriptionShipment DateAvailableNext Planning DateExpected Delivery DatePlanning Status; [None,Simulated,Plann...Needs ReplanningVariant CodePlanned QuantityLow-Level Code«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«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<Sales Order No.><Sales Order Line No.><Item No.><Variant Code><Document No.><Blanket Order No.><Attached to Line No.><Blanket Order Line No.><Variant Code><Originally Ordered Var. Code><Originally Ordered No.><BOM Item No.><Alternative Item No.><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 Sales Order No. (Sales Order No.) Code20
2 Sales Order Line No. (Sales Order Line No.) Integer
3 Item No. (Item No.) Code20
4 Description (Description) Text50
5 Shipment Date (Shipment Date) Date
6 Available (Available) Decimal (0:5)
7 Next Planning Date (Next Planning Date) Date
8 Expected Delivery Date (Expected Delivery Date) Date
9 Planning Status (Planning Status) Option
10 Needs Replanning (Needs Replanning) Boolean
11 Variant Code (Variant Code) Code10
12 Planned Quantity (Planned Quantity) Decimal (0:5)
15 Low-Level Code (Low-Level Code) Integer Editable: No

Keys

# Fields
0 Sales Order No.,Sales Order Line No. (Sales Order No.,Sales Order Line No.) Clustered: Yes
1 Low-Level Code (Low-Level Code)

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
Sales Order No. (Sales Order No.) Sales Header No. (No.) 1..n
Sales Order Line No. (Sales Order Line No.) Sales Line Line No. (Line No.) 1..n

Table Relations From Other Tables

From Table From Field