Project Transaction Report (PCR008)

Business Unit

N

"Organizations"."Business Unit Name"

Y

Y

Project

N

"Project"."Project Name"

Y

Y

Activity

N

"Project Resource"."Activity ID"

N

Y

Analysis Groups

N

"Analysis Group"."Analysis Group Description"

N

Y

Date Type

N

Hard Coded: 

Accounting or Transaction Date

Y

Y

Accounting Date

N

"Project Resource"."Accounting Date"

Y

Y

Transaction Date

N

"Project Resource"."Transaction Date"

Y

Y

Business Unit

"Organizations"."Business Unit Number"

Project

"Project"."Project Name"

Activity

"Project Resource"."Activity ID"

PC Source Type

"Financial Resource"."Resource Type Name"

PC Category

"Financial Resource"."Expenditure Category Name"

PC Subcategory

"Financial Resource"."Expenditure Subcategory Description"

Amount

"Fact - Project Cost"."Cost"

Analysis Type

"Analysis Type"."Analysis  Type Name"

Organization

"Organizations"."Organization Name"

Account

"GL Account"."Natural Account Number"

Fund

"GL Account"."Fund"

Budget Entity

"GL Account"."Budget Entity"

Category

"GL Account"."Category"

State Program

"GL Account"."State Program"

Grant ID

"GL Account"."Grant Id"

Contract ID

"GL Account"."Contract Id"

OA1

"GL Account"."OA1"

OA2

"GL Account"."OA2"

Budget Date

"Enterprise Calendar"."Date"

Journal ID

"Project Resource"."Journal ID"

Accounting Date

"Project Resource"."Accounting Date"

Transaction date

"Project Resource"."Transaction Date"

Payment Reference ID

"Project Resource"."Payment ID Reference"

Reference ID Custom

CASE WHEN "Analysis Type"."Analysis  Type Name" = 'ACT' AND "Project Resource"."System Source" = 'BAP'      

      THEN "Project Payment Voucher Details"."Voucher ID"   

                 WHEN "Analysis Type"."Analysis  Type Name" IN ('GLE', 'GLR') AND "Project Resource"."System Source" = 'BGL' 

                 THEN "Project Resource"."Journal ID"      

      WHEN "Analysis Type"."Analysis  Type Name" IN ('ARC', 'ARE') AND "Project Resource"."System Source" = 'BAR'

                 THEN "Project Resource"."Deposit ID"

      WHEN "Analysis Type"."Analysis  Type Name" IN ('IUE') AND "Project Resource"."System Source" = 'BIE'   

                 THEN "Project Resource"."Sequence Number"     

                 WHEN "Analysis Type"."Analysis  Type Name" IN ('IUT') AND "Project Resource"."System Source" = 'BIU'   

                 THEN "Project Resource"."Sequence Number"     

                 WHEN "Analysis Type"."Analysis  Type Name" = 'COM' AND "Project Resource"."System Source" = 'BPO'   

                 THEN "Project Resource"."PO ID"      

                 WHEN "Analysis Type"."Analysis  Type Name" = 'COM' AND "Project Resource"."System Source" = 'BRA'   

                 THEN "Project Resource"."Req ID (Receipt Number)"                

                 WHEN "Analysis Type"."Analysis  Type Name" = 'ADJ' AND "Project Resource"."System Source" = 'PPC'

                 THEN "Project Resource"."Resource ID"

                 WHEN "Analysis Type"."Analysis  Type Name" = 'REV' AND "Project Resource"."System Source" = 'BAR'      

      THEN "Project Resource"."Item ID"

 END

Original Version