[Home] [Help] [Dependency Information]
Object Name: | XTR_FX_ROLL_PRE_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASE_RATE | NUMBER | Yes | ||
BUY_AMOUNT | NUMBER | Yes | ||
CLIENT_CODE | VARCHAR2 | (7) | ||
COMPANY_CODE | VARCHAR2 | (7) | Yes | |
COMP_SETTLEMENT_ACCT | VARCHAR2 | (20) | ||
CPARTY_CODE | VARCHAR2 | (7) | Yes | |
CURRENCY_BUY | VARCHAR2 | (15) | Yes | |
CURRENCY_SELL | VARCHAR2 | (15) | Yes | |
DEALER_CODE | VARCHAR2 | (10) | ||
DEAL_DATE | DATE | Yes | ||
DEAL_NO | NUMBER | Yes | ||
LIMIT_CODE | VARCHAR2 | (7) | ||
MULTIPLE_TRANS_YN | VARCHAR2 | (3) | Yes | |
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PREV_DEAL_NO | NUMBER | |||
REF_NUMBER | NUMBER | Yes | ||
ROLL_PRE | VARCHAR2 | (3) | ||
ROLL_PRE_ON | DATE | |||
SELL_AMOUNT | NUMBER | Yes | ||
SETTLED_CURRENT | VARCHAR2 | (1) | Yes | |
SETTLEMENT_PARTY | VARCHAR2 | (7) | ||
SETTLEMENT_PARTY_ACCT | VARCHAR2 | (20) | ||
TRANS_RATE | NUMBER | Yes | ||
VALUE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BASE_RATE
, BUY_AMOUNT
, CLIENT_CODE
, COMPANY_CODE
, COMP_SETTLEMENT_ACCT
, CPARTY_CODE
, CURRENCY_BUY
, CURRENCY_SELL
, DEALER_CODE
, DEAL_DATE
, DEAL_NO
, LIMIT_CODE
, MULTIPLE_TRANS_YN
, PORTFOLIO_CODE
, PREV_DEAL_NO
, REF_NUMBER
, ROLL_PRE
, ROLL_PRE_ON
, SELL_AMOUNT
, SETTLED_CURRENT
, SETTLEMENT_PARTY
, SETTLEMENT_PARTY_ACCT
, TRANS_RATE
, VALUE_DATE
FROM XTR.XTR_FX_ROLL_PRE_DETAILS#;
|
|
|