[Home] [Help] [Dependency Information]
Object Name: | XTR_DEAL_DATE_AMOUNTS# |
---|---|
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_NO | VARCHAR2 | (20) | ||
ACCRUAL_FROM | DATE | |||
ACCRUAL_TO | DATE | |||
ACTION_CODE | VARCHAR2 | (7) | ||
ACTION_COMPLETED | VARCHAR2 | (1) | ||
ACTUAL_SETTLEMENT_DATE | DATE | |||
AMOUNT | NUMBER | Yes | ||
AMOUNT_DATE | DATE | |||
AMOUNT_TYPE | VARCHAR2 | (7) | Yes | |
ARCHIVE_BY | VARCHAR2 | (30) | ||
ARCHIVE_DATE | DATE | |||
ATTACHMENT_EXISTS | VARCHAR2 | (1) | ||
AUDIT_INDICATOR | VARCHAR2 | (1) | ||
AUTHORISED | VARCHAR2 | (1) | ||
BALANCE_SHEET_EXPOSURE | VARCHAR2 | (1) | ||
BENEFICIARY_ACCOUNT_NO | VARCHAR2 | (20) | ||
BENEFICIARY_PARTY | VARCHAR2 | (7) | ||
CASHFLOW_AMOUNT | NUMBER | |||
CHQ_REQD | VARCHAR2 | (1) | ||
CLIENT_BROKER_CLRACCT | VARCHAR2 | (1) | ||
CLIENT_CODE | VARCHAR2 | (7) | ||
COMMENCE_DATE | DATE | |||
COMMENTS | VARCHAR2 | (255) | ||
COMPANY_CODE | VARCHAR2 | (7) | ||
CONTRACT_CODE | VARCHAR2 | (7) | ||
CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | ||
CPARTY_CODE | VARCHAR2 | (7) | ||
CURRENCY | VARCHAR2 | (15) | Yes | |
CURRENCY_COMBINATION | VARCHAR2 | (31) | ||
DATE_TYPE | VARCHAR2 | (7) | Yes | |
DEALER_CODE | VARCHAR2 | (10) | ||
DEAL_NUMBER | NUMBER | Yes | ||
DEAL_ORDERS | VARCHAR2 | (255) | ||
DEAL_SUBTYPE | VARCHAR2 | (7) | ||
DEAL_TYPE | VARCHAR2 | (7) | Yes | |
DIARY_CREATED_BY | VARCHAR2 | (30) | ||
DIARY_NOTE | VARCHAR2 | (255) | ||
DIRECT_DEBIT | VARCHAR2 | (1) | ||
DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | ||
DUAL_AUTHORISATION_ON | DATE | |||
EXPOSURE_REF_DATE | DATE | |||
EXP_SETTLE_REQD | VARCHAR2 | (1) | ||
EXTERNAL_COMMENTS | VARCHAR2 | (255) | ||
FIRST_ACCRUAL | DATE | |||
FRA_DESCRIPTION | VARCHAR2 | (20) | ||
GENERAL_OR_PRIVATE_ACCESS | VARCHAR2 | (7) | ||
CODE_COMBINATION_ID | NUMBER | (15) | ||
GOOD_VALUE_CLAIM | VARCHAR2 | (1) | ||
HCE_AMOUNT | NUMBER | |||
JOURNAL_CREATED | VARCHAR2 | (1) | ||
LIMIT_CODE | VARCHAR2 | (7) | ||
LIMIT_PARTY | VARCHAR2 | (7) | ||
MULTIPLE_REFERENCE_NUMBER | NUMBER | |||
MULTIPLE_SETTLEMENTS | VARCHAR2 | (1) | ||
NETOFF_GROUP_FLAG | VARCHAR2 | (1) | ||
NETOFF_NUMBER | NUMBER | |||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PRINTED_MATURITY_YN | VARCHAR2 | (1) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | ||
QUICK_INPUT | VARCHAR2 | (1) | ||
RECONCILED_DAYS_ADJUST | NUMBER | |||
RECONCILED_PASS_CODE | VARCHAR2 | (3) | ||
RECONCILED_REFERENCE | NUMBER | |||
SERIAL_REFERENCE | VARCHAR2 | (12) | ||
SETTLE | VARCHAR2 | (1) | ||
SETTLEMENT_ACTIONED | VARCHAR2 | (1) | ||
SETTLEMENT_ACTIONED_FILE | VARCHAR2 | (255) | ||
SETTLEMENT_AUTHORISED_BY | VARCHAR2 | (30) | ||
SETTLEMENT_NUMBER | NUMBER | |||
SETTLEMENT_PARTY | VARCHAR2 | (7) | ||
STATUS_CODE | VARCHAR2 | (10) | ||
TRANSACTION_DATE | DATE | Yes | ||
TRANSACTION_NUMBER | NUMBER | |||
TRANSACTION_RATE | NUMBER | |||
TRANS_MTS | VARCHAR2 | (1) | ||
UPDATED_BY | VARCHAR2 | (30) | ||
UPDATED_ON | DATE | |||
ORIGINAL_SETTLEMENT_CURRENCY | VARCHAR2 | (15) | ||
ORIGINAL_SETTLEMENT_AMOUNT | NUMBER | |||
COMPANY_HCE_AMOUNT | NUMBER | |||
CREATED_BY | VARCHAR2 | (30) | ||
CREATED_ON | DATE | |||
BATCH_ID | NUMBER | (15) | ||
DEAL_DATE_AMOUNT_ID | NUMBER | Yes | ||
COMPANY_ACCT_USE_ID | NUMBER | (15) | ||
CPARTY_ACCT_USE_ID | NUMBER | (15) | ||
BENEFECIARY_ACCT_USE_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NO
, ACCRUAL_FROM
, ACCRUAL_TO
, ACTION_CODE
, ACTION_COMPLETED
, ACTUAL_SETTLEMENT_DATE
, AMOUNT
, AMOUNT_DATE
, AMOUNT_TYPE
, ARCHIVE_BY
, ARCHIVE_DATE
, ATTACHMENT_EXISTS
, AUDIT_INDICATOR
, AUTHORISED
, BALANCE_SHEET_EXPOSURE
, BENEFICIARY_ACCOUNT_NO
, BENEFICIARY_PARTY
, CASHFLOW_AMOUNT
, CHQ_REQD
, CLIENT_BROKER_CLRACCT
, CLIENT_CODE
, COMMENCE_DATE
, COMMENTS
, COMPANY_CODE
, CONTRACT_CODE
, CPARTY_ACCOUNT_NO
, CPARTY_CODE
, CURRENCY
, CURRENCY_COMBINATION
, DATE_TYPE
, DEALER_CODE
, DEAL_NUMBER
, DEAL_ORDERS
, DEAL_SUBTYPE
, DEAL_TYPE
, DIARY_CREATED_BY
, DIARY_NOTE
, DIRECT_DEBIT
, DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON
, EXPOSURE_REF_DATE
, EXP_SETTLE_REQD
, EXTERNAL_COMMENTS
, FIRST_ACCRUAL
, FRA_DESCRIPTION
, GENERAL_OR_PRIVATE_ACCESS
, CODE_COMBINATION_ID
, GOOD_VALUE_CLAIM
, HCE_AMOUNT
, JOURNAL_CREATED
, LIMIT_CODE
, LIMIT_PARTY
, MULTIPLE_REFERENCE_NUMBER
, MULTIPLE_SETTLEMENTS
, NETOFF_GROUP_FLAG
, NETOFF_NUMBER
, PORTFOLIO_CODE
, PRINTED_MATURITY_YN
, PRODUCT_TYPE
, QUICK_INPUT
, RECONCILED_DAYS_ADJUST
, RECONCILED_PASS_CODE
, RECONCILED_REFERENCE
, SERIAL_REFERENCE
, SETTLE
, SETTLEMENT_ACTIONED
, SETTLEMENT_ACTIONED_FILE
, SETTLEMENT_AUTHORISED_BY
, SETTLEMENT_NUMBER
, SETTLEMENT_PARTY
, STATUS_CODE
, TRANSACTION_DATE
, TRANSACTION_NUMBER
, TRANSACTION_RATE
, TRANS_MTS
, UPDATED_BY
, UPDATED_ON
, ORIGINAL_SETTLEMENT_CURRENCY
, ORIGINAL_SETTLEMENT_AMOUNT
, COMPANY_HCE_AMOUNT
, CREATED_BY
, CREATED_ON
, BATCH_ID
, DEAL_DATE_AMOUNT_ID
, COMPANY_ACCT_USE_ID
, CPARTY_ACCT_USE_ID
, BENEFECIARY_ACCT_USE_ID
FROM XTR.XTR_DEAL_DATE_AMOUNTS#;
|
|
|