EC Tables (83)
EC - e-Commerce Gateway — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
ECE_ADVO_DETAILS |
30 | Contains the status detail for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice |
ECE_ADVO_DETAILS_INTERFACE |
32 | Contains the detail data to support the outbound Application Advice (824/APERAK) transaction. |
ECE_ADVO_DETAILS_INTERFACE_X |
11 | Extension table for ECE_ADVO_DETAILS_INTERFACE. |
ECE_ADVO_HEADERS |
49 | Contains the status data for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice |
ECE_ADVO_HEADERS_INTERFACE |
76 | Contains the header data to support the outbound Application Advice (824/APERAK) transaction. |
ECE_ADVO_HEADERS_INTERFACE_X |
11 | Extension table for ECE_ADVO_HEADERS_INTERFACE. |
ECE_AP_CHECKS_INTERFACE |
222 | Contains the payment data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction. |
ECE_AP_CHECKS_INTERFACE_X |
10 | Extension table for ECE_AP_CHECKS_INTERFACE. |
ECE_AP_INVOICES_INTERFACE |
60 | Contains the invoice data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction. |
ECE_AP_INVOICES_INTERFACE_X |
9 | Extension table for ECE_AP_INVOICES_INTERFACE. |
ECE_AR_TRX_ALLOWANCE_CHARGES |
59 | Contains the customer invoice allowance charges information to support the outbound Invoice (810/INVOIC) transaction. |
ECE_AR_TRX_ALLOWANCE_CHARGES_X |
10 | Extension table for ECE_AR_TRX_ALLOWANCE_CHARGES. |
ECE_AR_TRX_HEADERS |
274 | Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction. |
ECE_AR_TRX_HEADERS_X |
10 | Extension table for ECE_AR_TRX_HEADERS. |
ECE_AR_TRX_HEADER_1 |
59 | 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 |
9 | Extension table for ECE_AR_TRX_HEADER_1. |
ECE_AR_TRX_LINES |
245 | Contains the customer invoice line data to support the outbound Invoice (810/INVOIC) transaction. |
ECE_AR_TRX_LINES_X |
9 | Extension table for ECE_AR_TRX_LINES. |
ECE_AR_TRX_LINE_TAX |
81 | Contains the customer invoice line tax data to support the outbound Invoice (810/INVOIC) transaction. |
ECE_AR_TRX_LINE_TAX_X |
10 | Extension table for ECE_AR_TRX_LINE_TAX. |
ECE_ATTACHMENT_DETAILS |
23 | Contains the temporary detail data for extracting attachments. |
ECE_ATTACHMENT_DETAILS_X |
10 | Extension table for ECE_ATTACHMENT_DETAILS. |
ECE_ATTACHMENT_HEADERS |
41 | Contains the temporary header data for extracting attachments. |
ECE_ATTACHMENT_HEADERS_X |
10 | Extension table for ECE_ATTACHMENT_HEADERS. |
ECE_COLUMN_RULES |
14 | Contains the column rule assignments. |
ECE_COLUMN_RULES_UPG |
14 | |
ECE_ERROR |
12 | Contains the Oracle EDI Gateway processing error messages used by Development for debugging purposes. |
ECE_EXTERNAL_LEVELS |
13 | Contains the information about the external levels for a given transaction and map. |
ECE_EXTERNAL_LEVELS_UPG |
13 | |
ECE_INTERFACE_COLS_UPG |
36 | Contains the interface file definitions for each EDI transaction. |
ECE_INTERFACE_COLUMNS |
36 | Contains the interface file definitions for each EDI transaction. |
ECE_INTERFACE_TABLES |
24 | Contains the information regarding the interface and extension tables used to support each EDI transaction. |
ECE_INTERFACE_TBLS_UPG |
24 | Contains the information regarding the interface and extension tables used to support each EDI transaction. |
ECE_LEVEL_MATRICES |
3 | Intersection table for ECE_INTERFACE_TABLE and ECE_EXTERNAL_LEVELS. |
ECE_LEVEL_MATRICES_UPG |
3 | |
ECE_MAPPINGS |
7 | Contains the information about maps for a given transaction. |
ECE_MAPPINGS_UPG |
7 | Upgrade table for ECE_MAPPINGS |
ECE_MVSTO_DETAILS |
303 | Contains the detail level information for the outbound Movement Statistics transaction. |
ECE_MVSTO_DETAILS_X |
2 | Extension table for ECE_MVSTO_DETAILS. |
ECE_MVSTO_HEADERS |
106 | Contains the movement statistics header data to support the outbound Movement Statistics transaction. |
ECE_MVSTO_HEADERS_X |
2 | Extension table for ECE_MVSTO_HEADERS. |
ECE_MVSTO_LOCATIONS |
55 | Contains the location information for outbound Movement Statistics transaction. |
ECE_MVSTO_LOCATIONS_X |
2 | Extension table for ECE_MVSTO_LOCATIONS. |
ECE_OUTPUT |
12 | Contains the contents of the interface file to be created by the e-Commerce Gateway extract program. |
ECE_PO_DISTRIBUTIONS |
97 | Contains temporary project data and PO distributions to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDC |
ECE_PO_DISTRIBUTIONS_X |
10 | Extension table for ECE_PO_DISTRIBUTIONS. |
ECE_PO_INTERFACE_HEADERS |
313 | Contains the purchase order header data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transacti |
ECE_PO_INTERFACE_HEADERS_X |
10 | Extension table for ECE_PO_INTERFACE_HEADERS. |
ECE_PO_INTERFACE_LINES |
125 | Contains the purchase order line data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transaction |
ECE_PO_INTERFACE_LINES_X |
10 | Extension table for ECE_PO_INTERFACE_LINES. |
ECE_PO_INTERFACE_SHIPMENTS |
180 | Contains the purchase order shipment data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transac |
ECE_PO_INTERFACE_SHIPMENTS_X |
10 | Extension table for ECE_PO_INTERFACE_SHIPMENTS. |
ECE_PO_PROJECT_INFO |
46 | Contains temporary project data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions. |
ECE_PO_PROJECT_INFO_X |
10 | Extension table for ECE_PO_PROJECT_INFO. |
ECE_PROCEDURE_MAPPINGS |
6 | Contains the information for calling procedures. |
ECE_PROCESS_RULES |
14 | Contains the process rule assignements. |
ECE_PROCESS_RULES_UPG |
14 | Upgrade table for ECE_PROCESS_RULES |
ECE_PROC_MAPPINGS_UPG |
6 | Upgrade table for ECE_PROCEDURE_MAPPINGS |
ECE_RULE_LIST |
12 | Contains the column list rule information. |
ECE_RULE_LIST_DETAILS |
12 | Contains the column rule list detail information. |
ECE_RULE_NULL_DEFAULT |
13 | Contains the column rule null default information. |
ECE_RULE_NULL_DEP |
12 | Contains the column rule null dependency information. |
ECE_RULE_NULL_DEP_DETAILS |
14 | Child table to ECE_RULE_NULL_DEP. |
ECE_RULE_SIMPLE_LOOKUP |
14 | Contains the column rule simple lookup information. |
ECE_RULE_VALUESET |
12 | Contains the column rule valueset information. |
ECE_RULE_VIOLATIONS |
19 | Contains the information about rule violations. |
ECE_SPSO_HEADERS |
179 | Contains the supplier schedule header data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transac |
ECE_SPSO_HEADERS_X |
10 | Extension table for ECE_SPSO_HEADERS. |
ECE_SPSO_ITEMS |
145 | Contains the supplier schedule line data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transacti |
ECE_SPSO_ITEMS_X |
10 | Extension table for ECE_SPSO_ITEMS. |
ECE_SPSO_ITEM_DET |
26 | Contains the supplier schedule item detail data to support outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transa |
ECE_SPSO_ITEM_DET_X |
10 | Extension table for ECE_SPSO_ITEM_DET. |
ECE_SPSO_SHIP_DET |
43 | ECE_SPSO_SHIP_DET |
ECE_SPSO_SHIP_DET_X |
10 | ECE_SPSO_SHIP_DET |
ECE_STAGE |
519 | Inbound staging table. |
ECE_TP_DETAILS |
26 | Contains the information for the trading partner processing rules. |
ECE_TP_GROUP |
12 | Contains the information for a trading partner group representing a collection of trading partner definitions. |
ECE_TP_HEADERS |
46 | Contains the information for trading partner address entity. |
ECE_TRAN_PARAMETERS |
7 | Generic inbound/outbound execution engine seed data for the parameters corresponding to a transaction. |
ECE_TRAN_STAGE_DATA |
19 | Contains the seed data for the dynamic execution of the inbound/outbound transactions. |
ECE_TRAN_STAGE_DATA_UPG |
19 | |
ECE_XREF_CATEGORIES |
29 | Contains the code conversion categories information. Rows contain category code, description, and up to five processing flags. |
ECE_XREF_DATA |
25 | Contains the information for code conversions which identify external values for a given Oracle internal value and vice versa. |