Transaction Date on receipt what database table stores this info?
SummaryTransaction Date on receipt what database table stores this info?
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.
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'