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 (Table ID) Integer
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) Code20
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 ID (Last Modified By 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
22 Posted Record ID (Posted Record ID) RecordID
23 Delegation Date Formula (Delegation Date Formula) DateFormula
26 Number of Approved Requests (Number of Approved Requests) Integer
27 Number of Rejected Requests (Number of Rejected Requests) Integer
28 Iteration No. (Iteration No.) Integer
29 Entry No. (Entry No.) Integer AutoIncrement: Yes

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field