[Home] [Help]
View: AS_DOSSIER_SALESREPS_V
Product: | AS - Sales Foundation |
Description: | Order history sales representatives view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DUR.HEADER_ID
, SUM(DUR.HEADER_CREDITS)
, SUM(DUR.LINE_CREDITS)
, DUR.CREDIT_TYPE
, DUR.SALESREP_ID
, DUR.SALESREP
FROM AS_DOSSIER_REPS_UNIONALL_V DUR GROUP BY DUR.HEADER_ID
, DUR.SALESREP_ID
, DUR.SALESREP
, DUR.CREDIT_TYPE
Columns
Name |
HEADER_ID |
HEADER_CREDITS |
LINE_CREDITS |
CREDIT_TYPE |
SALESREP_ID |
SALESREP |