ERP-PS记账处理步骤

记账处理步骤
1 JXC_CKYE_SSYE_NJ修改还原
USE [cwbase3]
GO
ALTER VIEW [lc0019999].[JXC_CKYE_SSYE_NJ] (
FF_WLBH,FF_CKBH,FF_PCH,FF_HWBH,FF_WLZT,FF_WLBZ,FF_TSKC,FF_XGDX,FF_ZYX1,FF_ZYX2,FF_ZYX3,
FF_ZYX4,FF_ZYX5,FF_SLYE,FF_FSLYE1,FF_FSLYE2,FF_JEYE)
AS
SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5,
SUM(KCCKYE_SLYE),SUM(KCCKYE_FSLYE1),SUM(KCCKYE_FSLYE2),SUM(KCCKYE_JEYE) FROM
(
SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5,
KCCKYE_SLYE,KCCKYE_FSLYE1,KCCKYE_FSLYE2,KCCKYE_JEYE FROM KCCKYE WITH (NOLOCK)
WHERE ( KCCKYE_SLYE>0 OR KCCKYE_SLYE<0)
AND KCCKYE_KJND+KCCKYE_KJQJ=(SELECT MAX(KCCKYE_KJND+KCCKYE_KJQJ) FROM KCCKYE (nolock))
--SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
--KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5,
--KCCKYE_SLYE,KCCKYE_FSLYE1,KCCKYE_FSLYE2,KCCKYE_JEYE FROM KCCKYE_NJ_LS
UNION ALL
SELECT KCRKD2_WLBH KCCKYE_WLBH,KCRKD1_CKBH KCCKYE_CKBH,KCRKD2_PCH KCCKYE_PCH,KCRKD2_HWBH KCCKYE_HWBH,KCRKD2_WLZT KCCKYE_WLZT,KCRKD2_WLBZ KCCKYE_WLBZ,
KCRKD2_TSKC KCCKYE_TSKC,KCRKD2_XGDX KCCKYE_XGDX,KCRKD2_ZYX1 KCCKYE_F1,KCRKD2_ZYX2 KCCKYE_F2,KCRKD2_ZYX3 KCCKYE_F3,KCRKD2_ZYX4 KCCKYE_F4,KCRKD2_ZYX5 KCCKYE_F5,
KCRKD2_SSSL KCCKYE_SLYE,KCRKD2_FSSSL1 KCCKYE_FSLYE1,KCRKD2_FSSSL2 KCCKYE_FSLYE2,KCRKD2_JE KCCKYE_JEYE
FROM KCRKD1 WITH (NOLOCK) ,KCRKD2 WITH (NOLOCK) WHERE KCRKD1_LSBH=KCRKD2_LSBH and KCRKD1_KCYWRQ>(SELECT ISNULL(F_VAL,'') FROM LSCONF WHERE F_VKEY='KC_YJQJ')
AND NOT (KCRKD1_QCBZ='1' AND KCRKD1_ZGBZ='1') AND KCRKD2_PJLX<>'F' and KCRKD1_YWBS<>'G' AND KCRKD1_YWBS<>'I' AND KCRKD1_KCJZ='0' and KCRKD1_SFQR='1'
AND KCRKD1_KCYWRQ>'20250425'
UNION ALL
SELECT KCCKD2_WLBH KCCKYE_WLBH,KCCKD1_CKBH KCCKYE_CKBH,KCCKD2_PCH KCCKYE_PCH,KCCKD2_HWBH KCCKYE_HWBH,KCCKD2_WLZT KCCKYE_WLZT,KCCKD2_WLBZ KCCKYE_WLBZ,
KCCKD2_TSKC KCCKYE_TSKC,KCCKD2_XGDX KCCKYE_XGDX,KCCKD2_ZYX1 KCCKYE_F1,KCCKD2_ZYX2 KCCKYE_F2,KCCKD2_ZYX3 KCCKYE_F3,KCCKD2_ZYX4 KCCKYE_F4,KCCKD2_ZYX5 KCCKYE_F5,
-KCCKD2_SL KCCKYE_SLYE, -KCCKD2_FSL1 KCCKYE_FSLYE1, - KCCKD2_FSL2 KCCKYE_FSLYE2,KCCKD2_JE KCCKYE_JEYE
FROM KCCKD1 WITH (NOLOCK),KCCKD2 WITH (NOLOCK)
WHERE KCCKD1_LSBH=KCCKD2_LSBH and KCCKD1_KCYWRQ>(SELECT ISNULL(F_VAL,'') FROM LSCONF WHERE F_VKEY='KC_YJQJ')
AND KCCKD2_PJLX<>'R' AND KCCKD1_SFQR='1' AND KCCKD1_KCJZ='0' and KCCKD1_SFQR='1'
AND KCCKD1_KCYWRQ>'20250425'
) KC_CKYE
GROUP BY KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5
GO
2 记账
3 执行储存过程
EXEC PROC_核查记账出错
4 JXC_CKYE_SSYE_NJ修改
USE [cwbase3]

GO
ALTER VIEW [lc0019999].[JXC_CKYE_SSYE_NJ] (
FF_WLBH,FF_CKBH,FF_PCH,FF_HWBH,FF_WLZT,FF_WLBZ,FF_TSKC,FF_XGDX,FF_ZYX1,FF_ZYX2,FF_ZYX3,
FF_ZYX4,FF_ZYX5,FF_SLYE,FF_FSLYE1,FF_FSLYE2,FF_JEYE)
AS
SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5,
SUM(KCCKYE_SLYE),SUM(KCCKYE_FSLYE1),SUM(KCCKYE_FSLYE2),SUM(KCCKYE_JEYE) FROM
(
--SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
--KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5,
--KCCKYE_SLYE,KCCKYE_FSLYE1,KCCKYE_FSLYE2,KCCKYE_JEYE FROM KCCKYE WITH (NOLOCK)
--WHERE ( KCCKYE_SLYE>0 OR KCCKYE_SLYE<0)
--AND KCCKYE_KJND+KCCKYE_KJQJ=(SELECT MAX(KCCKYE_KJND+KCCKYE_KJQJ) FROM KCCKYE (nolock))
SELECT KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5,
KCCKYE_SLYE,KCCKYE_FSLYE1,KCCKYE_FSLYE2,KCCKYE_JEYE FROM KCCKYE_NJ_LS
UNION ALL
SELECT KCRKD2_WLBH KCCKYE_WLBH,KCRKD1_CKBH KCCKYE_CKBH,KCRKD2_PCH KCCKYE_PCH,KCRKD2_HWBH KCCKYE_HWBH,KCRKD2_WLZT KCCKYE_WLZT,KCRKD2_WLBZ KCCKYE_WLBZ,
KCRKD2_TSKC KCCKYE_TSKC,KCRKD2_XGDX KCCKYE_XGDX,KCRKD2_ZYX1 KCCKYE_F1,KCRKD2_ZYX2 KCCKYE_F2,KCRKD2_ZYX3 KCCKYE_F3,KCRKD2_ZYX4 KCCKYE_F4,KCRKD2_ZYX5 KCCKYE_F5,
KCRKD2_SSSL KCCKYE_SLYE,KCRKD2_FSSSL1 KCCKYE_FSLYE1,KCRKD2_FSSSL2 KCCKYE_FSLYE2,KCRKD2_JE KCCKYE_JEYE
FROM KCRKD1 WITH (NOLOCK) ,KCRKD2 WITH (NOLOCK) WHERE KCRKD1_LSBH=KCRKD2_LSBH and KCRKD1_KCYWRQ>(SELECT ISNULL(F_VAL,'') FROM LSCONF WHERE F_VKEY='KC_YJQJ')
AND NOT (KCRKD1_QCBZ='1' AND KCRKD1_ZGBZ='1') AND KCRKD2_PJLX<>'F' and KCRKD1_YWBS<>'G' AND KCRKD1_YWBS<>'I' AND KCRKD1_KCJZ='0' and KCRKD1_SFQR='1'
AND KCRKD1_KCYWRQ>'20250425'
UNION ALL
SELECT KCCKD2_WLBH KCCKYE_WLBH,KCCKD1_CKBH KCCKYE_CKBH,KCCKD2_PCH KCCKYE_PCH,KCCKD2_HWBH KCCKYE_HWBH,KCCKD2_WLZT KCCKYE_WLZT,KCCKD2_WLBZ KCCKYE_WLBZ,
KCCKD2_TSKC KCCKYE_TSKC,KCCKD2_XGDX KCCKYE_XGDX,KCCKD2_ZYX1 KCCKYE_F1,KCCKD2_ZYX2 KCCKYE_F2,KCCKD2_ZYX3 KCCKYE_F3,KCCKD2_ZYX4 KCCKYE_F4,KCCKD2_ZYX5 KCCKYE_F5,
-KCCKD2_SL KCCKYE_SLYE, -KCCKD2_FSL1 KCCKYE_FSLYE1, - KCCKD2_FSL2 KCCKYE_FSLYE2,KCCKD2_JE KCCKYE_JEYE
FROM KCCKD1 WITH (NOLOCK),KCCKD2 WITH (NOLOCK)
WHERE KCCKD1_LSBH=KCCKD2_LSBH and KCCKD1_KCYWRQ>(SELECT ISNULL(F_VAL,'') FROM LSCONF WHERE F_VKEY='KC_YJQJ')
AND KCCKD2_PJLX<>'R' AND KCCKD1_SFQR='1' AND KCCKD1_KCJZ='0' and KCCKD1_SFQR='1'
AND KCCKD1_KCYWRQ>'20250425'
) KC_CKYE
GROUP BY KCCKYE_WLBH,KCCKYE_CKBH,KCCKYE_PCH,KCCKYE_HWBH,KCCKYE_WLZT,KCCKYE_WLBZ,
KCCKYE_TSKC,KCCKYE_XGDX,KCCKYE_F1,KCCKYE_F2,KCCKYE_F3,KCCKYE_F4,KCCKYE_F5
GO