Diagrams

Table

Posted Assemble-to-Order Link

DynamicsDocs.comPosted Assemble-to-Order Link«Table 914»Posted Assemble-to-Order LinkAssembly Document Type; [,Assembly] [P...Assembly Document No. [PK]Document Type; [,Sales Shipment]Document No.Document Line No.Assembled QuantityAssembled Quantity [Base]Assembly Order No.Order No.Order Line No.«Table 910»Posted Assembly HeaderNo. [PK]DescriptionSearch DescriptionDescription 2Order No.Item No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeItem Rcpt. Entry No.QuantityQuantity [Base]Assemble to OrderUnit CostCost AmountIndirect Cost %Overhead RateUnit of Measure CodeQty. per Unit of MeasureReversedNo. SeriesPosting No. Series...«Table 111»Sales Shipment LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No....<Assembly Document No.><Document No.><Attached to Line No.>

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

Fields

# Name Type
1 Assembly Document Type (Assembly Document Type) Option
2 Assembly Document No. (Assembly Document No.) Code20
12 Document Type (Document Type) Option
13 Document No. (Document No.) Code20
14 Document Line No. (Document Line No.) Integer
20 Assembled Quantity (Assembled Quantity) Decimal (0:5)
21 Assembled Quantity (Base) (Assembled Quantity (Base)) Decimal (0:5)
32 Assembly Order No. (Assembly Order No.) Code20
33 Order No. (Order No.) Code20
34 Order Line No. (Order Line No.) Integer

Keys

# Fields
0 Assembly Document Type,Assembly Document No. (Assembly Document Type,Assembly Document No.) Clustered: Yes
1 Document Type,Document No.,Document Line No. (Document Type,Document No.,Document Line No.)
2 Order No.,Order Line No. (Order No.,Order Line No.)

Table Relations To Other Tables

Field Related Table Related Field
Assembly Document No. (Assembly Document No.) Posted Assembly Header No. (No.) 1..n
Document No. (Document No.) Sales Shipment Line Document No. (Document No.) 1..n

Table Relations From Other Tables

From Table From Field