Diagrams


Table

Cost Journal Template

DynamicsDocs.comCost Journal Template«Table 1100»Cost Journal TemplateName [PK,NN]DescriptionReason CodeSource CodePosting Report IDPosting Report Caption«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 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 1105»Cost RegisterNo. [PK]Source; [Transfer from G/L,Cost Journa...TextFrom G/L Entry No.To G/L Entry No.From Cost Entry No.To Cost Entry No.No. of EntriesDebit AmountCredit AmountProcessed DatePosting DateClosedLevelUser IDJournal Batch Name«Table 1111»Cost Budget RegisterNo. [PK]Source; [Transfer from G/L Budget,Cost...DescriptionFrom Budget Entry No.To Budget Entry No.From Cost Budget Entry No.To Cost Budget Entry No.No. of EntriesAmountProcessed DatePosting DateClosedLevelUser IDJournal Batch NameCost Budget Name«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 230»Source CodeCode [PK,NN]Description<Reason Code><Source Code><Journal Template Name><Journal Template Name><Journal Batch Name><Journal Batch Name><Journal Batch Name><Reason Code><Source Code><Reason Code>

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

Fields

# Name Type
1 Name Code10 NotBlank: Yes
2 Description Text50
3 Reason Code Code10
6 Source Code Code10
7 Posting Report ID Integer
8 Posting Report Caption Text250 Editable: No
FlowField

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Posting Report ID AllObjWithCaption Object ID 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
Cost Budget Register Journal Batch Name 1..n
Cost Journal Batch Journal Template Name 1..n
Cost Journal Line Journal Template Name 1..n
Cost Register Journal Batch Name 1..n