[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_TRANSACTION_INTERFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_TRANSACTION_INTERFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
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.
.
.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_TRANSACTION_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 TXN_INTERFACE_ID
|
| PA_TRANSACTION_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_SOURCE
BATCH_NAME
TRANSACTION_STATUS_CODE
|
| PA_TRANSACTION_INTERFACE_N10 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROJECT_NUMBER
|
| PA_TRANSACTION_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BATCH_NAME
EXPENDITURE_ID
|
| PA_TRANSACTION_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
INTERFACE_ID
|
| PA_TRANSACTION_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_SOURCE
ORIG_TRANSACTION_REFERENCE
|
| PA_TRANSACTION_INTERFACE_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
EXPENDITURE_ITEM_ID
|
| PA_TRANSACTION_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CDL_SYSTEM_REFERENCE2
CDL_SYSTEM_REFERENCE5
CDL_SYSTEM_REFERENCE3
CDL_SYSTEM_REFERENCE4
|
| PA_TRANSACTION_INTERFACE_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
ADJUSTED_EXPENDITURE_ITEM_ID
FC_DOCUMENT_TYPE
|
| PA_TRANSACTION_INTERFACE_N8 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
NET_ZERO_ADJUSTMENT_FLAG
|
| PA_TRANSACTION_INTERFACE_N9 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
EXPENDITURE_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 areimported into Oracle Projects 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 since PA derives its value based on the employee's organization assignment 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 | |
| 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 | |
| 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 PA loads 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 |
| 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 | |
| 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 | (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 systems as specified by the GL_ACCOUNTED_FLAG flag on the transaction source. | |
| CR_CODE_COMBINATION_ID | NUMBER | (15) | Identifier of the credit code combination ID for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG flag on the transaction source. | |
| 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 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 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 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 the GL_ACCOUNTED_FLAG flag on the transaction source. This date is used to derive the PA_DATE on CDLs. | ||
| BURDENED_COST | NUMBER | Total cost including burden cost (raw cost + burden cost) | ||
| 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 | |
| TXN_INTERFACE_ID | NUMBER | (15) | Yes | System generated identifier that uniquely identifies a imported transaction |
| USER_TRANSACTION_SOURCE | VARCHAR2 | (80) | The descriptive name of the transaction source | |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| 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 conversion rate date for the transaction | ||
| ACCT_RATE_TYPE | VARCHAR2 | (30) | Functional conversion 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 | |
| VENDOR_NUMBER | VARCHAR2 | (30) | Supplier Number | |
| OVERRIDE_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | Supplier Invoice Distribution's override to organization name | |
| REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | (30) | 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 | |
| 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 assignment 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) | Indicates whether the imported transaction is automatically reversed in the next accounting period. | |
| 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 | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| WIP_RESOURCE_ID | NUMBER | Identifier of the resource for work in progress | ||
| UNIT_OF_MEASURE | VARCHAR2 | (30) | Base unit of measure | |
| 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 | |
| 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. | |
| 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. | |
| 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. | |
| 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 | (15) | 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. | |
| 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 | (15) | 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. | |
| 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 | |
| CBS_ELEMENT_ID | NUMBER | (15) | Unique id corresponding to the cost code. | |
| CBS_ELEMENT_NAME | VARCHAR2 | (250) | Stores the cost code. |
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
, QUANTITY
, RAW_COST
, 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
, RAW_COST_RATE
, 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
, BURDENED_COST
, BURDENED_COST_RATE
, SYSTEM_LINKAGE
, TXN_INTERFACE_ID
, USER_TRANSACTION_SOURCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, 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
, VENDOR_NUMBER
, OVERRIDE_TO_ORGANIZATION_NAME
, REVERSED_ORIG_TXN_REFERENCE
, 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
, INVENTORY_ITEM_ID
, WIP_RESOURCE_ID
, UNIT_OF_MEASURE
, PO_NUMBER
, PO_HEADER_ID
, PO_LINE_NUM
, PO_LINE_ID
, PERSON_TYPE
, PO_PRICE_TYPE
, ADJUSTED_EXPENDITURE_ITEM_ID
, FC_DOCUMENT_TYPE
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, SI_ASSETS_ADDITION_FLAG
, CDL_SYSTEM_REFERENCE5
, SC_XFER_CODE
, ADJUSTED_TXN_INTERFACE_ID
, NET_ZERO_ADJUSTMENT_FLAG
, JOB_ID
, JOB_NAME
, LOCATION_ID
, LOCATION_CODE
, PAY_ELEMENT_TYPE_ID
, CBS_ELEMENT_ID
, CBS_ELEMENT_NAME
FROM PA.PA_TRANSACTION_INTERFACE_ALL;
PA.PA_TRANSACTION_INTERFACE_ALL does not reference any database object
PA.PA_TRANSACTION_INTERFACE_ALL is referenced by following:
PA
PA_TRANSACTION_INTERFACE_ALL#
|
|
|
|