[Home] [Help] [Dependency Information]
Object Name: | PA_UNBILLED_REC_REPORTING# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | |
EI_BUCKET1 | NUMBER | (22) | ||
EI_BUCKET2 | NUMBER | (22) | ||
EI_BUCKET3 | NUMBER | (22) | ||
EI_BUCKET4 | NUMBER | (22) | ||
EVENT_BUCKET1 | NUMBER | (22) | ||
EVENT_BUCKET2 | NUMBER | (22) | ||
EVENT_BUCKET3 | NUMBER | (22) | ||
EVENT_BUCKET4 | NUMBER | (22) | ||
EVENT_INV_AMOUNT | NUMBER | (22) | ||
COST_WORK_AMOUNT | NUMBER | (22) | ||
INVOICE_REDUCTION | NUMBER | (22) | ||
RETENTION | NUMBER | (22) |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, EI_BUCKET1
, EI_BUCKET2
, EI_BUCKET3
, EI_BUCKET4
, EVENT_BUCKET1
, EVENT_BUCKET2
, EVENT_BUCKET3
, EVENT_BUCKET4
, EVENT_INV_AMOUNT
, COST_WORK_AMOUNT
, INVOICE_REDUCTION
, RETENTION
FROM PA.PA_UNBILLED_REC_REPORTING#;
|
|
|