Diagrams


Table

Language

DynamicsDocs.comLanguage«Table 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 1052»Reminder Terms TranslationReminder Terms Code [PK]Language Code [PK,NN]Note About Line Fee on Report«Table 1053»Line Fee Note on Report Hist.Cust. Ledger Entry No [PK]Due Date [PK]Language Code [PK,NN]Reminder Terms Code [PK]Reminder Level No [PK]ReportText [NN]«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 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 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 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 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 30»Item TranslationItem No. [PK,NN]Language Code [PK,NN]DescriptionDescription 2Variant Code [PK]«Table 462»Payment Term TranslationPayment Term [PK]Language Code [PK]Description«Table 463»Shipment Method TranslationShipment Method [PK]Language Code [PK]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. SeriesType; [Company,Person]Company No.Company NameLookup Contact No.First NameMiddle Name...«Table 5064»Interaction TemplateCode [PK,NN]Interaction Group Code [NN]DescriptionUnit Cost [LCY]Unit Duration [Min.]Information Flow; [,Outbound,Inbound]Initiated By; [,Us,Them]Attachment No.Campaign No.Campaign TargetCampaign ResponseCorrespondence Type [Default]; [,Hard...Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Language Code [Default]Wizard Action; [,Open,Import]Ignore Contact Corres. Type«Table 5069»Salutation FormulaSalutation Code [PK,NN]Language Code [PK]Salutation Type; [Formal,Informal] [PK...SalutationName 1; [,Job Title,First Name,Middle...Name 2; [,Job Title,First Name,Middle...Name 3; [,Job Title,First Name,Middle...Name 4; [,Job Title,First Name,Middle...Name 5; [,Job Title,First Name,Middle...Contact No. Filter«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 5080»To-doNo. [PK]Team CodeSalesperson CodeCampaign No.Contact No.Opportunity No.Segment No.Type; [,Meeting,Phone Call]Date [NN]Status; [Not Started,In Progress,Compl...Priority; [Low,Normal,High]DescriptionClosedDate ClosedNo. SeriesCommentCanceledContact NameTeam NameSalesperson NameCampaign DescriptionContact Company No.Contact Company NameRecurringRecurring Date IntervalCalc. Due Date From; [,Due Date,Closin...Opportunity DescriptionStart TimeDurationOpportunity Entry No.Last Date Modified...«Table 5103»Interaction Tmpl. LanguageInteraction Template Code [PK]Language Code [PK]DescriptionAttachment No.«Table 5104»Segment Interaction LanguageSegment No. [PK]Segment Line No. [PK]Language Code [PK]DescriptionAttachment No.Subject«Table 5196»To-do Interaction LanguageTo-do No. [PK]Language Code [PK]DescriptionAttachment No.«Table 5402»Unit of Measure TranslationCode [PK,NN]Language Code [PK,NN]Description [NN]«Table 561»VAT Clause TranslationVAT Clause Code [PK]Language Code [PK]DescriptionDescription 2«Table 5968»Service Contract TemplateNo. [PK]DescriptionInvoice Period; [Month,Two Months,Quar...Max. Labor Unit PriceCombine InvoicesPrepaidService Zone CodeLanguage CodeDefault Response Time [Hours]Contract Lines on InvoiceDefault Service PeriodInvoice after ServiceAllow Unbalanced AmountsContract Group CodeService Order TypeAutomatic Credit MemosNo. SeriesPrice Update PeriodPrice Inv. Increase CodeServ. Contract Acc. Gr. Code<Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code (Default)><Language Code><Default Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Language Code><Invoice Disc. Code><Bill-to Customer No.><Bill-to Customer No.><Preferred Bank Account><Customer No.><Primary Contact No.><Pay-to Vendor No.><Preferred Bank Account><Vendor No.><Primary Contact No.><Company No.><Lookup Contact No.><Contact No. Filter><Contact No.><Contact Company No.><Interaction Template Code><Interaction Template Code><Organizer To-do No.><To-do 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 Windows Language ID Integer BlankZero: Yes
7 Windows Language Name Text80 Editable: No
FlowField

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Windows Language ID Windows Language 1..n

Table Relations From Other Tables

From Table From Field
Bank Account Language Code 1..n
Contact Language Code 1..n
Customer Language Code 1..n
Customer Bank Account Language Code 1..n
Extended Text Header Language Code 1..n
Extended Text Line Language Code 1..n
Filed Service Contract Header Language Code 1..n
Finance Charge Memo Header Language Code 1..n
Generic Chart Captions Buffer Language Code 1..n
Generic Chart Memo Buffer Language Code 1..n
Interaction Log Entry Interaction Language Code 1..n
Interaction Template Language Code (Default) 1..n
Interaction Tmpl. Language Language Code 1..n
Issued Fin. Charge Memo Header Language Code 1..n
Issued Reminder Header Language Code 1..n
Item Translation Language Code 1..n
Job Language Code 1..n
Line Fee Note on Report Hist. Language Code 1..n
Marketing Setup Default Language Code 1..n
Mini Customer Template Language Code 1..n
Mini Vendor Template Language Code 1..n
Payment Term Translation Language Code 1..n
Purch. Cr. Memo Hdr. Language Code 1..n
Purch. Inv. Header Language Code 1..n
Purch. Rcpt. Header Language Code 1..n
Purchase Header Language Code 1..n
Purchase Header Archive Language Code 1..n
Reminder Header Language Code 1..n
Reminder Terms Translation Language Code 1..n
Return Receipt Header Language Code 1..n
Return Shipment Header Language Code 1..n
Sales Cr.Memo Header Language Code 1..n
Sales Header Language Code 1..n
Sales Header Archive Language Code 1..n
Sales Invoice Header Language Code 1..n
Sales Shipment Header Language Code 1..n
Salutation Formula Language Code 1..n
Segment Header Language Code (Default) 1..n
Segment Interaction Language Language Code 1..n
Segment Line Language Code 1..n
Service Contract Header Language Code 1..n
Service Contract Template Language Code 1..n
Service Cr.Memo Header Language Code 1..n
Service Header Language Code 1..n
Service Invoice Header Language Code 1..n
Service Shipment Header Language Code 1..n
Shipment Method Translation Language Code 1..n
To-do Language Code 1..n
To-do Interaction Language Language Code 1..n
Unit of Measure Translation Language Code 1..n
VAT Clause Translation Language Code 1..n
Vendor Language Code 1..n
Vendor Bank Account Language Code 1..n