Sql query to pull burden cost details by transaction (AP invoice)?
Hi,
We have an audit request to pull burden cost by detail, instead of summary for AP invoices. I came up with the following, which shows the burden by transaction but apparently gms_bc_packets is purged, so it doesn't work for historical data. Does anyone else have any queries to pull burden cost details? Thanks!
select a.award_number
p.name, p.segment1, jbc.je_category_name, jbc.entered_dr, jbc.gl_bc_packets_rowid, jbc.bc_packet_id, jbc.parent_bc_packet_id
, jbc.burdenable_raw_cost
, jbc.request_id, jbc.document_header_id, jbc.*
from gms_bc_packets jbc
We have an audit request to pull burden cost by detail, instead of summary for AP invoices. I came up with the following, which shows the burden by transaction but apparently gms_bc_packets is purged, so it doesn't work for historical data. Does anyone else have any queries to pull burden cost details? Thanks!
select a.award_number
p.name, p.segment1, jbc.je_category_name, jbc.entered_dr, jbc.gl_bc_packets_rowid, jbc.bc_packet_id, jbc.parent_bc_packet_id
, jbc.burdenable_raw_cost
, jbc.request_id, jbc.document_header_id, jbc.*
from gms_bc_packets jbc
0