[Home] [Help] [Dependency Information]
Object Name: | OKL_TRX_CONTRACTS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
TRX_NUMBER | VARCHAR2 | (30) | Yes | |
KHR_ID_NEW | NUMBER | |||
KHR_ID_OLD | NUMBER | |||
KHR_ID | NUMBER | |||
PVN_ID | NUMBER | |||
PDT_ID | NUMBER | |||
RBR_CODE | VARCHAR2 | (30) | ||
RPY_CODE | VARCHAR2 | (30) | ||
RVN_CODE | VARCHAR2 | (30) | ||
TRN_CODE | VARCHAR2 | (30) | ||
QTE_ID | NUMBER | |||
AES_ID | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | |||
TRY_ID | NUMBER | Yes | ||
TSU_CODE | VARCHAR2 | (30) | Yes | |
SET_OF_BOOKS_ID | NUMBER | |||
TCN_TYPE | VARCHAR2 | (10) | Yes | |
DESCRIPTION | VARCHAR2 | (1995) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
DATE_ACCRUAL | DATE | |||
DATE_TRANSACTION_OCCURRED | DATE | Yes | ||
ACCRUAL_STATUS_YN | VARCHAR2 | (3) | ||
UPDATE_STATUS_YN | VARCHAR2 | (3) | ||
TAX_DEDUCTIBLE_LOCAL | VARCHAR2 | (3) | ||
TAX_DEDUCTIBLE_CORPORATE | VARCHAR2 | (3) | ||
AMOUNT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (150) | ||
TMT_EVERGREEN_YN | VARCHAR2 | (3) | ||
TMT_CLOSE_BALANCES_YN | VARCHAR2 | (3) | ||
TMT_ACCOUNTING_ENTRIES_YN | VARCHAR2 | (3) | ||
TMT_CANCEL_INSURANCE_YN | VARCHAR2 | (3) | ||
TMT_ASSET_DISPOSITION_YN | VARCHAR2 | (3) | ||
TMT_AMORTIZATION_YN | VARCHAR2 | (3) | ||
TMT_ASSET_RETURN_YN | VARCHAR2 | (3) | ||
TMT_CONTRACT_UPDATED_YN | VARCHAR2 | (3) | ||
TMT_RECYCLE_YN | VARCHAR2 | (3) | ||
TMT_VALIDATED_YN | VARCHAR2 | (3) | ||
TMT_STREAMS_UPDATED_YN | VARCHAR2 | (3) | ||
RJN_CODE | VARCHAR2 | (30) | ||
PARTY_REL_ID1_OLD | NUMBER | (15) | ||
PARTY_REL_ID2_OLD | VARCHAR2 | (15) | ||
PARTY_REL_ID1_NEW | NUMBER | (15) | ||
PARTY_REL_ID2_NEW | VARCHAR2 | (15) | ||
COMPLETE_TRANSFER_YN | VARCHAR2 | (3) | ||
ACCRUAL_ACTIVITY | VARCHAR2 | (30) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
ATTRIBUTE1 | VARCHAR2 | (450) | ||
ATTRIBUTE2 | VARCHAR2 | (450) | ||
ATTRIBUTE3 | VARCHAR2 | (450) | ||
ATTRIBUTE4 | VARCHAR2 | (450) | ||
ATTRIBUTE5 | VARCHAR2 | (450) | ||
ATTRIBUTE6 | VARCHAR2 | (450) | ||
ATTRIBUTE7 | VARCHAR2 | (450) | ||
ATTRIBUTE8 | VARCHAR2 | (450) | ||
ATTRIBUTE9 | VARCHAR2 | (450) | ||
ATTRIBUTE10 | VARCHAR2 | (450) | ||
ATTRIBUTE11 | VARCHAR2 | (450) | ||
ATTRIBUTE12 | VARCHAR2 | (450) | ||
ATTRIBUTE13 | VARCHAR2 | (450) | ||
ATTRIBUTE14 | VARCHAR2 | (450) | ||
ATTRIBUTE15 | VARCHAR2 | (450) | ||
ORG_ID | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CHR_ID | NUMBER | |||
TMT_SPLIT_ASSET_YN | VARCHAR2 | (3) | ||
TMT_GENERIC_FLAG1_YN | VARCHAR2 | (3) | ||
TMT_GENERIC_FLAG2_YN | VARCHAR2 | (3) | ||
TMT_GENERIC_FLAG3_YN | VARCHAR2 | (3) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
SOURCE_TRX_ID | NUMBER | |||
SOURCE_TRX_TYPE | VARCHAR2 | (30) | ||
CANCELED_DATE | DATE | |||
LEGAL_ENTITY_ID | NUMBER | |||
ACCRUAL_REVERSAL_DATE | DATE | |||
PRODUCT_NAME | VARCHAR2 | (150) | ||
BOOK_CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
TAX_OWNER_CODE | VARCHAR2 | (150) | ||
ACCOUNTING_REVERSAL_YN | VARCHAR2 | (3) | ||
TMT_STATUS_CODE | VARCHAR2 | (30) | ||
REPRESENTATION_NAME | VARCHAR2 | (30) | ||
REPRESENTATION_CODE | VARCHAR2 | (20) | ||
UPGRADE_STATUS_FLAG | VARCHAR2 | (1) | ||
TRANSACTION_DATE | DATE | |||
REPRESENTATION_TYPE | VARCHAR2 | (9) | ||
PRIMARY_REP_TRX_ID | NUMBER | |||
TRANSACTION_REVERSAL_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, TRX_NUMBER
, KHR_ID_NEW
, KHR_ID_OLD
, KHR_ID
, PVN_ID
, PDT_ID
, RBR_CODE
, RPY_CODE
, RVN_CODE
, TRN_CODE
, QTE_ID
, AES_ID
, CODE_COMBINATION_ID
, TRY_ID
, TSU_CODE
, SET_OF_BOOKS_ID
, TCN_TYPE
, DESCRIPTION
, OBJECT_VERSION_NUMBER
, DATE_ACCRUAL
, DATE_TRANSACTION_OCCURRED
, ACCRUAL_STATUS_YN
, UPDATE_STATUS_YN
, TAX_DEDUCTIBLE_LOCAL
, TAX_DEDUCTIBLE_CORPORATE
, AMOUNT
, CURRENCY_CODE
, TMT_EVERGREEN_YN
, TMT_CLOSE_BALANCES_YN
, TMT_ACCOUNTING_ENTRIES_YN
, TMT_CANCEL_INSURANCE_YN
, TMT_ASSET_DISPOSITION_YN
, TMT_AMORTIZATION_YN
, TMT_ASSET_RETURN_YN
, TMT_CONTRACT_UPDATED_YN
, TMT_RECYCLE_YN
, TMT_VALIDATED_YN
, TMT_STREAMS_UPDATED_YN
, RJN_CODE
, PARTY_REL_ID1_OLD
, PARTY_REL_ID2_OLD
, PARTY_REL_ID1_NEW
, PARTY_REL_ID2_NEW
, COMPLETE_TRANSFER_YN
, ACCRUAL_ACTIVITY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORG_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CHR_ID
, TMT_SPLIT_ASSET_YN
, TMT_GENERIC_FLAG1_YN
, TMT_GENERIC_FLAG2_YN
, TMT_GENERIC_FLAG3_YN
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, SOURCE_TRX_ID
, SOURCE_TRX_TYPE
, CANCELED_DATE
, LEGAL_ENTITY_ID
, ACCRUAL_REVERSAL_DATE
, PRODUCT_NAME
, BOOK_CLASSIFICATION_CODE
, TAX_OWNER_CODE
, ACCOUNTING_REVERSAL_YN
, TMT_STATUS_CODE
, REPRESENTATION_NAME
, REPRESENTATION_CODE
, UPGRADE_STATUS_FLAG
, TRANSACTION_DATE
, REPRESENTATION_TYPE
, PRIMARY_REP_TRX_ID
, TRANSACTION_REVERSAL_DATE
FROM OKL.OKL_TRX_CONTRACTS_ALL#;
|
|
|