Diagrams


Table

Purch. Inv. Line Aggregate

DynamicsDocs.comPurch. Inv. Line Aggregate«Table 5478»Purch. Inv. Line AggregateLine No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Expected Receipt DateDescriptionDescription 2QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostVAT %Line Discount %Line Discount AmountAmountAmount Including VATQuantity ReceivedQuantity InvoicedInv. Discount AmountCurrency CodeVAT Base AmountLine AmountUnit of Measure CodeDocument Id [PK]Tax CodeTax AmountDiscount Applied Before TaxAPI Type; [Comment,Account,Item,Resour...Item IdAccount IdLine Tax AmountLine Amount Including Tax...«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 5477»Purch. Inv. Entity AggregateDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No. [NN]No. [PK]Your ReferencePayment Terms CodeDue DateShipment Method CodeVendor Posting GroupCurrency CodePrices Including VATPurchaser CodeOrder No.Recalculate Invoice Disc.AmountAmount Including VATVendor Invoice No.Buy-from Vendor NameBuy-from AddressBuy-from Address 2Buy-from CityBuy-from ContactBuy-from Post CodeBuy-from CountyBuy-from Country/Region CodeDocument DateVendor Ledger Entry No.Invoice Discount AmountBuy-from Contact No.IdTotal Tax AmountStatus; [,Draft,In Review,Open,Paid,Ca......<Currency Code><Unit of Measure Code><Unit of Measure Code><Document Id><Currency Code><Code>

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

Fields

# Name Type
4 Line No. Integer
5 Type Option
6 No. Code20
10 Expected Receipt Date Date
11 Description Text50
12 Description 2 Text50
15 Quantity Decimal (0:5)
17 Qty. to Invoice Decimal (0:5)
18 Qty. to Receive Decimal (0:5)
22 Direct Unit Cost Decimal
25 VAT % Decimal (0:5)
27 Line Discount % Decimal (0:5)
28 Line Discount Amount Decimal
29 Amount Decimal
30 Amount Including VAT Decimal
60 Quantity Received Decimal (0:5) Editable: No
61 Quantity Invoiced Decimal (0:5) Editable: No
69 Inv. Discount Amount Decimal Editable: No
91 Currency Code Code10
99 VAT Base Amount Decimal
103 Line Amount Decimal
5407 Unit of Measure Code Code10
8000 Document Id GUID
9020 Tax Code Code50
9021 Tax Amount Decimal
9022 Discount Applied Before Tax Boolean
9029 API Type Option
9030 Item Id GUID
9031 Account Id GUID
9039 Line Tax Amount Decimal
9040 Line Amount Including Tax Decimal
9041 Line Amount Excluding Tax Decimal
9042 Prices Including Tax Boolean
9043 Inv. Discount Amount Excl. VAT Decimal

Keys

# Fields
0 Document Id,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Document Id Purch. Inv. Entity Aggregate Id 1..n
Unit of Measure Code Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field