DW_EB_X_EBS_COMMON_W_PARTY_ORG_D

Party Organization Dimension includes B2C Customer , Supplier, Competitor data

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		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.
EFFECTIVE_FROM_DT	TIMESTAMP		6	DW System Column
INTEGRATION_ID	VARCHAR2	80 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.
ACCNT_AHA_NUM	VARCHAR2	30 CHAR		Account Aha Number
ACCNT_FLG	VARCHAR2	1 CHAR		Account Flag (Y/N) : It is set to Y if it is an Account, otherwise to N. Customer Billing Account Flag
ACCNT_GEOSTATE_WID	NUMBER		38	Foreign Key to Geography Dimension	DW_EB_X_EBS_COMMON_W_ACCGEOSTATE_D
ACCNT_HIN_NUM	VARCHAR2	30 CHAR		Account Hin Number
ACCNT_LOC	VARCHAR2	250 CHAR		Account Location
ACCNT_REGION	VARCHAR2	160 CHAR		Account Region
ACCOUNT_RANKING	VARCHAR2	100 CHAR
ACTIVE_FLG	VARCHAR2	1 CHAR		Active Flag (Y/N)
AGENCY_FLG	VARCHAR2	1 CHAR		Agency Flag
AGNC_CONTRACT_DT	TIMESTAMP		6	Agency Contract Date
ALT_CUSTOMER_NUM	VARCHAR2	80 CHAR		This is an alternate number assigned to the customer.
ALT_PHONE_NUM	VARCHAR2	30 CHAR		This is the customer's optional secondary phone number.
ANNUAL_REVENUE	NUMBER		28,10	Annual Revenue
ANNUAL_REVN_CAT_CODE	VARCHAR2	80 CHAR		Accounts Annual Revenue Category Code
AUX1_CHANGED_ON_DT	TIMESTAMP		6	DW System Column
AUX2_CHANGED_ON_DT	TIMESTAMP		6	DW System Column
AUX3_CHANGED_ON_DT	TIMESTAMP		6	DW System Column
AUX4_CHANGED_ON_DT	TIMESTAMP		6	DW System Column
AUX5_CHANGED_ON_DT	TIMESTAMP		6	DW System Column
AUX6_CHANGED_ON_DT	TIMESTAMP		6	DW System Column
AUX7_CHANGED_ON_DT	TIMESTAMP		6	DW System Column
AUX_CLASS_1_WID	NUMBER		38	Auxlilary Category 1 WID	DW_EB_X_EBS_COMMON_W_INDUSTRY_DH
AUX_CLASS_2_WID	NUMBER		38	Auxlilary Category 2 WID	DW_EB_X_EBS_COMMON_W_INDUSTRY_DH
AUX_CLASS_3_WID	NUMBER		38	Auxlilary Category 3 WID	DW_EB_X_EBS_COMMON_W_INDUSTRY_DH
BASE_CURCY_CD	VARCHAR2	20 CHAR		Currency Code
BOOK_VALUE	NUMBER		28,10	Book Value
BRANCH_FLG	VARCHAR2	1 CHAR		Branch Flag
BU_NAME	VARCHAR2	100 CHAR		Business Unit Name
CALL_FREQUENCY	VARCHAR2	30 CHAR		Call Frequency
CHANGED_BY_WID	NUMBER		38	DW System Column	DW_EB_X_EBS_COMMON_W_USER_D
CHANGED_ON_DT	TIMESTAMP		6	DW System Column
CHANNEL_FLG	VARCHAR2	1 CHAR		Channel Flag (Y/N)
CHNL_ANNL_SALES	NUMBER		28,10	Channel Annual sales
CHNL_SALES_GRWTH_CODE	VARCHAR2	80 CHAR		Channel Sales Growth Code
CITY_CODE	VARCHAR2	120 CHAR		Source City Code
CLIENT_FLG	VARCHAR2	1 CHAR		Client Flag
COMPETITOR_FLG	VARCHAR2	1 CHAR		Competitor Flag (Y/N): If organization is a competitor then it is set to Y otherwise to N
COUNTRY_CODE	VARCHAR2	120 CHAR		Source Country Code
CREATED_BY_WID	NUMBER		38	DW System Column	DW_EB_X_EBS_COMMON_W_USER_D
CREATED_ON_DT	TIMESTAMP		6	DW System Column
CREATED_SOURCE_CODE	VARCHAR2	80 CHAR
CREDIT_SCORE	NUMBER		28,10	Credit Score
CRIME_TYPE_CODE	VARCHAR2	80 CHAR		Crime Type Code
CURRENT_FLG	VARCHAR2	1 CHAR		DW System Column
CURR_ASSET	NUMBER		28,10	Current Asset
CURR_LIAB	NUMBER		28,10	Current Liability
CUSTOMER_NUM	VARCHAR2	80 CHAR		This is the customer number that is unique for each customer.
CUST_CAT_CODE	VARCHAR2	80 CHAR		Customer Category Code
CUST_CLASS_CODE	VARCHAR2	80 CHAR		Customer Class Code
CUST_END_DT	TIMESTAMP		6	Customer End Date
CUST_SINCE_DT	TIMESTAMP		6	Customer Since Date
CUST_STATUS_CODE	VARCHAR2	80 CHAR		Account Status Code
CUST_TYPE_CODE	VARCHAR2	80 CHAR		Organization Type Code
CUST_VALUE_CODE	VARCHAR2	80 CHAR		Customer Value Code
C_CITY_CODE	VARCHAR2	120 CHAR		Customized City Code
C_CONTINENT_CODE	VARCHAR2	120 CHAR		Customized Continent Code
C_COUNTRY_REGION_CODE	VARCHAR2	120 CHAR		Customized Country Region Code
C_COUNTY_CODE	VARCHAR2	120 CHAR		Customized County Code
C_REGION_CODE	VARCHAR2	120 CHAR		Customized Region Code
C_STATE_PROV_CODE	VARCHAR2	120 CHAR		Customized State Province Code
DB_RATING	VARCHAR2	5 CHAR		Dun aand Bradstreet Rating
DELETE_FLG	VARCHAR2	1 CHAR		DW System Column
DIRECT_MKTG_FLG	VARCHAR2	1 CHAR		This flag identifies whether the customer has explicitly requested no direct marketing contacts.
DISAB_VET_OWNED_FLG	VARCHAR2	1 CHAR
DIVIDEND	NUMBER		28,10	Dividend
DIVN_FLG	VARCHAR2	1 CHAR		Division Flag (Y/N) : If organization is a Division then it is set to Y otherwise to N
DIVN_TYPE_CODE	VARCHAR2	80 CHAR		Division Type Code
DOM_ULT_DUNS_NUM	VARCHAR2	15 CHAR		Domestic Ultimate DUNS Number
DUNNS_GLOBAL_NAME	VARCHAR2	255 CHAR		This provides the global name assigned by D&B.
DUNNS_LEGAL_NAME	VARCHAR2	255 CHAR		This provides the legal name assigned by D&B.
DUNNS_SITE_NAME	VARCHAR2	255 CHAR		This provides the site name assigned by D&B.
DUNS_NUM	VARCHAR2	15 CHAR		DUNS Number
EFFECTIVE_TO_DT	TIMESTAMP		6	DW System Column
EMAIL_ADDRESS	VARCHAR2	255 CHAR		Email Address
EMP_COUNT	NUMBER		28,10	Number of Employees
ETL_PROC_WID	NUMBER		38	Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data.
EXCHANGE_LOC	VARCHAR2	15 CHAR		Exchange Location
EXIST_SALES_ACCNT_FLG	VARCHAR2	1 CHAR		Existing Relationship with Sales Account Flag
EXPERTISE_CODE	VARCHAR2	80 CHAR		Expertise Code(Primary Expertise)
FACILITY_FLG	VARCHAR2	1 CHAR		Faciltiy Flag
FACILITY_TYPE_CODE	VARCHAR2	80 CHAR		Facility Type Code
FAX	VARCHAR2	100 CHAR
FIFTYTWO_HIGH	NUMBER		28,10	Fifty-two weeks High
FIFTYTWO_LOW	NUMBER		28,10	Fifty-two weeks low
FIN_METHOD_CODE	VARCHAR2	80 CHAR		Financial Method Code
FORMED_DT	TIMESTAMP		6	Formed Date
FRGHT_TERMS_CODE	VARCHAR2	80 CHAR		Freight Terms Code(values based on type FREIGHT_TERMS)
GEO_WID	NUMBER		38	Foreign Key to Geography Dimension	DW_EB_X_EBS_COMMON_W_GEO_D
GLBLULT_DUNS_NUM	VARCHAR2	15 CHAR		Global Ultimate DUNS Number
GOVT_ID_TYPE	VARCHAR2	30 CHAR		This defines whether the government identification type is a Tax ID, Social Security Number¿ etc.
GOVT_ID_VALUE	VARCHAR2	255 CHAR		This contains the actual ID value, such as the Tax ID, Social Security Number¿ etc.
GROSS_PROFIT	NUMBER		28,10	Gross Profit
GROWTH_HORIZ_CODE	VARCHAR2	80 CHAR		Growth Horizon Code
GROWTH_OBJ_CODE	VARCHAR2	80 CHAR		Growth Objective Code
GROWTH_PERCNTG	NUMBER		28,10	Growth Percentage
HIST_SLS_VOL	NUMBER		28,10	Historical Sales Volume (Calculated using Currency Code HIST_SLS_CURCY_CD and Exchange Date HIST_SLS_EXCH_DT)
HUB_ZONE_FLG	VARCHAR2	1 CHAR		Hub Zone Flag
IDENTIFIED_DT	TIMESTAMP		6	Identified Date
INDUSTRY_CODE	VARCHAR2	80 CHAR
INDUSTRY_WID	NUMBER		38	Industry WID	DW_EB_X_EBS_COMMON_W_INDUSTRY_DH
INTERNAL_FLG	VARCHAR2	1 CHAR		Internal Customer Flag
INTERNET_HOME_PAGE	VARCHAR2	255 CHAR		This is the home page of the organization.
INVESTOR_FLG	VARCHAR2	1 CHAR		Investor Flag
KEY_COMPETITOR	VARCHAR2	100 CHAR		Key Competitor
LEGAL_ENTITY_FLG	VARCHAR2	1 CHAR
LEGAL_FORM_CODE	VARCHAR2	80 CHAR		Legal Form Code
LEGAL_STRUCT_CODE	VARCHAR2	80 CHAR		A classification that defines the legal structure of the registration of the organization. For example, partnership, corporation¿ etc.
LINE_OF_BUSINESS	VARCHAR2	240 CHAR		Line of Business
LOYAL_SCORE1	NUMBER		28,10	Loyalty Score 1
LOYAL_SCORE2	NUMBER		28,10	Loyalty Score 2
LOYAL_SCORE3	NUMBER		28,10	Loyalty Score 3
LOYAL_SCORE4	NUMBER		28,10	Loyalty Score 4
LOYAL_SCORE5	NUMBER		28,10	Loyalty Score 5
LOYAL_SCORE6	NUMBER		28,10	Loyalty Score 6
LOYAL_SCORE7	NUMBER		28,10	Loyalty Score 7
MAIN_PH_NUM	VARCHAR2	40 CHAR		Main Phone Number
MANUFACTURER_FLG	VARCHAR2	1 CHAR
MARGIN_VS_INDUST_CODE	VARCHAR2	80 CHAR		Margin vs. Industry Code
MARKETING_MODULE_FLG	VARCHAR2	1 CHAR
MARKET_CLASS_CODE	VARCHAR2	80 CHAR		Market Class Code
MARKET_TYPE_CODE	VARCHAR2	80 CHAR		Market Type Code
MED_PROC	VARCHAR2	50 CHAR		Medical Procedure
MEMBER_NUM	VARCHAR2	50 CHAR		Member Number
MINORITY_GROUP_CODE	VARCHAR2	80 CHAR		Minority Group Code
MINORITY_OWNED_IND	VARCHAR2	30 CHAR		Minority Owned Business Indicator
MKT_POTENTIAL	VARCHAR2	30 CHAR		Market Potential
MRKT_CAP_PREF_CODE	VARCHAR2	80 CHAR		Market Cap Preference Code
NET_INCOME	NUMBER		28,10	Net Income
NON_CASH_EXP	NUMBER		28,10	Non Cash Expense
NUMB_OF_BEDS	NUMBER		10	Number of Beds
NUM_EMPLOY_CAT_CODE	VARCHAR2	80 CHAR		Number of Employee Category Code
OBJECTIVE_CODE	VARCHAR2	80 CHAR		Objective Code
OOB_IND	VARCHAR2	30 CHAR		Out of Business Indication
OPER_INCOME	NUMBER		28,10	Operation Income
ORG_DH_WID	NUMBER		38	Foreign Key to Party Organization Hierarchy.
ORG_FLG	VARCHAR2	1 CHAR		Organization Flag (Y/N) : It is set to Y if it organization, otherwise to N
ORG_NAME	VARCHAR2	250 CHAR		Organization Name
ORG_PRTNR_FLG	VARCHAR2	1 CHAR		Organization Partner Flag (Y/N) : If organization is a partner then it is set to Y otherwise to N
ORG_PRTNR_TIER_CODE	VARCHAR2	80 CHAR		Organization Partner Tier Code( values based on PARTNER_CERTIFICATION)
ORG_PRTNR_TYPE_CODE	VARCHAR2	80 CHAR		Organizatin Partner Type Code(values based on type PARTNER_TYPE)
ORG_SIZE_CODE	VARCHAR2	80 CHAR		Organization Size
ORG_TERR_NAME	VARCHAR2	75 CHAR		Organization Territory Name
ORG_TYPE_WID	NUMBER		38	Organization WID	DW_EB_X_EBS_COMMON_W_INDUSTRY_DH
PARENT_SUPPLIER_ID	VARCHAR2	80 CHAR		Parent Supplier ID
PAR_DUNS_NUM	VARCHAR2	15 CHAR		Par Duns Number
PAR_INTEGRATION_ID	VARCHAR2	80 CHAR		Parent Integration Id
PAR_ORG_NAME	VARCHAR2	100 CHAR		Parent Org Name
PERSIST_RATIO	NUMBER		28,10	Persist Ratio
POSTAL_CODE	VARCHAR2	120 CHAR		Postal or zip Code
PREF_ORDER_METHOD	VARCHAR2	30 CHAR		Preferred Order Method
PRIMARY_PHONE_AREA_CODE	VARCHAR2	10 CHAR		Primary Phone Area Code
PRIM_MARKET_CODE	VARCHAR2	80 CHAR		Primary Market Code
PRI_CONTACT_NAME	VARCHAR2	255 CHAR		Primary Contact Name
PRI_CONTACT_PHONE_NUM	VARCHAR2	40 CHAR		Primary Contact Phone Number
PRI_LST_NAME	VARCHAR2	50 CHAR		Price Lst Name
PROJ_EPS	NUMBER		28,10	Project EPS
PROSPECT_FLG	VARCHAR2	1 CHAR		Prospect Flag (Y/N)
PRTNRSHP_START_DT	TIMESTAMP		6	Partnershp Start Date
PRTNR_FLG	VARCHAR2	1 CHAR		Partner Flag
PRTNR_NAME	VARCHAR2	100 CHAR		Partner Name
PRTNR_SALES_RANK	NUMBER		28,10	Partner Sales Rank
PR_COMPETITOR	VARCHAR2	100 CHAR		Primary Competitor
PR_INDUST_NAME	VARCHAR2	50 CHAR		Primary Industry Name
PR_ORG_TRGT_MKT	VARCHAR2	50 CHAR		Primary Org Target Marketing
PR_PTSHP_MKTSEG	VARCHAR2	50 CHAR		Primary Partnership Mktseg
PR_SPEC_NAME	VARCHAR2	50 CHAR		Primary Specialty Name
PR_SYN_ID	VARCHAR2	100 CHAR		Primary Synonym Id
PTNTL_SLS_VOL	NUMBER		28,10	Potential Sales Volume
PTSHP_END_DT	TIMESTAMP		6	Partnership End Date
PTSHP_FEE_PAID_FLG	VARCHAR2	1 CHAR		Partnership Fee Paid Flag
PTSHP_PRTNR_ACCNT	VARCHAR2	100 CHAR		Partnership Partner Account
PTSHP_RENEWAL_DT	TIMESTAMP		6	Partnership Renewal Date
PTSHP_SAT_INDEX	NUMBER		28,10	Partnership Sat Index
PTSHP_STAGE_CODE	VARCHAR2	80 CHAR		Partnership Stage Code
PUBLIC_LISTING_FLG	VARCHAR2	1 CHAR		Public Listing Flag
QUICK_RATIO	NUMBER		28,10	Quick Ratio
REGION_CODE	VARCHAR2	120 CHAR		Source Region Code
REVN_GROWTH_CAT_CODE	VARCHAR2	80 CHAR		Revn Growth Category Code
ROW_WID	NUMBER		38	Surrogate key to uniquely identify a record.
SALES_ACCNT_FLG	VARCHAR2	1 CHAR		Sales Account Flag
SALES_ACCNT_TYPE_CODE	VARCHAR2	80 CHAR		Named Account Type Code
SALES_ACCT_SINCE_DT	TIMESTAMP		6	Sales Account Since Date
SALES_EMP_CNT	NUMBER		10	Sales Emp Count
SALES_MODULE_FLG	VARCHAR2	1 CHAR
SALES_REF_FLG	VARCHAR2	1 CHAR		Sales Reference Flag
SCD1_WID	NUMBER		38	Slow Changing Type 1 WID
SERVICE_EMP_CNT	NUMBER		10	Service Emp Count
SERVICE_MODULE_FLG	VARCHAR2	1 CHAR
SETID_CUSTOMER	VARCHAR2	30 CHAR		This column represents an 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.
SETID_VENDOR	VARCHAR2	30 CHAR		This column represents an 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.
SHARE_OUTST	NUMBER		28,10	Share Outstanding
SIC_CODE	VARCHAR2	80 CHAR		This is the Standard Industry Classification Code for the organization.
SMALL_BUS_IND	VARCHAR2	30 CHAR		Small Business Indicator
SOLICITATION_FLG	VARCHAR2	1 CHAR		This flag defines whether the customer has specifically requested that no marketing material be sent to them or that no illegal contacts are permitted. For example, it is illegal to contact the people in British Virgin Island from the United States.
SRC_EFF_FROM_DT	TIMESTAMP		6	DW System Column
SRC_EFF_TO_DT	TIMESTAMP		6	DW System Column
SRV_PROVDR_FLG	VARCHAR2	1 CHAR		Service Provider Flag
STATE_PROV_CODE	VARCHAR2	120 CHAR		Source State Provinvce Code
STAT_REASON_CODE	VARCHAR2	80 CHAR		Status Reason Code
ST_ADDRESS1	VARCHAR2	255 CHAR		Street Address Line 1
ST_ADDRESS2	VARCHAR2	255 CHAR		Street Address Line 2
ST_ADDRESS3	VARCHAR2	255 CHAR		Street Address Line 3
ST_ADDRESS4	VARCHAR2	255 CHAR		Street Address Line 4
SUPPLIER_ACTIVE_FLG	VARCHAR2	1 CHAR		Supplier Active Flag
SUPPLIER_CONTACT_NAME	VARCHAR2	200 CHAR		Supplier Primary Contact Name
SUPPLIER_EXT_NETWORK_ID	VARCHAR2	255 CHAR		External Network ID
SUPPLIER_FLG	VARCHAR2	1 CHAR		Supplier Flag (Y/N)
SUPPLIER_GROUP_CODE	VARCHAR2	80 CHAR		Supplier Group Code
SUPPLIER_ID	VARCHAR2	80 CHAR		Supplier ID
SUPPLIER_NUM	VARCHAR2	30 CHAR		Supplier Number
SUPPLIER_ONE_TIME_FLG	VARCHAR2	1 CHAR		One Time Flag for Supplier
SUPPLIER_RATING	VARCHAR2	1 CHAR
SUPPLIER_SEARCH_STR	VARCHAR2	255 CHAR		Search String
SUPPLIER_SINCE_DT	TIMESTAMP		6	Supplier Since Date
SUPPLIER_TYPE_CODE	VARCHAR2	80 CHAR		Supplier Type Code
SUPPRESS_CALL_FLG	VARCHAR2	1 CHAR		SUPPRESS_CALL_FLG
SUPPRESS_MAIL_FLG	VARCHAR2	1 CHAR		SUPPRESS_MAIL_FLG
TAX_REFERENCE	VARCHAR2	50 CHAR		Tax Reference
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.
TICKER	VARCHAR2	60 CHAR		Ticker
TOTAL_DEBT	NUMBER		28,10	Total Debt
TOTAL_NET_WORTH	NUMBER		28,10	Total Net Worth
TOT_ASSET	NUMBER		28,10	Total Asset
TOT_LIABILITY	NUMBER		28,10	Total Liability
TRAIL_EPS	NUMBER		28,10	Trail EPS
VET_OWNED_FLG	VARCHAR2	1 CHAR		Veteran Owned Flag
VIS_PR_BU_ID	VARCHAR2	15 CHAR		Primary Buisness Unit Id for Visibility
VIS_PR_POSTN_DH_WID	NUMBER		38	Foreign Key for Position Hierarchy Dimension	DW_EB_X_EBS_COMMON_W_POSITION_DH
VIS_PR_POS_ID	VARCHAR2	15 CHAR		Primary Postition Id For Visibility
VOLUME_TR	NUMBER		28,10	Trade Volume
WOMAN_OWNED_IND	VARCHAR2	30 CHAR		Women Owned Business Indicator
W_COUNTRY_CODE	VARCHAR2	120 CHAR		Warehouse Country Code
W_CRM_MODULE_CODE	VARCHAR2	80 CHAR
X_CUSTOM	VARCHAR2	10 CHAR		DW System Column
YR_ESTABLISHED	NUMBER		4	Year Established
W$_INSERT_DT	TIMESTAMP		6
W$_UPDATE_DT	TIMESTAMP		6