Diagrams

Table

Overdue Approval Entry

DynamicsDocs.comOverdue Approval Entry«Table 458»Overdue Approval EntryTable ID [PK]Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Sent to IDSent Time [PK]Sent Date [PK]E-MailSent to NameSequence No. [PK]Due DateApprover IDApproval CodeApproval Type; [Workflow User Group,Sa...Limit Type; [Approval Limits,Credit Li...Record ID to Approve [PK]«Table 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 38»Purchase HeaderDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.No. [PK]Pay-to Vendor No. [NN]Pay-to NamePay-to Name 2Pay-to AddressPay-to Address 2Pay-to CityPay-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateExpected Receipt DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeVendor Posting Group...«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter«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<Document No.><Document No.><Sent to ID><Approver ID><Assigned User ID><Assigned User ID><Approver ID><Substitute>

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 Sent to ID (Sent to ID) Code50
5 Sent Time (Sent Time) Time
6 Sent Date (Sent Date) Date
7 E-Mail (E-Mail) Text100 [E-Mail]
8 Sent to Name (Sent to Name) Text30
9 Sequence No. (Sequence No.) Integer
10 Due Date (Due Date) Date
11 Approver ID (Approver ID) Code50
12 Approval Code (Approval Code) Code20
13 Approval Type (Approval Type) Option
14 Limit Type (Limit Type) Option
15 Record ID to Approve (Record ID to Approve) RecordID

Keys

# Fields
0 Table ID,Document Type,Document No.,Sequence No.,Sent Date,Sent Time,Record ID to Approve (Table ID,Document Type,Document No.,Sequence No.,Sent Date,Sent Time,Record ID to Approve) Clustered: Yes
1 Approver ID (Approver ID)

Table Relations To Other Tables

Field Related Table Related Field
Document No. (Document No.) Purchase Header No. (No.) 1..n
Document No. (Document No.) Sales Header No. (No.) 1..n
Approver ID (Approver ID) User User Name (User Name) 1..n
Sent to ID (Sent to ID) User Setup User ID (User ID) 1..n

Table Relations From Other Tables

From Table From Field