This appendix covers the following topics:
The seeded parent data sources are:
Person: Represents Business to Consumer (B2C) customer attributes such as first name, last name, marital status, household income, etc.
Organization Contacts: Represents Business to Business (B2B) attributes such as first name, last name, job title, work e-mail address, etc.
Organization: Represents organization attributes such as company name, business type, revenue, etc.
The following table describes parent-child relationships for each of the seeded data sources.
Parent Data Source | Child Data Sources |
---|---|
Persons |
|
Organization Contacts |
|
Organization |
|
The following table lists seeded data source attributes, the tables or logic from which attribute values are derived, and the name of the data source(s) that use the attribute.
Attribute | Source | Data Source Name(s) |
---|---|---|
ACCOUNT_ACTIVATION_DATE | HZ_CUST_ACCOUNTS | Account |
ACCOUNT_ESTABLISHED_DATE | HZ_CUST_ACCOUNTS | Account |
ACCOUNT_LIABLE_FLAG | HZ_CUST_ACCOUNTS | Account |
ACCOUNT_NAME | HZ_CUST_ACCOUNTS | Account |
ACCOUNT_NUMBER | HZ_CUST_ACCOUNTS | Account |
ACCOUNT_TERMINATION_DATE | HZ_CUST_ACCOUNTS | Account |
ACCT_LIFE_CYCLE_STATUS | HZ_CUST_ACCOUNTS | Account |
AUTOPAY_FLAG | HZ_CUST_ACCOUNTS | Account |
COMPETITOR_TYPE | HZ_CUST_ACCOUNTS | Account |
COTERMINATE_DAY_MONTH | HZ_CUST_ACCOUNTS | Account |
CREDIT_CLASSIFICATION_CODE | HZ_CUST_ACCOUNTS | Account |
CURRENT_BALANCE | HZ_CUST_ACCOUNTS | Account |
CUST_ACCOUNT_ID | HZ_CUST_ACCOUNTS | Account |
CUSTOMER_CLASS_CODE | HZ_CUST_ACCOUNTS | Account |
CUSTOMER_TYPE | HZ_CUST_ACCOUNTS | Account |
DATE_TYPE_PREFERENCE | HZ_CUST_ACCOUNTS | Account |
DATES_NEGATIVE_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
DATES_POSITIVE_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
DEPARTMENT | HZ_CUST_ACCOUNTS | Account |
DEPOSIT_REFUND_METHOD | HZ_CUST_ACCOUNTS | Account |
DORMANT_ACCOUNT_FLAG | HZ_CUST_ACCOUNTS | Account |
FOB_POINT | HZ_CUST_ACCOUNTS | Account |
FREIGHT_TERM | HZ_CUST_ACCOUNTS | Account |
HELD_BILL_EXPIRATION_DATE | HZ_CUST_ACCOUNTS | Account |
HIGH_PRIORITY_INDICATOR | HZ_CUST_ACCOUNTS | Account |
HOLD_BILL_FLAG | HZ_CUST_ACCOUNTS | Account |
HOTWATCH_SERVICE_FLAG | HZ_CUST_ACCOUNTS | Account |
HOTWATCH_SVC_BAL_IND | HZ_CUST_ACCOUNTS | Account |
ITEM_CROSS_REF_PREF | HZ_CUST_ACCOUNTS | Account |
MAJOR_ACCOUNT_NUMBER | HZ_CUST_ACCOUNTS | Account |
NOTIFY_FLAG | HZ_CUST_ACCOUNTS | Account |
NPA_NUMBER | HZ_CUST_ACCOUNTS | Account |
ORIG_SYSTEM_REFERENCE | HZ_CUST_ACCOUNTS | Account |
OVER_RETURN_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
OVER_SHIPMENT_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
PAYMENT_TERM_ID | HZ_CUST_ACCOUNTS | Account |
PERSON_NAME_SUFFIX | HZ_CUST_ACCOUNTS | Account |
PO_EFFECTIVE_DATE | HZ_CUST_ACCOUNTS | Account |
PO_EXPIRATION_DATE | HZ_CUST_ACCOUNTS | Account |
POSTAL_CODE | HZ_CUST_ACCOUNTS | Account |
PRICING_EVENT | HZ_CUST_ACCOUNTS | Account |
PRIMARY_SALESREP_ID | HZ_CUST_ACCOUNTS | Account |
PRIMARY_SPECIALIST_ID | HZ_CUST_ACCOUNTS | Account |
REALTIME_RATE_FLAG | HZ_CUST_ACCOUNTS | Account |
RESTRICTION_LIMIT_AMOUNT | HZ_CUST_ACCOUNTS | Account |
SALES_CHANNEL_CODE | HZ_CUST_ACCOUNTS | Account |
SECONDARY_SPECIALIST_ID | HZ_CUST_ACCOUNTS | Account |
SHIP_PARTIAL | HZ_CUST_ACCOUNTS | Account |
SHIP_VIA | HZ_CUST_ACCOUNTS | Account |
SINGLE_USER_FLAG | HZ_CUST_ACCOUNTS | Account |
SOURCE_CODE | HZ_CUST_ACCOUNTS | Account |
STATUS | HZ_CUST_ACCOUNTS | Account |
STATUS_UPDATE_DATE | HZ_CUST_ACCOUNTS | Account |
SUSPENSION_DATE | HZ_CUST_ACCOUNTS | Account |
TAX_CODE | HZ_CUST_ACCOUNTS | Account |
TAX_HEADER_LEVEL_FLAG | HZ_CUST_ACCOUNTS | Account |
TAX_ROUNDING_RULE | HZ_CUST_ACCOUNTS | Account |
UNDER_RETURN_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
UNDER_SHIPMENT_TOLERANCE | HZ_CUST_ACCOUNTS | Account |
WATCH_ACCOUNT_FLAG | HZ_CUST_ACCOUNTS | Account |
WATCH_BALANCE_INDICATOR | HZ_CUST_ACCOUNTS | Account |
WRITE_OFF_ADJUSTMENT_AMOUNT | HZ_CUST_ACCOUNTS | Account |
WRITE_OFF_AMOUNT | HZ_CUST_ACCOUNTS | Account |
WRITE_OFF_PAYMENT_AMOUNT | HZ_CUST_ACCOUNTS | Account |
ACCOUNT_RECEIVABLE | HZ_FINANCIAL_NUMBERS. (FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘ACCOUNTS_RECEIVABLE') | Data Mining Aggregates |
AVG_CALL_LENGTH | BIC_PARTY_SUMM | Data Mining Aggregates |
AVG_CLOSED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
AVG_COMPLAINTS | BIC_PARTY_SUMM | Data Mining Aggregates |
AVG_DISC_OFFERED | Derived using AMS_ACT_OFFERS and AMS_CAMPAIGN_SCHEDULES_VL fields | Data Mining Aggregates |
AVG_HOLD_TIME | BIC_PARTY_SUMM | Data Mining Aggregates |
AVG_LEN_OF_EMP | BIC_PARTY_SUMM | Data Mining Aggregates |
AVG_ORDER_AMOUNT | BIC_PARTY_SUMM. ORDER_AMT divided by ORDER_NUM | Data Mining Aggregates |
AVG_RESOLVE_DAYS_1_MONTH | BIC_PARTY_SUMM.AVG_SR_RESL_TIME | Data Mining Aggregates |
AVG_RESOLVE_DAYS_3_MONTHS | BIC_PARTY_SUMM. AVG_SR_RESL_TIME over the last 3 months | Data Mining Aggregates |
AVG_RESOLVE_DAYS_6_MONTHS | BIC_PARTY_SUMM. AVG_SR_RESL_TIME over the last 6 months | Data Mining Aggregates |
AVG_RESOLVE_DAYS_YEAR | BIC_PARTY_SUMM. AVG_SR_RESL_TIME over the past year | Data Mining Aggregates |
AVG_TALK_TIME | BIC_PARTY_SUMM. AVG_TALK_TIME | Data Mining Aggregates |
AVG_TRANSFERS_PER_SR | BIC_PARTY_SUMM | Data Mining Aggregates |
AVG_UNITS_PER_ORDER | BIC_PARTY_SUMM. ORDER_QTY divided by ORDER_NUM | Data Mining Aggregates |
AVG_WORKLOAD | BIC_PARTY_SUMM | Data Mining Aggregates |
CAPITAL_AMOUNT | "HZ_FINANCIAL_NUMBERS.[FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME IN (‘ISSUED_CAPITAL', ‘PAID_IN_CAPITAL' ‘NOMINAL_CAPITAL', ‘AUTHORIZED_CAPITAL')]" | Data Mining Aggregates |
CAPITAL_TYPE_INDICATOR | HZ_FINANCIAL_NUMBERS.FINANCIAL_NUMBER_NAME (where FINANCIAL_NUMBER_NAME in (‘ISSUED_CAPITAL' , ‘PAID_IN_CAPITAL', ‘NOMINAL_CAPITAL', ‘AUTHORIZED_CAPITAL')) | Data Mining Aggregates |
CLOSED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
COGS | BIC_PARTY_SUMM | Data Mining Aggregates |
CONTRACT_AMT | BIC_PARTY_SUMM | Data Mining Aggregates |
CONTRACT_DURATION | BIC_PARTY_SUMM | Data Mining Aggregates |
CONTRACTS_CUML | BIC_PARTY_SUMM | Data Mining Aggregates |
CURRENT_ASSETS | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘TOTAL_CURRENT_ASSETS') | Data Mining Aggregates |
CURRENT_LIABILITIES | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘TOTAL_CURR_LIABILITIES') | Data Mining Aggregates |
DAYS_SINCE_FIRST_CONTACT | Derived using MIN (AMS_LIST_HEADERS_VL. SENT_OUT_DATE) where SENT_OUT_DATE is not Null and AMS_LIST_ENTRIES fields | Data Mining Aggregates |
DAYS_SINCE_LAST_EVENT | MAX (AMS_EVENT_OFFERS_VL.EVENT_START_DATE) where PARTY_ID in (AMS_EVENT_REGISTRATIONS.ATTENDANT_PARTY_ID) | Data Mining Aggregates |
DAYS_SINCE_LAST_TARGETED | Derived using MAX (AMS_LIST_HEADERS_VL. SENT_OUT_DATE) where party in AMS_LIST_ENTRIES. PARTY_ID | Data Mining Aggregates |
DEBT_TO_INCOME_RATIO | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY Where FINANCIAL_NUMBER_NAME = ‘LONG_TERM_DEBT') | Data Mining Aggregates |
ESCALATED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
FIRST_CALL_CL_RATE | BIC_PARTY_SUMM | Data Mining Aggregates |
GROSS_ANNUAL_INCOME | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘GROSS_INCOME') | Data Mining Aggregates |
GROSS_ANNUAL_SALES | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘SALES') | Data Mining Aggregates |
HZ_PARTY_SITE_USES.BEGIN_DATE and END_DATE for SITE_USE_TYPE = RESIDES_AT | HZ_PARTY_SITE_USES | Data Mining Aggregates |
INACTIVE_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
LAST_TARGETED_CHANNEL_CODE | Derived using AMS_CAMPAIGN_SCHEDULES_VL AMS_LIST_HEADERS_VL and AMS_LIST_ENTRIES fields | Data Mining Aggregates |
NET_PROFIT | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME=‘PROFIT_BEFORE_TAX') | Data Mining Aggregates |
NET_WORTH | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘NET_WORTH') | Data Mining Aggregates |
NEW_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
NUM_OF_COMPLAINTS | BIC_PARTY_SUMM | Data Mining Aggregates |
NUM_OF_INTERACTIONS | BIC_PARTY_SUMM | Data Mining Aggregates |
NUM_OF_SR_1_MONTH | BIC_PARTY_SUMM. SRS_LOGGED | Data Mining Aggregates |
NUM_OF_SR_3_MONTHS | SUM (BIC_PARTY_SUMM. SRS_LOGGED) over the last 3 months | Data Mining Aggregates |
NUM_OF_SR_6_MONTHS | SUM (BIC_PARTY_SUMM. SRS_LOGGED) over the last 6 months | Data Mining Aggregates |
NUM_OF_SR_YEAR | SUM (BIC_PARTY_SUMM. SRS_LOGGED) over the past year | Data Mining Aggregates |
NUM_OF_TRANSFERS | BIC_PARTY_SUMM | Data Mining Aggregates |
NUM_TGT_BY_OFFR_TYP1 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
NUM_TGT_BY_OFFR_TYP2 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
NUM_TGT_BY_OFFR_TYP3 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
NUM_TGT_BY_OFFR_TYP4 | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_ACT_OFFERS | Data Mining Aggregates |
NUM_TIMES_TARGETED | AMS_LIST_HEADERS_VL.SENT_OUT_DATE is not Null AND party is in AMS_LIST_ENTRIES. PARTY_ID | Data Mining Aggregates |
NUM_TIMES_TARGETED_DIRECT | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_MEDIA_VL | Data Mining Aggregates |
NUM_TIMES_TARGETED_EMAIL | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_MEDIA_VL | Data Mining Aggregates |
NUM_TIMES_TARGETED_TELEMKT | Derived using AMS_LIST_ENTRIES AMS_LIST_HEADERS_ALL AMS_CAMPAIGN_SCHEDULES_B AMS_MEDIA_VL | Data Mining Aggregates |
NUM_TYPES_DISC_OFFERED | Derived using AMS_ACT_OFFERS And AMS_CAMPAIGN_SCHEDULES_VL fields | Data Mining Aggregates |
ONTIME_PAYMENTS | BIC_PARTY_SUMM | Data Mining Aggregates |
ONTIME_SHIP_PCT | BIC_PARTY_SUMM | Data Mining Aggregates |
OPEN_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
OPEN_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
ORDER_LINES_DELIVERED | BIC_PARTY_SUMM | Data Mining Aggregates |
ORDER_LINES_ONTIME | BIC_PARTY_SUMM | Data Mining Aggregates |
ORDER_QTY_CUML | BIC_PARTY_SUMM | Data Mining Aggregates |
ORDER_RECENCY | BIC_PARTY_SUMM | Data Mining Aggregates |
PARTY_ID | -- | Data Mining Aggregates |
PAYMENTS | BIC_PARTY_SUMM | Data Mining Aggregates |
PERCT_CALL_REWORK | BIC_PARTY_SUMM | Data Mining Aggregates |
PRODUCTS | BIC_PARTY_SUMM | Data Mining Aggregates |
REFERALS | BIC_PARTY_SUMM | Data Mining Aggregates |
RENEWED_CONTRACTS | BIC_PARTY_SUMM | Data Mining Aggregates |
REOPENED_SRS | BIC_PARTY_SUMM | Data Mining Aggregates |
RETAINED_EARNINGS | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘RETAINED_EARNINGS') | Data Mining Aggregates |
RETURN_BY_VALUE | BIC_PARTY_SUMM | Data Mining Aggregates |
RETURN_BY_VALUE_PCT | BIC_PARTY_SUMM | Data Mining Aggregates |
RETURNS | BIC_PARTY_SUMM | Data Mining Aggregates |
SALES | BIC_PARTY_SUMM | Data Mining Aggregates |
TIMES_TARGETED_12_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last year | Data Mining Aggregates |
TIMES_TARGETED_3_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last 3 months | Data Mining Aggregates |
TIMES_TARGETED_6_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last 6 months | Data Mining Aggregates |
TIMES_TARGETED_9_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last 9 months | Data Mining Aggregates |
TIMES_TARGETED_MONTH | Derived using AMS_LIST_HEADERS_VL. SENT_OUT_DATE (if not Null) and party in AMS_LIST_ENTRIES. PARTY_ID for last month | Data Mining Aggregates |
TOT_CALLS | BIC_PARTY_SUMM | Data Mining Aggregates |
TOT_NUM_ORDER_3_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past 3 months | Data Mining Aggregates |
TOT_NUM_ORDER_6_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past 6 months | Data Mining Aggregates |
TOT_NUM_ORDER_9_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past 9 months | Data Mining Aggregates |
TOT_NUM_ORDER_YEAR | SUM (BIC_PARTY_SUMM.ORDER_QTY) over the past year | Data Mining Aggregates |
TOT_ORDER_AMOUNT_3_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past 3 months | Data Mining Aggregates |
TOT_ORDER_AMOUNT_6_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past 6 months | Data Mining Aggregates |
TOT_ORDER_AMOUNT_9_MONTHS | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past 9 months | Data Mining Aggregates |
TOT_ORDER_AMOUNT_YEAR | SUM (BIC_PARTY_SUMM.ORDER_AMT) over the past year | Data Mining Aggregates |
TOTAL_ASSETS | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘TOTAL_ASSETS') | Data Mining Aggregates |
TOTAL_DEBT_OUTSTANDING | HZ_FINANCIAL_NUMBERS.(FINANCIAL_NUMBER and FINANCIAL_NUMBER_CURRENCY where FINANCIAL_NUMBER_NAME = ‘LONG_TERM_DEBT') | Data Mining Aggregates |
TOTAL_SR_RESPONSE_TIME | BIC_PARTY_SUMM | Data Mining Aggregates |
ARC_USED_FOR_OBJECT | AMS_DM_SOURCE | Data Mining Scores |
CONTINUOUS_SCORE | AMS_DM_SOURCE | Data Mining Scores |
CREATED_BY | ams_dm_scores_all_b | Data Mining Scores |
CREATION_DATE | ams_dm_scores_all_b | Data Mining Scores |
DECILE | AMS_DM_SOURCE | Data Mining Scores |
LAST_UPDATE_DATE | ams_dm_scores_all_b | Data Mining Scores |
LAST_UPDATE_LOGIN | ams_dm_scores_all_b | Data Mining Scores |
LAST_UPDATED_BY | ams_dm_scores_all_b | Data Mining Scores |
MODEL_ID | ams_dm_scores_all_b | Data Mining Scores |
MODEL_NAME | ams_dm_models_all_tl | Data Mining Scores |
MODEL_TYPE | ams_dm_scores_all_tl | Data Mining Scores |
PARTY_ID | AMS_DM_SOURCE | Data Mining Scores |
SCORE_ID | ams_dm_scores_all_b | Data Mining Scores |
SCORE_NAME | ams_dm_scores_all_tl | Data Mining Scores |
USED_FOR_OBJECT_ID | AMS_DM_SOURCE | Data Mining Scores |
BEGIN_DATE | HZ_EMPLOYMENT_HISTORY | Employment History |
BRANCH | HZ_EMPLOYMENT_HISTORY | Employment History |
EMPLOYED_AS_TITLE | HZ_EMPLOYMENT_HISTORY | Employment History |
EMPLOYED_BY_DIVISION_NAME | HZ_EMPLOYMENT_HISTORY | Employment History |
EMPLOYED_BY_NAME_COMPANY | HZ_EMPLOYMENT_HISTORY | Employment History |
EMPLOYMENT_HISTORY_ID | HZ_EMPLOYMENT_HISTORY | Employment History |
END_DATE | HZ_EMPLOYMENT_HISTORY | Employment History |
MILITARY_RANK | HZ_EMPLOYMENT_HISTORY | Employment History |
PARTY_ID | HZ_EMPLOYMENT_HISTORY | Employment History |
RESPONSIBILITY | HZ_EMPLOYMENT_HISTORY | Employment History |
SERVED | HZ_EMPLOYMENT_HISTORY | Employment History |
STATION | HZ_EMPLOYMENT_HISTORY | Employment History |
SUPERVISOR_NAME | HZ_EMPLOYMENT_HISTORY | Employment History |
ACTIVE_END_DATE | CSI_ITEM_INSTANCES | Install Base Details |
ACTIVE_START_DATE | CSI_ITEM_INSTANCES | Install Base Details |
ACTUAL_RETURN_DATE | CSI_ITEM_INSTANCES | Install Base Details |
CATEGORY_DESC | CSI_ITEM_INSTANCES | Install Base Details |
CITY | CSI_ITEM_INSTANCES | Install Base Details |
COMPLETENESS_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
CONCAT_CAT_PARENTAGE | CSI_ITEM_INSTANCES | Install Base Details |
CONCATENATED_SEGMENTS | CSI_ITEM_INSTANCES | Install Base Details |
CONTEXT | CSI_ITEM_INSTANCES | Install Base Details |
COUNTRY | CSI_ITEM_INSTANCES | Install Base Details |
COUNTY | CSI_ITEM_INSTANCES | Install Base Details |
CREATED_BY | CSI_ITEM_INSTANCES | Install Base Details |
CREATION_COMPLETE_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
CREATION_DATE | CSI_ITEM_INSTANCES | Install Base Details |
DESCRIPTION | CSI_ITEM_INSTANCES | Install Base Details |
INSTALL_DATE | CSI_ITEM_INSTANCES | Install Base Details |
INSTANCE_DESCRIPTION | CSI_ITEM_INSTANCES | Install Base Details |
INSTANCE_ID | CSI_ITEM_INSTANCES | Install Base Details |
INSTANCE_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
INSTANCE_STATUS_ID | CSI_ITEM_INSTANCES | Install Base Details |
INSTANCE_USAGE_MEANING | CSI_ITEM_INSTANCES | Install Base Details |
INV_MASTER_ORGANIZATION_ID | CSI_ITEM_INSTANCES | Install Base Details |
INV_ORGANIZATION_ID | CSI_ITEM_INSTANCES | Install Base Details |
INVENTORY_ITEM_ID | CSI_ITEM_INSTANCES | Install Base Details |
ITEM_DESCRIPTION | CSI_ITEM_INSTANCES | Install Base Details |
ITEM_TYPE | CSI_ITEM_INSTANCES | Install Base Details |
LAST_CUST_PO_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
LAST_HEADER_ID | CSI_ITEM_INSTANCES | Install Base Details |
LAST_LINE_ID | CSI_ITEM_INSTANCES | Install Base Details |
LAST_LINE_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
LAST_OE_ORDER_LINE_ID | CSI_ITEM_INSTANCES | Install Base Details |
LAST_ORDER_NUMBER | CSI_ITEM_INSTANCES | Install Base Details |
LOCATION_ID | CSI_ITEM_INSTANCES | Install Base Details |
LOCATION_TYPE_CODE | CSI_ITEM_INSTANCES | Install Base Details |
LOT_CONTROL_CODE | CSI_ITEM_INSTANCES | Install Base Details |
MANUALLY_CREATED_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
NAME | CSI_ITEM_INSTANCES | Install Base Details |
OWNER_PARTY_ACCOUNT_ID | CSI_ITEM_INSTANCES | Install Base Details |
OWNER_PARTY_ID | CSI_ITEM_INSTANCES | Install Base Details |
PADDED_CONCATENATED_SEGMENTS | CSI_ITEM_INSTANCES | Install Base Details |
POSTAL_CODE | CSI_ITEM_INSTANCES | Install Base Details |
PROVINCE | CSI_ITEM_INSTANCES | Install Base Details |
QUANTITY | CSI_ITEM_INSTANCES | Install Base Details |
RETURN_BY_DATE | CSI_ITEM_INSTANCES | Install Base Details |
SERIAL_NUMBER_CONTROL_CODE | CSI_ITEM_INSTANCES | Install Base Details |
SHIPPED_DATE | CSI_ITEM_INSTANCES | Install Base Details |
STATE | CSI_ITEM_INSTANCES | Install Base Details |
TERMINATED_FLAG | CSI_ITEM_INSTANCES | Install Base Details |
UNIT_OF_MEASURE | CSI_ITEM_INSTANCES | Install Base Details |
ACTION | JTF_IH_ACTIONS_TL | Interactions |
ACTION_ID | JTF_IH_ACTIVITIES | Interactions |
ACTION_ITEM | JTF_IH_ACTION_ITEMS_TL | Interactions |
ACTION_ITEM_ID | JTF_IH_ACTIVITIES | Interactions |
ACTIVE | JTF_IH_ACTIVITIES | Interactions |
ACTIVITY | JTF_IH_ACTION_ITEMS_TL | Interactions |
ACTIVITY_ID | JTF_IH_ACTIVITIES | Interactions |
CREATION_DATE | JTF_IH_ACTIVITIES | Interactions |
CUST_ACCOUNT_ID | JTF_IH_INTERACTIONS | Interactions |
DIRECTION | JTF_IH_ACTIVITIES | Interactions |
DOC_ID | JTF_IH_MEDIA_ITEMS | Interactions |
DOC_REF | JTF_IH_ACTIVITIES | Interactions |
END_DATE_TIME | JTF_IH_ACTIVITIES | Interactions |
HANDLER_ID | JTF_IH_ACTIVITIES | Interactions |
INTERACTION_ID | JTF_IH_INTERACTIONS | Interactions |
MEDIA_ID | JTF_IH_ACTIVITIES | Interactions |
MEDIA_ITEM_TYPE | JTF_IH_ACTIVITIES | Interactions |
OBJECT_ID | JTF_IH_MEDIA_ITEMS | Interactions |
OUTCOME_CODE | JTF_IH_ACTIVITIES | Interactions |
OUTCOME_DESCRIPTION | JTF_IH_OUTCOMES_TL | Interactions |
OUTCOME_ID | JTF_IH_ACTIVITIES | Interactions |
PARTY_ID | JTF_IH_INTERACTIONS | Interactions |
POSITIVE_RESPONSE_FLAG | JTF_IH_RESULTS_TL | Interactions |
REASON_CODE | JTF_IH_REASONS_TL | Interactions |
REASON_DESCRIPTION | JTF_IH_ACTIVITIES | Interactions |
REASON_ID | JTF_IH_INTERACTIONS | Interactions |
RESOURCE_ID | JTF_IH_RESULTS_TL | Interactions |
RESULT_CODE | JTF_IH_ACTIVITIES | Interactions |
RESULT_DESCRIPTION | JTF_IH_ACTIVITIES | Interactions |
RESULT_ID | JTF_IH_OUTCOMES_TL | Interactions |
SCRIPT_ID | JTF_IH_REASONS_TL | Interactions |
SCRIPT_TRANS_ID | JTF_IH_RESULTS_TL | Interactions |
SOURCE_CODE | JTF_IH_ACTIVITIES | Interactions |
SOURCE_CODE_ID | JTF_IH_ACTIVITIES | Interactions |
START_DATE_TIME | JTF_IH_ACTIVITIES | Interactions |
PARTY_NAME | HZ_PARTIES | Interactions, Organization, and Person |
ACCEPT_FLAG | AS_SALES_LEADS | Leads |
ADDRESS_ID | AS_SALES_LEADS | Leads |
ASSIGN_SALES_GROUP_ID | AS_SALES_LEADS | Leads |
ASSIGN_TO_PERSON_ID | AS_SALES_LEADS | Leads |
ASSIGN_TO_SALESFORCE_ID | AS_SALES_LEADS | Leads |
BUDGET_AMOUNT | AS_SALES_LEADS | Leads |
BUDGET_STATUS | AS_LOOKUPS | Leads |
BUDGET_STATUS_CODE | AS_SALES_LEADS | Leads |
CATEGORY_ID | AS_SALES_LEAD_LINES | Leads |
CATEGORY_SET_ID | AS_SALES_LEAD_LINES | Leads |
CHANNEL_CODE | AS_SALES_LEADS | Leads |
CLOSE_REASON | AS_SALES_LEADS | Leads |
CONTACT_ROLE_CODE | AS_SALES_LEADS | Leads |
CREATION_DATE | AS_SALES_LEADS | Leads |
CURRENCY_CODE | AS_SALES_LEADS | Leads |
CUSTOMER_ID | AS_SALES_LEADS | Leads |
DECISION_TIMEFRAME_CODE | AS_SALES_LEADS | Leads |
DESCRIPTION | AS_SALES_LEADS | Leads |
GROUP_NAME | AS_LOOKUPS | Leads |
INVENTORY_ITEM_ID | AS_SALES_LEAD_LINES | Leads |
LAST_UPDATE_DATE | AS_SALES_LEADS | Leads |
LEAD_NUMBER | AS_SALES_LEADS | Leads |
LEAD_RANK_CODE | AS_SALES_LEADS | Leads |
LEAD_RANK_ID | AS_SALES_LEADS | Leads |
LEAD_STATUS | AS_STATUSES_TL | Leads |
ORGANIZATION_ID | AS_SALES_LEAD_LINES | Leads |
ORIG_SYSTEM_REFERENCE | AS_SALES_LEADS | Leads |
PRIMARY_CNT_PERSON_PARTY_ID | AS_SALES_LEADS | Leads |
PRIMARY_CONTACT_PARTY_ID | AS_SALES_LEADS | Leads |
PRIMARY_CONTACT_PHONE_ID | AS_SALES_LEADS | Leads |
QUALIFIED_FLAG | AS_SALES_LEADS | Leads |
QUANTITY | AS_SALES_LEAD_LINES | Leads |
RANK | AS_SALES_LEAD_RANKS_TL | Leads |
SALES_CHANNEL | ASO_I_SALES_CHANNELS_V | Leads |
SALES_LEAD_ID | AS_SALES_LEADS | Leads |
SOURCE_PROMOTION_CODE | AMS_P_SOURCE_CODES_V | Leads |
SOURCE_PROMOTION_ID | AS_SALES_LEADS | Leads |
SOURCE_PROMOTION_NAME | AMS_P_SOURCE_CODES_V | Leads |
STATUS_CODE | AS_SALES_LEADS | Leads |
TIME_FRAME | AS_SALES_LEADS | Leads |
UNIT_OF_MEASURE_TL | MTL_UNITS_OF_MEASURE | Leads |
UOM_CODE | AS_SALES_LEAD_LINES | Leads |
URGENT_FLAG | AS_SALES_LEADS | Leads |
VEH_RESP_CODE_MEANING | AS_LOOKUPS | Leads |
VEHICLE_RESPONSE_CODE | AS_SALES_LEADS | Leads |
CONCAT_CAT_PARENTAGE | ENI_PROD_DEN_HRCHY_PARENTS_V | Leads and Order Details |
CONCATENATED_SEGMENTS | MTL_SYSTEM_ITEMS_VL | Leads and Order Details |
ITEM_DESCRIPTION | MTL_SYSTEM_ITEMS_VL | Leads and Order Details |
CATEGORY_DESC | ENI_PROD_DEN_HRCHY_PARENTS_V | Leads and Order Details |
RESOURCE_NAME | JTF_RS_RESOURCE_EXTNS | Leads and Sales Access |
ACTUAL_ARRIVAL_DATE | OE_ORDER_LINES_ALL | Order Details |
ACTUAL_SHIPMENT_DATE | OE_ORDER_LINES_ALL | Order Details |
ATO_LINE_ID | OE_ORDER_LINES_ALL | Order Details |
BOOKED_DATE | OE_ORDER_HEADERS_ALL | Order Details |
BOOKED_FLAG | OE_ORDER_LINES_ALL | Order Details |
CANCELLED_FLAG | OE_ORDER_LINES_ALL | Order Details |
CANCELLED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
CREATION_DATE | OE_ORDER_LINES_ALL | Order Details |
EXTENDED_PRICE | NVL(OL.UNIT_SELLING_PRICE,0)*( NVL(OL.ORDERED_QUANTITY,0) - NVL(OL.CANCELLED_QUANTITY,0) ) | Order Details |
FULFILLED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
HEADER_ID | OE_ORDER_LINES_ALL | Order Details |
INVENTORY_ITEM_ID | MTL_SYSTEM_ITEMS_VL | Order Details |
INVOICE_TO_ORG_ID | OE_ORDER_LINES_ALL | Order Details |
ITEM_NUMBER | MTL_SYSTEM_ITEMS_VL | Order Details |
LAST_UPDATE_DATE | OE_ORDER_LINES_ALL | Order Details |
LINE_CATEGORY_CODE | OE_ORDER_LINES_ALL | Order Details |
LINE_ID | OE_ORDER_LINES_ALL | Order Details |
LINE_NUMBER | OE_ORDER_LINES_ALL | Order Details |
LINE_TYPE_ID | OE_ORDER_LINES_ALL | Order Details |
MARKETING_SOURCE_CODE_ID | OE_ORDER_HEADERS_ALL | Order Details |
OPEN_FLAG | OE_ORDER_LINES_ALL | Order Details |
OPTION_NUMBER | OE_ORDER_LINES_ALL | Order Details |
ORDER_QUANTITY_UOM | OE_ORDER_LINES_ALL | Order Details |
ORDER_SOURCE_ID | OE_ORDER_LINES_ALL | Order Details |
ORDERED_DATE | OE_ORDER_HEADERS_ALL | Order Details |
ORDERED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
ORG_ID | OE_ORDER_HEADERS_ALL | Order Details |
PARTY_ID | HZ_CUST_ACCOUNTS | Order Details |
PRICING_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
PRICING_QUANTITY_UOM | OE_ORDER_LINES_ALL | Order Details |
PROMISE_DATE | OE_ORDER_LINES_ALL | Order Details |
REQUEST_DATE | OE_ORDER_LINES_ALL | Order Details |
SALES_CHANNEL_CODE | OE_ORDER_HEADERS_ALL | Order Details |
SCHEDULE_ARRIVAL_DATE | OE_ORDER_LINES_ALL | Order Details |
SCHEDULE_SHIP_DATE | OE_ORDER_LINES_ALL | Order Details |
SHIP_TO_CONTACT_ID | OE_ORDER_LINES_ALL | Order Details |
SHIP_TO_ORG_ID | OE_ORDER_LINES_ALL | Order Details |
SHIPMENT_PRIORITY_CODE | OE_ORDER_LINES_ALL | Order Details |
SHIPPED_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
SHIPPING_METHOD_CODE | OE_ORDER_LINES_ALL | Order Details |
SHIPPING_QUANTITY | OE_ORDER_LINES_ALL | Order Details |
SHIPPING_QUANTITY_UOM | OE_ORDER_LINES_ALL | Order Details |
SOLD_FROM_ORG_ID | OE_ORDER_HEADERS_ALL | Order Details |
SOLD_TO_ORG_ID | OE_ORDER_HEADERS_ALL | Order Details |
TRANSACTIONAL_CURR_CODE | OE_ORDER_HEADERS_ALL | Order Details |
UNIT_LIST_PRICE | OE_ORDER_LINES_ALL | Order Details |
UNIT_SELLING_PRICE | OE_ORDER_LINES_ALL | Order Details |
ANALYSIS_FY | HZ_ORGANIZATION_PROFILES | Organization |
AVG_HIGH_CREDIT | HZ_ORGANIZATION_PROFILES | Organization |
BRANCH_FLAG | HZ_ORGANIZATION_PROFILES | Organization |
CEO_NAME | HZ_ORGANIZATION_PROFILES | Organization |
CEO_TITLE | HZ_ORGANIZATION_PROFILES | Organization |
CONG_DIST_CODE | HZ_ORGANIZATION_PROFILES | Organization |
CONTROL_YR | HZ_ORGANIZATION_PROFILES | Organization |
CORPORATION_CLASS | HZ_ORGANIZATION_PROFILES | Organization |
CREDIT_SCORE | HZ_ORGANIZATION_PROFILES | Organization |
CURR_FY_POTENTIAL_REVENUE | HZ_ORGANIZATION_PROFILES | Organization |
CUSTOMER_KEY | HZ_PARTIES | Organization |
DB_RATING | HZ_ORGANIZATION_PROFILES | Organization |
DISADV_8A_IND | HZ_ORGANIZATION_PROFILES | Organization |
EFFECTIVE_END_DATE | HZ_ORGANIZATION_PROFILES | Organization |
EFFECTIVE_START_DATE | HZ_ORGANIZATION_PROFILES | Organization |
EMP_AT_PRIMARY_ADR | HZ_ORGANIZATION_PROFILES | Organization |
EMPLOYEES_TOTAL | HZ_ORGANIZATION_PROFILES | Organization |
EXPORT_IND | HZ_ORGANIZATION_PROFILES | Organization |
FAILURE_SCORE | HZ_ORGANIZATION_PROFILES | Organization |
FAILURE_SCORE_NATL_PERCENTILE | HZ_ORGANIZATION_PROFILES | Organization |
FISCAL_YEAREND_MONTH | HZ_ORGANIZATION_PROFILES | Organization |
GLOBAL_FAILURE_SCORE | HZ_ORGANIZATION_PROFILES | Organization |
GSA_INDICATOR_FLAG | HZ_PARTIES | Organization |
HIGH_CREDIT | HZ_ORGANIZATION_PROFILES | Organization |
HQ_BRANCH_IND | HZ_ORGANIZATION_PROFILES | Organization |
IMPORT_IND | HZ_ORGANIZATION_PROFILES | Organization |
INCORP_YEAR | HZ_ORGANIZATION_PROFILES | Organization |
INTERNAL_FLAG | HZ_ORGANIZATION_PROFILES | Organization |
LANGUAGE_NAME | HZ_PARTIES | Organization |
LEGAL_STATUS | HZ_ORGANIZATION_PROFILES | Organization |
LINE_OF_BUSINESS | HZ_ORGANIZATION_PROFILES | Organization |
LOCAL_BUS_IDEN_TYPE | HZ_ORGANIZATION_PROFILES | Organization |
LOCAL_BUS_IDENTIFIER | HZ_ORGANIZATION_PROFILES | Organization |
PRIMARY_CONTACT_ID | HZ_ORGANIZATION_PROFILES | Organization |
STATUS | HZ_PARTIES | Organization |
TOTAL_EMPLOYEES_IND | HZ_ORGANIZATION_PROFILES | Organization |
VALIDATED_FLAG | HZ_PARTIES | Organization |
PARTY_TYPE | HZ_PARTIES | Organization and Organization Contact |
GROUP_TYPE | HZ_PARTIES | Organization and Organization Contact |
NEXT_FY_POTENTIAL_REVENUE | HZ_ORGANIZATION_PROFILES | Organization and Organization Contact |
ORIG_SYSTEM_REFERENCE | HZ_PARTIES | Organization and Organization Contact |
PUBLIC_PRIVATE_OWNERSHIP_FLAG | HZ_ORGANIZATION_PROFILES | Organization and Organization Contact |
TAX_NAME | HZ_PARTIES | Organization and Organization Contact |
OOB_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
ORGANIZATION_NAME | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
ORGANIZATION_TYPE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
PARENT_SUB_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
PAYDEX_NORM | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
PAYDEX_SCORE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
PAYDEX_THREE_MONTHS_AGO | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
PREF_FUNCTIONAL_CURRENCY | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
REGISTRATION_TYPE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
SIC_CODE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
SIC_CODE_TYPE | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
SMALL_BUS_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
TOTAL_EMP_EST_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
TOTAL_EMP_MIN_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
TOTAL_NUM_OF_ORDERS | HZ_PARTIES | Organization and Organization Profile |
TOTAL_ORDERED_AMOUNT | HZ_PARTIES | Organization and Organization Profile |
TOTAL_PAYMENTS | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
WOMAN_OWNED_IND | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
YEAR_ESTABLISHED | HZ_ORGANIZATION_PROFILES | Organization and Organization Profile |
LAST_ORDERED_DATE | HZ_PARTIES | Organization and Person |
PARTY_NUMBER | HZ_PARTIES | Organization and Person |
SALUTATION | HZ_PARTIES | Organization and Person |
CONTACT_ID | HZ_PARTIES | Organization Contact |
CONTACT_NUMBER | HZ_ORG_CONTACTS | Organization Contact |
CUSTOMER_KEY | HZ_PARTIES | Organization Contact |
DECISION_MAKER_FLAG | HZ_ORG_CONTACTS | Organization Contact |
DEPARTMENT | HZ_ORG_CONTACTS | Organization Contact |
DEPARTMENT_CODE | HZ_ORG_CONTACTS | Organization Contact |
GENDER | HZ_PARTIES | Organization Contact |
HQ_BRANCH_IND | HZ_PARTIES | Organization Contact |
JOB_TITLE | HZ_ORG_CONTACTS | Organization Contact |
JOB_TITLE_CODE | HZ_ORG_CONTACTS | Organization Contact |
MANAGED_BY | HZ_ORG_CONTACTS | Organization Contact |
NATIVE_LANGUAGE | HZ_ORG_CONTACTS | Organization Contact |
ORGANIZATION_ID | HZ_PARTIES | Organization Contact |
ORGANIZATION_PARTY_NAME | HZ_PARTIES | Organization Contact |
PARTY_CONTACT_NAME | HZ_ORG_CONTACTS | Organization Contact |
PERSON_ACADEMIC_TITLE | HZ_PARTIES | Organization Contact |
PERSON_PREVIOUS_LAST_NAME | HZ_PARTIES | Organization Contact |
PHONE_COUNTRY_CODE | HZ_PARTIES | Organization Contact |
PHONE_EXTENSION | HZ_PARTIES | Organization Contact |
PHONE_NUMBER | HZ_PARTIES | Organization Contact |
RANK | HZ_ORG_CONTACTS | Organization Contact |
RELATIONSHIP_CODE | HZ_RELATIONSHIPS | Organization Contact |
ROLE_TYPE | HZ_PARTIES | Organization Contact |
SIC_CODE | HZ_PARTIES | Organization Contact |
SIC_CODE_TYPE | HZ_PARTIES | Organization Contact |
TITLE | HZ_PARTIES | Organization Contact |
VALIDATED_FLAG | HZ_PARTIES | Organization Contact |
EMAIL_ADDRESS | HZ_PARTIES | Organization Contact and Person |
MAIL_STOP | HZ_ORG_CONTACTS | Organization Contact and Person |
PARTY_SITE_ID | HZ_PARTIES | Organization Contact and Person |
PERSON_FIRST_NAME | HZ_PARTIES | Organization Contact and Person |
PERSON_LAST_NAME | HZ_PARTIES | Organization Contact and Person |
PERSON_MIDDLE_NAME | HZ_PARTIES | Organization Contact and Person |
PERSON_NAME_SUFFIX | HZ_PARTIES | Organization Contact and Person |
PERSON_PRE_NAME_ADJUNCT | HZ_PARTIES | Organization Contact and Person |
PHONE_AREA_CODE | HZ_PARTIES | Organization Contact and Person |
PERSON_IDENTIFIER | HZ_PARTIES | Organization Contact and Person Profile |
MINORITY_OWNED_IND | HZ_ORGANIZATION_PROFILES | Organization Profile |
MINORITY_OWNED_TYPE | HZ_ORGANIZATION_PROFILES | Organization Profile |
PARTY_ID | HZ_ORGANIZATION_PROFILES | Organization Profile |
TAX_NAME | HZ_ORGANIZATION_PROFILES | Organization Profile |
TAX_REFERENCE | HZ_ORGANIZATION_PROFILES | Organization Profile |
TOTAL_EMPLOYEES_TEXT | HZ_ORGANIZATION_PROFILES | Organization Profile |
ADDRESS4 | HZ_PARTIES | Organization and Organization Contact |
DUNS_NUMBER | HZ_PARTIES | Organization and Organization Contact |
POSTAL_CODE | HZ_PARTIES | Organization and Organization Contact |
PROVINCE | HZ_PARTIES | Organization and Organization Contact |
REFERENCE_USE_FLAG | HZ_PARTIES | Organization, Organization Contact, and Person |
COUNTY | HZ_PARTIES | Organization, Organization Contact, and Person |
KNOWN_AS | HZ_PARTIES | Organization, Organization Contact, and Person Profile |
TAX_REFERENCE | HZ_PARTIES | Organization, Organization Contact, Person |
ADDRESS1 | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
ADDRESS2 | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
ADDRESS3 | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
CITY | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
COUNTRY | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
STATE | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
URL | HZ_PARTIES | Organization, Organization Contact, Person, and Account |
JGZZ_FISCAL_CODE | HZ_PARTIES | Organization, Organization Contact, Person, Person Profile |
RENT_OWN_IND | HZ_ORGANIZATION_PROFILES | Organization, Organization Contact, Person, Person Profile |
PARTY_ID | HZ_PARTIES | Organization, Person, and Organization Contact |
BEST_TIME_CONTACT_BEGIN | HZ_ORGANIZATION_PROFILES | Organization, Person, and Person Profile |
BEST_TIME_CONTACT_END | HZ_ORGANIZATION_PROFILES | Organization, Person, and Person Profile |
CUSTOMER_KEY | HZ_PARTIES | Person |
LANGUAGE | HZ_PARTY_SITES | Person |
LAST_ORDERED_DATE | HZ_PARTIES | Person |
PARTY_SITE_NAME | HZ_PARTY_SITES | Person |
PHONE_COUNTRY_CODE | HZ_CONTACT_POINTS | Person |
PHONE_EXTENSION | HZ_CONTACT_POINTS | Person |
PHONE_NUMBER | HZ_CONTACT_POINTS | Person |
AGE | trunc(months_between(sysdate date_of_birth) / 12,0) | Person and Person Profile |
DATE_OF_BIRTH | HZ_PERSON_PROFILES | Person and Person Profile |
DATE_OF_DEATH | HZ_PERSON_PROFILES | Person and Person Profile |
DECLARED_ETHNICITY | HZ_PERSON_PROFILES | Person and Person Profile |
GENDER | HZ_PERSON_PROFILES | Person and Person Profile |
HEAD_OF_HOUSEHOLD_FLAG | HZ_PERSON_PROFILES | Person and Person Profile |
HOUSEHOLD_INCOME | HZ_PERSON_PROFILES | Person and Person Profile |
HOUSEHOLD_SIZE | HZ_PERSON_PROFILES | Person and Person Profile |
INTERNAL_FLAG | HZ_PERSON_PROFILES | Person and Person Profile |
MARITAL_STATUS | HZ_PERSON_PROFILES | Person and Person Profile |
MARITAL_STATUS_EFFECTIVE_DATE | HZ_PERSON_PROFILES | Person and Person Profile |
PERSON_NAME | HZ_PERSON_PROFILES | Person and Person Profile |
PERSONAL_INCOME | HZ_PERSON_PROFILES | Person and Person Profile |
PLACE_OF_BIRTH | HZ_PERSON_PROFILES | Person and Person Profile |
COURSE_MAJOR | HZ_EDUCATION | Person Education |
DEGREE_RECEIVED | HZ_EDUCATION | Person Education |
EDUCATION_ID | HZ_EDUCATION | Person Education |
LAST_DATE_ATTENDED | HZ_EDUCATION | Person Education |
PARTY_ID | HZ_EDUCATION | Person Education |
SCHOOL_ATTENDED_NAME | HZ_EDUCATION | Person Education |
START_DATE_ATTENDED | HZ_EDUCATION | Person Education |
TYPE_OF_SCHOOL | HZ_EDUCATION | Person Education |
INTEREST_NAME | HZ_PERSON_INTEREST | Person Interest |
INTEREST_TYPE_CODE | HZ_PERSON_INTEREST | Person Interest |
LEVEL_OF_INTEREST | HZ_PERSON_INTEREST | Person Interest |
LEVEL_OF_PARTICIPATION | HZ_PERSON_INTEREST | Person Interest |
PARTY_ID | HZ_PERSON_INTEREST | Person Interest |
PERSON_INTEREST_ID | HZ_PERSON_INTEREST | Person Interest |
SINCE | HZ_PERSON_INTEREST | Person Interest |
SUB_INTEREST_TYPE_CODE | HZ_PERSON_INTEREST | Person Interest |
TEAM | HZ_PERSON_INTEREST | Person Interest |
AMS_PERSON_PROFILE_ID | HZ_PERSON_PROFILES | Person Profile |
CONTENT_SOURCE_TYPE | HZ_PERSON_PROFILES | Person Profile |
DECLARED_ETHNICITY | HZ_PERSON_PROFILES | Person Profile |
PARTY_ID | HZ_PERSON_PROFILES | Person Profile |
PERSON_IDEN_TYPE | HZ_PERSON_PROFILES | Person Profile |
PERSON_PERVIOUS_LAST_NAME | HZ_PERSON_PROFILES | Person Profile |
TAX_REFERENCE | HZ_PERSON_PROFILES | Person Profile |
ACCOUNTS1 | FEM_PARTY_PROFITABILITY | Profitability |
ACCOUNTS2 | FEM_PARTY_PROFITABILITY | Profitability |
ACCOUNTS3 | FEM_PARTY_PROFITABILITY | Profitability |
ACCOUNTS4 | FEM_PARTY_PROFITABILITY | Profitability |
ACCOUNTS5 | FEM_PARTY_PROFITABILITY | Profitability |
BALANCE1 | FEM_PARTY_PROFITABILITY | Profitability |
BALANCE2 | FEM_PARTY_PROFITABILITY | Profitability |
BALANCE3 | FEM_PARTY_PROFITABILITY | Profitability |
BALANCE4 | FEM_PARTY_PROFITABILITY | Profitability |
BALANCE5 | FEM_PARTY_PROFITABILITY | Profitability |
CACC_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
CACC1 | FEM_PARTY_PROFITABILITY | Profitability |
CACC2 | FEM_PARTY_PROFITABILITY | Profitability |
CACC3 | FEM_PARTY_PROFITABILITY | Profitability |
CACC4 | FEM_PARTY_PROFITABILITY | Profitability |
CACC5 | FEM_PARTY_PROFITABILITY | Profitability |
CONTRIB_AFTER_CPTL_CHG | FEM_PARTY_PROFITABILITY | Profitability |
EXPENSE_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
EXPENSE1 | FEM_PARTY_PROFITABILITY | Profitability |
EXPENSE2 | FEM_PARTY_PROFITABILITY | Profitability |
EXPENSE3 | FEM_PARTY_PROFITABILITY | Profitability |
EXPENSE4 | FEM_PARTY_PROFITABILITY | Profitability |
EXPENSE5 | FEM_PARTY_PROFITABILITY | Profitability |
ISO_CURRENCY_CD | FEM_PARTY_PROFITABILITY | Profitability |
LTD1 | FEM_PARTY_PROFITABILITY | Profitability |
LTD2 | FEM_PARTY_PROFITABILITY | Profitability |
LTD3 | FEM_PARTY_PROFITABILITY | Profitability |
LTD4 | FEM_PARTY_PROFITABILITY | Profitability |
LTD5 | FEM_PARTY_PROFITABILITY | Profitability |
PARTNER_VALUE_INDEX | FEM_PARTY_PROFITABILITY | Profitability |
PARTY_ID | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT_PCT | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT1 | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT2 | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT3 | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT4 | FEM_PARTY_PROFITABILITY | Profitability |
PROFIT5 | FEM_PARTY_PROFITABILITY | Profitability |
RATIO1 | FEM_PARTY_PROFITABILITY | Profitability |
RATIO2 | FEM_PARTY_PROFITABILITY | Profitability |
RATIO3 | FEM_PARTY_PROFITABILITY | Profitability |
RATIO4 | FEM_PARTY_PROFITABILITY | Profitability |
RATIO5 | FEM_PARTY_PROFITABILITY | Profitability |
RELATIONSHIP_EXPENSE | FEM_PARTY_PROFITABILITY | Profitability |
REVENUE_TOTAL | FEM_PARTY_PROFITABILITY | Profitability |
REVENUE1 | FEM_PARTY_PROFITABILITY | Profitability |
REVENUE2 | FEM_PARTY_PROFITABILITY | Profitability |
REVENUE3 | FEM_PARTY_PROFITABILITY | Profitability |
REVENUE4 | FEM_PARTY_PROFITABILITY | Profitability |
REVENUE5 | FEM_PARTY_PROFITABILITY | Profitability |
TOTAL_EQUITY | FEM_PARTY_PROFITABILITY | Profitability |
TOTAL_GROSS_CONTRIB | FEM_PARTY_PROFITABILITY | Profitability |
TOTAL_ROE | FEM_PARTY_PROFITABILITY | Profitability |
TRANSACTION1 | FEM_PARTY_PROFITABILITY | Profitability |
TRANSACTION2 | FEM_PARTY_PROFITABILITY | Profitability |
TRANSACTION3 | FEM_PARTY_PROFITABILITY | Profitability |
TRANSACTION4 | FEM_PARTY_PROFITABILITY | Profitability |
TRANSACTION5 | FEM_PARTY_PROFITABILITY | Profitability |
VALUE1 | FEM_PARTY_PROFITABILITY | Profitability |
VALUE2 | FEM_PARTY_PROFITABILITY | Profitability |
VALUE3 | FEM_PARTY_PROFITABILITY | Profitability |
VALUE4 | FEM_PARTY_PROFITABILITY | Profitability |
VALUE5 | FEM_PARTY_PROFITABILITY | Profitability |
YTD1 | FEM_PARTY_PROFITABILITY | Profitability |
YTD2 | FEM_PARTY_PROFITABILITY | Profitability |
YTD3 | FEM_PARTY_PROFITABILITY | Profitability |
YTD4 | FEM_PARTY_PROFITABILITY | Profitability |
YTD5 | FEM_PARTY_PROFITABILITY | Profitability |
CUSTOMER_ID | AS_ACCESSES_ALL | Sales Access |
GROUP_ID | JTF_RS_GROUPS_VL | Sales Access |
GROUP_NAME | JTF_RS_GROUPS_VL | Sales Access |
RESOURCE_ID | JTF_RS_RESOURCE_EXTNS | Sales Access |
SALESFORCE_ID | AS_ACCESSES_ALL | Sales Access |
ORIG_SYSTEM | HZ_ORIG_SYS_REFERENCES | System Reference |
ORIG_SYSTEM_REFERENCE | HZ_ORIG_SYS_REFERENCES | System Reference |
OWNER_TABLE_ID | HZ_ORIG_SYS_REFERENCES | System Reference |
OWNER_TABLE_NAME | HZ_ORIG_SYS_REFERENCES | System Reference |
STATUS | HZ_ORIG_SYS_REFERENCES | System Reference |