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...DescriptionOverduePayment 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 FilterOverdue CF Dates to Work DateDefault G/L Budget Name«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 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 21»Cust. Ledger EntryEntry No. [PK]Customer No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales [LCY]Profit [LCY]Inv. Discount [LCY]Sell-to Customer No.Customer Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«Table 25»Vendor Ledger EntryEntry No. [PK]Vendor No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Purchase [LCY]Inv. Discount [LCY]Buy-from Vendor No.Vendor Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodePurchaser CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Rcd.[LCY]PositiveClosed by Entry No....«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 GroupAcquiredImage...«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 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 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.><Source No.><G/L Budget Name><Dimension Set ID><Default G/L Budget Name><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 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><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.><Bal. Account No.><Bal. Account No.><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Dimension Set ID><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Dimension Set ID><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. (Entry No.) Integer
2 User ID (User ID) Code50
10 Cash Flow Forecast No. (Cash Flow Forecast No.) Code20
11 Cash Flow Date (Cash Flow Date) Date
12 Document No. (Document No.) Code20
13 Cash Flow Account No. (Cash Flow Account No.) Code20
14 Source Type (Source Type) Option Editable: No
15 Description (Description) Text250
16 Overdue (Overdue) Boolean Editable: No
21 Payment Discount (Payment Discount) Decimal
22 Associated Entry No. (Associated Entry No.) Integer
23 Associated Document No. (Associated Document No.) Code20
24 Global Dimension 2 Code (Global Dimension 2 Code) Code20
25 Global Dimension 1 Code (Global Dimension 1 Code) Code20
26 Recurring Method (Recurring Method) Option BlankZero: Yes
29 Amount (LCY) (Amount (LCY)) Decimal
30 Positive (Positive) Boolean Editable: No
33 Source No. (Source No.) Code20
35 G/L Budget Name (G/L Budget Name) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Cash Flow Account No.,Cash Flow Date,Cash Flow Forecast No. (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 (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 (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 (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.) Cash Flow Account No. (No.) 1..n
Cash Flow Forecast No. (Cash Flow Forecast No.) Cash Flow Forecast No. (No.) 1..n
Source No. (Source No.) Cash Flow Manual Expense Code (Code) 1..n
Source No. (Source No.) Cash Flow Manual Revenue Code (Code) 1..n
Source No. (Source No.) Cust. Ledger Entry Document No. (Document No.) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 1 Code (Global Dimension 1 Code) Dimension Value Code (Code) 1..n
Source No. (Source No.) Fixed Asset No. (No.) 1..n
Source No. (Source No.) G/L Account No. (No.) 1..n
G/L Budget Name (G/L Budget Name) G/L Budget Name Name (Name) 1..n
Source No. (Source No.) Job No. (No.) 1..n
Source No. (Source No.) Purchase Header No. (No.) 1..n
Source No. (Source No.) Sales Header No. (No.) 1..n
Source No. (Source No.) Service Header No. (No.) 1..n
Source No. (Source No.) Vendor Ledger Entry Document No. (Document No.) 1..n

Table Relations From Other Tables

From Table From Field