[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | JAI_PA_TAX_TRXS |
|---|---|
| Object Type: | TABLE |
| Owner: | JA |
| FND Design Data: |  JA.JAI_PA_TAX_TRXS
|
| Subobject Name: | |
| Status: | VALID |
This Table is used to store Tax Records interfaced to Projects Costing
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| JAI_PA_TAX_TRXS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 CDL_SYSTEM_REFERENCE4
ORIG_TRANSACTION_REFERENCE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_SOURCE | VARCHAR2 | (30) | Yes | Number of the Source transaction |
| BATCH_NAME | VARCHAR2 | (240) | Yes | Name of the batch |
| EXPENDITURE_ENDING_DATE | DATE | Yes | Ending date of the expenditure | |
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | Name of the organization | |
| EXPENDITURE_ITEM_DATE | DATE | Yes | expenditure item date | |
| PROJECT_NUMBER | VARCHAR2 | (25) | The number of the project | |
| TASK_NUMBER | VARCHAR2 | (25) | task number | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Yes | Type of the expenditure |
| NON_LABOR_RESOURCE | VARCHAR2 | (20) | Non labor resource | |
| NON_LABOR_RESOURCE_ORG_NAME | VARCHAR2 | (240) | Organization name of the non labor resource | |
| QUANTITY | NUMBER | Yes | The quantity | |
| RAW_COST | NUMBER | the raw cost | ||
| EXPENDITURE_COMMENT | VARCHAR2 | (240) | Expenditure comment | |
| TRANSACTION_STATUS_CODE | VARCHAR2 | (2) | Yes | The status code of the transaction |
| TRANSACTION_REJECTION_CODE | VARCHAR2 | (30) | The rejection code of the transaction | |
| EXPENDITURE_ID | NUMBER | (15) | Identifies the expenditure | |
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | (30) | Yes | The reference to the original transaction |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Identifies the attribute category | |
| 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 raw cost rate | ||
| INTERFACE_ID | NUMBER | (15) | The Interface ID | |
| UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | (1) | The flag to check for the unmathced negative transavtions | |
| EXPENDITURE_ITEM_ID | NUMBER | (15) | Identifies the Expenditure item | |
| ORG_ID | NUMBER | (15) | Identifies the operating unit | |
| DR_CODE_COMBINATION_ID | NUMBER | (15) | The code combination id of the debit | |
| CR_CODE_COMBINATION_ID | NUMBER | (15) | The code combination id of the credit | |
| CDL_SYSTEM_REFERENCE1 | VARCHAR2 | (30) | Reference column for CDL system reference1 | |
| CDL_SYSTEM_REFERENCE2 | VARCHAR2 | (30) | Reference column for CDL system reference2 | |
| CDL_SYSTEM_REFERENCE3 | VARCHAR2 | (30) | Reference column for CDL system reference3 | |
| GL_DATE | DATE | The GL date | ||
| BURDENED_COST | NUMBER | The burdened cost | ||
| BURDENED_COST_RATE | NUMBER | The burdened cost rate | ||
| SYSTEM_LINKAGE | VARCHAR2 | (30) | System linkage | |
| TXN_INTERFACE_ID | NUMBER | (15) | Yes | The transaction interface id |
| USER_TRANSACTION_SOURCE | VARCHAR2 | (80) | The transaction source of the user | |
| CREATED_BY | NUMBER | (15) | The standard who column | |
| CREATION_DATE | DATE | The standard who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | The standard who column | |
| LAST_UPDATE_DATE | DATE | The standard who column | ||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | The currency amount of the receipt | ||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | (240) | The currency code of the receipt | |
| RECEIPT_EXCHANGE_RATE | NUMBER | The exchange rate for the receipt | ||
| DENOM_CURRENCY_CODE | VARCHAR2 | (240) | The denom currency code | |
| DENOM_RAW_COST | NUMBER | The denom raw cost | ||
| DENOM_BURDENED_COST | NUMBER | The denom burdened cost | ||
| ACCT_RATE_DATE | DATE | The acct rate date | ||
| ACCT_RATE_TYPE | VARCHAR2 | (30) | The acct rate type | |
| ACCT_EXCHANGE_RATE | NUMBER | The acct exchange ratet | ||
| ACCT_RAW_COST | NUMBER | The acct raw cost | ||
| ACCT_BURDENED_COST | NUMBER | The account burdened cost | ||
| ACCT_EXCHANGE_ROUNDING_LIMIT | NUMBER | The account exchange rounding limit | ||
| PROJECT_CURRENCY_CODE | VARCHAR2 | (240) | The currency code of the project | |
| PROJECT_RATE_DATE | DATE | The rate date of the project | ||
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | The rate type of the project | |
| PROJECT_EXCHANGE_RATE | NUMBER | The exchange rate for the project | ||
| ORIG_EXP_TXN_REFERENCE1 | VARCHAR2 | (240) | The original Exp transaction reference column 1 | |
| ORIG_EXP_TXN_REFERENCE2 | VARCHAR2 | (240) | The original Exp transaction reference column 2 | |
| ORIG_EXP_TXN_REFERENCE3 | VARCHAR2 | (240) | The original Exp transaction reference column 3 | |
| ORIG_USER_EXP_TXN_REFERENCE | VARCHAR2 | (240) | The original user Exp transaction reference | |
| VENDOR_NUMBER | VARCHAR2 | (30) | The vendor number | |
| OVERRIDE_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | The override to the organization name | |
| REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | (30) | The revised original transaction refrence number | |
| BILLABLE_FLAG | VARCHAR2 | (1) | The check flag if the project is billable. The possible values are Y and N | |
| PERSON_BUSINESS_GROUP_NAME | VARCHAR2 | (240) | The person business group name | |
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (240) | The currency code of the project functional cost | |
| PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | The rate type of the project functional cost | |
| PROJFUNC_COST_RATE_DATE | DATE | The rate date of the project functional cost | ||
| PROJFUNC_COST_EXCHANGE_RATE | NUMBER | The exchange rate of the project functional cost | ||
| PROJECT_RAW_COST | NUMBER | The raw cost of the project | ||
| PROJECT_BURDENED_COST | NUMBER | The burdened cost of the project | ||
| ASSIGNMENT_NAME | VARCHAR2 | (80) | The assignment name | |
| WORK_TYPE_NAME | VARCHAR2 | (80) | The work type name | |
| CDL_SYSTEM_REFERENCE4 | VARCHAR2 | (30) | Reference column for CDL system reference4 | |
| ACCRUAL_FLAG | VARCHAR2 | (1) | The flag for the check of accrual. The possible values are Y and N | |
| PROJECT_ID | NUMBER | (15) | Identifier for the project | |
| TASK_ID | NUMBER | (15) | Identifier for the task | |
| PERSON_ID | NUMBER | (15) | Identifier for the person | |
| ORGANIZATION_ID | NUMBER | (15) | Identifier for the organization | |
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | (15) | The org id of the non labor resource | |
| VENDOR_ID | NUMBER | (15) | Identifies the vendor | |
| OVERRIDE_TO_ORGANIZATION_ID | NUMBER | (15) | The override to the organization if | |
| ASSIGNMENT_ID | NUMBER | (15) | Identifies the assignmnet | |
| WORK_TYPE_ID | NUMBER | The work type id | ||
| PERSON_BUSINESS_GROUP_ID | NUMBER | (15) | The person business group id | |
| INVENTORY_ITEM_ID | NUMBER | Identifies the inventory item | ||
| WIP_RESOURCE_ID | NUMBER | The WIP resource id | ||
| UNIT_OF_MEASURE | VARCHAR2 | (30) | The unit of measurement | |
| PO_NUMBER | VARCHAR2 | (20) | The purchase order number | |
| PO_HEADER_ID | NUMBER | Identifies the purchase order | ||
| PO_LINE_NUM | NUMBER | Identifies the line number of the purchase order | ||
| PO_LINE_ID | NUMBER | Identifies the line of the purchase order | ||
| PERSON_TYPE | VARCHAR2 | (30) | person type | |
| PO_PRICE_TYPE | VARCHAR2 | (30) | The price type of the purchase order | |
| ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | (15) | Identifies the adjusted expenditure item | |
| FC_DOCUMENT_TYPE | VARCHAR2 | (3) | FC document type. | |
| DOCUMENT_TYPE | VARCHAR2 | (30) | Specifies the type of document | |
| DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | Specifies the type of document distribution | |
| SI_ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | SI Assets addition flag. Possible values are Y and N | |
| CDL_SYSTEM_REFERENCE5 | NUMBER | (15) | Reference column for CDL system reference5 | |
| SC_XFER_CODE | VARCHAR2 | (1) | SC XFER code | |
| ADJUSTED_TXN_INTERFACE_ID | NUMBER | (15) | The adjusted transaction interface id | |
| NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | (1) | The net zero adjustment flag. The possible values are Y and N | |
| PA_ADDITION_FLAG | VARCHAR2 | (240) | The PA addition flag. The possible values are Y and N | |
| REQUEST_ID | VARCHAR2 | (240) | The request ID |
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
, PA_ADDITION_FLAG
, REQUEST_ID
FROM JA.JAI_PA_TAX_TRXS;
JA.JAI_PA_TAX_TRXS does not reference any database object
JA.JAI_PA_TAX_TRXS is referenced by following:
JA
JAI_PA_TAX_TRXS#
|
|
|
|