公用-运维项目

导出工程公司（1069-1075）1月实物采购应付账务

select a.pk_id,a.company_code,a.form_no,a.voucher_num,a.FISCAL_PERIOD,a.POST_DATE,a.ACCOUNTING_YEAR,a.ACCOUNT_TITLE_CODE,a.ACCOUNT_TITLE_NAME,a.DEBIT_AMOUNT,a.CREDIT_AMOUNT,a.CURRENCY_AMOUNT,a.DC_DIRECT_ENUM_ID,a.SHOW_NUM,a.VOUCHER_TEXT,a.LINE_PROJECT_TEXT from t_fssc_account_process a
LEFT JOIN t_ap_public_apply_payment b on a.form_no = b.form_no
where b.APPLY_BIZ_TYPE_CODE = 'PUBLIC_APPLY_PAYMENT_INVOICEPAYMENTANDOFFSET_PO-GOODS'
and a.voucher_type = '转' and a.voucher_num <> '' and a.voucher_num is not null
and a.company_code in ('1069','1070','1071','1072','1073','1074','1075')
and a.FISCAL_PERIOD = '202501'
order by a.form_no

工程公司（1069-1075）1月实物采购应付账务对应入库单
select  h.OFFSET_NO,h.COMPANY_CODE,h.MATERIAL_VOUCHER_NO,h.MATERIAL_ACCOUNT_YEAR,MATERIAL_VOUCHER_LINE_NO,h.MATERIAL_CODE,CURRENT_PO_QTY,TAX_AMOUNT,AMOUNT ,INCLUDE_TAX_AMOUNT, 
CURRENT_PO_QTY 本次请款数量,CURRENT_OFFSET_AMOUNT 本次请款金额不含税,CURRENT_OFFSET_INCLUDE_TAX_AMOUNT  本次请款金额含税
from t_offset_sap_po_goods_offset_his h where h.OFFSET_NO in (
select a.form_no from  t_fssc_account_process a
LEFT JOIN t_ap_public_apply_payment b on a.form_no = b.form_no 
where b.APPLY_BIZ_TYPE_CODE = 'PUBLIC_APPLY_PAYMENT_INVOICEPAYMENTANDOFFSET_PO-GOODS'
and a.voucher_type = '转' and a.voucher_num <> '' and a.voucher_num is  not null 
and a.company_code in ('1069','1070','1071','1072','1073','1074','1075')
and a.FISCAL_PERIOD = '202501'
 order by a.form_no
)

1069-1075公司入库日期在1月的入库单数据
select * from t_offset_sap_po_goods_offset a where VOUCHER_DATE like '2025-01%' and company_code in ('1069','1070','1071','1072','1073','1074','1075')

导出工程公司（1069-1075）12月实物采购应付账务

select a.pk_id,a.company_code,a.form_no,b.TAIL_AMOUNT,a.voucher_num,a.FISCAL_PERIOD,a.POST_DATE,a.ACCOUNTING_YEAR,a.ACCOUNT_TITLE_CODE,a.ACCOUNT_TITLE_NAME,a.DEBIT_AMOUNT,a.CREDIT_AMOUNT,a.CURRENCY_AMOUNT,a.DC_DIRECT_ENUM_ID,a.SHOW_NUM,a.VOUCHER_TEXT,a.LINE_PROJECT_TEXT from t_fssc_account_process a
LEFT JOIN t_ap_public_apply_payment b on a.form_no = b.form_no
where b.APPLY_BIZ_TYPE_CODE = 'PUBLIC_APPLY_PAYMENT_INVOICEPAYMENTANDOFFSET_PO-GOODS'
and a.voucher_type = '转' and a.voucher_num <> '' and a.voucher_num is not null
and a.company_code in ('1069','1070','1071','1072','1073','1074','1075')
and a.FISCAL_PERIOD = '202501'
order by a.form_no

工程公司（1069-1075）12月实物采购应付账务对应入库单
select  h.OFFSET_NO
, ROW_NUMBER() OVER (PARTITION BY h.OFFSET_NO ORDER BY h.PK_ID) AS row_num
,b.TAIL_AMOUNT,h.COMPANY_CODE,h.MATERIAL_VOUCHER_NO,h.MATERIAL_ACCOUNT_YEAR,MATERIAL_VOUCHER_LINE_NO,h.MATERIAL_CODE,CURRENT_PO_QTY,TAX_AMOUNT,AMOUNT ,INCLUDE_TAX_AMOUNT, 
CURRENT_PO_QTY 本次请款数量,CURRENT_OFFSET_AMOUNT 本次请款金额不含税,CURRENT_OFFSET_INCLUDE_TAX_AMOUNT  本次请款金额含税

from t_offset_sap_po_goods_offset_his h
left join t_ap_public_apply_payment b on h.OFFSET_NO = b.FORM_NO
where h.OFFSET_NO in (
select a.form_no from t_fssc_account_process a
LEFT JOIN t_ap_public_apply_payment b on a.form_no = b.form_no
where b.APPLY_BIZ_TYPE_CODE = 'PUBLIC_APPLY_PAYMENT_INVOICEPAYMENTANDOFFSET_PO-GOODS'
and a.voucher_type = '转' and a.voucher_num <> '' and a.voucher_num is not null
and a.company_code in ('1069','1070','1071','1072','1073','1074','1075')
and a.FISCAL_PERIOD = '202501'

) order by h.OFFSET_NO,h.PK_ID