用友軟件各種單據(jù)最大單據(jù)號(hào)的解決方法

1、發(fā)貨單

* dbo.UA_Identity
set ifatherid=(* Max(Cast(right(isnull(DLid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..
dispatchlist),
ICHILDID=(* Max(Cast(right(isnull(aoutoid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..dispatchlists) WHERE

(CVOUCHTYPE=*dispatch* AND CACC_ID=*006*)

2、委托代銷(xiāo)結(jié)算單

* dbo.UA_Identity
set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
UFDATA_006_2012..
SA_SETTLEVOUCH),
ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..SA_SETTLEVOUCHS) WHERE

(CVOUCHTYPE=*SETTLEVOUCH* AND CACC_ID=*006*)

3、調(diào)撥單

* dbo.UA_Identity
set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
UFDATA_006_2012..
transvouch),
ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..transvouchs) WHERE (CVOUCHTYPE=*tr*

AND CACC_ID=*006*)

4,出入庫(kù)單

* dbo.UA_Identity
set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
UFDATA_006_2012..
rdrecord32),
ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..rdrecords32) WHERE (CVOUCHTYPE=*rd*

AND CACC_ID=*006*)

5、銷(xiāo)售發(fā)票

* dbo.UA_Identity
set ifatherid=(* Max(Cast(right(isnull(sbvid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..
salebillvouch),
ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..salebillvouchs) WHERE

(CVOUCHTYPE=*billvouch* AND CACC_ID=*006*)

6、銷(xiāo)售訂單

* UA_Identity
set ifatherid=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
UFDATA_006_2012..SO_SOMAIN),
ICHILDID=(* Max(Cast(right(isnull(AUTOid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..SO_SODetails) WHERE

(CVOUCHTYPE=*SOMAIN* AND CACC_ID=*006*)

7、采購(gòu)訂單

* UA_Identity
set ifatherid=(* Max(Cast(right(isnull(cPOid,0),7) AS INT))AS ID FROM
UFDATA_006_2012..PO_POMAIN),
ICHILDID=(* Max(Cast(right(isnull(id,0),7) AS INT))AS ID FROM
UFDATA_006_2012..PO_PODetails) WHERE (CVOUCHTYPE=*POMAIN*

AND CACC_ID=*006*)