会计期间脚本

来源：互联网发布：吉他工厂店淘宝编辑：程序博客网时间：2024/04/28 00:10

--库存会计期
SELECT STATUS
      ,PERIOD_NAME
      ,PERIOD_NUMBER
      ,PERIOD_YEAR
      ,START_DATE
      ,END_DATE
      ,CLOSE_DATE
      ,REC_TYPE
      ,ORGANIZATION_ID
      ,ACCT_PERIOD_ID
      ,ROW_ID
      ,ACCOUNTED_PERIOD_TYPE
      ,PERIOD_SET_NAME
      ,LAST_UPDATE_DATE
      ,CREATION_DATE
      ,LAST_UPDATED_BY
      ,CREATED_BY
      ,LAST_UPDATE_LOGIN
FROM ORG_ACCT_PERIODS_V
WHERE (REC_TYPE = 'ORG_PERIOD' AND ORGANIZATION_ID = 4942)

--采购与总账会计期

SELECT ROW_ID
      ,APPLICATION_ID
      ,SET_OF_BOOKS_ID
      ,CLOSING_STATUS
      ,SHOW_STATUS
      ,PERIOD_NAME
      ,PERIOD_NUM
      ,PERIOD_YEAR
      ,START_DATE
      ,END_DATE
      ,LAST_UPDATED_BY
      ,LAST_UPDATE_DATE
      ,CREATION_DATE
      ,PERIOD_TYPE
      ,QUARTER_NUM
      ,ADJUSTMENT_PERIOD_FLAG
      ,CREATED_BY
      ,LAST_UPDATE_LOGIN
      ,ATTRIBUTE1
      ,ATTRIBUTE2
      ,ATTRIBUTE3
      ,ATTRIBUTE4
      ,ATTRIBUTE5
      ,CONTEXT
FROM GL_PERIOD_STATUSES_V
WHERE APPLICATION_ID = 101
   AND SET_OF_BOOKS_ID = 143
   AND CLOSING_STATUS != 'N'
   AND (PERIOD_NAME = 'Feb-12')
ORDER BY PERIOD_YEAR DESC
         ,PERIOD_NUM DESC