Diagrams


Table

Cost Journal Batch

DynamicsDocs.comCost Journal Batch«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 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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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 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<Journal Template Name><Reason Code><Bal. Cost Type No.><Bal. Cost Center Code><Bal. Cost Object Code><Journal Batch Name><Journal Template Name><Cost Type No.><Bal. Cost Type No.><Cost Center Code><Bal. Cost Center Code><Cost Object Code><Bal. Cost Object Code><Reason Code><Reason Code><Cost Center Code><Cost Center Filter><Cost Type Filter><Cost Object Code><Cost Object Filter><Cost Type Filter>

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 NotBlank: No
2 Name Code10 NotBlank: Yes
3 Description Text50
4 Reason Code Code10
9 Bal. Cost Type No. Code20
10 Bal. Cost Center Code Code20
11 Bal. Cost Object Code Code20
12 Delete after Posting Boolean

Keys

# Fields
0 Journal Template Name,Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bal. Cost Center Code Cost Center Code 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
Reason Code Reason Code Code 1..n

Table Relations From Other Tables

From Table From Field
Cost Journal Line Journal Batch Name 1..n