[Home] [Help] [Dependency Information]
Object Name: | XTR_A_PARTY_INFO |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_A_PARTY_INFO |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_A_PARTY_INFO_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPDATED_ON |
XTR_A_PARTY_INFO_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_MANAGER | VARCHAR2 | (20) | ||
ACCOUNT_STATUS | VARCHAR2 | (14) | ||
ADDRESS_1 | VARCHAR2 | (50) | Name of addressee. | |
ADDRESS_2 | VARCHAR2 | (50) | Postal address line 2. | |
ADDRESS_3 | VARCHAR2 | (50) | Postal address line 3. | |
ADDRESS_4 | VARCHAR2 | (50) | Postal address line 4. | |
ADDRESS_5 | VARCHAR2 | (50) | Postal address line 5. | |
ADDRESS_6 | VARCHAR2 | (50) | Postal address line 6. | |
ADVISOR_YN | VARCHAR2 | (1) | Indicates if the party is an advisor. Valid values are: Y (is an advisor) or N (not an advisor). | |
AUDIT_DATE_STORED | DATE | Date on which this record is audited. | ||
AUDIT_INDICATOR | VARCHAR2 | (1) | ||
AUTHORISED | VARCHAR2 | (1) | Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised). | |
BRANCH_SUBSIDIARY_CODE | VARCHAR2 | (7) | ||
BRANCH_SUBSIDIARY_YN | VARCHAR2 | (1) | ||
BROKER | VARCHAR2 | (1) | ||
BROKERAGE_CATEGORY | VARCHAR2 | (7) | Brokerage category identifier. Foreign key to XTR_BROKERAGE_CATEGORIES. | |
CLIENT_ADVICE | VARCHAR2 | (1) | Indicates if confirmation advice letter is required for the party's confirmation actions. Valid values are: Y (requried) or N (not requried). | |
CLIENT_AGENT1 | VARCHAR2 | (20) | Name of the party's solicitor. | |
CLIENT_AGENT2 | VARCHAR2 | (20) | Name of the party's accountant. | |
CLIENT_AGENT3 | VARCHAR2 | (20) | Name of any other agent of the party. | |
CLIENT_GROUPING | VARCHAR2 | (7) | Client group identifier. Foreign key to XTR_PARTY_GROUPS. | |
CLIENT_YN | VARCHAR2 | (1) | Indicates if the party is a client. Valid values are: Y (is a client) or N (not a client). | |
COMMENTS | VARCHAR2 | (255) | Additional note. | |
CONFO_ACTION_CODE | VARCHAR2 | (20) | ||
CONFO_GROUP_CODE | VARCHAR2 | (20) | Confirmation group identifer. Composite key to XTR_CONFIRMATION_ACTIONS. | |
CONTACT_NAME | VARCHAR2 | (50) | ||
COUNTRY_CODE | VARCHAR2 | (2) | Country identifier. Foreign key to XTR_COUNTRY_CODES. | |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record. |
CREATED_ON | DATE | Yes | Date on which this record is created. | |
CROSS_REF_TO_OTHER_PARTY | VARCHAR2 | (7) | ||
DEFAULT_ADDRESS_DETAILS | VARCHAR2 | (1) | ||
DEFAULT_COMPANY | VARCHAR2 | (1) | ||
DEPOSIT_REF | VARCHAR2 | (10) | ||
EMAIL_ADDRESS | VARCHAR2 | (40) | Party's email address. | |
FAX_NUMBER | VARCHAR2 | (15) | Party's fax number. | |
FULL_NAME | VARCHAR2 | (50) | Yes | Full name of the party. |
FX_MATCH_ID | VARCHAR2 | (11) | ||
INTERNAL_PTY | VARCHAR2 | (1) | ||
PAGER_NUMBER | NUMBER | |||
PARTY_CATEGORY | VARCHAR2 | (2) | ||
PARTY_CODE | VARCHAR2 | (7) | Yes | |
PARTY_GROUP | VARCHAR2 | (7) | ||
PARTY_TYPE | VARCHAR2 | (2) | Yes | |
PHONE_NUMBER | VARCHAR2 | (15) | Party's contact phone number. | |
PI_CONSTANT | VARCHAR2 | (1) | ||
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) | Indicates if the party is a risk party. Valid values are: Y (is a risk party) or N (not a risk party). | |
SETTLEMENT_DEFAULT_CATEGORY | VARCHAR2 | (7) | Settlement default category. Foreign key to XTR_SETTLEMENT_CATEGORIES. | |
SHORT_NAME | VARCHAR2 | (20) | Yes | Short name of the party. |
STATE_CODE | VARCHAR2 | (3) | State identifier. Free text. | |
SWIFT_ID | VARCHAR2 | (11) | ||
TAX_CATEGORY | VARCHAR2 | (7) | Tax category idnetifier. Foreign key to XTR_TAX_CATEGORIES. | |
TAX_EXEMPTION_CODE | VARCHAR2 | (15) | Tax exemption identifier. Free text. | |
TAX_NUMBER | VARCHAR2 | (20) | ||
TITLE_DESCRIPTION | VARCHAR2 | (50) | Title description. Free text. | |
UPDATED_BY | VARCHAR2 | (30) | Last updated user. | |
UPDATED_ON | DATE | Last updated date. | ||
VALUER_YN | VARCHAR2 | (1) | Indicates if the party is a valuer. Valid values are: Y (is a valuer) or N (not a valuer). | |
FX_CPARTY | VARCHAR2 | (1) | ||
MM_CPARTY | VARCHAR2 | (1) | ||
LEGAL_ENTITY_ID | NUMBER | (15) | ||
SUSPENSE_CCID | NUMBER | (15) | ||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
CHART_OF_ACCOUNTS_ID | NUMBER | (15) |
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_DATE_STORED
, 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
FROM XTR.XTR_A_PARTY_INFO;
XTR.XTR_A_PARTY_INFO does not reference any database object
XTR.XTR_A_PARTY_INFO is referenced by following:
|
|
|