VIEW: PJI.PJI_FM_EXTR_DINVC#

Source

View Text - Preformatted

select ROW_ID ROW_ID, WORKER_ID WORKER_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ID PROJECT_ID, PJI_PROJECT_STATUS PJI_PROJECT_STATUS, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, GL_DATE GL_DATE, PA_DATE PA_DATE, SYSTEM_REFERENCE SYSTEM_REFERENCE, APPROVED_DATE APPROVED_DATE, APPROVED_BY_PERSON_ID APPROVED_BY_PERSON_ID, CANCEL_CREDIT_MEMO_FLAG CANCEL_CREDIT_MEMO_FLAG, WRITE_OFF_FLAG WRITE_OFF_FLAG, INTER_COMPANY_BILLING_FLAG INTER_COMPANY_BILLING_FLAG, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG, APPROVED_FLAG APPROVED_FLAG, PJI_DATE_RANGE_FLAG PJI_DATE_RANGE_FLAG, CUSTOMER_ID CUSTOMER_ID from "PJI"."PJI_FM_EXTR_DINVC"

View Text - HTML Formatted

SELECT ROW_ID ROW_ID
, WORKER_ID WORKER_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ID PROJECT_ID
, PJI_PROJECT_STATUS PJI_PROJECT_STATUS
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, GL_DATE GL_DATE
, PA_DATE PA_DATE
, SYSTEM_REFERENCE SYSTEM_REFERENCE
, APPROVED_DATE APPROVED_DATE
, APPROVED_BY_PERSON_ID APPROVED_BY_PERSON_ID
, CANCEL_CREDIT_MEMO_FLAG CANCEL_CREDIT_MEMO_FLAG
, WRITE_OFF_FLAG WRITE_OFF_FLAG
, INTER_COMPANY_BILLING_FLAG INTER_COMPANY_BILLING_FLAG
, PJI_SUMMARIZED_FLAG PJI_SUMMARIZED_FLAG
, APPROVED_FLAG APPROVED_FLAG
, PJI_DATE_RANGE_FLAG PJI_DATE_RANGE_FLAG
, CUSTOMER_ID CUSTOMER_ID
FROM "PJI"."PJI_FM_EXTR_DINVC"