[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_EXTR_DINVCITM# |
---|---|
Object Type: | VIEW |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | Yes | ||
PROJECT_ORG_ID | NUMBER | |||
PROJECT_ORGANIZATION_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
DRAFT_INVOICE_NUM | NUMBER | |||
GL_DATE | DATE | |||
PA_DATE | DATE | |||
SYSTEM_REFERENCE | NUMBER | |||
APPROVED_DATE | DATE | |||
APPROVED_BY_PERSON_ID | NUMBER | |||
CANCEL_CREDIT_MEMO_FLAG | VARCHAR2 | (1) | ||
WRITE_OFF_FLAG | VARCHAR2 | (1) | ||
INTER_COMPANY_BILLING_FLAG | VARCHAR2 | (1) | ||
PJI_SUMMARIZED_FLAG | VARCHAR2 | (1) | ||
INVOICE_LINE_TYPE | VARCHAR2 | (30) | ||
POU_INVOICE_AMOUNT | NUMBER | |||
PRJ_INVOICE_AMOUNT | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
APPROVED_FLAG | VARCHAR2 | (1) | ||
PJI_DATE_RANGE_FLAG | VARCHAR2 | (1) | ||
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | ||
PJI_RECORD_TYPE | VARCHAR2 | (1) | ||
AR_INVOICE_COUNT | NUMBER | |||
AR_INVOICE_WRITEOFF_COUNT | NUMBER | |||
AR_CREDIT_MEMO_COUNT | NUMBER | |||
AR_UNAPPR_INVOICE_COUNT | NUMBER | |||
AR_APPR_INVOICE_COUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ID
, DRAFT_INVOICE_NUM
, GL_DATE
, PA_DATE
, SYSTEM_REFERENCE
, APPROVED_DATE
, APPROVED_BY_PERSON_ID
, CANCEL_CREDIT_MEMO_FLAG
, WRITE_OFF_FLAG
, INTER_COMPANY_BILLING_FLAG
, PJI_SUMMARIZED_FLAG
, INVOICE_LINE_TYPE
, POU_INVOICE_AMOUNT
, PRJ_INVOICE_AMOUNT
, CUSTOMER_ID
, APPROVED_FLAG
, PJI_DATE_RANGE_FLAG
, TRANSFER_STATUS_CODE
, PJI_RECORD_TYPE
, AR_INVOICE_COUNT
, AR_INVOICE_WRITEOFF_COUNT
, AR_CREDIT_MEMO_COUNT
, AR_UNAPPR_INVOICE_COUNT
, AR_APPR_INVOICE_COUNT
FROM PJI.PJI_FM_EXTR_DINVCITM#;
|
|
|