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.><No.><Originally Ordered No.><BOM Item No.><Attached to Line No.><Blanket Order Line No.><Variant Code><Originally Ordered Var. Code><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. Code20
2 Sales Order Line No. Integer
3 Item No. Code20
4 Description Text50
5 Shipment Date Date
6 Available Decimal (0:5)
7 Next Planning Date Date
8 Expected Delivery Date Date
9 Planning Status Option
10 Needs Replanning Boolean
11 Variant Code Code10
12 Planned Quantity Decimal (0:5)
15 Low-Level Code Integer Editable: No

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Variant Code Item Variant Code 1..n
Sales Order No. Sales Header No. 1..n
Sales Order Line No. Sales Line Line No. 1..n

Table Relations From Other Tables

From Table From Field