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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field