Diagrams

Table

Country/Region

DynamicsDocs.comCountry/Region«Table 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT Scheme«Table 1226»Payment Export DataEntry No. [PK]Data Exch Entry No.Line No.Data Exch. Line Def CodeGeneral Journal TemplateGeneral Journal Batch NameGeneral Journal Line No.Sender Bank Name - Data Conv.Sender Bank NameSender Bank Account CodeSender Bank Account No.Sender Bank Account CurrencySender Bank Country/RegionSender Bank BICSender Bank Clearing Std.Sender Bank Clearing CodeSender Bank AddressSender Bank CitySender Bank Post CodeRecipient NameRecipient AddressRecipient CityRecipient Post CodeRecipient Country/Region CodeRecipient Email AddressRecipient IDRecipient Bank Clearing Std.Recipient Bank Clearing CodeRecipient Reg. No.Recipient Acc. No.Recipient Bank Acc. No....«Table 1300»Mini Customer TemplateKey [PK]Code [NN]Template Name [NN]CityDocument Sending ProfileCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodePayment Terms CodeFin. Charge Terms CodeCustomer Disc. GroupCountry/Region CodePrint StatementsPayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyReminder Terms CodeVAT Bus. Posting GroupBlock Payment ToleranceAllow Line Disc.«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 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 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 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Order,Complete...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 222»Ship-to AddressCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityContactPhone No.Telex No.Shipment Method CodeShipping Agent CodePlace of ExportCountry/Region CodeLast Date ModifiedLocation CodeFax No.Telex Answer BackPost CodeCountyE-MailHome PageTax Area CodeTax LiableShipping Agent Service CodeService Zone Code«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 225»Post CodeCode [PK,NN]City [PK,NN]Search CityCountry/Region CodeCounty«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 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 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«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 287»Customer Bank AccountCustomer 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 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 381»VAT Registration No. FormatCountry/Region Code [PK,NN]Line No. [PK]Format«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. SeriesType; [Company,Person]Company No.Company NameLookup Contact No.First NameMiddle Name...«Table 5051»Contact Alt. AddressContact No. [PK]Code [PK,NN]Company NameCompany Name 2AddressAddress 2CityPost CodeCountyCountry/Region CodePhone No.Telex No.Extension No.Mobile Phone No.PagerE-MailHome PageFax No.Telex Answer BackLast Date ModifiedSearch E-Mail«Table 5079»Marketing SetupPrimary Key [PK]Contact Nos.Campaign Nos.Segment Nos.To-do Nos.Opportunity Nos.Bus. Rel. Code for CustomersBus. Rel. Code for VendorsBus. Rel. Code for Bank Accs.Inherit Salesperson CodeInherit Territory CodeInherit Country/Region CodeInherit Language CodeInherit Address DetailsInherit Communication DetailsDefault Salesperson CodeDefault Territory CodeDefault Country/Region CodeDefault Language CodeDefault Sales Cycle CodeAttachment Storage Type; [Embedded,Dis...Attachment Storage LocationAutosearch for DuplicatesSearch Hit % [NN]Maintain Dupl. Search Strings [NN]Mergefield Language IDDef. Company Salutation CodeDefault Person Salutation CodeDefault Correspondence Type; [,Hard Co...Queue Folder PathQueue Folder UID...«Table 5096»Segment Wizard FilterSegment No. [PK]Functionality; [Add Contacts,Remove Co...Mailing Group Code FilterIndustry Group Code FilterSalesperson Code FilterCountry/Region Code FilterTerritory Code FilterPost Code FilterBusiness Relation Code FilterProfile Questn. Code FilterProfile Questn. Line FilterJob Responsibility Code FilterProfile Questionnaire CodeAdd Additional CriteriaWizard Step; [,1,2,3,4,5,6]«Table 5105»Customer TemplateCode [PK,NN]DescriptionTerritory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeCustomer Posting GroupCurrency CodeCustomer Price GroupPayment Terms CodeShipment Method CodeInvoice Disc. CodeCustomer Disc. GroupCountry/Region CodePayment Method CodeGen. Bus. Posting GroupVAT Bus. Posting GroupAllow Line Disc.«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«Table 5201»Alternative AddressEmployee No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeCountyPhone No.Fax No.E-MailCommentCountry/Region Code«Table 5209»UnionCode [PK,NN]NameAddressPost CodeCityPhone No.No. of Members EmployedName 2Address 2CountyFax No.E-MailHome PageCountry/Region Code«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 79»Company InformationPrimary Key [PK]NameName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.Giro No.Bank NameBank Branch No.Bank Account No.Payment Routing No.Customs Permit No.Customs Permit DateVAT Registration No.Registration No.Telex Answer BackShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactLocation CodePicturePost CodeCountyShip-to Post Code...«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 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...<Sender Bank Country/Region><Recipient Bank Country/Region><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Bill-to Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Purchased Code><Country/Region of Origin Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Default Country/Region Code><Country/Region Code Filter><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Country/Region Code><Ship-to Country/Region Code><Country/Region Code><Country/Region Code><Sender Bank Account Code><Invoice Disc. Code><Location Code><Location Code><Location Code><Location Filter><Location Code><Location Code><Location Code><Location Code><Vendor No.><Person Responsible><Resource Filter><Resource No.><Bill-to Customer No.><Bill-to Customer No.><Preferred Bank Account><Customer No.><Primary Contact No.><Responsibility Center><Ship-to Filter><Customer No.><Account No.><Vendor No.><Post Code Filter><Pay-to Vendor No.><Preferred Bank Account><Vendor No.><Primary Contact No.><Responsibility Center><Account No.><Vendor No.><Subcontractor No.><Alternative Item No.><Item Filter><Company No.><Lookup Contact No.><Contact No.><Alt. Address Code><Employee No.><Union Code><Manager No.><Employee No. Filter><Responsibility Center><Alternate Work Center><Work Center No.>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Name Text50
6 EU Country/Region Code Code10
7 Intrastat Code Code10
8 Address Format Option
9 Contact Address Format Option
10 VAT Scheme Code10

Keys

# Fields
0 Code Clustered: Yes
1 EU Country/Region Code
2 Intrastat Code
3 Name

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Alternative Address Country/Region Code 1..n
Bank Account Country/Region Code 1..n
Company Information Ship-to Country/Region Code 1..n
Contact Country/Region Code 1..n
Contact Alt. Address Country/Region Code 1..n
Customer Country/Region Code 1..n
Customer Bank Account Country/Region Code 1..n
Customer Template Country/Region Code 1..n
Employee Country/Region Code 1..n
Filed Service Contract Header Ship-to Country/Region Code 1..n
Finance Charge Memo Header Country/Region Code 1..n
Gen. Journal Line Country/Region Code 1..n
Intrastat Jnl. Line Country/Region of Origin Code 1..n
Issued Fin. Charge Memo Header Country/Region Code 1..n
Issued Reminder Header Country/Region Code 1..n
Item Country/Region of Origin Code 1..n
Item Journal Line Country/Region Code 1..n
Item Ledger Entry Country/Region Code 1..n
Job Bill-to Country/Region Code 1..n
Job Journal Line Country/Region Code 1..n
Job Ledger Entry Country/Region Code 1..n
Job Planning Line Country/Region Code 1..n
Location Country/Region Code 1..n
Machine Center Country/Region Code 1..n
Marketing Setup Default Country/Region Code 1..n
Mini Customer Template Country/Region Code 1..n
Mini Vendor Template Country/Region Code 1..n
Order Address Country/Region Code 1..n
Payment Export Data Recipient Bank Country/Region 1..n
Post Code Country/Region Code 1..n
Purch. Cr. Memo Hdr. Ship-to Country/Region Code 1..n
Purch. Inv. Header Ship-to Country/Region Code 1..n
Purch. Rcpt. Header Ship-to Country/Region Code 1..n
Purchase Header Ship-to Country/Region Code 1..n
Purchase Header Archive Ship-to Country/Region Code 1..n
Reminder Header Country/Region Code 1..n
Resource Country/Region Code 1..n
Responsibility Center Country/Region Code 1..n
Return Receipt Header Ship-to Country/Region Code 1..n
Return Shipment Header Ship-to Country/Region Code 1..n
Sales Cr.Memo Header Ship-to Country/Region Code 1..n
Sales Header Ship-to Country/Region Code 1..n
Sales Header Archive Ship-to Country/Region Code 1..n
Sales Invoice Header Ship-to Country/Region Code 1..n
Sales Shipment Header Ship-to Country/Region Code 1..n
Segment Wizard Filter Country/Region Code Filter 1..n
Service Cr.Memo Header Ship-to Country/Region Code 1..n
Service Header Ship-to Country/Region Code 1..n
Service Invoice Header Ship-to Country/Region Code 1..n
Service Shipment Header Ship-to Country/Region Code 1..n
Ship-to Address Country/Region Code 1..n
Standard Item Journal Line Country/Region Code 1..n
Transfer Header Trsf.-to Country/Region Code 1..n
Transfer Receipt Header Trsf.-to Country/Region Code 1..n
Transfer Shipment Header Trsf.-to Country/Region Code 1..n
Union Country/Region Code 1..n
VAT Entry Country/Region Code 1..n
VAT Registration Log Country/Region Code 1..n
VAT Registration No. Format Country/Region Code 1..n
VAT Report Line Country/Region Code 1..n
Vendor Country/Region Code 1..n
Vendor Bank Account Country/Region Code 1..n
Work Center Country/Region Code 1..n