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 |