PJC_TXN_XFACE_ALL
PA_TRANSACTION_INTERFACE_ALL is the table you use for importing transactions from external sources into Oracle Projects. You load this table with your transaction data and then submit the Transaction Import process to validate and import the data into the Oracle Projects expenditure tables. . .
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJC_TXN_XFACE_ALL_PK |
TXN_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| TXN_INTERFACE_ID | NUMBER | 18 | Yes | System generated identifier that uniquely identifies a imported transaction | |||
| RATE_OVERRIDE_ID | NUMBER | 18 | Identifier of rate_override_id from pjf_rate_overrides table | ||||
| TRANSACTION_SOURCE_ID | NUMBER | 18 | Identifier of the Transaction Source. ***** | ||||
| TRANSACTION_SOURCE_CODE | VARCHAR2 | 30 | TRANSACTION_SOURCE_CODE ***** | ||||
| ACCOUNTING_STATUS_CODE | VARCHAR2 | 5 | ACCOUNTING_STATUS_CODE ***** | ||||
| DOCUMENT_ID | NUMBER | 18 | Identifier for the Projects-related categorization of the document type that is creating this transaction. ***** | ||||
| DOCUMENT_NAME | VARCHAR2 | 240 | Projects-related categorization of the document type that is creating this transaction. ***** | ||||
| DOC_ENTRY_ID | NUMBER | 18 | Identifier of Projects-related categorization of the document type that is creating this transaction. ***** | ||||
| PARENT_REVERSAL_ID | NUMBER | 18 | PARENT_REVERSAL_ID ***** | ||||
| REVERSAL_FLAG | VARCHAR2 | 1 | REVERSAL_FLAG ***** | ||||
| PERSON_JOB_ID | NUMBER | 18 | PERSON_JOB_ID ***** | ||||
| DOC_ENTRY_NAME | VARCHAR2 | 240 | Name of the Document Entry. ***** | ||||
| LANGUAGE | VARCHAR2 | 4 | Indicates the code of the language into which the contents of the translatable columns are translated. | Obsolete | |||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Yes | Identifier of the Expenditure Type. ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| BURDEN_SUM_DEST_RUN_ID | NUMBER | 18 | BURDEN_SUM_DEST_RUN_ID ***** | ||||
| PROJFUNC_BURDENED_COST | NUMBER | PROJFUNC_BURDENED_COST ***** | |||||
| PROJFUNC_RAW_COST | NUMBER | PROJFUNC_RAW_COST ***** | |||||
| PRVDR_ACCRUAL_DATE | DATE | PRVDR_ACCRUAL_DATE ***** | |||||
| RECVR_ACCRUAL_DATE | DATE | RECVR_ACCRUAL_DATE ***** | |||||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Accum Header Identifier ***** | ||||
| COST_IND_COMPILED_SET_ID | NUMBER | 18 | COST_IND_COMPILED_SET_ID ***** | ||||
| LABOR_COST_MULTIPLIER_NAME | VARCHAR2 | 20 | LABOR_COST_MULTIPLIER_NAME ***** | ||||
| BATCH_NAME | VARCHAR2 | 200 | Yes | User-entered name for a grouping of expenditures in the interface table.For one transaction source, all items with the same BATCH_NAME areimported into Oracle Projects in the same expenditure group, if processed together. | |||
| BATCH_DESCRIPTION | VARCHAR2 | 250 | BATCH_DESCRIPTION ***** | ||||
| BATCH_ENDING_DATE | DATE | BATCH_ENDING_DATE ***** | |||||
| EXPENDITURE_ITEM_DATE | DATE | Yes | Date on which the transaction occurred | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| EXPENDITURE_ENDING_DATE | DATE | Yes | The date of the last day in the expenditure week. PA uses this value to group transactions into expenditures. All items must be dated on or before their EXPENDITURE_ENDING_DATE | ||||
| PRVDR_PA_DATE | DATE | PRVDR_PA_DATE ***** | |||||
| PRVDR_PA_PERIOD_NAME | VARCHAR2 | 20 | PRVDR_PA_PERIOD_NAME ***** | ||||
| RECVR_PA_DATE | DATE | RECVR_PA_DATE ***** | |||||
| RECVR_PA_PERIOD_NAME | VARCHAR2 | 20 | RECVR_PA_PERIOD_NAME ***** | ||||
| GL_DATE | DATE | GL_DATE to be copied to PA_COST_DISTRIBUTION_LINES.GL_DATE for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG flag on the transaction source. This date is used to derive the PA_DATE on CDLs. | |||||
| PRVDR_GL_PERIOD_NAME | VARCHAR2 | 20 | PRVDR_GL_PERIOD_NAME ***** | ||||
| RECVR_GL_DATE | DATE | RECVR_GL_DATE ***** | |||||
| RECVR_GL_PERIOD_NAME | VARCHAR2 | 20 | RECVR_GL_PERIOD_NAME ***** | ||||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Identifier of the Non-labor resource utilized when incurring the transaction charge. ***** | ||||
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | 18 | Non-Labor Resource Organization Identifier | ||||
| QUANTITY | NUMBER | Yes | Number of units for the transaction. This column is defined with a precision of '2' in order to maintain consistency with PA's expenditure entry forms which round expenditure item quantities to '2' decimal places when saved to the database | ||||
| EXPENDITURE_COMMENT | VARCHAR2 | 240 | User-entered free text comment to describe the transaction | ||||
| PROCESS_GROUP_ID | NUMBER | 18 | PROCESS_GROUP_ID ***** | ||||
| EI_CREATION_FLAG | VARCHAR2 | 1 | EI_CREATION_FLAG ***** | ||||
| RAISE_ACCT_EVENT_FLAG | VARCHAR2 | 1 | RAISE_ACCT_EVENT_FLAG ***** | ||||
| TRANSACTION_STATUS_CODE | VARCHAR2 | 2 | Yes | System-defined status of the transaction as it is loaded into PA | |||
| TIEBACK_STATUS_CODE | VARCHAR2 | 1 | TIEBACK_STATUS_CODE ***** | ||||
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | Yes | User-entered value used to identify the transaction in an external system from which the imported item originated. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Project Unprocessed Expenditure Item (PJC_TXN_XFACE_DESC_FLEX) | |||
| RAW_COST_RATE | NUMBER | The cost rate used to calculate the transaction's raw cost amount. PA loads this cost rate for transactions identified by a 'Costed' transaction source. PA performs no validation on this value, and it is used only for reporting purposes | |||||
| INTERFACE_ID | NUMBER | 18 | System-generated number that identifies all the transactions processed by a given concurrent request | ||||
| UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | 1 | Flag used to identify certain adjustments (transactions with negative quantities) as summary-level adjustments for which there is no single matching item in PA to reverse. When this flag is 'Y', PA does not execute the matching value | ||||
| EXPENDITURE_ITEM_ID | NUMBER | 18 | The system-generated number that uniquely identifies the expenditure item | ||||
| CDL_LINE_NUM | NUMBER | 18 | Line Number of the Cost Distribution Line. ***** | ||||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |||
| CONVERTED_FLAG | VARCHAR2 | 1 | Flag that indicates if the transaction is converted from legacy applications and should be marked as converted. Transactions marked as converted have restrictions around what type of adjustments can be performed on them. ***** | ||||
| BURDENED_COST_RATE | NUMBER | Burden cost rate used to calculate burden cost | |||||
| SYSTEM_LINKAGE | VARCHAR2 | 30 | System Linkage or Expenditure Type Class of the transaction | ||||
| SRC_SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | 30 | SRC_SYSTEM_LINKAGE_FUNCTION ***** | ||||
| USER_TRANSACTION_SOURCE | VARCHAR2 | 240 | The descriptive name of the transaction source | ||||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||||
| 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 | |||||
| CALC_RAW_COST_FLAG | VARCHAR2 | 1 | CALC_RAW_COST_FLAG ***** | ||||
| CALC_INDIRECT_COST_FLAG | VARCHAR2 | 1 | CALC_INDIRECT_COST_FLAG ***** | ||||
| COMP_DETAILS_ID | NUMBER | 18 | COMP_DETAILS_ID ***** | ||||
| ORG_LABOR_SCH_RULE_ID | NUMBER | 18 | ORG_LABOR_SCH_RULE_ID ***** | ||||
| DENOM_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code of the transaction | ||||
| DENOM_RAW_COST | NUMBER | Raw cost in Transaction currency | |||||
| DENOM_BURDENED_COST | NUMBER | Burdened cost in Transaction currency | |||||
| ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Functional Currency Code. ***** | ||||
| ACCT_RATE_DATE | DATE | Functional conversion rate date for the transaction | |||||
| ACCT_RATE_TYPE | VARCHAR2 | 30 | Functional conversion rate type for the transaction | ||||
| ACCT_RATE_DATE_TYPE | VARCHAR2 | 4 | Provider Ledger Currency Conversion Date Type ***** | ||||
| ACCT_EXCHANGE_RATE | NUMBER | Functional exchange rate for the transaction | |||||
| ACCT_RAW_COST | NUMBER | Raw cost in functional currency | |||||
| ACCT_BURDENED_COST | NUMBER | Burdened cost in Functional currency | |||||
| ACCT_EXCHANGE_ROUNDING_LIMIT | NUMBER | Rounding limit for imported transactions | |||||
| PROJECT_CURRENCY_CODE | VARCHAR2 | 15 | 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 Currency Conversion Date Type ***** | ||||
| PROJECT_EXCHANGE_RATE | NUMBER | Project exchange rate for the transaction | |||||
| ORIG_EXP_TXN_REFERENCE1 | VARCHAR2 | 60 | Expenditure Identifier in external system(system reference). For Oracle Payables, invoice ID should be populated into this field | ||||
| ORIG_EXP_TXN_REFERENCE2 | VARCHAR2 | 60 | Additional colum provided to group transactions into expenditures | ||||
| ORIG_EXP_TXN_REFERENCE3 | VARCHAR2 | 60 | Additional colum provided to group transactions into expenditures | ||||
| ORIG_USER_EXP_TXN_REFERENCE | VARCHAR2 | 60 | Expenditure Identifier in external system(user reference). For Oracle Payables, invoice number should be populated into this field | ||||
| REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | 120 | Value used to identify the transaction being reversed in the external system from which the imported item originated | ||||
| BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if the item can accrue revenue | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization. ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| BILL_HOLD_FLAG | VARCHAR2 | 1 | Flag that indicates if item will be held from invoicing. Upon entry, it is nullable. | ||||
| REVENUE_HOLD_FLAG | VARCHAR2 | 1 | This column indicates whether the item will be on hold for revenue processing or not. Upon entry, it is nullable. | ||||
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | 15 | Project functional currency code | ||||
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | 30 | Rate type used to convert costs from transaction currency to project functional currency. | ||||
| PROJFUNC_COST_RATE_DATE | DATE | Rate date used to convert costs from the transaction currency to the project currency. | |||||
| PROJFUNC_RATE_DATE_TYPE | VARCHAR2 | 4 | Receiver Ledger Currency Conversion Date Type ***** | ||||
| PROJFUNC_COST_EXCHANGE_RATE | NUMBER | Exchange rate used to convert costs from the transaction currency to the project functional currency. | |||||
| PROJECT_RAW_COST | NUMBER | Raw cost in project currency. | |||||
| PROJECT_BURDENED_COST | NUMBER | Burdened cost in project currency. | |||||
| HCM_ASSIGNMENT_ID | NUMBER | 18 | The HCM assignment for which the transaction was created. ***** | ||||
| WORK_TYPE_ID | NUMBER | 18 | Work Type Identifier | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| ACCRUAL_FLAG | VARCHAR2 | 1 | Indicates whether the imported transaction is automatically reversed in the next accounting period. | ||||
| PROJECT_ID | NUMBER | 18 | Yes | Project Identifier | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| TASK_ID | NUMBER | 18 | Yes | Task Identifier | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | ||
| PERSON_ID | NUMBER | 18 | Person Identifier | ||||
| VENDOR_ID | NUMBER | 18 | Vendor Identifier | ||||
| ORGANIZATION_ID | NUMBER | 18 | Organization Identifier | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| OVERRIDE_TO_ORGANIZATION_ID | NUMBER | 18 | Override to Organization Identifier | ||||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier | ||||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Base unit of measure | ||||
| PERSON_TYPE | VARCHAR2 | 30 | Type of person who incurred the expenditure | ||||
| ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | 18 | The supplier cost interface process uses this column to create an adjusting expenditure item copies the value to the PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID column. | ||||
| TRANSFERRED_FROM_EXP_ITEM_ID | NUMBER | 18 | TRANSFERRED_FROM_EXP_ITEM_ID ***** | ||||
| SOURCE_EXP_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. | ||||
| DOCUMENT_TYPE | VARCHAR2 | 30 | The supplier cost interface process uses this column to indicate the transaction type and copies the value to the PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_TYPE column. 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 and copies the value to the PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE column. Valid values are as follows: Payables, Purchas | ||||
| ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | 1 | Indicates whether items are accrued upon receipt. ***** | ||||
| SI_ASSETS_ADDITION_FLAG | VARCHAR2 | 1 | This column indicates the status of the cost distribution line in relation to Oracle Assets. It only applies to supplier cost expenditure items. Valid values are as follows:Y - The distribution line is interfaced to Oracle Assets.N - The d | ||||
| SC_XFER_CODE | VARCHAR2 | 1 | The supplier cost interface process uses this column to indicate the GL transfer status code in another application for the distribution line. | ||||
| ADJUSTED_TXN_INTERFACE_ID | NUMBER | 18 | The supplier cost interface process uses this column to indicate the transaction interface identifier of an adjusted expenditure item. | ||||
| NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | 1 | The supplier cost interface process uses this column to indicate that the item is a net-zero expenditure item. | ||||
| 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. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||||
| CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE1 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE2 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE3 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE4 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE5 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE6 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE7 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE8 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE9 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE10 ***** | Project Costing Details (PROJECTS_STD_COST_COLLECTION) | |||
| PROJECT_UNIT_ID | NUMBER | 18 | Project Unit Identifier. ***** | ||||
| COMMITMENT_CONTROL_FLAG | VARCHAR2 | 1 | COMMITMENT_CONTROL_FLAG ***** | ||||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||||
| 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. | ||||
| ACCT_EVENT_ID | NUMBER | 18 | ACCT_EVENT_ID ***** | ||||
| ACCT_SOURCE_CODE | VARCHAR2 | 10 | ACCT_SOURCE_CODE ***** | ||||
| ALLOW_CC_FLAG | VARCHAR2 | 1 | This flag determines if Cross Charge processing is allowed or not.For external Oracle Import, this flag is derived from the setup data atProject, Task and Document Entry level. For external third party import, this flag should be populated while interfacing the data into PATI. ***** | ||||
| BURDENED_COST_CR_CCID | NUMBER | 18 | BURDENED_COST_CR_CCID ***** | ||||
| BURDENED_COST_DR_CCID | NUMBER | 18 | BURDENED_COST_DR_CCID ***** | ||||
| CDL_LINE_NUM_REVERSED | NUMBER | 18 | For a reversing cdl the adjustment API should populate it with the line num of the original cdl. (Add to XDF) ***** | ||||
| COST_SCHEDULE_ID | NUMBER | 18 | Cost Rate Schedule Identifier ***** | ||||
| COST_SCHEDULE_LINE_ID | NUMBER | 18 | Cost Rate Schedule Line Identifier ***** | ||||
| DERIVATIONS_FLAG | VARCHAR2 | 1 | Flag that indicates if Derivations module of the Import and Process was successful for the transaction ***** | ||||
| ERROR_GROUP | VARCHAR2 | 30 | Indicates the processing stage that resulted in the error. Values correspond to the lookup type PJC_TI_STAGE (1.Pre-Processing Client Extension 2.Post-Processing Client Extension 3.Validation 4.Derivation 5.Additional Transaction Creation 6.Costing 7.Accounting 8.Commitment Control). ***** | ||||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | ORDER_TYPE_LOOKUP_CODE ***** | ||||
| ORIG_HISTORICAL_FLAG | VARCHAR2 | 1 | For a reversing EI it should be populated with the historical_flag of the original EI. For a reversing cdl it should be populated with the historical_flag on the same EI. This has to be done by the Adjustment API while creating the adjustment records in PATI. ***** | ||||
| VALIDATIONS_FLAG | VARCHAR2 | 1 | Flag that indicates if Validations module of the Import and Process was successful for the transaction. ***** | ||||
| COST_JOB_ID | NUMBER | 18 | COST_JOB_ID ***** | ||||
| RECVR_ORG_ID | NUMBER | 18 | RECVR_ORG_ID ***** | ||||
| COMMS_NL_TRACKABLE_FLAG | VARCHAR2 | 1 | COMMS_NL_TRACKABLE_FLAG ***** | ||||
| CDL_LINE_TYPE | VARCHAR2 | 1 | CDL_LINE_TYPE ***** | ||||
| CDL_PARENT_LINE_NUM | NUMBER | 18 | CDL_PARENT_LINE_NUM ***** | ||||
| TXN_REVIEW_COMMENT | VARCHAR2 | 240 | TXN_REVIEW_COMMENT ***** | ||||
| RAW_COST_CR_CCID | NUMBER | 18 | RAW_COST_CR_CCID ***** | ||||
| RAW_COST_DR_CCID | NUMBER | 18 | RAW_COST_DR_CCID ***** | ||||
| BURDEN_COST_CR_CCID | NUMBER | 18 | BURDEN_COST_CR_CCID ***** | ||||
| BURDEN_COST_DR_CCID | NUMBER | 18 | BURDEN_COST_DR_CCID ***** | ||||
| RAW_LINE_NUM_REVERSED | NUMBER | 18 | RAW_LINE_NUM_REVERSED ***** | ||||
| EXP_GROUP_ID | NUMBER | 18 | EXP_GROUP_ID ***** | ||||
| 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 ***** | ||||
| 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 override. | ||||
| PRBS_ELEMENT_ID | NUMBER | 18 | Planning resource breakdown structure element identifier of the planning resource that the transaction maps to. | ||||
| PRBS_TXN_ACCUM_HEADER_ID | NUMBER | 18 | Unique identifier for the transaction attributes that are used for mapping and deriving a planning resource breakdown structure element. | ||||
| BUDGET_CCID | NUMBER | 18 | Budget account used for budget checking raw cost. | ||||
| BUDGETARY_CONTROL_VAL_STATUS | VARCHAR2 | 30 | Budgetary control validation status at the distribution level. | ||||
| DATA_SET_ID | NUMBER | 18 | Identifies data for a particular budgetary control request. | ||||
| BUDGET_PERIOD_ID | NUMBER | 18 | Identifier of Budget Period for which the funding is made. | ||||
| PLANNED_FLAG | VARCHAR2 | 1 | Identifier whether the transaction amount is palnned or not. | ||||
| BACKING_HEADER_ID1 | NUMBER | 18 | Backing Header Identifier One | ||||
| BACKING_DIST_ID1 | NUMBER | 18 | Backing Distribution Identifier One | ||||
| BACKING_DIST_ID2 | NUMBER | 18 | Backing Distribution Identifier Two | ||||
| BACKING_DIST_ID3 | NUMBER | 18 | Backing Distribution Identifier Three | ||||
| BACKING_AMOUNT | NUMBER | Backing Distribution Amount | |||||
| 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 | ||||
| CMR_TRANSACTION_DATE | DATE | The date when the receiving transaction was created. | |||||
| 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. | ||||
| 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. | ||||
| SOURCE_FUNDS_STATUS | VARCHAR2 | 30 | Budgetary control validation status of the source distribution. | ||||
| 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. | ||||
| LAST_COSTED_DATE | DATE | Date on which the costing process was last run and the cost measures of the transaction were derived. | |||||
| COST_RATE_MULTIPLIER | NUMBER | Labor costing multiplier value that was derived during the last run of the costing process. This value is used to calculate the raw cost. For example, quantity * raw cost rate * labor costing multiplier value = raw cost. | |||||
| 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. | ||||
| BACKING_HEADER_ID2 | NUMBER | 18 | Backing Header Identifier Two | ||||
| BACKING_LEDGER_CURR_AMT | NUMBER | Backing Ledger Currency Amount | |||||
| BACKING_DIST_ID4 | NUMBER | 18 | Backing Distribution Identifier Four | ||||
| BACKING_DIST_ID5 | NUMBER | 18 | Backing Distribution Identifier Five | ||||
| BACKING_DIST_ID6 | NUMBER | 18 | Backing Distribution Identifier Six | ||||
| TOP_PRBS_ELEMENT_ID | NUMBER | 18 | The identifier of the top resource derived for the transaction using the planning resource breakdown structure. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_TXN_XFACE_ALL | pjf_work_types_b | WORK_TYPE_ID |
| PJC_TXN_XFACE_ALL | pjf_rate_overrides | RATE_OVERRIDE_ID |
| PJC_TXN_XFACE_ALL | pjf_exp_types_b | EXPENDITURE_TYPE_ID |
| PJC_TXN_XFACE_ALL | pjf_txn_document_b | DOCUMENT_ID |
| PJC_TXN_XFACE_ALL | pjf_txn_doc_entry_b | DOC_ENTRY_ID |
| PJC_TXN_XFACE_ALL | gl_daily_conversion_types | PROJFUNC_COST_RATE_TYPE |
| PJC_TXN_XFACE_ALL | pjf_projects_all_b | PROJECT_ID |
| PJC_TXN_XFACE_ALL | pjf_proj_elements_b | TASK_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_TXN_XFACE_ALL_N1 | Non Unique | Default | ORG_ID, INTERFACE_ID |
| PJC_TXN_XFACE_ALL_N10 | Non Unique | Default | TRANSFERRED_FROM_EXP_ITEM_ID |
| PJC_TXN_XFACE_ALL_N11 | Non Unique | Default | SOURCE_EXP_ITEM_ID |
| PJC_TXN_XFACE_ALL_N12 | Non Unique | Default | PROJECT_UNIT_ID |
| PJC_TXN_XFACE_ALL_N13 | Non Unique | Default | TRANSACTION_SOURCE_ID, DOCUMENT_ID, DOC_ENTRY_ID |
| PJC_TXN_XFACE_ALL_N14 | Non Unique | Default | REQUEST_ID |
| PJC_TXN_XFACE_ALL_N15 | Non Unique | Default | UPPER("BATCH_NAME") |
| PJC_TXN_XFACE_ALL_N16 | Non Unique | Default | DATA_SET_ID |
| PJC_TXN_XFACE_ALL_N17 | Non Unique | Default | BUDGETARY_CONTROL_VAL_STATUS, PROJECT_ID |
| PJC_TXN_XFACE_ALL_N18 | Non Unique | Default | ORIG_TRANSACTION_REFERENCE |
| PJC_TXN_XFACE_ALL_N19 | Non Unique | Default | DISTRIBUTION_ID |
| PJC_TXN_XFACE_ALL_N2 | Non Unique | Default | PROCESS_GROUP_ID |
| PJC_TXN_XFACE_ALL_N3 | Non Unique | Default | INTERFACE_ID |
| PJC_TXN_XFACE_ALL_N4 | Non Unique | Default | BATCH_NAME |
| PJC_TXN_XFACE_ALL_N5 | Non Unique | Default | EXPENDITURE_ITEM_ID |
| PJC_TXN_XFACE_ALL_N6 | Non Unique | Default | TRANSACTION_STATUS_CODE |
| PJC_TXN_XFACE_ALL_N7 | Non Unique | Default | ADJUSTED_EXPENDITURE_ITEM_ID |
| PJC_TXN_XFACE_ALL_N8 | Non Unique | Default | PROJECT_ID, TRANSACTION_STATUS_CODE, PROJECT_CURRENCY_CODE, TRANSACTION_SOURCE_ID, QUANTITY, PROJECT_RAW_COST, PROJECT_BURDENED_COST |
| PJC_TXN_XFACE_ALL_N9 | Non Unique | Default | ORG_ID, TRANSACTION_SOURCE_ID, DOCUMENT_ID |
| PJC_TXN_XFACE_ALL_U1 | Unique | Default | TXN_INTERFACE_ID |