Diagrams


Table

Cost Allocation Source

DynamicsDocs.comCost Allocation Source«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 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 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 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 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<Cost Center Code><Cost Object Code><Credit to Cost Type><User ID><Allocation ID><ID><Allocation ID><Cost Type No.><Cost Center Code><Cost Object Code><User ID><Target Cost Type><Target Cost Center><Target Cost Object><User ID><Cost Type No.><Cost Center Code><Cost Object Code><Last Modified By User><Cost Type Filter><Cost Center Code><Cost Center Filter><Cost Type Filter><Cost Object Code><Cost Object Filter><Modified By>

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

Fields

# Name Type
1 ID Code10
2 Level Integer
3 Valid From Date
4 Valid To Date
5 Cost Type Range Code30
6 Cost Center Code Code20
7 Cost Object Code Code20
8 Variant Code10
10 Credit to Cost Type Code20
20 Comment Text50
22 Total Share Decimal Editable: No
FlowField
30 Blocked Boolean
60 Last Date Modified Date Editable: No
61 User ID Code50 Editable: No
100 Allocation Source Type Option

Keys

# Fields
0 ID Clustered: Yes
1 Level,Valid From,Valid To,Cost Type Range

Table Relations To Other Tables

Field Related Table Related Field
Cost Center Code Cost Center Code 1..n
Cost Object Code Cost Object Code 1..n
Credit to Cost Type Cost Type No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field
Cost Allocation Target ID 1..n
Cost Budget Entry Allocation ID 1..n
Cost Entry Allocation ID 1..n