1.查看各数据表名
select * from t_tabledescription
WHERE FDescription LIKE '%生产任务单%'
2.查看某单据表的字段名
SELECT B1.*
FROM ICTranSactionType A1
LEFT JOIN ICTemplateEntry B1 ON A1.FTemplateID=B1.FID
WHERE A1.FName like '%产品入库%'
3.查看对应数据表的单据类型编号
SELECT FID,FHeadTable, FBillPOSHeadTable, *
FROM ICTransactionType
WHERE FName LIKE '%生产任务单%'