用友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') 请参考运用。

其他单据请做适当修正今后，在履行上面句子。