用友u8 Ua_identity说明
Ua_identity说明
下表是UfSystem..Ua_identity 表中常用记录所对应的数据表及字段，
字段标识
描述
主表字段
子表字段
Rd
收发记录主子表
Rdrecord.id
Rdrecords.autoid
BILLVOUCH
销售发票主子表
SaleBillVouch.SBVID
SaleBillVouchs.autoid
DISPATCH
发货退货单主子表
DispatchList.dlid
DispatchLists.idlsid
POMain
采购订单主子表
PO_Pomain.POID
PO_Podetails.id
SOMain
销售订单主子表
SO_SOMain.id
SO_SODetails.autoid
PURBILL
采购发票主子表
PurBillVouch.PBVID
PurBillVouchs.ID
PURSTID
采购结算单主子表
PurSettleVouch.PSVID
PurSettleVouchs.ID
SETTLEVOUCH
委托代销结算单主子表
SA_SettleVouch.ID
SA_SettleVouchs.Autoid
Ju
出入库调整单主子表
JustInVouch.ID
JustInVouch.Autoid
PUAPP
采购请购单主子表
PU_AppVouch.ID
PU_AppVouchs.Autoid
PUARRIVAL
采购到货单主子表
PU_ArrivalVouch.ID
PU_ArrivalVouchs.Autoid
Tr
库存调拨单主子表
TransVouch.Id
TransVouchs.Autoid
EXPENSE
代垫费用单主子表
ExpenseVouch.ID
ExpenseVouchs.Autoid
Ch
盘点单主子表
CheckVouch.ID
CheckVouchs.Autoid
Ma
限额领料单主子表
MatchVouch.ID
MatchVouchs.Autoid
SALEPAY
销售支出单主子表
SalePayVouch.ID
SalePayVouchs.Autoid
QUOMAIN
销售报价单主子表
SA_QuoMain.ID
SA_QuoDetails.Autoid
XJ
收付款单主子表(销售现结使用)
Ap_CloseBill.ccancelno
Ap_CloseBills.ID
SK
收付款单主子表(收款cCancelNo is null)
Ap_CloseBill.iID
Ap_CloseBills.ID
OM_MO
委外订单主子表
OM_MOMain.Moid
OM_MODetails.MODetailsID
OM_MS
委外结算主子表
OM_MatSettleVouch.MSID
OM_MatSettleVouchs.MSDetailsID
OM_Materials
委外用料表
OM_MOMaterials.MOID
OM_MOMaterials.MOMaterialsID
如果出入库单据出现问题，下面是修改语句
update ufsystem..UA_Identity set ifatherid=( select max(cast(right(id,7) as int)) FROM ufdata_999_2002..RdRecord) WHERE (cAcc_Id = '999') AND (cVouchType = 'rd') update ufsystem..UA_Identity set ichildid=( select max(cast(right(autoid,7) as int)) FROM ufdata_999_2002..RdRecords ) WHERE (cAcc_Id = '999') AND (cVouchType = 'rd') 请参考使用。
其他单据请做适当修改以后，在执行上面语句。
