Diagrams


Table

Text-to-Account Mapping

DynamicsDocs.comText-to-Account Mapping«Table 1251»Text-to-Account MappingLine No. [PK]Mapping Text [NN]Debit Acc. No.Credit Acc. No.Bal. Source Type; [G/L Account,Custome...Bal. Source No.Vendor No.«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«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...<Debit Acc. No.><Credit Acc. No.><Bal. Source No.><Bal. Source No.><Bal. Source No.><Vendor No.><Bal. Source No.><Bill-to Customer No.><Pay-to Vendor No.>

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

Fields

# Name Type
1 Line No. (Line No.) Integer
2 Mapping Text (Mapping Text) Text250 NotBlank: Yes
3 Debit Acc. No. (Debit Acc. No.) Code20
4 Credit Acc. No. (Credit Acc. No.) Code20
5 Bal. Source Type (Bal. Source Type) Option
6 Bal. Source No. (Bal. Source No.) Code20
7 Vendor No. (Vendor No.) Code20

Keys

# Fields
0 Line No. (Line No.) Clustered: Yes
1 Mapping Text,Vendor No. (Mapping Text,Vendor No.)

Table Relations To Other Tables

Field Related Table Related Field
Bal. Source No. (Bal. Source No.) Bank Account No. (No.) 1..n
Bal. Source No. (Bal. Source No.) Customer No. (No.) 1..n
Bal. Source No. (Bal. Source No.) G/L Account () 1..n
Vendor No. (Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field