Diagrams


Table

Item Charge Assignment (Purch)

DynamicsDocs.comItem Charge Assignment (Purch)«Table 5805»Item Charge Assignment (Purch)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 38»Purchase HeaderDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«Table 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 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 120»Purch. Rcpt. HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency Code...«Table 6650»Return Shipment HeaderBuy-from Vendor No. [NN]No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactPosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting GroupCurrency CodeCurrency Factor...«Table 121»Purch. Rcpt. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Qty. Rcd. Not InvoicedQuantity InvoicedOrder No....«Table 6651»Return Shipment LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Quantity InvoicedPay-to Vendor No.Vendor Item 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 Receiving No.><Last Return Shipment No.><Blanket Order No.><Document No.><Blanket Order No.><No.><No.><Attached to Line 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 Option
2 Document No. Code20
3 Document Line No. Integer
4 Line No. Integer
5 Item Charge No. Code20 NotBlank: Yes
6 Item No. Code20
7 Description Text50
8 Qty. to Assign Decimal (0:5) BlankZero: Yes
9 Qty. Assigned Decimal (0:5) BlankZero: Yes
Editable: No
10 Unit Cost Decimal
11 Amount to Assign Decimal
12 Applies-to Doc. Type Option
13 Applies-to Doc. No. Code20
14 Applies-to Doc. Line No. Integer
15 Applies-to Doc. Line Amount Decimal

Keys

# Fields
0 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.
2 Applies-to Doc. Type

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Item Charge No. Item Charge No. 1..n
Applies-to Doc. No. Purch. Rcpt. Header No. 1..n
Applies-to Doc. Line No. Purch. Rcpt. Line Line No. 1..n
Applies-to Doc. No. Purchase Header No. 1..n
Applies-to Doc. Line No. Purchase Line Line No. 1..n
Applies-to Doc. No. Return Shipment Header No. 1..n
Applies-to Doc. Line No. Return Shipment Line Line No. 1..n

Table Relations From Other Tables

From Table From Field