Table 1101 "Cost Journal Line"

Base Application · Microsoft.CostAccounting.Journal · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 1108 “Cost Journal” (2 Learn pages).

Properties

Property	Value
Caption	Cost Journal Line
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	Journal Template Name	Code[10]	—	TableRelation Table 1100 “Cost Journal Template” (Cost Journal Template)
2	Line No.	Integer	—
4	Cost Type No.	Code[20]	Specifies the subtype of the cost center. This is an information field and is not used for any other purposes. Choose the field to select the cost subtype. via Page 1108 “Cost Journal”	TableRelation Table 1103 “Cost Type” (Cost Type)
5	Posting Date	Date	Specifies the entry’s posting date. via Page 1108 “Cost Journal”
7	Document No.	Code[20]	Specifies the number of the related document. via Page 1108 “Cost Journal”
8	Description	Text[100]	Specifies a description of the cost journal entry. via Page 1108 “Cost Journal”
9	Journal Batch Name	Code[10]	—	TableRelation Table 1102 “Cost Journal Batch” (“Cost Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)))
11	Bal. Cost Type No.	Code[20]	Specifies the number of the type that a balancing entry for the journal line is posted to. via Page 1108 “Cost Journal”	TableRelation Table 1103 “Cost Type” (Cost Type)
16	Amount Δ BC27	Decimal	Specifies the amount of the entry in the cost journal. via Page 1108 “Cost Journal”
17	Balance Δ BC27	Decimal	Specifies the balance of the cost type. via Page 1108 “Cost Journal”	not editable
18	Debit Amount Δ BC27	Decimal	Specifies the total of the ledger entries that represent debits. via Page 1108 “Cost Journal”
19	Credit Amount Δ BC27	Decimal	Specifies the total of the ledger entries that represent credits. via Page 1108 “Cost Journal”
20	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 1108 “Cost Journal”	TableRelation Table 1112 “Cost Center” (Cost Center)
21	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 1108 “Cost Journal”	TableRelation Table 1113 “Cost Object” (Cost Object)
22	Bal. Cost Center Code	Code[20]	Specifies the number of the cost center that a balancing entry for the journal line is posted to. via Page 1108 “Cost Journal”	TableRelation Table 1112 “Cost Center” (Cost Center)
23	Bal. Cost Object Code	Code[20]	Specifies the number of the cost center that a balancing entry for the journal line is posted to. via Page 1108 “Cost Journal”	TableRelation Table 1113 “Cost Object” (Cost Object)
27	Reason Code	Code[10]	—	TableRelation Table 231 “Reason Code” (Reason Code)
29	G/L Entry No.	Integer	Specifies the entry number of the corresponding general ledger entry that is associated with this cost entry. For combined entries, the entry number of the last general ledger entry is saved in the field. This is the entry with the highest entry number. via Page 1108 “Cost Journal”	TableRelation Table 17 “G/L Entry” (G/L Entry); not editable
30	Source Code	Code[10]	Specifies the source code that specifies where the entry was created. via Page 1108 “Cost Journal”	TableRelation Table 230 “Source Code” (Source Code)
31	System-Created Entry	Boolean	—	not editable
32	Cost Entry No.	Integer	—	not editable
33	Allocated	Boolean	—
50	Allocation Description	Text[80]	—
51	Allocation ID	Code[10]	—
68	Additional-Currency Amount Δ BC27	Decimal	—	not editable
69	Add.-Currency Debit Amount Δ BC27	Decimal	—	not editable
70	Add.-Currency Credit Amount Δ BC27	Decimal	—	not editable
100	Budget Name	Code[10]	—	not editable

Keys

Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
Key2: Cost Type No., Cost Center Code, Cost Object Code
Key3: G/L Entry No.

Events published

OnAfterSetUpNewLine(var CostJournalLine: Record "Cost Journal Line"; CostJournalTemplate: Record "Cost Journal Template"; CostJournalBatch: Record "Cost Journal Batch"; LastCostJournalLine: Record "Cost Journal Line") (integration)

Procedures

SetUpNewLine(LastCostJournalLine: Record "Cost Journal Line")
EmptyLine(): Boolean
IsOpenedFromBatch(): Boolean

Plus 5 local procedures.

Triggers

OnInsert, OnModify

Relations

Journal Template Name: TableRelation Table 1100 “Cost Journal Template”
Journal Batch Name: TableRelation Table 1102 “Cost Journal Batch”
Bal. Cost Type No.: TableRelation Table 1103 “Cost Type”
Cost Type No.: TableRelation Table 1103 “Cost Type”
Bal. Cost Center Code: TableRelation Table 1112 “Cost Center”
Cost Center Code: TableRelation Table 1112 “Cost Center”
Bal. Cost Object Code: TableRelation Table 1113 “Cost Object”
Cost Object Code: TableRelation Table 1113 “Cost Object”
G/L Entry No.: TableRelation Table 17 “G/L Entry”
Source Code: TableRelation Table 230 “Source Code”
Reason Code: TableRelation Table 231 “Reason Code”

Referenced by

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

Table 1102 “Cost Journal Batch”: No. of Lines

Pages and codeunits on this table

Page 1108 “Cost Journal” (source table)
Codeunit 1101 “CA Jnl.-Check Line” (codeunit runs on it)
Codeunit 1102 “CA Jnl.-Post Line” (codeunit runs on it)
Codeunit 1103 “CA Jnl.-Post Batch” (codeunit runs on it)
Codeunit 1108 “CA Jnl.-Post” (codeunit runs on it)
Codeunit 1113 “CA Jnl.-Post+Print” (codeunit runs on it)

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 Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.