[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ST_TRADING_PARTNERS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_ST_TRADING_PARTNERS
|
| Subobject Name: | |
| Status: | VALID |
The staging table used by the collection program to validate and process data for table MSC_TRADING_PARTNERS.
| Tablespace: |  |
|---|---|
| PCT Free: | |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PARTNER_ID | NUMBER | Unique partner identifier which can be customer id, supplier id, or inventory organization id | ||
| ORGANIZATION_CODE | VARCHAR2 | (7) | Organization code | |
| SR_TP_ID | NUMBER | Unique partner identifier in the source application instance | ||
| DISABLE_DATE | DATE | Disable date of the trading partner | ||
| STATUS | VARCHAR2 | (1) | Status of the trading partner | |
| MASTER_ORGANIZATION | NUMBER | Master organization identifier | ||
| PARTNER_TYPE | NUMBER | Specify the type of partner: Customer, Supplier, or organization | ||
| PARTNER_NAME | VARCHAR2 | (1020) | 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 app. | |
| CALENDAR_EXCEPTION_SET_ID | NUMBER | Calendar exception set identifier | ||
| OPERATING_UNIT | NUMBER | Operating unit | ||
| MAXIMUM_WEIGHT | NUMBER | Maximum weight | ||
| MAXIMUM_VOLUME | NUMBER | Maximum volume | ||
| WEIGHT_UOM | VARCHAR2 | (3) | Weight unit of measure | |
| VOLUME_UOM | VARCHAR2 | (3) | Volume unit of measure | |
| PROJECT_REFERENCE_ENABLED | NUMBER | Project reference enabled flag | ||
| PROJECT_CONTROL_LEVEL | NUMBER | Project control level | ||
| DEMAND_LATENESS_COST | NUMBER | Demand lateness cost | ||
| SUPPLIER_CAP_OVERUTIL_COST | NUMBER | Supplier over-utilization cost | ||
| RESOURCE_CAP_OVERUTIL_COST | NUMBER | Resource over-utilization cost | ||
| DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS will be deleted | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | 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 | ||
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
| REFRESH_ID | NUMBER | Refresh identifier | ||
| 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 dentifier 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 | Transportation over-utilization cost | ||
| USE_PHANTOM_ROUTINGS | NUMBER | Use phantom routings | ||
| INHERIT_PHANTOM_OP_SEQ | NUMBER | Inherit phantom op sequence | ||
| DEFAULT_ATP_RULE_ID | NUMBER | Default ATP rule identifier | ||
| DEFAULT_DEMAND_CLASS | VARCHAR2 | (34) | Default demand class | |
| MATERIAL_ACCOUNT | NUMBER | Material account | ||
| EXPENSE_ACCOUNT | NUMBER | Expense account | ||
| SOURCE_ORG_ID | NUMBER | Organization to source items from | ||
| ORGANIZATION_TYPE | NUMBER | Organization | ||
| SERVICE_LEVEL | NUMBER | Service level | ||
| CUSTOMER_CLASS_CODE | VARCHAR2 | (30) | Customer Class Code | |
| COMPANY_ID | NUMBER | Company identifier | ||
| COMPANY_NAME | VARCHAR2 | (255) | Company name | |
| SR_INSTANCE_CODE | VARCHAR2 | (3) | Source Instance code | |
| DEFAULT_ATP_RULE_NAME | VARCHAR2 | (80) | ATP Rule | |
| SOURCE_ORG_CODE | VARCHAR2 | (7) | Source Organization code | |
| MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | ||
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | ||
| DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source Type indicating the source of the records | |
| ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
| ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
| BATCH_ID | NUMBER | Batch identifier generated during pre-processing | ||
| PLANNING_ENABLED_FLAG | VARCHAR2 | (1) | Planning Enabled Flag | |
| MODELED_CUSTOMER_NAME | VARCHAR2 | (255) | For Cross Instance Planning, represents the customer code for the instance modelled as customer | |
| MODELED_SUPPLIER_NAME | VARCHAR2 | (255) | For Cross Instance Planning, represents the supplier for the instance modelled as supplier | |
| MODELED_CUSTOMER_SITE_CODE | VARCHAR2 | (30) | For Cross Instance Planning, represents the customer code for the instance modelled as customer | |
| MODELED_SUPPLIER_SITE_CODE | VARCHAR2 | (30) | For Cross Instance Planning, represents the supplier code for the instance modelled as supplier | |
| MASTER_ORGANIZATION_CODE | VARCHAR2 | (7) | ||
| INHERIT_OC_OP_SEQ_NUM | NUMBER | |||
| AGGREGATE_DEMAND_FLAG | NUMBER | |||
| SOURCE_SOURCE_ORG_ID | NUMBER | |||
| SOURCE_SR_TP_ID | NUMBER | |||
| BUSINESS_GROUP_ID | NUMBER | |||
| LEGAL_ENTITY | NUMBER | |||
| SET_OF_BOOKS_ID | NUMBER | |||
| CHART_OF_ACCOUNTS_ID | NUMBER | |||
| CUSTOMER_TYPE | VARCHAR2 | (240) | ||
| BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
| LEGAL_ENTITY_NAME | VARCHAR2 | (240) | ||
| OPERATING_UNIT_NAME | VARCHAR2 | (240) | ||
| CUST_ACCOUNT_NUMBER | VARCHAR2 | (240) | ||
| RESOURCE_TYPE | NUMBER | |||
| CURRENCY_CODE | VARCHAR2 | (14) | ||
| SUBCONTRACTING_SOURCE_ORG | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PARTNER_ID
, ORGANIZATION_CODE
, SR_TP_ID
, DISABLE_DATE
, STATUS
, MASTER_ORGANIZATION
, PARTNER_TYPE
, PARTNER_NAME
, PARTNER_NUMBER
, CALENDAR_CODE
, CALENDAR_EXCEPTION_SET_ID
, OPERATING_UNIT
, MAXIMUM_WEIGHT
, MAXIMUM_VOLUME
, WEIGHT_UOM
, VOLUME_UOM
, PROJECT_REFERENCE_ENABLED
, PROJECT_CONTROL_LEVEL
, DEMAND_LATENESS_COST
, SUPPLIER_CAP_OVERUTIL_COST
, RESOURCE_CAP_OVERUTIL_COST
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID
, REFRESH_ID
, MODELED_CUSTOMER_ID
, MODELED_CUSTOMER_SITE_ID
, MODELED_SUPPLIER_ID
, MODELED_SUPPLIER_SITE_ID
, TRANSPORT_CAP_OVER_UTIL_COST
, USE_PHANTOM_ROUTINGS
, INHERIT_PHANTOM_OP_SEQ
, DEFAULT_ATP_RULE_ID
, DEFAULT_DEMAND_CLASS
, MATERIAL_ACCOUNT
, EXPENSE_ACCOUNT
, SOURCE_ORG_ID
, ORGANIZATION_TYPE
, SERVICE_LEVEL
, CUSTOMER_CLASS_CODE
, COMPANY_ID
, COMPANY_NAME
, SR_INSTANCE_CODE
, DEFAULT_ATP_RULE_NAME
, SOURCE_ORG_CODE
, MESSAGE_ID
, PROCESS_FLAG
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, ERROR_TEXT
, BATCH_ID
, PLANNING_ENABLED_FLAG
, MODELED_CUSTOMER_NAME
, MODELED_SUPPLIER_NAME
, MODELED_CUSTOMER_SITE_CODE
, MODELED_SUPPLIER_SITE_CODE
, MASTER_ORGANIZATION_CODE
, INHERIT_OC_OP_SEQ_NUM
, AGGREGATE_DEMAND_FLAG
, SOURCE_SOURCE_ORG_ID
, SOURCE_SR_TP_ID
, BUSINESS_GROUP_ID
, LEGAL_ENTITY
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, CUSTOMER_TYPE
, BUSINESS_GROUP_NAME
, LEGAL_ENTITY_NAME
, OPERATING_UNIT_NAME
, CUST_ACCOUNT_NUMBER
, RESOURCE_TYPE
, CURRENCY_CODE
, SUBCONTRACTING_SOURCE_ORG
FROM MSC.MSC_ST_TRADING_PARTNERS;
MSC.MSC_ST_TRADING_PARTNERS does not reference any database object
MSC.MSC_ST_TRADING_PARTNERS is referenced by following:
MSC
MSC_ST_TRADING_PARTNERS#
|
|
|
|