Diagrams


Table

Cash Flow Forecast Entry

DynamicsDocs.comCash Flow Forecast Entry«Table 847»Cash Flow Forecast EntryEntry No. [PK]User IDCash Flow Forecast No.Cash Flow DateDocument No.Cash Flow Account No.Source Type; [,Receivables,Payables,Li...DescriptionPayment DiscountAssociated Entry No.Associated Document No.Global Dimension 2 CodeGlobal Dimension 1 CodeRecurring Method; [,Fixed,Variable]Amount [LCY]PositiveSource No.G/L Budget NameDimension Set ID«Table 840»Cash Flow ForecastNo. [PK]Search NameDescriptionDescription 2Consider DiscountCreation DateCreated ByManual Payments ToCommentNo. SeriesManual Payments FromG/L Budget FromG/L Budget ToConsider CF Payment TermsConsider Pmt. Disc. Tol. DateConsider Pmt. Tol. AmountAccount No. FilterSource Type Filter; [,Receivables,Paya...Cash Flow Date FilterAmount [LCY]Positive Filter«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/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.Business Unit Filter...«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 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting Group«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 38»Purchase HeaderDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 850»Cash Flow Manual ExpenseCode [PK,NN]Cash Flow Account No.DescriptionStarting DateEnding DateRecurring FrequencyAmountGlobal Dimension 1 CodeGlobal Dimension 2 Code«Table 849»Cash Flow Manual RevenueCode [PK,NN]Cash Flow Account No.DescriptionStarting DateEnding DateRecurring FrequencyAmountGlobal Dimension 1 CodeGlobal Dimension 2 Code«Table 95»G/L Budget NameName [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 Code«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Cash Flow Forecast No.><Cash Flow Account No.><Global Dimension 2 Code><Global Dimension 1 Code><Source No.><Source No.><Source No.><Source No.><Source No.><Source No.><Source No.><Source No.><Source No.><G/L Budget Name><Dimension Set ID><Cash Flow Forecast Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Cash Flow Account No.><Cash Flow Account No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><Budget Filter><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bill-to Customer No.><Sell-to Customer No.><Bill-to Customer No.><Sell-to Customer No.><Customer No.><Bill-to Customer No.><Customer Filter><Pay-to Vendor No.><Buy-from Vendor No.><Pay-to Vendor No.><Vendor No.><Maintenance Vendor No.><Component of Main Asset><Dimension Set ID><Dimension Set ID><Dimension Set ID>

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

Fields

# Name Type
1 Entry No. Integer
2 User ID Code50
10 Cash Flow Forecast No. Code20
11 Cash Flow Date Date
12 Document No. Code20
13 Cash Flow Account No. Code20
14 Source Type Option Editable: No
15 Description Text50
21 Payment Discount Decimal
22 Associated Entry No. Integer
23 Associated Document No. Code20
24 Global Dimension 2 Code Code20
25 Global Dimension 1 Code Code20
26 Recurring Method Option BlankZero: Yes
29 Amount (LCY) Decimal
30 Positive Boolean Editable: No
33 Source No. Code20
35 G/L Budget Name Code10
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 Cash Flow Account No.,Cash Flow Date,Cash Flow Forecast No.
2 Cash Flow Forecast No.,Cash Flow Account No.,Source Type,Cash Flow Date,Positive
3 Cash Flow Account No.,Cash Flow Forecast No.,Global Dimension 1 Code,Global Dimension 2 Code,Cash Flow Date
4 Cash Flow Forecast No.,Cash Flow Date

Table Relations To Other Tables

Field Related Table Related Field
Cash Flow Account No. Cash Flow Account No. 1..n
Cash Flow Forecast No. Cash Flow Forecast No. 1..n
Source No. Cash Flow Manual Expense Code 1..n
Source No. Cash Flow Manual Revenue Code 1..n
Source No. Customer No. 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 1 Code Dimension Value Code 1..n
Source No. Fixed Asset No. 1..n
Source No. G/L Account No. 1..n
G/L Budget Name G/L Budget Name Name 1..n
Source No. Purchase Header No. 1..n
Source No. Sales Header No. 1..n
Source No. Service Header No. 1..n
Source No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field