1. Tables and Views for SCM
  2. CMK_EXTERNAL_MSG_TYPES_B

CMK_EXTERNAL_MSG_TYPES_B

This table captures the business messages that are exchanged with collaboration partners, including information such as version, standards body that defined the message type (e.g. OAGIS) etc. It refers to a specific format (document type) in which a Collaboration Document exchanged with a partner or service provider.

Details

  • Schema: FUSION

  • Object owner: CMK

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

CMK_EXT_MSG_TYPES_B_PK

EXT_MESSAGE_TYPE_ID

Columns

Name Datatype Length Precision Not-null Comments
EXT_MESSAGE_TYPE_ID NUMBER 18 Yes Primary key for the External Message Type.
EXT_MESSAGE_TYPE_NAME VARCHAR2 256 Yes Name of the External Message Type e.g. OAGIS-10.1-ProcessPurchaseOrderCollaborationMessage (Message Name is <Standard>-<Version>-<Collaboration Message>.
MESSAGE_TYPE VARCHAR2 100 Yes Name of the External Message Type e.g. Process Purchase Order.
VERSION VARCHAR2 100 Yes Version of the type e.g. 9.6.
STANDARD VARCHAR2 100 Yes Message Standard. e.g OAGIS.
DOCUMENT_SUBTYPE VARCHAR2 512 Document Subtype of External Message Type.
DOCUMENT_TYPE VARCHAR2 256 Yes The type of collaboration document e.g. Process Purchase Order.
VALIDATION_PAYLOAD CLOB Validation Payload Template to test inbound collaboration message.
CONFIGURABLE_FLAG VARCHAR2 100 Flag that indicates if messages that are associated by this type can be configured by users
IN_IDENTIFICATION_XPATH VARCHAR2 2000 This column stores value of XPATH which will be applied to Input payload to get the Document Subtype
MESSAGE_IDENTIFIER_XPATH VARCHAR2 2000 This column stores the XPATH to identify the Sender Message Id.
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.
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.
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.
OBJECT_XPATH VARCHAR2 2000 An XPath expression that identifies the multiple orders in an XML payload.
OBN_DOC_TYPE_MAP VARCHAR2 256 A value provided will be used to correlate the OBN DocType
PO_LINE_XPATH VARCHAR2 2000 An XPath expression that identifies order lines for Process and Change Purchase Order 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.
REFERENCE_OBJECT_KEY_XPATH VARCHAR2 2000 Reference Object Key XPath is an XPath expression that identifies the location of the reference object key in an XML payload. For example, the purchase order number is the reference object key in the invoice XML file or in the shipment XML file.

Foreign Keys

Table Foreign Table Foreign Key Column
cmk_collab_messages_b cmk_external_msg_types_b EXT_MESSAGE_TYPE_ID
cmk_account_num_locators cmk_external_msg_types_b EXT_MESSAGE_TYPE_ID

Indexes

Index Uniqueness Tablespace Columns Status
CMK_EXT_MSG_TYPES_B_U1 Unique FUSION_TS_SEED EXT_MESSAGE_TYPE_ID, ORA_SEED_SET1
CMK_EXT_MSG_TYPES_B_U11 Unique FUSION_TS_SEED EXT_MESSAGE_TYPE_ID, ORA_SEED_SET2
CMK_EXT_MSG_TYPES_B_U2 Unique FUSION_TS_SEED EXT_MESSAGE_TYPE_NAME, ORA_SEED_SET1
CMK_EXT_MSG_TYPES_B_U21 Unique FUSION_TS_SEED EXT_MESSAGE_TYPE_NAME, ORA_SEED_SET2
CMK_EXT_MSG_TYPES_B_U3 Unique FUSION_TS_SEED MESSAGE_TYPE, VERSION, STANDARD, DOCUMENT_SUBTYPE Obsolete
CMK_EXT_MSG_TYPES_B_U4 Unique FUSION_TS_SEED MESSAGE_TYPE, VERSION, STANDARD, DOCUMENT_SUBTYPE, DOCUMENT_TYPE, ORA_SEED_SET1
CMK_EXT_MSG_TYPES_B_U41 Unique FUSION_TS_SEED MESSAGE_TYPE, VERSION, STANDARD, DOCUMENT_SUBTYPE, DOCUMENT_TYPE, ORA_SEED_SET2