Diagrams


Table

Cost Budget Entry

DynamicsDocs.comCost Budget Entry«Table 1109»Cost Budget EntryEntry No. [PK]Budget NameCost Type No.DateCost Center CodeCost Object CodeAmountDescriptionDocument No.Source CodeSystem-Created EntryAllocatedAllocated with Journal No.Last Modified By UserLast Date ModifiedAllocation DescriptionAllocation ID«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 1110»Cost Budget NameName [PK,NN]Description«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«Table 230»Source CodeCode [PK,NN]Description«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 1106»Cost Allocation SourceID [PK]LevelValid FromValid ToCost Type RangeCost Center CodeCost Object CodeVariantCredit to Cost TypeCommentTotal ShareBlockedLast Date ModifiedUser IDAllocation Source Type; [Both,Actual,B...<Budget Name><Cost Type No.><Cost Center Code><Cost Object Code><Source Code><Last Modified By User><Allocation ID><From Cost Budget Entry No.><To Cost Budget Entry No.><User ID><Cost Budget Name><Budget Filter><Cost Center Code><Cost Center Filter><Cost Type Filter><Cost Object Code><Cost Object Filter><Cost Type Filter><Modified By><Credit to Cost Type><Cost Center Code><Cost Object Code><User ID>

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

Fields

# Name Type
1 Entry No. Integer Editable: No
2 Budget Name Code10
3 Cost Type No. Code20
4 Date Date [ClosingDates:Yes]
5 Cost Center Code Code20
6 Cost Object Code Code20
7 Amount Decimal
9 Description Text80
20 Document No. Code20
30 Source Code Code10
31 System-Created Entry Boolean Editable: No
32 Allocated Boolean
33 Allocated with Journal No. Integer
40 Last Modified By User Code50 Editable: No
42 Last Date Modified Date Editable: No
50 Allocation Description Text80
51 Allocation ID Code10

Keys

# Fields
0 Entry No. Clustered: Yes
1 Budget Name,Cost Type No.,Date
2 Budget Name,Cost Type No.,Cost Center Code,Cost Object Code,Date
3 Budget Name,Cost Center Code,Cost Type No.,Allocated,Date
4 Budget Name,Cost Object Code,Cost Type No.,Allocated,Date
5 Budget Name,Allocation ID,Date

Table Relations To Other Tables

Field Related Table Related Field
Allocation ID Cost Allocation Source ID 1..n
Budget Name Cost Budget Name Name 1..n
Cost Center Code Cost Center Code 1..n
Cost Object Code Cost Object Code 1..n
Cost Type No. Cost Type No. 1..n
Source Code Source Code Code 1..n
Last Modified By User User User Name 1..n

Table Relations From Other Tables

From Table From Field
Cost Budget Register To Cost Budget Entry No. 1..n