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

TABLE: PA.PA_DEDUCTION_TRANSACTIONS_ALL

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_DEDUCTION_TRANSACTIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEDUCTION_REQ_TRAN_ID
PA_DEDUCTION_TRANSACTIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXPENDITURE_ITEM_ID
PA_DEDUCTION_TRANSACTIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnTASK_ID
ColumnEXPENDITURE_ITEM_DATE
Columns
Name Datatype Length Mandatory Comments
DEDUCTION_REQ_ID NUMBER (15) Yes This is the ID of the deduction request to which the deduction transaction belongs.
DEDUCTION_REQ_TRAN_ID NUMBER (15) Yes This is a system generated number that uniquely identifies a deduction transaction.
PROJECT_ID NUMBER (15) Yes This is the ID of the project to which the deduction transaction is charged.
TASK_ID NUMBER (15) Yes This is the ID of the task to which the deduction transaction is charged.
EXPENDITURE_TYPE VARCHAR2 (30) Yes This is used to classify the type of work performed.
EXPENDITURE_ORG_ID NUMBER (15) Yes This is the ID of the expenditure organization to which the cost is charged.
QUANTITY NUMBER

This is the quantity of work done by the supplier.
OVERRIDE_QUANTITY NUMBER

This is the work quantity modified by user. In case of an expenditure item mapped to a deduction line, users can modify the existing quantity. The modified quantity is stored as override quantity.
EXPENDITURE_ITEM_ID NUMBER (15)
This is the ID of the expenditure item mapped to a deduction line.
EXPENDITURE_ITEM_DATE DATE
Yes This is the date on which the work was done.
GL_DATE DATE

This is the accounting date
PROJFUNC_CURRENCY_CODE VARCHAR2 (30)
This is the project functional currency code.
ORIG_PROJFUNC_AMOUNT NUMBER

This is the amount expressed in the project functional currency.
OVERRIDE_PROJFUNC_AMOUNT NUMBER

This is the modified amount expressed in the projects functional currency.
CONVERSION_RATETYPE VARCHAR2 (30)
This is the currency conversion rate type used to convert the projects functional currency to the transaction currency.
CONVERSION_RATEDATE DATE

This indicates the date on which the defined currency conversion rate is applicable.
CONVERSION_RATE NUMBER

This is the currency conversion rate used to convert projects functional currency amount to the transaction currency amout.
AMOUNT NUMBER
Yes This is the deduction line amount expressed in the transaction currency
DESCRIPTION VARCHAR2 (4000)
This is the description of the deduction line.
CREATION_DATE DATE
Yes This is the date on which the deduction request was created.
CREATED_BY NUMBER (15) Yes This is the ID of the user who created the deductions request.
LAST_UPDATION_DATE DATE

This is the date on which the deduction request was last updated.
LAST_UPDATED_BY NUMBER (15)
This is the ID of the user who last updated the deductions request.
Query Text

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


SELECT DEDUCTION_REQ_ID
,      DEDUCTION_REQ_TRAN_ID
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORG_ID
,      QUANTITY
,      OVERRIDE_QUANTITY
,      EXPENDITURE_ITEM_ID
,      EXPENDITURE_ITEM_DATE
,      GL_DATE
,      PROJFUNC_CURRENCY_CODE
,      ORIG_PROJFUNC_AMOUNT
,      OVERRIDE_PROJFUNC_AMOUNT
,      CONVERSION_RATETYPE
,      CONVERSION_RATEDATE
,      CONVERSION_RATE
,      AMOUNT
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATION_DATE
,      LAST_UPDATED_BY
FROM PA.PA_DEDUCTION_TRANSACTIONS_ALL;

Dependencies

[top of page]

PA.PA_DEDUCTION_TRANSACTIONS_ALL does not reference any database object

PA.PA_DEDUCTION_TRANSACTIONS_ALL is referenced by following:

SchemaPA
ViewPA_DEDUCTION_TRANSACTIONS_ALL#