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 EmailExchange IdentifierApplication ID<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


# Name Type
1 ID (ID) Code10 Editable: No
2 Line No. (Line No.) Integer NotBlank: Yes
Editable: No
5 Target Cost Type (Target Cost Type) Code20
6 Target Cost Center (Target Cost Center) Code20
7 Target Cost Object (Target Cost Object) Code20
8 Static Base (Static Base) Decimal (0:2) BlankZero: Yes
9 Static Weighting (Static Weighting) Decimal (0:5) BlankZero: Yes
10 Share (Share) Decimal (2:5)
11 Percent (Percent) Decimal (2:5) Editable: No
20 Comment (Comment) Text50
30 Base (Base) Option
31 No. Filter (No. Filter) Text250
32 Cost Center Filter (Cost Center Filter) Text250
33 Cost Object Filter (Cost Object Filter) Text250
34 Date Filter Code (Date Filter Code) Option
35 Group Filter (Group Filter) Text250
38 Allocation Target Type (Allocation Target Type) Option
40 Percent per Share (Percent per Share) Decimal BlankZero: Yes
41 Amount per Share (Amount per Share) Decimal BlankZero: Yes
50 Share Updated on (Share Updated on) Date Editable: No
60 Last Date Modified (Last Date Modified) Date Editable: No
61 User ID (User ID) Code50 Editable: No


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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field