[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_TXN_INTERFACE_AUDIT_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_TXN_INTERFACE_AUDIT_ALL
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_TXN_INTERFACE_AUDIT_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 TXN_INTERFACE_ID
|
| PA_TXN_INTERFACE_AUDIT_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EXPENDITURE_ITEM_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_SOURCE | VARCHAR2 | (30) | Yes | Implementation-defined name used to classify the transaction by the type of expenditure incurred |
| BATCH_NAME | VARCHAR2 | (240) | 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 |
| 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 | |
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | The employee number of the person who incurred the expenditure. Labor and expense report items must be linked to an employee, but usages can be entered for an organization instead of an employee | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | The name of the organization that incurred the expenditure. If an employee is specified, this column can be NULL sincePA derives its value based on the employee's organizationassignment as of the expenditure item date | |
| EXPENDITURE_ITEM_DATE | DATE | Yes | Date on which the transaction occurred | |
| PROJECT_NUMBER | VARCHAR2 | (25) | Number identifying the project to which the transaction is charged | |
| TASK_NUMBER | VARCHAR2 | (25) | Number identifying the task to which the transaction is charged | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Expenditure type that classifies the kind of charge for the transaction |
| NON_LABOR_RESOURCE | VARCHAR2 | (20) | Non-labor resource utilized when incurring the transaction charge. This column is only populated for usage transactions | |
| NON_LABOR_RESOURCE_ORG_NAME | VARCHAR2 | (240) | Name of the organization that owns the non-labor resource utilized. This column is only populated for usage items | |
| 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 |
| TRANSACTION_REJECTION_CODE | VARCHAR2 | (30) | System-defined reason why Transaction Import rejected the item | |
| EXPENDITURE_ID | NUMBER | (15) | System-defined number populated by Transaction Import to identify transactions it has grouped into an expenditure | |
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | (50) | 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 context field | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| INTERFACE_ID | NUMBER | (15) | 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 | (15) | The system-generated number that uniquely identifies the expenditure item | |
| ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations | |
| DR_CODE_COMBINATION_ID | NUMBER | (15) | Identifier of the debit code combination ID for transactions that are accounted for in external system | |
| CR_CODE_COMBINATION_ID | NUMBER | (15) | Identifier of the credit code combination ID for transactions that are accounted for in external system | |
| CDL_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Reference to be copied to PA_COST_DISTRIBUTION_LINES.SYSTEM_REFERENCE1 for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG on the transaction source | |
| CDL_SYSTEM_REFERENCE2 | VARCHAR2 | (30) | Reference to be copied to PA_COST_DISTRIBUTION_LINES.SYSTEM_REFERENCE2 for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG on the transaction source | |
| CDL_SYSTEM_REFERENCE3 | VARCHAR2 | (30) | Reference to be copied to PA_COST_DISTRIBUTION_LINES.SYSTEM_REFERENCE3 for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG on the transaction source | |
| 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 | ||
| SYSTEM_LINKAGE | VARCHAR2 | (30) | System Linkage or Expenditure Type Class of the transaction | |
| TXN_INTERFACE_ID | NUMBER | (15) | Yes | The system generated number that uniquely identifies this transaction |
| BEFORE_AFTER_FLAG | VARCHAR2 | (1) | Yes | Flag to identify before or after image of a transaction 'B' - before, 'A' - after |
| UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| UPDATE_DATE | DATE | Yes | Standard Who column | |
| 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 | |
| OVERRIDE_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | Supplier Invoice Distribution's override to organization name | |
| REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | (30) | Identifier of the original transaction that has been reversed in the external system | |
| VENDOR_NUMBER | VARCHAR2 | (30) | Supplier Number | |
| BILLABLE_FLAG | VARCHAR2 | (1) | Flag that indicates if the item can accrue revenue | |
| PERSON_BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Name of the business group to which this transaction is charged. | |
| 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. | ||
| ASSIGNMENT_NAME | VARCHAR2 | (80) | The type of work for which the transaction was created. | |
| WORK_TYPE_NAME | VARCHAR2 | (80) | The type of work for which the transaction was created. | |
| CDL_SYSTEM_REFERENCE4 | VARCHAR2 | (30) | Reference to be copied to PA_COST_DISTRIBUTION_LINES_ALL. SYSTEM_REFERENCE4 for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG flag on the transaction source | |
| ACCRUAL_FLAG | VARCHAR2 | (1) | Period-End Accrual Flag | |
| PROJECT_ID | NUMBER | (15) | Project Identifier | |
| TASK_ID | NUMBER | (15) | Task Identifier | |
| PERSON_ID | NUMBER | (15) | Person Identifier | |
| ORGANIZATION_ID | NUMBER | (15) | Organization Identifier | |
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | (15) | Non Labor Resource Organization Identifier | |
| VENDOR_ID | NUMBER | (15) | Vendor Identifier | |
| OVERRIDE_TO_ORGANIZATION_ID | NUMBER | (15) | Override to Organization Identifier | |
| ASSIGNMENT_ID | NUMBER | (15) | Assignment Identifier | |
| WORK_TYPE_ID | NUMBER | Work Type Identifier | ||
| PERSON_BUSINESS_GROUP_ID | NUMBER | (15) | Person Business Group Identifier | |
| PO_NUMBER | VARCHAR2 | (20) | Purchase order number | |
| PO_HEADER_ID | NUMBER | Purchase order unique identifier | ||
| PO_LINE_NUM | NUMBER | Purchase order line number | ||
| PO_LINE_ID | NUMBER | Purchase order line identifier | ||
| PERSON_TYPE | VARCHAR2 | (30) | Type of person who incurred the expenditure | |
| PO_PRICE_TYPE | VARCHAR2 | (30) | Purchase order line price type for contingent worker labor transactions | |
| UNIT_OF_MEASURE | VARCHAR2 | (30) | Base unit of measure | |
| WIP_RESOURCE_ID | NUMBER | Identifier of the resource for work in progress | ||
| 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. | |
| CDL_SYSTEM_REFERENCE5 | NUMBER | (30) | The supplier cost interface and transaction import processes use this column to refer to a record in another application. When the cost distribution line is related to Oracle Payables transactions, it holds the AP_INVOICE_DISTRIBUTIONS_ALL. INVOICE_DISTRIBUTION_ID and the interface process copies the value to the PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_ID column. When the cost distribution line is related to manufacturing or receiving transactions, it holds the debit subledger identifier and the import process copies the value to the PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE5 column. This column is not used for labor or usage transactions. | |
| FC_DOCUMENT_TYPE | VARCHAR2 | (3) | The supplier cost interface process uses this column to indicate the types of documents that require funds checking. Valid values are as follows: Commitments, Actuals, Both, or None. | |
| ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | (15) | 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 | (15) | 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. | |
| JOB_ID | NUMBER | (15) | HR job identifier | |
| JOB_NAME | VARCHAR2 | (700) | Name of the job | |
| LOCATION_ID | NUMBER | (15) | HR location identifier | |
| LOCATION_CODE | VARCHAR2 | (20) | Name of the location | |
| PAY_ELEMENT_TYPE_ID | NUMBER | (9) | Pay element identifier | |
| QUANTITY#1 | NUMBER | Yes | ||
| RAW_COST#1 | NUMBER | |||
| RAW_COST_RATE#1 | NUMBER | |||
| BURDENED_COST#1 | NUMBER | |||
| BURDENED_COST_RATE#1 | NUMBER | |||
| CBS_ELEMENT_ID | NUMBER | (15) | The unique identifier of the cost breakdown structure element. | |
| CBS_ELEMENT_NAME | VARCHAR2 | (250) | The unique cost code generated for the cost attribute |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_SOURCE
, BATCH_NAME
, EXPENDITURE_ENDING_DATE
, EMPLOYEE_NUMBER
, ORGANIZATION_NAME
, EXPENDITURE_ITEM_DATE
, PROJECT_NUMBER
, TASK_NUMBER
, EXPENDITURE_TYPE
, NON_LABOR_RESOURCE
, NON_LABOR_RESOURCE_ORG_NAME
, EXPENDITURE_COMMENT
, TRANSACTION_STATUS_CODE
, TRANSACTION_REJECTION_CODE
, EXPENDITURE_ID
, ORIG_TRANSACTION_REFERENCE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, INTERFACE_ID
, UNMATCHED_NEGATIVE_TXN_FLAG
, EXPENDITURE_ITEM_ID
, ORG_ID
, DR_CODE_COMBINATION_ID
, CR_CODE_COMBINATION_ID
, CDL_SYSTEM_REFERENCE1
, CDL_SYSTEM_REFERENCE2
, CDL_SYSTEM_REFERENCE3
, GL_DATE
, SYSTEM_LINKAGE
, TXN_INTERFACE_ID
, BEFORE_AFTER_FLAG
, UPDATED_BY
, UPDATE_DATE
, USER_TRANSACTION_SOURCE
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_RATE_DATE
, ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, PROJECT_EXCHANGE_RATE
, ORIG_EXP_TXN_REFERENCE1
, ORIG_EXP_TXN_REFERENCE2
, ORIG_EXP_TXN_REFERENCE3
, ORIG_USER_EXP_TXN_REFERENCE
, OVERRIDE_TO_ORGANIZATION_NAME
, REVERSED_ORIG_TXN_REFERENCE
, VENDOR_NUMBER
, BILLABLE_FLAG
, PERSON_BUSINESS_GROUP_NAME
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, PROJFUNC_COST_EXCHANGE_RATE
, PROJECT_RAW_COST
, PROJECT_BURDENED_COST
, ASSIGNMENT_NAME
, WORK_TYPE_NAME
, CDL_SYSTEM_REFERENCE4
, ACCRUAL_FLAG
, PROJECT_ID
, TASK_ID
, PERSON_ID
, ORGANIZATION_ID
, NON_LABOR_RESOURCE_ORG_ID
, VENDOR_ID
, OVERRIDE_TO_ORGANIZATION_ID
, ASSIGNMENT_ID
, WORK_TYPE_ID
, PERSON_BUSINESS_GROUP_ID
, PO_NUMBER
, PO_HEADER_ID
, PO_LINE_NUM
, PO_LINE_ID
, PERSON_TYPE
, PO_PRICE_TYPE
, UNIT_OF_MEASURE
, WIP_RESOURCE_ID
, INVENTORY_ITEM_ID
, SI_ASSETS_ADDITION_FLAG
, CDL_SYSTEM_REFERENCE5
, FC_DOCUMENT_TYPE
, ADJUSTED_EXPENDITURE_ITEM_ID
, ADJUSTED_TXN_INTERFACE_ID
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, NET_ZERO_ADJUSTMENT_FLAG
, SC_XFER_CODE
, JOB_ID
, JOB_NAME
, LOCATION_ID
, LOCATION_CODE
, PAY_ELEMENT_TYPE_ID
, QUANTITY#1
, RAW_COST#1
, RAW_COST_RATE#1
, BURDENED_COST#1
, BURDENED_COST_RATE#1
, CBS_ELEMENT_ID
, CBS_ELEMENT_NAME
FROM PA.PA_TXN_INTERFACE_AUDIT_ALL;
PA.PA_TXN_INTERFACE_AUDIT_ALL does not reference any database object
PA.PA_TXN_INTERFACE_AUDIT_ALL is referenced by following:
PA
PA_TXN_INTERFACE_AUDIT_ALL#
|
|
|
|