金蝶K3付款单代码

 

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