Diagrams


Table

Purch. Inv. Entity Aggregate

DynamicsDocs.comPurch. Inv. Entity Aggregate«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......«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 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 10»Shipment MethodCode [PK,NN]DescriptionLast Modified Date TimeId«Table 93»Vendor Posting GroupCode [PK,NN]Payables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.DescriptionUsed in VendorsUsed in Ledger Entries«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 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next Task DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTask Status Filter; [Not Started,In Pr......«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT SchemeLast Modified Date TimeId«Table 25»Vendor Ledger EntryEntry No. [PK]Vendor No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Purchase [LCY]Inv. Discount [LCY]Buy-from Vendor No.Vendor Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodePurchaser CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Rcd.[LCY]PositiveClosed by Entry No....«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...<Buy-from Vendor No.><Vendor Id><Payment Terms Code><Shipment Method Code><Vendor Posting Group><Currency Code><Purchaser Code><Buy-from Country/Region Code><Vendor Ledger Entry No.><Buy-from Contact No.><Document Id><Currency Code><Vendor Posting Group><Currency Code><Currency Filter><Currency Id><Vendor Filter><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Purchaser Code><Shipment Method Code><Country/Region Code><Pay-to Vendor No.><Primary Contact No.><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Vendor Posting Group><Currency Code><Closed by Currency Code><Currency Code><Contact Filter><Contact Company Filter><Salesperson Code><Salesperson Filter><Purchaser Code><Country/Region Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Company No.><Lookup Contact 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 Buy-from Vendor No. Code20 NotBlank: Yes
3 No. Code20
11 Your Reference Text35
23 Payment Terms Code Code10
24 Due Date Date
27 Shipment Method Code Code10
31 Vendor Posting Group Code20
32 Currency Code Code10
35 Prices Including VAT Boolean
43 Purchaser Code Code20
44 Order No. Code20
56 Recalculate Invoice Disc. Boolean Editable: No
FlowField
60 Amount Decimal
61 Amount Including VAT Decimal
68 Vendor Invoice No. Code35
79 Buy-from Vendor Name Text50
81 Buy-from Address Text50
82 Buy-from Address 2 Text50
83 Buy-from City Text30
84 Buy-from Contact Text50
88 Buy-from Post Code Code20
89 Buy-from County Text30
90 Buy-from Country/Region Code Code10
99 Document Date Date
1304 Vendor Ledger Entry No. Integer
1305 Invoice Discount Amount Decimal
5052 Buy-from Contact No. Code20
8000 Id GUID
9600 Total Tax Amount Decimal
9601 Status Option
9602 Posted Boolean
9624 Discount Applied Before Tax Boolean
9630 Last Modified Date Time DateTime Editable: No
9631 Vendor Id GUID
9632 Order Id GUID

Keys

# Fields
0 No.,Posted Clustered: Yes
1 Id
2 Vendor Ledger Entry No.

Table Relations To Other Tables

Field Related Table Related Field
Buy-from Contact No. Contact No. 1..n
Buy-from Country/Region Code Country/Region Code 1..n
Currency Code Currency Code 1..n
Payment Terms Code Payment Terms Code 1..n
Purchaser Code Salesperson/Purchaser Code 1..n
Shipment Method Code Shipment Method Code 1..n
Vendor Id Vendor Id 1..n
Vendor Ledger Entry No. Vendor Ledger Entry Entry No. 1..n
Vendor Posting Group Vendor Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Purch. Inv. Line Aggregate Document Id 1..n