Diagrams


Table

Approval Entry

DynamicsDocs.comApproval Entry«Table 454»Approval EntryTable IDDocument Type; [Quote,Order,Invoice,Cr...Document No.Sequence No.Approval CodeSender IDSalespers./Purch. CodeApprover IDStatus; [Created,Open,Canceled,Rejecte...Date-Time Sent for ApprovalLast Date-Time ModifiedLast Modified By User IDCommentDue DateAmountAmount [LCY]Currency CodeApproval Type; [Workflow User Group,Sa...Limit Type; [Approval Limits,Credit Li...Available Credit Limit [LCY]Pending ApprovalsRecord ID to ApproveDelegation Date FormulaNumber of Approved RequestsNumber of Rejected RequestsEntry No. [PK]Workflow Step Instance IDRelated to Change«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...<Sender ID><Approver ID><Last Modified By User ID><Currency Code>

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

Fields

# Name Type
1 Table ID Integer
2 Document Type Option
3 Document No. Code20
4 Sequence No. Integer
5 Approval Code Code20
6 Sender ID Code50
7 Salespers./Purch. Code Code10
8 Approver ID Code50
9 Status Option
10 Date-Time Sent for Approval DateTime
11 Last Date-Time Modified DateTime
12 Last Modified By User ID Code50
13 Comment Boolean Editable: No
FlowField
14 Due Date Date
15 Amount Decimal
16 Amount (LCY) Decimal
17 Currency Code Code10
18 Approval Type Option
19 Limit Type Option
20 Available Credit Limit (LCY) Decimal
21 Pending Approvals Integer FlowField
22 Record ID to Approve RecordID
23 Delegation Date Formula DateFormula
26 Number of Approved Requests Integer FlowField
27 Number of Rejected Requests Integer FlowField
29 Entry No. Integer AutoIncrement: Yes
30 Workflow Step Instance ID GUID
31 Related to Change Boolean FlowField

Keys

# Fields
0 Entry No. Clustered: Yes
1 Record ID to Approve,Workflow Step Instance ID,Sequence No.
2 Table ID,Document Type,Document No.,Sequence No.,Record ID to Approve
3 Approver ID,Status
4 Sender ID
5 Due Date
6 Table ID,Record ID to Approve,Status,Workflow Step Instance ID,Sequence No.

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Last Modified By User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field