GML Tables (163)
GML - Process Manufacturing Logistics — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
CPG_COST_DTL |
12 | OPM acquisition costs entered against Oracle Purchasing PO |
CPG_ORAGEMS_ARCH |
18 | Archive table for mapping between Oracle Purchase Order and Purchase Order created in OPM |
CPG_ORAGEMS_MAPPING |
19 | Maps a standard or planned purchase order entered in Oracle Purchasing with the PO or BPO created in OPM |
CPG_PURCHASING_ARCH |
96 | Archive table for OPM Common Purchasing interface. |
CPG_PURCHASING_INTERFACE |
96 | Interface table used by OPM Common Purchasing. |
GML_BATCH_SO_ALLOC_HISTORY |
29 | OM batch reservations history table |
GML_BATCH_SO_RESERVATIONS |
29 | OM batch reservations |
GML_BATCH_SO_RULES |
29 | OM Batch reservations rules |
GML_BATCH_SO_RULE_ASSIGNMENTS |
16 | OM Batch Reservation Rule Assignments |
GML_BATCH_SO_WORKFLOW |
14 | OM Batch reservation workflow |
GML_BATCH_TMP |
20 | Temporary Table for Batch Reservations |
GML_GASNO_DETAILS |
202 | Contains detail line data of the order that the shipment generated from. |
GML_GASNO_DETAILS_X |
10 | Extension table of GML_GASNO_DETAILS. |
GML_GASNO_DETAIL_ALLOCATIONS |
40 | Contains information about lot, location and pending transaction for an order line of an order that the shipment generated from for GASNO t |
GML_GASNO_DETAIL_ALLOCATIONS_X |
10 | Extension table of GML_GASNO_DETAIL_ALLOCATIONS. |
GML_GASNO_DETAIL_CHARGES |
36 | Contains key charge data for a line that the shipment generated from for the GASNO transaction. |
GML_GASNO_DETAIL_CHARGES_X |
10 | Extension table of GML_GASNO_DETAIL_CHARGES. |
GML_GASNO_DETAIL_TEXT |
28 | Contains text data for a line that the shipment generated from for the GASNO transaction. |
GML_GASNO_DETAIL_TEXT_X |
10 | Extension table of GML_GASNO_DETAIL_TEXT. |
GML_GASNO_ORDERS |
50 | Contains key order data that the shipment generated from for the GASNO transaction. |
GML_GASNO_ORDERS_X |
10 | Extension table of GML_GASNO_ORDERS. |
GML_GASNO_ORDER_CHARGES |
36 | Contains key charge data for an order that the shipment generated from for the GASNO transaction. |
GML_GASNO_ORDER_CHARGES_X |
10 | Extension table of GML_GASNO_ORDER_CHARGES. |
GML_GASNO_ORDER_TEXT |
27 | Contains text data for a line that the shipment generated from for the GASNO transaction. |
GML_GASNO_ORDER_TEXT_X |
10 | Extension table of GML_GASNO_ORDER_TEXT. |
GML_GASNO_SHIPMENTS |
213 | Contains shipping and associated trading partner data for the GASNO transaction. |
GML_GASNO_SHIPMENTS_X |
10 | Extension table of GML_GASNO_SHIPMENTS. |
GML_GASNO_SHIPMENT_TEXT |
27 | Contains text data for a line that the shipment generated from for the GASNO transaction. |
GML_GASNO_SHIPMENT_TEXT_X |
10 | Extension table of GML_GASNO_SHIPMENT_TEXT. |
GML_GPOAO_DETAILS |
201 | Contains order line detail data to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP). |
GML_GPOAO_DETAILS_X |
10 | Extension table for GML_GPOAO_DETAILS |
GML_GPOAO_DETAIL_ALLOCATIONS |
40 | Contains order line detail allocation data to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/O |
GML_GPOAO_DETAIL_ALLOCATIONS_X |
10 | Extension table for GML_GPOAO_DETAIL_ALLOCATIONS. |
GML_GPOAO_DETAIL_CHARGES |
36 | Contains order line detail charges to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP). |
GML_GPOAO_DETAIL_CHARGES_X |
10 | Extension table for GML_GPOAO_DETAIL_CHARGES. |
GML_GPOAO_DETAIL_TEXT |
28 | Contains order line detail text to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP). |
GML_GPOAO_DETAIL_TEXT_X |
10 | Extension table for GML_GPOAO_DETAIL_TEXT. |
GML_GPOAO_ORDERS |
258 | Contains order data to support the edi outbound transaction GPOAO. |
GML_GPOAO_ORDERS_X |
10 | Extension table for GML_GPOAO_ORDERS. |
GML_GPOAO_ORDER_CHARGES |
36 | Contains charge data to support the OPM Outbound Purchase Order Acknowledgment (855/ORDRSP) EDI transaction. |
GML_GPOAO_ORDER_CHARGES_X |
10 | Extension table for GML_GPOAO_ORDER_CHARGES. |
GML_GPOAO_ORDER_TEXT |
27 | Contains text data to support the OPM Outbound Purchase Order Acknowledgment (855/ORDRSP) EDI transaction. |
GML_GPOAO_ORDER_TEXT_X |
10 | Extension table for GML_GPOAO_ORDER_TEXT. |
GML_INVALID_CUSTOMERS |
5 | Table contains customer records that failed to synch from Oracle Receivables to OPM. |
GML_PO_MIG_ERRORS |
18 | Migration errors reporting table from Common Purchasing to Common Receiving |
GML_RCV_LOTS_MIGRATION |
9 | Table to maintain log of migrated records in receiving lots |
GML_RECV_ADJUST_ERRORS |
15 | OPM receipt adjustment errors |
GML_RECV_TRANS_MAP |
11 | Mapping of receipts in OPM and Oracle Receiving. |
OP_ALOT_PRM |
25 | Allocation parameters by customer and item class. |
OP_AUDT_DTL |
56 | Sales Order Audit Trail by order line |
OP_AUDT_MST |
11 | Header record which links all change records for a sales orderdetail line. |
OP_BILL_LAD |
63 | Header information for a shipment. |
OP_CGLD_CLS |
10 | Customer GL account classes |
OP_CHRG_BRK |
14 | Charge breaks. |
OP_CHRG_CLS |
10 | Ancillary charge tax classes |
OP_CHRG_ITM |
46 | Charges for items or item classes and customers. |
OP_CHRG_MST |
55 | Charge master. |
OP_CNTR_BRK |
14 | Price breaks for contracts. |
OP_CNTR_DTL |
52 | Item prices on a contract. |
OP_CNTR_HDR |
51 | Contract header. |
OP_CNTR_HDR_EFC |
4 | Shadow table of OP_CNTR_HDR for EFC migration. |
OP_COMMISSION |
6 | Commission code header. |
OP_COMM_CDS |
13 | Commission code detail. |
OP_CPRC_CLS |
10 | Customer Price Classes. |
OP_CTRD_CLS |
10 | Customer Trade Classes. |
OP_CUST_ASC |
17 | Customer relationships |
OP_CUST_CLS |
10 | General customer classes. |
OP_CUST_CON |
54 | Customer contact information. |
OP_CUST_CON_INT |
58 | Interface table used to move customer contact information from Oracle Receivables into OPM. |
OP_CUST_ITM |
52 | Customer item information. |
OP_CUST_MST_INT |
110 | Customer Interface table for data transferred from Oracle Receivables into the OPM customer master. |
OP_CUST_MST_OPM |
95 | Customer master. |
OP_CUST_SHP |
23 | Preferred shippers (carriers) and ship methods for customers. |
OP_FOBC_MST |
16 | Free on Board (FOB) codes. |
OP_FOBC_MST_INT |
13 | This table is not used in 11i. |
OP_FRGT_MTH |
11 | Freight bill method codes . |
OP_GNRC_ITM |
17 | Customer and generic (alternate) names for items. |
OP_HOLD_CDS |
15 | Sales order hold reason codes. |
OP_INVC_CHG |
24 | Tax details for an order line. |
OP_LKBX_MST |
43 | Lockbox codes. |
OP_ORDR_CHG |
21 | Order and order line charges. |
OP_ORDR_DAC_INTERFACE |
17 | Order Entry Open Interface Detail Charges table. |
OP_ORDR_DTL |
145 | Order detail (order lines). |
OP_ORDR_DTL_EFC |
4 | Shadow table of OP_ORDR_DTL for EFC migration. |
OP_ORDR_DTL_INTERFACE |
91 | Order Entry Open Interface Detail table. |
OP_ORDR_DTX_INTERFACE |
13 | Order Entry Open Interface Detail Text table. |
OP_ORDR_HAC_INTERFACE |
17 | Order Entry Open Interface Header Charges table. |
OP_ORDR_HDR |
90 | Sales Order Header table. |
OP_ORDR_HDR_INTERFACE |
119 | Order Header open interface table. |
OP_ORDR_HTX_INTERFACE |
13 | Order Entry Open Interface Header Text table. |
OP_ORDR_STS_B |
11 | Order status codes and descriptions. |
OP_ORDR_STS_TL |
10 | Translations for Order Status Codes and Descriptions. |
OP_ORDR_TYPE_MIGRATION |
4 | Mapping table for GML and OM order types. |
OP_ORDR_TYP_B |
26 | User-defined order types and descriptions. |
OP_ORDR_TYP_TL |
10 | Translations for OrderType Codes and Descriptions. |
OP_PKGD_ITM |
27 | Packaged item names and shipping weights. |
OP_PORT_MST |
12 | Shipping/receiving port codes. |
OP_PRCE_BRK |
14 | Price breaks for items on a pricelist. |
OP_PRCE_CDS |
12 | Order Entry Price Reason Codes. |
OP_PRCE_EFF |
24 | Pricing effectivities to establish active price lists, contracts or charges. |
OP_PRCE_ITM |
52 | Item prices on a pricelist. |
OP_PRCE_MST |
45 | Price list header. |
OP_PRSL_AUD |
27 | This table is not used in 11i. |
OP_PRSL_CHG |
18 | Charges for an entire order profile and/or order profile lines. |
OP_PRSL_DTL |
112 | Order profile lines and blanket sales order lines. |
OP_PRSL_DTL_EFC |
3 | Shadow table of OP_PRSL_DTL for EFC migration. |
OP_PRSL_HDR |
95 | Order Profile Header and Blanket Sales Order Header. |
OP_PRSL_HDR_EFC |
3 | Shadow table of OP_PRSL_HDRL for EFC migration. |
OP_PRSL_MOD |
10 | This table is not used in 11i. |
OP_PRSL_TYP_B |
13 | This table is not used in 11i. |
OP_PRSL_TYP_TL |
10 | This table is not used in 11i. |
OP_RELS_SCH |
26 | Blanket Sales Order Release Schedules. |
OP_SHIP_MST |
12 | Carrier (shipper) codes . |
OP_SHIP_MTH |
13 | Shipping method codes. |
OP_SLSR_CLS |
10 | Sales representative classes. |
OP_SLSR_MST |
24 | Sales representative master table. |
OP_SLSR_MST_INT |
22 | Sales representative interface table used to transfer data from Oracle Receivables. |
OP_TERM_MST |
19 | Payment terms codes. |
OP_TERM_MST_INT |
15 | This table is not used in 11i. |
OP_TEXT_HDR |
6 | Header text table for the Order Fulfillment application. |
OP_TEXT_TBL_TL |
13 | Text for the Order Fulfillment Application. |
OP_TRAN_TMP |
20 | Table used by automatic inventory allocation in Shipping. |
OP_TXCU_ASC |
17 | Customer tax exemption information. |
OP_UPDT_BAL_WK |
9 | Table used by the " Update Customer Balance Report". |
PO_BPOS_DTL |
75 | Blanket purchase order lines. |
PO_BPOS_HDR |
74 | Header information for blanket purchase orders. |
PO_BPOS_HDR_EFC |
3 | Shadow table of PO_BPOS_HDR for EFC migration. |
PO_COST_DTL |
21 | Acquistion cost details for a purchase order or a stock receipt. |
PO_COST_MST |
16 | Acquisition costs master table. |
PO_DIST_DTL |
32 | General Ledger (GL) distribution for purchase orders and stock receipt transactions. |
PO_DIST_DTL_EFC |
8 | Shadow table of PO_DIST_DTL for EFC migration. |
PO_ORDR_DTL |
83 | Purchase order lines. |
PO_ORDR_HDR |
80 | Purchase order header. |
PO_ORDR_HDR_EFC |
3 | Shadow table of PO_ORDR_HDR for EFC migration. |
PO_RECV_DTL |
69 | Receipt lines. |
PO_RECV_HDR |
73 | Receipt header. |
PO_RECV_HDR_EFC |
3 | Shadow table of PO_RECV_HDR for EFC migration. |
PO_RECV_HST |
26 | Audit trail of quantity and price changes made to a receipt or return line. |
PO_RECV_HST_EFC |
5 | Shadow table of PO_RECV_HST for EFC migration. |
PO_RELS_SCH |
54 | Release schedules for a blanket purchase order. |
PO_RTRN_DTL |
53 | Return lines. |
PO_RTRN_HDR |
46 | Return header. |
PO_TEXT_HDR |
6 | Header text table for OPM Purchasing application. |
PO_TEXT_TBL_TL |
13 | Text for the OPM Purchasing application. |
PO_VEND_ASC |
15 | Vendor associations/relationships. |
PO_VEND_CLS |
10 | Vendor classes. |
PO_VEND_MST |
82 | Vendor master. |
PO_VEND_MST_INT |
91 | This table is not used in 11i. |
PO_VGLD_CLS |
10 | Vendor GL (General Ledger) classes. |
PO_VNIT_MST |
19 | Vendor Item Table not supported in OPM Purchasing. |
PO_VTRD_CLS |
10 | Vendor trade class. |
TX_CALC_MST |
19 | Tax calculation codes. |
TX_HIST_TAX |
16 | This table is not used in 11i. |
TX_TAXA_DTL |
20 | Tax rates by item and/or charge class for a tax authority. |
TX_TAXA_MST |
45 | Tax Authorities. |
TX_TAXA_STS |
13 | Tax status codes. |
TX_TEXT_HDR |
6 | Header table for text for the Tax application in OPM. |
TX_TEXT_TBL_TL |
13 | Text for the Tax Application. |
TX_TLOC_ASC |
11 | Tax Authorities that apply for a pair of tax locations. |
TX_TLOC_CDS |
10 | Tax Location Codes. |
TX_TOFR_ASC |
11 | Pairing of Tax Locations as Ship-From and Ship-To Locations. |
TX_TXRE_CDS |
10 | Tax Exemption Reason Codes. |
TX_TXRP_CLS |
10 | Tax reporting classes. |