Diagrams


Table

Cost Object

DynamicsDocs.comCost Object«Table 1113»Cost ObjectCode [PK,NN]NameCost Type FilterDate FilterNet ChangeBalance at DateSorting OrderCommentLine Type; [Cost Object,Heading,Total,...BlockedNew PageBlank LineIndentationTotaling«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 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 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 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...«Table 1107»Cost Allocation TargetID [PK]Line No. [PK,NN]Target Cost TypeTarget Cost CenterTarget Cost ObjectStatic BaseStatic WeightingSharePercentCommentBase; [Static,G/L Entries,G/L Budget E...No. FilterCost Center FilterCost Object FilterDate Filter Code; [,Week,Last Week,Mon...Group FilterAllocation Target Type; [All Costs,Per...Percent per ShareAmount per ShareShare Updated onLast Date ModifiedUser ID«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 1114»Cost Budget BufferCost Type No. [PK]Budget NameDate [PK]Cost Center Code [PK]Cost Object Code [PK]Amount«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«Table 85»Acc. Schedule LineSchedule Name [PK]Line No. [PK]Row No.DescriptionTotalingTotaling Type; [Posting Accounts,Total...New PageIndentationDate FilterDimension 1 FilterDimension 2 FilterG/L Budget FilterBusiness Unit FilterShow; [Yes,No,If Any Column Not Zero,W...Dimension 3 FilterDimension 4 FilterDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingDimension 4 TotalingBoldItalicUnderlineShow Opposite SignRow Type; [Net Change,Balance at Date,...Amount Type; [Net Amount,Debit Amount,...Double UnderlineCash Flow Forecast FilterCost Center FilterCost Object FilterCost Center Totaling...<Cost Type Filter><Cost Object Code><Cost Object Filter><Cost Object Code><Bal. Cost Object Code><Bal. Cost Object Code><Cost Object Code><Cost Object Code><Target Cost Object><Cost Object Code><Cost Object Code><Cost Object Code><Cost Object Filter><Cost Type No.><Bal. Cost Type No.><Journal Batch Name><Bal. Cost Type No.><Cost Type No.><Credit to Cost Type><Target Cost Type><Cost Type No.><Cost Type No.><Allocation ID><ID><Allocation ID><Manager No.><Employee No. Filter>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Name Text50
3 Cost Type Filter Code20 FlowFilter
4 Date Filter Date FlowFilter
5 Net Change Decimal BlankZero: Yes
Editable: No
FlowField
6 Balance at Date Decimal BlankZero: Yes
Editable: No
FlowField
7 Sorting Order Code10
8 Comment Text50
9 Line Type Option
10 Blocked Boolean
11 New Page Boolean
12 Blank Line Boolean
13 Indentation Integer Editable: No
14 Totaling Text250

Keys

# Fields
0 Code Clustered: Yes
1 Sorting Order

Table Relations To Other Tables

Field Related Table Related Field
Cost Type Filter Cost Type No. 1..n

Table Relations From Other Tables

From Table From Field
Acc. Schedule Line Cost Object Filter 1..n
Cost Allocation Source Cost Object Code 1..n
Cost Allocation Target Target Cost Object 1..n
Cost Budget Buffer Cost Object Code 1..n
Cost Budget Entry Cost Object Code 1..n
Cost Entry Cost Object Code 1..n
Cost Journal Batch Bal. Cost Object Code 1..n
Cost Journal Line Bal. Cost Object Code 1..n
Cost Type Cost Object Filter 1..n
Employee Cost Object Code 1..n