DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D

DW_EB_X_EBS_COMMON_W_CUSTOMER_ACCOUNT_D is the dimension table for Customer Account Dimension, the grain of this dimension is at the Account level.

Details

Module: Common Tables (EBS_COMMON)

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
Name	Datatype	Length	Precision	Comments	Referred Table
DATASOURCE_NUM_ID	NUMBER		22	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.
EFFECTIVE_FROM_DT	TIMESTAMP		6	Effective From Date
INTEGRATION_ID	VARCHAR2	80 CHAR		Customer Account ID
ACCOUNT_CLASS_CODE	VARCHAR2	80 CHAR		Customer Account Class Code
ACCOUNT_NUM	VARCHAR2	30 CHAR		Customer Account Number
ACCOUNT_SINCE_DT	TIMESTAMP		6	Customer Account Since Date
ACCOUNT_TEMINATION_DT	TIMESTAMP		6	Account Termination date
ACCOUNT_TYPE_CODE	VARCHAR2	80 CHAR		Customer Account Type Code
ACTIVE_FLG	VARCHAR2	1 CHAR		Active Flag
ALT_ACCOUNT_NUM	VARCHAR2	80 CHAR		Alternative Account Number
AUTOPAY_FLG	VARCHAR2	1 CHAR		Auto Payment Flag
AUX1_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary changed on date
AUX2_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary changed on date
AUX3_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary changed on date
AUX4_CHANGED_ON_DT	TIMESTAMP		6	Auxiliary changed on date
BASE_CURCY_CD	VARCHAR2	20 CHAR		Base Currency Code
BOE_PAYTERMS_CODE	VARCHAR2	80 CHAR		Bill of Exchange Payment Terms Code
CHANGED_BY_WID	NUMBER		38	Changed by wid	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6	Changed on date
COMPANY_CODE	VARCHAR2	80 CHAR		Customer Account Company
CREATED_BY_WID	NUMBER		38	created by wid	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6	Created on Date
CRLIMIT_EXCEED_DT	TIMESTAMP		6	Credit Limit Exceeded Date
CURRENT_FLG	VARCHAR2	1 CHAR		Current Flag
CUST_ACCOUNT_ATTR10_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 10
CUST_ACCOUNT_ATTR10_DATE	TIMESTAMP		6	Additional attribute date 10
CUST_ACCOUNT_ATTR10_NUM	NUMBER		20,4	Additional attribute Number 10
CUST_ACCOUNT_ATTR11_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 11
CUST_ACCOUNT_ATTR11_NUM	NUMBER		20,4	Additional attribute Number 11
CUST_ACCOUNT_ATTR12_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 12
CUST_ACCOUNT_ATTR12_NUM	NUMBER		20,4	Additional attribute Number 12
CUST_ACCOUNT_ATTR13_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 13
CUST_ACCOUNT_ATTR13_NUM	NUMBER		20,4	Additional attribute Number 13
CUST_ACCOUNT_ATTR14_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 14
CUST_ACCOUNT_ATTR14_NUM	NUMBER		20,4	Additional attribute Number 14
CUST_ACCOUNT_ATTR15_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 15
CUST_ACCOUNT_ATTR15_NUM	NUMBER		20,4	Additional attribute Number 15
CUST_ACCOUNT_ATTR16_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 16
CUST_ACCOUNT_ATTR16_NUM	NUMBER		20,4	Additional attribute Number 16
CUST_ACCOUNT_ATTR17_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 17
CUST_ACCOUNT_ATTR17_NUM	NUMBER		20,4	Additional attribute Number 17
CUST_ACCOUNT_ATTR18_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 18
CUST_ACCOUNT_ATTR18_NUM	NUMBER		20,4	Additional attribute Number 18
CUST_ACCOUNT_ATTR19_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 19
CUST_ACCOUNT_ATTR19_NUM	NUMBER		20,4	Additional attribute Number 19
CUST_ACCOUNT_ATTR1_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 1
CUST_ACCOUNT_ATTR1_DATE	TIMESTAMP		6	Additional attribute date 1
CUST_ACCOUNT_ATTR1_NUM	NUMBER		20,4	Additional attribute Number 1
CUST_ACCOUNT_ATTR20_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 20
CUST_ACCOUNT_ATTR20_NUM	NUMBER		20,4	Additional attribute Number 20
CUST_ACCOUNT_ATTR21_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 21
CUST_ACCOUNT_ATTR22_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 22
CUST_ACCOUNT_ATTR23_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 23
CUST_ACCOUNT_ATTR24_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 24
CUST_ACCOUNT_ATTR25_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 25
CUST_ACCOUNT_ATTR26_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 26
CUST_ACCOUNT_ATTR27_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 27
CUST_ACCOUNT_ATTR28_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 28
CUST_ACCOUNT_ATTR29_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 29
CUST_ACCOUNT_ATTR2_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 2
CUST_ACCOUNT_ATTR2_DATE	TIMESTAMP		6	Additional attribute date 2
CUST_ACCOUNT_ATTR2_NUM	NUMBER		20,4	Additional attribute Number 2
CUST_ACCOUNT_ATTR30_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 30
CUST_ACCOUNT_ATTR3_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 3
CUST_ACCOUNT_ATTR3_DATE	TIMESTAMP		6	Additional attribute date 3
CUST_ACCOUNT_ATTR3_NUM	NUMBER		20,4	Additional attribute Number 3
CUST_ACCOUNT_ATTR4_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 4
CUST_ACCOUNT_ATTR4_DATE	TIMESTAMP		6	Additional attribute date 4
CUST_ACCOUNT_ATTR4_NUM	NUMBER		20,4	Additional attribute Number 4
CUST_ACCOUNT_ATTR5_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 5
CUST_ACCOUNT_ATTR5_DATE	TIMESTAMP		6	Additional attribute date 5
CUST_ACCOUNT_ATTR5_NUM	NUMBER		20,4	Additional attribute Number 5
CUST_ACCOUNT_ATTR6_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 6
CUST_ACCOUNT_ATTR6_DATE	TIMESTAMP		6	Additional attribute date 6
CUST_ACCOUNT_ATTR6_NUM	NUMBER		20,4	Additional attribute Number 6
CUST_ACCOUNT_ATTR7_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 7
CUST_ACCOUNT_ATTR7_DATE	TIMESTAMP		6	Additional attribute date 7
CUST_ACCOUNT_ATTR7_NUM	NUMBER		20,4	Additional attribute Number 7
CUST_ACCOUNT_ATTR8_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 8
CUST_ACCOUNT_ATTR8_DATE	TIMESTAMP		6	Additional attribute date 8
CUST_ACCOUNT_ATTR8_NUM	NUMBER		20,4	Additional attribute Number 8
CUST_ACCOUNT_ATTR9_CHAR	VARCHAR2	255 CHAR		Additional attribute Character 9
CUST_ACCOUNT_ATTR9_DATE	TIMESTAMP		6	Additional attribute date 9
CUST_ACCOUNT_ATTR9_NUM	NUMBER		20,4	Additional attribute Number 9
DELETE_FLG	VARCHAR2	1 CHAR		Delete Flag
EFFECTIVE_TO_DT	TIMESTAMP		6	Effective To Date
ETL_PROC_WID	NUMBER		38	ETL Process WID
FRGHT_TERMS_CODE	VARCHAR2	80 CHAR		Freight Terms Code
HOLD_BILL_FLG	VARCHAR2	1 CHAR		Hold Bill Flag
HO_ACCT_NUM	VARCHAR2	30 CHAR		Head Office Account Number
LATE_CHARGE_BEGIN_DATE	TIMESTAMP		6	Late Charge Begin Date
NAME	VARCHAR2	250 CHAR		Customer Account Name
PARTY_ID	VARCHAR2	80 CHAR		Party ID
PAY_TERMS_CODE	VARCHAR2	80 CHAR		Bill of Exchange Payment Terms Code
RECON_ACCT_NUM	VARCHAR2	30 CHAR		Reconciliation Account Number
REF_CUSTOMER_NAME	VARCHAR2	255 CHAR		Reference Customer Name
REF_CUSTOMER_NUM	VARCHAR2	50 CHAR		Reference Customer Number
ROW_WID	NUMBER		38	Surrogate key to uniquely identify a record
SCD1_WID	NUMBER		38	SCD1_WID column
SET_ID	VARCHAR2	80 CHAR		Customer Account SET ID
SRC_EFF_FROM_DT	TIMESTAMP		6	Source effective from date
SRC_EFF_TO_DT	TIMESTAMP		6	Source effective to date
TAX_CODE	VARCHAR2	50 CHAR		Tax Code
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.
TOLERANCE_GRP_CODE	VARCHAR2	80 CHAR		Tolerance Group Code
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