Diagrams


Table

Posted Approval Entry

DynamicsDocs.comPosted Approval Entry«Table 456»Posted Approval EntryTable IDDocument No.Sequence No.Approval CodeSender IDSalespers./Purch. CodeApprover IDStatus; [Created,Open,Canceled,Rejecte...Date-Time Sent for ApprovalLast Date-Time ModifiedLast Modified By IDCommentDue DateAmountAmount [LCY]Currency CodeApproval Type; [Workflow User Group,Sa...Limit Type; [Approval Limits,Credit Li...Available Credit Limit [LCY]Posted Record IDDelegation Date FormulaNumber of Approved RequestsNumber of Rejected RequestsIteration No.Entry No. [PK]«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«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 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
3 Document No. Code20
4 Sequence No. Integer
5 Approval Code Code20
6 Sender ID Code50
7 Salespers./Purch. Code Code20
8 Approver ID Code50
9 Status Option
10 Date-Time Sent for Approval DateTime
11 Last Date-Time Modified DateTime
12 Last Modified By 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
22 Posted Record ID RecordID
23 Delegation Date Formula DateFormula
26 Number of Approved Requests Integer
27 Number of Rejected Requests Integer
28 Iteration No. Integer
29 Entry No. Integer AutoIncrement: Yes

Keys

# Fields
0 Entry No. Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field