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

Transaction Date on receipt what database table stores this info?

Received Response
151
Views
3
Comments
edited Dec 11, 2019 11:32PM in Inventory Management 3 comments

Summary

Transaction Date on receipt what database table stores this info?

Content

We back-date receipts on PO's and I can't find the transaction date in any receiving tables. There is a transaction_date in the rcv_transactions table, but that is just receipt date and not the date we enter for the backdated receipt.

Version

19D

Code Snippet

select to_char(rt.transaction_date, 'MM/DD/YYYY') transaction_date,
to_char(rt.creation_date, 'MM/DD/YYYY') creation_date

from 
rcv_transactions rt,
po_headers_all        poh
WHERE rt.po_header_id = poh.po_header_id 
--and poh.segment1 = 'BCB103603' --testing
and poh.segment1 = 'BCB104611' --testing
and transaction_id in ('453854','453855')
AND rt.destination_type_code = 'RECEIVING'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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