Diagrams


Table

User Setup

DynamicsDocs.comUser Setup«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 1512»Notification SetupUser ID [PK]Notification Type; [New Record,Approva...Notification Method; [Email,Note]Schedule; [Instantly,Daily,Weekly,Mont...Display Target; [Web,Windows]«Table 1513»Notification ScheduleUser ID [PK]Notification Type; [New Record,Approva...Recurrence; [Instantly,Daily,Weekly,Mo...TimeDaily Frequency; [Weekday,Daily]MondayTuesdayWednesdayThursdayFridaySaturdaySundayDate of MonthMonthly Notification Date; [First Work...Last Scheduled Job«Table 1523»Workflow Step ArgumentID [PK]Type; [Event,Response]General Journal Template NameGeneral Journal Batch NameNotification User IDNotification User License Type; [Full...Response Function NameLink Target PageCustom LinkEvent ConditionsApprover Type; [Salesperson/Purchaser,...Approver Limit Type; [Approver Chain,D...Workflow User Group CodeDue Date FormulaMessageDelegate After; [Never,1 day,2 days,5...Show Confirmation MessageTable No.Field No.Field CaptionApprover User IDResponse Option Group«Table 1541»Workflow User Group MemberWorkflow User Group Code [PK]User Name [PK]Sequence No.«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 167»JobNo. [PK]Search DescriptionDescriptionDescription 2Bill-to Customer No.Creation DateStarting DateEnding DateStatus; [Planning,Quote,Open,Completed...Person ResponsibleGlobal Dimension 1 CodeGlobal Dimension 2 CodeJob Posting GroupBlocked; [,Posting,All]Last Date ModifiedCommentCustomer Disc. GroupCustomer Price GroupLanguage CodeScheduled Res. Qty.Resource FilterPosting Date FilterResource Gr. FilterScheduled Res. Gr. Qty.PictureBill-to NameBill-to AddressBill-to Address 2Bill-to CityBill-to CountyBill-to Post Code...«Table 1804»Approval Workflow WizardPrimary Key [PK]Approver IDSales Invoice App. WorkflowSales Amount Approval LimitPurch Invoice App. WorkflowPurch Amount Approval LimitUse Exist. Approval User SetupFieldTableNoField CaptionCustom MessageApp. Trigger; [The user sends an appro...Field Operator; [Increased,Decreased,C...Journal Batch NameFor All BatchesJournal Template Name«Table 295»Reminder HeaderNo. [PK]Customer No.NameName 2AddressAddress 2Post CodeCityCountyCountry/Region CodeLanguage CodeCurrency CodeContactYour ReferenceShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupGen. Bus. Posting GroupVAT Registration No.Reason CodePosting DateDocument DateDue DateReminder Terms CodeFin. Charge Terms CodePost InterestPost Additional FeeReminder LevelPosting DescriptionCommentRemaining Amount...«Table 302»Finance Charge Memo HeaderNo. [PK]Customer No.NameName 2AddressAddress 2Post CodeCityCountyCountry/Region CodeLanguage CodeCurrency CodeContactYour ReferenceShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupGen. Bus. Posting GroupVAT Registration No.Reason CodePosting DateDocument DateDue DateFin. Charge Terms CodePost InterestPost Additional FeePosting DescriptionCommentRemaining AmountInterest AmountAdditional Fee...«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 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 5107»Sales Header ArchiveDocument 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 5109»Purchase Header ArchiveDocument 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 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 5740»Transfer HeaderNo. [PK]Transfer-from CodeTransfer-from NameTransfer-from Name 2Transfer-from AddressTransfer-from Address 2Transfer-from Post CodeTransfer-from CityTransfer-from CountyTrsf.-from Country/Region CodeTransfer-to CodeTransfer-to NameTransfer-to Name 2Transfer-to AddressTransfer-to Address 2Transfer-to Post CodeTransfer-to CityTransfer-to CountyTrsf.-to Country/Region CodePosting DateShipment DateReceipt DateStatus; [Open,Released]CommentShortcut Dimension 1 CodeShortcut Dimension 2 CodeIn-Transit CodeNo. SeriesLast Shipment No.Last Receipt No.Transfer-from Contact...«Table 5900»Service HeaderDocument Type; [Quote,Order,Invoice,Cr...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 Date [NN]Posting DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«Table 900»Assembly HeaderDocument Type; [Quote,Order,,,Blanket...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedItem No.Variant CodeInventory Posting GroupGen. Prod. Posting GroupCommentLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodePosting DateDue DateStarting DateEnding DateBin CodeQuantityQuantity [Base]Remaining QuantityRemaining Quantity [Base]Assembled QuantityAssembled Quantity [Base]Quantity to AssembleQuantity to Assemble [Base]Reserved QuantityReserved Qty. [Base]Planning Flexibility; [Unlimited,None]...«Table 950»Time Sheet HeaderNo. [PK]Starting DateEnding DateResource No.Owner User IDApprover User IDOpen ExistsSubmitted ExistsRejected ExistsApproved ExistsPosted ExistsQuantityPosted QuantityCommentStatus Filter; [Open,Submitted,Rejecte...Job No. FilterJob Task No. FilterDate FilterPosted FilterType Filter; [,Resource,Job,Service,Ab...«Table 951»Time Sheet LineTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 954»Time Sheet Header ArchiveNo. [PK]Starting DateEnding DateResource No.Owner User IDApprover User IDQuantityCommentStatus Filter; [Open,Submitted,Rejecte...Job No. FilterJob Task No. FilterDate FilterPosted FilterType Filter; [,Resource,Job,Service,Ab...«Table 955»Time Sheet Line ArchiveTime Sheet No. [PK]Line No. [PK]Time Sheet Starting DateType; [,Resource,Job,Service,Absence,A...Job No.Job Task No.Cause of Absence CodeDescriptionWork Type CodeApprover IDService Order No.Service Order Line No.Total QuantityChargeableAssembly Order No.Assembly Order Line No.Status; [Open,Submitted,Rejected,Appro...Approved ByApproval DatePostedComment«Table 13»Salesperson/PurchaserCode [PK,NN]NameCommission %ImageGlobal Dimension 1 CodeGlobal Dimension 2 CodeE-MailPhone No.Next To-do DateNo. of OpportunitiesEstimated Value [LCY]Calcd. Current Value [LCY]Date FilterNo. of InteractionsCost [LCY]Duration [Min.]Job TitleAction Taken Filter; [,Next,Previous,U...Sales Cycle FilterSales Cycle Stage FilterProbability % FilterCompleted % FilterAvg. Estimated Value [LCY]Avg.Calcd. Current Value [LCY]Contact FilterContact Company FilterCampaign FilterEstimated Value FilterCalcd. Current Value FilterChances of Success % FilterTo-do Status Filter; [Not Started,In P......«Table 5714»Responsibility CenterCode [PK,NN]NameAddressAddress 2CityPost CodeCountry/Region CodePhone No.Fax No.Name 2ContactGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeCountyE-MailHome PageDate FilterContract Gain/Loss Amount<Salespers./Purch. Code><Approver ID><Substitute><Sales Resp. Ctr. Filter><Purchase Resp. Ctr. Filter><Service Resp. Ctr. Filter><User ID><User ID><Notification User ID><Approver User ID><User Name><Time Sheet Owner User ID><Time Sheet Approver User ID><Project Manager><Approver ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Sent to ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Assigned User ID><Owner User ID><Approver User ID><Approver ID><Approved By><Owner User ID><Approver User ID><Approver ID><Approved By><Person Responsible><Resource Filter><Resource Filter><Resource No.><Resource No.><Job No.><Job No.><Salesperson Code><Responsibility Center><Document No.><Source No.><Purchaser Code><Responsibility Center><Document No.><Salesperson Code><Responsibility Center><Purchaser Code><Responsibility Center><Salesperson Code><Responsibility Center><Service Order No.><Service Order No.><Assembly Order No.><Assembly Order No.><Time Sheet No.><Time Sheet No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 User ID Code50 NotBlank: Yes
2 Allow Posting From Date
3 Allow Posting To Date
4 Register Time Boolean
10 Salespers./Purch. Code Code10
11 Approver ID Code50
12 Sales Amount Approval Limit Integer BlankZero: Yes
13 Purchase Amount Approval Limit Integer BlankZero: Yes
14 Unlimited Sales Approval Boolean
15 Unlimited Purchase Approval Boolean
16 Substitute Code50
17 E-Mail Text100 [E-Mail]
19 Request Amount Approval Limit Integer BlankZero: Yes
20 Unlimited Request Approval Boolean
21 Approval Administrator Boolean
31 License Type Option FlowField
950 Time Sheet Admin. Boolean
5600 Allow FA Posting From Date
5601 Allow FA Posting To Date
5700 Sales Resp. Ctr. Filter Code10
5701 Purchase Resp. Ctr. Filter Code10
5900 Service Resp. Ctr. Filter Code10

Keys

# Fields
0 User ID Clustered: Yes
1 Salespers./Purch. Code

Table Relations To Other Tables

Field Related Table Related Field
Service Resp. Ctr. Filter Responsibility Center Code 1..n
Salespers./Purch. Code Salesperson/Purchaser Code 1..n
Substitute User Setup User ID 1..n

Table Relations From Other Tables

From Table From Field
Approval Workflow Wizard Approver ID 1..n
Assembly Header Assigned User ID 1..n
Finance Charge Memo Header Assigned User ID 1..n
Job Project Manager 1..n
Notification Schedule User ID 1..n
Notification Setup User ID 1..n
Overdue Approval Entry Sent to ID 1..n
Production Order Assigned User ID 1..n
Purchase Header Assigned User ID 1..n
Purchase Header Archive Assigned User ID 1..n
Reminder Header Assigned User ID 1..n
Resource Time Sheet Approver User ID 1..n
Sales Header Assigned User ID 1..n
Sales Header Archive Assigned User ID 1..n
Service Header Assigned User ID 1..n
Time Sheet Header Approver User ID 1..n
Time Sheet Header Archive Approver User ID 1..n
Time Sheet Line Approved By 1..n
Time Sheet Line Archive Approved By 1..n
Transfer Header Assigned User ID 1..n
User Setup Substitute 1..n
Workflow Step Argument Approver User ID 1..n
Workflow User Group Member User Name 1..n