[Home] [Help]
View: XTR_A_DEAL_ORDERS_V
View Text
SELECT UNIQUE_REF_NUM
, DEAL_TYPE
, ORDER_TYPE
, COMPANY_CODE
, CPARTY_CODE
, STATUS_CODE
, PLACED_ON
, VALID_UNTIL
, CREATED_BY
, CREATED_ON
, DETAILS_OF_ORDER
, CONFIRMED_BY_DEALER
, DEAL_SUBTYPE
, PRODUCT_TYPE
, DEALER_COMPANY
, DEALER_CPARTY
, UPDATED_BY
, UPDATED_ON
, ORDER_RATE
, ORDER_CCY_A
, CCY_A_AMOUNT
, ORDER_CCY_B
, CCY_B_AMOUNT
, ORDER_DELIVERY_DATE
, SOURCE
, RIC_CODE
, ADVICE_GROUP
, ORDER_GROUP
, GROUP_ACTION
, ABOVE_OR_BELOW_LEVEL
, MARKET_RATE_WHEN_ENTERED
, CROSS_REF
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
FROM XTR_A_DEAL_ORDERS
Columns
Name |
UNIQUE_REF_NUM |
DEAL_TYPE |
ORDER_TYPE |
COMPANY_CODE |
CPARTY_CODE |
STATUS_CODE |
PLACED_ON |
VALID_UNTIL |
CREATED_BY |
CREATED_ON |
DETAILS_OF_ORDER |
CONFIRMED_BY_DEALER |
DEAL_SUBTYPE |
PRODUCT_TYPE |
DEALER_COMPANY |
DEALER_CPARTY |
UPDATED_BY |
UPDATED_ON |
ORDER_RATE |
ORDER_CCY_A |
CCY_A_AMOUNT |
ORDER_CCY_B |
CCY_B_AMOUNT |
ORDER_DELIVERY_DATE |
SOURCE |
RIC_CODE |
ADVICE_GROUP |
ORDER_GROUP |
GROUP_ACTION |
ABOVE_OR_BELOW_LEVEL |
MARKET_RATE_WHEN_ENTERED |
CROSS_REF |
AUDIT_INDICATOR |
AUDIT_DATE_STORED |