Diagrams


Table

Cost Allocation Target

DynamicsDocs.comCost Allocation Target«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 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 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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email<ID><Target Cost Type><Target Cost Center><Target Cost Object><User ID><Cost Center Code><Cost Object Code><Credit to Cost Type><User ID><Cost Center Code><Cost Center Filter><Cost Type Filter><Cost Object Code><Cost Object Filter><Cost Type 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 Editable: No
2 Line No. Integer NotBlank: Yes
Editable: No
5 Target Cost Type Code20
6 Target Cost Center Code20
7 Target Cost Object Code20
8 Static Base Decimal (0:2) BlankZero: Yes
9 Static Weighting Decimal (0:5) BlankZero: Yes
10 Share Decimal (2:5)
11 Percent Decimal (2:5) Editable: No
20 Comment Text50
30 Base Option
31 No. Filter Text250
32 Cost Center Filter Text250
33 Cost Object Filter Text250
34 Date Filter Code Option
35 Group Filter Text250
38 Allocation Target Type Option
40 Percent per Share Decimal BlankZero: Yes
41 Amount per Share Decimal BlankZero: Yes
50 Share Updated on Date Editable: No
60 Last Date Modified Date Editable: No
61 User ID Code50 Editable: No

Keys

# Fields
0 ID,Line No. Clustered: Yes
1 Target Cost Type
2 Target Cost Center
3 Target Cost Object
4 ID,Allocation Target Type

Table Relations To Other Tables

Field Related Table Related Field
ID Cost Allocation Source ID 1..n
Target Cost Center Cost Center Code 1..n
Target Cost Object Cost Object Code 1..n
Target Cost Type Cost Type No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field