Diagrams

Table

Activities Cue

DynamicsDocs.comActivities Cue«Table 1313»Activities CuePrimary Key [PK]Due Date FilterOverdue Date FilterOngoing Sales InvoicesOngoing Purchase InvoicesSales This MonthTop 10 Customer Sales YTDOverdue Purch. Invoice AmountOverdue Sales Invoice AmountAverage Collection DaysOngoing Sales QuotesRequests to ApproveSales Inv. - Pending Doc.Exch.Sales CrM. - Pending Doc.Exch.User ID FilterDue Next Week FilterMy Incoming DocumentsNon-Applied PaymentsPurch. Invoices Due Next WeekSales Invoices Due Next WeekOngoing Sales OrdersInc. Doc. Awaiting VerficationPurchase Orders

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 Due Date Filter (Due Date Filter) Date Editable: No
FlowFilter
3 Overdue Date Filter (Overdue Date Filter) Date FlowFilter
4 Ongoing Sales Invoices (Ongoing Sales Invoices) Integer FlowField
5 Ongoing Purchase Invoices (Ongoing Purchase Invoices) Integer FlowField
6 Sales This Month (Sales This Month) Decimal (0:0)
7 Top 10 Customer Sales YTD (Top 10 Customer Sales YTD) Decimal
8 Overdue Purch. Invoice Amount (Overdue Purch. Invoice Amount) Decimal (0:0)
9 Overdue Sales Invoice Amount (Overdue Sales Invoice Amount) Decimal (0:0)
10 Average Collection Days (Average Collection Days) Decimal (1:1)
11 Ongoing Sales Quotes (Ongoing Sales Quotes) Integer FlowField
12 Requests to Approve (Requests to Approve) Integer FlowField
13 Sales Inv. - Pending Doc.Exch. (Sales Inv. - Pending Doc.Exch.) Integer Editable: No
FlowField
14 Sales CrM. - Pending Doc.Exch. (Sales CrM. - Pending Doc.Exch.) Integer Editable: No
FlowField
15 User ID Filter (User ID Filter) Code50 FlowFilter
17 Due Next Week Filter (Due Next Week Filter) Date FlowFilter
20 My Incoming Documents (My Incoming Documents) Integer FlowField
21 Non-Applied Payments (Non-Applied Payments) Integer FlowField
22 Purch. Invoices Due Next Week (Purch. Invoices Due Next Week) Integer Editable: No
FlowField
23 Sales Invoices Due Next Week (Sales Invoices Due Next Week) Integer Editable: No
FlowField
24 Ongoing Sales Orders (Ongoing Sales Orders) Integer FlowField
25 Inc. Doc. Awaiting Verfication (Inc. Doc. Awaiting Verfication) Integer FlowField
26 Purchase Orders (Purchase Orders) Integer FlowField

Keys

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

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field