DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D

This dimension table stores your General Ledger accounts. In Oracle, this table stores the GL Code Combinations. The GROUP_ACCOUNT_NUM field categorizes GL accounts into various groups. This categorization denotes the nature of the GL account. Some of the seeded GROUP_ACCOUNT_NUM values are ¿PPAID EXP¿ Prepaid Expense, ¿CASH¿, Cash, ¿WIP INV¿ Work in Process Inventory, etc.

Details

Module: Common Tables (EBS_COMMON)

Business Name: General Ledger accounts

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Not Null	Comments	Referred Table
ROW_WID	NUMBER			True	Surrogate key to uniquely identify a record.
ACCOUNT_SEG10_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG10_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG10_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG11_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG11_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG11_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG12_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG12_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG12_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG13_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG13_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG13_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG14_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG14_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG14_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG15_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG15_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG15_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG16_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG16_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG16_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG17_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG17_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG17_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG18_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG18_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG18_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG19_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG19_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG19_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG1_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG1_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG1_INTEGRATION_ID	VARCHAR2	100 CHAR				DW_EB_X_EBS_COMMON_W_GL_SEGMENT_D
ACCOUNT_SEG20_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG20_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG20_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG21_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG21_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG21_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG22_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG22_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG22_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG23_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG23_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG23_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG24_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG24_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG24_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG25_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG25_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG25_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG26_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG26_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG26_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG27_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG27_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG27_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG28_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG28_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG28_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG29_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG29_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG29_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG2_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, valueset id is stored in this column.
ACCOUNT_SEG2_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG2_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG30_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG30_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG30_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG3_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG3_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG3_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG4_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG4_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG4_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG5_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG5_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG5_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG6_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG6_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG6_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG7_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, valueset id is stored in this column.
ACCOUNT_SEG7_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG7_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG8_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG8_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG8_INTEGRATION_ID	VARCHAR2	100 CHAR
ACCOUNT_SEG9_ATTRIB	VARCHAR2	50 CHAR			Provides a flexible field that could be used to define additional attributes for a GL Account. When sourced from Oracle EBS, value set id is stored in this column.
ACCOUNT_SEG9_CODE	VARCHAR2	50 CHAR			Provides a flexible code field that could be used to define additional attributes for a GL Account.
ACCOUNT_SEG9_INTEGRATION_ID	VARCHAR2	100 CHAR
ACTIVE_FLG	VARCHAR2	1 CHAR			Flag indicating if this record is currently active in the system
AUX1_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX2_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX3_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
AUX4_CHANGED_ON_DT	TIMESTAMP		6		Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table.
BALANCING_SEGMENT_ATTRIB	VARCHAR2	50 CHAR				DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D
BALANCING_SEGMENT_NUM	VARCHAR2	50 CHAR				DW_EB_X_EBS_COMMON_W_BALANCING_SEGMENT_D
CHANGED_BY_WID	NUMBER		10		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was last modified in the source system.
CHART_OF_ACCOUNTS	VARCHAR2	50 CHAR			Chart of accounts (Hierarchical Attribute)
COMPANY_CODE	VARCHAR2	50 CHAR			The code which determines which financial company this account belongs to
COMPANY_NAME	VARCHAR2	80 CHAR			The name of the financial company this account belongs to
CONCATENATED_SEGMENT_VALUE	VARCHAR2	2000 CHAR
COST_CENTER_ATTRIB	VARCHAR2	50 CHAR			Cost center attribute
COST_CENTER_NUM	VARCHAR2	50 CHAR			Cost Center Number
CREATED_BY_WID	NUMBER		10		This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system.	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6		Identifies the date and time when the record was initially created in the source system.
CURRENCY_CODE	VARCHAR2	50 CHAR			Currency code
CURRENCY_NAME	VARCHAR2	80 CHAR			Currency name
CURRENT_FLG	VARCHAR2	1 CHAR			This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous.
DATASOURCE_NUM_ID	NUMBER		10		This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances.
DELETE_FLG	VARCHAR2	1 CHAR			This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active.
EFFECTIVE_FROM_DT	TIMESTAMP		6		This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
EFFECTIVE_TO_DT	TIMESTAMP		6		This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source.
ETL_PROC_WID	NUMBER		10		Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
FIN_STMT_ITEM_CODE	VARCHAR2	80 CHAR			The code which determines the nature of account (i.e. revenue, AP, AR etc)
GL_ACCOUNT_CAT_CODE	VARCHAR2	80 CHAR			This code which determines whether the account is Balance Sheet Account or Profit and Loss Account
GROUP_ACCOUNT_NUM	VARCHAR2	50 CHAR			Group account number (Hierarchical Attribute)
HIER1_WID	NUMBER		10		Key for the IA_HIERARCHIES Dimension	W_GL_ACCOUNT_DH
HIER2_WID	NUMBER		10		Key for the IA_HIERARCHIES Dimension	W_GL_ACCOUNT_DH
HIER3_WID	NUMBER		10		Key for the IA_HIERARCHIES Dimension	W_GL_ACCOUNT_DH
HIER4_WID	NUMBER		10		Key for the IA_HIERARCHIES Dimension	W_GL_ACCOUNT_DH
HIER5_WID	NUMBER		10		Key for the IA_HIERARCHIES Dimension	W_GL_ACCOUNT_DH
HIER6_WID	NUMBER		10		Key for the IA_HIERARCHIES Dimension	W_GL_ACCOUNT_DH
INTEGRATION_ID	VARCHAR2	240 CHAR			This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts.
MANAGEMENT_SEGMENT_NUM	VARCHAR2	50 CHAR
NATURAL_ACCOUNT_ATTRIB	VARCHAR2	50 CHAR				DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D
NATURAL_ACCOUNT_NUM	VARCHAR2	50 CHAR				DW_EB_X_EBS_COMMON_W_NATURAL_ACCOUNT_D
PROFIT_CENTER_ATTRIB	VARCHAR2	50 CHAR			Profit center attribute
PROFIT_CENTER_NUM	VARCHAR2	50 CHAR			Profit Center Num
PROGRAM_ATTRIB	VARCHAR2	50 CHAR
PROGRAM_CODE	VARCHAR2	50 CHAR			Program Segment Code
PROGRAM_INTEGRATION_ID	VARCHAR2	100 CHAR
PROJECT_ATTRIB	VARCHAR2	50 CHAR
PROJECT_CODE	VARCHAR2	50 CHAR			Project Segment Code
PROJECT_INTEGRATION_ID	VARCHAR2	100 CHAR
RECON_TYPE_CODE	VARCHAR2	50 CHAR			Reconciliation Account Type
SET_ID	VARCHAR2	30 CHAR			This column represents the unique identifier often used by source systems for the purpose of data sharing, reducing redundancies and minimizing system maintenance tasks, or even to drive data visibility. From a datawarehouse standpoint, the intended use of this column is to drive dimensional data security, primarily.
SRC_EFF_FROM_DT	TIMESTAMP		6		This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
SRC_EFF_TO_DT	TIMESTAMP		6		This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available)
TAX_CAT_CODE	VARCHAR2	50 CHAR			Tax category in account master
TAX_CAT_NAME	VARCHAR2	80 CHAR			Tax category name in account master
TENANT_ID	VARCHAR2	80 CHAR			This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
X_CUSTOM	VARCHAR2	10 CHAR			This column is used as a generic field for customer extensions.
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6