金蝶K3付款单代码

最新推荐文章于 2022-08-01 13:41:18 发布

sumeing

最新推荐文章于 2022-08-01 13:41:18 发布

阅读量3.5k

点赞数

分类专栏： SQL Server 金蝶K3二次开发文章标签： join user exchange

本文链接：https://blog.csdn.net/sumeing/article/details/5964417

版权

SELECT t_Currency3.FScale AS FCurrencyID_Decimal,t_currency4.FScale AS FReceiveCyID_Decimal,t_currency5.FScale AS FSettleCyID_Decimal,t_RP_NewReceiveBill.FMulCy,t_RP_NewReceiveBill.FNumber,t_RP_NewReceiveBill.FDate,
t_RP_NewReceiveBill.FFincDate,t_ItemClass.FName AS FItemClassID_DSPName,t_Item.FNumber AS FCustomer_FNDName,t_Item.FName AS FCustomer_DSPName,t_RP_NewReceiveBill.FRPBank AS FRPBank_Pay,t_RP_NewReceiveBill.FBankAcct AS FBankAcct_Pay,
t_Department.FNumber AS FDepartment_FNDName,t_Department.FName AS FDepartment_DSPName,t_Emp.FNumber AS FEmployee_FNDName,t_Emp.FName AS FEmployee_DSPName,t_rp_systemenum.FName AS FBillType_DSPName,t_Settle.FName AS FSettle_DSPName,
t_RP_NewReceiveBill.FSettleNo,t_RP_NewReceiveBill.FExplanation,t_Account.FName AS faccountid_DSPName,t_RP_NewReceiveBill.FRPBank_Pay AS FRPBank,t_RP_NewReceiveBill.FBankAcct_Pay AS FBankAcct,t_RP_NewReceiveBill.FContractNo,
t_Currency3.FName AS FCurrencyID_DSPName,t_RP_NewReceive