用友11.1 rdrecords32 表最大单据号问题

DAISOU8

因为U8 10.1以上的Rdrecords细分成了几张表，请问这几张表的最大单据号要怎么改？

下面语句是只适用8.9以下：

update ua_identity set ifatherid=(select max(id) fromufdata_883_2008..rdrecord where cacc_id='883')

update ua_identity set ichildid=(select max(autoid)from ufdata_883_2008..rdrecords where cacc_id='883')

10.1或11.1以上的
Rdrecords1
Rdrecords9
....
Rdrecords32 呢，需要怎么改？
有哪位高手赐教下.

DAISOU8

select MAX(id)

from (select MAX(id) as id from RdRecord01 union

select MAX(id) as id from RdRecord08 union

select MAX(id) as id from RdRecord09 union

select MAX(id) as id from rdrecord10 union

select MAX(id) as id from rdrecord11 union

select MAX(id) as id from rdrecord32 union

select MAX(id) as id from rdrecord34)t


select MAX(autoid)

from (select MAX(autoid) as autoid from RdRecords01 union

select MAX(autoid) as autoid from RdRecords08 union

select MAX(autoid) as autoid from RdRecords09 union

select MAX(autoid) as autoid from rdrecords10 union

select MAX(autoid) as autoid from rdrecords11 union

select MAX(autoid) as autoid from rdrecords32 union

select MAX(autoid) as autoid from rdrecords34)t

独孤厚冰

没有语句，怕语句整错的情况下，其实对于表ua_identity里面的id都增加一位数也是可行的

cldzyc

最大单据号不可以在系统单号设置里设置吗？