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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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