Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

EXP_EXPENSE Tables link between AP_INVOICE_DISTRIBUTIONS_ALL

edited Nov 2, 2023 4:15PM in Expenses 1 comment

Summary:

EXP_EXPENSE Tables link between AP_INVOICE_DISTRIBUTIONS_ALL

Content (please ensure you mask any confidential information):

Hi,


We have Employee expenses in the below tables:

exm_expense_reports eer,

EXM_EXPENSES ee,

exm_expense_templates ET,

exm_expense_types eet,

EXM_EXPENSE_DISTS eed,


Now we need to join one of above table to ap_invoice_distributions_all table to get the distribution_id and later on we will join invoice_id and Invoice_distributoin_id to get expenditure_item_id from pjc_exp_items_all table.


Regards,


Zahid Rahim


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!