[Home] [Help]
View: ASBV_SALES_GROUPS
Product: | AS - Sales Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT GRP.NAME
, GRP.START_DATE_ACTIVE
, GRP.END_DATE_ACTIVE
, '_LA:GRP.ENABLED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, GRP.DESCRIPTION
, GRP.ACCOUNTING_CODE
, '_DF:AS:AS_SALES_GROUPS:GRP' -- ID
, GRP.SALES_GROUP_ID
, GRP.PARENT_SALES_GROUP_ID
, GRP.MANAGER_PERSON_ID
, GRP.MANAGER_SALESFORCE_ID -- WHO
, GRP.LAST_UPDATE_DATE
, GRP.LAST_UPDATED_BY
, GRP.CREATION_DATE
, GRP.CREATED_BY
FROM AS_SALES_GROUPS GRP WITH READ ONLY
Columns
Name |
SALES_GROUP_NAME |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
"_LA:ENABLED" |
DESCRIPTION |
ACCOUNTING_CODE |
"_DF" |
SALES_GROUP_ID |
PARENT_SALES_GROUP_ID |
MANAGER_PERSON_ID |
MANAGER_SALESFORCE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |