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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field