如果外系统和NC系统需要交互，但是基础档案又不一样，那就需要配置对照表来将两边的数据进行匹配
今天遇到凭证中的制单人无法翻译，但是在外部信息系统设置处设置了仅按照对照表来翻译，并且在基础信息对照表中也维护了数据，就是无法翻译，一直报错
单据 0001B110000000000O6N1682bfe4d9avouchergl0 开始处理...
(1)单据翻译转换错误:根据基础档案[用户]无法翻译[pk_prepared]字段,待翻译值:yangxiaofang,翻译方式:简单参照翻译器.
单据 0001B110000000000O6N1682bfe4d9avouchergl0 处理错误:单据翻译转换错误:单据校验转换失败
解决方法：外部系统设置处没有问题，最后根源吗发现翻译是根据凭证所属组织和用户编码来对照表查询数据，所以对照表中的所属组织也应该和制单凭证组织相同
查询的sql语句：
select xx_bdcontra.pk_contra as pk_contra,
xx_bdcontra.ts as ts,
xx_bdcontra.dr as dr,
xx_bdcontra.modifier as modifier,
xx_bdcontra.creationtime as creationtime,
xx_bdcontra.pk_org as pk_org,
xx_bdcontra.exsystem as exsystem,
xx_bdcontra.pk_orgtype as pk_orgtype,
xx_bdcontra.modifiedtime as modifiedtime,
xx_bdcontra.bdclass as bdclass,
xx_bdcontra.bdclass2 as bdclass2,
xx_bdcontra.creator as creator
from xx_bdcontra xx_bdcontra
where 0 = 0
and exsystem = '10012A100000000CZLQS'
and bdclass = 'f6f9a473-56c0-432f-8bc7-fbf8fde54fee'
and pk_org = '00012A100000000025IO'