Oracle e-Commerce Gateway Tables

TABLE NAME	DESCRIPTION
ECE_ADVO_DETAILS	Contains the status detail for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice (857).
ECE_ADVO_DETAILS_INTERFACE	Contains the detail data to support the outbound Application Advice (824/APERAK) transaction.
ECE_ADVO_DETAILS_INTERFACE_X	Extension table for ECE_ADVO_DETAILS_INTERFACE.
ECE_ADVO_HEADERS	Contains the status data for inbound transactions:  Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice (857).
ECE_ADVO_HEADERS_INTERFACE	Contains the header data to support the outbound Application Advice (824/APERAK) transaction.
ECE_ADVO_HEADERS_INTERFACE_X	Extension table for ECE_ADVO_HEADERS_INTERFACE.
ECE_AP_CHECKS_INTERFACE	Contains the payment data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction.
ECE_AP_CHECKS_INTERFACE_X	Extension table for ECE_AP_CHECKS_INTERFACE.
ECE_AP_INVOICES_INTERFACE	Contains the invoice data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction.
ECE_AP_INVOICES_INTERFACE_X	Extension table for ECE_AP_INVOICES_INTERFACE.
ECE_AR_TRX_ALLOWANCE_CHARGES	Contains the customer invoice allowance charges information to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_ALLOWANCE_CHARGES_X	Extension table for ECE_AR_TRX_ALLOWANCE_CHARGES.
ECE_AR_TRX_HEADER_1	Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction.  Continuation of ECE_AR_TRX_HEADERS.
ECE_AR_TRX_HEADER_1_X	Extension table for ECE_AR_TRX_HEADER_1.
ECE_AR_TRX_HEADERS	Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_HEADERS_X	Extension table for ECE_AR_TRX_HEADERS.
ECE_AR_TRX_LINE_TAX	Contains the customer invoice line tax data to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_LINE_TAX_X	Extension table for ECE_AR_TRX_LINE_TAX.
ECE_AR_TRX_LINES	Contains the customer invoice line data to support the outbound Invoice (810/INVOIC) transaction.
ECE_AR_TRX_LINES_X	Extension table for ECE_AR_TRX_LINES.
ECE_ATTACHMENT_DETAILS	Contains the temporary detail data for extracting attachments.
ECE_ATTACHMENT_DETAILS_X	Extension table for ECE_ATTACHMENT_DETAILS.
ECE_ATTACHMENT_HEADERS	Contains the temporary header data for extracting attachments.
ECE_ATTACHMENT_HEADERS_X	Extension table for ECE_ATTACHMENT_HEADERS.
ECE_COLUMN_RULES	Contains the column rule assignments.
ECE_ERROR	Contains the Oracle EDI Gateway processing error messages used by Development for debugging purposes.
ECE_EXTERNAL_LEVELS	Contains the information about the external levels for a given transaction and map.
ECE_EXTERNAL_LEVELS_UPG
ECE_INTERFACE_COLS_UPG	Contains the interface file definitions for each EDI transaction.
ECE_INTERFACE_COLUMNS	Contains the interface file definitions for each EDI transaction.
ECE_INTERFACE_TABLES	Contains the information regarding the interface and extension tables used to support each EDI transaction.
ECE_INTERFACE_TBLS_UPG	Contains the information regarding the interface and extension tables used to support each EDI transaction.
ECE_LEVEL_MATRICES	Intersection table for ECE_INTERFACE_TABLE and ECE_EXTERNAL_LEVELS.
ECE_LEVEL_MATRICES_UPG
ECE_MAPPINGS	Contains the information about maps for a given transaction.
ECE_MAPPINGS_UPG	Upgrade table for ECE_MAPPINGS
ECE_MVSTO_DETAILS	Contains the detail level information for the outbound Movement Statistics transaction.
ECE_MVSTO_DETAILS_X	Extension table for ECE_MVSTO_DETAILS.
ECE_MVSTO_HEADERS	Contains the movement statistics header data to support the outbound Movement Statistics transaction.
ECE_MVSTO_HEADERS_X	Extension table for ECE_MVSTO_HEADERS.
ECE_MVSTO_LOCATIONS	Contains the location information for outbound Movement Statistics transaction.
ECE_MVSTO_LOCATIONS_X	Extension table for ECE_MVSTO_LOCATIONS.
ECE_OUTPUT	Contains the contents of the interface file to be created by the e-Commerce Gateway extract program.
ECE_PO_DISTRIBUTIONS	Contains temporary project data and PO distributions to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_DISTRIBUTIONS_X	Extension table for ECE_PO_DISTRIBUTIONS.
ECE_PO_INTERFACE_HEADERS	Contains the purchase order header data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_INTERFACE_HEADERS_X	Extension table for ECE_PO_INTERFACE_HEADERS.
ECE_PO_INTERFACE_LINES	Contains the purchase order line data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_INTERFACE_LINES_X	Extension table for ECE_PO_INTERFACE_LINES.
ECE_PO_INTERFACE_SHIPMENTS	Contains the purchase order shipment data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_INTERFACE_SHIPMENTS_X	Extension table for ECE_PO_INTERFACE_SHIPMENTS.
ECE_PO_PROJECT_INFO	Contains temporary project data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
ECE_PO_PROJECT_INFO_X	Extension table for ECE_PO_PROJECT_INFO.
ECE_PROC_MAPPINGS_UPG	Upgrade table for ECE_PROCEDURE_MAPPINGS
ECE_PROCEDURE_MAPPINGS	Contains the information for calling procedures.
ECE_PROCESS_RULES	Contains the process rule assignements.
ECE_PROCESS_RULES_UPG	Upgrade table for ECE_PROCESS_RULES
ECE_RULE_LIST	Contains the column list rule information.
ECE_RULE_LIST_DETAILS	Contains the column rule list detail information.
ECE_RULE_NULL_DEFAULT	Contains the column rule null default information.
ECE_RULE_NULL_DEP	Contains the column rule null dependency information.
ECE_RULE_NULL_DEP_DETAILS	Child table to ECE_RULE_NULL_DEP.
ECE_RULE_SIMPLE_LOOKUP	Contains the column rule simple lookup information.
ECE_RULE_VALUESET	Contains the column rule valueset information.
ECE_RULE_VIOLATIONS	Contains the information about rule violations.
ECE_SPSO_HEADERS	Contains the supplier schedule header data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
ECE_SPSO_HEADERS_X	Extension table for ECE_SPSO_HEADERS.
ECE_SPSO_ITEM_DET	Contains the supplier schedule item detail data to support outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
ECE_SPSO_ITEM_DET_X	Extension table for ECE_SPSO_ITEM_DET.
ECE_SPSO_ITEMS	Contains the supplier schedule line data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
ECE_SPSO_ITEMS_X	Extension table for ECE_SPSO_ITEMS.
ECE_SPSO_SHIP_DET	ECE_SPSO_SHIP_DET
ECE_SPSO_SHIP_DET_X	ECE_SPSO_SHIP_DET
ECE_STAGE	Inbound staging table.
ECE_TP_DETAILS	Contains the information for the trading partner processing rules.
ECE_TP_GROUP	Contains the information for a trading partner group representing a collection of trading partner definitions.
ECE_TP_HEADERS	Contains the information for trading partner address entity.
ECE_TRAN_PARAMETERS	Generic inbound/outbound execution engine seed data for the parameters corresponding to a transaction.
ECE_TRAN_STAGE_DATA	Contains the seed data for the dynamic execution of the inbound/outbound transactions.
ECE_TRAN_STAGE_DATA_UPG
ECE_XREF_CATEGORIES	Contains the code conversion categories information.  Rows contain category code, description, and up to five processing flags.
ECE_XREF_DATA	Contains the information for code conversions which identify external values for a given Oracle internal value and vice versa.