| XML Gateway - ECX_ATTRIBUTE_MAPPINGS | This table contains the mapping information between the source and target attributes |
|---|---|
| Column Name | Descritpion |
| ATTRIBUTE_MAP_ID | Attribute Mapping Identifier |
| COND_NODE_TYPE | No longer used |
| LEVEL_MAPPING_ID | Level Mapping Identifier |
| SOURCE_ATTRIBUTE_ID | Source Attribute Identifier |
| TARGET_ATTRIBUTE_ID | Target Attribute Identifier |
| MAP_ID | Map Identifier |
| OCCURRENCE | No longer used |
| COND_VALUE | No longer used |
| COND_NODE | No longer used |
| PARENT_ATTRIBUTE_MAP_ID | No longer used |
| XML Gateway - ECX_DOCLOGS | This table contains the document logs for Inbound, outbound and passthrough messages |
|---|---|
| Column Name | Descritpion |
| MSGID | Message Iedntifier in a Queue |
| PROTOCOL_TYPE | Protocol Type |
| PROTOCOL_ADDRESS | Protocol Address |
| USERNAME | Receiving UserName |
| PASSWORD | Receiving Password |
| ATTRIBUTE1 | Source System Information |
| ATTRIBUTE2 | Reserved Attribute |
| ATTRIBUTE3 | Reserved for Destination Trading Partner Location Code for Dynamic Routing |
| ATTRIBUTE4 | Reserved Attribute |
| ATTRIBUTE5 | Reserved Attribute for Oracle Transport Agent |
| PAYLOAD | Message Payload |
| MESSAGE_TYPE | Payload Type |
| FIELD1 | Reserved for Inbound |
| FIELD2 | Reserved for Inbound |
| FIELD3 | Reserved for Inbound |
| FIELD4 | Reserved for Inbound |
| FIELD5 | Reserved for Inbound |
| FIELD6 | Reserved for Inbound |
| FIELD7 | Reserved for Inbound |
| FIELD8 | Reserved for Inbound |
| FIELD9 | Reserved for Inbound |
| FIELD10 | Reserved for Inbound |
| MESSAGE_STANDARD | Payload Standard |
| FIELD11 | Reserved for Inbound |
| FIELD12 | Reserved for Inbound |
| FIELD13 | Reserved for Inbound |
| FIELD14 | Reserved for Inbound |
| FIELD15 | Reserved for Inbound |
| FIELD16 | Reserved for Inbound |
| FIELD17 | Reserved for Inbound |
| FIELD18 | Reserved for Inbound |
| FIELD19 | Reserved for Inbound |
| FIELD20 | Reserved for Inbound |
| TRANSACTION_TYPE | External Transaction Type Code |
| FIELD21 | Reserved for Inbound |
| FIELD22 | Reserved for Inbound |
| FIELD23 | Reserved for Inbound |
| FIELD24 | Reserved for Inbound |
| FIELD25 | Reserved for Inbound |
| FIELD26 | Reserved for Inbound |
| FIELD27 | Reserved for Inbound |
| FIELD28 | Reserved for Inbound |
| FIELD29 | Reserved for Inbound |
| FIELD30 | Reserved for Inbound |
| TRANSACTION_SUBTYPE | External Transaction Subtype Code |
| LOGFILE | Transaction Logfile |
| INTERNAL_CONTROL_NUMBER | Internal Message Control Number |
| STATUS | Message Processing Status |
| DIRECTION | Message Direction |
| TIME_STAMP | Time Log was Last Updated |
| OUT_MSGID | Outbound Message Identifier |
| ITEM_TYPE | Workflow Item Type |
| ITEM_KEY | Workflow Item Key |
| ACTIVITY_ID | Workflow activity id |
| EVENT_NAME | Workflow event name |
| EVENT_KEY | Workflow event key |
| ORIG_REFERENCE_ID | Original Reference Id |
| CB_EVENT_NAME | Message Callback event name |
| CB_EVENT_KEY | Message Callback event key |
| BLOCK_MODE | Message Callback Mode |
| DOCUMENT_NUMBER | Document Identifier |
| PARTYID | No longer used |
| PARTY_SITE_ID | Source Trading Partner Party Site Identifier |
| PARTY_TYPE | No longer used |
| XML Gateway - ECX_ERRMSGS | |
|---|---|
| Column Name | Descritpion |
| ERROR_ID | |
| MESSAGE |
| XML Gateway - ECX_EXTERNAL_LOGS | This table contains the outbound message logs. |
|---|---|
| Column Name | Descritpion |
| EXTERNAL_PROCESS_ID | External Process Identifier |
| OUT_MSGID | Message Identifier |
| STATUS | Document Status |
| ERROR_ID | Error Message Identifier |
| TIME_STAMP | Last Update Time Stamp |
| XML Gateway - ECX_INTRAN_LOGS | |
|---|---|
| Column Name | Descritpion |
| TRIGGER_ID | |
| MSGID | |
| PROCESS_ID | |
| STATUS | |
| ERROR_ID | |
| TIME_STAMP |
| XML Gateway - ECX_LEVEL_MAPPINGS | This table contains the relationship between the source and target mappings |
|---|---|
| Column Name | Descritpion |
| LEVEL_MAPPING_ID | Level Mapping Identifier |
| SOURCE_LEVEL_ID | Source Object Level Identifier |
| TARGET_LEVEL_ID | Target Object Level Identifier |
| SOURCE_ELEMENT_ID | First Source Attribute Identifier |
| MAP_ID | Map Identifier |
| TARGET_ELEMENT_ID | First Target Attribute Identifier |
| XML Gateway - ECX_MAPPINGS | The table contains the definitions of the maps that are used by XML Gateway |
|---|---|
| Column Name | Descritpion |
| MAP_ID | Map Identifier |
| MAP_CODE | Map Code |
| DESCRIPTION | Map Description |
| OBJECT_ID_SOURCE | Source Object Identifier |
| OBJECT_ID_TARGET | Target Object Identifier |
| ENABLED | Maps Enabled Flag |
| ECX_MAJOR_VERSION | ECX Major Version |
| ECX_MINOR_VERSION | ECX Minor Version |
| CREATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XML Gateway - ECX_OBJECTS | This table contains the source and target objects for the maps. |
|---|---|
| Column Name | Descritpion |
| OBJECT_ID | Object Identifier |
| OBJECT_NAME | Object Name |
| OBJECT_TYPE | Object Type |
| OBJECT_DESCRIPTION | Object Description |
| OBJECT_STANDARD | Object Standard |
| ROOT_ELEMENT | Root Element |
| FULLPATH | DTD Path and FileName |
| MAP_ID | Map Identifier |
| RUNTIME_LOCATION | Map version of the object |
| XML Gateway - ECX_OBJECT_ATTRIBUTES | This table contains the source and target object Attributes |
|---|---|
| Column Name | Descritpion |
| ATTRIBUTE_ID | Attribute Identifier |
| STAGING_COLUMN | No longer used |
| DEFAULT_VALUE | Attribute Default Value |
| ATTRIBUTE_TYPE | Attribute Type |
| HAS_ATTRIBUTES | Number of Attributes |
| LEAF_NODE | Attribute is a Leaf Node Indicator |
| REQUIRED_FLAG | No longer used |
| MAP_ID | Map Identifier |
| COND_NODE | Condition Node Name |
| COND_VALUE | Condition Node Value |
| COND_NODE_TYPE | Condition Node Type |
| OBJECTLEVEL_ID | Object Level Identifier |
| OCCURRENCE | No longer used |
| IS_MAPPED | Attribute is Mapped Indicator |
| ATTRIBUTE_NAME | Attribute Name |
| OBJECT_COLUMN_FLAG | Database Column Flag |
| DATA_TYPE | Data Type |
| PARENT_ATTRIBUTE_ID | Parent Attribute Identifier |
| POSITION | No longer used |
| WIDTH | No longer used |
| XREF_CATEGORY_ID | Code Conversion Category Identifier |
| XML Gateway - ECX_OBJECT_LEVELS | This table contains the source and target object Levels |
|---|---|
| Column Name | Descritpion |
| OBJECTLEVEL_ID | Object Level Identifier |
| OBJECT_ID | Object Identifier |
| OBJECT_LEVEL | Logical Level |
| OBJECT_LEVEL_NAME | Object Level Name |
| PARENT_LEVEL | Parent Object Level |
| ENABLED | No longer used |
| MAP_ID | Map Identifier |
| XML Gateway - ECX_OUTTRAN_LOGS | |
|---|---|
| Column Name | Descritpion |
| PROCESS_ID | |
| STATUS | |
| ERROR_ID | |
| OUT_MSGID | |
| TIME_STAMP |
| XML Gateway - ECX_OUTTRIG_LOGS | |
|---|---|
| Column Name | Descritpion |
| TRIGGER_ID | |
| TRANSACTION_TYPE | |
| DOCUMENT_NUMBER | |
| PROCESS_ID | |
| TIME_STAMP |
| XML Gateway - ECX_PROC_MAPPINGS | This table contains the procedure mappings |
|---|---|
| Column Name | Descritpion |
| PROCMAP_ID | Procedure map Identifier |
| VARIABLE_CONSTANT | Stores Literal Value |
| VARIABLE_VALUE | Variable Value |
| TRANSTAGE_ID | Transaction stage Identifier |
| PARAMETER_NAME | Parameter Name |
| ACTION_TYPE | IN or OUT parameter |
| VARIABLE_LEVEL | Direction variable Level |
| VARIABLE_NAME | Variable Name |
| DATA_TYPE | Datatype as specified in Oracle server |
| VARIABLE_POS | Variable Position |
| MAP_ID | Map Identifier |
| VARIABLE_DIRECTION | Variable direction (Direction or Global or Literal |
| XML Gateway - ECX_STANDARDS | This table contains the standards definitions |
|---|---|
| Column Name | Descritpion |
| STANDARD_ID | Standard Identifier |
| STANDARD_CODE | Standard Code |
| STANDARD_TYPE | Standard Type |
| STANDARD_DESC | Standard Code Description |
| DATA_SEEDED | Seeded Data Flag |
| CREATED_BY | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| XML Gateway - ECX_STANDARD_ATTRIBUTES | This table contains the attributes for a given standard |
|---|---|
| Column Name | Descritpion |
| STANDARD_ATTRIBUTE_ID | Standard Attribute Identifier |
| STANDARD_ID | Standard identifier |
| ATTRIBUTE_NAME | Standard Attribute name |
| ELEMENT_TAG_NAME | Standard Element Name |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XML Gateway - ECX_TP_DETAILS | This table contains the trading partner detail information |
|---|---|
| Column Name | Descritpion |
| TP_HEADER_ID | Trading partner Header Identifier |
| PASSWORD | Password |
| ROUTING_ID | Routing id for passthrough transaction |
| SOURCE_TP_LOCATION_CODE | Source trading partner Location Code |
| EXTERNAL_TP_LOCATION_CODE | Target trading partner Location Code |
| OMB_SYNC | No longer Used |
| CONFIRMATION | Confirmation Indicator |
| CREATED_BY | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| TP_DETAIL_ID | Trading partner Detail Identifier |
| LAST_UPDATE_LOGIN | Standard Who Column |
| HUB_ID | Hub ID |
| MAP_ID | Map Identifier |
| EXT_PROCESS_ID | External transaction Identifier |
| CONNECTION_TYPE | Connection Type |
| HUB_USER_ID | Hub User Identifier |
| PROTOCOL_TYPE | Protocol Type |
| PROTOCOL_ADDRESS | Protocol Address |
| USERNAME | Username |
| XML Gateway - ECX_TP_HEADERS | This table contains Trading Partner header information |
|---|---|
| Column Name | Descritpion |
| TP_HEADER_ID | Trading Partner Header Identifier |
| PARTY_TYPE | Party type |
| PARTY_ID | Party Identifier |
| PARTY_SITE_ID | Party Site identifier |
| COMPANY_ADMIN_EMAIL | Trading Partner Administrator Email Address |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| XML Gateway - ECX_TRANSACTIONS | This table contains internal transaction definitions |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_ID | Internal Transaction identifier |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| ENABLED | Enabled |
| TRANSACTION_DESCRIPTION | Internal Transaction Description |
| TRANSACTION_TYPE | Internal Transaction Type |
| TRANSACTION_SUBTYPE | Internal Transaction subtype |
| PARTY_TYPE | Party type |
| CREATED_BY | Standard Who Column |
| XML Gateway - ECX_TRAN_STAGE_DATA | This table contains the action definitions |
|---|---|
| Column Name | Descritpion |
| TRANSTAGE_ID | Transaction Stage Identifier |
| SEQUENCE_NAME | Sequence Name |
| CUSTOM_PROCEDURE_NAME | Database Procedure Name |
| DATA_TYPE | Datatype |
| FUNCTION_NAME | Database Function Name |
| WHERE_CLAUSE | Where Clause |
| VARIABLE_POS | Result Variable Postion |
| MAP_ID | Map Identifier |
| OBJECTLEVEL_ID | Object Level Identifier |
| OBJECT_DIRECTION | Object Direction |
| VARIABLE_DIRECTION | Result Direction |
| SOURCE_LEVEL_ID | Source Object Level Identifier |
| ACTION_POS | Action Postion |
| COND_LOGICAL_OPERATOR | Not Used |
| COND_OPERATOR1 | First Condition Operator |
| COND_VAR1_LEVEL | First Condition Variable Level |
| COND_VAR1_NAME | First Condition Variable Name |
| COND_VAR1_POS | First Condition Variable Position |
| COND_VAR1_DIRECTION | First Condition Variable Direction |
| COND_VAR1_CONSTANT | First Condition Variable Constant |
| COND_OPERATOR2 | Not Used |
| COND_VAR2_LEVEL | Not Used |
| STAGE | Processing Stage |
| COND_VAR2_NAME | Not Used |
| COND_VAR2_POS | Not Used |
| COND_VAR2_DIRECTION | Not Used |
| COND_VAR2_CONSTANT | Not Used |
| COND_VAL1_LEVEL | First Condition Value Level |
| COND_VAL1_NAME | First Condition Value Name |
| COND_VAL1_POS | First Condition Value Position |
| COND_VAL1_DIRECTION | First Condition Value Direction |
| COND_VAL1_CONSTANT | First Condition Value Constant |
| COND_VAL2_LEVEL | Not Used |
| SEQ_NUMBER | Action Sequence Number |
| COND_VAL2_NAME | Not Used |
| COND_VAL2_POS | Not Used |
| COND_VAL2_DIRECTION | Not Used |
| COND_VAL2_CONSTANT | Not Used |
| OPERAND1_LEVEL | First Operand Level |
| OPERAND1_NAME | First Operand Name |
| OPERAND1_POS | First Operand Position |
| OPERAND1_DIRECTION | First Operand Direction |
| OPERAND1_CONSTANT | First Operand Constant |
| OPERAND1_START_POS | Not Used |
| ACTION_TYPE | Action Type |
| OPERAND1_LEN | Not Used |
| OPERAND2_NAME | Second Operand Name |
| OPERAND2_LEVEL | Second Operand Level |
| OPERAND2_POS | Second Operand Position |
| OPERAND2_DIRECTION | Second Operand Direction |
| OPERAND2_CONSTANT | Second Operand Constant |
| OPERAND3_LEVEL | Third Operand Level |
| OPERAND3_NAME | Third Operand Name |
| OPERAND3_POS | Third Operand Position |
| OPERAND3_DIRECTION | Third Operand Direction |
| VARIABLE_LEVEL | Result Variable Level |
| OPERAND3_CONSTANT | Third Operand Constant |
| OPERAND4_LEVEL | Fourth Operand Level |
| OPERAND4_NAME | Fourth Operand Name |
| OPERAND4_POS | Fourth Operand Position |
| OPERAND4_DIRECTION | Fourth Operand Direction |
| OPERAND4_CONSTANT | Fourth Operand Constant |
| OPERAND5_LEVEL | Fifth Operand Level |
| OPERAND5_NAME | Fifth Operand Name |
| OPERAND5_POS | Fifth Operand Position |
| OPERAND5_DIRECTION | Fifth Operand Direction |
| VARIABLE_NAME | Result Variable Name |
| OPERAND5_CONSTANT | Fifth Operand Constant |
| OPERAND6_LEVEL | Sixth Operand Level |
| OPERAND6_NAME | Sixth Operand Name |
| OPERAND6_POS | Sixth Operand Position |
| OPERAND6_DIRECTION | Sixth Operand Direction |
| OPERAND6_CONSTANT | Sixth Operand Constant |
| VARIABLE_VALUE | Result Variable Value |
| DEFAULT_VALUE | Result Default Value |
| XML Gateway - ECX_XREF_DTL | This table contains the trading partners code conversion values. |
|---|---|
| Column Name | Descritpion |
| XREF_DTL_ID | Conversion Category Value Identifier |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XREF_CATEGORY_ID | Code Conversion Category Identifier |
| STANDARD_ID | Standard Identifier |
| XREF_STANDARD_CODE | Not Used |
| TP_HEADER_ID | Trading Partner Header Identifier |
| XREF_EXT_VALUE | Code Conversion External Category Value |
| XREF_INT_VALUE | Code Conversion Internal Category Value |
| DESCRIPTION | Code Conversion Internal Category Value Description |
| DIRECTION | Direction |
| XML Gateway - ECX_XREF_HDR | This table contains the code conversion categories. |
|---|---|
| Column Name | Descritpion |
| XREF_CATEGORY_ID | Code Conversion Category unique identifier |
| XREF_CATEGORY_CODE | Code Conversion Category Code |
| DESCRIPTION | Code Conversion Category Description |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XML Gateway - ECX_XREF_STANDARDS | This table contains the code conversion category values. |
|---|---|
| Column Name | Descritpion |
| XREF_STANDARD_ID | Code Conversion Category Value Identifier |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XREF_CATEGORY_ID | Code Conversion Category Identifier |
| STANDARD_ID | Standard Identifier |
| XREF_STANDARD_CODE | Not Used |
| XREF_STD_VALUE | Code Conversion Standard Value |
| XREF_INT_VALUE | Code Conversion Internal Value |
| DESCRIPTION | Code Conversion Standard Value Description |
| DATA_SEEDED | Seeded Data Indicator |
| LAST_UPDATE_DATE | Standard Who Column |
| XML Gateway - ECX_HUBS | This table contains the hub definitions |
|---|---|
| Column Name | Descritpion |
| HUB_ID | Hub Identifier |
| NAME | Hub Name |
| PROTOCOL_TYPE | Protocol Type |
| PROTOCOL_ADDRESS | Protocol Address |
| CREATED_BY | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XML Gateway - ECX_HUB_USERS | This table contains the hub user definitions |
|---|---|
| Column Name | Descritpion |
| HUB_USER_ID | Hub User Identifier |
| LAST_UPDATE_LOGIN | Standard Who Column |
| HUB_ID | Hub Identifier |
| HUB_ENTITY_CODE | Hub Location Code |
| USERNAME | Receiving UserName |
| PASSWORD | Receiving Password |
| CREATED_BY | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| XML Gateway - ECX_EXT_PROCESSES | This table contains the external transaction definitions. |
|---|---|
| Column Name | Descritpion |
| EXT_PROCESS_ID | External Transaction Identifier |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| EXT_TYPE | External Transaction Type |
| EXT_SUBTYPE | External Transaction Subtype |
| TRANSACTION_ID | Internal Transaction Identifier |
| STANDARD_ID | Standard Identifier |
| QUEUE_NAME | Queue Name |
| DIRECTION | Transaction Direction |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| XML Gateway - ECX_DUMMY | |
|---|---|
| Column Name | Descritpion |
| DUMMY |
| XML Gateway - ECX_DTDS | This table contains the DTD's used by XML Gateway |
|---|---|
| Column Name | Descritpion |
| DTD_ID | DTD Identifier |
| DESCRIPTION | DTD Description |
| FILENAME | DTD FileName |
| ROOT_ELEMENT | DTD Root Element |
| VERSION | User-defined DTD Version |
| PAYLOAD | Actual DTD |
| XML Gateway - ECX_OXTA_LOGMSG | This table contains the Oracle Transport Agent message logs |
|---|---|
| Column Name | Descritpion |
| SENDER_MESSAGE_ID | Sender Message Identifier |
| PROTOCOL_TYPE | Protocol Type |
| PROTOCOL_ADDRESS | Protocol Address |
| RESULT_CODE | Result Status Code |
| RESULT_TEXT | Result Message |
| RECEIPT_MESSAGE_ID | Receipt Message Identifier |
| COMPLETED_DATE | Message Processing Date |
| EXCEPTION_TEXT | Exception Message |
| DIRECTION | Message Direction |
| STATUS | Message Status |
| BEGIN_DATE | Message Start Date |
| REQUEST_TYPE | Request Type |
| CONTENT_LENGTH | Message length |
| TRANSACTION_TYPE | Transaction Type |
| USERNAME | UserName |
| IP_ADDRESS | IP Address |
| XML Gateway - ECX_STANDARDS_TL | This table contains the translated standards definition |
|---|---|
| Column Name | Descritpion |
| STANDARD_TYPE | Standard Type |
| STANDARD_DESC | Standard Code Description |
| STANDARD_CODE | Standard Code |
| CREATED_BY | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| STANDARD_ID | |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| LANGUAGE | Translated Language |
| SOURCE_LANG | Seeded language |
| XML Gateway - ECX_TRANSACTIONS_TL | This table contains translated internal transaction definitions |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_SUBTYPE | Internal Transactions subtype |
| PARTY_TYPE | Party type |
| TRANSACTION_DESCRIPTION | Internal Transaction Description |
| TRANSACTION_TYPE | Internal Transactions Type |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| TRANSACTION_ID | |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LANGUAGE | Translated Language |
| SOURCE_LANG | Seeded Language |
| XML Gateway - ECX_XREF_HDR_TL | This table contains the translated code conversion categories. |
|---|---|
| Column Name | Descritpion |
| XREF_CATEGORY_CODE | Code Conversion Category Code |
| DESCRIPTION | Code Conversion Category Description |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| XREF_CATEGORY_ID | |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| LANGUAGE | Translated Language |
| SOURCE_LANG | Seeded Language |
| XML Gateway - ECX_EXTERNAL_RETRY | This table contains the outbound logs for resent messages. |
|---|---|
| Column Name | Descritpion |
| RETRY_MSGID | Retry Message Identifier |
| STATUS | Retry Document Status |
| ERROR_ID | Error Message Identifier |
| TIME_STAMP | Last Update Time Stamp |
| MSGID | Original Message Identifier |
| XML Gateway - ECX_ERROR_MSGS | This table contains the error messages that are generated during transaction processing. |
|---|---|
| Column Name | Descritpion |
| MESSAGE | Error Message |
| MESSAGE_PARAMETERS | Message Parameters |
| ERROR_ID | Error Message Identifier |
| XML Gateway - ECX_INBOUND_LOGS | This table contains the inbound transaction logs. |
|---|---|
| Column Name | Descritpion |
| MSGID | Message Identifier |
| PROCESS_ID | Process Identifier |
| STATUS | Processing Status |
| ERROR_ID | Error Message Identifier |
| LOGFILE | Processing Logfile |
| TIME_STAMP | Last Update Time Stamp |
| TRIGGER_ID | Triggerring Identifier |
| XML Gateway - ECX_MSG_LOGS | This table contains the inbound and outbound message logs. |
|---|---|
| Column Name | Descritpion |
| TRIGGER_ID | Trigger Identifier |
| ERROR_ID | Error Message Identifier |
| LOG_ID | Message Log Identifier |
| XML Gateway - ECX_OUTBOUND_LOGS | This table contains the outbound transaction logs |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_TYPE | External Transaction Type |
| TRANSACTION_SUBTYPE | External Transaction Subtype |
| PARTY_ID | Party Identifier |
| PARTY_SITE_ID | Party Site Identifier |
| DOCUMENT_NUMBER | Document Number |
| PROCESS_ID | No longer used |
| STATUS | Processing Status |
| ERROR_ID | Error Message Identifier |
| TRIGGER_ID | Trigger Identifier |
| OUT_MSGID | Message Identifier |
| LOGFILE | Processing Logfile |
| TIME_STAMP | Last Update Time Stamp |
| PARTY_TYPE | The Party Type |
| XML Gateway - ECX_FILES | This table contains XSLT Files |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who Column |
| PAYLOAD | actual content of the file |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| NAME | name of file |
| VERSION | Version of the File |
| APPLICATION_CODE | application code |
| LAST_UPDATE_DATE | last update date |
| TYPE | file type i.e. XML ,XSLT,DTD's |
| ID | Unique identifier for the table |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XML Gateway - ECX_STANDARDS_B | This table contains the standards definitions |
|---|---|
| Column Name | Descritpion |
| STANDARD_ID | Standard Identifier |
| STANDARD_CODE | Standard Code |
| STANDARD_TYPE | Standard Type |
| DATA_SEEDED | Seeded Data Flag |
| APPLICATION_ID | Application Id |
| CREATED_BY | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| XML Gateway - ECX_TRANSACTIONS_B | This table contains internal transaction definitions |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_ID | Internal Transaction identifier |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| ENABLED | Enabled |
| ADMIN_USER | ADMIN_USER |
| TRANSACTION_TYPE | Internal Transaction Type |
| TRANSACTION_SUBTYPE | Internal Transaction subtype |
| PARTY_TYPE | Party type |
| APPLICATION_ID | Application Id |
| CREATED_BY | Standard Who Column |
| XML Gateway - ECX_XREF_DTL_B | This table contains the trading partners code conversion values. |
|---|---|
| Column Name | Descritpion |
| XREF_DTL_ID | Conversion Category Value Identifier |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XREF_CATEGORY_ID | Code Conversion Category Identifier |
| STANDARD_ID | Standard Identifier |
| XREF_STANDARD_CODE | Not Used |
| TP_HEADER_ID | Trading Partner Header Identifier |
| XREF_EXT_VALUE | Code Conversion External Category Value |
| XREF_INT_VALUE | Code Conversion Internal Category Value |
| DIRECTION | Direction |
| APPLICATION_ID | Application Id |
| XML Gateway - ECX_XREF_HDR_B | This table contains the code conversion categories. |
|---|---|
| Column Name | Descritpion |
| XREF_CATEGORY_ID | Code Conversion Category unique identifier |
| XREF_CATEGORY_CODE | Code Conversion Category Code |
| APPLICATION_ID | Application Id |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XML Gateway - ECX_XREF_STANDARDS_B | This table contains the code conversion category values. |
|---|---|
| Column Name | Descritpion |
| XREF_STANDARD_ID | Code Conversion Category Value Identifier |
| LAST_UPDATED_BY | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| CREATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| XREF_CATEGORY_ID | Category Id |
| STANDARD_ID | Standard Id |
| XREF_STANDARD_CODE | Standard Code |
| XREF_STD_VALUE | Code Conversion Standard Value |
| XREF_INT_VALUE | Code Conversion Internal Value |
| DATA_SEEDED | Seeded Data Indicator |
| APPLICATION_ID | Application Id |
| LAST_UPDATE_DATE | Standard Who Column |
| XML Gateway - ECX_XREF_DTL_TL | |
|---|---|
| Column Name | Descritpion |
| DESCRIPTION | |
| LANGUAGE | |
| SOURCE_LANG | |
| XREF_DTL_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_LOGIN |
| XML Gateway - ECX_XREF_STANDARDS_TL | |
|---|---|
| Column Name | Descritpion |
| DESCRIPTION | |
| LANGUAGE | |
| SOURCE_LANG | |
| LAST_UPDATE_DATE | |
| XREF_STANDARD_ID | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_LOGIN |
| XML Gateway - ECX_ATTACHMENT_MAPS | The table records correlation mappings between main business documents and their assciated attachments. It is used by the OTA and XML-Gateway engine. |
|---|---|
| Column Name | Descritpion |
| MSGID | This is the message id |
| CID | Content Id through whic user uniquely identifies the attachment |
| FID | File Id of attachment |
| DATATYPE | This type of attachment files |
| ORDERINDEX | This is the order index of attachments |
| NESTPARENTINDEX | This is nest parent index |
No hay comentarios:
Publicar un comentario