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. Integer
4 Cost Type No. Code20
5 Posting Date Date [ClosingDates:Yes]
7 Document No. Code20
8 Description Text80
16 Amount Decimal BlankZero: Yes
17 Debit Amount Decimal BlankZero: Yes
18 Credit Amount Decimal BlankZero: Yes
20 Cost Center Code Code20
21 Cost Object Code Code20
27 Reason Code Code10
28 G/L Account Code20
29 G/L Entry No. Integer Editable: No
30 Source Code Code10
31 System-Created Entry Boolean Editable: No
32 Allocated Boolean
33 Allocated with Journal No. Integer
40 User ID Code50 Editable: No
41 Batch Name Code10
50 Allocation Description Text80
51 Allocation ID Code10
68 Additional-Currency Amount Decimal
69 Add.-Currency Debit Amount Decimal
70 Add.-Currency Credit Amount Decimal

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Allocation ID Cost Allocation Source ID 1..n
Cost Center Code Cost Center Code 1..n
Cost Object Code Cost Object Code 1..n
Cost Type No. Cost Type No. 1..n
G/L Account G/L Account No. 1..n
G/L Entry No. G/L Entry Entry No. 1..n
Batch Name Gen. Journal Batch Journal Template Name 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field
Cost Register To Cost Entry No. 1..n