FND Design Data [Home] [Help]

Table: AS_SALES_CREDITS_DENORM

Product: AS - Sales Foundation
Description: Denormalized table to store opportunity data denormalized from AS_LEADS_ALL, AS_LEAD_LINES_ALL, AS_SALES_CREDITS, AS_SALES_STAGE_ALL, AS_INTEREST_TYPES_ALL, AS_INTEREST_CODES_ALL, HZ_PARTIES, AS_SALES_GROUPS, PER_ALL_PEOPLR_F
Implementation/DBA Data: TableOSM.AS_SALES_CREDITS_DENORM
Primary Key: AS_SALES_CREDITS_DENORM_PK
  1. ColumnSALES_CREDIT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
AS_SALES_CREDITS_DENORM FK Joins to TableJTF_RS_RESOURCE_EXTNS AS_SALES_CREDITS_DENORM.SALESFORCE_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_FORECAST_PROB_ALL_B AS_SALES_CREDITS_DENORM.WIN_PROBABILITY
AS_SALES_CREDITS_DENORM FK Joins to TableAS_INTEREST_TYPES_B AS_SALES_CREDITS_DENORM.INTEREST_TYPE_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_INTEREST_CODES_B AS_SALES_CREDITS_DENORM.PRIMARY_INTEREST_CODE_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_INTEREST_CODES_B AS_SALES_CREDITS_DENORM.SECONDARY_INTEREST_CODE_ID
AS_SALES_CREDITS_DENORM FK Joins to TableHZ_PARTIES AS_SALES_CREDITS_DENORM.CLOSE_COMPETITOR_ID
AS_SALES_CREDITS_DENORM FK Joins to TableHZ_PARTIES AS_SALES_CREDITS_DENORM.PARTNER_CUSTOMER_ID
AS_SALES_CREDITS_DENORM FK Joins to TableHZ_PARTY_SITES AS_SALES_CREDITS_DENORM.PARTNER_ADDRESS_ID
AS_SALES_CREDITS_DENORM FK Joins to TableJTF_RS_GROUPS_B AS_SALES_CREDITS_DENORM.SALES_GROUP_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_SALES_CREDITS AS_SALES_CREDITS_DENORM.SALES_CREDIT_ID
AS_SALES_CREDITS_DENORM FK Joins to TableHZ_PARTIES AS_SALES_CREDITS_DENORM.CUSTOMER_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_LEADS_ALL AS_SALES_CREDITS_DENORM.LEAD_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_LEAD_LINES_ALL AS_SALES_CREDITS_DENORM.LEAD_LINE_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_SALES_STAGES_ALL_B AS_SALES_CREDITS_DENORM.SALES_STAGE_ID
AS_SALES_CREDITS_DENORM FK Joins to TableAS_STATUSES_B AS_SALES_CREDITS_DENORM.STATUS_CODE
AS_SALES_CREDITS_DENORM FK Joins to TableHZ_PARTY_SITES AS_SALES_CREDITS_DENORM.ADDRESS_ID
TableAS_MC_SALES_CREDITS_DEN FK Joins to AS_SALES_CREDITS_DENORM AS_MC_SALES_CREDITS_DEN.SALES_CREDIT_ID