Diagrams


Table

Cost Center

DynamicsDocs.comCost Center«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 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 PageDate 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 TotalingCost Object Totaling...<Cost Type Filter><Cost Center Code><Cost Center Filter><Cost Center Code><Bal. Cost Center Code><Bal. Cost Center Code><Cost Center Code><Cost Center Code><Target Cost Center><Cost Center Code><Cost Center Code><Cost Center Code><Cost Center 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 Subtype Option
4 Cost Type Filter Code20 FlowFilter
5 Date Filter Date FlowFilter
6 Net Change Decimal BlankZero: Yes
Editable: No
FlowField
7 Balance at Date Decimal BlankZero: Yes
Editable: No
FlowField
8 Balance to Allocate Decimal BlankZero: Yes
Editable: No
FlowField
9 Responsible Person Code50
10 Sorting Order Code10
11 Comment Text50
12 Line Type Option
13 Blocked Boolean
14 New Page Boolean
15 Blank Line Boolean
16 Indentation Integer Editable: No
17 Totaling Text250

Keys

# Fields
0 Code Clustered: Yes
1 Cost Subtype
2 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 Center Filter 1..n
Cost Allocation Source Cost Center Code 1..n
Cost Allocation Target Target Cost Center 1..n
Cost Budget Buffer Cost Center Code 1..n
Cost Budget Entry Cost Center Code 1..n
Cost Entry Cost Center Code 1..n
Cost Journal Batch Bal. Cost Center Code 1..n
Cost Journal Line Bal. Cost Center Code 1..n
Cost Type Cost Center Filter 1..n
Employee Cost Center Code 1..n