在SLA中技术方面最常用的就是日记帐来源追溯,在追溯的过程中从GL到SLA和11i差别不大, 使通过gl_import_references表来进行,该表的je_batch_id,je_header_id,je_line_num 是和GL关联,该表字段gl_sl_link_id是和SLA中的行表(XLA_AE_LINES)关联, 在SLA中重要的几张表如下: xla_transaction_entities:The ta...
GL_JE_LINES_PK JE_HEADER_ID, JE_LINE_NUM Columns NameDatatypeLengthPrecisionNot-nullCommentsFlexfield-mapping JE_HEADER_ID NUMBER 18 Yes Journal entry header defining column. JE_LINE_NUM NUMBER 18 Yes Line on the supplier's response. LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the...
51CTO博客已为您找到关于GL_JE_LINES的相关内容,包含IT学习相关文档代码介绍、相关教程视频课程,以及GL_JE_LINES问答内容。更多GL_JE_LINES相关解答可以来51CTO博客参与分享和学习,帮助广大IT技术人实现成长和进步。
VRM_EBIZ_GL_JE_HDR_LINES gl_code_combinations CODE_COMBINATION_ID Indexes IndexUniquenessTablespaceColumns VRM_EBIZ_GL_JE_HDR_LINES_N1 Non Unique FUSION_TS_TX_DATA PERIOD_NAME, JE_SOURCE, JE_HEADER_STATUS VRM_EBIZ_GL_JE_HDR_LINES_U1 Unique FUSION_TS_TX_DATA JE_HEADER_ID, JE_LINE_NUM,...
GL_JE_LINES contains the journal entry lines that you enter in the Enter Journals form. There is a one-to-many relationship between journal entries and journal entry lines. Each row in this table stores the associated journal entry header ID, the line nu
GL_JE_LINES_RECON_PK JE_HEADER_ID, JE_LINE_NUM Columns NameDatatypeLengthPrecisionNot-nullComments JE_HEADER_ID NUMBER 18 Yes Journal entry header defining column. JE_LINE_NUM NUMBER 18 Yes Journal entry line number. Foreign composite key to GL_JE_LINES. LEDGER_ID NUMBER 18 Yes Ledger ide...
VRM_EBIZ_GL_JE_HDR_LINES gl_code_combinations CODE_COMBINATION_ID Indexes IndexUniquenessTablespaceColumns VRM_EBIZ_GL_JE_HDR_LINES_N1 Non Unique FUSION_TS_TX_DATA PERIOD_NAME, JE_SOURCE, JE_HEADER_STATUS VRM_EBIZ_GL_JE_HDR_LINES_U1 Unique FUSION_TS_TX_DATA JE_HEADER_ID, JE_LINE_NUM,...