提交或暂存时,单据自动生成编号规则为:BFT+2位年份+4位月日+4位编号,例如BFT1902120001
select
'BFT' || to_char(SYSDATE, 'yymmdd') ||
(select lpad(decode(max(substr(t.RECEIPT_NUM, 10,4)),null,0,max(substr(t.RECEIPT_NUM, 10, 4))) + 1,4,'0')
from
T_COST_SHARING_BILLING_MAIN t
where
substr(t.RECEIPT_NUM, 1, 9) = 'BFT' || to_char(SYSDATE, 'yymmdd'))
from dual