[Home] [Help]
View: ASBV_SALES_CREDITS
Product: | AS - Sales Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CRED.REVENUE_AMOUNT
, CRED.REVENUE_PERCENT
, CRED.QUOTA_CREDIT_AMOUNT
, CRED.QUOTA_CREDIT_PERCENT
, '_DF:AS:AS_SALES_CREDITS:CRED' -- ID
, CRED.SALES_CREDIT_ID
, CRED.LEAD_ID
, CRED.LEAD_LINE_ID
, CRED.SALESFORCE_ID
, CRED.SALESGROUP_ID
, CRED.PARTNER_CUSTOMER_ID
, CRED.PARTNER_ADDRESS_ID -- WHO
, CRED.LAST_UPDATE_DATE
, CRED.LAST_UPDATED_BY
, CRED.CREATION_DATE
, CRED.CREATED_BY
FROM AS_SALES_CREDITS CRED WITH READ ONLY
Columns
Name |
REVENUE_AMOUNT |
REVENUE_PERCENT |
QUOTA_CREDIT_AMOUNT |
QUOTA_CREDIT_PERCENT |
"_DF" |
SALES_CREDIT_ID |
LEAD_ID |
LEAD_LINE_ID |
SALESFORCE_ID |
SALESGROUP_ID |
PARTNER_CUSTOMER_ID |
PARTNER_ADDRESS_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |