Home  >  Article  >  Database  >  报表标准参数值集

报表标准参数值集

WBOY
WBOYOriginal
2016-06-07 15:23:201259browse

报表标准参数集 1、期间集:GL_SRS_OPEN_PERIODS --打开的期间集:GL_SRS_ALL_PERIODS --所有期间 2、chart_of_account_id集:GL_SRS_COA_ID_BYSOB集:GL_SRS_COA_UNVALIDATED默认类型:SQL 语句默认:SELECT chart_of_accounts_id FROM gl_sets_of_books WHE

 报表标准参数值集
1、期间 值集:GL_SRS_OPEN_PERIODS --打开的期间 值集:GL_SRS_ALL_PERIODS --所有期间
2、chart_of_account_id 值集:GL_SRS_COA_ID_BYSOB 值集:GL_SRS_COA_UNVALIDATED 默认类型:SQL 语句 默认值:SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = :$PROFILES$.GL_SET_OF_BKS_ID
3、账户 值集:GL_SRS_LEDGER_FLEXFIELD需要COA值集:GL_SRS_COA_UNVALIDATED的值
4、YES/NO 值集:IBY_YES_NO 说明:Y = Yes, N = No
5、时间 带时分秒:FND_STANDARD_DATETIME 不带时分秒:FND_STANDARD_DATE

持续更新中……


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:存储过程的简单应用Next article:csv文件导入数据库