I found it, hope that help someone else: TABLE.COLUMN: rbsa.name nome_origem JOIN: rcta.batch_source_seq_id = rbsa.batch_source_seq_id

Excited to learn more about Accelerated Dashboard Creation

@MandeepGupta, This worked perfectly, thank you very much for your help, it was crucial to my analysis.

Hi @MandeepGupta, Indeed, the table you mentioned has the necessary columns, but I couldn't link them to any, and when trying with this join, it doesn't return any data: vJOIN XLE_REGISTRATIONS xl ON xl.location_id = hla.location_id OR JOIN XLE_REGISTRATIONS xl ON ti.FINAL_DISCHARGE_LOCATION_ID

Thank you guys for the help, apreciate that.

Yeah, it works for the "FINAL_DISCHARGE_LOCATION_ID" in my first query, like this: JOIN hr_locations_all hla ON hla.location_id = ti.FINAL_DISCHARGE_LOCATION_ID -- Adicionando o join com hr_locations_all But i still miss the Brazilian company registration number. That is composed with 14 characteres, like this:…

I need the description of: jfdla.bill_to_location_id jfdla.final_discharge_location_id

No, rcta.attribute15 and inv.organization_name are my descriptions. I need to find the municipality where the branch is established, the Brazilian company registration number (similar to a tax ID for businesses), and the final unloading location (where the service was provided).

I understand this; however, without the due date, my report is inefficient, and the subject areas I mentioned above do not communicate well. The due value is for the installment, but if I include the Due Date field from the Receivables - Payment Schedules Real Time subject area, I still face issues. Below is a screenshot…

Hi @Nathan CCC, This subject area allowed me to complete my report successfully, thank you very much!

I'm with the same issue, any help?

Hi @John Hung-Oracle, Thank you for your help. We are excited to complete our analysis. Best regards, Kauan Bohn