| 123456789101112131415161718 |
- SELECT
- O.PERIOD_NUM AS 结算期数,
- O.SN AS 业绩单编号,
- O.DEC_TYPE AS 业绩单类型,
- O.LAST_STATUS AS 业绩单状态,
- U.USER_NAME AS 会员编号,
- U.REAL_NAME AS 会员姓名,
- O.LAST_REC_USER_NAME AS 结算时开拓者编号,
- O.LAST_REC_REAL_NAME AS 结算时开拓者姓名,
- O.PV AS 报单PV,
- O.DEC_AMOUNT AS 报单金额,
- O.LAST_DEC_SUB_COM_ID AS 报单编号,
- O.CREATED_AT AS 创建时间
- FROM
- AR_PERF_ORDER O
- LEFT JOIN AR_USER U ON U.ID = O.USER_ID
- WHERE
- O.PERIOD_NUM = 156
|
