Table 1107 "Cost Allocation Target"
Base Application · Microsoft.CostAccounting.Allocation
Across versions
- BC23present
- BC24declaration changed
- BC25-26unchanged
- BC276 fields changed
- BC28-30unchanged
Neighbourhood 9 connected objects and pages
Base Application · Microsoft.CostAccounting.Allocation · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1106 “Cost Allocation Target” (1 Learn page), Page 1109 “Cost Allocation Target Card” (1), Page 1114 “Cost Allocation Target List” (1).
Properties
| Property | Value |
|---|---|
| Caption | Cost Allocation Target |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | ID | Code[10] | Specifies the ID that applies to the cost allocation. via Page 1109 “Cost Allocation Target Card” | TableRelation Table 1106 “Cost Allocation Source” (Cost Allocation Source); not editable |
| 2 | Line No. | Integer | Specifies the number of this line. via Page 1109 “Cost Allocation Target Card” | not editable; NotBlank |
| 5 | Target Cost Type | Code[20] | Specifies the type of target cost. via Page 1109 “Cost Allocation Target Card” | TableRelation Table 1103 “Cost Type” (Cost Type) |
| 6 | Target Cost Center | Code[20] | Specifies the target cost center. via Page 1109 “Cost Allocation Target Card” | TableRelation Table 1112 “Cost Center” (Cost Center) |
| 7 | Target Cost Object | Code[20] | Specifies the target cost object. via Page 1109 “Cost Allocation Target Card” | TableRelation Table 1113 “Cost Object” (Cost Object) |
| 8 | Static Base Δ BC27 | Decimal | Specifies whether or not the base is static. via Page 1109 “Cost Allocation Target Card” | |
| 9 | Static Weighting Δ BC27 | Decimal | Specifies whether the values in the static base are weighted. via Page 1109 “Cost Allocation Target Card” | |
| 10 | Share Δ BC27 | Decimal | Specifies the values calculated from the Static Base and Static Weighting fields. via Page 1109 “Cost Allocation Target Card” | |
| 11 | Percent Δ BC27 | Decimal | Specifies the percentage rate calculated based on all other allocation targets. via Page 1109 “Cost Allocation Target Card” | not editable |
| 20 | Comment | Text[50] | Specifies a comment that applies to the cost allocation. via Page 1109 “Cost Allocation Target Card” | |
| 30 | Base | Enum “Cost Allocation Target Base” | Specifies whether or not the base is static. via Page 1109 “Cost Allocation Target Card” | enum Enum 1117 “Cost Allocation Target Base” |
| 31 | No. Filter | Text[250] | Specifies a filter for the numbers that are included. via Page 1109 “Cost Allocation Target Card” | |
| 32 | Cost Center Filter | Text[250] | Specifies the cost center code. The code serves as a default value for cost posting that is captured later in the cost journal. via Page 1109 “Cost Allocation Target Card” | TableRelation Table 1112 “Cost Center” (Cost Center) |
| 33 | Cost Object Filter | Text[250] | Specifies the cost object code. The code serves as a default value for cost posting that is captured later in the cost journal. via Page 1109 “Cost Allocation Target Card” | TableRelation Table 1113 “Cost Object” (Cost Object) |
| 34 | Date Filter Code | Enum “Cost Allocation Target Period” | Specifies a filter to filter the calculation of the dynamic allocation base by dates. You use the Date Filter Code field to define a dynamic date range without using a static date. If the allocation bases are updated, the date filter is automatically updated by using the work date. via Page 1109 “Cost Allocation Target Card” | enum Enum 1118 “Cost Allocation Target Period” |
| 35 | Group Filter | Text[250] | Specifies a filter so that the dynamic calculation of the Share field is based on the chosen group. Leave the field blank for static allocation. via Page 1109 “Cost Allocation Target Card” | |
| 38 | Allocation Target Type | Enum “Cost Allocation Target Type” | Specifies if the allocation comes from both budgeted and actual costs, only budgeted costs, or only actual costs. via Page 1109 “Cost Allocation Target Card” | enum Enum 1119 “Cost Allocation Target Type” |
| 40 | Percent per Share Δ BC27 | Decimal | Specifies the percentage if the chosen Allocation Target Type is Percent per Share. via Page 1109 “Cost Allocation Target Card” | |
| 41 | Amount per Share Δ BC27 | Decimal | Specifies the amount if the value in the Allocation Target Type field is Amount per Share. via Page 1109 “Cost Allocation Target Card” | |
| 50 | Share Updated on | Date | Specifies the date of when the Share field was last updated. via Page 1109 “Cost Allocation Target Card” | not editable |
| 60 | Last Date Modified | Date | Specifies when the allocation target card was last modified. via Page 1109 “Cost Allocation Target Card” | not editable |
| 61 | User ID | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. via Page 1109 “Cost Allocation Target Card” | TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation |
Keys
- Key1: ID, Line No. (clustered)
- Key2: Target Cost Type
- Key3: Target Cost Center
- Key4: Target Cost Object
- Key5: ID, Allocation Target Type
Events published
OnBeforeLookupGroupFilter(SourceBase: Integer; var SelectionFilter: Text; var IsHandled: Boolean)(integration)OnCalcPercentOnBeforeDistributeRoundingError(var CostAllocationTarget: Record "Cost Allocation Target"; PctTotal: Decimal; var IsHandled: Boolean)(integration)OnCalcPercentOnAfterSetFilters(var CostAllocationTarget: Record "Cost Allocation Target"; var Rec: Record "Cost Allocation Target")(integration)OnBeforeValidateTargetCostCenter(var CostAllocationTarget: Record "Cost Allocation Target"; var IsHandled: Boolean)(integration)
Procedures
7 local procedures, no public ones.
Triggers
OnInsert, OnModify
Relations
- drill-down page Page 1114 “Cost Allocation Target List”
- lookup page Page 1114 “Cost Allocation Target List”
- Target Cost Type: TableRelation Table 1103 “Cost Type”
- ID: TableRelation Table 1106 “Cost Allocation Source”
- Cost Center Filter: TableRelation Table 1112 “Cost Center”
- Target Cost Center: TableRelation Table 1112 “Cost Center”
- Cost Object Filter: TableRelation Table 1113 “Cost Object”
- Target Cost Object: TableRelation Table 1113 “Cost Object”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 1106 “Cost Allocation Source”: Total Share
Pages and codeunits on this table
- Page 1106 “Cost Allocation Target” (source table)
- Page 1109 “Cost Allocation Target Card” (source table)
- Page 1114 “Cost Allocation Target List” (source table)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Cost Allocation Target"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.