DOO_SALES_CREDITS_RM_V

Details

• Schema: FUSION

• Object owner: DOO

• Object type: VIEW

Columns

Name
DOC_SUB_LINE_ID_INT_1 DOC_ID_INT_1 DOC_LINE_ID_INT_1 SALESREP_ID REVENUE_PERCENT_SPLIT DOCUMENT_TYPE_ID SOURCE_SYSTEM DOC_SUB_LINE_PARENT_LEVEL DOC_SUB_LINE_TYPE

Query

SQL_Statement
SELECT SALES_CREDIT_ID DOC_SUB_LINE_ID_INT_1, DOO_SALES_CREDITS.HEADER_ID DOC_ID_INT_1, FULFILL_LINE_ID DOC_LINE_ID_INT_1, SALESPERSON_ID SALESREP_ID, PERCENT REVENUE_PERCENT_SPLIT, 5 DOCUMENT_TYPE_ID, 'FUSION' SOURCE_SYSTEM, 'L' DOC_SUB_LINE_PARENT_LEVEL, 'SALESCREDITS' DOC_SUB_LINE_TYPE FROM DOO_SALES_CREDITS