Diagrams


Table

Cost Entry

DynamicsDocs.comCost Entry«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 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 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 1112»Cost CenterCode [PK,NN]NameCost Subtype; [,Service Cost Center,Au...Cost Type FilterDate FilterNet ChangeBalance at DateBalance to AllocateResponsible PersonSorting OrderCommentLine Type; [Cost Center,Heading,Total,...BlockedNew PageBlank LineIndentationTotaling«Table 1113»Cost ObjectCode [PK,NN]NameCost Type FilterDate FilterNet ChangeBalance at DateSorting OrderCommentLine Type; [Cost Object,Heading,Total,...BlockedNew PageBlank LineIndentationTotaling«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«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 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 Email«Table 232»Gen. Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceAllow Payment ExportBank Statement Import FormatTemplate Type; [General,Sales,Purchase...Recurring«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...<Cost Type No.><Cost Center Code><Cost Object Code><Reason Code><G/L Account><G/L Entry No.><Source Code><User ID><Batch Name><Allocation ID><From Cost Entry No.><To Cost Entry No.><From G/L Entry No.><To G/L Entry No.><User ID><Cost Center Code><Cost Center Filter><Cost Type Filter><Cost Object Code><Cost Object Filter><Cost Type Filter><Modified By><Credit to Cost Type><Cost Center Code><Cost Object Code><Reason Code><Reason Code><G/L Account No.><Bal. Account No.><Bal. Account No.><Source Code><Reversed by Entry No.><Reversed 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 Entry No. (Entry No.) Integer
4 Cost Type No. (Cost Type No.) Code20
5 Posting Date (Posting Date) Date [ClosingDates:Yes]
7 Document No. (Document No.) Code20
8 Description (Description) Text80
16 Amount (Amount) Decimal BlankZero: Yes
17 Debit Amount (Debit Amount) Decimal BlankZero: Yes
18 Credit Amount (Credit Amount) Decimal BlankZero: Yes
20 Cost Center Code (Cost Center Code) Code20
21 Cost Object Code (Cost Object Code) Code20
27 Reason Code (Reason Code) Code10
28 G/L Account (G/L Account) Code20
29 G/L Entry No. (G/L Entry No.) Integer Editable: No
30 Source Code (Source Code) Code10
31 System-Created Entry (System-Created Entry) Boolean Editable: No
32 Allocated (Allocated) Boolean
33 Allocated with Journal No. (Allocated with Journal No.) Integer
40 User ID (User ID) Code50 Editable: No
41 Batch Name (Batch Name) Code10
50 Allocation Description (Allocation Description) Text80
51 Allocation ID (Allocation ID) Code10
68 Additional-Currency Amount (Additional-Currency Amount) Decimal
69 Add.-Currency Debit Amount (Add.-Currency Debit Amount) Decimal
70 Add.-Currency Credit Amount (Add.-Currency Credit Amount) Decimal

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Cost Type No.,Posting Date (Cost Type No.,Posting Date)
2 Cost Type No.,Cost Center Code,Cost Object Code,Allocated,Posting Date (Cost Type No.,Cost Center Code,Cost Object Code,Allocated,Posting Date)
3 Cost Center Code,Cost Type No.,Allocated,Posting Date (Cost Center Code,Cost Type No.,Allocated,Posting Date)
4 Cost Object Code,Cost Type No.,Allocated,Posting Date (Cost Object Code,Cost Type No.,Allocated,Posting Date)
5 Allocation ID,Posting Date (Allocation ID,Posting Date)
6 Document No.,Posting Date (Document No.,Posting Date)
7 Allocated with Journal No. (Allocated with Journal No.)
8 Cost Type No.,Posting Date,Cost Center Code,Cost Object Code (Cost Type No.,Posting Date,Cost Center Code,Cost Object Code)

Table Relations To Other Tables

Field Related Table Related Field
Allocation ID (Allocation ID) Cost Allocation Source ID (ID) 1..n
Cost Center Code (Cost Center Code) Cost Center Code (Code) 1..n
Cost Object Code (Cost Object Code) Cost Object Code (Code) 1..n
Cost Type No. (Cost Type No.) Cost Type No. (No.) 1..n
G/L Account (G/L Account) G/L Account No. (No.) 1..n
G/L Entry No. (G/L Entry No.) G/L Entry Entry No. (Entry No.) 1..n
Batch Name (Batch Name) Gen. Journal Batch Journal Template Name (Journal Template Name) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 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
Cost Register To Cost Entry No. (To Cost Entry No.) 1..n