The AR table ra_customer_trx_all holds the following info:
Project Number - INTERFACE_HEADER_ATTRIBUTE1
Draft Invoice Number- INTERFACE_HEADER_ATTRIBUTE2
Agreement Number -INTERFACE_HEADER_ATTRIBUTE3
Project Organization -INTERFACE_HEADER_ATTRIBUTE4
Project Manager -INTERFACE_HEADER_ATTRIBUTE5
Another join:
PA_DRAFT_INVOICES_ALL.SYSTEM_REFERENCE = RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID
* The PA_DRAFT_INVOICES_ALL.SYSTEM_REFERENCE will have customer_trx_id.
No comments:
Post a Comment