Uaidentity 数据表及字段.docx
《Uaidentity 数据表及字段.docx》由会员分享，可在线阅读，更多相关《Uaidentity 数据表及字段.docx（9页珍藏版）》请在冰豆网上搜索。
Uaidentity数据表及字段
UfSystem..Ua_identity表中常用记录所对应的数据表及字段UfSystem..Ua_identity表中常用记录所对应的数据表及字段
字段标识
Rd
BILLVOUCH
DISPATCH
POMain
SOMain
PURBILL
PURSTID描述
收发记录主子表
销售发票主子表
发货退货单主子表
采购订单主子表主表字段
Rdrecord.id
SaleBillVouch.SBVID
DispatchList.dlid
PO_Pomain.POID
SO_SOMain.id
PurBillVouch.PBVID
PurSettleVouch.PSVID
SA_SettleVouch.ID
JustInVouch.ID
PU_AppVouch.ID
PU_ArrivalVouch.ID
TransVouch.Id
ExpenseVouch.ID
CheckVouch.ID
MatchVouch.ID
SalePayVouch.ID
SA_QuoMain.IDxx表字段
Rdrecords.autoidSaleBillVouchs.autoidDispatchLists.idlsidPO_Podetails.idSO_SODetails.autoidPurBillVouchs.IDPurSettleVouchs.IDSA_SettleVouchs.AutoidJustInVouch.AutoidPU_AppVouchs.AutoidPU_ArrivalVouchs.AutoidTransVouchs.AutoidExpenseVouchs.AutoidCheckVouchs.AutoidMatchVouchs.AutoidSalePayVouchs.AutoidSA_QuoDetails.Autoid销售订单主子表
采购发票主子表
采购结算单主子表
委托代销结算单主子
SETTLEVOUCH表Ju出入库调整单主子表
PUAPP采购请购单主子表
PUARRIVAL采购到货单主子表
Tr库存调拨单主子表
EXPENSE代垫费用单主子表
Ch
Ma
SALEPAY
QUOMAIN
XJ盘点单主子表
限额领料单主子表
销售支出单主子表
销售报价单主子表
收付款单主子表
（销售现结使用）
收付款单主子表
（收款cCancelNois
null）
委外订单主子表Ap_CloseBill.ccancelnoAp_CloseBills.IDSK
OM_MOAp_CloseBill.iID
OM_MOMain.MoidAp_CloseBills.IDOM_MODetails.MODetailsIDOM_MS委外结算主子表
OM_Materials委外用料表
PUPRICE供应商调价单OM_MatSettleVouch.MSIDOM_MatSettleVouchs.MSDetailsIDOM_MOMaterials.MOIDOM_MOMaterials.MOMaterialsIDPU_PricejustmainPu_Pricejustdetail如果出入库单据出现问题，下面是修改语句
updateufsystem..UA_Identitysetifatherid=（selectmax（cast（right（id,7）asint））FROMufdata_999_
2002..RdRecord）WHERE（cAcc_Id='999'）AND（cVouchType='rd'）updateufsystem..UA_Identitysetichildid=（selectmax（cast（right（autoid,7）asint））FROMufdata_999_
2002..RdRecords）WHERE（cAcc_Id='999'）AND（cVouchType='rd'）请参考使用。
其他单据请做适当修改以后，在执行上面语句。
用友修改最大单据号SQL大全
ufsystem..ua_identity字段标识描述主表字段子表字段
Rd收发记录主子表Rdrecord.idRdrecords.autoid
BILLVOUCH销售发票主子表SaleBillVouch.SBVIDSaleBillVouchs.autoidDISPATCH发货退货单主子表DispatchList.dlidDispatchLists.idlsid
POMain采购订单主子表PO_Pomain.POIDPO_Podetails.id
SOMain销售订单主子表SO_SOMain.idSO_SODetails.autoid
PURBILL采购发票主子表PurBillVouch.PBVIDPurBillVouchs.ID
PURSTID采购结算单主子表PurSettleVouch.PSVIDPurSettleVouchs.IDSETTLEVOUCH委托代销结算单主子表
SA_SettleVouch.IDSA_SettleVouchs.Autoid
Ju出入库调整单主子表JustInVouch.IDJustInVouch.Autoid
PUAPP采购请购单主子表PU_AppVouch.IDPU_AppVouchs.Autoid
PUARRIVAL采购到货单主子表PU_ArrivalVouch.IDPU_ArrivalVouchs.AutoidTr库存调拨单主子表TransVouch.IdTransVouchs.Autoid
EXPENSE代垫费用单主子表ExpenseVouch.IDExpenseVouchs.AutoidCh盘点单主子表CheckVouch.IDCheckVouchs.Autoid
Ma限额领料单主子表MatchVouch.IDMatchVouchs.Autoid
SALEPAY销售支出单主子表SalePayVouch.IDSalePayVouchs.AutoidQUOMAIN销售报价单主子表SA_QuoMain.IDSA_QuoDetails.AutoidXJ收付款单主子表（销售现结使用）Ap_CloseBill.ccancelnoAp_CloseBills.IDSK收付款单主子表（收款cCancelNoisnull）Ap_CloseBill.iIDAp_CloseBills.IDOM_MO委外订单主子表OM_MOMain.MoidOM_MODetails.MODetailsIDOM_MS
委外结算主子表
OM_MatSettleVouch.MSIDOM_MatSettleVouchs.MSDetailsID
OM_Materials委外用料表
OM_MOMaterials.MOIDOM_MOMaterials.MOMaterialsID
下面是对应的更新语句
以002账套2010年度数据为例
updateufsystem..ua_identitySetiFatherId=（SelectMax（ID）AsIDFromUFDATA_002_
2010..RdRecord）,
iChildId=（SelectMax（AutoID）AsAutoIDFrom
UFDATA_002_
2010..RdRecords）
WherecAcc_Id='002'AndcVouchType='rd'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（dlID）AsIDFromUFDATA_002_
2010..DISPATCHlist）,
iChildId=（SelectMax（AUTOID）AsAutoIDFrom
UFDATA_002_
2010..DISPATCHlists）
WherecAcc_Id='002'AndcVouchType='dispatch'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（SBVID）AsIDFromUFDATA_002_
2010..SaleBillVouch）,
iChildId=（SelectMax（AutoID）AsAutoIDFrom
UFDATA_002_
2010..SaleBillVouchs）
WherecAcc_Id='002'AndcVouchType='billvouch'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（poid）AsIDFromUFDATA_002_
2010..po_POMain）,
iChildId=（SelectMax（id）AsAutoIDFromUFDATA_002_
2010..po_podetails）WherecAcc_Id='002'AndcVouchType='POMain'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..JustInVouch）,
iChildId=（SelectMax（autoid）AsAutoIDFrom
UFDATA_002_
2010..JustInVouchs）
WherecAcc_Id='002'AndcVouchType='ju'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..PU_ArrivalVouch）,
iChildId=（SelectMax（autoid）AsAutoIDFrom
UFDATA_002_
2010..PU_ArrivalVouchs）
WherecAcc_Id='002'AndcVouchType='puarrival'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..PU_ArrivalVouch）,
iChildId=（SelectMax（autoid）AsAutoIDFrom
UFDATA_002_
2010..PU_ArrivalVouchs）
WherecAcc_Id='002'AndcVouchType='puarrival'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..PU_AppVouch）,
iChildId=（SelectMax（autoid）AsAutoIDFrom
UFDATA_002_
2010..PU_AppVouchs）
WherecAcc_Id='002'AndcVouchType='puapp'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（pbvid）AsIDFromUFDATA_002_
2010..PurBillVouch）,
iChildId=（SelectMax（id）AsAutoIDFromUFDATA_002_
2010..PurBillVouchs）WherecAcc_Id='002'AndcVouchType='purbill'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（psvid）AsIDFromUFDATA_002_
2010..PurSettleVouch）,
iChildId=（SelectMax（id）AsAutoIDFrom
UFDATA_002_
2010..PurSettleVouchs）
WherecAcc_Id='002'AndcVouchType='PURSTID'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..SA_QuoMain）,
iChildId=（SelectMax（autoid）AsAutoIDFrom
UFDATA_002_
2010..SA_Quodetails）
WherecAcc_Id='002'AndcVouchType='QUOMAIN'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..SO_SOMain）,
iChildId=（SelectMax（isosid）AsisosidFrom
UFDATA_002_
2010..SO_SOdetails）
WherecAcc_Id='002'AndcVouchType='somain'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（iid）AsIDFromUFDATA_002_
2010..Ap_CloseBill）,
iChildId=（SelectMax（id）AsAutoIDFromUFDATA_002_
2010..Ap_CloseBills）WherecAcc_Id='002'AndcVouchType='sk'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..TransVouch）,
iChildId=（SelectMax（autoid）AsAutoIDFrom
UFDATA_002_
2010..TransVouchs）
WherecAcc_Id='002'AndcVouchType='tr'
go
updateufsystem..ua_identitySetiFatherId=（SelectMax（id）AsIDFromUFDATA_002_
2010..ExpenseVouch）,
iChildId=（SelectMax（autoid）AsAutoIDFrom
UFDATA_002_
2010..ExpenseVouchS）
WherecAcc_Id='002'AndcVouchType='EXPENSE'
go
升级会员 