Table 843 "Cash Flow Setup"
Base Application · Microsoft.CashFlow.Setup
Across versions
- BC23present
- BC247 procedures changed, 2 fields changed
- BC251 fields removed
- BC262 fields removed, 1 fields changed
- BC274 procedures removed
- BC28-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.CashFlow.Setup · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 846 “Cash Flow Setup” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Cash Flow Setup |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Primary Key Δ BC24 Δ BC26 | Code[10] | — | DataClassification SystemMetadata |
| 2 | Cash Flow Forecast No. Series | Code[20] | Specifies the number series that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 308 “No. Series” (No. Series) |
| 3 | Receivables CF Account No. | Code[20] | Specifies the receivables account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 4 | Payables CF Account No. | Code[20] | Specifies the payables account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 5 | Sales Order CF Account No. | Code[20] | Specifies the sales order account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 6 | Purch. Order CF Account No. | Code[20] | Specifies the purchase order account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 8 | FA Budget CF Account No. | Code[20] | Specifies the fixed asset budget account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 9 | FA Disposal CF Account No. | Code[20] | Specifies the fixed asset disposal account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 11 | CF No. on Chart in Role Center | Code[20] | — | |
| 12 | Job CF Account No. Δ BC24 | Code[20] | Specifies the project account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 13 | Automatic Update Frequency | Option | Specifies the automatic update frequency of the cash flow forecast. The Cash Flow Forecast with “Show in Chart on Role Center” set will be used for the automatic update. via Page 846 “Cash Flow Setup” | OptionCaption: Never,Daily,Weekly |
| 14 | Tax CF Account No. | Code[20] | Specifies the tax account number that is used in cash flow forecasts. via Page 846 “Cash Flow Setup” | TableRelation Table 841 “Cash Flow Account” (Cash Flow Account) |
| 19 | Taxable Period | Option | Specifies how often tax payment is registered. via Page 846 “Cash Flow Setup” | OptionCaption: Monthly,Quarterly,Accounting Period,Yearly |
| 20 | Tax Payment Window | DateFormula | Specifies a date formula for calculating how soon after the previous tax period finished, the tax payment is registered. via Page 846 “Cash Flow Setup” | |
| 21 | Tax Bal. Account Type | Option | Specifies the type of the balancing account that your taxes are paid to. via Page 846 “Cash Flow Setup” | OptionCaption: ,Vendor,G/L Account |
| 22 | Tax Bal. Account No. | Code[20] | Specifies the balancing account that your taxes are paid to. via Page 846 “Cash Flow Setup” | TableRelation Table 15 “G/L Account”, Table 23 “Vendor” (if (“Tax Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Tax Bal. Account Type” = const(Vendor)) Vendor) |
| 23 | API Key | Text[250] | — | |
| 24 | API URL | Text[250] | Specifies the API URI to the AzureML instance. via Page 846 “Cash Flow Setup” | |
| 25 | Variance % | Integer | Specifies the range of deviation, plus or minus, that you’ll accept in the forecast. Lower percentages represent more accurate forecasts, and are typically between 20 and 40. Forecasts outside the range are considered inaccurate, and do not display. via Page 846 “Cash Flow Setup” | |
| 26 | Historical Periods | Integer | Specifies the number of historical periods to include in the forecast. via Page 846 “Cash Flow Setup” | |
| 27 | Horizon | Integer | Specifies how many periods you want the forecast to cover. via Page 846 “Cash Flow Setup” | |
| 28 | Period Type | Option | Specifies the type of period that you want to see the forecast by. via Page 846 “Cash Flow Setup” | OptionCaption: Day,Week,Month,Quarter,Year |
| 29 | TimeOut | Integer | — | |
| 30 | Service Pass API Key ID | Guid | — | |
| 33 | Time Series Model | Option | Specifies the time series model to be used for the cash flow forecast. via Page 846 “Cash Flow Setup” | OptionCaption: ‘ARIMA,ETS,STL,ETS+ARIMA,ETS+STL,ALL,TBATS’, Locked = true |
| 34 | Azure AI Enabled | Boolean | Specifies status of Azure AI forecast. via Page 846 “Cash Flow Setup” | |
| 35 | Show AzureAI Notification | Boolean | — |
Keys
- Key1: Primary Key (clustered)
Procedures
CheckAccountType(Code: Code[20])SetChartRoleCenterCFNo(CashFlowNo: Code[20])GetChartRoleCenterCFNo(): Code[20]GetTaxPaymentDueDate(ReferenceDate: Date): DateGetTaxPeriodStartEndDates(TaxDueDate: Date; var StartDate: Date; var EndDate: Date)GetTaxPaymentStartDate(TaxDueDate: Date): DateGetTaxPeriodEndDate(TaxDueDate: Date): DateGetCurrentPeriodStartDate(): DateGetCurrentPeriodEndDate(): DateUpdateTaxPaymentInfo(NewTaxablePeriod: Option; NewPaymentWindow: DateFormula; NewTaxBalAccountType: Option; NewTaxBalAccountNum: Code[20])HasValidTaxAccountInfo(): BooleanEmptyTaxBalAccountIfTypeChanged(OldTypeValue: Option)SaveUserDefinedAPIKey(APIKeyValue: SecretText)Δ BC24 + BC24 − BC27GetMLCredentials(var ApiUrl: Text[250]; var ApiKey: SecretText; var LimitValue: Decimal; var UsingStandardCredentials: Boolean): BooleanΔ BC24 Δ BC24 − BC27EnableEncryption()Δ BC24 (internal)GetUserDefinedAPIKeySecret(): SecretText+ BC24 (internal)IsAPIUserDefined(): Boolean
Plus 5 local procedures.
Relations
- drill-down page Page 846 “Cash Flow Setup”
- lookup page Page 846 “Cash Flow Setup”
- Tax Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Tax Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
- Cash Flow Forecast No. Series: TableRelation Table 308 “No. Series”
- FA Budget CF Account No.: TableRelation Table 841 “Cash Flow Account”
- FA Disposal CF Account No.: TableRelation Table 841 “Cash Flow Account”
- Job CF Account No.: TableRelation Table 841 “Cash Flow Account”
- Payables CF Account No.: TableRelation Table 841 “Cash Flow Account”
- Purch. Order CF Account No.: TableRelation Table 841 “Cash Flow Account”
- Receivables CF Account No.: TableRelation Table 841 “Cash Flow Account”
- Sales Order CF Account No.: TableRelation Table 841 “Cash Flow Account”
- Tax CF Account No.: TableRelation Table 841 “Cash Flow Account”
Pages and codeunits on this table
- Page 846 “Cash Flow Setup” (source table)
Extended by
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 1293 “Isolated Storage Management” (3 calls:
GetMLCredentials → Get,GetUserDefinedAPIKeySecret → Get,SaveUserDefinedAPIKey → Set) - Codeunit 1266 “Cryptography Management” (2 calls:
EnableEncryption → EnableEncryption,EnableEncryption → IsEncryptionEnabled) - Codeunit 2000 “Time Series Management” (1 call:
RetrieveSaaSMLCredentials → GetMLForecastCredentials) - Codeunit 457 “Environment Information” (1 call:
GetMLCredentials → IsSaaS)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Cash Flow Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.