DBA Data[Home] [Help] [Dependency Information]


TABLE: XTR.XTR_PARTY_INFO

Object Details
Object Name: XTR_PARTY_INFO
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_PARTY_INFO
Subobject Name:
Status: VALID


XTR_PARTY_INFO contains general information about all companies and counterparties in Treasury. Each row corresponds to a party and contains the party?s contact information such as address, phone number, the tax information. The PARTY_TYPE column indicates whether the party is a company or a counterparty.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_PARTY_INFO_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_CODE
XTR_PARTY_INFO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_TYPE
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_MANAGER VARCHAR2 (10)
Cparty account manager
ACCOUNT_STATUS VARCHAR2 (14)
Not currently used
ADDRESS_1 VARCHAR2 (50)
(Cparty) contact name or (company) address line 1
ADDRESS_2 VARCHAR2 (50)
(Cparty) mailing address line 1 or (company) address line 2
ADDRESS_3 VARCHAR2 (50)
(Cparty) mailing address line 2 or (company) address line 3
ADDRESS_4 VARCHAR2 (50)
(Cparty) mailing address line 3 or (company) address line 4
ADDRESS_5 VARCHAR2 (50)
(Cparty) mailing address line 4 or (company) address line 5
ADDRESS_6 VARCHAR2 (50)
(Cparty) mailing address line 5 or (company) address line 6
ADVISOR_YN VARCHAR2 (1)
Flag to indicate if the counterparty acts as a legal or accounting advisor (Y), or not (N)
AUDIT_INDICATOR VARCHAR2 (1)
Not currently used
AUTHORISED VARCHAR2 (1)
Flag to indicate if the party is authorized (Y), or not (N). Companies are always authorized.
BRANCH_SUBSIDIARY_CODE VARCHAR2 (7)
Not currently used
BRANCH_SUBSIDIARY_YN VARCHAR2 (1)
Not currently used
BROKER VARCHAR2 (1)
Not currently used
BROKERAGE_CATEGORY VARCHAR2 (7)
Counterparty brokerage category
CLIENT_ADVICE VARCHAR2 (1)
Flag to indicate if confirmation advice letter is required for the party's confirmation actions (Y), or not (N)
CLIENT_AGENT1 VARCHAR2 (20)
Party that provides legal service for the counterparty
CLIENT_AGENT2 VARCHAR2 (20)
Party that provides accounting service for the counterparty
CLIENT_AGENT3 VARCHAR2 (20)
Party that provides an 'Other' service for the counterparty
CLIENT_GROUPING VARCHAR2 (7)
Client group code
CLIENT_YN VARCHAR2 (1)
Flag to indicate if the counterparty is a client (Y), or not (N)
COMMENTS VARCHAR2 (255)
Comments for the counterparty
CONFO_ACTION_CODE VARCHAR2 (20)
Not currently used
CONFO_GROUP_CODE VARCHAR2 (20)
Confirmation group code
CONTACT_NAME VARCHAR2 (50)
Name of the contact party for a deal
COUNTRY_CODE VARCHAR2 (2)
Country code
CREATED_BY VARCHAR2 (30) Yes User who created this record
CREATED_ON DATE
Yes Date this record was created
CROSS_REF_TO_OTHER_PARTY VARCHAR2 (7)
Party cross reference
DEFAULT_ADDRESS_DETAILS VARCHAR2 (1)
Flag to indicate if a set of address details should be set as default (Y), or not (N)
DEFAULT_COMPANY VARCHAR2 (1)
Flag to indicate if a company should be set as default (Y), or not (N)
DEPOSIT_REF VARCHAR2 (10)
Reference to a deposit made
EMAIL_ADDRESS VARCHAR2 (40)
Email address of a party
FAX_NUMBER VARCHAR2 (15)
Fax number of a party
FULL_NAME VARCHAR2 (50) Yes Full name of a party
FX_MATCH_ID VARCHAR2 (11)
Identifier used in Citibank's foreign exchange deal confirmation and matching services
INTERNAL_PTY VARCHAR2 (1)
Flag to indicate if the party is an internal party (Y), or not (N)
PAGER_NUMBER NUMBER

Pager number of a party
PARTY_CATEGORY VARCHAR2 (2)
Not currently used
PARTY_CODE VARCHAR2 (7) Yes Party code
PARTY_GROUP VARCHAR2 (7)
Deal confirmation group to which the party belongs
PARTY_TYPE VARCHAR2 (2) Yes Indicates if the party is a company or a counterparty
PHONE_NUMBER VARCHAR2 (15)
Phone number of party
PI_CONSTANT VARCHAR2 (1)
Not currently used
P_ADDRESS_1 VARCHAR2 (50)
Physical address line 1
P_ADDRESS_2 VARCHAR2 (50)
Physical address line 2
P_ADDRESS_3 VARCHAR2 (50)
Physical address line 3
P_ADDRESS_4 VARCHAR2 (50)
Physical address line 4
RISK_PARTY VARCHAR2 (1)
Flag to determine if the party is a risk party (Y), or not (N)
SETTLEMENT_DEFAULT_CATEGORY VARCHAR2 (7)
Counterparty settlement category
SHORT_NAME VARCHAR2 (20) Yes Counterparty short name
STATE_CODE VARCHAR2 (3)
Counterparty state code
SWIFT_ID VARCHAR2 (11)
Bank transit identifier
TAX_CATEGORY VARCHAR2 (7)
Tax category
TAX_EXEMPTION_CODE VARCHAR2 (15)
Counterparty tax exemption code
TAX_NUMBER VARCHAR2 (20)
Number under which the counterparty files tax
TITLE_DESCRIPTION VARCHAR2 (50)
Counterparty contact title
UPDATED_BY VARCHAR2 (30)
User who last updated this record
UPDATED_ON DATE

Date this record was last updated
VALUER_YN VARCHAR2 (1)
Flag to determine if the party is a valuer (Y), or not (N)
FX_CPARTY VARCHAR2 (1)
Flag to indicate if that party is involved in foreign exchange (Y), or not (N)
MM_CPARTY VARCHAR2 (1)
Flag to indicate if a counterparty is involved in the money market (Y), or not (N)
LEGAL_ENTITY_ID NUMBER (15)
Legal entity identifier
SUSPENSE_CCID NUMBER (15)
Suspense account identifier
CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type
SET_OF_BOOKS_ID NUMBER (15)
Set of books identifier
CHART_OF_ACCOUNTS_ID NUMBER (15)
Key flexfield structure defining column
EM_CPARTY VARCHAR2 (1)
Not currently used
CE_BANK_BRANCH_ID NUMBER (15)
Bank Branch Id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCOUNT_MANAGER
,      ACCOUNT_STATUS
,      ADDRESS_1
,      ADDRESS_2
,      ADDRESS_3
,      ADDRESS_4
,      ADDRESS_5
,      ADDRESS_6
,      ADVISOR_YN
,      AUDIT_INDICATOR
,      AUTHORISED
,      BRANCH_SUBSIDIARY_CODE
,      BRANCH_SUBSIDIARY_YN
,      BROKER
,      BROKERAGE_CATEGORY
,      CLIENT_ADVICE
,      CLIENT_AGENT1
,      CLIENT_AGENT2
,      CLIENT_AGENT3
,      CLIENT_GROUPING
,      CLIENT_YN
,      COMMENTS
,      CONFO_ACTION_CODE
,      CONFO_GROUP_CODE
,      CONTACT_NAME
,      COUNTRY_CODE
,      CREATED_BY
,      CREATED_ON
,      CROSS_REF_TO_OTHER_PARTY
,      DEFAULT_ADDRESS_DETAILS
,      DEFAULT_COMPANY
,      DEPOSIT_REF
,      EMAIL_ADDRESS
,      FAX_NUMBER
,      FULL_NAME
,      FX_MATCH_ID
,      INTERNAL_PTY
,      PAGER_NUMBER
,      PARTY_CATEGORY
,      PARTY_CODE
,      PARTY_GROUP
,      PARTY_TYPE
,      PHONE_NUMBER
,      PI_CONSTANT
,      P_ADDRESS_1
,      P_ADDRESS_2
,      P_ADDRESS_3
,      P_ADDRESS_4
,      RISK_PARTY
,      SETTLEMENT_DEFAULT_CATEGORY
,      SHORT_NAME
,      STATE_CODE
,      SWIFT_ID
,      TAX_CATEGORY
,      TAX_EXEMPTION_CODE
,      TAX_NUMBER
,      TITLE_DESCRIPTION
,      UPDATED_BY
,      UPDATED_ON
,      VALUER_YN
,      FX_CPARTY
,      MM_CPARTY
,      LEGAL_ENTITY_ID
,      SUSPENSE_CCID
,      CONVERSION_TYPE
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      EM_CPARTY
,      CE_BANK_BRANCH_ID
FROM XTR.XTR_PARTY_INFO;

Dependencies

[top of page]

XTR.XTR_PARTY_INFO does not reference any database object

XTR.XTR_PARTY_INFO is referenced by following:

SchemaXTR
ViewXTR_PARTY_INFO#