1. ae_line_id(AE行ID):该字段是xla_ae_lines表中的主键,用于唯一标识每一行数据。它的数据类型是数字型,通常采用自增长方式生成。 2. ae_header_id(AE头ID):这个字段是关联的AE头表的外键,用于将AE交易行与相应的AE交易头关联起来。它的数据类型也是数字型。 3. accounting_class_code(会计分类
Object type: TABLE Tablespace: Default Primary Key Name Columns XLA_AE_LINES_GT_PK LEDGER_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID, HEADER_NUM Columns NameDatatypeLengthPrecisionNot-nullComments AE_HEADER_ID NUMBER 18 Yes Subledger journal entry identifier. TEMP_LINE_NUM NUMBER...
Once the entire accounting entry has been processed, the data in this table is grouped together and then transferred to the XLA_AE_LINES table. The grouping is done by updating the REF_LINE_NUM, ENTERED_DR_SUM, ENTERED_CR_SUM, ACCOUNTED_DR_SUM, ACCOUNTED_CR_SUM, UNROUNDED_ENTERED_DR_SUM...
We can see a records created in XLA_AE_LINES for it.We were expecting to see the columns XLA_AE_LINES .source_table to be populated with ('AP_INVOICES' or 'AP_INVOICE_DISTRIBUTIONS') and XLA_AE_LINES.source_id to be populated with INVOICE_ID. Other column have values like below : ...
GL_JE_LINES (je_header_id, je_line_num) => GL_IMPORT_REFERENCES (je_header_id, je_line_num) ; GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id) => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id) ; XLA_AE_LINES (application_id, ae_header_id) => XLA_AE_HEADERS (...
--ap_invoice_distributions_all到xla_ae_lines. 到了XLA_AE_LINES后,会by科目和描述汇总.所以,不能一对一 selectc.code_combination_id, h.je_header_id, l.ae_header_id, l.ae_line_num, te.source_id_int_1, te.application_id, te.entity_id, ...
--ap_invoice_distributions_all到xla_ae_lines. 到了XLA_AE_LINES后,会by科目和描述汇总.所以,不能一对一 selectc.code_combination_id, h.je_header_id, l.ae_header_id, l.ae_line_num, te.source_id_int_1, te.application_id, te.entity_id, ...
Oracle Payables - Version 12.0.0 and later: Xla_ae_lines_pkg.BusinessFlowPriorEntries. ORA-01403: No Data Found.
29 Oancea AE, Berru M, Shulman MJ. Expression of the (recombi- nant) endogenous immunoglobulin heavy-chain locus requires the intronic matrix attachment regions. Mol Cell Biol 1997; 17: 2658–2668. 30 Jenuwein T, Forrester WC, Fernandez-Herrero LA, Laible G, Dull M, Grosschedl R. ...
AE3 AC10 AC13 AE19 AB24 V24 N24 J24 M36 V8 BG432- XLA and XL devices in the BG432 package have 352 I/O pins. The XC4000XV devices allocate 16 of these I/O pins to VCCINT (2.5V). V36 P77 AF8 P55 B4 AF36 AM8 AM36 AT12 AT18 AT26 ...