Diagrams


Table

Cost Journal Line

DynamicsDocs.comCost Journal Line«Table 1101»Cost Journal LineJournal Template Name [PK]Line No. [PK]Cost Type No.Posting DateDocument No.DescriptionJournal Batch Name [PK]Bal. Cost Type No.AmountBalanceDebit AmountCredit AmountCost Center CodeCost Object CodeBal. Cost Center CodeBal. Cost Object CodeReason CodeG/L Entry No.Source CodeSystem-Created EntryCost Entry No.AllocatedAllocation DescriptionAllocation IDAdditional-Currency AmountAdd.-Currency Debit AmountAdd.-Currency Credit AmountBudget Name«Table 1100»Cost Journal TemplateName [PK,NN]DescriptionReason CodeSource CodePosting Report IDPosting Report Caption«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 1102»Cost Journal BatchJournal Template Name [PK]Name [PK,NN]DescriptionReason CodeBal. Cost Type No.Bal. Cost Center CodeBal. Cost Object CodeDelete after Posting«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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«Table 230»Source CodeCode [PK,NN]Description<Journal Template Name><Cost Type No.><Bal. Cost Type No.><Journal Batch Name><Cost Center Code><Bal. Cost Center Code><Cost Object Code><Bal. Cost Object Code><Reason Code><G/L Entry No.><Source Code><Reason Code><Source Code><Journal Template Name><Cost Center Code><Cost Center Filter><Cost Type Filter><Cost Object Code><Cost Object Filter><Cost Type Filter><Bal. Cost Type No.><Reason Code><Bal. Cost Center Code><Bal. Cost Object Code><Reason Code><Source Code><Reversed by Entry No.><Reversed Entry No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Journal Template Name Code10
2 Line No. Integer
4 Cost Type No. Code20
5 Posting Date Date [ClosingDates:Yes]
7 Document No. Code20
8 Description Text80
9 Journal Batch Name Code10
11 Bal. Cost Type No. Code20
16 Amount Decimal
17 Balance Decimal Editable: No
18 Debit Amount Decimal
19 Credit Amount Decimal
20 Cost Center Code Code20
21 Cost Object Code Code20
22 Bal. Cost Center Code Code20
23 Bal. Cost Object Code Code20
27 Reason Code Code10
29 G/L Entry No. Integer Editable: No
30 Source Code Code10
31 System-Created Entry Boolean Editable: No
32 Cost Entry No. Integer Editable: No
33 Allocated Boolean
50 Allocation Description Text80
51 Allocation ID Code10
68 Additional-Currency Amount Decimal Editable: No
69 Add.-Currency Debit Amount Decimal Editable: No
70 Add.-Currency Credit Amount Decimal Editable: No
100 Budget Name Code10 Editable: No

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Line No. Clustered: Yes
1 Cost Type No.,Cost Center Code,Cost Object Code
2 G/L Entry No.

Table Relations To Other Tables

Field Related Table Related Field
Bal. Cost Center Code Cost Center Code 1..n
Journal Batch Name Cost Journal Batch Name 1..n
Journal Template Name Cost Journal Template Name 1..n
Bal. Cost Object Code Cost Object Code 1..n
Bal. Cost Type No. Cost Type No. 1..n
G/L Entry No. G/L Entry Entry No. 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n

Table Relations From Other Tables

From Table From Field