tableAL Developmentofficial - Microsoftderived - from the source, no model text

Table 1103 "Cost Type"

Base Application · Microsoft.CostAccounting.Account

Across versions

  1. BC23present
  2. BC2410 fields changed
  3. BC25-26unchanged
  4. BC2712 fields changed, 1 procedures added
  5. BC28-30unchanged

Neighbourhood 32 connected objects and pages

Table 1104 "Cost Entry" (relates to, 8 links)Cost EntryTable 1109 "Cost Budget Entry" (relates to, 3 links)Table 1112 "Cost Center" (relates to, 2 links)Cost CenterTable 1113 "Cost Object" (relates to, 2 links)Cost ObjectTable 1110 "Cost Budget Name" (relates to)Cost Budget NameTable 15 "G/L Account" (relates to)G/L AccountPage 1100 "Chart of Cost Types" (pages and codeunits on it, 3 links)Chart of Cost TypesPage 1101 "Cost Type Card" (pages and codeunits on it)Cost Type CardPage 1110 "Cost Type Balance" (pages and codeunits on it)Cost Type BalancePage 1117 "Cost Budget per Period" (pages and codeunits on it)Cost Budget per PeriodPage 1118 "Cost Budget by Cost Center" (pages and codeunits on it)Cost Budget by Cost CenterPage 1119 "Cost Budget by Cost Object" (pages and codeunits on it)Page 1120 "Cost Type Balance/Budget" (pages and codeunits on it)Cost Type Balance/BudgetPage 1124 "Cost Type List" (pages and codeunits on it)Cost Type ListPage 1130 "Cost Type Balance Matrix" (pages and codeunits on it)Page 1131 "Cost Budget per Period Matrix" (pages and codeunits on it)Page 1132 "Cost Bdgt. per Center Matrix" (pages and codeunits on it)Page 1133 "Cost Bdgt. per Object Matrix" (pages and codeunits on it)Table 1101 "Cost Journal Line" (referenced by, 2 links)Cost Journal LineTable 1106 "Cost Allocation Source" (referenced by, 2 links)Cost Allocation SourceTable 1102 "Cost Journal Batch" (referenced by)Table 1104 "Cost Entry" (referenced by)Table 1107 "Cost Allocation Target" (referenced by)Table 1109 "Cost Budget Entry" (referenced by)Table 1112 "Cost Center" (referenced by)Table 1113 "Cost Object" (referenced by)Table 1114 "Cost Budget Buffer" (referenced by)Table 15 "G/L Account" (referenced by)About cost accounting (Learn pages)Creating cost budgets (Learn pages)Set up cost accounting (Learn pages)Transferring and posting cost entries (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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): Boolean
  • LookupCostTypeFilter(var Text: Text): Boolean

Plus 3 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Referenced by

13 fields in 11 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

Evidence 1 sources