PJC_TXN_XFACE_AUDIT_ALL

PA_TXN_INTERFACE_AUDIT_ALL is used for auditing the updates taking place on PA_TRANSACTION_INTERFACE_ALL table. For any update on columns other than the system populated columns, two records are created in this table. The before_after_flag will specify whether the record has pre-update or post-update values.

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

PJC_TXN_XFACE_AUDIT_ALL_PK

TXN_INTERFACE_ID

Columns

Name Datatype Length Precision Not-null Comments
TXN_INTERFACE_ID NUMBER 18 Yes The system generated number that uniquely identifies this transaction *****
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 are imported into PA in the same expenditure group, if processed together *****
HCM_ASSIGNMENT_ID NUMBER 18 HCM_ASSIGNMENT_ID *****
DOC_ENTRY_ID NUMBER 18 DOC_ENTRY_ID *****
DOC_ENTRY_NAME VARCHAR2 240 DOC_ENTRY_NAME *****
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 *****
EXPENDITURE_ITEM_DATE DATE Yes Date on which the transaction occurred *****
NON_LABOR_RESOURCE_ID NUMBER 18 NON_LABOR_RESOURCE_ID *****
PERSON_JOB_ID NUMBER 18 PERSON_JOB_ID *****
PROJECT_UNIT_ID NUMBER 18 PROJECT_UNIT_ID *****
PROJFUNC_BURDENED_COST NUMBER PROJFUNC_BURDENED_COST *****
PRVDR_ACCRUAL_DATE DATE PRVDR_ACCRUAL_DATE *****
PRVDR_GL_PERIOD_NAME VARCHAR2 20 PRVDR_GL_PERIOD_NAME *****
PRVDR_PA_DATE DATE PRVDR_PA_DATE *****
PRVDR_PA_PERIOD_NAME VARCHAR2 20 PRVDR_PA_PERIOD_NAME *****
RECVR_ACCRUAL_DATE DATE RECVR_ACCRUAL_DATE *****
RECVR_GL_DATE DATE RECVR_GL_DATE *****
RECVR_GL_PERIOD_NAME VARCHAR2 20 RECVR_GL_PERIOD_NAME *****
RECVR_ORG_ID NUMBER 18 RECVR_ORG_ID *****
RECVR_PA_DATE DATE RECVR_PA_DATE *****
RECVR_PA_PERIOD_NAME VARCHAR2 20 RECVR_PA_PERIOD_NAME *****
RESERVED_ATTRIBUTE1 VARCHAR2 150 RESERVED_ATTRIBUTE1 *****
RESERVED_ATTRIBUTE2 VARCHAR2 150 RESERVED_ATTRIBUTE2 *****
RESERVED_ATTRIBUTE3 VARCHAR2 150 RESERVED_ATTRIBUTE3 *****
RESERVED_ATTRIBUTE4 VARCHAR2 150 RESERVED_ATTRIBUTE4 *****
RESERVED_ATTRIBUTE5 VARCHAR2 150 RESERVED_ATTRIBUTE5 *****
RESERVED_ATTRIBUTE6 VARCHAR2 150 RESERVED_ATTRIBUTE6 *****
RESERVED_ATTRIBUTE7 VARCHAR2 150 RESERVED_ATTRIBUTE7 *****
RESERVED_ATTRIBUTE8 VARCHAR2 150 RESERVED_ATTRIBUTE8 *****
RESERVED_ATTRIBUTE9 VARCHAR2 150 RESERVED_ATTRIBUTE9 *****
RESERVED_ATTRIBUTE10 VARCHAR2 150 RESERVED_ATTRIBUTE10 *****
SOURCE_EXP_ITEM_ID NUMBER 18 SOURCE_EXP_ITEM_ID *****
TRANSACTION_SOURCE_CODE VARCHAR2 30 TRANSACTION_SOURCE_CODE *****
TRANSACTION_SOURCE_ID NUMBER 18 TRANSACTION_SOURCE_ID *****
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 *****
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 *****
PROJFUNC_RAW_COST NUMBER The total raw cost for the transaction as calculated in the original, external system. If the transaction source identifies the item as 'Costed' then PAloads the raw cost and ensures that the amount is never altered *****
EXPENDITURE_COMMENT VARCHAR2 240 User-entered free text comment to describe the transaction *****
TRANSACTION_STATUS_CODE VARCHAR2 2 Yes System-defined status of the transaction as it is loaded into PA *****
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.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
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 *****
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
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 theGL_ACCOUNTED_FLAG flag on the transaction source. This date is used to derive the PA_DATE on CDLs *****
BURDENED_COST_RATE NUMBER Burden Cost/Quantity *****
BURDENED_COST_CR_CCID NUMBER 18 BURDENED_COST_CR_CCID *****
BURDENED_COST_DR_CCID NUMBER 18 BURDENED_COST_DR_CCID *****
CAPITALIZABLE_FLAG VARCHAR2 1 A separate flag for capitalizable as separate from billable, since capital projects can now be billed. *****
CONVERTED_FLAG VARCHAR2 1 Flag indicates if the transaction is convereted from legacy applications and should be marked as converted. Transaction marked as converted have restrictions around what type of adjustments can be performed on them *****
DOCUMENT_ID NUMBER 18 DOCUMENT_ID *****
DOCUMENT_NAME VARCHAR2 240 DOCUMENT_NAME *****
SYSTEM_LINKAGE VARCHAR2 30 System Linkage or Expenditure Type Class of the transaction *****
BEFORE_AFTER_FLAG VARCHAR2 1 Yes Flag to identify before or after image of a transaction 'B' - before, 'A' - after *****
USER_TRANSACTION_SOURCE VARCHAR2 80 User-defined source for this transaction *****
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 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_RATE_DATE DATE Functional rate date for the transaction *****
ACCT_RATE_TYPE VARCHAR2 30 Functional rate type for the transaction *****
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_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 Identifier of the original transaction that has been reversed in the external system *****
BILLABLE_FLAG VARCHAR2 1 Flag that indicates if the item can accrue revenue *****
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_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. *****
ACCRUAL_FLAG VARCHAR2 1 Period-End Accrual Flag *****
PROJECT_ID NUMBER 18 Project Identifier *****
TASK_ID NUMBER 18 Task Identifier *****
PERSON_ID NUMBER 18 Person Identifier *****
ORGANIZATION_ID NUMBER 18 Organization Identifier *****
NON_LABOR_RESOURCE_ORG_ID NUMBER 18 Non Labor Resource Organization Identifier *****
VENDOR_ID NUMBER 18 Vendor Identifier *****
OVERRIDE_TO_ORGANIZATION_ID NUMBER 18 Override to Organization Identifier *****
WORK_TYPE_ID NUMBER Work Type Identifier *****
PERSON_TYPE VARCHAR2 30 Type of person who incurred the expenditure *****
UNIT_OF_MEASURE VARCHAR2 30 Base unit of measure *****
INVENTORY_ITEM_ID NUMBER Inventory item identifier *****
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 distribution line is not eligible to be interfaced to Oracle Assets.T - The distribution line is pending interface to Oracle Assets. *****
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. *****
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. *****
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, Purchasing, or Receiving. *****
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. *****
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. *****
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 *****
ENTERED_BY_PERSON_ID NUMBER 18 ENTERED_BY_PERSON_ID *****
EXP_GROUP_ID NUMBER 18 EXP_GROUP_ID *****
ORIGINAL_DIST_ID NUMBER 18 ORIGINAL_DIST_ID *****
ORIGINAL_HEADER_ID NUMBER 18 ORIGINAL_HEADER_ID *****
ORIGINAL_LINE_NUMBER NUMBER 18 ORIGINAL_LINE_NUMBER *****
PARENT_DIST_ID NUMBER 18 PARENT_DIST_ID *****
PARENT_HEADER_ID NUMBER 18 PARENT_HEADER_ID *****
PARENT_LINE_NUMBER NUMBER 18 PARENT_LINE_NUMBER *****
RAW_LINE_NUM_REVERSED NUMBER 18 RAW_LINE_NUM_REVERSED *****
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.
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.
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
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.
BUDGET_PERIOD_ID NUMBER 18 Identifier of Budget Period for which the funding is made.
LD_ORIG_TRANSACTION_REFERENCE VARCHAR2 120 Unique identifier of this record in the originating payroll system.
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.
BATCH_DESCRIPTION VARCHAR2 250 Description of the expenditure batch to which the unprocessed cost belongs.
BATCH_ENDING_DATE DATE The latest expenditure item date for the unprocessed costs that constitute an expenditure batch.
BILL_HOLD_FLAG VARCHAR2 1 Flag that indicates if item will be held from invoicing. Upon entry, it is nullable.
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.
CALC_INDIRECT_COST_FLAG VARCHAR2 1 Indicates if the application should derive the burden cost for the project cost transaction.
CALC_RAW_COST_FLAG VARCHAR2 1 Indicates if the application should derive the raw cost for the project cost transaction.
CDL_LINE_NUM NUMBER 18 Line Number of the Cost Distribution Line.
CDL_LINE_TYPE VARCHAR2 1 The type of the cost distribution line
COMP_DETAILS_ID NUMBER 18 Reference to Labor Rate Override.
CONTEXT_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for project-related standardized cost collection.
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.
COST_JOB_ID NUMBER 18 Identifier of the scheduled process that processed the cost transaction.
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
EI_CREATION_FLAG VARCHAR2 1 Indicates whether a project cost is created from the unprocessed cost 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).
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.
LABOR_COST_MULTIPLIER_NAME VARCHAR2 20 Name of the labor cost multiplier that is associated with the burden schedule for the project cost.
ORG_LABOR_SCH_RULE_ID NUMBER 18 Indicates the burden schedule associated for the organization of the project cost.
PLANNED_FLAG VARCHAR2 1 Identifier whether the transaction amount is planned or not.
PROJECT_RATE_DATE_TYPE VARCHAR2 4 Project Currency Conversion Date Type
PROJFUNC_RATE_DATE_TYPE VARCHAR2 4 Receiver Ledger Currency Conversion Date Type
RAISE_ACCT_EVENT_FLAG VARCHAR2 1 Indicates whether the Create Accounting process was run for the project cost.
RATE_OVERRIDE_ID NUMBER 18 Identifier of rate_override_id from pjf_rate_overrides table
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
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.
TRANSFERRED_FROM_EXP_ITEM_ID NUMBER 18 Identifier of the project cost whose transfer resulted in the creation of this project cost.
TXN_ACCUM_HEADER_ID NUMBER 18 Accum Header Identifier
VALIDATIONS_FLAG VARCHAR2 1 Flag that indicates if Validations module of the Import and Process was successful for the transaction.
TXN_REVIEW_COMMENT VARCHAR2 240 Comment entered for the unprocessed cost.
SRC_SYSTEM_LINKAGE_FUNCTION VARCHAR2 30 Indicates the document entry code associated with the project cost.
REVERSAL_FLAG VARCHAR2 1 Indicates if the project cost is created as a reversal of an existing project cost.
REFERENCE_ID5 NUMBER 18 Source Document Reference Identifier 5.
REFERENCE_ID4 NUMBER 18 Source Document Reference Identifier 4.
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_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_ID1 NUMBER 18 Source Document Reference Identifier 1. In the case of sales order issue transactions, this is the fulfillment line ID.
PROCESS_GROUP_ID NUMBER 18 Process Group Identifier.
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.
PRBS_ELEMENT_ID NUMBER 18 Planning resource breakdown structure element identifier of the planning resource that the transaction maps to.
PO_CATEGORY_ID NUMBER 18 PO Category ID
PARENT_REVERSAL_ID NUMBER 18 Identifier of the original project cost whose reversal resulted in the creation of this project cost.
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.
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.
ORDER_TYPE_LOOKUP_CODE VARCHAR2 30 Type of order line.
INV_ASSET_CATEGORY_ID NUMBER 18 Asset Category ID
EXPENDITURE_TYPE_ID NUMBER 18 Identifier of the Expenditure Type.
DOC_REF_ID5 VARCHAR2 120 Source Document Reference 5.
DOC_REF_ID4 VARCHAR2 120 Source Document Reference 4.
DOC_REF_ID3 VARCHAR2 500 Source Document Reference 3.
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_ID1 VARCHAR2 500 Source Document Reference 1. In the case of sales order issue transactions, this is the shipment number.
COMMITMENT_CONTROL_FLAG VARCHAR2 1 Indicates if the project cost transaction is eligible for budgetary control.
CMR_TRANSACTION_TYPE_CODE VARCHAR2 40 Receiving Transaction Type Code
CMR_TRANSACTION_DATE DATE The date when the receiving transaction was created.
CMR_EXP_ADJUSTMENT_FLAG VARCHAR2 1 Receiving Cost Adjustment Type Code
CMR_EVENT_COST_ID NUMBER 18 Receiving Cost Event ID
CMR_ACCOUNTING_EVENT_ID NUMBER 18 Receiving Accounting Event ID
BACKING_HEADER_ID1 NUMBER 18 Backing Header Identifier One
BACKING_DIST_ID3 NUMBER 18 Backing Distribution Identifier Three
BACKING_DIST_ID2 NUMBER 18 Backing Distribution Identifier Two
BACKING_DIST_ID1 NUMBER 18 Backing Distribution Identifier One
BACKING_AMOUNT NUMBER Backing Distribution Amount
ACCT_RATE_DATE_TYPE VARCHAR2 4 Provider Ledger Currency Conversion Date Type.
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Indicates whether items are accrued upon receipt.
ACCT_CURRENCY_CODE VARCHAR2 15 Functional Currency Code.
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.
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 Source Document Reference Identifier 7.
REFERENCE_ID8 NUMBER 18 Source Document Reference Identifier 8.
REFERENCE_ID9 NUMBER 18 Source Document Reference Identifier 9.
REFERENCE_ID10 NUMBER 18 Source Document Reference Identifier 10.
DOC_REF_ID6 VARCHAR2 120 Source Document Reference 6.
DOC_REF_ID7 VARCHAR2 120 Source Document Reference 7.
DOC_REF_ID8 VARCHAR2 120 Source Document Reference 8.
DOC_REF_ID9 VARCHAR2 120 Source Document Reference 9.
DOC_REF_ID10 VARCHAR2 120 Source Document Reference 10.
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_AUDIT_ALL pjf_work_types_b WORK_TYPE_ID
PJC_TXN_XFACE_AUDIT_ALL pjf_txn_document_b DOCUMENT_ID
PJC_TXN_XFACE_AUDIT_ALL pjf_txn_doc_entry_b DOC_ENTRY_ID
PJC_TXN_XFACE_AUDIT_ALL pjf_projects_all_b PROJECT_ID
PJC_TXN_XFACE_AUDIT_ALL pjf_proj_elements_b TASK_ID

Indexes

Index Uniqueness Tablespace Columns
PJC_TXN_XFACE_AUDIT_ALL_N2 Non Unique Default EXPENDITURE_ITEM_ID
PJC_TXN_XFACE_AUDIT_ALL_U1 Unique Default TXN_INTERFACE_ID