[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_EXTR_DINVC# |
---|---|
Object Type: | VIEW |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Yes | |
WORKER_ID | NUMBER | Yes | ||
PROJECT_ORG_ID | NUMBER | |||
PROJECT_ORGANIZATION_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
PJI_PROJECT_STATUS | VARCHAR2 | (1) | ||
DRAFT_INVOICE_NUM | NUMBER | |||
UNBILLED_RECEIVABLE_DR | NUMBER | |||
UNEARNED_REVENUE_CR | NUMBER | |||
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | ||
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) | ||
APPROVED_FLAG | VARCHAR2 | (1) | ||
PJI_DATE_RANGE_FLAG | VARCHAR2 | (1) | ||
CUSTOMER_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, WORKER_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ID
, PJI_PROJECT_STATUS
, DRAFT_INVOICE_NUM
, UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR
, TRANSFER_STATUS_CODE
, 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
, APPROVED_FLAG
, PJI_DATE_RANGE_FLAG
, CUSTOMER_ID
FROM PJI.PJI_FM_EXTR_DINVC#;
|
|
|