[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_EI_DENORM |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_EI_DENORM
|
| Subobject Name: | |
| Status: | VALID |
PA_EI_DENORM is the denormalized representation of the PA_EXPENDITURE_ITEMS_ALL table, primarily used by the Self-Service Time module to enable matrix time entry. Please refer to the column descriptions in the PA_EXPENDITURE_ITEMS_ALL for a detailed description of the columns in this table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_EI_DENORM_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 EXPENDITURE_ID
DENORM_ID
|
| PA_EI_DENORM_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
DENORM_ID
|
| PA_EI_DENORM_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
|
| PA_EI_DENORM_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TASK_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXPENDITURE_ID | NUMBER | (15) | Yes | The system-generated number that uniquely identifies the expenditure item |
| DENORM_ID | NUMBER | (15) | Yes | System generated unique identifier |
| PERSON_ID | NUMBER | (15) | Yes | The identifier of the employee who incurred the charges. This column is always populated for labor and expense report charges and is not populated for supplier invoices. For usages, specifying employees who incurred the charges is optional |
| PROJECT_ID | NUMBER | (15) | Yes | The project_id of the event that the expenditure item is FIFO marked by |
| TASK_ID | NUMBER | (15) | Yes | The identifier of the task to which the expenditure item is charged |
| BILLABLE_FLAG | VARCHAR2 | (1) | Yes | Obsolete |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | The expenditure type that classifies the type of work performed | |
| DEFAULT_SYS_LINK_FUNC | VARCHAR2 | (3) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (30) | The unit by which to measure amounts entered for the expenditure type | |
| UNIT_OF_MEASURE | VARCHAR2 | (80) | The unit by which to measure amounts entered for the expenditure type | |
| EXPENDITURE_ITEM_ID_1 | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
| EXPENDITURE_ITEM_DATE_1 | DATE | The date on which the work occurred | ||
| QUANTITY_1 | NUMBER | (22) | The number of units of the work performed | |
| SYSTEM_LINKAGE_FUNCTION_1 | VARCHAR2 | (30) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| NON_LABOR_RESOURCE_1 | VARCHAR2 | (20) | The non-labor resource utilized as the work was performed. This column is only populated for usage items | |
| ORGANIZATION_ID_1 | NUMBER | (15) | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | |
| OVERRIDE_TO_ORGANIZATION_ID_1 | NUMBER | (15) | The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables | |
| RAW_COST_1 | NUMBER | (22) | Raw cost in project Currency | |
| RAW_COST_RATE_1 | NUMBER | (22) | The raw cost rate used to cost the item | |
| ATTRIBUTE_CATEGORY_1 | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE1_1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE1_10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ORIG_TRANSACTION_REFERENCE_1 | VARCHAR2 | (50) | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. | |
| ADJUSTED_EXPENDITURE_ITEM_ID_1 | NUMBER | (15) | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item. | |
| NET_ZERO_ADJUSTMENT_FLAG_1 | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice | |
| EXPENDITURE_COMMENT_1 | VARCHAR2 | (240) | The free text comment entered for an expenditure item to further describe work done | |
| EXPENDITURE_ITEM_ID_2 | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
| EXPENDITURE_ITEM_DATE_2 | DATE | The date on which the work occurred | ||
| QUANTITY_2 | NUMBER | (22) | The number of units of the work performed | |
| SYSTEM_LINKAGE_FUNCTION_2 | VARCHAR2 | (30) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| NON_LABOR_RESOURCE_2 | VARCHAR2 | (20) | The non-labor resource utilized as the work was performed. This column is only populated for usage items | |
| ORGANIZATION_ID_2 | NUMBER | (15) | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | |
| OVERRIDE_TO_ORGANIZATION_ID_2 | NUMBER | (15) | The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables | |
| RAW_COST_2 | NUMBER | (22) | Raw cost in project Currency | |
| RAW_COST_RATE_2 | NUMBER | (22) | The raw cost rate used to cost the item | |
| ATTRIBUTE_CATEGORY_2 | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE2_1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2_10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ORIG_TRANSACTION_REFERENCE_2 | VARCHAR2 | (50) | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. | |
| ADJUSTED_EXPENDITURE_ITEM_ID_2 | NUMBER | (15) | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item. | |
| NET_ZERO_ADJUSTMENT_FLAG_2 | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice | |
| EXPENDITURE_COMMENT_2 | VARCHAR2 | (240) | The free text comment entered for an expenditure item to further describe work done | |
| EXPENDITURE_ITEM_ID_3 | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
| EXPENDITURE_ITEM_DATE_3 | DATE | The date on which the work occurred | ||
| QUANTITY_3 | NUMBER | (22) | The number of units of the work performed | |
| SYSTEM_LINKAGE_FUNCTION_3 | VARCHAR2 | (30) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| NON_LABOR_RESOURCE_3 | VARCHAR2 | (20) | The non-labor resource utilized as the work was performed. This column is only populated for usage items | |
| ORGANIZATION_ID_3 | NUMBER | (15) | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | |
| OVERRIDE_TO_ORGANIZATION_ID_3 | NUMBER | (15) | The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables | |
| RAW_COST_3 | NUMBER | (22) | Raw cost in project Currency | |
| RAW_COST_RATE_3 | NUMBER | (22) | The raw cost rate used to cost the item | |
| ATTRIBUTE_CATEGORY_3 | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE3_1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3_10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ORIG_TRANSACTION_REFERENCE_3 | VARCHAR2 | (50) | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. | |
| ADJUSTED_EXPENDITURE_ITEM_ID_3 | NUMBER | (15) | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item. | |
| NET_ZERO_ADJUSTMENT_FLAG_3 | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice | |
| EXPENDITURE_COMMENT_3 | VARCHAR2 | (240) | The free text comment entered for an expenditure item to further describe work done | |
| EXPENDITURE_ITEM_ID_4 | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
| EXPENDITURE_ITEM_DATE_4 | DATE | The date on which the work occurred | ||
| QUANTITY_4 | NUMBER | (22) | The number of units of the work performed | |
| SYSTEM_LINKAGE_FUNCTION_4 | VARCHAR2 | (30) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| NON_LABOR_RESOURCE_4 | VARCHAR2 | (20) | The non-labor resource utilized as the work was performed. This column is only populated for usage items | |
| ORGANIZATION_ID_4 | NUMBER | (15) | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | |
| OVERRIDE_TO_ORGANIZATION_ID_4 | NUMBER | (15) | The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables | |
| RAW_COST_4 | NUMBER | (22) | Raw cost in project Currency | |
| RAW_COST_RATE_4 | NUMBER | (22) | The raw cost rate used to cost the item | |
| ATTRIBUTE_CATEGORY_4 | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE4_1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4_10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ORIG_TRANSACTION_REFERENCE_4 | VARCHAR2 | (50) | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. | |
| ADJUSTED_EXPENDITURE_ITEM_ID_4 | NUMBER | (15) | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item. | |
| NET_ZERO_ADJUSTMENT_FLAG_4 | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice | |
| EXPENDITURE_COMMENT_4 | VARCHAR2 | (240) | The free text comment entered for an expenditure item to further describe work done | |
| EXPENDITURE_ITEM_ID_5 | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
| EXPENDITURE_ITEM_DATE_5 | DATE | The date on which the work occurred | ||
| QUANTITY_5 | NUMBER | (22) | The number of units of the work performed | |
| SYSTEM_LINKAGE_FUNCTION_5 | VARCHAR2 | (30) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| NON_LABOR_RESOURCE_5 | VARCHAR2 | (20) | The non-labor resource utilized as the work was performed. This column is only populated for usage items | |
| ORGANIZATION_ID_5 | NUMBER | (15) | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | |
| OVERRIDE_TO_ORGANIZATION_ID_5 | NUMBER | (15) | The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables | |
| RAW_COST_5 | NUMBER | (22) | Raw cost in project Currency | |
| RAW_COST_RATE_5 | NUMBER | (22) | The raw cost rate used to cost the item | |
| ATTRIBUTE_CATEGORY_5 | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE5_1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5_10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ORIG_TRANSACTION_REFERENCE_5 | VARCHAR2 | (50) | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. | |
| ADJUSTED_EXPENDITURE_ITEM_ID_5 | NUMBER | (15) | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item. | |
| NET_ZERO_ADJUSTMENT_FLAG_5 | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice | |
| EXPENDITURE_COMMENT_5 | VARCHAR2 | (240) | The free text comment entered for an expenditure item to further describe work done | |
| EXPENDITURE_ITEM_ID_6 | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
| EXPENDITURE_ITEM_DATE_6 | DATE | The date on which the work occurred | ||
| QUANTITY_6 | NUMBER | (22) | The number of units of the work performed | |
| SYSTEM_LINKAGE_FUNCTION_6 | VARCHAR2 | (30) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| NON_LABOR_RESOURCE_6 | VARCHAR2 | (20) | The non-labor resource utilized as the work was performed. This column is only populated for usage items | |
| ORGANIZATION_ID_6 | NUMBER | (15) | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | |
| OVERRIDE_TO_ORGANIZATION_ID_6 | NUMBER | (15) | The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables | |
| RAW_COST_6 | NUMBER | (22) | Raw cost in project Currency | |
| RAW_COST_RATE_6 | NUMBER | (22) | The raw cost rate used to cost the item | |
| ATTRIBUTE_CATEGORY_6 | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE6_1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6_10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ORIG_TRANSACTION_REFERENCE_6 | VARCHAR2 | (50) | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. | |
| ADJUSTED_EXPENDITURE_ITEM_ID_6 | NUMBER | (15) | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item. | |
| NET_ZERO_ADJUSTMENT_FLAG_6 | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice | |
| EXPENDITURE_COMMENT_6 | VARCHAR2 | (240) | The free text comment entered for an expenditure item to further describe work done | |
| EXPENDITURE_ITEM_ID_7 | NUMBER | (15) | The system-generated number that uniquely identifies the expenditure item | |
| EXPENDITURE_ITEM_DATE_7 | DATE | The date on which the work occurred | ||
| QUANTITY_7 | NUMBER | (22) | The number of units of the work performed | |
| SYSTEM_LINKAGE_FUNCTION_7 | VARCHAR2 | (30) | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | |
| NON_LABOR_RESOURCE_7 | VARCHAR2 | (20) | The non-labor resource utilized as the work was performed. This column is only populated for usage items | |
| ORGANIZATION_ID_7 | NUMBER | (15) | The identifier of the organization that owns the non-labor resource that was utilized as the work was performed. This column is only populated for usage items | |
| OVERRIDE_TO_ORGANIZATION_ID_7 | NUMBER | (15) | The identifier of the organization that the cost and revenue for this item are charged to by a cost distribution override entered for the project. For supplier invoices, the expenditure organization entered in Oracle Payables | |
| RAW_COST_7 | NUMBER | (22) | Raw cost in project Currency | |
| RAW_COST_RATE_7 | NUMBER | (22) | The raw cost rate used to cost the item | |
| ATTRIBUTE_CATEGORY_7 | VARCHAR2 | (30) | Descriptive flexfield context field | |
| ATTRIBUTE7_1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7_10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ORIG_TRANSACTION_REFERENCE_7 | VARCHAR2 | (50) | Only populated for expenditure items created from transactions imported into PA from an external system. The TRANSACTION_SOURCE and ORIG_TRANSACTION_REFERENCE columns together identify the expenditure item created after import. | |
| ADJUSTED_EXPENDITURE_ITEM_ID_7 | NUMBER | (15) | The identifier of the expenditure item adjusted by this expenditure item. Adjustment items are entered by users with negative amounts to fully reverse an item, or are system created to reverse a transferred item. | |
| NET_ZERO_ADJUSTMENT_FLAG_7 | VARCHAR2 | (1) | Flag that indicates whether the item is fully reversed or the item is one of the adjusting items that fully reverse another item. Generate Draft Invoice uses the flag to exclude fully reversed, uninvoiced items from a customer invoice | |
| EXPENDITURE_COMMENT_7 | VARCHAR2 | (240) | The free text comment entered for an expenditure item to further describe work done | |
| DENORM_TOTAL_QTY | NUMBER | (22) | The number of units of the work performed for the week | |
| DENORM_TOTAL_AMOUNT | NUMBER | (22) | Total raw cost in project Currency for the week | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| JOB_ID_1 | NUMBER | (15) | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | |
| JOB_ID_2 | NUMBER | (15) | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | |
| JOB_ID_3 | NUMBER | (15) | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | |
| JOB_ID_4 | NUMBER | (15) | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | |
| JOB_ID_5 | NUMBER | (15) | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | |
| JOB_ID_6 | NUMBER | (15) | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | |
| JOB_ID_7 | NUMBER | (15) | The identifier of the job of an employee as of the expenditure item date. Required for all items incurred by an employee. This may be used in the mapping of the transaction to a resource for project summary amounts. | |
| ADJUSTED_DENORM_ID | NUMBER | (15) | Identifies the original denorm transaction adjusted | |
| BILLABLE_FLAG_1 | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls. | |
| BILLABLE_FLAG_2 | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls. | |
| BILLABLE_FLAG_3 | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls. | |
| BILLABLE_FLAG_4 | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls. | |
| BILLABLE_FLAG_5 | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls. | |
| BILLABLE_FLAG_6 | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls. | |
| BILLABLE_FLAG_7 | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue. Upon entry, this flag is defaulted from the task to which the item is charged, or is based on transaction controls. |
Cut, paste (and edit) the following text to query this object:
SELECT EXPENDITURE_ID
, DENORM_ID
, PERSON_ID
, PROJECT_ID
, TASK_ID
, BILLABLE_FLAG
, EXPENDITURE_TYPE
, DEFAULT_SYS_LINK_FUNC
, UNIT_OF_MEASURE_CODE
, UNIT_OF_MEASURE
, EXPENDITURE_ITEM_ID_1
, EXPENDITURE_ITEM_DATE_1
, QUANTITY_1
, SYSTEM_LINKAGE_FUNCTION_1
, NON_LABOR_RESOURCE_1
, ORGANIZATION_ID_1
, OVERRIDE_TO_ORGANIZATION_ID_1
, RAW_COST_1
, RAW_COST_RATE_1
, ATTRIBUTE_CATEGORY_1
, ATTRIBUTE1_1
, ATTRIBUTE1_2
, ATTRIBUTE1_3
, ATTRIBUTE1_4
, ATTRIBUTE1_5
, ATTRIBUTE1_6
, ATTRIBUTE1_7
, ATTRIBUTE1_8
, ATTRIBUTE1_9
, ATTRIBUTE1_10
, ORIG_TRANSACTION_REFERENCE_1
, ADJUSTED_EXPENDITURE_ITEM_ID_1
, NET_ZERO_ADJUSTMENT_FLAG_1
, EXPENDITURE_COMMENT_1
, EXPENDITURE_ITEM_ID_2
, EXPENDITURE_ITEM_DATE_2
, QUANTITY_2
, SYSTEM_LINKAGE_FUNCTION_2
, NON_LABOR_RESOURCE_2
, ORGANIZATION_ID_2
, OVERRIDE_TO_ORGANIZATION_ID_2
, RAW_COST_2
, RAW_COST_RATE_2
, ATTRIBUTE_CATEGORY_2
, ATTRIBUTE2_1
, ATTRIBUTE2_2
, ATTRIBUTE2_3
, ATTRIBUTE2_4
, ATTRIBUTE2_5
, ATTRIBUTE2_6
, ATTRIBUTE2_7
, ATTRIBUTE2_8
, ATTRIBUTE2_9
, ATTRIBUTE2_10
, ORIG_TRANSACTION_REFERENCE_2
, ADJUSTED_EXPENDITURE_ITEM_ID_2
, NET_ZERO_ADJUSTMENT_FLAG_2
, EXPENDITURE_COMMENT_2
, EXPENDITURE_ITEM_ID_3
, EXPENDITURE_ITEM_DATE_3
, QUANTITY_3
, SYSTEM_LINKAGE_FUNCTION_3
, NON_LABOR_RESOURCE_3
, ORGANIZATION_ID_3
, OVERRIDE_TO_ORGANIZATION_ID_3
, RAW_COST_3
, RAW_COST_RATE_3
, ATTRIBUTE_CATEGORY_3
, ATTRIBUTE3_1
, ATTRIBUTE3_2
, ATTRIBUTE3_3
, ATTRIBUTE3_4
, ATTRIBUTE3_5
, ATTRIBUTE3_6
, ATTRIBUTE3_7
, ATTRIBUTE3_8
, ATTRIBUTE3_9
, ATTRIBUTE3_10
, ORIG_TRANSACTION_REFERENCE_3
, ADJUSTED_EXPENDITURE_ITEM_ID_3
, NET_ZERO_ADJUSTMENT_FLAG_3
, EXPENDITURE_COMMENT_3
, EXPENDITURE_ITEM_ID_4
, EXPENDITURE_ITEM_DATE_4
, QUANTITY_4
, SYSTEM_LINKAGE_FUNCTION_4
, NON_LABOR_RESOURCE_4
, ORGANIZATION_ID_4
, OVERRIDE_TO_ORGANIZATION_ID_4
, RAW_COST_4
, RAW_COST_RATE_4
, ATTRIBUTE_CATEGORY_4
, ATTRIBUTE4_1
, ATTRIBUTE4_2
, ATTRIBUTE4_3
, ATTRIBUTE4_4
, ATTRIBUTE4_5
, ATTRIBUTE4_6
, ATTRIBUTE4_7
, ATTRIBUTE4_8
, ATTRIBUTE4_9
, ATTRIBUTE4_10
, ORIG_TRANSACTION_REFERENCE_4
, ADJUSTED_EXPENDITURE_ITEM_ID_4
, NET_ZERO_ADJUSTMENT_FLAG_4
, EXPENDITURE_COMMENT_4
, EXPENDITURE_ITEM_ID_5
, EXPENDITURE_ITEM_DATE_5
, QUANTITY_5
, SYSTEM_LINKAGE_FUNCTION_5
, NON_LABOR_RESOURCE_5
, ORGANIZATION_ID_5
, OVERRIDE_TO_ORGANIZATION_ID_5
, RAW_COST_5
, RAW_COST_RATE_5
, ATTRIBUTE_CATEGORY_5
, ATTRIBUTE5_1
, ATTRIBUTE5_2
, ATTRIBUTE5_3
, ATTRIBUTE5_4
, ATTRIBUTE5_5
, ATTRIBUTE5_6
, ATTRIBUTE5_7
, ATTRIBUTE5_8
, ATTRIBUTE5_9
, ATTRIBUTE5_10
, ORIG_TRANSACTION_REFERENCE_5
, ADJUSTED_EXPENDITURE_ITEM_ID_5
, NET_ZERO_ADJUSTMENT_FLAG_5
, EXPENDITURE_COMMENT_5
, EXPENDITURE_ITEM_ID_6
, EXPENDITURE_ITEM_DATE_6
, QUANTITY_6
, SYSTEM_LINKAGE_FUNCTION_6
, NON_LABOR_RESOURCE_6
, ORGANIZATION_ID_6
, OVERRIDE_TO_ORGANIZATION_ID_6
, RAW_COST_6
, RAW_COST_RATE_6
, ATTRIBUTE_CATEGORY_6
, ATTRIBUTE6_1
, ATTRIBUTE6_2
, ATTRIBUTE6_3
, ATTRIBUTE6_4
, ATTRIBUTE6_5
, ATTRIBUTE6_6
, ATTRIBUTE6_7
, ATTRIBUTE6_8
, ATTRIBUTE6_9
, ATTRIBUTE6_10
, ORIG_TRANSACTION_REFERENCE_6
, ADJUSTED_EXPENDITURE_ITEM_ID_6
, NET_ZERO_ADJUSTMENT_FLAG_6
, EXPENDITURE_COMMENT_6
, EXPENDITURE_ITEM_ID_7
, EXPENDITURE_ITEM_DATE_7
, QUANTITY_7
, SYSTEM_LINKAGE_FUNCTION_7
, NON_LABOR_RESOURCE_7
, ORGANIZATION_ID_7
, OVERRIDE_TO_ORGANIZATION_ID_7
, RAW_COST_7
, RAW_COST_RATE_7
, ATTRIBUTE_CATEGORY_7
, ATTRIBUTE7_1
, ATTRIBUTE7_2
, ATTRIBUTE7_3
, ATTRIBUTE7_4
, ATTRIBUTE7_5
, ATTRIBUTE7_6
, ATTRIBUTE7_7
, ATTRIBUTE7_8
, ATTRIBUTE7_9
, ATTRIBUTE7_10
, ORIG_TRANSACTION_REFERENCE_7
, ADJUSTED_EXPENDITURE_ITEM_ID_7
, NET_ZERO_ADJUSTMENT_FLAG_7
, EXPENDITURE_COMMENT_7
, DENORM_TOTAL_QTY
, DENORM_TOTAL_AMOUNT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, JOB_ID_1
, JOB_ID_2
, JOB_ID_3
, JOB_ID_4
, JOB_ID_5
, JOB_ID_6
, JOB_ID_7
, ADJUSTED_DENORM_ID
, BILLABLE_FLAG_1
, BILLABLE_FLAG_2
, BILLABLE_FLAG_3
, BILLABLE_FLAG_4
, BILLABLE_FLAG_5
, BILLABLE_FLAG_6
, BILLABLE_FLAG_7
FROM PA.PA_EI_DENORM;
PA.PA_EI_DENORM does not reference any database object
PA.PA_EI_DENORM is referenced by following:
PA
PA_EI_DENORM#
|
|
|
|