| Oracle® Retail Insights Cloud Service Suite Operations Guide Release 18.0.002.5 F25166-01 |
|
 Previous |
 Next |
| Oracle® Retail Insights Cloud Service Suite Operations Guide Release 18.0.002.5 F25166-01 |
|
Previous |
Next |
This appendix contains the list of non Retail Insights columns that are conformed with the Oracle BI application tables.
Table C-1 Unused Physical Columns
| Physical Table | Physical Column not used by Retail Insights |
|---|---|
|
W_WEEK_D |
W_CURRENT_CAL_WEEK_CODE |
|
W_CURRENT_CAL_YEAR_CODE |
|
|
FST_WEEK_CAL_YEAR_FLG |
|
|
LAST_WEEK_CAL_YEAR_FLG |
|
|
WEEK_KEY |
|
|
CAL_WEEK_END_DT_WID |
|
|
CAL_WEEK_END_DT_KEY |
|
|
CAL_WEEK_START_DT_WID |
|
|
CAL_WEEK_START_DT_KEY |
|
|
CAL_WEEK |
|
|
JULIAN_WEEK_NUM |
|
|
JULIAN_YEAR_NUM |
|
|
CAL_YEAR_START_DT_WID |
|
|
CAL_YEAR_END_DT_WID |
|
|
W_PARTY_PER_D |
ACCESS_LVL_CODE |
|
ACCESS_LVL_NAME |
|
|
ACCNT_FLG |
|
|
ACTIVE_FLG |
|
|
ADDR_EFF_DT |
|
|
AGE_RANGE |
|
|
AGENT_FLG |
|
|
ANNL_REVENUE |
|
|
APPR_AUTH |
|
|
APPR_AUTH_CAT_CODE |
|
|
APPR_AUTH_CAT_NAME |
|
|
APPR_CURCY_CD |
|
|
BIRTH_PLACE |
|
|
CALL_FLG |
|
|
CALL_LST_NAME |
|
|
CITIZENSHIP_CODE |
|
|
CITIZENSHIP_NAME |
|
|
CITY_CODE |
|
|
COM_PREFERENCE |
|
|
COMP_OWNER_FLG |
|
|
COMPLEXION_CODE |
|
|
COMPLEXION_NAME |
|
|
CON_ACTIVE_FLG |
|
|
CON_BU_NAME |
|
|
CON_FORMED_DT |
|
|
CONSUMER_FLG |
|
|
COUNTRY_CODE |
|
|
CREDIT_SCORE |
|
|
CUST_END_DT |
|
|
CUST_SINCE_DT |
|
|
CUST_VAL_EFF_DT |
|
|
CUST_VALUE_CODE |
|
|
CUST_VALUE_NAME |
|
|
DEATH_DT |
|
|
DECEASE_FLG |
|
|
DEPARTMENT_NAME |
|
|
DEPT_TYPE_CODE |
|
|
DEPT_TYPE_NAME |
|
|
EDUCATION_BCKGND_NAME |
|
|
EDUCATION_YEARS |
|
|
EMAIL_SR_UPD_FLG |
|
|
EMP_ACCNT_BU_NAME |
|
|
EMP_ACCNT_LOC |
|
|
EMP_ACCNT_NAME |
|
|
EMP_ACTIVE_FLG |
|
|
EMP_FLG |
|
|
EMP_FORMED_DT |
|
|
EMP_HIRE_DT |
|
|
EMPLMNT_STAT_CODE |
|
|
ENTERPRISE_FLG |
|
|
ETHNICITY_NAME |
|
|
ETHNICITY1_CD |
|
|
ETHNICITY2_CD |
|
|
EXT_CON_STORE |
|
|
EYE_COLOR_LEFT_CODE |
|
|
EYE_COLOR_LEFT_NAME |
|
|
EYE_COLOR_RIGHT_CODE |
|
|
EYE_COLOR_RIGHT_NAME |
|
|
FST_PROMO_DT |
|
|
GEO_WID |
|
|
GOALS |
|
|
GRAD_YR |
|
|
HAIR_COLOR |
|
|
HARD_TO_REACH |
|
|
HEIGHT |
|
|
HELD_POSTN |
|
|
HOBBY |
|
|
INCOME_RANGE_CODE |
|
|
INCOME_RANGE_NAME |
|
|
INCOME_RNG_EFF_DT |
|
|
INVST_EXPERIENCE_CODE |
|
|
INVST_EXPERIENCE_NAME |
|
|
INVST_HORIZON_CODE |
|
|
INVST_HORIZON_NAME |
|
|
INVST_KNOWLEDGE_CODE |
|
|
INVST_KNOWLEDGE_NAME |
|
|
INVST_OBJECTIVE_CODE |
|
|
INVST_OBJECTIVE_NAME |
|
|
INVST_PROFILE_CODE |
|
|
INVST_PROFILE_NAME |
|
|
INVST_RISK_CODE |
|
|
INVST_RISK_NAME |
|
|
JOB_CATEGORY_CODE |
|
|
JOB_CATEGORY_NAME |
|
|
JOB_TITLE |
|
|
LST_PROMO_DT |
|
|
MARITAL_STAT_NAME |
|
|
MASTER_CUSTOMER_NAME |
|
|
MASTER_CUSTOMER_NUM |
|
|
MEMBER_FLG |
|
|
MKT_POTENTIAL |
|
|
MRKT_CAP_PREF_CODE |
|
|
MRKT_CAP_PREF_NAME |
|
|
NAME_EFF_DT |
|
|
NET_WORTH_CODE |
|
|
NET_WORTH_EFF_DT |
|
|
NET_WORTH_NAME |
|
|
NUM_CMPGNS |
|
|
NUM_OFRS_PRSNTD |
|
|
OU_MAIL_STOP |
|
|
PAR_HELD_POSTN |
|
|
PR_HOUSEHOLD_WID |
|
|
PR_MKT_SEGMENT |
|
|
PR_POSTN |
|
|
PR_SPEC_NAME |
|
|
PR_SPECIALTY |
|
|
PRE_LANG |
|
|
PREF_CALL_FREQ |
|
|
PREF_COMM_MEDIA_CODE |
|
|
PREF_COMM_MEDIA_NAME |
|
|
PREF_LANG_ID |
|
|
PRESCRIBER_FLG |
|
|
PROF_TITLE |
|
|
PROVIDER_FLG |
|
|
REGION_CODE |
|
|
REGION_NAME |
|
|
RESDNCE_CATEGORY_CODE |
|
|
RESDNCE_CATEGORY_NAME |
|
|
RESDNCE_TYPE_CODE |
|
|
RESDNCE_TYPE_NAME |
|
|
RESDNCE_VAL |
|
|
RESIDENCY_INSTN |
|
|
RSRCH_CHNL_PREF_CODE |
|
|
RSRCH_CHNL_PREF_NAME |
|
|
SELF_EMPL_FLG |
|
|
SEMINAR_INVIT_FLG |
|
|
SEX_MF_NAME |
|
|
SPEAKER_FLG |
|
|
SPECIALTY_BRICK |
|
|
STAFF |
|
|
STAT_REASON_CODE |
|
|
STAT_REASON_NAME |
|
|
STATUS_CODE |
|
|
STATUS_NAME |
|
|
STUDENT_FLG |
|
|
SUPPLIER_FLG |
|
|
SUPPLIER_ID |
|
|
SUPPRESS_CALL_FLG |
|
|
SUPPRESS_EMAIL_FLG |
|
|
SUPPRESS_FAX_FLG |
|
|
SUPPRESS_MAIL_FLG |
|
|
TAX_BRACKET |
|
|
TERR_NAME |
|
|
VETERAN_FLG |
|
|
VIS_PR_BU_ID |
|
|
VIS_PR_POS_ID |
|
|
VIS_PR_POSTN_DH_WID |
|
|
WEIGHT |
|
|
YEARS_AT_ACCNT |
|
|
YRS_AT_RESIDENCE |
|
|
W_MCAL_DAY_D |
CAL_DAY_AGO_DT |
|
CAL_DAY_AGO_KEY |
|
|
CAL_DAY_AGO_WID |
|
|
CAL_HALF |
|
|
CAL_TRIMESTER |
|
|
CAL_JULIAN_DAY_NUM |
|
|
CAL_JULIAN_MONTH_NUM |
|
|
CAL_JULIAN_WEEK_NUM |
|
|
CAL_JULIAN_TER_NUM |
|
|
CAL_JULIAN_YEAR_NUM |
|
|
CAL_YEAR_WID |
|
|
CAL_YEAR_START_DT_WID |
|
|
CAL_YEAR_END_DT_WID |
|
|
CAL_YEAR_TOTAL_DAYS |
|
|
CAL_PRIOR_YEAR_WID |
|
|
MCAL_PERIOD_START_DT_WID |
|
|
MCAL_PERIOD_END_DT_WID |
|
|
MCAL_PRIOR_PERIOD_WID |
|
|
MCAL_PERIOD_AGO_WID |
|
|
MCAL_PERIOD_OF_YEAR |
|
|
MCAL_PERIOD_OF_QTR |
|
|
MCAL_PERIOD_START_DAY_WID |
|
|
MCAL_PERIOD_END_DAY_WID |
|
|
MCAL_JULIAN_PERIOD_NUM |
|
|
MCAL_WEEK_START_DT_KEY |
|
|
MCAL_WEEK_START_DT_WID |
|
|
MCAL_WEEK_END_DT_KEY |
|
|
MCAL_WEEK_END_DT_WID |
|
|
MCAL_PRIOR_WEEK_WID |
|
|
MCAL_WEEK_AGO_WID |
|
|
MCAL_WEEK_OF_YEAR |
|
|
MCAL_WEEK_OF_QTR |
|
|
MCAL_WEEK_OF_PERIOD |
|
|
MCAL_WEEK_START_DAY_WID |
|
|
MCAL_WEEK_END_DAY_WID |
|
|
MCAL_PER_NAME_TER |
|
|
MCAL_QTR_WID |
|
|
MCAL_QTR |
|
|
MCAL_QTR_START_DT |
|
|
MCAL_QTR_START_DT_WID |
|
|
MCAL_QTR_END_DT |
|
|
MCAL_QTR_END_DT_WID |
|
|
MCAL_PRIOR_QTR_WID |
|
|
MCAL_QTR_AGO_WID |
|
|
MCAL_QTR_OF_YEAR |
|
|
MCAL_QTR_START_DAY_WID |
|
|
MCAL_QTR_END_DAY_WID |
|
|
MCAL_YEAR_WID |
|
|
MCAL_YEAR_START_DT_WID |
|
|
MCAL_YEAR_END_DT_WID |
|
|
MCAL_YEAR_TOTAL_WEEKS |
|
|
MCAL_YEAR_TOTAL_DAYS |
|
|
MCAL_PRIOR_YEAR_WID |
|
|
MCAL_YEAR_START_DAY_WID |
|
|
MCAL_YEAR_END_DAY_WID |
|
|
MCAL_DAY_OF_YEAR |
|
|
MCAL_DAY_OF_QTR |
|
|
MCAL_DAY_OF_PERIOD |
|
|
MCAL_DAY_OF_WEEK |
|
|
W_CURRENT_MCAL_DAY_CODE |
|
|
W_CURRENT_MCAL_PERIOD_CODE |
|
|
W_CURRENT_MCAL_QTR_CODE |
|
|
W_CURRENT_MCAL_WEEK_CODE |
|
|
W_CURRENT_MCAL_YEAR_CODE |
|
|
FST_DAY_MCAL_PER_FLG |
|
|
FST_DAY_MCAL_QTR_FLG |
|
|
FST_DAY_MCAL_WEEK_FLG |
|
|
FST_DAY_MCAL_YEAR_FLG |
|
|
LAST_DAY_MCAL_PER_FLG |
|
|
LAST_DAY_MCAL_QTR_FLG |
|
|
LAST_DAY_MCAL_WEEK_FLG |
|
|
LAST_DAY_MCAL_YEAR_FLG |
|
|
W_CAL_DAY_CODE |
|
|
CAL_DAY_OF_THE_WEEK_ABBR |
|
|
CAL_DAY_OF_THE_WEEK_CODE |
|
|
CAL_DAY_OF_YEAR |
|
|
CAL_DAY_OF_QTR |
|
|
CAL_DAY_OF_MONTH |
|
|
CAL_WEEK_WID |
|
|
CAL_WEEK |
|
|
CAL_WEEK_START_DT_WID |
|
|
CAL_WEEK_END_DT_WID |
|
|
CAL_WEEK_ABBR |
|
|
CAL_WEEK_OF_QTR |
|
|
CAL_WEEK_TOTAL_DAYS |
|
|
CAL_PRIOR_WEEK_WID |
|
|
CAL_WEEK_AGO_WID |
|
|
CAL_MONTH_WID |
|
|
CAL_MONTH |
|
|
W_CAL_MONTH_CODE |
|
|
CAL_MONTH_START_DT_WID |
|
|
CAL_MONTH_END_DT_WID |
|
|
CAL_MONTH_ABBR |
|
|
CAL_MONTH_OF_QTR |
|
|
CAL_MONTH_TOTAL_DAYS |
|
|
CAL_PRIOR_MONTH_WID |
|
|
CAL_MONTH_AGO_WID |
|
|
CAL_QTR_WID |
|
|
CAL_QTR |
|
|
CAL_QTR_ABBR |
|
|
CAL_QTR_NAME |
|
|
CAL_QTR_START_DT |
|
|
CAL_QTR_START_DT_WID |
|
|
CAL_QTR_END_DT |
|
|
CAL_QTR_END_DT_WID |
|
|
CAL_QTR_TOTAL_DAYS |
|
|
CAL_PRIOR_QTR_WID |
|
|
CAL_QTR_AGO_WID |
|
|
MCAL_CAL_WID |
|
|
MCAL_CAL_ID |
|
|
MCAL_CAL_CLASS |
|
|
MCAL_DAY_CODE |
|
|
MCAL_DAY_DT_WID |
|
|
ADJUSTMENT_PERIOD_FLG |
|
|
MCAL_PERIOD_WID |
|
|
MCAL_PERIOD_TYPE |
|
|
MCAL_PERIOD |
|
|
W_MCAL_PERIOD_D |
CAL_DAY_AGO_DT |
|
CAL_DAY_AGO_KEY |
|
|
CAL_DAY_AGO_WID |
|
|
CAL_HALF |
|
|
CAL_TRIMESTER |
|
|
CAL_JULIAN_DAY_NUM |
|
|
CAL_JULIAN_MONTH_NUM |
|
|
CAL_JULIAN_WEEK_NUM |
|
|
CAL_JULIAN_TER_NUM |
|
|
CAL_JULIAN_YEAR_NUM |
|
|
CAL_YEAR_WID |
|
|
CAL_YEAR_START_DT_WID |
|
|
CAL_YEAR_END_DT_WID |
|
|
CAL_YEAR_TOTAL_DAYS |
|
|
CAL_PRIOR_YEAR_WID |
|
|
MCAL_PERIOD_START_DT_WID |
|
|
MCAL_PERIOD_END_DT_WID |
|
|
MCAL_PRIOR_PERIOD_WID |
|
|
MCAL_PERIOD_AGO_WID |
|
|
MCAL_PERIOD_OF_YEAR |
|
|
MCAL_PERIOD_OF_QTR |
|
|
MCAL_PERIOD_START_DAY_WID |
|
|
MCAL_PERIOD_END_DAY_WID |
|
|
MCAL_JULIAN_PERIOD_NUM |
|
|
MCAL_WEEK_START_DT_KEY |
|
|
MCAL_WEEK_START_DT_WID |
|
|
MCAL_WEEK_END_DT_KEY |
|
|
MCAL_WEEK_END_DT_WID |
|
|
MCAL_PRIOR_WEEK_WID |
|
|
MCAL_WEEK_AGO_WID |
|
|
MCAL_WEEK_OF_YEAR |
|
|
MCAL_WEEK_OF_QTR |
|
|
MCAL_WEEK_OF_PERIOD |
|
|
MCAL_WEEK_START_DAY_WID |
|
|
MCAL_WEEK_END_DAY_WID |
|
|
MCAL_PER_NAME_TER |
|
|
MCAL_QTR_WID |
|
|
MCAL_QTR |
|
|
MCAL_QTR_START_DT |
|
|
MCAL_QTR_START_DT_WID |
|
|
MCAL_QTR_END_DT |
|
|
MCAL_QTR_END_DT_WID |
|
|
MCAL_PRIOR_QTR_WID |
|
|
MCAL_QTR_AGO_WID |
|
|
MCAL_QTR_OF_YEAR |
|
|
MCAL_QTR_START_DAY_WID |
|
|
MCAL_QTR_END_DAY_WID |
|
|
MCAL_YEAR_WID |
|
|
MCAL_YEAR_START_DT_WID |
|
|
MCAL_YEAR_END_DT_WID |
|
|
MCAL_YEAR_TOTAL_WEEKS |
|
|
MCAL_YEAR_TOTAL_DAYS |
|
|
MCAL_PRIOR_YEAR_WID |
|
|
MCAL_YEAR_START_DAY_WID |
|
|
MCAL_YEAR_END_DAY_WID |
|
|
MCAL_DAY_OF_YEAR |
|
|
MCAL_DAY_OF_QTR |
|
|
MCAL_DAY_OF_PERIOD |
|
|
MCAL_DAY_OF_WEEK |
|
|
W_CURRENT_MCAL_DAY_CODE |
|
|
W_CURRENT_MCAL_PERIOD_CODE |
|
|
W_CURRENT_MCAL_QTR_CODE |
|
|
W_CURRENT_MCAL_WEEK_CODE |
|
|
W_CURRENT_MCAL_YEAR_CODE |
|
|
FST_DAY_MCAL_PER_FLG |
|
|
FST_DAY_MCAL_QTR_FLG |
|
|
FST_DAY_MCAL_WEEK_FLG |
|
|
FST_DAY_MCAL_YEAR_FLG |
|
|
LAST_DAY_MCAL_PER_FLG |
|
|
LAST_DAY_MCAL_QTR_FLG |
|
|
LAST_DAY_MCAL_WEEK_FLG |
|
|
LAST_DAY_MCAL_YEAR_FLG |
|
|
W_CAL_DAY_CODE |
|
|
CAL_DAY_OF_THE_WEEK_ABBR |
|
|
CAL_DAY_OF_THE_WEEK_CODE |
|
|
CAL_DAY_OF_YEAR |
|
|
CAL_DAY_OF_QTR |
|
|
CAL_DAY_OF_MONTH |
|
|
CAL_WEEK_WID |
|
|
CAL_WEEK |
|
|
CAL_WEEK_START_DT_WID |
|
|
CAL_WEEK_END_DT_WID |
|
|
CAL_WEEK_ABBR |
|
|
CAL_WEEK_OF_QTR |
|
|
CAL_WEEK_TOTAL_DAYS |
|
|
CAL_PRIOR_WEEK_WID |
|
|
CAL_WEEK_AGO_WID |
|
|
CAL_MONTH_WID |
|
|
CAL_MONTH |
|
|
W_CAL_MONTH_CODE |
|
|
CAL_MONTH_START_DT_WID |
|
|
CAL_MONTH_END_DT_WID |
|
|
CAL_MONTH_ABBR |
|
|
CAL_MONTH_OF_QTR |
|
|
CAL_MONTH_TOTAL_DAYS |
|
|
CAL_PRIOR_MONTH_WID |
|
|
CAL_MONTH_AGO_WID |
|
|
CAL_QTR_WID |
|
|
CAL_QTR |
|
|
CAL_QTR_ABBR |
|
|
CAL_QTR_NAME |
|
|
CAL_QTR_START_DT |
|
|
CAL_QTR_START_DT_WID |
|
|
CAL_QTR_END_DT |
|
|
CAL_QTR_END_DT_WID |
|
|
CAL_QTR_TOTAL_DAYS |
|
|
CAL_PRIOR_QTR_WID |
|
|
CAL_QTR_AGO_WID |
|
|
MCAL_CAL_WID |
|
|
MCAL_CAL_ID |
|
|
MCAL_CAL_CLASS |
|
|
MCAL_DAY_CODE |
|
|
MCAL_DAY_DT_WID |
|
|
ADJUSTMENT_PERIOD_FLG |
|
|
MCAL_PERIOD_WID |
|
|
MCAL_PERIOD_TYPE |
|
|
MCAL_PERIOD |
|
|
W_MCAL_QTR_D |
MCAL_QTR_KEY |
|
MCAL_HALF |
|
|
MCAL_QTR_LAST_DAY_OF_YEAR |
|
|
MCAL_FST_QTR_FR_KEY |
|
|
MCAL_FST_QTR_TO_KEY |
|
|
MCAL_PER_NAME_HALF |
|
|
MCAL_DIM_QTR_NUM |
|
|
MCAL_DIM_YEAR_NUM |
|
|
MCAL_QTR_START_DT |
|
|
MCAL_QTR_START_DT_KEY |
|
|
MCAL_QTR_START_DT_WID |
|
|
MCAL_QTR_END_DT |
|
|
MCAL_QTR_END_DT_KEY |
|
|
MCAL_QTR_END_DT_WID |
|
|
MCAL_YEAR_WID |
|
|
MCAL_YEAR_START_DT_WID |
|
|
MCAL_YEAR_END_DT_WID |
|
|
MCAL_YEAR_START_QTR_WID |
|
|
MCAL_YEAR_TOTAL_WEEKS |
|
|
MCAL_YEAR_TOTAL_DAYS |
|
|
MCAL_YEAR_START_DAY_WID |
|
|
MCAL_YEAR_END_DAY_WID |
|
|
MCAL_PRIOR_YEAR_WID |
|
|
MCAL_PRIOR_QTR_WID |
|
|
MCAL_QTR_AGO_WID |
|
|
MCAL_QTR_START_DAY_WID |
|
|
MCAL_QTR_END_DAY_WID |
|
|
W_CURRENT_MCAL_QTR_CODE |
|
|
W_CURRENT_MCAL_YEAR_CODE |
|
|
FST_QTR_MCAL_YEAR_FLG |
|
|
LAST_QTR_MCAL_YEAR_FLG |
|
|
W_MCAL_WEEK_D |
MCAL_PERIOD_TOTAL_DAYS |
|
MCAL_PERIOD_START_DAY_WID |
|
|
MCAL_PERIOD_END_DAY_WID |
|
|
MCAL_QTR_WID |
|
|
MCAL_QTR_NUM |
|
|
MCAL_QTR_START_DT |
|
|
MCAL_QTR_START_DT_WID |
|
|
MCAL_QTR_END_DT |
|
|
MCAL_QTR_END_DT_WID |
|
|
MCAL_PRIOR_QTR_WID |
|
|
MCAL_QTR_AGO_WID |
|
|
MCAL_QTR_START_DAY_WID |
|
|
MCAL_QTR_END_DAY_WID |
|
|
MCAL_YEAR_WID |
|
|
MCAL_YEAR_START_DT_WID |
|
|
MCAL_YEAR_END_DT_WID |
|
|
MCAL_YEAR_TOTAL_WEEKS |
|
|
MCAL_YEAR_TOTAL_DAYS |
|
|
MCAL_YEAR_START_DAY_WID |
|
|
MCAL_YEAR_END_DAY_WID |
|
|
MCAL_PRIOR_YEAR_WID |
|
|
W_CURRENT_MCAL_WEEK_CODE |
|
|
W_CURRENT_MCAL_PERIOD_CODE |
|
|
W_CURRENT_MCAL_MONTH_CODE |
|
|
W_CURRENT_MCAL_QTR_CODE |
|
|
W_CURRENT_MCAL_YEAR_CODE |
|
|
FST_WK_MCAL_MNTH_FLG |
|
|
LAST_WK_MCAL_MNTH_FLG |
|
|
FST_WK_MCAL_QTR_FLG |
|
|
LAST_WK_MCAL_QTR_FLG |
|
|
FST_WK_MCAL_YEAR_FLG |
|
|
LAST_WK_MCAL_YEAR_FLG |
|
|
MCAL_CAL_WID |
|
|
MCAL_CAL_ID |
|
|
MCAL_CAL_NAME |
|
|
MCAL_CAL_CLASS |
|
|
MCAL_WEEK |
|
|
MCAL_WEEK_START_DT_KEY |
|
|
MCAL_WEEK_START_DT_WID |
|
|
MCAL_WEEK_END_DT_KEY |
|
|
MCAL_WEEK_END_DT_WID |
|
|
MCAL_WEEK_START_DAY_WID |
|
|
MCAL_WEEK_END_DAY_WID |
|
|
MCAL_HALF |
|
|
MCAL_MONTH |
|
|
MCAL_QTR |
|
|
MCAL_TRIMESTER |
|
|
MCAL_WEEK_OF_YEAR |
|
|
MCAL_WEEK_OF_QTR |
|
|
MCAL_WEEK_OF_PERIOD |
|
|
MCAL_FST_WK_FR_KEY |
|
|
MCAL_FST_WK_TO_KEY |
|
|
MCAL_WEEK_KEY |
|
|
MCAL_PRIOR_WEEK_WID |
|
|
MCAL_WEEK_AGO_WID |
|
|
MCAL_PER_NAME_MNTH |
|
|
MCAL_PER_NAME_TER |
|
|
MCAL_DIM_WEEK_NUM |
|
|
MCAL_DIM_MNTH_NUM |
|
|
MCAL_DIM_QTR_NUM |
|
|
MCAL_DIM_YEAR_NUM |
|
|
MCAL_PERIOD_WID |
|
|
MCAL_PERIOD_TYPE |
|
|
MCAL_PERIOD_NUM |
|
|
MCAL_PERIOD_START_DT_WID |
|
|
MCAL_PERIOD_END_DT_WID |
|
|
MCAL_PRIOR_PERIOD_WID |
|
|
MCAL_PERIOD_AGO_WID |
|
|
MCAL_PERIOD_OF_YEAR |
|
|
MCAL_PERIOD_OF_QUARTER |
|
|
MCAL_PERIOD_TOTAL_WEEKS |
|
|
W_MCAL_YEAR_D |
MCAL_CAL_WID |
|
MCAL_CAL_ID |
|
|
MCAL_CAL_NAME |
|
|
MCAL_CAL_CLASS |
|
|
MCAL_PERIOD_TYPE |
|
|
MCAL_YEAR_KEY |
|
|
MCAL_DIM_YEAR_NUM |
|
|
MCAL_YEAR_START_DT_KEY |
|
|
MCAL_YEAR_START_DT_WID |
|
|
MCAL_YEAR_END_DT_KEY |
|
|
MCAL_YEAR_END_DT_WID |
|
|
MCAL_YEAR_TOTAL_WEEKS |
|
|
MCAL_YEAR_TOTAL_DAYS |
|
|
MCAL_PRIOR_YEAR_WID |
|
|
MCAL_YEAR_LAST_DAY_OF_YEAR |
|
|
MCAL_YEAR_START_DAY_WID |
|
|
MCAL_YEAR_END_DAY_WID |
|
|
W_CURRENT_MCAL_YEAR_CODE |
|
|
W_YEAR_D |
JULIAN_YEAR_NUM |
|
YEAR_AGO_WID |
|
|
YEAR_KEY |
|
|
CAL_YEAR_END_DT_KEY |
|
|
CAL_YEAR_END_DT_WID |
|
|
CAL_YEAR_START_DT_KEY |
|
|
CAL_YEAR_START_DT_WID |
|
|
W_CURRENT_CAL_YEAR_CODE |
|
|
W_QTR_D |
CAL_HALF |
|
CAL_QTR |
|
|
JULIAN_QTR_NUM |
|
|
JULIAN_YEAR_NUM |
|
|
Q_END_CAL_DT_WID |
|
|
CAL_QTR_END_DT_KEY |
|
|
Q_STRT_CAL_DT_WID |
|
|
CAL_QTR_START_DT_KEY |
|
|
YEAR_AGO_WID |
|
|
HALF_AGO_WID |
|
|
QUARTER_AGO_WID |
|
|
CAL_QTR_START_DT |
|
|
CAL_QTR_END_DT |
|
|
W_CURRENT_CAL_QTR_CODE |
|
|
W_CURRENT_CAL_YEAR_CODE |
|
|
FST_QTR_YEAR_FLG |
|
|
LAST_QTR_YEAR_FLG |
|
|
QUARTER_KEY |
|
|
CAL_YEAR_END_DT_WID |
|
|
CAL_YEAR_STRT_DT_WID |
|
|
W_MONTH_D |
CAL_HALF |
|
CAL_MONTH |
|
|
CAL_QTR |
|
|
CAL_TRIMESTER |
|
|
JULIAN_MONTH_NUM |
|
|
JULIAN_QTR_NUM |
|
|
JULIAN_TER_NUM |
|
|
JULIAN_YEAR_NUM |
|
|
W_MONTH_CODE |
|
|
M_END_CAL_DT_WID |
|
|
CAL_MONTH_END_DT_KEY |
|
|
M_STRT_CAL_DT_WID |
|
|
CAL_MONTH_START_DT_KEY |
|
|
PER_NAME_TER |
|
|
HALF_AGO_WID |
|
|
MONTH_AGO_WID |
|
|
MONTH_KEY |
|
|
QUARTER_AGO_WID |
|
|
TRIMESTER_AGO_WID |
|
|
YEAR_AGO_WID |
|
|
CAL_QTR_START_DT |
|
|
CAL_QTR_END_DT |
|
|
W_CURRENT_CAL_MONTH_CODE |
|
|
W_CURRENT_CAL_QTR_CODE |
|
|
W_CURRENT_CAL_YEAR_CODE |
|
|
FST_MONTH_CAL_QTR_FLG |
|
|
LAST_MONTH_CAL_QTR_FLG |
|
|
FST_MONTH_CAL_YEAR_FLG |
|
|
LAST_MONTH_CAL_YEAR_FLG |
|
|
CAL_QTR_END_DT_WID |
|
|
CAL_QTR_START_DT_WID |
|
|
CAL_YEAR_END_DT_WID |
|
|
CAL_YEAR_START_DT_WID |
|
|
W_EMPLOYEE_D |
ACCOUNT_REP_FLG |
|
ADDR_EFF_DATE |
|
|
ADDRESS_LINE_1 |
|
|
ADDRESS_LINE_2 |
|
|
ADDRESS_LINE_3 |
|
|
ADDRESS_LINE_4 |
|
|
ADJ_SERVICE_DT |
|
|
ADJ_SERVICE_DT_WID |
|
|
ALT_EMP_NUM |
|
|
ALTERNATE_EMAIL_ADDR |
|
|
APPLICANT_FLG |
|
|
APPLICANT_NUM |
|
|
APPR_AUTH |
|
|
APPR_AUTH_CAT_CODE |
|
|
APPR_CURCY_CD |
|
|
BUYER_FLG |
|
|
C_APPR_AUTH_CAT_CODE |
|
|
C_CITY_CODE |
|
|
C_COUNTRY_REGION_CODE |
|
|
C_COUNTY_CODE |
|
|
C_MAIL_CITY_CODE |
|
|
C_MAIL_COUNTRY_REGION_CODE |
|
|
C_MAIL_COUNTY_CODE |
|
|
C_MAIL_REGION_CODE |
|
|
C_MAIL_STATE_PROV_CODE |
|
|
C_REGION_CODE |
|
|
C_STATE_PROV_CODE |
|
|
C_WORK_CITY_CODE |
|
|
C_WORK_COUNTRY_REGION_CODE |
|
|
C_WORK_COUNTY_CODE |
|
|
C_WORK_REGION_CODE |
|
|
C_WORK_STATE_PROV_CODE |
|
|
CITY |
|
|
CONTACT_REP_FLG |
|
|
CONTACT_TYPE_CODE |
|
|
CONTINGENT_WORKER_NUM |
|
|
CONTRACT_END_DT |
|
|
CONTRACT_END_DT_WID |
|
|
CONTRACT_ST_DT |
|
|
CONTRACT_ST_DT_WID |
|
|
COUNTRY |
|
|
COUNTRY_REGION_CODE |
|
|
COUNTY |
|
|
DEPARTMENT_CODE |
|
|
EMAIL_ADDR |
|
|
EMP_ACCNT |
|
|
EMP_ACCNT_BU |
|
|
EMP_ACCNT_LOC |
|
|
EMP_ACTIVE_FLG |
|
|
EMP_FLG |
|
|
EMP_FORMED_DT |
|
|
EMP_HIRE_DT |
|
|
EMPLOYEE_NUM |
|
|
FAX_PH_NUM |
|
|
FST_NAME |
|
|
HELD_POSTN |
|
|
INDV_TITLE |
|
|
JOB_CATEGORY_CODE |
|
|
JOB_TITLE |
|
|
LAST_NAME |
|
|
LEGISLATION_CODE |
|
|
LOGIN |
|
|
MAIL_ADDR_EFF_DATE |
|
|
MAIL_ADDRESS_LINE_1 |
|
|
MAIL_ADDRESS_LINE_2 |
|
|
MAIL_ADDRESS_LINE_3 |
|
|
MAIL_ADDRESS_LINE_4 |
|
|
MAIL_CITY |
|
|
MAIL_COUNTRY |
|
|
MAIL_COUNTRY_REGION_CODE |
|
|
MAIL_COUNTY |
|
|
MAIL_POST_OFFICE_BOX |
|
|
MAIL_POST_OFFICE_BOX |
|
|
MAIL_REGION_CODE |
|
|
MAIL_STATE_PROV_CODE |
|
|
MAIL_ZIPCODE |
|
|
MANAGER_FLG |
|
|
MID_NAME |
|
|
MOBILE_NUM |
|
|
NAME_EFF_DATE |
|
|
NAME_PREFIX |
|
|
NAME_SUFFIX |
|
|
NATIVE_LANG_CODE |
|
|
ORIG_HIRE_DT |
|
|
ORIG_HIRE_DT_WID |
|
|
PAGER_NUM |
|
|
PAR_HELD_POSTN |
|
|
PAR_INTEGRATION_ID |
|
|
PARTY_ID |
|
|
POSITION_TYPE_CODE |
|
|
POST_OFFICE_BOX |
|
|
PR_POSTN |
|
|
PREV_LAST_NAME |
|
|
PROJ_MGR_FLG |
|
|
PURCHASE_REP_FLG |
|
|
REGION_CODE |
|
|
REQUESTOR_FLG |
|
|
SEC_FLU_LANG_CODE |
|
|
SERVICE_REP_FLG |
|
|
SPOUSE_NAME |
|
|
STATE_PROV_CODE |
|
|
SUPERVISOR_NAME |
|
|
SUPERVISOR_NUM |
|
|
THR_FLU_LANG_CODE |
|
|
U_DELPRI_EXCH_DT |
|
|
USER_FLG |
|
|
VIS_PR_BU_ID |
|
|
VIS_PR_POS_ID |
|
|
VIS_PR_POSTN_DH_WID |
|
|
W_COUNTRY_CODE |
|
|
WEB_ADDRESS |
|
|
WORK_ADDR_EFF_DATE |
|
|
WORK_ADDRESS_LINE_1 |
|
|
WORK_ADDRESS_LINE_2 |
|
|
WORK_ADDRESS_LINE_3 |
|
|
WORK_ADDRESS_LINE_4 |
|
|
WORK_CITY |
|
|
WORK_COUNTRY |
|
|
WORK_COUNTRY_REGION_CODE |
|
|
WORK_COUNTY |
|
|
WORK_PHONE |
|
|
WORK_POST_OFFICE_BOX |
|
|
WORK_REGION_CODE |
|
|
WORK_STATE_PROV_CODE |
|
|
WORK_ZIPCODE |
|
|
ZIPCODE |
|
|
W_PRODUCT_D |
APPLICATION_FLG |
|
BASE_UOM_CODE |
|
|
BODY_STYLE_CODE |
|
|
CASE_PACK |
|
|
CTLG_CAT_ID |
|
|
DEALER_INV_PRICE |
|
|
DETAIL_TYPE_CODE |
|
|
DISCONTINUATION_DT |
|
|
DOORS_TYPE_CODE |
|
|
DRIVE_TRAIN_CODE |
|
|
ENGINE_TYPE_CODE |
|
|
FUEL_TYPE_CODE |
|
|
GROSS_MRGN |
|
|
HAZARD_MTL_CODE |
|
|
INVENTORY_FLG |
|
|
ITEM_SIZE |
|
|
LEAD_TIME |
|
|
MAKE_CODE |
|
|
MODEL_CODE |
|
|
MODEL_YR |
|
|
MSRP |
|
|
MTBF |
|
|
MTTR |
|
|
ORDERABLE_FLG |
|
|
PAR_INTEGRATION_ID |
|
|
PART_NUM |
|
|
PROD_CAT10_AS_WAS |
|
|
PROD_CAT5_AS_WAS |
|
|
PROD_CAT6_AS_WAS |
|
|
PROD_CAT7_AS_WAS |
|
|
PROD_CAT8_AS_WAS |
|
|
PROD_CAT9_AS_WAS |
|
|
PROD_NDC_ID |
|
|
PROFIT_RANK_CODE |
|
|
R_TYPE_CODE |
|
|
REFERRAL_FLG |
|
|
RX_AVG_PRICE |
|
|
SALES_UOM_CODE |
|
|
SERIALIZED_COUNT |
|
|
SERVICE_TYPE_CODE |
|
|
SET_ID |
|
|
SHELF_LIFE |
|
|
SHIP_MTHD_GRP_CODE |
|
|
SHIP_MTL_GRP_CODE |
|
|
SHIP_TYPE_CODE |
|
|
SOURCE_OF_SUPPLY |
|
|
SPRT_WITHDRAWL_DT |
|
|
STATUS_CODE |
|
|
SUB_TYPE_CODE |
|
|
TGT_CUST_TYPE_CODE |
|
|
TRANSMISSION_CODE |
|
|
TRIM_CODE |
|
|
U_DEALER_INV_PRICE |
|
|
U_DELPRI_CURCY_CD |
|
|
U_MSRP |
|
|
U_MSRP_CURCY_CD |
|
|
U_MSRP_CURCY_CD |
|
|
U_MSRP_EXCH_DT |
|
|
U_RX_AVG_PRICE |
|
|
U_RXAVPR_CURCY_CD |
|
|
U_RXAVPR_EXCH_DT |
|
|
UNIT_CONV_FACTOR |
|
|
UNIT_GROSS_WEIGHT |
|
|
UNIT_NET_WEIGHT |
|
|
UNIT_VOLUME |
|
|
UNIV_PROD_CODE |
|
|
UOM_CODE |
|
|
UOV_CODE |
|
|
UOW_CODE |
|
|
VENDOR_LOC |
|
|
VENDOR_LOC1 |
|
|
VENDOR_LOC2 |
|
|
VENDOR_LOC3 |
|
|
VENDOR_NAME |
|
|
VENDR_PART_NUM |
|
|
VER_DT |
|
|
VER_DT1 |
|
|
VER_DT2 |
|
|
VER_DT3 |
|
|
W_PROD_CAT_DH |
|
|
FIXED_HIER_LEVEL |
|
|
BASE_LVL_PRODCAT_ID |
|
|
LVL1ANC_PRODCAT_ID |
|
|
LVL2ANC_PRODCAT_ID |
|
|
LVL3ANC_PRODCAT_ID |
|
|
HIERARCHY_CODE |
|
|
W_CATEGORY |
|
|
CREATED_BY_ID |
|
|
CHANGED_BY_ID |
|
|
CATALOG_CREATION_DATE |
|
|
HIERARCHY_TYPE_CODE |
|
|
FIXED_HIER_LEVEL |
|
|
BASE_LVL_PRODCAT_ID |
|
|
LVL1ANC_PRODCAT_ID |
|
|
LVL2ANC_PRODCAT_ID |
|
|
LVL3ANC_PRODCAT_ID |
|
|
HIERARCHY_CODE |
|
|
W_CATEGORY |
|
|
CREATED_BY_ID |
|
|
CHANGED_BY_ID |
|
|
CATALOG_CREATION_DATE |
|
|
LEVEL_NAME |
|
|
HIERARCHY_TYPE_CODE |
|
|
FINANCIAL_BU_FLG |
|
|
W_INT_ORG_D |
ASSET_ORG_FLG |
|
BALANCING_ENTITY_FLG |
|
|
BRANCH_FLG |
|
|
BU_FLG |
|
|
BUSINESS_AREA_FLG |
|
|
BUSINESS_GROUP_FLG |
|
|
C_CITY_CODE |
|
|
C_COUNTRY_REGION_CODE |
|
|
C_COUNTY_CODE |
|
|
C_STATE_PROV_CODE |
|
|
CNTCT_REP_ORG_FLG |
|
|
COLLECTIONS_BU_FLG |
|
|
COMPANY_FLG |
|
|
CONTRACT_BU_FLG |
|
|
CONTROL_AREA_FLG |
|
|
COST_ORG_FLG |
|
|
COUNTRY_REGION_CODE |
|
|
COUNTY_CODE |
|
|
CUSTOMER_PAYMENTS_BU_FLG |
|
|
DIVN_FLG |
|
|
EMAIL_ADDRESS |
|
|
ENTERPRISE_FLG |
|
|
EXPENDITURE_ORG_FLG |
|
|
EXPENSE_BU_FLG |
|
|
FAX_NUM |
|
|
FIN_AREA_FLG |
|
|
FINANCIAL_BU_FLG |
|
|
GOVT_REPT_ENTITY_FLG |
|
|
HR_ORG_FLG |
|
|
INTERNAL_FLG |
|
|
INV_ORG_FLG |
|
|
LEGAL_ENTITY_FLG |
|
|
MARKETING_ORG_FLG |
|
|
MATERIALS_MANAGEMENT_BU_FLG |
|
|
OPERATING_UNIT_FLG |
|
|
ORG_TYPE_CODE |
|
|
ORGANIZATION_CODE |
|
|
PAYABLES_ORG_FLG |
|
|
PAYROLL_STATUTORY_UNIT_FLG |
|
|
POSITION_DH_WID |
|
|
PR_ORG_TRGT_MKT |
|
|
PR_PTSHP_MKTSEG |
|
|
PRC_CONTRACT_MANAGEMENT_BU_FLG |
|
|
PROJECT_BU_FLG |
|
|
PROJECT_EXP_ORG_FLG |
|
|
PROJECT_ORG_FLG |
|
|
PROJECT_UNIT_FLG |
|
|
PRTNR_FLG |
|
|
PRTNR_SALES_RANK |
|
|
PRTNR_TIER_CODE |
|
|
PRTNR_TYPE_CODE |
|
|
PRTNRSHP_START_DT |
|
|
PTSHP_END_DT |
|
|
PTSHP_PRTNR_ACCNT |
|
|
PTSHP_RENEWAL_DT |
|
|
PTSHP_SAT_INDEX |
|
|
PTSHP_STAGE_CODE |
|
|
PURCH_ORG_FLG |
|
|
RECEIVABLES_ORG_FLG |
|
|
RECEIVING_BU_FLG |
|
|
REGISTRATION_NUM |
|
|
REPORTING_EST_FLG |
|
|
REQUISITION_BU_FLG |
|
|
RETAIL_FLG |
|
|
SALES_AREA_FLG |
|
|
SALES_GROUP_FLG |
|
|
SALES_ORG_FLG |
|
|
SCD1_WID |
|
|
SERVICE_ORG_FLG |
|
|
SET_ID |
|
|
VALUATION_AREA_FLG |
|
|
VIS_PR_BU_ID |
|
|
VIS_PR_POS_ID |
|
|
VIS_PRTNR_MGR_ID |
|
|
W_COUNTRY_CODE |
|
|
WEB_ADDRESS |
|
|
W_INT_ORG_DH |
ASSET_ORG_FLG |
|
BALANCING_ENTITY_FLG |
|
|
BASE_ORG_MGR |
|
|
BASE_ORG_NUM |
|
|
BRANCH_FLG |
|
|
BU_FLG |
|
|
BUSINESS_AREA_FLG |
|
|
BUSINESS_AREA_FLG |
|
|
BUSINESS_GROUP_FLG |
|
|
CNTCT_REP_ORG_FLG |
|
|
COLLECTIONS_BU_FLG |
|
|
COMPANY_FLG |
|
|
CONTRACT_BU_FLG |
|
|
CONTROL_AREA_FLG |
|
|
COST_ORG_FLG |
|
|
CUSTOMER_PAYMENTS_BU_FLG |
|
|
DIVN_FLG |
|
|
ENTERPRISE_FLG |
|
|
EXPENDITURE_ORG_FLG |
|
|
EXPENSE_BU_FLG |
|
|
FIN_AREA_FLG |
|
|
FINANCIAL_BU_FLG |
|
|
FIXED_HIER_LEVEL |
|
|
GOVT_REPT_ENTITY_FLG |
|
|
HIERARCHY_NAME |
|
|
HIERARCHY_VERSION |
|
|
HR_ORG_FLG |
|
|
INTERNAL_FLG |
|
|
INV_ORG_FLG |
|
|
LEGAL_ENTITY_FLG |
|
|
MARKETING_ORG_FLG |
|
|
MATERIALS_MANAGEMENT_BU_FLG |
|
|
OPERATING_UNIT_FLG |
|
|
ORG_HIER1_MGR |
|
|
ORG_HIER1_NUM |
|
|
ORG_HIER10_MGR |
|
|
ORG_HIER2_MGR |
|
|
ORG_HIER2_NUM |
|
|
ORG_HIER3_MGR |
|
|
ORG_HIER3_NUM |
|
|
ORG_HIER4_MGR |
|
|
ORG_HIER4_NUM |
|
|
ORG_HIER5_MGR |
|
|
ORG_HIER5_NUM |
|
|
ORG_HIER6_MGR |
|
|
ORG_HIER6_NUM |
|
|
ORG_HIER7_MGR |
|
|
ORG_HIER7_NUM |
|
|
ORG_HIER8_MGR |
|
|
ORG_HIER8_NUM |
|
|
ORG_HIER9_MGR |
|
|
ORG_TYPE_CODE |
|
|
PAYABLES_ORG_FLG |
|
|
PAYROLL_STATUTORY_UNIT_FLG |
|
|
PRC_CONTRACT_MANAGEMENT_BU_FLG |
|
|
PRIMARY_FLG |
|
|
PROJECT_BU_FLG |
|
|
PROJECT_EXP_ORG_FLG |
|
|
PROJECT_ORG_FLG |
|
|
PROJECT_UNIT_FLG |
|
|
PRTNR_FLG |
|
|
PURCH_ORG_FLG |
|
|
RECEIVABLES_ORG_FLG |
|
|
RECEIVING_BU_FLG |
|
|
REPORTING_EST_FLG |
|
|
REQUISITION_BU_FLG |
|
|
RETAIL_FLG |
|
|
SALES_AREA_FLG |
|
|
SALES_GROUP_FLG |
|
|
SALES_ORG_FLG |
|
|
SERVICE_ORG_FLG |
|
|
SET_ID |
|
|
TOP_ORG_MGR |
|
|
VALUATION_AREA_FLG |
|
|
W_HIERARCHY_CLASS |
|
|
W_XACT_TYPE_D |
ACTIVE_FLG |
|
W_XACT_CODE |
|
|
W_XACT_SUBTYPE_CODE |
|
|
W_XACT_TYPE_CODE1 |
|
|
W_XACT_TYPE_CODE2 |
|
|
XACT_SUBTYPE_CODE |
|
|
XACT_TYPE_CODE |
|
|
XACT_TYPE_CODE1 |
|
|
XACT_TYPE_CODE2 |
|
|
W_PARTY_ORG_D |
ACCNT_AHA_NUM |
|
ACCNT_FLG |
|
|
ACCNT_GEOSTATE_WID |
|
|
ACCNT_HIN_NUM |
|
|
ACCNT_LOC |
|
|
ACCNT_REGION |
|
|
ACTIVE_FLG |
|
|
AGENCY_FLG |
|
|
AGNC_CONTRACT_DT |
|
|
ALT_CUSTOMER_NUM |
|
|
ALT_PHONE_NUM |
|
|
ANNUAL_REVENUE |
|
|
ANNUAL_REVN_CAT_CODE |
|
|
AUX_CLASS_1_WID |
|
|
AUX_CLASS_2_WID |
|
|
AUX_CLASS_3_WID |
|
|
BOOK_VALUE |
|
|
BRANCH_FLG |
|
|
BU_NAME |
|
|
C_CITY_CODE |
|
|
C_CONTINENT_CODE |
|
|
C_COUNTRY_REGION_CODE |
|
|
C_COUNTY_CODE |
|
|
C_REGION_CODE |
|
|
C_STATE_PROV_CODE |
|
|
CALL_FREQUENCY |
|
|
CHANNEL_FLG |
|
|
CHNL_ANNL_SALES |
|
|
CHNL_SALES_GRWTH_CODE |
|
|
CITY_CODE |
|
|
CLIENT_FLG |
|
|
COMPETITOR_FLG |
|
|
COUNTRY_CODE |
|
|
CREATED_BY_WID |
|
|
CREATED_ON_DT |
|
|
CREDIT_SCORE |
|
|
CRIME_TYPE_CODE |
|
|
CURR_ASSET |
|
|
CURR_LIAB |
|
|
CURRENT_FLG |
|
|
CUST_CAT_CODE |
|
|
CUST_CLASS_CODE |
|
|
CUST_END_DT |
|
|
CUST_SINCE_DT |
|
|
CUST_STATUS_CODE |
|
|
CUST_TYPE_CODE |
|
|
CUST_VALUE_CODE |
|
|
CUSTOMER_NUM |
|
|
DB_RATING |
|
|
DIRECT_MKTG_FLG |
|
|
DIVIDEND |
|
|
DIVN_FLG |
|
|
DIVN_TYPE_CODE |
|
|
DOM_ULT_DUNS_NUM |
|
|
DUNNS_GLOBAL_NAME |
|
|
DUNNS_LEGAL_NAME |
|
|
DUNNS_SITE_NAME |
|
|
DUNS_NUM |
|
|
EMAIL_ADDRESS |
|
|
EMP_COUNT |
|
|
EXCHANGE_LOC |
|
|
EXIST_SALES_ACCNT_FLG |
|
|
EXPERTISE_CODE |
|
|
FACILITY_FLG |
|
|
FACILITY_TYPE_CODE |
|
|
FIFTYTWO_HIGH |
|
|
FIFTYTWO_LOW |
|
|
FIN_METHOD_CODE |
|
|
FORMED_DT |
|
|
FRGHT_TERMS_CODE |
|
|
GEO_WID |
|
|
GLBLULT_DUNS_NUM |
|
|
GOVT_ID_TYPE |
|
|
GOVT_ID_VALUE |
|
|
GROSS_PROFIT |
|
|
GROWTH_HORIZ_CODE |
|
|
GROWTH_OBJ_CODE |
|
|
GROWTH_PERCNTG |
|
|
HIST_SLS_VOL |
|
|
HUB_ZONE_FLG |
|
|
IDENTIFIED_DT |
|
|
INDUSTRY_WID |
|
|
INTERNAL_FLG |
|
|
INTERNET_HOME_PAGE |
|
|
INVESTOR_FLG |
|
|
KEY_COMPETITOR |
|
|
LEGAL_FORM_CODE |
|
|
LEGAL_STRUCT_CODE |
|
|
LINE_OF_BUSINESS |
|
|
LOYAL_SCORE1 |
|
|
LOYAL_SCORE2 |
|
|
LOYAL_SCORE3 |
|
|
LOYAL_SCORE4 |
|
|
LOYAL_SCORE5 |
|
|
LOYAL_SCORE6 |
|
|
LOYAL_SCORE7 |
|
|
MAIN_PH_NUM |
|
|
MARGIN_VS_INDUST_CODE |
|
|
MARKET_CLASS_CODE |
|
|
MARKET_TYPE_CODE |
|
|
MED_PROC |
|
|
MEMBER_NUM |
|
|
MINORITY_GROUP_CODE |
|
|
MINORITY_OWNED_IND |
|
|
MKT_POTENTIAL |
|
|
MRKT_CAP_PREF_CODE |
|
|
NET_INCOME |
|
|
NON_CASH_EXP |
|
|
NUM_EMPLOY_CAT_CODE |
|
|
NUMB_OF_BEDS |
|
|
OBJECTIVE_CODE |
|
|
OOB_IND |
|
|
OPER_INCOME |
|
|
ORG_FLG |
|
|
ORG_PRTNR_FLG |
|
|
ORG_PRTNR_TIER_CODE |
|
|
ORG_PRTNR_TYPE_CODE |
|
|
ORG_SIZE_CODE |
|
|
ORG_TERR_NAME |
|
|
ORG_TYPE_WID |
|
|
PAR_DUNS_NUM |
|
|
PAR_INTEGRATION_ID |
|
|
PAR_ORG_NAME |
|
|
PARENT_SUPPLIER_ID |
|
|
PERSIST_RATIO |
|
|
POSTAL_CODE |
|
|
PR_COMPETITOR |
|
|
PR_INDUST_NAME |
|
|
PR_ORG_TRGT_MKT |
|
|
PR_PTSHP_MKTSEG |
|
|
PR_SPEC_NAME |
|
|
PR_SYN_ID |
|
|
PREF_ORDER_METHOD |
|
|
PRI_CONTACT_NAME |
|
|
PRI_CONTACT_PHONE_NUM |
|
|
PRI_LST_NAME |
|
|
PRIM_MARKET_CODE |
|
|
PRIMARY_PHONE_AREA_CODE |
|
|
PROJ_EPS |
|
|
PROSPECT_FLG |
|
|
PRTNR_FLG |
|
|
PRTNR_NAME |
|
|
PRTNR_SALES_RANK |
|
|
PRTNRSHP_START_DT |
|
|
PTNTL_SLS_VOL |
|
|
PTSHP_END_DT |
|
|
PTSHP_FEE_PAID_FLG |
|
|
PTSHP_PRTNR_ACCNT |
|
|
PTSHP_RENEWAL_DT |
|
|
PTSHP_SAT_INDEX |
|
|
PTSHP_STAGE_CODE |
|
|
PUBLIC_LISTING_FLG |
|
|
QUICK_RATIO |
|
|
REGION_CODE |
|
|
REVN_GROWTH_CAT_CODE |
|
|
SALES_ACCNT_FLG |
|
|
SALES_ACCNT_TYPE_CODE |
|
|
SALES_ACCT_SINCE_DT |
|
|
SALES_EMP_CNT |
|
|
SALES_REF_FLG |
|
|
SERVICE_EMP_CNT |
|
|
SETID_CUSTOMER |
|
|
SETID_VENDOR |
|
|
SHARE_OUTST |
|
|
SIC_CODE |
|
|
SMALL_BUS_IND |
|
|
SOLICITATION_FLG |
|
|
SRV_PROVDR_FLG |
|
|
ST_ADDRESS1 |
|
|
ST_ADDRESS2 |
|
|
ST_ADDRESS3 |
|
|
ST_ADDRESS4 |
|
|
STAT_REASON_CODE |
|
|
STATE_PROV_CODE |
|
|
SUPPLIER_CONTACT_NAME |
|
|
SUPPLIER_EXT_NETWORK_ID |
|
|
SUPPLIER_FLG |
|
|
SUPPLIER_GROUP_CODE |
|
|
SUPPLIER_ID |
|
|
SUPPLIER_NUM |
|
|
SUPPLIER_ONE_TIME_FLG |
|
|
SUPPLIER_SEARCH_STR |
|
|
SUPPLIER_SINCE_DT |
|
|
SUPPLIER_TYPE_CODE |
|
|
TAX_REFERENCE |
|
|
TICKER |
|
|
TOT_ASSET |
|
|
TOT_LIABILITY |
|
|
TOTAL_DEBT |
|
|
TOTAL_NET_WORTH |
|
|
TRAIL_EPS |
|
|
VET_OWNED_FLG |
|
|
VIS_PR_BU_ID |
|
|
VIS_PR_POS_ID |
|
|
VIS_PR_POSTN_DH_WID |
|
|
VOLUME_TR |
|
|
W_COUNTRY_CODE |
|
|
WOMAN_OWNED_IND |
|
|
YR_ESTABLISHED |
|
|
W_MINUTE_OF_DAY_D |
FROM_TIME_OF_DAY_WID |
|
TO_TIME_OF_DAY_WID |
|
|
HH12MI_STR |
|
|
HH24MI_STR |
|
|
HALF_HOUR_NUM |
|
|
QTR_HOUR_NUM |
|
|
TIME_SESSION |
