[Home] [Help]
View: XTR_A_PARTY_INFO_V
View Text
SELECT PARTY_CODE
, PARTY_TYPE
, SHORT_NAME
, FULL_NAME
, CREATED_BY
, CREATED_ON
, RISK_PARTY
, DEFAULT_COMPANY
, UPDATED_BY
, UPDATED_ON
, CONTACT_NAME
, PHONE_NUMBER
, FAX_NUMBER
, ADDRESS_1
, ADDRESS_2
, ADDRESS_3
, ADDRESS_4
, ADDRESS_5
, ADDRESS_6
, COUNTRY_CODE
, AUTHORISED
, TAX_NUMBER
, INTERNAL_PTY
, PARTY_CATEGORY
, BROKER
, CLIENT_YN
, CROSS_REF_TO_OTHER_PARTY
, CLIENT_GROUPING
, STATE_CODE
, TITLE_DESCRIPTION
, PARTY_GROUP
, SETTLEMENT_DEFAULT_CATEGORY
, TAX_CATEGORY
, BROKERAGE_CATEGORY
, TAX_EXEMPTION_CODE
, CLIENT_ADVICE
, CLIENT_AGENT1
, CLIENT_AGENT2
, CLIENT_AGENT3
, ACCOUNT_MANAGER
, ADVISOR_YN
, VALUER_YN
, P_ADDRESS_1
, P_ADDRESS_2
, P_ADDRESS_3
, P_ADDRESS_4
, EMAIL_ADDRESS
, DEPOSIT_REF
, COMMENTS
, ACCOUNT_STATUS
, CONFO_GROUP_CODE
, CONFO_ACTION_CODE
, PI_CONSTANT
, PAGER_NUMBER
, BRANCH_SUBSIDIARY_CODE
, BRANCH_SUBSIDIARY_YN
, DEFAULT_ADDRESS_DETAILS
, SWIFT_ID
, FX_MATCH_ID
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, FX_CPARTY
, MM_CPARTY
, LEGAL_ENTITY_ID
, SUSPENSE_CCID
, CONVERSION_TYPE
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
FROM XTR_A_PARTY_INFO
Columns
Name |
PARTY_CODE |
PARTY_TYPE |
SHORT_NAME |
FULL_NAME |
CREATED_BY |
CREATED_ON |
RISK_PARTY |
DEFAULT_COMPANY |
UPDATED_BY |
UPDATED_ON |
CONTACT_NAME |
PHONE_NUMBER |
FAX_NUMBER |
ADDRESS_1 |
ADDRESS_2 |
ADDRESS_3 |
ADDRESS_4 |
ADDRESS_5 |
ADDRESS_6 |
COUNTRY_CODE |
AUTHORISED |
TAX_NUMBER |
INTERNAL_PTY |
PARTY_CATEGORY |
BROKER |
CLIENT_YN |
CROSS_REF_TO_OTHER_PARTY |
CLIENT_GROUPING |
STATE_CODE |
TITLE_DESCRIPTION |
PARTY_GROUP |
SETTLEMENT_DEFAULT_CATEGORY |
TAX_CATEGORY |
BROKERAGE_CATEGORY |
TAX_EXEMPTION_CODE |
CLIENT_ADVICE |
CLIENT_AGENT1 |
CLIENT_AGENT2 |
CLIENT_AGENT3 |
ACCOUNT_MANAGER |
ADVISOR_YN |
VALUER_YN |
P_ADDRESS_1 |
P_ADDRESS_2 |
P_ADDRESS_3 |
P_ADDRESS_4 |
EMAIL_ADDRESS |
DEPOSIT_REF |
COMMENTS |
ACCOUNT_STATUS |
CONFO_GROUP_CODE |
CONFO_ACTION_CODE |
PI_CONSTANT |
PAGER_NUMBER |
BRANCH_SUBSIDIARY_CODE |
BRANCH_SUBSIDIARY_YN |
DEFAULT_ADDRESS_DETAILS |
SWIFT_ID |
FX_MATCH_ID |
AUDIT_INDICATOR |
AUDIT_DATE_STORED |
FX_CPARTY |
MM_CPARTY |
LEGAL_ENTITY_ID |
SUSPENSE_CCID |
CONVERSION_TYPE |
SET_OF_BOOKS_ID |
CHART_OF_ACCOUNTS_ID |