[Home] [Help] [Dependency Information]
Object Name: | PA_TXN_INTERFACE_AUDIT_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_TXN_INTERFACE_AUDIT_AR |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_BATCH_ID | NUMBER | Yes | Purge batch Id | |
PURGE_RELEASE | VARCHAR2 | (10) | Yes | Purge Release |
PURGE_PROJECT_ID | NUMBER | Yes | Purge Project Id | |
ATTRIBUTE10 | VARCHAR2 | (150) | ||
RAW_COST_RATE | NUMBER | |||
INTERFACE_ID | NUMBER | |||
UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | (1) | ||
EXPENDITURE_ITEM_ID | NUMBER | |||
ORG_ID | NUMBER | |||
DR_CODE_COMBINATION_ID | NUMBER | |||
CR_CODE_COMBINATION_ID | NUMBER | |||
CDL_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | ||
CDL_SYSTEM_REFERENCE2 | VARCHAR2 | (30) | ||
CDL_SYSTEM_REFERENCE3 | VARCHAR2 | (30) | ||
GL_DATE | DATE | |||
BURDENED_COST | NUMBER | |||
BURDENED_COST_RATE | NUMBER | |||
SYSTEM_LINKAGE | VARCHAR2 | (30) | ||
TXN_INTERFACE_ID | NUMBER | Yes | ||
BEFORE_AFTER_FLAG | VARCHAR2 | (1) | Yes | |
UPDATED_BY | NUMBER | Yes | ||
UPDATE_DATE | DATE | Yes | ||
USER_TRANSACTION_SOURCE | VARCHAR2 | (80) | ||
TRANSACTION_SOURCE | VARCHAR2 | (30) | Yes | |
BATCH_NAME | VARCHAR2 | (10) | Yes | |
EXPENDITURE_ENDING_DATE | DATE | Yes | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
EXPENDITURE_ITEM_DATE | DATE | Yes | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
TASK_NUMBER | VARCHAR2 | (25) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | |
NON_LABOR_RESOURCE | VARCHAR2 | (20) | ||
NON_LABOR_RESOURCE_ORG_NAME | VARCHAR2 | (240) | ||
QUANTITY | NUMBER | Yes | ||
RAW_COST | NUMBER | |||
EXPENDITURE_COMMENT | VARCHAR2 | (240) | ||
TRANSACTION_STATUS_CODE | VARCHAR2 | (2) | Yes | |
TRANSACTION_REJECTION_CODE | VARCHAR2 | (30) | ||
EXPENDITURE_ID | NUMBER | |||
ORIG_TRANSACTION_REFERENCE | VARCHAR2 | (50) | Yes | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
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_TYPE | VARCHAR2 | (30) | Functional rate type for the transaction. | |
ACCT_RATE_DATE | DATE | Functional rate date 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_TYPE | VARCHAR2 | (30) | Project rate type for the transaction. | |
PROJECT_RATE_DATE | DATE | Project rate date 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). | |
ORIG_EXP_TXN_REFERENCE2 | VARCHAR2 | (60) | Additional column provided to group transactions into expenditures. | |
ORIG_EXP_TXN_REFERENCE3 | VARCHAR2 | (60) | Additional column provided to group transactions into expenditures. | |
ORIG_USER_EXP_TXN_REFERENCE | VARCHAR2 | (60) | Expenditure Identifier in external system (user reference). | |
OVERRIDE_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | 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 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) | 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 | ||
CDL_SYSTEM_REFERENCE5 | NUMBER | (15) | ||
FC_DOCUMENT_TYPE | VARCHAR2 | (3) | ||
ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
ADJUSTED_TXN_INTERFACE_ID | NUMBER | (15) | ||
DOCUMENT_TYPE | VARCHAR2 | (30) | ||
DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
SI_ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | ||
NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
SC_XFER_CODE | VARCHAR2 | (1) | ||
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 PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, 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
, BEFORE_AFTER_FLAG
, UPDATED_BY
, UPDATE_DATE
, USER_TRANSACTION_SOURCE
, 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
, RECEIPT_CURRENCY_AMOUNT
, RECEIPT_CURRENCY_CODE
, RECEIPT_EXCHANGE_RATE
, DENOM_CURRENCY_CODE
, DENOM_RAW_COST
, DENOM_BURDENED_COST
, ACCT_RATE_TYPE
, ACCT_RATE_DATE
, ACCT_EXCHANGE_RATE
, ACCT_RAW_COST
, ACCT_BURDENED_COST
, ACCT_EXCHANGE_ROUNDING_LIMIT
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE
, 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
, CDL_SYSTEM_REFERENCE5
, FC_DOCUMENT_TYPE
, ADJUSTED_EXPENDITURE_ITEM_ID
, ADJUSTED_TXN_INTERFACE_ID
, DOCUMENT_TYPE
, DOCUMENT_DISTRIBUTION_TYPE
, SI_ASSETS_ADDITION_FLAG
, NET_ZERO_ADJUSTMENT_FLAG
, SC_XFER_CODE
, JOB_ID
, JOB_NAME
, LOCATION_ID
, LOCATION_CODE
, PAY_ELEMENT_TYPE_ID
, CBS_ELEMENT_ID
, CBS_ELEMENT_NAME
FROM PA.PA_TXN_INTERFACE_AUDIT_AR;
PA.PA_TXN_INTERFACE_AUDIT_AR does not reference any database object
PA.PA_TXN_INTERFACE_AUDIT_AR is referenced by following:
|
|
|