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

TABLE: FTE.FTE_MESSAGE_PARTNER

Object Details
Object Name: FTE_MESSAGE_PARTNER
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_MESSAGE_PARTNER
Subobject Name:
Status: VALID


This table stores all the partners listed in the Shipstatus message


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_MESSAGE_PARTNER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
FTE_MESSAGE_PARTNER_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary Key
NAME1 VARCHAR2 (50)
Name
NAME2 VARCHAR2 (50)
Name
NAME3 VARCHAR2 (50)
Name
NAME4 VARCHAR2 (50)
Name
NAME5 VARCHAR2 (50)
Name
NAME6 VARCHAR2 (50)
Name
NAME7 VARCHAR2 (50)
Name
NAME8 VARCHAR2 (50)
Name
NAME9 VARCHAR2 (50)
Name
ONETIME VARCHAR2 (50)
One time use
PARTNER_ID NUMBER

Partner ID
PARTNER_TYPE VARCHAR2 (15)
Partner Type
ACTIVE VARCHAR2 (1)
is this partner Active?
CURRENCY VARCHAR2 (10)
Partner's preferred Currency
DESCRIPTION VARCHAR2 (1000)
Description
DUNS_NUMBER VARCHAR2 (30)
DUNS number
GL_ENTITIES VARCHAR2 (30)
GL Entities
PARENT_ID NUMBER

Parent ID
PARTNER_ID_X VARCHAR2 (30)
Partner ID X
PARTNER_RATING VARCHAR2 (30)
Partner Rating
PARTNER_ROLE VARCHAR2 (30)
Partner Role
PAYMENT_METHOD VARCHAR2 (30)
Payment Method
TAX_EXEMPT VARCHAR2 (1)
Tax Exempt flag
TAX_ID VARCHAR2 (30)
Tax ID
TERM_ID VARCHAR2 (30)
Term ID
CREATED_BY NUMBER

Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER

Last Updated By
LAST_UPDATE_DATE DATE

Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
SHIPPER_ACCOUNT_NUMBER VARCHAR2 (30)
Shipper Account Number
TRANSACTION_ID NUMBER
Yes FK reference to headers table
Query Text

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


SELECT ID
,      NAME1
,      NAME2
,      NAME3
,      NAME4
,      NAME5
,      NAME6
,      NAME7
,      NAME8
,      NAME9
,      ONETIME
,      PARTNER_ID
,      PARTNER_TYPE
,      ACTIVE
,      CURRENCY
,      DESCRIPTION
,      DUNS_NUMBER
,      GL_ENTITIES
,      PARENT_ID
,      PARTNER_ID_X
,      PARTNER_RATING
,      PARTNER_ROLE
,      PAYMENT_METHOD
,      TAX_EXEMPT
,      TAX_ID
,      TERM_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SHIPPER_ACCOUNT_NUMBER
,      TRANSACTION_ID
FROM FTE.FTE_MESSAGE_PARTNER;

Dependencies

[top of page]

FTE.FTE_MESSAGE_PARTNER does not reference any database object

FTE.FTE_MESSAGE_PARTNER is referenced by following:

SchemaFTE
ViewFTE_MESSAGE_PARTNER#