DW_CXS_SALES_ACCOUNT_ACCESS_D

Sales account access

Details

Module:

Key Columns

ACCOUNT_ACCESS_ID, TYPE_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCOUNT_ACCESS_ID NUMBER 38 0 True Unique identifier    
TYPE_CODE VARCHAR2 32   True Type code, stores values like RESOURCE, TERRITORY    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Source Record Identifier    
SALES_ACCOUNT_ID NUMBER 38 0   Sales account identifier    
GROUP_ID NUMBER 38 0   Contains either Resources Party Id or Territory Id based on Type column value    
ACCOUNT_TERRITORY_ID NUMBER 38 0   Account territory Identifier    
ACCOUNT_RESOURCE_ID NUMBER 38 0   Account resource Identifier    
SALES_ACCOUNT_TYPE VARCHAR2 32     Type of the sales Account. Possible values are: ZCA_PROSPECT,ZCA_CONTACT,ZCA_CUSTOMER    
PARTY_ID NUMBER 38 0   Party Id of the Sales Account    
ACCESS_LEVEL_CODE VARCHAR2 32     Access Level Code of Resource on Account, for records with type='RESOURCE'. 'null', for records with type='TERRITORY'    
CREATED_BY VARCHAR2 128     Indicates the user who created the row.    
CREATION_DATE TIMESTAMP       Indicates the date and time of the creation of the row.    
LAST_UPDATED_BY VARCHAR2 128     Indicates the user who last updated the row    
LAST_UPDATE_DATE TIMESTAMP       Indicates the date and time of the last update of the row.    
LAST_UPDATE_LOGIN VARCHAR2 64     Indicates the session login associated to the user who last updated the row    

Copyright © 2019, 2024, Oracle and/or its affiliates.