AS Tables (203)

AS - Sales Foundation — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
AS_ACCESSES_ALL_ALL 67 Contains employee and partner access records for customers, sales leads and opportunities
AS_ACCESSES_PURGE_TEMP 66
AS_ACCOUNT_QUAL_VALUES_ALL 19 Contains changed accounts - obsolete
AS_AP_ACCOUNT_PLANS 25 This is the header table that will hold account plans for various customers
AS_AP_BUSINESS_DRIVERS 28 This table will hold all the business drivers for each of the account plans
AS_AP_STRTGC_OBJECTIVES 29 This table will hold all the strategic objectives for each of the account plans
AS_AP_TRACKING_OBJECTIVES 34 This table will hold all the revenue objectives for each of the account plans
AS_CARD_RULE_QUAL_VALUES 21 Holds the information about various parameters used in the rule. Records can be deleted.
AS_CATEGORIES_ALL 27 Contains collateral categories
AS_CHANGED_ACCOUNTS_ALL 21 Contains changed accounts
AS_CHANGED_TERRITORIES_ALL 22 Contains changed territories
AS_COLLATERAL_CAT_ALL 12 Contains collateral categories
AS_COLLATERAL_KITS_ALL 25 Contains collateral kits
AS_COLLATERAL_REQ_ALL 50 Contains collateral requests
AS_COLLATERAL_REQ_ITEMS 27 Contains items included in a collateral request
AS_CONC_REQUEST_MESSAGES 15 Contains error messages for concurrent programs
AS_CONTACT_EDUCATION 11 Contains education information for contacts
AS_CONTACT_ENTER 14 Contains entertainment information for contacts
AS_CONTACT_FAMILY 12 Obsolete table in 11i
AS_CONTACT_HOBBIES 10 Contain information about hobbies for contacts
AS_CONTACT_JOB_HISTORY 13 Contains job history information for contacts
AS_CONTACT_MILITARY 11 Contains millitary information for contacts
AS_CONTACT_PREFERENCES 13 Contains additional preferences for contacts
AS_CONTACT_SPORTS 12 Contains sport information for contacts
AS_CONTACT_TRAITS 9 Contains traits for contacts
AS_COUNTRY_PHONES 13 Contains international dialing codes for countries
AS_CURRENT_ENVIRONMENT 47 This table stores information about the current environment of the
AS_CUST_PROFILES 7 Table for OSM disconnected, stores identifiers for newly created accounts.
AS_DEFAULT_PURCHASES_ALL 12 Currently not in use
AS_EVENT_DATA 133 Table for storing Business Events data
AS_EVENT_ENROLLMENTS_ALL 39 Contains event enrollments
AS_EVENT_FACILITIES_ALL 43 Contains event facilities
AS_EVENT_FAC_ROOMS 31 Contains event facility rooms
AS_EVENT_FAC_STAFF 34 Contains event facility staff
AS_EVENT_LETTERS_ALL 33 Contains letters to be used for events
AS_EVENT_NAMES_ALL 25 Contains events
AS_EVENT_NAME_REQUIREMENTS 8 Contains event requirements
AS_EVENT_PERSONNEL 34 Contains event personnel
AS_EXCHANGES_B 25 Base table to store exchanges
AS_EXCHANGES_TL 10 For MLS - Translated columns of Exchanges
AS_FORECASTS 58 Holds revenue and quota credit forecasts
AS_FORECAST_ACTUALS 20 Table for comparing the actual returns with forecasted values
AS_FORECAST_CATEGORIES_B 11 Forecast categories will determine the selection of interest types available for forecast. Any opportunity which has interest types mapped
AS_FORECAST_CATEGORIES_TL 11 Forecast categories will determine the selection of interest types available for forecast. Any opportunity which has interest types mapped
AS_FORECAST_CAT_DEN 4
AS_FORECAST_PROB_ALL_B 32 AS_FORECAST_PROB_ALL defines win probability values for sales
AS_FORECAST_PROB_ALL_TL 10 MLS - Translated columns of AS_FORECAST_PROB_ALL_B
AS_FORECAST_WORKSHEETS 49 This will store header information for the opportunity and product category worksheet.
AS_FST_SALES_CATEGORIES 14 Resolving table between AS_FORECAST_CATEGORIES and AS_INTEREST_TYPES_B
AS_FUNDS_B 30 Base table to store Funds
AS_FUNDS_TL 10 For MLS - Translated columns of Funds
AS_FUND_CONTACTS 26 Fund Contacts
AS_GROUP_ISSUE_MAP 32 Mapping table between issue groups and issues
AS_GROUP_PARTY_MAP 29 Mapping table between issue groups and issues
AS_HZ_CLASS_CODE_DENORM 46 Denormalized table to store customer classification code relations data denormalized from HZ_CLASS_CATEGORIES, HZ_CLASS_CATEGORY_USES, HZ_CL
AS_IMPORT_INTERFACE 339 staging table to hold data to be imported
AS_IMP_CNT_PNT_INTERFACE 36 Interface table to hold contact points information to be imported.
AS_IMP_CNT_ROL_INTERFACE 19 Interface table to hold contact roles information to be imported.
AS_IMP_LINES_INTERFACE 23 Interface table to hold lead lines information to be imported.
AS_IMP_SL_FLEX 61 Table to hold flex field information to be imported.
AS_INTERESTS_ALL 43 Stores product interests, customer and opportunity classifications
AS_INTEREST_CATEGORY_SETS_ALL 10 Contains interest category sets
AS_INTEREST_CODES_ALL 40 Defines interest codes with multi-org flag columns
AS_INTEREST_CODES_B 40 Define Interest code - Base table
AS_INTEREST_CODES_MC 10 for recording a price and currency for a product family.
AS_INTEREST_CODES_TL 11 For MLS - Translated columns of Interest Codes.
AS_INTEREST_STATUSES 11 Define interest statuses
AS_INTEREST_TYPES_ALL 18 Defines interest types with multi-org flag columns
AS_INTEREST_TYPES_B 17 Define Interest types - base table
AS_INTEREST_TYPES_TL 11 For MLS - Translated columns of Interest Types
AS_INTERNAL_FORECASTS 62 Table to store the summary forecast information for individual or group
AS_INVALID_ADDR 10 Stores invalid addresses from ra_addresses
AS_ISSUER 25 Stores Issuers
AS_ISSUES_B 27 Holds Issues - Base Table
AS_ISSUES_TL 11 For MLS - Translated columns of Issues
AS_ISSUE_GROUPS_B 29 Holds Issue Groups - Base Table
AS_ISSUE_GROUPS_TL 10 For MLS - Translated columns of Issue Groups
AS_ISSUE_GROUP_IDFR 28 Holds Issue Group Identifiers
AS_ISSUE_GROUP_TYPES 31 Holds Issue Group Types
AS_ISSUE_LISTING_B 26 Holds Issue Listings - base table
AS_ISSUE_LISTING_IDFR 31 Holds issue listing identifiers
AS_ISSUE_LISTING_TL 12 For MLS - Translated columns of Issue Listings
AS_ISSUE_RELATIONSHIPS 30 Stores Issue Relationships
AS_LAST_RUN_DATES 19 Contains the last date an Oracle Sales and marketing concurrent program ran
AS_LEADS_ALL 80 Holds sales opportunities
AS_LEADS_LOG 33 Holds opportunity header change history
AS_LEAD_ADJS 15 Stores adjustments to a lead (opportunity).
AS_LEAD_COMPETITORS 37 Defines competitors for sales opportunities
AS_LEAD_COMP_PRODUCTS 33 Holds competitor products
AS_LEAD_CONTACTS_ALL 39 Contains contacts linked to sales opportunities
AS_LEAD_DECISION_FACTORS 32 Holds decision factors
AS_LEAD_IMPORT_ERRORS 14 Contains the error messages for imported sales leads
AS_LEAD_LINES_ALL 55 Holds sales opportunity lines
AS_LEAD_LINES_LOG 23 Hold purchase line change history
AS_LEAD_LINE_ADJS 32 Stores adjustments to lead (opportunity) lines.
AS_LEAD_OBSTACLES 33 Defines obstacles for sales opportunities
AS_LEAD_ORDERS 29 Contains orders resulting from sales opportunities
AS_LETS_PARTNER_MAP 4 Store partner information for Opportunity Exchange Transaction Server
AS_LISTS_ALL 37 Defines market and campaign lists
AS_LIST_ENTRIES 197 Holds list entries
AS_LIST_ENTRY_USAGES 31 Contains the assignement of list entries to the sales person and the promotion.
AS_LIST_RULES 12 This table stores the user-defined rules for identifying duplicates in a list.
AS_LIST_RULE_ENTRIES 9 This table stores the columns that are used to identify duplicates in a list.
AS_LLOG_STATUS_SUMMARY 17 Holds data for opportunity log status summary
AS_LS_ERRS 11 For Lead Sharing use
AS_MC_REPORTING_CURR 11 Holds reporting currencies
AS_MC_SALES_CREDITS_DEN 27 Multi currency table to store sales credit amounts converted in various reporting currencies based on daily as well as pseudo period rates
AS_MC_TYPE_MAPPINGS 12 Define the mapping from Period to Conversion_type.
AS_MERGE_FILES_ALL 18 Holds information about letter merge files
AS_METH_STAGE_INSTANCES 30 This table stores methodology stage instances.
AS_METH_STEP_INSTANCES 32 This table stores methodology step instances.
AS_MRP_FCT_DETAIL 18
AS_MRP_FCT_REPORT 25
AS_MRP_INTERFACE 14 Holds OSM-MRP interface header information
AS_MRP_INTERFACE_LINES 21 Holds OSM-MRP interface lines information
AS_MRP_OPP_REPORT 19
AS_OBJECT_ATTRIBUTES 17 PRM related table
AS_OPP_WORKSHEET_LINES 95 Table to store the forecast information on all possible opportunities for individual or sales group
AS_OSI_CONS_CCS_BASE 7 This table is only for Oracle internal rollout.
AS_OSI_CONTR_NAMES_BASE 6 This table is only for Oracle internal rollout.
AS_OSI_CONTR_VHCL_BASE 5 This table is only for Oracle internal rollout.
AS_OSI_LEADS_ALL 45 This table is only for Oracle internal rollout.
AS_OSI_LEADS_DENORM 48 Denormalized table
AS_OSI_LEAD_OVL_ALL 12 This table is only for Oracle internal rollout.
AS_OSI_LOOKUP 5 This table is only for Oracle internal rollout.
AS_OSI_OVERLAY_BASE 4 This table is only for Oracle internal rollout.
AS_PARTNER_ACCESSES 16 Stores the sales rep information for a lead in partner's OSO database.
AS_PARTNER_LEAD_CONTACTS 16 Stores the contact information for a lead in partner's OSO database.
AS_PARTNER_LEAD_LINES 12 Stores the contact information for a lead in partner's OSO database.
AS_PARTNER_LEAD_NOTES 9 Stores the Notes information for a lead in partner's OSO database.
AS_PARTNER_MAP 4 OBSOLETE
AS_PERIOD_DAYS 7 simplifies gl_periods
AS_PERIOD_RATES 25 Holds currency conversion rates
AS_PE_INT_CATEGORIES 19 Mapping table between plan elements in osc and forecast
AS_PHONE_FORMATS 14 Defines valid phone formats for a particular country
AS_PRICE_LISTS 9 Price lists
AS_PRICE_LIST_GROUPS 10 Price lists groups
AS_PRODUCT_FILTERS 13
AS_PROD_WORKSHEET_LINES 64 Table to store the forecast information on all possible product categories for individual or sales group
AS_PROMOTIONS_ALL 97 Defines promotions
AS_PROMOTION_RELATIONSHIPS 24 Defines promotion relationships
AS_PROMOTION_SCRIPTS 23 Holds scripts linked to promotions
AS_QUOTA_PROFILES 39
AS_QUOTES_ALL 90 Defines quotations
AS_QUOTE_LINES_ALL 84 Holds quotation lines information
AS_QUOTE_STATUS_LOG 16 Tracks changes of quote status and quote version
AS_RELATIONSHIPS 32 This table stores relationships between entities.
AS_REPORTING_MANAGERS 25 Denormalized table derived from AS_SALESFORCE.
AS_ROLLING_CALENDARS 25 Stores Rolling Calendars for Sales Forecasts
AS_ROLLING_PERIODS 24 Stores Rolling Periods within rolling calendars for Sales Forecasts
AS_SALESFORCE 31 Obsolete Defines the salesforce
AS_SALESREP_JOBS 22 Defines sales representative jobs
AS_SALES_CREDITS 49 Holds sales credits
AS_SALES_CREDITS_DENORM 116 Denormalized table to store opportunity data denormalized from AS_LEADS_ALL, AS_LEAD_LINES_ALL, AS_SALES_CREDITS, AS_SALES_STAGE_ALL, AS_INT
AS_SALES_CREDITS_LOG 20 Holds sales credit change history
AS_SALES_CREDIT_ADJS 19 Stores adjustments to sales credits.
AS_SALES_GROUPS 31 Defines sales groups
AS_SALES_GROUPS_DENORM 24 Denormalized table derived from AS_SALES_GROUPS
AS_SALES_GRP_ADMIN 24 Defines administrators for sales groups
AS_SALES_LEADS 98 Holds sales leads
AS_SALES_LEADS_LOG 22 Holds opportunity change history
AS_SALES_LEAD_CARD_RULES 12 Holds the score and description information for a score card rule
AS_SALES_LEAD_CONTACTS 38 Holds contact information for the Lead. Records can be deleted.
AS_SALES_LEAD_LINES 42 Holds sales lead lines informaiton
AS_SALES_LEAD_OPPORTUNITY 30 Holds the linking information between sales leads and opportunity. Records can not be deleted.
AS_SALES_LEAD_OPP_LINES 30 Holds the linking information between sales lead linesand opportunity lines
AS_SALES_LEAD_OWNERS 19 Holds lead owners information
AS_SALES_LEAD_QUALS_B 14 Holds information about the columns which are used in scorecard rules
AS_SALES_LEAD_QUALS_TL 12 Holds transalation information for multi lingual support
AS_SALES_LEAD_RANKS_B 11 Defines the various ranks a lead can have
AS_SALES_LEAD_RANKS_TL 12 Holds transalation information for multi lingual support
AS_SALES_LEAD_SCORECARDS 12 Holds the score card information
AS_SALES_LEAD_SEED_QUAL_B 11 Holds information about the columns which are used in scorecard rules
AS_SALES_METHODOLOGY_B 28 Define Sales Methodologies
AS_SALES_METHODOLOGY_TL 12 For MLS - Translated columns of AS_SALES_METHODOLOGY_B
AS_SALES_METH_STAGE_MAP 15 Table for mapping Sales Stages with Task Template Groups
AS_SALES_METH_TASK_MAP 14 Stores information about task created automatically by the sales methodology
AS_SALES_QUOTAS 45 Defines sales quotas
AS_SALES_STAGES_ALL_B 37 Defines sales stages
AS_SALES_STAGES_ALL_TL 12 For MLS - Translated columns of AS_SALES_STAGES_ALL_B
AS_SCRIPT_ACTUAL_ANSWERS 38 Holds answers for script questions
AS_SCRIPT_ANSWER_ACTIONS_ALL 38 Holds actions resulting from script answers
AS_SCRIPT_PRE_DEFINED_ANSWERS 30 Defines answers to script questions
AS_SCRIPT_QUESTIONS 26 Defines script questions
AS_SERVERS 9 OBSOLETE
AS_STATUSES_B 34 Hold three types of status, opportunity, lead and quote
AS_STATUSES_TL 12 For MLS, Translated columns of AS_STATUSES_B
AS_TAP_PURGE_WORKING 8 The working table for TAP purge program
AS_TERRITORIES_ALL 47 Obsolete Sales out to JTF Terr Core -- Holds territory definitions
AS_TERRITORY_ACCESSES 14 Defines territory accesses
AS_TERRITORY_ACC_PURGE_TEMP 14
AS_TERRITORY_GROUPS_ALL 29 Obsolete Defines territory groups
AS_TERRITORY_ROLLUPS 4 Defines rollup territories
AS_TERRITORY_TYPES_ALL 32 Obsolete To JTF Terr Core Defines territory types
AS_TERRITORY_VALUES_ALL 25 Obsolete To JTF Terr Core Holds territory values
AS_TERR_RESOURCES_TMP 13 Hold territory assignment results.
AS_TERR_ROLLUPS_IMMEDIATE_TMP 2 Temporary table used by the Territory program
AS_TERR_SEEDED_QUALIFIERS_ALL 14 Defines qualifiers for territory definitions
AS_TERR_TYPE_QUALIFIERS 9 Holds territory type and qualifier combinations
AS_TODO_LISTS_ALL 57 Obsolete Holds activities for sales representatives
AS_TRANSFER_DETAILS 5 For Lead Sharing use
AS_TRANSFER_QUES 9 For Lead Sharing use
AS_WORD_REPLACEMENTS 25 Defines word replacement rules for Fuzzy Find functionality