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 EmailExchange IdentifierApplication ID«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 ZoneLicense Type; [Full User,Limited User,...«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 2000000189»Tenant License StateStart Date [PK]End DateState; [Evaluation,Trial,Paid,Warning,...User Security ID«Table 2000000197»Token CacheUser Security ID [PK]User Unique IDTenant IDCache Write TimeCache Data«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 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 MessageDetailed InfoTable No Filter«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 TriggersDelete Recs Before ProcessingProcessing Report IDParent Table IDValidated«Table 9001»User Group MemberUser Group Code [PK,NN]User Security ID [PK,NN]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 9005»User PlanUser Security ID [PK]Plan ID [PK]User NameUser Full NamePlan Name«Table 9062»User Security StatusUser Security ID [PK]User NameFull NameReviewedBelongs To Subscription PlanBelongs to User GroupUsers - To reviewUsers - Without SubscriptionsUsers - Not Group Members«Table 9178»Application Area SetupCompany Name [PK]Profile ID [PK]User ID [PK]BasicSuiteRelationship MgmtJobsFixed Assets<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 Security ID><User Security ID><User ID><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><User Security ID><User Security ID><User ID><Credit to Cost Type><Target Cost Type><ID><Parent Table 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 (User Security ID) GUID
2 User Name (User Name) Code50
3 Full Name (Full Name) Text80
4 State (State) Option
5 Expiry Date (Expiry Date) DateTime
7 Windows Security ID (Windows Security ID) Text119
8 Change Password (Change Password) Boolean
10 License Type (License Type) Option
11 Authentication Email (Authentication Email) Text250
14 Contact Email (Contact Email) Text250
15 Exchange Identifier (Exchange Identifier) Text250
16 Application ID (Application ID) GUID

Keys

# Fields
0 User Security ID (User Security ID) Clustered: Yes
1 User Name (User Name)
2 Windows Security ID (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 (User Security ID) 1..n
Active Session User SID (User SID) 1..n
Activity Log User ID (User ID) 1..n
Analysis Selected Dimension User ID (User ID) 1..n
Application Area Setup User ID (User ID) 1..n
Approval Comment Line User ID (User ID) 1..n
Approval Entry Last Modified By User ID (Last Modified By User ID) 1..n
Bank Account Ledger Entry User ID (User ID) 1..n
Bin Creation Worksheet Line User ID (User ID) 1..n
CAL Test Result User ID (User ID) 1..n
CV Ledger Entry Buffer User ID (User ID) 1..n
Campaign Entry User ID (User ID) 1..n
Change Log Entry User ID (User ID) 1..n
Check Ledger Entry User ID (User ID) 1..n
Config. Package Table Created by User ID (Created by User ID) 1..n
Contract Change Log User ID (User ID) 1..n
Contract Gain/Loss Entry User ID (User ID) 1..n
Cost Allocation Source User ID (User ID) 1..n
Cost Allocation Target User ID (User ID) 1..n
Cost Budget Entry Last Modified By User (Last Modified By User) 1..n
Cost Budget Register User ID (User ID) 1..n
Cost Entry User ID (User ID) 1..n
Cost Register User ID (User ID) 1..n
Cost Type Modified By (Modified By) 1..n
Credit Transfer Register Created by User (Created by User) 1..n
Date Compr. Register User ID (User ID) 1..n
Detailed CV Ledg. Entry Buffer User ID (User ID) 1..n
Detailed Cust. Ledg. Entry User ID (User ID) 1..n
Detailed Vendor Ledg. Entry User ID (User ID) 1..n
Direct Debit Collection Created by User (Created by User) 1..n
FA Ledger Entry User ID (User ID) 1..n
FA Register User ID (User ID) 1..n
Filed Service Contract Header Filed By (Filed By) 1..n
G/L Budget Entry User ID (User ID) 1..n
G/L Register User ID (User ID) 1..n
Incoming Document Last Modified By User ID (Last Modified By User ID) 1..n
Ins. Coverage Ledger Entry User ID (User ID) 1..n
Insurance Register User ID (User ID) 1..n
Interaction Log Entry User ID (User ID) 1..n
Inventory Period Entry User ID (User ID) 1..n
Issued Fin. Charge Memo Header User ID (User ID) 1..n
Issued Reminder Header User ID (User ID) 1..n
Item Application Entry Last Modified By User (Last Modified By User) 1..n
Item Application Entry History Deleted By User (Deleted By User) 1..n
Item Budget Entry User ID (User ID) 1..n
Item Register User ID (User ID) 1..n
Item Tracing Buffer Created by (Created by) 1..n
Job Ledger Entry User ID (User ID) 1..n
Job Planning Line User ID (User ID) 1..n
Job Queue Entry User ID (User ID) 1..n
Job Queue Log Entry User ID (User ID) 1..n
Job Register User ID (User ID) 1..n
Logged Segment User ID (User ID) 1..n
Maintenance Ledger Entry User ID (User ID) 1..n
Notification Entry Created By (Created By) 1..n
Overdue Approval Entry Approver ID (Approver ID) 1..n
Page Data Personalization User SID (User SID) 1..n
Phys. Inventory Ledger Entry User ID (User ID) 1..n
Positive Pay Entry Detail User ID (User ID) 1..n
Posted Approval Comment Line User ID (User ID) 1..n
Posted Approval Entry Last Modified By ID (Last Modified By ID) 1..n
Posted Assembly Header User ID (User ID) 1..n
Purch. Cr. Memo Hdr. User ID (User ID) 1..n
Purch. Inv. Header User ID (User ID) 1..n
Purch. Rcpt. Header User ID (User ID) 1..n
Purchase Header Archive Archived By (Archived By) 1..n
Reminder/Fin. Charge Entry User ID (User ID) 1..n
Requisition Line User ID (User ID) 1..n
Res. Ledger Entry User ID (User ID) 1..n
Reservation Entry Changed By (Changed By) 1..n
Resource Register User ID (User ID) 1..n
Return Receipt Header User ID (User ID) 1..n
Return Shipment Header User ID (User ID) 1..n
Sales Cr.Memo Header User ID (User ID) 1..n
Sales Header Archive Archived By (Archived By) 1..n
Sales Invoice Header User ID (User ID) 1..n
Sales Shipment Header User ID (User ID) 1..n
Saved Segment Criteria User ID (User ID) 1..n
Selected Dimension User ID (User ID) 1..n
Sent Notification Entry Created By (Created By) 1..n
Service Cr.Memo Header User ID (User ID) 1..n
Service Document Log User ID (User ID) 1..n
Service Invoice Header User ID (User ID) 1..n
Service Item Log User ID (User ID) 1..n
Service Ledger Entry User ID (User ID) 1..n
Service Register User ID (User ID) 1..n
Service Shipment Header User ID (User ID) 1..n
Tenant License State User Security ID (User Security ID) 1..n
Token Cache User Security ID (User Security ID) 1..1
User Default Style Sheet User ID (User ID) 1..n
User Group Access Control User Security ID (User Security ID) 1..n
User Group Member User Security ID (User Security ID) 1..n
User Metadata User SID (User SID) 1..n
User Personalization User SID (User SID) 1..1
User Plan User Security ID (User Security ID) 1..n
User Property User Security ID (User Security ID) 1..1
User Security Status User Security ID (User Security ID) 1..1
VAT Entry User ID (User ID) 1..n
VAT Registration Log User ID (User ID) 1..n
Value Entry User ID (User ID) 1..n
Vendor Ledger Entry User ID (User ID) 1..n
Warehouse Entry User ID (User ID) 1..n
Warehouse Journal Line User ID (User ID) 1..n
Warehouse Register User ID (User ID) 1..n
Workflow Step Instance Last Modified By User ID (Last Modified By User ID) 1..n
Workflow Step Instance Archive Last Modified By User ID (Last Modified By User ID) 1..n