Diagrams

Table

Item Charge Assignment (Sales)

DynamicsDocs.comItem Charge Assignment (Sales)«Table 5809»Item Charge Assignment (Sales)Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Document Line No. [PK]Line No. [PK]Item Charge No. [NN]Item No.DescriptionQty. to AssignQty. AssignedUnit CostAmount to AssignApplies-to Doc. Type; [Quote,Order,Inv...Applies-to Doc. No.Applies-to Doc. Line No.Applies-to Doc. Line Amount«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 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal 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 110»Sales Shipment HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«Table 6660»Return Receipt HeaderSell-to Customer No. [NN]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 GroupCurrency Code...«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....«Table 6661»Return Receipt 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 Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQuantity InvoicedBill-to Customer No.Gen. Bus. Posting Group...<Document No.><Applies-to Doc. No.><Document Line No.><Applies-to Doc. Line No.><Item Charge No.><Item No.><Applies-to Doc. No.><Applies-to Doc. No.><Applies-to Doc. Line No.><Applies-to Doc. Line No.><Last Shipping No.><Last Return Receipt No.><Blanket Order No.><Document No.><Blanket Order No.><Blanket Order No.><Attached to Line No.><Blanket Order Line No.><Originally Ordered No.><BOM Item No.><Blanket Order Line No.><Blanket Order Line No.><No.><No.><Alternative Item No.><No.><No.><Document No.><Document No.><Attached to Line 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 Document Type (Document Type) Option
2 Document No. (Document No.) Code20
3 Document Line No. (Document Line No.) Integer
4 Line No. (Line No.) Integer
5 Item Charge No. (Item Charge No.) Code20 NotBlank: Yes
6 Item No. (Item No.) Code20
7 Description (Description) Text50
8 Qty. to Assign (Qty. to Assign) Decimal (0:5) BlankZero: Yes
9 Qty. Assigned (Qty. Assigned) Decimal (0:5) BlankZero: Yes
Editable: No
10 Unit Cost (Unit Cost) Decimal
11 Amount to Assign (Amount to Assign) Decimal
12 Applies-to Doc. Type (Applies-to Doc. Type) Option
13 Applies-to Doc. No. (Applies-to Doc. No.) Code20
14 Applies-to Doc. Line No. (Applies-to Doc. Line No.) Integer
15 Applies-to Doc. Line Amount (Applies-to Doc. Line Amount) Decimal

Keys

# Fields
0 Document Type,Document No.,Document Line No.,Line No. (Document Type,Document No.,Document Line No.,Line No.) Clustered: Yes
MaintainSIFTIndex: No
1 Applies-to Doc. Type,Applies-to Doc. No.,Applies-to Doc. Line No. (Applies-to Doc. Type,Applies-to Doc. No.,Applies-to Doc. Line No.)
2 Applies-to Doc. Type (Applies-to Doc. Type)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Item Charge No. (Item Charge No.) Item Charge No. (No.) 1..n
Applies-to Doc. No. (Applies-to Doc. No.) Return Receipt Header No. (No.) 1..n
Applies-to Doc. Line No. (Applies-to Doc. Line No.) Return Receipt Line Line No. (Line No.) 1..n
Applies-to Doc. No. (Applies-to Doc. No.) Sales Header No. (No.) 1..n
Applies-to Doc. Line No. (Applies-to Doc. Line No.) Sales Line Line No. (Line No.) 1..n
Applies-to Doc. No. (Applies-to Doc. No.) Sales Shipment Header No. (No.) 1..n
Applies-to Doc. Line No. (Applies-to Doc. Line No.) Sales Shipment Line Line No. (Line No.) 1..n

Table Relations From Other Tables

From Table From Field