1. Tables and Views for SCM
  2. CMK_EXT_PTNR_MSGS_CUST

CMK_EXT_PTNR_MSGS_CUST

The table contains the translation details of the external messages that are exchanged (sent or received) with each partner e.g. outbound OAGIS Process Purchase Order with Partner XYZ.

Details

  • Schema: FUSION

  • Object owner: CMK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

CMK_EXT_PTNR_MSGS_CUST_PK

PARTNER_MESSAGE_CUST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
PARTNER_MESSAGE_CUST_ID NUMBER 18 Yes Primary Key of the External Partner Message Customization.
OVERRIDE_STATUS VARCHAR2 100 Override Status of the External Partner Message. Defaults to Entered, Can be set to Active or Inactive.
OVERRIDE_STATUS_DATE TIMESTAMP Override External Partner Message Status Date.
RETENTION_DURATION_TYPE VARCHAR2 100 Retention Duration Type e.g. Date or Month or Year
RETENTION_DURATION NUMBER 4 Retention Duration value
PARTNER_MESSAGE_ID NUMBER 18 Foreign Key to the External Partner Message Base. Obsolete
DELIVERY_METHOD_ID NUMBER 18 Foreign Key to Delivery Method table.
ALT_DELIVERY_METHOD_ID NUMBER 18 To store alternate delivery method for outbound message.
ENABLE_ATTACHMENTS CHAR 1 Enable Attachment Flag is used to identify if attachments are allowed for message processing with the payload.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ATTCH_PROCESS_MTHD VARCHAR2 64 ATTCH_PROCESS_MTHD signify the attachment method to be used while processing the message. Eg: MIME.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
TP_IDENTIFIER_XPATH VARCHAR2 2000 An XPath expression that identifies the Trading Partner in an XML payload.
TP_TYPE_IDENTIFIER_XPATH VARCHAR2 2000 An XPath expression that identifies the Trading Partner Type in an XML payload.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.
ENDPOINT_SUFFIX VARCHAR2 512 A suffix for web services delivery methods. The value in this field is concatenated with the endpoint for the web service delivery method during processing and delivery of B2B messages.

Foreign Keys

Table Foreign Table Foreign Key Column
CMK_EXT_PTNR_MSGS_CUST cmk_delivery_methods DELIVERY_METHOD_ID

Indexes

Index Uniqueness Tablespace Columns
CMK_EXT_PTNR_MSGS_CUST_U1 Unique FUSION_TS_SEED PARTNER_MESSAGE_CUST_ID, ORA_SEED_SET1
CMK_EXT_PTNR_MSGS_CUST_U11 Unique FUSION_TS_SEED PARTNER_MESSAGE_CUST_ID, ORA_SEED_SET2