GL追溯子模块的视图.docx

GL追溯子模块的视图已有 181 次阅读2011/10/21 10:21----应收1/*1. 通过 gl_import_reference 表找到来源为应收的记录的 gl_sl_link_id2. 通过 gl_sl_link_id 找到在 xla_ae_lines 表中对应行的 ae_header_id3. 通过 ae_header_id 找到 xla_ae_headers 表中应应的 entity_id4. 通过 entity_id 找到 xla.xla_transaction_entities 表中对应的记录5. 找到 xla.xla_transaction_entities 表中的记录后需要按如下情况分开追溯:? (1). entity_code 为 TRANSACTIONS 和 BILLS_RECEIVABLE 时，表中字段 source_id_int_1 对应的为 ra_customer_trx_all 表中的 customer_trx_id; 字段 security_id_int_1 对应的为 org_id? (2). entity_code 为 ADJUSTMENTS 时，表中字段 source_id_int_1 对应的为 ar_adjustments_all 表中的 adjustment_id; 字段 security_id_int_1 对应的为 org_id? (3). entity_code 为 RECEIPTS 时，表中字段 source_id_int_1 对应的为 ar_cash_receipts_all 表中的 cash_receipt_id; 字段 security_id_int_1 对应的为 org_id? (4). entity_code 为 THIRD_PARTY_MERGE 的情况不会传送至总帐，所以没有追溯。*/Select * From gl_import_references Where je_header_id=2235Select * From xla_ae_lines xal Where xal.gl_sl_link_id=17150Select * From xla_ae_headers? xah Where xah.ae_header_id=15151Select * From xla.xla_transaction_entities? xte Where xte.entity_id=21074Select * From ra_customer_trx_all rct Where rct.customer_trx_id=1415 And rct.org_id=81?----应付1select aca.check_id,aca.check_number,aca.payment_id,gjh.*from gl_je_headers gjh,???? gl_import_references gir,???? xla.xla_transaction_entities xte,???? xla.xla_ae_headers xah,???? ap_checks_all acawhere????? gjh.je_header_id = gir.je_header_id????? and xah.ae_header_id = gir.reference_7????? and xah.entity_id = gir.reference_5????? and xah.event_id = gir.reference_6????? and xah.je_category_name = Payments?????????? and xah.entity_id = xte.entity_id????? and gir.reference_10 is not null????? and xte.source_id_int_1 = aca.check_id????? and aca.check_number = 21?=============================================================--资产FROM XLA_FA_AEL_GL_V XLA_AEL_GL_VWHERE application_id = 140AND je_header_id = 276683FROM XLA_FA_AEL_GL_V XLA_AEL_GL_VWHERE application_id = 140AND je_header_id = 276684--应付FROM XLA_AP_INV_AEL_GL_V XLA_AEL_GL_VWHERE application_id =