Diagrams


Table

Vendor

DynamicsDocs.comVendor«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 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«Table 1303»Mini Vendor TemplateKey [PK]Code [NN]Template Name [NN]CityVendor Posting GroupCurrency CodeLanguage CodePayment Terms CodeFin. Charge Terms CodeInvoice Disc. CodeCountry/Region CodePayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyVAT Bus. Posting GroupBlock Payment ToleranceValidate EU Vat Reg. No.«Table 130»Incoming DocumentEntry No. [PK]DescriptionCreated Date-TimeCreated By User IDCreated By User NameReleasedReleased Date-TimeReleased By User IDReleased By User NameLast Date-Time ModifiedLast Modified By User IDLast Modified By User NamePostedPosted Date-TimeDocument Type; [Journal,Sales Invoice,...Document No.Posting DateStatus; [New,Released,Rejected,Posted,...URL1URL2URL3URL4Vendor NameVendor VAT Registration No.Vendor IBANDocument DateVendor Bank Branch No.Vendor Bank Account No.Vendor No.Data Exchange TypeOCR Data Corrected...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 1625»Office Contact AssociationsContact No. [PK]Business Relation CodeAssociated Table; [,Customer,Vendor,Ba...No.Business Relation DescriptionContact NameType; [Company,Contact Person] [PK]«Table 175»Standard Vendor Purchase CodeVendor No. [PK,NN]Code [PK,NN]Description«Table 2158»O365 Document Sent HistoryDocument Type; [Quote,Order,Invoice,Cr...Document No. [PK]Posted [PK]Created Date-Time [PK]Source Type; [,Customer,Vendor]Source No.Job Queue Entry IDJob Last Status; [,In Process,Finished...Job CompletedNotifiedNotificationCleared«Table 224»Order AddressVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Country/Region CodeLast Date ModifiedFax No.Telex Answer BackPost CodeCountyE-MailHome Page«Table 249»VAT Registration LogEntry No. [PK]VAT Registration No. [NN]Account Type; [Customer,Vendor,Contact...Account No.Country/Region Code [NN]User IDStatus; [Not Verified,Valid,Invalid]Verified NameVerified AddressVerified DateRequest IdentifierVerified StreetVerified PostcodeVerified City«Table 267»Vendor AmountVendor No. [PK]Amount [LCY] [PK]Amount 2 [LCY] [PK]«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 288»Vendor Bank AccountVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCYAuto. Accept Transactions«Table 460»Purchase Prepayment %Item No. [PK,NN]Vendor No. [PK]Starting Date [PK]Ending DatePrepayment %«Table 5054»Contact Business RelationContact No. [PK,NN]Business Relation Code [PK,NN]Link to Table; [,Customer,Vendor,Bank...No.Business Relation DescriptionContact Name«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 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 5616»Maintenance RegistrationFA No. [PK,NN]Line No. [PK]Service DateMaintenance Vendor No.CommentService Agent NameService Agent Phone No.Service Agent Mobile Phone«Table 5628»InsuranceNo. [PK]Effective DateExpiration DatePolicy No.Annual PremiumPolicy CoverageTotal Value InsuredCommentInsurance TypeLast Date ModifiedInsurance Vendor No.FA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeBlockedDescriptionSearch DescriptionDate FilterNo. Series«Table 5700»Stockkeeping UnitItem No. [PK,NN]Variant Code [PK]Location Code [PK]DescriptionDescription 2Assembly BOMShelf No.Unit CostStandard CostLast Direct CostVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder QuantityCommentLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterInventoryQty. on Purch. OrderQty. on Sales OrderDrop Shipment FilterAssembly Policy; [Assemble-to-Stock,As...Qty. on Assembly OrderQty. on Asm. ComponentQty. on Job OrderTransfer-Level CodeLot Size...«Table 5717»Item Cross ReferenceItem No. [PK]Variant Code [PK]Unit of Measure [PK]Cross-Reference Type; [,Customer,Vendo...Cross-Reference Type No. [PK]Cross-Reference No. [PK,NN]DescriptionDiscontinue Bar Code«Table 5718»Nonstock ItemEntry No. [PK]Manufacturer CodeVendor No.Vendor Item No.DescriptionUnit of MeasurePublished CostNegotiated CostUnit PriceGross WeightNet WeightItem Template CodeProduct Group CodeLast Date ModifiedBar CodeItem No.CommentNo. Series«Table 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 7012»Purchase PriceItem No. [PK,NN]Vendor No. [PK,NN]Currency Code [PK]Starting Date [PK]Direct Unit CostMinimum Quantity [PK]Ending DateUnit of Measure Code [PK]Variant Code [PK]«Table 843»Cash Flow SetupPrimary Key [PK]Cash Flow Forecast No. SeriesReceivables CF Account No.Payables CF Account No.Sales Order CF Account No.Purch. Order CF Account No.FA Budget CF Account No.FA Disposal CF Account No.Service CF Account No.CF No. on Chart in Role CenterJob CF Account No.Automatic Update Frequency; [Never,Dai...Tax CF Account No.Taxable Period; [Monthly,Quarterly,Acc...Tax Payment WindowTax Bal. Account Type; [,Vendor,G/L Ac...Tax Bal. Account No.API KeyAPI URLVariance %Historical PeriodsHorizonPeriod Type; [Day,Week,Month,Quarter,Y...TimeOutService Pass API Key IDCortana Intelligence EnabledShow Cortana NotificationTime Series Model; [ARIMA,ETS,STL,ETS+...«Table 871»Social Listening Search TopicSource Type; [,Item,Vendor,Customer] [...Source No. [PK]Search Topic«Table 9151»My VendorUser ID [PK]Vendor No. [PK,NN]NamePhone No.Balance [LCY]«Table 9657»Custom Report SelectionSource Type [PK]Source No. [PK]Usage; [S.Quote,S.Order,S.Invoice,S.Cr...Sequence [PK]Report IDReport CaptionCustom Report Layout CodeCustom Report DescriptionSend To EmailUse for Email AttachmentUse for Email BodyEmail Body Layout CodeEmail Body Layout Description«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 99»Item VendorItem No. [PK,NN]Vendor No. [PK,NN]Lead Time CalculationVendor Item No.Variant Code [PK]«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 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. MemosLast Modified Date TimeId«Table 5»Finance Charge TermsCode [PK,NN]Interest RateMinimum Amount [LCY]Additional Fee [LCY]DescriptionInterest Calculation Method; [Average...Interest Period [Days]Grace PeriodDue Date CalculationInterest Calculation; [Open Entries,Cl...Post InterestPost Additional FeeLine DescriptionAdd. Line Fee in Interest«Table 10»Shipment MethodCode [PK,NN]DescriptionLast Modified Date TimeId«Table 291»Shipping AgentCode [PK,NN]NameInternet AddressAccount No.«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 318»Tax AreaCode [PK,NN]DescriptionLast Modified Date TimeId«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«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...«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 7600»Base CalendarCode [PK,NN]NameCustomized Changes Exist«Table 60»Document Sending ProfileCode [PK,NN]DescriptionPrinter; [No,Yes <Prompt for Settings>...E-Mail; [No,Yes <Prompt for Settings>,...E-Mail Attachment; [PDF,Electronic Doc...E-Mail FormatDisk; [No,PDF,Electronic Document,PDF...Disk FormatElectronic Document; [No,Through Docum...Electronic FormatDefaultSend To; [Disk,Email,Print,Electronic...Usage; [Sales Invoice,Sales Credit Mem...One Related Party Selected<Vendor Posting Group><Payment Terms Code><Cash Flow Payment Terms Code><Payment Terms Id><Fin. Charge Terms Code><Shipment Method Code><Shipping Agent Code><Pay-to Vendor No.><Payment Method Code><Payment Method Id><Gen. Bus. Posting Group><Tax Area Code><VAT Bus. Posting Group><IC Partner Code><Vendor No.><Preferred Bank Account Code><Vendor No.><Primary Contact No.><Responsibility Center><Location Code><Base Calendar Code><Document Sending Profile><Account No.><Invoice Disc. Code><Vendor No.><Vendor No.><No.><Vendor No.><Source No.><Vendor No.><Account No.><Vendor No.><Vendor No.><Vendor No.><No.><Buy-from Vendor No.><Vendor Id><Vendor No.><Maintenance Vendor No.><Maintenance Vendor No.><Insurance Vendor No.><Vendor No.><Cross-Reference Type No.><Vendor No.><Destination No.><Vendor No.><Vendor No.><Tax Bal. Account No.><Source No.><Vendor No.><Source No.><Subcontractor No.><Vendor No.><Account No.><Account No.><Vendor Posting Group><Payment Terms Code><Fin. Charge Terms Code><Payment Method Code><Gen. Bus. Posting Group><VAT Bus. Posting Group><Preferred Resource><Alternative Item No.><Location Filter><VAT Bus. Posting Gr. (Price)><Item No.><Item No.><Item No.><Item No.><Destination No.><Item No.><Item No.><Source No.><Item No.><Contact No.><Payment Terms Code><Shipment Method Code><Vendor Posting Group><Buy-from Contact No.><Location Code><Component of Main Asset><FA No.><Location Code><Location Code><Components at Location><Transfer-from Code><Location Code><Destination No.><Shipment Method Code><Shipping Agent Code><Alternate Work Center><Location Code><Direct Debit Pmt. Terms Code><Def. VAT Bus. Posting Group><Company No.><Lookup Contact No.><Location Code><Base Calendar Code>

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

Fields

# Name Type
1 No. Code20
2 Name Text50
3 Search Name Code50
4 Name 2 Text50
5 Address Text50
6 Address 2 Text50
7 City Text30
8 Contact Text50
9 Phone No. Text30 [Phone No.]
10 Telex No. Text20
14 Our Account No. Text20
15 Territory Code Code10
16 Global Dimension 1 Code Code20
17 Global Dimension 2 Code Code20
19 Budgeted Amount Decimal
21 Vendor Posting Group Code20
22 Currency Code Code10
24 Language Code Code10
26 Statistics Group Integer
27 Payment Terms Code Code10
28 Fin. Charge Terms Code Code10
29 Purchaser Code Code20
30 Shipment Method Code Code10
31 Shipping Agent Code Code10
33 Invoice Disc. Code Code20
35 Country/Region Code Code10
38 Comment Boolean Editable: No
FlowField
39 Blocked Option
45 Pay-to Vendor No. Code20
46 Priority Integer
47 Payment Method Code Code10
53 Last Modified Date Time DateTime Editable: No
54 Last Date Modified Date Editable: No
55 Date Filter Date FlowFilter
56 Global Dimension 1 Filter Code20 FlowFilter
57 Global Dimension 2 Filter Code20 FlowFilter
58 Balance Decimal Editable: No
FlowField
59 Balance (LCY) Decimal Editable: No
FlowField
60 Net Change Decimal Editable: No
FlowField
61 Net Change (LCY) Decimal Editable: No
FlowField
62 Purchases (LCY) Decimal Editable: No
FlowField
64 Inv. Discounts (LCY) Decimal Editable: No
FlowField
65 Pmt. Discounts (LCY) Decimal Editable: No
FlowField
66 Balance Due Decimal Editable: No
FlowField
67 Balance Due (LCY) Decimal Editable: No
FlowField
69 Payments Decimal Editable: No
FlowField
70 Invoice Amounts Decimal Editable: No
FlowField
71 Cr. Memo Amounts Decimal Editable: No
FlowField
72 Finance Charge Memo Amounts Decimal Editable: No
FlowField
74 Payments (LCY) Decimal Editable: No
FlowField
75 Inv. Amounts (LCY) Decimal Editable: No
FlowField
76 Cr. Memo Amounts (LCY) Decimal Editable: No
FlowField
77 Fin. Charge Memo Amounts (LCY) Decimal Editable: No
FlowField
78 Outstanding Orders Decimal Editable: No
FlowField
79 Amt. Rcd. Not Invoiced Decimal Editable: No
FlowField
80 Application Method Option
82 Prices Including VAT Boolean
84 Fax No. Text30
85 Telex Answer Back Text20
86 VAT Registration No. Text20
88 Gen. Bus. Posting Group Code20
89 Picture BLOB [Bitmap]
90 GLN Code13 [Numeric:Yes]
91 Post Code Code20
92 County Text30
97 Debit Amount Decimal BlankZero: Yes
Editable: No
FlowField
98 Credit Amount Decimal BlankZero: Yes
Editable: No
FlowField
99 Debit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
100 Credit Amount (LCY) Decimal BlankZero: Yes
Editable: No
FlowField
102 E-Mail Text80 [E-Mail]
103 Home Page Text80 [URL]
104 Reminder Amounts Decimal Editable: No
FlowField
105 Reminder Amounts (LCY) Decimal Editable: No
FlowField
107 No. Series Code20 Editable: No
108 Tax Area Code Code20
109 Tax Liable Boolean
110 VAT Bus. Posting Group Code20
111 Currency Filter Code10 FlowFilter
113 Outstanding Orders (LCY) Decimal Editable: No
FlowField
114 Amt. Rcd. Not Invoiced (LCY) Decimal Editable: No
FlowField
116 Block Payment Tolerance Boolean
117 Pmt. Disc. Tolerance (LCY) Decimal Editable: No
FlowField
118 Pmt. Tolerance (LCY) Decimal Editable: No
FlowField
119 IC Partner Code Code20
120 Refunds Decimal FlowField
121 Refunds (LCY) Decimal FlowField
122 Other Amounts Decimal FlowField
123 Other Amounts (LCY) Decimal FlowField
124 Prepayment % Decimal (0:5)
125 Outstanding Invoices Decimal Editable: No
FlowField
126 Outstanding Invoices (LCY) Decimal Editable: No
FlowField
130 Pay-to No. Of Archived Doc. Integer FlowField
131 Buy-from No. Of Archived Doc. Integer FlowField
132 Partner Type Option
140 Image Media [Person]
170 Creditor No. Code20 [Numeric:Yes]
288 Preferred Bank Account Code Code20
840 Cash Flow Payment Terms Code Code10
5049 Primary Contact No. Code20
5700 Responsibility Center Code10
5701 Location Code Code10
5790 Lead Time Calculation DateFormula
7177 No. of Pstd. Receipts Integer Editable: No
FlowField
7178 No. of Pstd. Invoices Integer Editable: No
FlowField
7179 No. of Pstd. Return Shipments Integer Editable: No
FlowField
7180 No. of Pstd. Credit Memos Integer Editable: No
FlowField
7181 Pay-to No. of Orders Integer Editable: No
FlowField
7182 Pay-to No. of Invoices Integer Editable: No
FlowField
7183 Pay-to No. of Return Orders Integer Editable: No
FlowField
7184 Pay-to No. of Credit Memos Integer Editable: No
FlowField
7185 Pay-to No. of Pstd. Receipts Integer Editable: No
FlowField
7186 Pay-to No. of Pstd. Invoices Integer Editable: No
FlowField
7187 Pay-to No. of Pstd. Return S. Integer Editable: No
FlowField
7188 Pay-to No. of Pstd. Cr. Memos Integer Editable: No
FlowField
7189 No. of Quotes Integer Editable: No
FlowField
7190 No. of Blanket Orders Integer Editable: No
FlowField
7191 No. of Orders Integer FlowField
7192 No. of Invoices Integer Editable: No
FlowField
7193 No. of Return Orders Integer Editable: No
FlowField
7194 No. of Credit Memos Integer Editable: No
FlowField
7195 No. of Order Addresses Integer Editable: No
FlowField
7196 Pay-to No. of Quotes Integer Editable: No
FlowField
7197 Pay-to No. of Blanket Orders Integer FlowField
7198 No. of Incoming Documents Integer Editable: No
FlowField
7600 Base Calendar Code Code10
7601 Document Sending Profile Code20
7602 Validate EU Vat Reg. No. Boolean
8000 Id GUID
8001 Currency Id GUID
8002 Payment Terms Id GUID
8003 Payment Method Id GUID

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Vendor Posting Group
3 Currency Code
4 Priority
5 Country/Region Code
6 Gen. Bus. Posting Group
7 VAT Registration No.
8 Name
9 City
10 Post Code
11 Phone No.
12 Contact

Table Relations To Other Tables

Field Related Table Related Field
Base Calendar Code Base Calendar Code 1..n
Primary Contact No. Contact No. 1..n
Country/Region Code Country/Region Code 1..n
Currency Id Currency Id 1..n
Global Dimension 2 Filter Dimension Value Code 1..n
Document Sending Profile Document Sending Profile Code 1..n
Fin. Charge Terms Code Finance Charge Terms Code 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
IC Partner Code IC Partner Code 1..n
Language Code Language Code 1..n
Location Code Location 1..n
No. Series No. Series Code 1..n
Payment Method Id Payment Method Id 1..n
Payment Terms Id Payment Terms Id 1..n
Responsibility Center Responsibility Center Code 1..n
Purchaser Code Salesperson/Purchaser Code 1..n
Shipment Method Code Shipment Method Code 1..n
Shipping Agent Code Shipping Agent Code 1..n
Tax Area Code Tax Area Code 1..n
Territory Code Territory Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
Pay-to Vendor No. Vendor No. 1..n
Preferred Bank Account Code Vendor Bank Account Code 1..n
Vendor Posting Group Vendor Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Analysis Line Source No. Filter 1..n
Applied Payment Entry Account No. 1..n
Bank Acc. Reconciliation Line Account No. 1..n
Bank Account Ledger Entry Bal. Account No. 1..n
CV Ledger Entry Buffer Bal. Account No. 1..n
Cash Flow Setup Tax Bal. Account No. 1..n
Check Ledger Entry Bal. Account No. 1..n
Comment Line No. 1..n
Contact Business Relation No. 1..n
Credit Transfer Entry Account No. 1..n
Currency Vendor Filter 1..n
Cust. Ledger Entry Bal. Account No. 1..n
Custom Report Selection Source No. 1..n
Default Dimension No. 1..n
Detailed Vendor Ledg. Entry Vendor No. 1..n
Employee Ledger Entry Bal. Account No. 1..n
FA Ledger Entry Bal. Account No. 1..n
Fixed Asset Maintenance Vendor No. 1..n
G/L Entry Source No. 1..n
Gen. Journal Batch Bal. Account No. 1..n
Gen. Journal Line Sell-to/Buy-from No. 1..n
Gen. Journal Template Bal. Account No. 1..n
Handled IC Inbox Jnl. Line Account No. 1..n
Handled IC Inbox Purch. Header Pay-to Vendor No. 1..n
Handled IC Outbox Jnl. Line Account No. 1..n
Handled IC Outbox Purch. Hdr Pay-to Vendor No. 1..n
IC Inbox Jnl. Line Account No. 1..n
IC Inbox Purchase Header Pay-to Vendor No. 1..n
IC Outbox Jnl. Line Account No. 1..n
IC Outbox Purchase Header Pay-to Vendor No. 1..n
IC Partner Vendor No. 1..n
Incoming Document Vendor No. 1..n
Insurance Insurance Vendor No. 1..n
Item Vendor No. 1..n
Item Analysis View Budg. Entry Source No. 1..n
Item Analysis View Entry Source No. 1..n
Item Budget Buffer Source No. 1..n
Item Budget Entry Source No. 1..n
Item Cross Reference Cross-Reference Type No. 1..n
Item Journal Line Invoice-to Source No. 1..n
Item Ledger Entry Source No. 1..n
Item Tracing Buffer Source No. 1..n
Item Vendor Vendor No. 1..n
Maintenance Ledger Entry Bal. Account No. 1..n
Maintenance Registration Maintenance Vendor No. 1..n
Mini Vendor Template Invoice Disc. Code 1..n
My Vendor Vendor No. 1..n
Nonstock Item Vendor No. 1..n
O365 Document Sent History Source No. 1..n
Office Contact Associations No. 1..n
Order Address Vendor No. 1..n
Payable Vendor Ledger Entry Vendor No. 1..n
Payment Application Proposal Account No. 1..n
Payment Buffer Vendor No. 1..n
Posted Invt. Pick Header Destination No. 1..n
Posted Invt. Pick Line Destination No. 1..n
Posted Invt. Put-away Header Destination No. 1..n
Posted Invt. Put-away Line Destination No. 1..n
Posted Payment Recon. Line Account No. 1..n
Posted Whse. Shipment Line Destination No. 1..n
Purch. Cr. Memo Hdr. Pay-to Vendor No. 1..n
Purch. Cr. Memo Line Pay-to Vendor No. 1..n
Purch. Inv. Entity Aggregate Vendor Id 1..n
Purch. Inv. Header Pay-to Vendor No. 1..n
Purch. Inv. Line Pay-to Vendor No. 1..n
Purch. Rcpt. Header Pay-to Vendor No. 1..n
Purch. Rcpt. Line Pay-to Vendor No. 1..n
Purchase Header Pay-to Vendor No. 1..n
Purchase Header Archive Pay-to Vendor No. 1..n
Purchase Line Pay-to Vendor No. 1..n
Purchase Line Archive Pay-to Vendor No. 1..n
Purchase Line Discount Vendor No. 1..n
Purchase Prepayment % Vendor No. 1..n
Purchase Price Vendor No. 1..n
Registered Invt. Movement Hdr. Destination No. 1..n
Registered Invt. Movement Line Destination No. 1..n
Registered Whse. Activity Line Destination No. 1..n
Requisition Line Supply From 1..n
Resource Vendor No. 1..n
Return Shipment Header Pay-to Vendor No. 1..n
Return Shipment Line Pay-to Vendor No. 1..n
Reversal Entry Bal. Account No. 1..n
Service Item Vendor No. 1..n
Service Item Line Vendor No. 1..n
Service Shipment Item Line Vendor No. 1..n
Social Listening Search Topic Source No. 1..n
Standard General Journal Line Sell-to/Buy-from No. 1..n
Standard Vendor Purchase Code Vendor No. 1..n
Stockkeeping Unit Vendor No. 1..n
Text-to-Account Mapping Vendor No. 1..n
VAT Entry Bill-to/Pay-to No. 1..n
VAT Registration Log Account No. 1..n
VAT Report Line Bill-to/Pay-to No. 1..n
Value Entry Source No. 1..n
Vendor Pay-to Vendor No. 1..n
Vendor Amount Vendor No. 1..n
Vendor Bank Account Vendor No. 1..n
Vendor Ledger Entry Bal. Account No. 1..n
Warehouse Activity Header Destination No. 1..n
Warehouse Activity Line Destination No. 1..n
Warehouse Request Destination No. 1..n
Warehouse Shipment Line Destination No. 1..n
Warranty Ledger Entry Vendor No. 1..n
Whse. Worksheet Line Destination No. 1..n
Work Center Subcontractor No. 1..n