Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Payment Source and positon costing Column Query
in HCM Extract
Hi,
I am currently working in a requirement to get the below column
However, I couldn't find the payment reference, source, and position costing and tax reporting unit in the query.
Can anyone help me with this?
Payroll Statutory Unit | Tax Reporting Unit | Payment Status | Payment Source | Payment Type | Payment Method | Prepayment Action ID | Payroll | Person Number | Payroll Relationship Number | First Name | Last Name | Person Name | Payment Reference | Bank Name | Account Number | Account Name | Account Type | Payment Amount | Payment Date | Currency | Position Costing |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Here is the query I am currently working on,
SELECT DISTINCT
PPP.PRE_PAYMENT_ID PRE_PAYMENT_ACTION_ID
Tagged:
0