Diagrams

Table

Cash Flow Setup

DynamicsDocs.comCash Flow Setup«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 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 841»Cash Flow AccountNo. [PK,NN]NameSearch NameAccount Type; [Entry,Heading,Total,Beg...CommentBlockedNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterCash Flow Forecast FilterAmountGlobal Dimension 1 FilterGlobal Dimension 2 FilterTotalingSource Type; [,Receivables,Payables,Li...G/L Integration; [,Balance,Budget,Both...G/L Account Filter«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 Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc....«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 1261»Service PasswordKey [PK]Value<Cash Flow Forecast No. Series><Receivables 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.><Job CF Account No.><Tax CF Account No.><Tax Bal. Account No.><Tax Bal. Account No.><Service Pass API Key ID><No. Series><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 Primary Key (Primary Key) Code10
2 Cash Flow Forecast No. Series (Cash Flow Forecast No. Series) Code10
3 Receivables CF Account No. (Receivables CF Account No.) Code20
4 Payables CF Account No. (Payables CF Account No.) Code20
5 Sales Order CF Account No. (Sales Order CF Account No.) Code20
6 Purch. Order CF Account No. (Purch. Order CF Account No.) Code20
8 FA Budget CF Account No. (FA Budget CF Account No.) Code20
9 FA Disposal CF Account No. (FA Disposal CF Account No.) Code20
10 Service CF Account No. (Service CF Account No.) Code20
11 CF No. on Chart in Role Center (CF No. on Chart in Role Center) Code20
12 Job CF Account No. (Job CF Account No.) Code20
13 Automatic Update Frequency (Automatic Update Frequency) Option
14 Tax CF Account No. (Tax CF Account No.) Code20
19 Taxable Period (Taxable Period) Option
20 Tax Payment Window (Tax Payment Window) DateFormula
21 Tax Bal. Account Type (Tax Bal. Account Type) Option
22 Tax Bal. Account No. (Tax Bal. Account No.) Code20
23 API Key (API Key) Text250
24 API URL (API URL) Text250
25 Variance % (Variance %) Integer
26 Historical Periods (Historical Periods) Integer
27 Horizon (Horizon) Integer
28 Period Type (Period Type) Option
29 TimeOut (TimeOut) Integer
30 Service Pass API Key ID (Service Pass API Key ID) GUID
31 Cortana Intelligence Enabled (Cortana Intelligence Enabled) Boolean
32 Show Cortana Notification (Show Cortana Notification) Boolean

Keys

# Fields
0 Primary Key (Primary Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Tax CF Account No. (Tax CF Account No.) Cash Flow Account No. (No.) 1..n
Tax Bal. Account No. (Tax Bal. Account No.) G/L Account No. (No.) 1..n
Cash Flow Forecast No. Series (Cash Flow Forecast No. Series) No. Series Code (Code) 1..n
Service Pass API Key ID (Service Pass API Key ID) Service Password Key (Key) 1..n
Tax Bal. Account No. (Tax Bal. Account No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field