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,Open,Completed...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. SeriesImageType; [Company,Person]Company No.Company NameLookup Contact No.First Name...«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.Custom Layout CodeCustom Layout Description«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«Table 7502»Item Attribute TranslationAttribute ID [PK,NN]Language Code [PK,NN]Name«Table 7503»Item Attr. Value TranslationAttribute ID [PK,NN]ID [PK,NN]Language Code [PK,NN]Name<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><Language Code><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 Code><Customer No.><Primary Contact No.><Pay-to Vendor No.><Preferred Bank Account Code><Vendor No.><Primary Contact No.><Company No.><Lookup Contact No.><Contact No. Filter><Contact No.><Contact Company No.><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 (Code) Code10 NotBlank: Yes
2 Name (Name) Text50
6 Windows Language ID (Windows Language ID) Integer BlankZero: Yes
7 Windows Language Name (Windows Language Name) Text80 Editable: No
FlowField

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

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