[Home] [Help]
View: ASBV_SALES_COMPETITORS
| Product: | AS - Sales Foundation |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT '_LA:COM.COMPETITOR_CODE:AS_LOOKUPS:COMPETITOR:MEANING'
, COM.COMPETITOR
, COM.PRODUCTS
, COM.COMMENTS
, '_DF:AS:AS_LEAD_COMPETITORS:COM' -- ID
, COM.LEAD_COMPETITOR_ID
, COM.LEAD_ID
, COM.COMPETITOR_ID -- WHO
, COM.LAST_UPDATE_DATE
, COM.LAST_UPDATED_BY
, COM.CREATION_DATE
, COM.CREATED_BY
FROM AS_LEAD_COMPETITORS COM WITH READ ONLY
Columns
| Name |
| "_LA:COMPETITOR_CODE" |
| COMPETITOR |
| PRODUCTS |
| COMMENTS |
| "_DF" |
| LEAD_COMPETITOR_ID |
| LEAD_ID |
| COMPETITOR_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |