VIEW: PJI.PJI_FM_AGGR_ACT4#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, TASK_ID TASK_ID, PERIOD_TYPE PERIOD_TYPE, PERIOD_ID PERIOD_ID, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_REVENUE TXN_REVENUE, TXN_FUNDING TXN_FUNDING, TXN_INITIAL_FUNDING_AMOUNT TXN_INITIAL_FUNDING_AMOUNT, TXN_ADDITIONAL_FUNDING_AMOUNT TXN_ADDITIONAL_FUNDING_AMOUNT, TXN_CANCELLED_FUNDING_AMOUNT TXN_CANCELLED_FUNDING_AMOUNT, TXN_FUNDING_ADJUSTMENT_AMOUNT TXN_FUNDING_ADJUSTMENT_AMOUNT, TXN_REVENUE_WRITEOFF TXN_REVENUE_WRITEOFF, TXN_AR_INVOICE_AMOUNT TXN_AR_INVOICE_AMOUNT, TXN_AR_CASH_APPLIED_AMOUNT TXN_AR_CASH_APPLIED_AMOUNT, TXN_AR_INVOICE_WRITEOFF_AMOUNT TXN_AR_INVOICE_WRITEOFF_AMOUNT, TXN_AR_CREDIT_MEMO_AMOUNT TXN_AR_CREDIT_MEMO_AMOUNT, TXN_UNBILLED_RECEIVABLES TXN_UNBILLED_RECEIVABLES, TXN_UNEARNED_REVENUE TXN_UNEARNED_REVENUE, TXN_AR_UNAPPR_INVOICE_AMOUNT TXN_AR_UNAPPR_INVOICE_AMOUNT, TXN_AR_APPR_INVOICE_AMOUNT TXN_AR_APPR_INVOICE_AMOUNT, TXN_AR_AMOUNT_DUE TXN_AR_AMOUNT_DUE, TXN_AR_AMOUNT_OVERDUE TXN_AR_AMOUNT_OVERDUE, PRJ_REVENUE PRJ_REVENUE, PRJ_FUNDING PRJ_FUNDING, PRJ_INITIAL_FUNDING_AMOUNT PRJ_INITIAL_FUNDING_AMOUNT, PRJ_ADDITIONAL_FUNDING_AMOUNT PRJ_ADDITIONAL_FUNDING_AMOUNT, PRJ_CANCELLED_FUNDING_AMOUNT PRJ_CANCELLED_FUNDING_AMOUNT, PRJ_FUNDING_ADJUSTMENT_AMOUNT PRJ_FUNDING_ADJUSTMENT_AMOUNT, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF, PRJ_AR_INVOICE_AMOUNT PRJ_AR_INVOICE_AMOUNT, PRJ_AR_CASH_APPLIED_AMOUNT PRJ_AR_CASH_APPLIED_AMOUNT, PRJ_AR_INVOICE_WRITEOFF_AMOUNT PRJ_AR_INVOICE_WRITEOFF_AMOUNT, PRJ_AR_CREDIT_MEMO_AMOUNT PRJ_AR_CREDIT_MEMO_AMOUNT, PRJ_UNBILLED_RECEIVABLES PRJ_UNBILLED_RECEIVABLES, PRJ_UNEARNED_REVENUE PRJ_UNEARNED_REVENUE, PRJ_AR_UNAPPR_INVOICE_AMOUNT PRJ_AR_UNAPPR_INVOICE_AMOUNT, PRJ_AR_APPR_INVOICE_AMOUNT PRJ_AR_APPR_INVOICE_AMOUNT, PRJ_AR_AMOUNT_DUE PRJ_AR_AMOUNT_DUE, PRJ_AR_AMOUNT_OVERDUE PRJ_AR_AMOUNT_OVERDUE, POU_REVENUE POU_REVENUE, POU_FUNDING POU_FUNDING, POU_INITIAL_FUNDING_AMOUNT POU_INITIAL_FUNDING_AMOUNT, POU_ADDITIONAL_FUNDING_AMOUNT POU_ADDITIONAL_FUNDING_AMOUNT, POU_CANCELLED_FUNDING_AMOUNT POU_CANCELLED_FUNDING_AMOUNT, POU_FUNDING_ADJUSTMENT_AMOUNT POU_FUNDING_ADJUSTMENT_AMOUNT, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF, POU_AR_INVOICE_AMOUNT POU_AR_INVOICE_AMOUNT, POU_AR_CASH_APPLIED_AMOUNT POU_AR_CASH_APPLIED_AMOUNT, POU_AR_INVOICE_WRITEOFF_AMOUNT POU_AR_INVOICE_WRITEOFF_AMOUNT, POU_AR_CREDIT_MEMO_AMOUNT POU_AR_CREDIT_MEMO_AMOUNT, POU_UNBILLED_RECEIVABLES POU_UNBILLED_RECEIVABLES, POU_UNEARNED_REVENUE POU_UNEARNED_REVENUE, POU_AR_UNAPPR_INVOICE_AMOUNT POU_AR_UNAPPR_INVOICE_AMOUNT, POU_AR_APPR_INVOICE_AMOUNT POU_AR_APPR_INVOICE_AMOUNT, POU_AR_AMOUNT_DUE POU_AR_AMOUNT_DUE, POU_AR_AMOUNT_OVERDUE POU_AR_AMOUNT_OVERDUE, INITIAL_FUNDING_COUNT INITIAL_FUNDING_COUNT, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDING_COUNT, CANCELLED_FUNDING_COUNT CANCELLED_FUNDING_COUNT, FUNDING_ADJUSTMENT_COUNT FUNDING_ADJUSTMENT_COUNT, AR_INVOICE_COUNT AR_INVOICE_COUNT, AR_CASH_APPLIED_COUNT AR_CASH_APPLIED_COUNT, AR_INVOICE_WRITEOFF_COUNT AR_INVOICE_WRITEOFF_COUNT, AR_CREDIT_MEMO_COUNT AR_CREDIT_MEMO_COUNT, AR_UNAPPR_INVOICE_COUNT AR_UNAPPR_INVOICE_COUNT, AR_APPR_INVOICE_COUNT AR_APPR_INVOICE_COUNT, AR_COUNT_DUE AR_COUNT_DUE, AR_COUNT_OVERDUE AR_COUNT_OVERDUE, G1_REVENUE G1_REVENUE, G1_FUNDING G1_FUNDING, G1_INITIAL_FUNDING_AMOUNT G1_INITIAL_FUNDING_AMOUNT, G1_ADDITIONAL_FUNDING_AMOUNT G1_ADDITIONAL_FUNDING_AMOUNT, G1_CANCELLED_FUNDING_AMOUNT G1_CANCELLED_FUNDING_AMOUNT, G1_FUNDING_ADJUSTMENT_AMOUNT G1_FUNDING_ADJUSTMENT_AMOUNT, G1_REVENUE_WRITEOFF G1_REVENUE_WRITEOFF, G1_AR_INVOICE_AMOUNT G1_AR_INVOICE_AMOUNT, G1_AR_CASH_APPLIED_AMOUNT G1_AR_CASH_APPLIED_AMOUNT, G1_AR_INVOICE_WRITEOFF_AMOUNT G1_AR_INVOICE_WRITEOFF_AMOUNT, G1_AR_CREDIT_MEMO_AMOUNT G1_AR_CREDIT_MEMO_AMOUNT, G1_UNBILLED_RECEIVABLES G1_UNBILLED_RECEIVABLES, G1_UNEARNED_REVENUE G1_UNEARNED_REVENUE, G1_AR_UNAPPR_INVOICE_AMOUNT G1_AR_UNAPPR_INVOICE_AMOUNT, G1_AR_APPR_INVOICE_AMOUNT G1_AR_APPR_INVOICE_AMOUNT, G1_AR_AMOUNT_DUE G1_AR_AMOUNT_DUE, G1_AR_AMOUNT_OVERDUE G1_AR_AMOUNT_OVERDUE, G2_REVENUE G2_REVENUE, G2_FUNDING G2_FUNDING, G2_INITIAL_FUNDING_AMOUNT G2_INITIAL_FUNDING_AMOUNT, G2_ADDITIONAL_FUNDING_AMOUNT G2_ADDITIONAL_FUNDING_AMOUNT, G2_CANCELLED_FUNDING_AMOUNT G2_CANCELLED_FUNDING_AMOUNT, G2_FUNDING_ADJUSTMENT_AMOUNT G2_FUNDING_ADJUSTMENT_AMOUNT, G2_REVENUE_WRITEOFF G2_REVENUE_WRITEOFF, G2_AR_INVOICE_AMOUNT G2_AR_INVOICE_AMOUNT, G2_AR_CASH_APPLIED_AMOUNT G2_AR_CASH_APPLIED_AMOUNT, G2_AR_INVOICE_WRITEOFF_AMOUNT G2_AR_INVOICE_WRITEOFF_AMOUNT, G2_AR_CREDIT_MEMO_AMOUNT G2_AR_CREDIT_MEMO_AMOUNT, G2_UNBILLED_RECEIVABLES G2_UNBILLED_RECEIVABLES, G2_UNEARNED_REVENUE G2_UNEARNED_REVENUE, G2_AR_UNAPPR_INVOICE_AMOUNT G2_AR_UNAPPR_INVOICE_AMOUNT, G2_AR_APPR_INVOICE_AMOUNT G2_AR_APPR_INVOICE_AMOUNT, G2_AR_AMOUNT_DUE G2_AR_AMOUNT_DUE, G2_AR_AMOUNT_OVERDUE G2_AR_AMOUNT_OVERDUE from "PJI"."PJI_FM_AGGR_ACT4"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, TASK_ID TASK_ID
, PERIOD_TYPE PERIOD_TYPE
, PERIOD_ID PERIOD_ID
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_REVENUE TXN_REVENUE
, TXN_FUNDING TXN_FUNDING
, TXN_INITIAL_FUNDING_AMOUNT TXN_INITIAL_FUNDING_AMOUNT
, TXN_ADDITIONAL_FUNDING_AMOUNT TXN_ADDITIONAL_FUNDING_AMOUNT
, TXN_CANCELLED_FUNDING_AMOUNT TXN_CANCELLED_FUNDING_AMOUNT
, TXN_FUNDING_ADJUSTMENT_AMOUNT TXN_FUNDING_ADJUSTMENT_AMOUNT
, TXN_REVENUE_WRITEOFF TXN_REVENUE_WRITEOFF
, TXN_AR_INVOICE_AMOUNT TXN_AR_INVOICE_AMOUNT
, TXN_AR_CASH_APPLIED_AMOUNT TXN_AR_CASH_APPLIED_AMOUNT
, TXN_AR_INVOICE_WRITEOFF_AMOUNT TXN_AR_INVOICE_WRITEOFF_AMOUNT
, TXN_AR_CREDIT_MEMO_AMOUNT TXN_AR_CREDIT_MEMO_AMOUNT
, TXN_UNBILLED_RECEIVABLES TXN_UNBILLED_RECEIVABLES
, TXN_UNEARNED_REVENUE TXN_UNEARNED_REVENUE
, TXN_AR_UNAPPR_INVOICE_AMOUNT TXN_AR_UNAPPR_INVOICE_AMOUNT
, TXN_AR_APPR_INVOICE_AMOUNT TXN_AR_APPR_INVOICE_AMOUNT
, TXN_AR_AMOUNT_DUE TXN_AR_AMOUNT_DUE
, TXN_AR_AMOUNT_OVERDUE TXN_AR_AMOUNT_OVERDUE
, PRJ_REVENUE PRJ_REVENUE
, PRJ_FUNDING PRJ_FUNDING
, PRJ_INITIAL_FUNDING_AMOUNT PRJ_INITIAL_FUNDING_AMOUNT
, PRJ_ADDITIONAL_FUNDING_AMOUNT PRJ_ADDITIONAL_FUNDING_AMOUNT
, PRJ_CANCELLED_FUNDING_AMOUNT PRJ_CANCELLED_FUNDING_AMOUNT
, PRJ_FUNDING_ADJUSTMENT_AMOUNT PRJ_FUNDING_ADJUSTMENT_AMOUNT
, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF
, PRJ_AR_INVOICE_AMOUNT PRJ_AR_INVOICE_AMOUNT
, PRJ_AR_CASH_APPLIED_AMOUNT PRJ_AR_CASH_APPLIED_AMOUNT
, PRJ_AR_INVOICE_WRITEOFF_AMOUNT PRJ_AR_INVOICE_WRITEOFF_AMOUNT
, PRJ_AR_CREDIT_MEMO_AMOUNT PRJ_AR_CREDIT_MEMO_AMOUNT
, PRJ_UNBILLED_RECEIVABLES PRJ_UNBILLED_RECEIVABLES
, PRJ_UNEARNED_REVENUE PRJ_UNEARNED_REVENUE
, PRJ_AR_UNAPPR_INVOICE_AMOUNT PRJ_AR_UNAPPR_INVOICE_AMOUNT
, PRJ_AR_APPR_INVOICE_AMOUNT PRJ_AR_APPR_INVOICE_AMOUNT
, PRJ_AR_AMOUNT_DUE PRJ_AR_AMOUNT_DUE
, PRJ_AR_AMOUNT_OVERDUE PRJ_AR_AMOUNT_OVERDUE
, POU_REVENUE POU_REVENUE
, POU_FUNDING POU_FUNDING
, POU_INITIAL_FUNDING_AMOUNT POU_INITIAL_FUNDING_AMOUNT
, POU_ADDITIONAL_FUNDING_AMOUNT POU_ADDITIONAL_FUNDING_AMOUNT
, POU_CANCELLED_FUNDING_AMOUNT POU_CANCELLED_FUNDING_AMOUNT
, POU_FUNDING_ADJUSTMENT_AMOUNT POU_FUNDING_ADJUSTMENT_AMOUNT
, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF
, POU_AR_INVOICE_AMOUNT POU_AR_INVOICE_AMOUNT
, POU_AR_CASH_APPLIED_AMOUNT POU_AR_CASH_APPLIED_AMOUNT
, POU_AR_INVOICE_WRITEOFF_AMOUNT POU_AR_INVOICE_WRITEOFF_AMOUNT
, POU_AR_CREDIT_MEMO_AMOUNT POU_AR_CREDIT_MEMO_AMOUNT
, POU_UNBILLED_RECEIVABLES POU_UNBILLED_RECEIVABLES
, POU_UNEARNED_REVENUE POU_UNEARNED_REVENUE
, POU_AR_UNAPPR_INVOICE_AMOUNT POU_AR_UNAPPR_INVOICE_AMOUNT
, POU_AR_APPR_INVOICE_AMOUNT POU_AR_APPR_INVOICE_AMOUNT
, POU_AR_AMOUNT_DUE POU_AR_AMOUNT_DUE
, POU_AR_AMOUNT_OVERDUE POU_AR_AMOUNT_OVERDUE
, INITIAL_FUNDING_COUNT INITIAL_FUNDING_COUNT
, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDING_COUNT
, CANCELLED_FUNDING_COUNT CANCELLED_FUNDING_COUNT
, FUNDING_ADJUSTMENT_COUNT FUNDING_ADJUSTMENT_COUNT
, AR_INVOICE_COUNT AR_INVOICE_COUNT
, AR_CASH_APPLIED_COUNT AR_CASH_APPLIED_COUNT
, AR_INVOICE_WRITEOFF_COUNT AR_INVOICE_WRITEOFF_COUNT
, AR_CREDIT_MEMO_COUNT AR_CREDIT_MEMO_COUNT
, AR_UNAPPR_INVOICE_COUNT AR_UNAPPR_INVOICE_COUNT
, AR_APPR_INVOICE_COUNT AR_APPR_INVOICE_COUNT
, AR_COUNT_DUE AR_COUNT_DUE
, AR_COUNT_OVERDUE AR_COUNT_OVERDUE
, G1_REVENUE G1_REVENUE
, G1_FUNDING G1_FUNDING
, G1_INITIAL_FUNDING_AMOUNT G1_INITIAL_FUNDING_AMOUNT
, G1_ADDITIONAL_FUNDING_AMOUNT G1_ADDITIONAL_FUNDING_AMOUNT
, G1_CANCELLED_FUNDING_AMOUNT G1_CANCELLED_FUNDING_AMOUNT
, G1_FUNDING_ADJUSTMENT_AMOUNT G1_FUNDING_ADJUSTMENT_AMOUNT
, G1_REVENUE_WRITEOFF G1_REVENUE_WRITEOFF
, G1_AR_INVOICE_AMOUNT G1_AR_INVOICE_AMOUNT
, G1_AR_CASH_APPLIED_AMOUNT G1_AR_CASH_APPLIED_AMOUNT
, G1_AR_INVOICE_WRITEOFF_AMOUNT G1_AR_INVOICE_WRITEOFF_AMOUNT
, G1_AR_CREDIT_MEMO_AMOUNT G1_AR_CREDIT_MEMO_AMOUNT
, G1_UNBILLED_RECEIVABLES G1_UNBILLED_RECEIVABLES
, G1_UNEARNED_REVENUE G1_UNEARNED_REVENUE
, G1_AR_UNAPPR_INVOICE_AMOUNT G1_AR_UNAPPR_INVOICE_AMOUNT
, G1_AR_APPR_INVOICE_AMOUNT G1_AR_APPR_INVOICE_AMOUNT
, G1_AR_AMOUNT_DUE G1_AR_AMOUNT_DUE
, G1_AR_AMOUNT_OVERDUE G1_AR_AMOUNT_OVERDUE
, G2_REVENUE G2_REVENUE
, G2_FUNDING G2_FUNDING
, G2_INITIAL_FUNDING_AMOUNT G2_INITIAL_FUNDING_AMOUNT
, G2_ADDITIONAL_FUNDING_AMOUNT G2_ADDITIONAL_FUNDING_AMOUNT
, G2_CANCELLED_FUNDING_AMOUNT G2_CANCELLED_FUNDING_AMOUNT
, G2_FUNDING_ADJUSTMENT_AMOUNT G2_FUNDING_ADJUSTMENT_AMOUNT
, G2_REVENUE_WRITEOFF G2_REVENUE_WRITEOFF
, G2_AR_INVOICE_AMOUNT G2_AR_INVOICE_AMOUNT
, G2_AR_CASH_APPLIED_AMOUNT G2_AR_CASH_APPLIED_AMOUNT
, G2_AR_INVOICE_WRITEOFF_AMOUNT G2_AR_INVOICE_WRITEOFF_AMOUNT
, G2_AR_CREDIT_MEMO_AMOUNT G2_AR_CREDIT_MEMO_AMOUNT
, G2_UNBILLED_RECEIVABLES G2_UNBILLED_RECEIVABLES
, G2_UNEARNED_REVENUE G2_UNEARNED_REVENUE
, G2_AR_UNAPPR_INVOICE_AMOUNT G2_AR_UNAPPR_INVOICE_AMOUNT
, G2_AR_APPR_INVOICE_AMOUNT G2_AR_APPR_INVOICE_AMOUNT
, G2_AR_AMOUNT_DUE G2_AR_AMOUNT_DUE
, G2_AR_AMOUNT_OVERDUE G2_AR_AMOUNT_OVERDUE
FROM "PJI"."PJI_FM_AGGR_ACT4"