Diagrams


DynamicsDocs.comUser«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 1103»Cost TypeNo. [PK,NN]NameSearch NameType; [Cost Type,Heading,Total,Begin-T...Cost Center CodeCost Object CodeCombine Entries; [None,Day,Month]BlockedNew PageBlank LineIndentationCommentCost Classification; [,Fixed,Variable,...Fixed ShareModified DateModified ByDate FilterCost Center FilterCost Object FilterBalance at DateNet ChangeBudget AmountTotalingBudget FilterBalanceBudget at DateG/L Account RangeDebit AmountCredit AmountBalance to AllocateBudget Debit Amount...«Table 1106»Cost Allocation SourceID [PK]LevelValid FromValid ToCost Type RangeCost Center CodeCost Object CodeVariantCredit to Cost TypeCommentTotal ShareBlockedLast Date ModifiedUser IDAllocation Source Type; [Both,Actual,B...«Table 1107»Cost Allocation TargetID [PK]Line No. [PK,NN]Target Cost TypeTarget Cost CenterTarget Cost ObjectStatic BaseStatic WeightingSharePercentCommentBase; [Static,G/L Entries,G/L Budget E...No. FilterCost Center FilterCost Object FilterDate Filter Code; [,Week,Last Week,Mon...Group FilterAllocation Target Type; [All Costs,Per...Percent per ShareAmount per ShareShare Updated onLast Date ModifiedUser ID«Table 1207»Direct Debit CollectionNo. [PK]IdentifierCreated Date-TimeCreated by UserStatus; [New,Canceled,File Created,Pos...No. of TransfersTo Bank Account No.To Bank Account NameMessage IDPartner Type; [,Company,Person]«Table 130405»CAL Test ResultNo. [PK]Test Run No.Codeunit IDCodeunit NameFunction NamePlatform; [Classic,ServiceTier]Result; [Passed,Failed,Inconclusive,In...RestoreExecution TimeError CodeError MessageFileCall StackUser IDStart TimeFinish Time«Table 130»Incoming DocumentEntry No. [PK]DescriptionCreated Date-TimeCreated By User IDCreated By User NameReleasedReleased Date-TimeReleased By User IDReleased By User NameLast Date-Time ModifiedLast Modified By User IDLast Modified By User NamePostedPosted Date-TimeDocument Type; [Journal,Sales Invoice,...Document No.Posting DateStatus; [New,Released,Rejected,Posted,...URL1URL2URL3URL4Vendor NameVendor VAT Registration No.Vendor IBANDocument DateVendor Bank Branch No.Vendor Bank Account No.Vendor No.Data Exchange TypeOCR Data Corrected...«Table 1504»Workflow Step InstanceID [PK]Workflow Code [PK]Workflow Step ID [PK]DescriptionEntry PointRecord IDCreated Date-TimeCreated By User IDLast Modified Date-TimeLast Modified By User IDStatus; [Inactive,Active,Completed,Ign...Previous Workflow Step IDNext Workflow Step IDType; [Event,Response]Function NameArgumentOriginal Workflow CodeOriginal Workflow Step IDSequence No.«Table 2000000053»Access ControlUser Security ID [PK]Role ID [PK]Company Name [PK]User NameRole NameScope; [System,Tenant] [PK]App ID [PK]App Name«Table 2000000067»User Default Style SheetUser ID [PK]Object Type; [Form,Report,Page] [PK]Object ID [PK]Program ID [PK]Style Sheet ID«Table 2000000073»User PersonalizationUser SID [PK]User IDProfile IDLanguage IDCompanyDebugger Break On ErrorDebugger Break On Rec ChangesDebugger Skip System TriggersLocale IDTime Zone«Table 2000000075»User MetadataUser SID [PK]User IDPage ID [PK]DescriptionDateTimePersonalization ID [PK]Page Metadata Delta«Table 2000000080»Page Data PersonalizationUser SID [PK]User IDObject Type; [,,,Report,,,XMLport,,Pag...Object ID [PK]DateTimePersonalization ID [PK]ValueName [PK]Value«Table 2000000110»Active SessionUser SIDServer Instance ID [PK]Session ID [PK]Server Instance NameServer Computer NameUser IDClient Type; [Windows Client,SharePoin...Client Computer NameLogin DatetimeDatabase NameSession Unique ID«Table 2000000121»User PropertyUser Security ID [PK]PasswordName IdentifierAuthentication KeyWebServices KeyWebServices Key Expiry DateAuthentication Object ID«Table 249»VAT Registration LogEntry No. [PK]VAT Registration No. [NN]Account Type; [Customer,Vendor,Contact...Account No.Country/Region Code [NN]User IDStatus; [Not Verified,Valid,Invalid]Verified NameVerified AddressVerified Date«Table 369»Selected DimensionUser ID [PK]Object Type [PK]Object ID [PK]Dimension Code [PK]New Dimension Value CodeDimension Value FilterLevel; [,Level 1,Level 2,Level 3,Level...Analysis View Code [PK]«Table 470»Job QueueCode [PK,NN]DescriptionJob Queue Category FilterServer Instance IDSession IDLast HeartbeatStartedStart Automatically From NASStart on This NAS ComputerStart on This NAS InstanceRunning as User IDRunning on Server ComputerRunning on Server InstanceSession Unique ID«Table 5075»Logged SegmentEntry No. [PK]Segment No.DescriptionNo. of InteractionsNo. of Campaign EntriesCreation DateUser IDCanceled«Table 5098»Saved Segment CriteriaCode [PK,NN]DescriptionUser IDNo. of Actions«Table 5912»Service Document LogDocument No. [PK]Entry No. [PK]Event No.Service Item Line No.AfterBeforeChange DateChange TimeUser IDDocument Type; [Quote,Order,Invoice,Cr...«Table 5942»Service Item LogService Item No. [PK,NN]Entry No. [PK]Event No.Document No.AfterBeforeChange DateChange TimeUser IDDocument Type; [,Quote,Order,Contract]«Table 5967»Contract Change LogContract Type; [Quote,Contract]Contract No. [PK]Change No. [PK]User IDDate of ChangeTime of ChangeContract Part; [Header,Line,Discount]Field DescriptionOld ValueNew ValueType of Change; [Modify,Insert,Delete,...Service Item No.Serv. Contract Line No.«Table 710»Activity LogID [PK]Record IDActivity DateUser IDStatus; [Success,Failed]ContextDescriptionActivity Message«Table 7159»Analysis Selected DimensionUser ID [PK]Object Type [PK]Object ID [PK]Dimension Code [PK]New Dimension Value CodeDimension Value FilterLevel; [,Level 1,Level 2,Level 3]Analysis View Code [PK]Analysis Area; [Sales,Purchase,Invento...«Table 8613»Config. Package TablePackage Code [PK]Table ID [PK,NN]Table NameNo. of Package RecordsNo. of Package ErrorsImported Date and TimeExported Date and TimeCommentsCreated Date and TimeCompany Filter [Source Table]Table CaptionData TemplatePackage Processing OrderPage IDProcessing OrderNo. of Fields IncludedNo. of Fields AvailableNo. of Fields to ValidatePackage CaptionImported by User IDCreated by User IDDimensions as ColumnsFilteredSkip Table TriggersProcessing Report ID«Table 9001»User Group MemberUser Group Code [PK,NN]User Security ID [PK]Company Name [PK]User NameUser Full NameUser Group Name«Table 9002»User Group Access ControlUser Group Code [PK]User Security ID [PK]Role ID [PK]Company Name [PK]User NameScope; [System,Tenant] [PK]App ID [PK]«Table 9650»Custom Report LayoutID [PK]Report IDReport NameCompany NameType; [RDLC,Word]LayoutLast ModifiedLast Modified by UserFile ExtensionDescriptionCustom XML Part<Modified By><User ID><User ID><Created by User><User ID><Created By User ID><Released By User ID><Last Modified By User ID><Created By User ID><Last Modified By User ID><User Security ID><User ID><User SID><User SID><User SID><User SID><User Security ID><User ID><User ID><Running as User ID><User ID><User ID><User ID><User ID><User ID><User ID><User ID><Imported by User ID><Created by User ID><User Security ID><User Security ID><Last Modified by User><Credit to Cost Type><Target Cost Type><ID>

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

Fields

# Name Type
1 User Security ID GUID
2 User Name Code50
3 Full Name Text80
4 State Option
5 Expiry Date DateTime
7 Windows Security ID Text119
8 Change Password Boolean
10 License Type Option
11 Authentication Email Text250
14 Contact Email Text250

Keys

# Fields
0 User Security ID Clustered: Yes
1 User Name
2 Windows Security ID

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Access Control User Security ID 1..n
Active Session User SID 1..n
Activity Log User ID 1..n
Analysis Selected Dimension User ID 1..n
Approval Comment Line User ID 1..n
Approval Entry Last Modified By User ID 1..n
Bank Account Ledger Entry User ID 1..n
Bin Creation Worksheet Line User ID 1..n
CAL Test Result User ID 1..n
CV Ledger Entry Buffer User ID 1..n
Campaign Entry User ID 1..n
Change Log Entry User ID 1..n
Check Ledger Entry User ID 1..n
Config. Package Table Created by User ID 1..n
Contract Change Log User ID 1..n
Contract Gain/Loss Entry User ID 1..n
Cost Allocation Source User ID 1..n
Cost Allocation Target User ID 1..n
Cost Budget Entry Last Modified By User 1..n
Cost Budget Register User ID 1..n
Cost Entry User ID 1..n
Cost Register User ID 1..n
Cost Type Modified By 1..n
Credit Transfer Register Created by User 1..n
Custom Report Layout Last Modified by User 1..n
DO Payment Trans. Log Entry User ID 1..n
Date Compr. Register User ID 1..n
Detailed CV Ledg. Entry Buffer User ID 1..n
Detailed Cust. Ledg. Entry User ID 1..n
Detailed Vendor Ledg. Entry User ID 1..n
Direct Debit Collection Created by User 1..n
FA Ledger Entry User ID 1..n
FA Register User ID 1..n
Filed Service Contract Header Filed By 1..n
G/L Budget Entry User ID 1..n
G/L Register User ID 1..n
Incoming Document Last Modified By User ID 1..n
Ins. Coverage Ledger Entry User ID 1..n
Insurance Register User ID 1..n
Interaction Log Entry User ID 1..n
Inventory Period Entry User ID 1..n
Issued Fin. Charge Memo Header User ID 1..n
Issued Reminder Header User ID 1..n
Item Application Entry Last Modified By User 1..n
Item Application Entry History Deleted By User 1..n
Item Budget Entry User ID 1..n
Item Register User ID 1..n
Item Tracing Buffer Created by 1..n
Job Ledger Entry User ID 1..n
Job Planning Line User ID 1..n
Job Queue Running as User ID 1..n
Job Queue Entry User ID 1..n
Job Queue Log Entry User ID 1..n
Job Register User ID 1..n
Logged Segment User ID 1..n
Maintenance Ledger Entry User ID 1..n
Notification Entry Created By 1..n
Overdue Approval Entry Approver ID 1..n
Page Data Personalization User SID 1..n
Phys. Inventory Ledger Entry User ID 1..n
Positive Pay Entry Detail User ID 1..n
Posted Approval Comment Line User ID 1..n
Posted Approval Entry Last Modified By ID 1..n
Posted Assembly Header User ID 1..n
Purch. Cr. Memo Hdr. User ID 1..n
Purch. Inv. Header User ID 1..n
Purch. Rcpt. Header User ID 1..n
Purchase Header Archive Archived By 1..n
Reminder/Fin. Charge Entry User ID 1..n
Requisition Line User ID 1..n
Res. Ledger Entry User ID 1..n
Reservation Entry Changed By 1..n
Resource Register User ID 1..n
Return Receipt Header User ID 1..n
Return Shipment Header User ID 1..n
Sales Cr.Memo Header User ID 1..n
Sales Header Archive Archived By 1..n
Sales Invoice Header User ID 1..n
Sales Shipment Header User ID 1..n
Saved Segment Criteria User ID 1..n
Selected Dimension User ID 1..n
Sent Notification Entry Created By 1..n
Service Cr.Memo Header User ID 1..n
Service Document Log User ID 1..n
Service Invoice Header User ID 1..n
Service Item Log User ID 1..n
Service Ledger Entry User ID 1..n
Service Register User ID 1..n
Service Shipment Header User ID 1..n
User Default Style Sheet User ID 1..n
User Group Access Control User Security ID 1..n
User Group Member User Security ID 1..n
User Metadata User SID 1..n
User Personalization User SID 1..1
User Property User Security ID 1..1
VAT Entry User ID 1..n
VAT Registration Log User ID 1..n
Value Entry User ID 1..n
Vendor Ledger Entry User ID 1..n
Warehouse Entry User ID 1..n
Warehouse Journal Line User ID 1..n
Warehouse Register User ID 1..n
Workflow Step Instance Last Modified By User ID 1..n
Workflow Step Instance Archive Last Modified By User ID 1..n