PJC_EXP_ITEMS_ALL
PA_EXPENDITURE_ITEMS_ALL stores the smallest categorized expenditure units charged to projects and tasks.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJC_EXP_ITEMS_ALL_PK |
EXPENDITURE_ITEM_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| EXPENDITURE_ITEM_ID | NUMBER | 18 | Yes | The system-generated number that uniquely identifies the expenditure item | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| TASK_ID | NUMBER | 18 | Yes | The identifier of the task to which the expenditure item is charged | ||
| EXPENDITURE_ITEM_DATE | DATE | Yes | The date on which the work occurred | |||
| BILLABLE_FLAG | VARCHAR2 | 1 | Yes | 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. | ||
| BILL_BY_COST_CODE | VARCHAR2 | 30 | BILL_BY_COST_CODE ***** | |||
| REVENUE_RECOGNIZED_FLAG | VARCHAR2 | 1 | REVENUE_RECOGNIZED_FLAG ***** | |||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | TXN_ACCUM_HEADER_ID ***** | |||
| IC_BILLABLE_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates if transaction is eligible for Intercompany billing. ***** | ||
| BILL_HOLD_FLAG | VARCHAR2 | 1 | Yes | Flag that indicates if the item is held from invoicing. Upon entry, this flag is defaulted to 'N'. | ||
| QUANTITY | NUMBER | Yes | The number of units of the work performed | |||
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | 18 | 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 ***** | |||
| PERSON_JOB_ID | NUMBER | 18 | 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. ***** | |||
| OVERRIDE_TO_ORGANIZATION_ID | NUMBER | 18 | 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 | |||
| PROJFUNC_RAW_COST | NUMBER | Yes | Raw cost in project Functional Currency ***** | |||
| RAW_COST_RATE | NUMBER | The raw cost rate used to cost the item | ||||
| PROJFUNC_BURDENED_COST | NUMBER | Yes | The burden cost in project functional currency ***** | |||
| BURDEN_COST_RATE | NUMBER | The burdened cost rate of the item. Burdened cost rate = (burden cost / quantity ). | ||||
| LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | 20 | The labor cost multiplier specified for a premium labor expenditure item in order to determine the premium labor cost. Cost = (cost rate*quantity*LCM). This is populated by the timecard entry forms or the Overtime Calculation program | |||
| INVOICED_FLAG | VARCHAR2 | 1 | INVOICED_FLAG ***** | |||
| INVOICED_PERCENTAGE | NUMBER | INVOICED_PERCENTAGE ***** | ||||
| PERIOD_ACCRUAL_FLAG | VARCHAR2 | 1 | PERIOD_ACCRUAL_FLAG ***** | |||
| REVENUE_HOLD_FLAG | VARCHAR2 | 1 | Yes | REVENUE_HOLD_FLAG ***** | ||
| ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | 18 | 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 | 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 | |||
| TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | 18 | The identifier of the expenditure item from which this expenditure item originated. This expenditure item is the new item that is system created when an item is transferred and is charged to the new project/task | |||
| CONVERTED_FLAG | VARCHAR2 | 1 | Flag set to 'Y' if the item is converted. If the item is converted, no adjustments to the item's revenue or cost are allowed. Adjustments allowed are 'Edit Comments', 'Bill Hold', 'One-Time Billing Hold', and 'Release Bill Hold' | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Expenditure Item (PJC_EXP_ITEMS_DESC_FLEX) | ||
| COST_IND_COMPILED_SET_ID | NUMBER | 18 | The identifier of the compiled set that is used to calculate the cost amount of the expenditure item | |||
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | 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. | |||
| PROJECT_ID | NUMBER | 18 | Yes | The project_id of the event that the expenditure item is FIFO marked by | ||
| SOURCE_EXPENDITURE_ITEM_ID | NUMBER | 18 | Stores the transaction number of the raw cost for which the separate burden cost was created. This is populated for burden cost transactions only if burden grouping is configured in the Project Process Configurator to group burden costs by transaction number. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| PROJECT_UNIT_ID | NUMBER | 18 | PROJECT_UNIT_ID ***** | |||
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 3 | Yes | The system linkage that classifies the expenditure type in order to drive system processing for the items classified by the expenditure type | ||
| BURDEN_SUM_DEST_RUN_ID | NUMBER | 18 | Burden summarization run id. Id will identify all the expenditure items created by burden component summarization process. This is used to identify all the Cost distribution lines summarized together to create expenditure item | |||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | Receipt currency amount of the transaction | ||||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | 15 | Receipt currency code of the transaction | |||
| RECEIPT_EXCHANGE_RATE | NUMBER | Receipt exchange rate for the transaction | ||||
| DENOM_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Transaction Currency code of the transaction | ||
| DENOM_RAW_COST | NUMBER | Yes | The total raw cost of the expenditure item in transaction currency Raw cost = (quantity * cost rate) This value should always equal the sum of the items raw cost distribution lines | |||
| DENOM_BURDENED_COST | NUMBER | Yes | Total burdened cost of the expenditure item in transaction currency Burdened cost = (raw cost * (1 + burden cost multiplier)) This must equal the sum of the items burden debit cost distribution lines For non-burdened items, burdened cost | |||
| ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Account currency code of the transaction | ||
| ACCT_RATE_DATE | DATE | Functional Rate date for the Transaction | ||||
| ACCT_RATE_TYPE | VARCHAR2 | 30 | Functional rate type for the transaction | |||
| ACCT_RATE_DATE_TYPE | VARCHAR2 | 4 | ACCT_RATE_DATE_TYPE ***** | |||
| ACCT_EXCHANGE_RATE | NUMBER | Functional Exchange Rate for the Transaction | ||||
| ACCT_RAW_COST | NUMBER | Yes | Raw cost in Functional Currency | |||
| ACCT_BURDENED_COST | NUMBER | Yes | Burdened Cost in Functional Currency | |||
| ACCT_EXCHANGE_ROUNDING_LIMIT | NUMBER | Rounding limit for imported transaction | ||||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Project Currency Code of the Transaction | ||
| PROJECT_RATE_DATE | DATE | Project Rate date for the Transaction | ||||
| PROJECT_RATE_TYPE | VARCHAR2 | 30 | Project Rate Type for the Transaction | |||
| PROJECT_RATE_DATE_TYPE | VARCHAR2 | 4 | PROJECT_RATE_DATE_TYPE ***** | |||
| PROJECT_EXCHANGE_RATE | NUMBER | Project Exchange Rate for Transaction | ||||
| CC_CROSS_CHARGE_CODE | VARCHAR2 | 1 | Yes | Indicates the method of cross charge processing that will be or has been performed on an Expenditure Item. | ||
| CC_PROCESSED_FLAG | VARCHAR2 | 1 | CC_PROCESSED_FLAG ***** | |||
| CC_PRVDR_ORGANIZATION_ID | NUMBER | 18 | Identifier of the provider organization. This may be different than the expenditure organization or the non-labor resource organization, if it is overridden by the client extension to derive provider organization | |||
| CC_RECVR_ORGANIZATION_ID | NUMBER | 18 | Identifier of the receiver organization. This may be different than the project organization, if it is overridden by the client extension to derive receiver organization | |||
| CC_REJECTION_CODE | VARCHAR2 | 30 | Code indicating rejection reason encountered while processing cross charge | |||
| DENOM_TP_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code of the transfer price | |||
| DENOM_TRANSFER_PRICE | NUMBER | Transfer price in the transaction currency | ||||
| ACCT_TP_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert the transfer price from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price | |||
| ACCT_TP_RATE_DATE | DATE | Rate date used to convert the transfer price from the transaction currency to the functional currency. | ||||
| ACCT_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price from the transaction currency to the provider functional currency | ||||
| ACCT_TRANSFER_PRICE | NUMBER | Transfer price in functional currency of the provider operating unit | ||||
| PROJACCT_TRANSFER_PRICE | NUMBER | Transfer price in the functional currency of cross charged project (receiver operating unit) | ||||
| CC_MARKUP_BASE_CODE | VARCHAR2 | 1 | Audit column.to help derive how transfer price wsa calculated. Basis used to calculate the transfer price. | |||
| TP_BASE_AMOUNT | NUMBER | Audit column. Base amount used to derive the transfer price, held in transfer price transaction currency | ||||
| CC_CROSS_CHARGE_TYPE | VARCHAR2 | 2 | Cross Charge Type | |||
| RECVR_ORG_ID | NUMBER | 18 | Receiver Operating Unit Identifier | |||
| CC_BL_DISTRIBUTED_CODE | VARCHAR2 | 1 | Yes | Indicates the processing status of the Expenditure Item by the Distribute Borrowed and Lent Accounts process | ||
| TP_IND_COMPILED_SET_ID | NUMBER | 18 | Identifier of the compiled set used to calculate the Transfer Price using a burden schedule | |||
| TP_BILL_RATE | NUMBER | Audit column. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule | ||||
| TP_BILL_MARKUP_PERCENTAGE | NUMBER | Audit column. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule | ||||
| TP_SCHEDULE_LINE_PERCENTAGE | NUMBER | Audit column. Percentage applied to the calculated transfer price from the schedule line | ||||
| TP_RULE_PERCENTAGE | NUMBER | Audit column. Percentage applied to the calculated transfer price from the rule definition | ||||
| CC_PRVDR_COST_RECLASS_CODE | VARCHAR2 | 1 | Indicates if the cost for the expenditure item is reclassified for intercompany billing | |||
| COST_JOB_ID | NUMBER | 18 | Costing Job ID | |||
| TP_JOB_ID | NUMBER | 18 | Borrowed/Lent Job ID | |||
| COST_DIST_WARNING_CODE | VARCHAR2 | 30 | During funds check if the transaction passes in advisory mode then this column will be updated with the apropriate warning. | |||
| PROJECT_TP_RATE_DATE | DATE | Rate date used to convert transfer price from the transaction currency to the project currency. | ||||
| PROJECT_TP_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert transfer price from the transaction currency to the project currency. | |||
| PROJECT_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert transfer price from the transaction currency to the project currency. | ||||
| PROJFUNC_TP_RATE_DATE | DATE | Rate date used to convert transfer price from the transaction currency to the project functional currency. | ||||
| PROJFUNC_TP_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert transfer price from the transaction currency to the project functional currency. | |||
| PROJFUNC_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert transfer price from the transaction currency to the project functional currency. | ||||
| PROJFUNC_TRANSFER_PRICE | NUMBER | Transfer price in project functional currency. | ||||
| PROJFUNC_COST_RATE_DATE | DATE | Rate date used to convert costs from the transaction currency to the project functional currency. | ||||
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert costs from the transaction currency to the project functional currency. | |||
| PROJFUNC_RATE_DATE_TYPE | VARCHAR2 | 4 | PROJFUNC_RATE_DATE_TYPE ***** | |||
| PROJFUNC_COST_EXCHANGE_RATE | NUMBER | Exchange rate used to convert costs from the transaction currency to the project functional currency. | ||||
| COST_SCHEDULE_ID | NUMBER | 18 | Cost rate schedule identifier. ***** | |||
| COST_SCHEDULE_LINE_ID | NUMBER | 18 | Cost rate schedule line identifier. ***** | |||
| PRVDR_ACCRUAL_DATE | DATE | Provider operating unit accounting date for transactions included in a reversing expenditure batch. | ||||
| PROJECT_RAW_COST | NUMBER | Yes | Raw cost in project currency. | |||
| PROJECT_BURDENED_COST | NUMBER | Yes | Burdened cost in project currency. | |||
| HCM_ASSIGNMENT_ID | NUMBER | 18 | HCM_ASSIGNMENT_ID ***** | |||
| WORK_TYPE_ID | NUMBER | 18 | Identifier for a work type assigned to the transaction. | |||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Project functional currency code. | ||
| PROJECT_TRANSFER_PRICE | NUMBER | Transfer price in project currency. | ||||
| TP_AMT_TYPE_CODE | VARCHAR2 | 30 | Cross charge classification. | |||
| BILL_TRANS_CURRENCY_CODE | VARCHAR2 | 15 | Bill transaction currency code for the expenditure item for accrued revenue and bill amounts | |||
| BILL_TRANS_CURR_REV_AMT | NUMBER | Accrued revenue amount of expenditure item in Bill transaction currency. ***** | ||||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Yes | Identifier of the expenditure type. ***** | ||
| RECVR_ACCRUAL_DATE | DATE | Receiver operating unit accounting date for transactions included in a reversing expenditure batch. | ||||
| ADJUSTMENT_TYPE | VARCHAR2 | 150 | Adjustment Type Code | |||
| ADJUSTMENT_STATUS | VARCHAR2 | 20 | ADJUSTMENT_STATUS ***** | |||
| CAPITAL_EVENT_ID | NUMBER | 18 | Capital Event Identifier to which the expenditure item is assigned. | |||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier | |||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Base unit of measure | |||
| SRC_SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 30 | The system linkage of the source expenditure items which were summarized to create separate burden transaction. | |||
| VENDOR_ID | NUMBER | 18 | This column indicates the vendor identifier for supplier cost transactions. If the expenditure item originated in Oracle Payables, it holds the AP_INVOICES_ALL.VENDOR_ID. If the expenditure item originated in Oracle Purchasing, it holds the | |||
| DOCUMENT_TYPE | VARCHAR2 | 30 | The supplier cost interface process uses this column to indicate the transaction type. Valid values are as follows: Payables, Purchasing, or Receiving. | |||
| DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | 30 | The supplier cost interface process uses this column to indicate the transaction type of the distribution. Valid values are as follows: Payables, Purchasing, or Receiving. | |||
| HISTORICAL_FLAG | VARCHAR2 | 1 | Historical Flag | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Yes | A separate flag for capitalizable as separate from billable, since capital projects can now be billed. ***** | ||
| CAPITALIZATION_DIST_FLAG | VARCHAR2 | 1 | CAPITALIZATION_DIST_FLAG ***** | |||
| IC_BILL_HOLD_FLAG | VARCHAR2 | 1 | Yes | IC_BILL_HOLD_FLAG ***** | ||
| IC_INVOICED_FLAG | VARCHAR2 | 1 | IC_INVOICED_FLAG ***** | |||
| IC_INVOICED_PERCENTAGE | NUMBER | IC_INVOICED_PERCENTAGE ***** | ||||
| IC_LEDGER_CURR_INV_AMT | NUMBER | IC_LEDGER_CURR_INV_AMT ***** | ||||
| IC_LEDGER_CURR_REV_AMT | NUMBER | IC_LEDGER_CURR_REV_AMT ***** | ||||
| IC_PROJECT_CURR_INV_AMT | NUMBER | IC_PROJECT_CURR_INV_AMT ***** | ||||
| IC_PROJECT_CURR_REV_AMT | NUMBER | IC_PROJECT_CURR_REV_AMT ***** | ||||
| IC_RBS_ELEMENT_ID | NUMBER | 18 | IC_RBS_ELEMENT_ID ***** | |||
| IC_REV_RECOG_PERCENTAGE | NUMBER | IC_REV_RECOG_PERCENTAGE ***** | ||||
| IC_REVENUE_HOLD_FLAG | VARCHAR2 | 1 | Yes | IC_REVENUE_HOLD_FLAG ***** | ||
| IC_REVENUE_RECOGNIZED_FLAG | VARCHAR2 | 1 | IC_REVENUE_RECOGNIZED_FLAG ***** | |||
| LEDGER_CURR_INV_AMT | NUMBER | LEDGER_CURR_INV_AMT ***** | ||||
| LEDGER_CURR_REV_AMT | NUMBER | LEDGER_CURR_REV_AMT ***** | ||||
| MANUAL_FLAG | VARCHAR2 | 1 | MANUAL_FLAG ***** | |||
| PROJECT_CURR_INV_AMT | NUMBER | PROJECT_CURR_INV_AMT ***** | ||||
| PROJECT_CURR_REV_AMT | NUMBER | PROJECT_CURR_REV_AMT ***** | ||||
| RBS_ELEMENT_ID | NUMBER | 18 | RBS_ELEMENT_ID ***** | |||
| REVENUE_RECOG_PERCENTAGE | NUMBER | REVENUE_RECOG_PERCENTAGE ***** | ||||
| TRANSACTION_SOURCE_ID | NUMBER | 18 | Yes | TRANSACTION_SOURCE_ID ***** | ||
| DOCUMENT_ID | NUMBER | 18 | Yes | Projects-related categorization of the document type that is creating this transaction. ***** | ||
| DOC_ENTRY_ID | NUMBER | 18 | Yes | Projects-relates sub-categorication of the document type that is creating this transaction. ***** | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Identifier of the non labor resource. ***** | |||
| PERSON_TYPE | VARCHAR2 | 30 | Identifies the type of person - employee or contingent worker. ***** | |||
| INCURRED_BY_PERSON_ID | NUMBER | 18 | INCURRED_BY_PERSON_ID ***** | |||
| INCURRED_BY_ORGANIZATION_ID | NUMBER | 18 | INCURRED_BY_ORGANIZATION_ID ***** | |||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | Yes | EXPENDITURE_ORGANIZATION_ID for the Exp item which holds the value NVL(OVERRIDE_TO_ORGANIZATION_ID,INCURRED_BY_ORGANIZATION_ID) | ||
| EXP_GROUP_ID | NUMBER | 18 | Yes | EXP_GROUP_ID ***** | ||
| EXPENDITURE_ENDING_DATE | DATE | EXPENDITURE_ENDING_DATE ***** | ||||
| ORIGINAL_HEADER_ID | NUMBER | 18 | ORIGINAL_HEADER_ID ***** | |||
| ORIGINAL_LINE_NUMBER | NUMBER | 18 | ORIGINAL_LINE_NUMBER ***** | |||
| ORIGINAL_DIST_ID | NUMBER | 18 | Source Transaction Distribution Reference which is the identifier used to retrieve the account for the inventory and receipt costs imported into Project Costing. For example, in the case of miscellaneous issue to project transactions, this is the offset account identifier. | |||
| PARENT_HEADER_ID | NUMBER | 18 | PARENT_HEADER_ID ***** | |||
| PARENT_LINE_NUMBER | NUMBER | 18 | PARENT_LINE_NUMBER ***** | |||
| PARENT_DIST_ID | NUMBER | 18 | PARENT_DIST_ID ***** | |||
| PRVDR_LEGAL_ENTITY_ID | NUMBER | 18 | PRVDR_LEGAL_ENTITY_ID ***** | |||
| IC_BILL_BY_COST_CODE | VARCHAR2 | 1 | IC_BILL_BY_COST_CODE ***** | |||
| IC_TP_AMT_TYPE_CODE | VARCHAR2 | 30 | IC_TP_AMT_TYPE_CODE ***** | |||
| IC_TP_BASE_CODE | VARCHAR2 | 30 | IC_TP_BASE_CODE ***** | |||
| INV_EXCLUDE_FLAG | VARCHAR2 | 1 | INV_EXCLUDE_FLAG ***** | |||
| REV_EXCLUDE_FLAG | VARCHAR2 | 1 | REV_EXCLUDE_FLAG ***** | |||
| REVENUE_EXCEPTION_FLAG | VARCHAR2 | 1 | REVENUE_EXCEPTION_FLAG ***** | |||
| INVOICE_EXCEPTION_FLAG | VARCHAR2 | 1 | INVOICE_EXCEPTION_FLAG ***** | |||
| CONTEXT_CATEGORY | VARCHAR2 | 40 | CONTEXT_CATEGORY ***** | |||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | |||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | |||
| USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE1 ***** | |||
| USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE2 ***** | |||
| USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE3 ***** | |||
| USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE4 ***** | |||
| USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE5 ***** | |||
| USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE6 ***** | |||
| USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE7 ***** | |||
| USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE8 ***** | |||
| USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE9 ***** | |||
| USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE10 ***** | |||
| RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | |||
| CONTRACT_ID | NUMBER | 18 | Unique Identifier of the contract. | |||
| CONTRACT_LINE_ID | NUMBER | 18 | Unique Identifier of the contract line. | |||
| FUNDING_ALLOCATION_ID | NUMBER | 18 | Specifies the name of the project funding source. | |||
| BUDGETARY_CONTROL_VAL_STATUS | VARCHAR2 | 30 | Budgetary control validation status at the transaction level. | |||
| XCC_BTC_STATUS | VARCHAR2 | 10 | Budgetary control distribution status indicating if the burden transaction cost process will pick up a separate line burden transaction. | |||
| PLANNED_FLAG | VARCHAR2 | 1 | Identifier whether the transaction amount is palnned or not. | |||
| CMR_ACCOUNTING_EVENT_ID | NUMBER | 18 | Receiving Accounting Event ID | |||
| CMR_EVENT_COST_ID | NUMBER | 18 | Receiving Cost Event ID | |||
| CMR_EXP_ADJUSTMENT_FLAG | VARCHAR2 | 1 | Receiving Cost Adjustment Type Code | |||
| INV_ASSET_CATEGORY_ID | NUMBER | 18 | Asset Category ID | |||
| PO_CATEGORY_ID | NUMBER | 18 | PO Category ID | |||
| CMR_TRANSACTION_TYPE_CODE | VARCHAR2 | 40 | Receiving Transaction Type Code | |||
| BATCH_PROCESS_ID | NUMBER | 18 | Unique identifier for a batch that identifies and classifies a set of mutually exclusive cross-charge transactions allong with other batches ar part of parallel processing | |||
| EXT_OVRD_BILL_RATE | NUMBER | The rate at which the expenditure item is to be billed on an external or interproject contract. | ||||
| EXT_OVRD_BILL_RATE_CURR_CODE | VARCHAR2 | 15 | The currency of the external bill rate for the expenditure item. | |||
| EXT_OVRD_BILL_RATE_SOURCE_NAME | VARCHAR2 | 150 | The name of the external source from where the external bill rate originates. | |||
| EXT_OVRD_BILL_RATE_SOURCE_REF | VARCHAR2 | 30 | The unique identifier of the external bill rate in the external source. | |||
| IC_OVRD_BILL_RATE | NUMBER | The rate at which the expenditure item is to be billed on an itercompany contract. | ||||
| IC_OVRD_BILL_RATE_CURR_CODE | VARCHAR2 | 15 | The currency of the intercompany bill rate for the expenditure item. | |||
| IC_OVRD_BILL_RATE_SOURCE_NAME | VARCHAR2 | 150 | The name of the external source from where the intercompany bill rate originates. | |||
| IC_OVRD_BILL_RATE_SOURCE_REF | VARCHAR2 | 30 | The unique identifier of the intercompany bill rate in the external source. | |||
| ORIGINAL_DIST_ID2 | NUMBER | 18 | Peer Source Transaction Distribution Reference which is the identifier used to retrieve the counterpart account of the source transaction distribution reference. For example, in the case of miscellaneous issue to project transactions, this is the inventory valuation account identifier. | |||
| DOC_REF_ID1 | VARCHAR2 | 500 | Source Document Reference 1. In the case of sales order issue transactions, this is the shipment number. | |||
| DOC_REF_ID2 | VARCHAR2 | 500 | Source Document Reference 2. In the case of sales order issue transactions, this is the sales order number. | |||
| DOC_REF_ID3 | VARCHAR2 | 500 | Source Document Reference 3. | |||
| DOC_REF_ID4 | VARCHAR2 | 120 | Source Document Reference 4. | |||
| DOC_REF_ID5 | VARCHAR2 | 120 | Source Document Reference 5. | |||
| REFERENCE_ID1 | NUMBER | 18 | Source Document Reference Identifier 1. In the case of sales order issue transactions, this is the fulfillment line ID. | |||
| REFERENCE_ID2 | NUMBER | 18 | Source Document Reference Identifier 2. In the case of work order resource transactions, this is the labor resource instance record identifier. | |||
| REFERENCE_ID3 | NUMBER | 18 | Source Document Reference Identifier 3. In the case of work order resource transactions, this is the equipment resource instance record identifier. | |||
| REFERENCE_ID4 | NUMBER | 18 | Source Document Reference Identifier 4. | |||
| REFERENCE_ID5 | NUMBER | 18 | Source Document Reference Identifier 5. | |||
| USER_BATCH_NAME | VARCHAR2 | 200 | User Batch Name. | |||
| EXPENDITURE_COMMENT | VARCHAR2 | 240 | The free text comment entered for an expenditure item to further describe work done. | |||
| LD_ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | Unique identifier of this record in the originating payroll system. | |||
| CREATION_SOURCE | VARCHAR2 | 30 | The source from which the cost transaction was created, for example, FBDI, ADFdi, and so on. | |||
| TXN_XFACE_CTRL_ID | NUMBER | 18 | Identifier of the expenditure batch to which the project cost belongs | |||
| DISTRIBUTION_ID | NUMBER | 18 | Source transaction surrogate identifying distribution header record. | |||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Source transaction type identifier. | |||
| BASE_TXN_ACTION_ID | NUMBER | 18 | Source transaction action identifier. | |||
| SOURCE_TXN_QUANTITY | NUMBER | Source transaction number of units. | ||||
| REFERENCE_ID6 | NUMBER | 18 | Source Document Reference Identifier 6. | |||
| REFERENCE_ID7 | NUMBER | 18 | The payroll identifier associated with the interfaced cost. | |||
| REFERENCE_ID8 | NUMBER | 18 | Allocation run identification number for Payroll integration. | |||
| REFERENCE_ID9 | NUMBER | 18 | The unique identifier of the payroll run action used to get accounting information associated with the cost. | |||
| REFERENCE_ID10 | NUMBER | 18 | The unique identifier of the payroll cost action used to get accounting information associated with the cost. | |||
| DOC_REF_ID6 | VARCHAR2 | 120 | Source Document Reference 6. | |||
| DOC_REF_ID7 | VARCHAR2 | 120 | User name for payroll. | |||
| DOC_REF_ID8 | VARCHAR2 | 120 | The unique payroll action identifier of the cost. This identifier is used to gather accounting information associated with the cost. | |||
| DOC_REF_ID9 | VARCHAR2 | 120 | Source Document Reference 9. | |||
| DOC_REF_ID10 | VARCHAR2 | 120 | Source Document Reference 10. | |||
| PROJECT_ROLE_ID | NUMBER | 18 | Unique id of the project role associated with the project cost transaction. | |||
| COST_ID | NUMBER | 18 | The unique identifier of the cost. This identifier is used to gather accounting information associated with the cost. | |||
| COST_ALLOCATION_KEYFLEX_ID | NUMBER | 18 | The unique identifier of the cost allocation flex field associated with the cost. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_EXP_ITEMS_ALL | pjf_proj_elements_b | TASK_ID |
| PJC_EXP_ITEMS_ALL | pjf_projects_all_b | PROJECT_ID |
| PJC_EXP_ITEMS_ALL | gl_daily_conversion_types | PROJFUNC_TP_RATE_TYPE |
| PJC_EXP_ITEMS_ALL | pjf_system_linkages | SYSTEM_LINKAGE_FUNCTION |
| PJC_EXP_ITEMS_ALL | pjf_exp_types_b | EXPENDITURE_TYPE_ID |
| PJC_EXP_ITEMS_ALL | gl_daily_conversion_types | ACCT_RATE_TYPE |
| PJC_EXP_ITEMS_ALL | pjf_bu_impl_all | RECVR_ORG_ID |
| PJC_EXP_ITEMS_ALL | gl_daily_conversion_types | PROJECT_RATE_TYPE |
| PJC_EXP_ITEMS_ALL | gl_daily_conversion_types | ACCT_TP_RATE_TYPE |
| PJC_EXP_ITEMS_ALL | gl_daily_conversion_types | PROJECT_TP_RATE_TYPE |
| PJC_EXP_ITEMS_ALL | gl_daily_conversion_types | PROJFUNC_COST_RATE_TYPE |
| PJC_EXP_ITEMS_ALL | pjf_work_types_b | WORK_TYPE_ID |
| PJC_EXP_ITEMS_ALL | pjf_txn_sources_b | TRANSACTION_SOURCE_ID |
| pjc_cc_dist_lines_all | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| pjc_txn_upgrade_temp | pjc_exp_items_all | PK1_ID |
| pjc_pati_adj_queue | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| pjc_acct_sweeper_logs | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| pjb_errors | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| pjc_expend_item_adj_acts | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| pjc_alloc_txn_details | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| pjc_exp_comments | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
| pjc_cost_dist_lines_all | pjc_exp_items_all | EXPENDITURE_ITEM_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_EXP_ITEMS_ALL_N1 | Non Unique | Default | PROJECT_ID, TASK_ID |
| PJC_EXP_ITEMS_ALL_N10 | Non Unique | Default | ORIG_TRANSACTION_REFERENCE, TRANSACTION_SOURCE_ID, DOCUMENT_ID |
| PJC_EXP_ITEMS_ALL_N11 | Non Unique | Default | COST_IND_COMPILED_SET_ID |
| PJC_EXP_ITEMS_ALL_N12 | Non Unique | Default | ADJUSTMENT_TYPE, ORG_ID |
| PJC_EXP_ITEMS_ALL_N13 | Non Unique | Default | PROJECT_UNIT_ID, ORG_ID |
| PJC_EXP_ITEMS_ALL_N14 | Non Unique | Default | SOURCE_EXPENDITURE_ITEM_ID |
| PJC_EXP_ITEMS_ALL_N15 | Non Unique | Default | EXP_GROUP_ID, ORG_ID, PROJECT_ID |
| PJC_EXP_ITEMS_ALL_N16 | Non Unique | Default | INCURRED_BY_PERSON_ID |
| PJC_EXP_ITEMS_ALL_N17 | Non Unique | Default | LAST_UPDATE_DATE |
| PJC_EXP_ITEMS_ALL_N18 | Non Unique | Default | BURDEN_SUM_DEST_RUN_ID |
| PJC_EXP_ITEMS_ALL_N19 | Non Unique | Default | COST_SCHEDULE_LINE_ID |
| PJC_EXP_ITEMS_ALL_N2 | Non Unique | Default | CAPITAL_EVENT_ID |
| PJC_EXP_ITEMS_ALL_N21 | Non Unique | Default | BUDGETARY_CONTROL_VAL_STATUS, PROJECT_ID |
| PJC_EXP_ITEMS_ALL_N22 | Non Unique | Default | PROJECT_ID, PROJECT_UNIT_ID, TRANSACTION_SOURCE_ID, DOCUMENT_ID, DOC_ENTRY_ID |
| PJC_EXP_ITEMS_ALL_N23 | Non Unique | Default | TP_IND_COMPILED_SET_ID |
| PJC_EXP_ITEMS_ALL_N24 | Non Unique | Default | EXPENDITURE_ITEM_DATE |
| PJC_EXP_ITEMS_ALL_N25 | Non Unique | Default | PRVDR_ACCRUAL_DATE |
| PJC_EXP_ITEMS_ALL_N26 | Non Unique | Default | VENDOR_ID |
| PJC_EXP_ITEMS_ALL_N27 | Non Unique | Default | CC_BL_DISTRIBUTED_CODE, REQUEST_ID |
| PJC_EXP_ITEMS_ALL_N28 | Non Unique | Default | RECVR_ORG_ID, PROJECT_ID |
| PJC_EXP_ITEMS_ALL_N29 | Non Unique | Default | INVOICED_FLAG |
| PJC_EXP_ITEMS_ALL_N3 | Non Unique | Default | TRANSACTION_SOURCE_ID, CAPITAL_EVENT_ID |
| PJC_EXP_ITEMS_ALL_N33 | Non Unique | Default | TRANSACTION_SOURCE_ID, DOCUMENT_ID, DOC_ENTRY_ID, EXPENDITURE_ITEM_DATE, PARENT_DIST_ID |
| PJC_EXP_ITEMS_ALL_N34 | Non Unique | Default | WORK_TYPE_ID |
| PJC_EXP_ITEMS_ALL_N35 | Non Unique | Default | NON_LABOR_RESOURCE_ID |
| PJC_EXP_ITEMS_ALL_N36 | Non Unique | Default | CC_CROSS_CHARGE_CODE, ORG_ID, CC_BL_DISTRIBUTED_CODE |
| PJC_EXP_ITEMS_ALL_N37 | Non Unique | Default | ORIGINAL_HEADER_ID |
| PJC_EXP_ITEMS_ALL_N38 | Non Unique | Default | PARENT_HEADER_ID |
| PJC_EXP_ITEMS_ALL_N39 | Non Unique | Default | BATCH_PROCESS_ID |
| PJC_EXP_ITEMS_ALL_N4 | Non Unique | Default | EXPENDITURE_TYPE_ID, CAPITAL_EVENT_ID |
| PJC_EXP_ITEMS_ALL_N40 | Non Unique | Default | DISTRIBUTION_ID |
| PJC_EXP_ITEMS_ALL_N41 | Non Unique | PJC_EXP_ITEMS_ALL_N41 | INVENTORY_ITEM_ID |
| PJC_EXP_ITEMS_ALL_N5 | Non Unique | Default | ORG_ID, TRANSACTION_SOURCE_ID, DOCUMENT_ID |
| PJC_EXP_ITEMS_ALL_N6 | Non Unique | Default | ADJUSTMENT_STATUS |
| PJC_EXP_ITEMS_ALL_N7 | Non Unique | Default | ORG_ID, INCURRED_BY_PERSON_ID |
| PJC_EXP_ITEMS_ALL_N8 | Non Unique | Default | SYSTEM_LINKAGE_FUNCTION, LABOR_COST_MULTIPLIER_NAME |
| PJC_EXP_ITEMS_ALL_N9 | Non Unique | Default | EXPENDITURE_ORGANIZATION_ID |
| PJC_EXP_ITEMS_ALL_U1 | Unique | Default | EXPENDITURE_ITEM_ID |