Diagrams


Table

Cost Register

DynamicsDocs.comCost Register«Table 1105»Cost RegisterNo. [PK]Source; [Transfer from G/L,Cost Journa...TextFrom G/L Entry No.To G/L Entry No.From Cost Entry No.To Cost Entry No.No. of EntriesDebit AmountCredit AmountProcessed DatePosting DateClosedLevelUser IDJournal Batch Name«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«Table 1104»Cost EntryEntry No. [PK]Cost Type No.Posting DateDocument No.DescriptionAmountDebit AmountCredit AmountCost Center CodeCost Object CodeReason CodeG/L AccountG/L Entry No.Source CodeSystem-Created EntryAllocatedAllocated with Journal No.User IDBatch NameAllocation DescriptionAllocation IDAdditional-Currency AmountAdd.-Currency Debit AmountAdd.-Currency Credit Amount«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 1100»Cost Journal TemplateName [PK,NN]DescriptionReason CodeSource CodePosting Report IDPosting Report Caption<From G/L Entry No.><To G/L Entry No.><From Cost Entry No.><To Cost Entry No.><User ID><Journal Batch Name><Reversed by Entry No.><Reversed Entry No.><G/L Entry No.><User ID>

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 Editable: No
2 Source (Source) Option Editable: No
3 Text (Text) Text30 Editable: No
4 From G/L Entry No. (From G/L Entry No.) Integer BlankZero: Yes
Editable: No
5 To G/L Entry No. (To G/L Entry No.) Integer BlankZero: Yes
Editable: No
6 From Cost Entry No. (From Cost Entry No.) Integer BlankZero: Yes
Editable: No
7 To Cost Entry No. (To Cost Entry No.) Integer BlankZero: Yes
Editable: No
8 No. of Entries (No. of Entries) Integer Editable: No
15 Debit Amount (Debit Amount) Decimal BlankZero: Yes
Editable: No
16 Credit Amount (Credit Amount) Decimal BlankZero: Yes
Editable: No
20 Processed Date (Processed Date) Date Editable: No
21 Posting Date (Posting Date) Date Editable: No
23 Closed (Closed) Boolean
25 Level (Level) Integer BlankZero: Yes
Editable: No
31 User ID (User ID) Code50 Editable: No
32 Journal Batch Name (Journal Batch Name) Code10 Editable: No

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Source (Source)
2 Closed (Closed)

Table Relations To Other Tables

Field Related Table Related Field
To Cost Entry No. (To Cost Entry No.) Cost Entry Entry No. (Entry No.) 1..n
Journal Batch Name (Journal Batch Name) Cost Journal Template Name (Name) 1..n
To G/L Entry No. (To G/L Entry No.) G/L Entry Entry No. (Entry No.) 1..n
User ID (User ID) User User Name (User Name) 1..n

Table Relations From Other Tables

From Table From Field