XM_FLAT_COST_CENTER

Entity Name XM_FLAT_COST_CENTER
Entity Type Independent
Definition Includes information on cost centers. Each user belongs to a cost_center. And expenses can be charged across cost centers.
Attribute Datatype Width Definition
COST_CENTER_ID Integer 11 PK
USER_ID Integer 1
REVIEW_SEGMENT_NAME Varchar 39 Review segment name
REVIEW_SEGMENT_CODE Varchar 7 Review segment code
REVIEW_SEGMENT_DISPLAY_STRING Varchar 39 Review segment display name
REVIEW_SEGMENT_DESCRIPTION Varchar 46 Review segment description
DEFAULT_REVIEWER_ID Integer 5 Default cost center reviewer id
ALTERNATE_REVIEWER_ID Integer 1 Alternate cost center reviewer id
SEGMENT1_NAME Varchar 15 segment name
SEGMENT1_CODE Integer 1 segment code
SEGMENT1_DISPLAY_STRING Varchar 255 segment display string
SEGMENT2_NAME Varchar 255 segment name
SEGMENT2_CODE Varchar 60 segment code
SEGMENT2_DISPLAY_STRING Varchar 255 segment display string
SEGMENT3_NAME Varchar 255 segment name
SEGMENT3_CODE Varchar 60 segment code
SEGMENT3_DISPLAY_STRING Varchar 255 segment display string
SEGMENT_COUNT Integer 1 the number of segments for this company or business unit
COST_CENTER_NAME Varchar 55 Concatenate of segment names
COST_CENTER_CODE Varchar 9 Concatenate of segment codes
COST_CENTER_DISPLAY_STRING Varchar 41 Concatenate of segment display strings
COST_CENTER_ACTIVE_STATUS Integer 1 Active status
CHANGE_TIMESTAMP DateTime
SEGMENT1_INDEX Integer 1 Segment 1 index
SEGMENT2_INDEX Integer 1 Segment 2 index
SEGMENT3_INDEX Integer 1 Segment 3 index
SEGMENT4_INDEX Integer 1 Segment 4 index
SEGMENT5_INDEX Integer 1 Segment 5 index
SEGMENT6_INDEX Integer 1 Segment 6 index
SEGMENT7_INDEX Integer 1 Segment 7 index
SEGMENT8_INDEX Integer 1 Segment 8 index
SEGMENT9_INDEX Integer 1 Segment 9 index