Diagrams


Table

Cost Register

DynamicsDocs.comCost Register«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 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 1104»Cost EntryEntry No. [PK]Cost Type No.Posting DateDocument No.DescriptionAmountDebit AmountCredit AmountCost Center CodeCost Object CodeReason CodeG/L AccountG/L Entry No.Source CodeSystem-Created EntryAllocatedAllocated with Journal No.User IDBatch NameAllocation DescriptionAllocation IDAdditional-Currency AmountAdd.-Currency Debit AmountAdd.-Currency Credit Amount«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 1100»Cost Journal TemplateName [PK,NN]DescriptionReason CodeSource CodePosting Report IDPosting Report Caption<From G/L Entry No.><To G/L Entry No.><From Cost Entry No.><To Cost Entry No.><User ID><Journal Batch Name><Reversed by Entry No.><Reversed Entry No.><G/L Entry No.><User ID>

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

Fields

# Name Type
1 No. Integer Editable: No
2 Source Option Editable: No
3 Text Text30 Editable: No
4 From G/L Entry No. Integer BlankZero: Yes
Editable: No
5 To G/L Entry No. Integer BlankZero: Yes
Editable: No
6 From Cost Entry No. Integer BlankZero: Yes
Editable: No
7 To Cost Entry No. Integer BlankZero: Yes
Editable: No
8 No. of Entries Integer Editable: No
15 Debit Amount Decimal BlankZero: Yes
Editable: No
16 Credit Amount Decimal BlankZero: Yes
Editable: No
20 Processed Date Date Editable: No
21 Posting Date Date Editable: No
23 Closed Boolean
25 Level Integer BlankZero: Yes
Editable: No
31 User ID Code50 Editable: No
32 Journal Batch Name Code10 Editable: No

Keys

# Fields
0 No. Clustered: Yes
1 Source
2 Closed

Table Relations To Other Tables

Field Related Table Related Field
To Cost Entry No. Cost Entry Entry No. 1..n
Journal Batch Name Cost Journal Template Name 1..n
To G/L Entry No. G/L Entry Entry No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field