﻿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