[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_TRADING_PARTNERS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_TRADING_PARTNERS
|
| Subobject Name: | |
| Status: | VALID |
This table stores information about the different organizations: customers, vendors, and planned organizations.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_TRADING_PARTNERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PARTNER_ID
|
| MSC_TRADING_PARTNERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SR_INSTANCE_ID
SR_TP_ID
PARTNER_TYPE
COMPANY_ID
ORGANIZATION_CODE
|
| MSC_TRADING_PARTNERS_U3 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PARTNER_TYPE
PARTNER_NAME
COMPANY_ID
|
| MSC_TRADING_PARTNERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MODELED_SUPPLIER_ID
MODELED_SUPPLIER_SITE_ID
|
| MSC_TRADING_PARTNERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SR_INSTANCE_ID
CALENDAR_CODE
CALENDAR_EXCEPTION_SET_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTNER_ID | NUMBER | Yes | Unique partner identifier which can be customer id, vendor id, or inventory organization id | |
| SR_TP_ID | NUMBER | Yes | Unique partner identifier in the source application instance | |
| SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
| ORGANIZATION_CODE | VARCHAR2 | (7) | The code includes instance code and organization code | |
| DISABLE_DATE | DATE | Disable date of the trading partner | ||
| STATUS | VARCHAR2 | (1) | Status of the trading partner | |
| MASTER_ORGANIZATION | NUMBER | Master organization identifier | ||
| WEIGHT_UOM | VARCHAR2 | (3) | Weight unit of measure | |
| MAXIMUM_WEIGHT | NUMBER | Weight capacity | ||
| VOLUME_UOM | VARCHAR2 | (3) | Volume unit of measure | |
| MAXIMUM_VOLUME | NUMBER | Volume capacity | ||
| PARTNER_TYPE | NUMBER | Yes | Specify the type of partner: Customer, Supplier, or Organization | |
| PARTNER_NAME | VARCHAR2 | (255) | Yes | Name of the supplier or customer |
| PARTNER_NUMBER | VARCHAR2 | (154) | Number of the supplier or customer | |
| CALENDAR_CODE | VARCHAR2 | (14) | Calendar used for this partner.The code includes instance code and calendar code from the source apps. | |
| CALENDAR_EXCEPTION_SET_ID | NUMBER | Calendar exception set identifier | ||
| OPERATING_UNIT | NUMBER | Operating unit | ||
| PROJECT_REFERENCE_ENABLED | NUMBER | Flag indicates whether project references are allowed in the organization or not | ||
| PROJECT_CONTROL_LEVEL | NUMBER | Specifies whether project references are being tracked at the project or task level | ||
| SOURCE_ORG_ID | NUMBER | Org level default for source organization | ||
| DEMAND_LATENESS_COST | NUMBER | Demand lateness cost | ||
| SUPPLIER_CAP_OVERUTIL_COST | NUMBER | Supplier overutilization cost | ||
| RESOURCE_CAP_OVERUTIL_COST | NUMBER | Resource overutilization cost | ||
| DEFAULT_DEMAND_CLASS | VARCHAR2 | (34) | Default demand class assigned to the organization | |
| MODELED_CUSTOMER_ID | NUMBER | Customer identifier which is modelled as inventory organization | ||
| MODELED_CUSTOMER_SITE_ID | NUMBER | Customer site identifier which is modelled as inventory organization | ||
| MODELED_SUPPLIER_ID | NUMBER | Supplier identifier which is modelled as inventory organization | ||
| MODELED_SUPPLIER_SITE_ID | NUMBER | Supplier site identifier which is modelled as inventory organization | ||
| TRANSPORT_CAP_OVER_UTIL_COST | NUMBER | The Penalty cost for transportation capacity | ||
| REFRESH_NUMBER | NUMBER | Refresh number | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| USE_PHANTOM_ROUTINGS | NUMBER | Use-phantom-routings flag | ||
| INHERIT_PHANTOM_OP_SEQ | NUMBER | Inherit-phantom-op-seq flag | ||
| DEFAULT_ATP_RULE_ID | NUMBER | Default ATP rule identifier | ||
| MATERIAL_ACCOUNT | NUMBER | Material account | ||
| EXPENSE_ACCOUNT | NUMBER | Expense account | ||
| ORGANIZATION_TYPE | NUMBER | Organization type | ||
| SERVICE_LEVEL | NUMBER | Service level | ||
| CUSTOMER_CLASS_CODE | VARCHAR2 | (30) | Customer Class Code | |
| COMPANY_ID | NUMBER | Company Id | ||
| ORG_SUPPLIER_MAPPED | VARCHAR2 | (1) | Flag to Indicate if the Instance Org is modelled as a Supplier | |
| INHERIT_OC_OP_SEQ_NUM | NUMBER | Value of profile option INHERIT_OPTION_CLASS_OP_SEQ | ||
| ACCEPT_DEMANDS_FROM_UNMET_PO | NUMBER | 1- Yes, 2-No | ||
| SR_BUSINESS_GROUP_ID | NUMBER | BUSINESS_GROUP_ID of the org in source | ||
| SR_LEGAL_ENTITY | NUMBER | LEGAL_ENTITY id of the org in teh source | ||
| SR_SET_OF_BOOKS_ID | NUMBER | SET_OF_BOOKS_ID of the org in source | ||
| SR_CHART_OF_ACCOUNTS_ID | NUMBER | CHART_OF_ACCOUNTS_ID of the org in source | ||
| CUSTOMER_TYPE | VARCHAR2 | (30) | CUSTOMER_TYPE | |
| BUSINESS_GROUP_NAME | VARCHAR2 | (240) | BUSINESS_GROUP_NAME of the org | |
| LEGAL_ENTITY_NAME | VARCHAR2 | (240) | LEGAL_ENTITY_NAME of the org | |
| OPERATING_UNIT_NAME | VARCHAR2 | (240) | OPERATING_UNIT_NAME of the org | |
| CURRENCY_CODE | VARCHAR2 | (14) | Currency used for this partner.The code is populated only for organizations. | |
| SUBCONTRACTING_SOURCE_ORG | NUMBER | Subcontracting Source Org |
Cut, paste (and edit) the following text to query this object:
SELECT PARTNER_ID
, SR_TP_ID
, SR_INSTANCE_ID
, ORGANIZATION_CODE
, DISABLE_DATE
, STATUS
, MASTER_ORGANIZATION
, WEIGHT_UOM
, MAXIMUM_WEIGHT
, VOLUME_UOM
, MAXIMUM_VOLUME
, PARTNER_TYPE
, PARTNER_NAME
, PARTNER_NUMBER
, CALENDAR_CODE
, CALENDAR_EXCEPTION_SET_ID
, OPERATING_UNIT
, PROJECT_REFERENCE_ENABLED
, PROJECT_CONTROL_LEVEL
, SOURCE_ORG_ID
, DEMAND_LATENESS_COST
, SUPPLIER_CAP_OVERUTIL_COST
, RESOURCE_CAP_OVERUTIL_COST
, DEFAULT_DEMAND_CLASS
, MODELED_CUSTOMER_ID
, MODELED_CUSTOMER_SITE_ID
, MODELED_SUPPLIER_ID
, MODELED_SUPPLIER_SITE_ID
, TRANSPORT_CAP_OVER_UTIL_COST
, REFRESH_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USE_PHANTOM_ROUTINGS
, INHERIT_PHANTOM_OP_SEQ
, DEFAULT_ATP_RULE_ID
, MATERIAL_ACCOUNT
, EXPENSE_ACCOUNT
, ORGANIZATION_TYPE
, SERVICE_LEVEL
, CUSTOMER_CLASS_CODE
, COMPANY_ID
, ORG_SUPPLIER_MAPPED
, INHERIT_OC_OP_SEQ_NUM
, ACCEPT_DEMANDS_FROM_UNMET_PO
, SR_BUSINESS_GROUP_ID
, SR_LEGAL_ENTITY
, SR_SET_OF_BOOKS_ID
, SR_CHART_OF_ACCOUNTS_ID
, CUSTOMER_TYPE
, BUSINESS_GROUP_NAME
, LEGAL_ENTITY_NAME
, OPERATING_UNIT_NAME
, CURRENCY_CODE
, SUBCONTRACTING_SOURCE_ORG
FROM MSC.MSC_TRADING_PARTNERS;
MSC.MSC_TRADING_PARTNERS does not reference any database object
MSC.MSC_TRADING_PARTNERS is referenced by following:
APPS
MSC_ATP_PLAN_SN
MSC_PHUB_DATES_MV
MSC_PHUB_PROJECTS_MV
MSC
MSC_TRADING_PARTNERS#
|
|
|
|