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