Diagrams

Table

Job Register

DynamicsDocs.comJob Register«Table 241»Job RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«Table 87»Date Compr. RegisterNo. [PK]Creation DateTable CaptionPeriod Length; [Day,Week,Month,Quarter...Ending DateNo. of New RecordsNo. Records DeletedUser IDFilterStarting DateTable IDRegister No.Source CodeRetain Field ContentsRetain Totals«Table 169»Job Ledger EntryEntry No. [PK]Job No.Posting DateDocument No.Type; [Resource,Item,G/L Account]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeJob Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeWork Type CodeCustomer Price GroupUser IDSource CodeAmt. to Post to G/LAmt. Posted to G/LEntry Type; [Usage,Sale]Journal Batch NameReason CodeTransaction TypeTransport MethodCountry/Region Code...«Table 230»Source CodeCode [PK,NN]Description«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<From Entry No.><To Entry No.><Source Code><User ID><Register No.><User ID><Source Code><User ID><Source Code>

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

Fields

# Name Type
1 No. (No.) Integer
2 From Entry No. (From Entry No.) Integer
3 To Entry No. (To Entry No.) Integer
4 Creation Date (Creation Date) Date
5 Source Code (Source Code) Code10
6 User ID (User ID) Code50
7 Journal Batch Name (Journal Batch Name) Code10

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Creation Date (Creation Date)
2 Source Code,Journal Batch Name,Creation Date (Source Code,Journal Batch Name,Creation Date)

Table Relations To Other Tables

Field Related Table Related Field
To Entry No. (To Entry No.) Job Ledger Entry Entry No. (Entry No.) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field
Date Compr. Register Register No. (Register No.) 1..n