Manufacturing
Bill Of Material & Routing
Tables
- BOM_BILL_OF_MATERIALS (BOM)
- BOM_INVENTORY_COMPONENTS (BOM)
- BOM_OPERATIONAL_ROUTINGS (Routing)
- BOM_OPERATION_RESOURCES (Routing)
Interface Tables
- BOM_BILL_OF_MTLS_INTERFACE
- BOM_INVENTORY_COMPS_INTERFACE
Cost Management
Tables
- CST_PAC_ITEM_COSTS
- CST_PAC_ITEM_COST_DETAILS
- CST_PAC_QUANTITY_LAYERS
Interface Tables
- CST_PC_ITEM_COST_INTERFACE
- CST_PC_COST_DET_INTERFACE
Inventory
Tables
- MTL_MATERIAL_TRANSACTIONS
- MTL_SYSTEM_ITEMS
- MTL_ITEM_CATEGORIES
Interface Tables
- MTL_TRANSACTIONS_INTERFACE (Inventory/Transactoin)
- MTL_TRANSACTION_LOTS_INTERFACE
- MTL_SERIAL_NUMBERS_INTERFACE
- MTL_SYSTEMS_ITEM_ITERFACE (Items)
- MTL_ITEM_CATEGORIES_INTERFACE (Item categories)
- MTL_INTERFACE_ERRORS
Purchase Order
Tables
- PO_REQUISITIONS_HEADERS_ALL (Requisition)
- PO_REQUISITIONS_LINES_ALL (Requisition)
- PO_HEADERS_ALL (Purchasing documents open interface)
- PO_LINES_ALL (Purchasing documents open interface)
- PO_LINE_LOCATIONS_ALL (Purchasing documents open interface)
- PO_DISTRIBUTIOS_ALL (Purchasing documents open interface)
- PO_DISTRIBUTIONS_AP_V (View of PO_DISTRIBUTIONS_ALL)
- PO_RELEASES (Blanket Purchase Orders)
- PO_LOOKUP_CODES
- RCV_TRANSACTIONS (Receipts Interface)
- RCV_LOTS_SUPPLY (Receipts Interface)
- RCV_SERIALS_SUPPLY (Receipts Interface)
- RCV_SERIAL_TRANSACTIONS (Receipts Interface)
- RCV_SHIPMENT_HEADERS (Receipts Interface)
- RCV_SHIPMENT_LINES (Receipts Interface)
Interface Tables
- PO_REQUISTIONS_INTERFACE_ALL
- PO_HEADERS_INTERFACE (Purchasing documents open interface)
- PO_LINES_INTERFACE (Purchasing documents open interface)
- PO_DISTRIBUTIONS_INTERFACE (Purchasing documents open interface)
- RCV_HEADERS_INTERFACE (Receipts Interface)
- RCV_TRASACTION_INTERFACE (Receipts Interface)
- RCV_LOTS_INTERFACE (Receipts Interface)
- RCV_SERIALS_INTERFACE (Receipts Interface)
- PO_INTERFACE_ERRORS
Only API for PO vendors
Order Management
Tables
- OE_ORDER_HEADERS_ALL
- OE_ORDER_LINES_ALL
Interface Tables
- OE_HEADERS_IFACE_ALL
- OE_LINES_IFACE_ALL
Accounts Payable
Tables
- AP_INVOICES_ALL
- AP_INVOICE_DISTRIBUTIONS_ALL (If matched to purchase order)
Interface Tables
- AP_INVOICES_INTERFACE
- AP_INVLOICE_LINES_INTERFACE
- AP_INTERFACE_CONTROLS
- AP_INTERFACE_REJECTIONS
Accounts Receivable
Tables
- RA_CUSTOMER_TRX_ALL
- RA_CUSTOMER_TRX_LINES_ALL
- RA_CUST_TRX_LINES_GL_DIST
Interface Tables
- RA_CUSTOMERS_INTERFACE(Customer interface)
- RA_CUSTOMER_PROFILES_INTERFACE (Customer Interface)
- RA_INTERFACE_LINES_ALL (Invoice interface)
- RA_INTERFACE_DISTRIBUTIONS_ALL (Invoice inteface)
- RA_INTERFACE_SALESCREDITS_ALL (Invoice interface)
- AR_PAYMENTS_INTERFACE_ALL (Receipts Interface)
- RA_INTERFACE_ERRORS_ALL
General Ledger
Tables
- GL_JE_HEADERS
- GL_JE_LINES
- GL_JE_BATCHES
Interface Tables
- GL_INTERFACE
