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

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Record ID to Approve,Workflow Step Instance ID,Sequence No. (Record ID to Approve,Workflow Step Instance ID,Sequence No.)
2 Table ID,Document Type,Document No.,Sequence No.,Record ID to Approve (Table ID,Document Type,Document No.,Sequence No.,Record ID to Approve)
3 Approver ID,Status (Approver ID,Status)
4 Sender ID (Sender ID)
5 Due Date (Due Date)
6 Table ID,Record ID to Approve,Status,Workflow Step Instance ID,Sequence No. (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) Currency Code (Code) 1..n
Last Modified By User ID (Last Modified By User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field