[Home] [Help] [Dependency Information]
Object Name: | JAI_PA_TAX_TRXS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_SOURCE | VARCHAR2 | (30) | Yes | |
BATCH_NAME | VARCHAR2 | (240) | 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 | (15) | ||
ORIG_TRANSACTION_REFERENCE | VARCHAR2 | (30) | 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) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
RAW_COST_RATE | NUMBER | |||
INTERFACE_ID | NUMBER | (15) | ||
UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | (1) | ||
EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
DR_CODE_COMBINATION_ID | NUMBER | (15) | ||
CR_CODE_COMBINATION_ID | NUMBER | (15) | ||
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 | (15) | Yes | |
USER_TRANSACTION_SOURCE | VARCHAR2 | (80) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
RECEIPT_CURRENCY_AMOUNT | NUMBER | |||
RECEIPT_CURRENCY_CODE | VARCHAR2 | (240) | ||
RECEIPT_EXCHANGE_RATE | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (240) | ||
DENOM_RAW_COST | NUMBER | |||
DENOM_BURDENED_COST | NUMBER | |||
ACCT_RATE_DATE | DATE | |||
ACCT_RATE_TYPE | VARCHAR2 | (30) | ||
ACCT_EXCHANGE_RATE | NUMBER | |||
ACCT_RAW_COST | NUMBER | |||
ACCT_BURDENED_COST | NUMBER | |||
ACCT_EXCHANGE_ROUNDING_LIMIT | NUMBER | |||
PROJECT_CURRENCY_CODE | VARCHAR2 | (240) | ||
PROJECT_RATE_DATE | DATE | |||
PROJECT_RATE_TYPE | VARCHAR2 | (30) | ||
PROJECT_EXCHANGE_RATE | NUMBER | |||
ORIG_EXP_TXN_REFERENCE1 | VARCHAR2 | (240) | ||
ORIG_EXP_TXN_REFERENCE2 | VARCHAR2 | (240) | ||
ORIG_EXP_TXN_REFERENCE3 | VARCHAR2 | (240) | ||
ORIG_USER_EXP_TXN_REFERENCE | VARCHAR2 | (240) | ||
VENDOR_NUMBER | VARCHAR2 | (30) | ||
OVERRIDE_TO_ORGANIZATION_NAME | VARCHAR2 | (240) | ||
REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | (30) | ||
BILLABLE_FLAG | VARCHAR2 | (1) | ||
PERSON_BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (240) | ||
PROJFUNC_COST_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_COST_RATE_DATE | DATE | |||
PROJFUNC_COST_EXCHANGE_RATE | NUMBER | |||
PROJECT_RAW_COST | NUMBER | |||
PROJECT_BURDENED_COST | NUMBER | |||
ASSIGNMENT_NAME | VARCHAR2 | (80) | ||
WORK_TYPE_NAME | VARCHAR2 | (80) | ||
CDL_SYSTEM_REFERENCE4 | VARCHAR2 | (30) | ||
ACCRUAL_FLAG | VARCHAR2 | (1) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
NON_LABOR_RESOURCE_ORG_ID | NUMBER | (15) | ||
VENDOR_ID | NUMBER | (15) | ||
OVERRIDE_TO_ORGANIZATION_ID | NUMBER | (15) | ||
ASSIGNMENT_ID | NUMBER | (15) | ||
WORK_TYPE_ID | NUMBER | |||
PERSON_BUSINESS_GROUP_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | |||
WIP_RESOURCE_ID | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (30) | ||
PO_NUMBER | VARCHAR2 | (20) | ||
PO_HEADER_ID | NUMBER | |||
PO_LINE_NUM | NUMBER | |||
PO_LINE_ID | NUMBER | |||
PERSON_TYPE | VARCHAR2 | (30) | ||
PO_PRICE_TYPE | VARCHAR2 | (30) | ||
ADJUSTED_EXPENDITURE_ITEM_ID | NUMBER | (15) | ||
FC_DOCUMENT_TYPE | VARCHAR2 | (3) | ||
DOCUMENT_TYPE | VARCHAR2 | (30) | ||
DOCUMENT_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
SI_ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | ||
CDL_SYSTEM_REFERENCE5 | NUMBER | (15) | ||
SC_XFER_CODE | VARCHAR2 | (1) | ||
ADJUSTED_TXN_INTERFACE_ID | NUMBER | (15) | ||
NET_ZERO_ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
PA_ADDITION_FLAG | VARCHAR2 | (240) | ||
REQUEST_ID | VARCHAR2 | (240) |
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#;
|
|
|