DBA Data[Home] [Help] [Dependency Information]


TABLE: PA.PA_NL_BILL_RATE_OVERRIDES

Object Details
Object Name: PA_NL_BILL_RATE_OVERRIDES
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_NL_BILL_RATE_OVERRIDES
Subobject Name:
Status: VALID


PA_NL_BILL_RATE_OVERRIDES stores special billing rates
for non-labor items negotiated for specific projects
or tasks. A non-labor bill rate override takes
precedence over the billing rate defined in the
standard non-labor bill rate schedule used for a
particular project or task.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_NL_BILL_RATE_OVERRIDES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnTASK_ID
ColumnEXPENDITURE_TYPE
ColumnSTART_DATE_ACTIVE
ColumnNON_LABOR_RESOURCE
PA_NL_BILL_RATE_OVERRIDES_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNL_BILL_RATE_OVERRIDE_ID
PA_NL_BILL_RATE_OVERRIDES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTASK_ID
ColumnEXPENDITURE_TYPE
ColumnSTART_DATE_ACTIVE
ColumnNON_LABOR_RESOURCE
Columns
Name Datatype Length Mandatory Comments
EXPENDITURE_TYPE VARCHAR2 (30) Yes The expenditure type that will be billed according to the non-labor bill rate override. This column is also populated for a non-labor resource bill rate override
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
START_DATE_ACTIVE DATE
Yes First effective date of non-labor bill rate override
NON_LABOR_RESOURCE VARCHAR2 (20)
The non-labor resource that will be billed according to the non-labor bill rate override
MARKUP_PERCENTAGE NUMBER (9)
The markup percentage over raw cost used to determine an item's revenue or bill amount. Revenue = (raw cost * (1 + (markup/100)))
BILL_RATE NUMBER (22)
The bill rate used to determine the item's revenue amount. Revenue = (bill rate * quantity)
END_DATE_ACTIVE DATE

Last effective date of non-labor bill rate override
PROJECT_ID NUMBER (15)
The identifier of the project for which the non-labor bill rate override is entered
TASK_ID NUMBER (15)
The identifier of the task for which the non-labor bill rate override is entered
RECORD_VERSION_NUMBER NUMBER (15)
Record version number.
NL_BILL_RATE_OVERRIDE_ID NUMBER (15) Yes Uniqely identifies a non labor bill rate override
RATE_CURRENCY_CODE VARCHAR2 (15)
Currency of the bill rate override.
DISCOUNT_PERCENTAGE NUMBER

Audit column for rate derivation. The discount percentage is used to derive the adjusted revenue and rate
RATE_DISC_REASON_CODE VARCHAR2 (30)
Reason code for dicount,discount override or rate override
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXPENDITURE_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      START_DATE_ACTIVE
,      NON_LABOR_RESOURCE
,      MARKUP_PERCENTAGE
,      BILL_RATE
,      END_DATE_ACTIVE
,      PROJECT_ID
,      TASK_ID
,      RECORD_VERSION_NUMBER
,      NL_BILL_RATE_OVERRIDE_ID
,      RATE_CURRENCY_CODE
,      DISCOUNT_PERCENTAGE
,      RATE_DISC_REASON_CODE
FROM PA.PA_NL_BILL_RATE_OVERRIDES;

Dependencies

[top of page]

PA.PA_NL_BILL_RATE_OVERRIDES does not reference any database object

PA.PA_NL_BILL_RATE_OVERRIDES is referenced by following:

SchemaAPPS
SynonymPA_NL_BILL_RATE_OVERRIDES