Table 1103 "Cost Type"
Base Application · Microsoft.CostAccounting.Account
Across versions
- BC23present
- BC2410 fields changed
- BC25-26unchanged
- BC2712 fields changed, 1 procedures added
- BC28-30unchanged
Neighbourhood 32 connected objects and pages
Base Application · Microsoft.CostAccounting.Account · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1100 “Chart of Cost Types” (2 Learn pages), Page 1101 “Cost Type Card” (1), Page 1117 “Cost Budget per Period” (1), Page 1118 “Cost Budget by Cost Center” (1), Page 1119 “Cost Budget by Cost Object” (1), Page 1120 “Cost Type Balance/Budget” (1), Page 1124 “Cost Type List” (1), Page 1131 “Cost Budget per Period Matrix” (1), Page 1132 “Cost Bdgt. per Center Matrix” (1), Page 1133 “Cost Bdgt. per Object Matrix” (1).
Properties
| Property | Value |
|---|---|
| Caption | Cost Type |
| 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 | No. | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. via Page 1101 “Cost Type Card” | NotBlank |
| 2 | Name | Text[100] | Specifies the name of the cost type. via Page 1101 “Cost Type Card” | |
| 3 | Search Name | Code[100] | Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field. via Page 1101 “Cost Type Card” | |
| 4 | Type | Enum “Cost Account Type” | Specifies the type of the cost type. via Page 1101 “Cost Type Card” | enum Enum 1103 “Cost Account Type” |
| 6 | Cost Center Code | Code[20] | 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 1101 “Cost Type Card” | TableRelation Table 1112 “Cost Center” (Cost Center) |
| 7 | Cost Object Code | Code[20] | 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 1101 “Cost Type Card” | TableRelation Table 1113 “Cost Object” (Cost Object) |
| 10 | Combine Entries | Option | Specifies the option to allow for general ledger entries to be posted individually or as a combined posting per day or month. via Page 1101 “Cost Type Card” | OptionCaption: None,Day,Month |
| 13 | Blocked | Boolean | Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine. via Page 1101 “Cost Type Card” | |
| 17 | New Page | Boolean | Specifies if you want a new page to start immediately after this cost center when you print the chart of cash flow accounts. via Page 1101 “Cost Type Card” | |
| 18 | Blank Line | Boolean | Specifies whether you want a blank line to appear immediately after this cost center when you print the chart of cost centers. The New Page, Blank Line, and Indentation fields define the layout of the chart of cost centers. via Page 1101 “Cost Type Card” | |
| 19 | Indentation | Integer | — | |
| 20 | Comment | Text[50] | Specifies a description that applies to the cost type. via Page 1101 “Cost Type Card” | |
| 22 | Cost Classification | Option | Specifies the cost type by variability. via Page 1101 “Cost Type Card” | OptionCaption: ,Fixed,Variable,Step Variable |
| 23 | Fixed Share | Text[30] | Specifies an explanation of the Cost Classification field. via Page 1101 “Cost Type Card” | |
| 26 | Modified Date | Date | Specifies when the cost object was last modified. via Page 1101 “Cost Type Card” | not editable |
| 27 | Modified By | Code[50] | Specifies the user who last modified the cost object. via Page 1101 “Cost Type Card” | TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation |
| 28 | Date Filter | Date | — | FlowFilter |
| 29 | Cost Center Filter | Code[20] | — | TableRelation Table 1112 “Cost Center” (Cost Center); FlowFilter |
| 30 | Cost Object Filter | Code[20] | — | TableRelation Table 1113 “Cost Object” (Cost Object); FlowFilter |
| 31 | Balance at Date Δ BC24 Δ BC27 | Decimal | Specifies the cost type balance on the last date that is included in the Date Filter field. The contents of the field are calculated by using the entries in the Amount field in the Cost Entry table. via Page 1100 “Chart of Cost Types” | FlowField: sum(“Cost Entry”.Amount where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), “Posting Date” = field(upperlimit(“Date Filter”)))); not editable |
| 32 | Net Change Δ BC24 Δ BC27 | Decimal | Specifies the net change in the account balance during the time period in the Date Filter field. via Page 1100 “Chart of Cost Types” | FlowField: sum(“Cost Entry”.Amount where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), “Posting Date” = field(“Date Filter”))); not editable |
| 33 | Budget Amount Δ BC24 Δ BC27 | Decimal | Specifies either the cost type’s total budget or, if you have specified a filter in the Budget Filter field, a filtered budget. The contents of the field are calculated by using the entries in the Amount field in the Cost Budget Entry table. via Page 1100 “Chart of Cost Types” | FlowField: sum(“Cost Budget Entry”.Amount where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), Date = field(“Date Filter”), “Budget Name” = field(“Budget Filter”))) |
| 34 | Totaling | Text[250] | Specifies an account interval or a list of account numbers. The entries of the account will be totaled to give a total balance. How entries are totaled depends on the value in the Account Type field. via Page 1101 “Cost Type Card” | TableRelation Table 1103 “Cost Type” (Cost Type) |
| 35 | Budget Filter | Code[10] | — | TableRelation Table 1110 “Cost Budget Name” (Cost Budget Name); FlowFilter |
| 36 | Balance Δ BC24 Δ BC27 | Decimal | Specifies the balance of the cost type. via Page 1101 “Cost Type Card” | FlowField: sum(“Cost Entry”.Amount where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”))); not editable |
| 37 | Budget at Date Δ BC27 | Decimal | — | not editable |
| 40 | G/L Account Range | Text[50] | Specifies a general ledger account range to establish which general ledger account a cost type belongs to. via Page 1101 “Cost Type Card” | TableRelation Table 15 “G/L Account” (G/L Account) |
| 47 | Debit Amount Δ BC24 Δ BC27 | Decimal | Specifies the total of the ledger entries that represent debits. via Page 1120 “Cost Type Balance/Budget” | FlowField: sum(“Cost Entry”.“Debit Amount” where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), “Posting Date” = field(“Date Filter”))) |
| 48 | Credit Amount Δ BC24 Δ BC27 | Decimal | Specifies the total of the ledger entries that represent credits. via Page 1120 “Cost Type Balance/Budget” | FlowField: sum(“Cost Entry”.“Credit Amount” where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), “Posting Date” = field(“Date Filter”))) |
| 51 | Balance to Allocate Δ BC27 | Decimal | Specifies the net amount that can still be allocated. The entry in the Allocated field in the Cost Entry table determines whether a cost entry is a part of this field. via Page 1101 “Cost Type Card” | FlowField: sum(“Cost Entry”.Amount where(“Cost Type No.” = field(“No.”), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), Allocated = const(false), “Posting Date” = field(“Date Filter”))); not editable |
| 60 | Budget Debit Amount Δ BC24 Δ BC27 | Decimal | — | FlowField: sum(“Cost Budget Entry”.Amount where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), Date = field(“Date Filter”), “Budget Name” = field(“Budget Filter”))) |
| 72 | Budget Credit Amount Δ BC24 Δ BC27 | Decimal | — | FlowField: - sum(“Cost Budget Entry”.Amount where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), Date = field(“Date Filter”), “Budget Name” = field(“Budget Filter”))) |
| 73 | Add. Currency Net Change Δ BC24 Δ BC27 | Decimal | — | FlowField: sum(“Cost Entry”.“Additional-Currency Amount” where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), “Posting Date” = field(“Date Filter”))); not editable |
| 74 | Add. Currency Balance at Date Δ BC24 Δ BC27 | Decimal | — | FlowField: sum(“Cost Entry”.“Additional-Currency Amount” where(“Cost Type No.” = field(“No.”), “Cost Type No.” = field(filter(Totaling)), “Cost Center Code” = field(“Cost Center Filter”), “Cost Object Code” = field(“Cost Object Filter”), “Posting Date” = field(upperlimit(“Date Filter”)))) |
Keys
- Key1: No. (clustered)
- Key2: Type
Events published
OnBeforeCheckBalance(var CostType: Record "Cost Type"; var IsHandled: Boolean)(integration)
Procedures
LookupGLAccFilter(var Text: Text): BooleanLookupCostTypeFilter(var Text: Text): Boolean
Plus 3 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- drill-down page Page 1100 “Chart of Cost Types”
- lookup page Page 1100 “Chart of Cost Types”
- Totaling: TableRelation Table 1103 “Cost Type”
- Add. Currency Balance at Date: CalcFormula Table 1104 “Cost Entry”
- Add. Currency Net Change: CalcFormula Table 1104 “Cost Entry”
- Balance: CalcFormula Table 1104 “Cost Entry”
- Balance at Date: CalcFormula Table 1104 “Cost Entry”
- Balance to Allocate: CalcFormula Table 1104 “Cost Entry”
- Credit Amount: CalcFormula Table 1104 “Cost Entry”
- Debit Amount: CalcFormula Table 1104 “Cost Entry”
- Net Change: CalcFormula Table 1104 “Cost Entry”
- Budget Amount: CalcFormula Table 1109 “Cost Budget Entry”
- Budget Credit Amount: CalcFormula Table 1109 “Cost Budget Entry”
- Budget Debit Amount: CalcFormula Table 1109 “Cost Budget Entry”
- Budget Filter: TableRelation Table 1110 “Cost Budget Name”
- Cost Center Code: TableRelation Table 1112 “Cost Center”
- Cost Center Filter: TableRelation Table 1112 “Cost Center”
- Cost Object Code: TableRelation Table 1113 “Cost Object”
- Cost Object Filter: TableRelation Table 1113 “Cost Object”
- G/L Account Range: TableRelation Table 15 “G/L Account”
Referenced by
13 fields in 11 objects relate to this table (TableRelation or CalcFormula).
- Table 1101 “Cost Journal Line”: Bal. Cost Type No., Cost Type No.
- Table 1106 “Cost Allocation Source”: Cost Type Range, Credit to Cost Type
- Table 1102 “Cost Journal Batch”: Bal. Cost Type No.
- Table 1103 “Cost Type”: Totaling
- Table 1104 “Cost Entry”: Cost Type No.
- Table 1107 “Cost Allocation Target”: Target Cost Type
- Table 1109 “Cost Budget Entry”: Cost Type No.
- Table 1112 “Cost Center”: Cost Type Filter
- Table 1113 “Cost Object”: Cost Type Filter
- Table 1114 “Cost Budget Buffer”: Cost Type No.
- Table 15 “G/L Account”: Cost Type No.
Pages and codeunits on this table
- Page 1100 “Chart of Cost Types” (source table)
- Page 1101 “Cost Type Card” (source table)
- Page 1110 “Cost Type Balance” (source table)
- Page 1117 “Cost Budget per Period” (source table)
- Page 1118 “Cost Budget by Cost Center” (source table)
- Page 1119 “Cost Budget by Cost Object” (source table)
- Page 1120 “Cost Type Balance/Budget” (source table)
- Page 1124 “Cost Type List” (source table)
- Page 1130 “Cost Type Balance Matrix” (source table)
- Page 1131 “Cost Budget per Period Matrix” (source table)
- Page 1132 “Cost Bdgt. per Center Matrix” (source table)
- Page 1133 “Cost Bdgt. per Object Matrix” (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 Type"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.