[Home] [Help] [Dependency Information]
Object Name: | PA_DEDUCTION_TRANSACTIONS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_DEDUCTION_TRANSACTIONS_ALL |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_DEDUCTION_TRANSACTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DEDUCTION_REQ_TRAN_ID |
PA_DEDUCTION_TRANSACTIONS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | EXPENDITURE_ITEM_ID |
PA_DEDUCTION_TRANSACTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROJECT_ID
TASK_ID EXPENDITURE_ITEM_DATE |
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. |
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;
PA.PA_DEDUCTION_TRANSACTIONS_ALL does not reference any database object
PA.PA_DEDUCTION_TRANSACTIONS_ALL is referenced by following:
|
|
|