SELECT ACCOUNTCODE,PERIODV,NOV,YEARV,LOCALCREDITAMOUNT,LOCALDEBITAMOUNT,EXPLANATION,PK_VOUCHERTYPEV,ASSID,PK_DETAIL,PK_ACCOUNTINGBOOK,PK_ORG,PK_ACCASOA ,(SELECT NAME FROM ORG_CORP WHERE GL_DETAIL.PK_ORG=ORG_CORP.PK_CORP and NAME='A公司') as 财务组织,(SELECT NAME from BD_VOUCHERTYPE WHERE GL_DETAIL.PK_VOUCHERTYPEV=BD_VOUCHERTYPE.PK_VOUCHERTYPE) as 凭证类别,(SELECT FILE_ID from V_GL_DETAIL WHERE GL_DETAIL.PK_DETAIL= V_GL_DETAIL.PK_DETAIL) as 数据交换平台传递编号 FROM GL_DETAIL LEFT JOIN GL_DOCFREE1 WHERE GL_DETAIL.ASSID=GL_DOCFREE1.ASSID |