What's new in Customer Journeys?

Connect and learn more! ×
EXP_EXPENSE Tables link between AP_INVOICE_DISTRIBUTIONS_ALL — Cloud Customer Connect
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

Question
56
Views
0
Comments
edited Nov 2, 2023 4:15PM in Expenses

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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