Diagrams


Table

Cost Type

DynamicsDocs.comCost Type«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 1101»Cost Journal LineJournal Template Name [PK]Line No. [PK]Cost Type No.Posting DateDocument No.DescriptionJournal Batch Name [PK]Bal. Cost Type No.AmountBalanceDebit AmountCredit AmountCost Center CodeCost Object CodeBal. Cost Center CodeBal. Cost Object CodeReason CodeG/L Entry No.Source CodeSystem-Created EntryCost Entry No.AllocatedAllocation DescriptionAllocation IDAdditional-Currency AmountAdd.-Currency Debit AmountAdd.-Currency Credit AmountBudget Name«Table 1102»Cost Journal BatchJournal Template Name [PK]Name [PK,NN]DescriptionReason CodeBal. Cost Type No.Bal. Cost Center CodeBal. Cost Object CodeDelete after Posting«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 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 1109»Cost Budget EntryEntry No. [PK]Budget NameCost Type No.DateCost Center CodeCost Object CodeAmountDescriptionDocument No.Source CodeSystem-Created EntryAllocatedAllocated with Journal No.Last Modified By UserLast Date ModifiedAllocation DescriptionAllocation ID«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 1114»Cost Budget BufferCost Type No. [PK]Budget NameDate [PK]Cost Center Code [PK]Cost Object Code [PK]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 1110»Cost Budget NameName [PK,NN]Description<Cost Center Code><Cost Center Filter><Cost Type Filter><Cost Object Code><Cost Object Filter><Cost Type Filter><Modified By><Budget Filter><Cost Type No.><Bal. Cost Type No.><Bal. Cost Type No.><Cost Type No.><Credit to Cost Type><Target Cost Type><Cost Type No.><Cost Type No.><Journal Batch Name><Cost Center Code><Bal. Cost Center Code><Cost Object Code><Bal. Cost Object Code><Bal. Cost Center Code><Bal. Cost Object Code><Cost Center Code><Cost Object Code><User ID><Allocation ID><Cost Center Code><Cost Object Code><User ID><ID><Allocation ID><Target Cost Center><Target Cost Object><User ID><Budget Name><Cost Center Code><Cost Object Code><Last Modified By User><Cost Center Code><Cost Object Code><Budget Name>

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

Fields

# Name Type
1 No. Code20 NotBlank: Yes
2 Name Text50
3 Search Name Code50
4 Type Option
6 Cost Center Code Code20
7 Cost Object Code Code20
10 Combine Entries Option
13 Blocked Boolean
17 New Page Boolean
18 Blank Line Boolean BlankZero: Yes
19 Indentation Integer
20 Comment Text50
22 Cost Classification Option
23 Fixed Share Text30
26 Modified Date Date Editable: No
27 Modified By Code50 Editable: No
28 Date Filter Date FlowFilter
29 Cost Center Filter Code20 FlowFilter
30 Cost Object Filter Code20 FlowFilter
31 Balance at Date Decimal BlankZero: Yes
Editable: No
FlowField
32 Net Change Decimal BlankZero: Yes
Editable: No
FlowField
33 Budget Amount Decimal BlankZero: Yes
FlowField
34 Totaling Text250
35 Budget Filter Code10 FlowFilter
36 Balance Decimal BlankZero: Yes
Editable: No
FlowField
37 Budget at Date Decimal Editable: No
40 G/L Account Range Text50
47 Debit Amount Decimal FlowField
48 Credit Amount Decimal FlowField
51 Balance to Allocate Decimal BlankZero: Yes
Editable: No
FlowField
60 Budget Debit Amount Decimal BlankNumbers: BlankNegAndZero
FlowField
72 Budget Credit Amount Decimal BlankNumbers: BlankNegAndZero
FlowField
73 Add. Currency Net Change Decimal BlankZero: Yes
Editable: No
FlowField
74 Add. Currency Balance at Date Decimal FlowField

Keys

# Fields
0 No. Clustered: Yes
1 Type

Table Relations To Other Tables

Field Related Table Related Field
Budget Filter Cost Budget Name Name 1..n
Cost Center Filter Cost Center Code 1..n
Cost Object Filter Cost Object Code 1..n
Modified By User User Name 1..n

Table Relations From Other Tables

From Table From Field
Cost Allocation Source Credit to Cost Type 1..n
Cost Allocation Target Target Cost Type 1..n
Cost Budget Buffer Cost Type No. 1..n
Cost Budget Entry Cost Type No. 1..n
Cost Center Cost Type Filter 1..n
Cost Entry Cost Type No. 1..n
Cost Journal Batch Bal. Cost Type No. 1..n
Cost Journal Line Bal. Cost Type No. 1..n
Cost Object Cost Type Filter 1..n