现金支票(限额)
select
a.BS_DISP_CODE,a.BSI_DISP_CODE,a.BI_DISP_CODE,a.BK_DISP_CODE,a.MK_DISP_CODE,a.MB_DISP_CODE,a.BT_DISP_CODE,a.FILE_DISP_CODE,a.PAY_ACCOUNT_DISP_CODE,a.CLEAR_ACCOUNT_DISP_CODE,a.HOLD1_DISP_CODE,a.HOLD2_DISP_CODE,a.BS_NAME,a.PAY_ID,a.BUDGET_ID,a.PLAN_ID,a.PAY_BILL_ID,a.PAY_BANK_BILL_ID,a.PAY_CENTER_BILL_ID,a.PAY_ACC_BILL_ID,a.PAY_EN_BILL_ID,a.PAY_RECEIVE_BILL_ID,a.PAY_DAY_BILL_ID,a.SUMMARY_CODE,a.SUMMARY_DISP_CODE,a.SUMMARY_NAME AS
REMARK,a.RECEIPT_NAME,a.PAYEE_NAME,a.PAYEE_BANK,a.PAYEE_ACCOUNT,a.IS_END,a.IS_VALID,a.LOCK_USER_CODE,a.LOCK_DATE,a.INPUT_USER,a.SEAL_USER,a.PRINT_DATE,a.LATEST_OP_DATE,a.LATEST_OP_USER,a.PAY_DETAIL_BILL_ID,a.OLD_PAY_ID,a.SUM_ACC_VOU_FLAG,a.PAY_ACC_VOU_FLAG,a.CLEAR_ACC_VOU_FLAG,a.EN_ACC_VOU_FLAG,a.SET_YEAR,a.EN_CODE,a.BS_CODE,a.BSI_CODE,a.BI_CODE,a.BK_CODE,a.BO_CODE,a.PK_CODE,a.MK_CODE,a.MB_CODE,a.BT_CODE,a.FILE_CODE,a.HOLD1_CODE,a.HOLD2_CODE,a.HOLD3_CODE,a.EN_DISP_CODE,a.BSI_NAME,a.BI_NAME,a.BK_NAME,a.BO_NAME,a.PK_NAME,a.BT_NAME,a.FILE_NAME,a.PAY_ACCOUNT_NAME,a.HOLD1_NAME,a.HOLD2_NAME,a.HOLD3_NAME,a.CLEAR_BANK_CODE,a.CLEAR_BANK_DISP_CODE,a.CLEAR_BANK_NAME,a.PAY_BANK_CODE,a.PAY_BANK_DISP_CODE,a.PAY_BANK_NAME,a.PAY_MONEY,a.PAY_MODE_CODE,a.PAY_MODE_DISP_CODE,a.PA_DISP_CODE,a.PA_NAME,a.INPUT_DATE,a.PAY_DATE,a.ACCESSORY_NUMBER,a.PAY_ACCOUNT_CODE,a.CLEAR_ACCOUNT_CODE,a.BO_DISP_CODE,a.PK_DISP_CODE,a.HOLD3_DISP_CODE,a.EN_NAME,a.MK_NAME,a.MB_NAME,a.CLEAR_ACCOUNT_NAME,a.PAY_MODE_NAME,a.PA_CODE,a.RECEIPT_CODE,a.RECEIPT_DISP_CODE,a.EDITOR_CODE,a.EDITOR_NAME,mid(a.bs_disp_code,1,lei) as
lei_code,mid(a.bs_disp_code,lei+1,2) as kuan_code,mid(a.bs_disp_code,lei+3,2) as xiang_code,(select d.ACCOUNT_NO from BANK_ACCOUNT_PAY d where
d.in_code=a.pay_account_code and d.set_year=a.set_year) as new_account_no, (select b.disp_name from budget_subject b where
b.disp_code=mid(a.bs_disp_code,1,iif(a.set_year <= 2006, 2, 3)) and b.set_year=a.set_year and len(b.disp_code)=iif(a.set_year <= 2006, 2, 3)) as lei_name, (select b.disp_name from budget_subject b where
b.disp_code=mid(a.bs_disp_code,1,iif(a.set_year <= 2006, 4, 5)) and b.set_year=a.set_year and len(b.disp_code)=iif(a.set_year <= 2006, 4, 5)) as kuan_name ,(select b.disp_name from budget_subject b where
b.disp_code=mid(a.bs_disp_code,1,iif(a.set_year <= 2006, 6, 7)) and b.set_year=a.set_year and len(b.disp_code)=iif(a.set_year <= 2006, 6, 7)) as xiang_name,(select c.disp_name from enterprise c where c.in_code=mid(a.en_code,1,3) and a.set_year=c.set_year) as yiji_name,iif(a.bk_disp_code not like '007%',iif(a.bk_disp_code like '006%','1','3'),'2') as
my_bk_code,a.set_year,iif(a.set_year <= 2006, 2, 3) as lei from pay a where a.pay_bill_id in (:Cur_ID)