[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_PARTY_INFO |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_PARTY_INFO_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PARTY_CODE
|
| XTR_PARTY_INFO_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARTY_TYPE
|
| 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 |
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;
XTR.XTR_PARTY_INFO does not reference any database object
XTR.XTR_PARTY_INFO is referenced by following:
XTR
XTR_PARTY_INFO#
|
|
|
|