OE Tables (108)

OE - Order Entry — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
OE_BIS_BBB_INFO 11
OE_BIS_CUST_SAT_T 18
OE_BIS_CUST_SAT_T2 31
OE_BIS_TOP_CUSTOMERS 13
SO_ACTIONS 30 Cycle actions for order cycles
SO_ACTION_CLAUSES 13 Cycle action where clauses
SO_ACTION_PRE_REQS 9 Cycle action prerequisites
SO_ACTION_RESULTS 25 Cycle action results for order cycles
SO_AGREEMENTS_B 39 Customer agreements
SO_AGREEMENTS_TL 9 Translation table for SO_AGREEMENTS_B
SO_ATTRIBUTES 36 Attributes used in security rules and standard value rules sets
SO_ATTRIBUTE_STD_VALUE_SOURCES 24 Sources for standard value rules
SO_ATTRIBUTE_USES 24 Attribute uses asociated with security rules and standard value rule sets
SO_CREDIT_CHECK_RULES_115 33 Table to store Credit Check Rules.
SO_CYCLES 26 Order cycles for processing orders and returns
SO_CYCLE_ACTIONS 13 Order cycle actions
SO_DISCOUNTS 40 Discounts for use in price adjustments
SO_DISCOUNT_CUSTOMERS 32 Discounts for specific customers
SO_DISCOUNT_LINES_115 34 Discounts for order lines
SO_DROP_SHIP_SOURCES 16 Cross-reference table to hold relationships between sales order lines and purchase orders
SO_ENTITIES 29 Entities for pricing, holds, and notes
SO_ENTITY_USES 23 Entity uses
SO_EXCEPTIONS 13 Oracle Order Entry/Shipping concurrent request messages and errors
SO_FREIGHT_CHARGES 50 Freight charges
SO_FREIGHT_CHARGE_TYPES 29 Types of freight charges
SO_GENERAL_STD_VALUE_SOURCES 24 Predefined standard value rule sources
SO_HEADERS_ALL 180 Order header information
SO_HEADERS_INTERFACE_ALL 121 Imported order header information
SO_HEADER_ATTRIBUTES 31 Additional attributes of order headers
SO_HEADER_ATTRIBUTES_INTERFACE 35 Additional attributes of imported order headers
SO_HOLDS 28 Holds
SO_HOLD_AUTHORIZATIONS 27 Hold responsibility information
SO_HOLD_RELEASES 31 Hold release reasons
SO_HOLD_SOURCES_ALL 34 Applied holds
SO_ITEM_GROUPS 24 Price list item groups
SO_ITEM_GROUP_LINES 45 Price list item group lines
SO_LINES_ALL 241 Order lines
SO_LINES_INTERFACE_ALL 198 Imported order line information
SO_LINE_APPROVALS 29 Order line-level approvals
SO_LINE_ATTRIBUTES 47 Additional attributes of order lines
SO_LINE_ATTRIBUTES_INTERFACE 52 Additional attributes of imported order line information
SO_LINE_DETAILS 73 Order line schedule details
SO_LINE_DETAILS_INTERFACE 43 Imported order line schedule details
SO_LINE_DETAIL_ATTRIBUTES 31 Additional attributes of order line schedule details
SO_LINE_DETAIL_ATTRIBUTES_INT 36 Additional attributes of imported order line schedule details
SO_LINE_SERVICE_DETAILS 47 Installation details
SO_NOTES 32 Order and line standard notes
SO_NOTE_ADDITION_RULES 25 Note addition prerequisites
SO_NOTE_REFERENCES 34 Notes attached to orders and order lines
SO_NOTE_REPLICATION 5 Documents and attachments to replicate into Oracle Order Entry/Shipping
SO_NOTE_USAGES 28 Note usages
SO_NOTE_USAGE_ATTRIBUTES 8 Note printing parameters
SO_OBJECTS 29 Objects used in security rules and standard value rule sets
SO_ORDER_APPROVALS 30 Order-level approvals
SO_ORDER_CANCELLATIONS 34 Order and order line cancellations
SO_ORDER_HOLDS_ALL 31 Order and order lines on hold
SO_ORDER_NUMBER_SOURCES 27 Order numbering sources
SO_ORDER_SOURCES_115 11 Feeder system names for use with OrderImport
SO_ORDER_TYPES_115_ALL 58 Order types
SO_PICKING_BATCHES_ALL 61 Released order batches
SO_PICKING_CANCELLATIONS 34 Cancelled picking lines
SO_PICKING_HEADERS_ALL 48 Batch picking headers
SO_PICKING_LINES_ALL 61 Picking lines
SO_PICKING_LINE_DETAILS 86 Picking line details
SO_PICKING_RULES 50 Frequently used picking parameters (pick release rules)
SO_PRICE_ADJUSTMENTS 32 Order and order line price adjustments
SO_PRICE_ADJUSTMENTS_INTERFACE 52 Imported price adjustments
SO_PRICE_BREAK_LINES 35 Discount line price breaks
SO_PRICE_COPY_PARAMETERS 9 Copy item groups parameters
SO_PRICE_LISTS_B 35 Price lists
SO_PRICE_LISTS_TL 10 Translation table for SO_PRICE_LISTS_B
SO_PRICE_LIST_LINES_115 51 Table to store Price List Lines.
SO_PRICING_RULES_B 25 Price list and item group pricing rules
SO_PRICING_RULES_TL 10 Translation table for SO_PRICING_RULES_B
SO_PRICING_RULE_LINES 26 Pricing rule details
SO_PRICING_RULE_LINE_VALUES 29 Pricing rule column values
SO_PURGE_ORDERS 9 Orders identified for purging
SO_REPORTS 25 Oracle Order Entry/Shipping reports
SO_REPORT_PARAMETERS 8 Report parameters
SO_REPORT_PRINTERS 12 Report printer assignments
SO_REPORT_SETS 28 Document sets to be printed from Ship Confirm Delivery and Ship Confirm Departure windows
SO_REPORT_SET_LINES 26 Document set lines
SO_REPORT_SOURCE_PARAMETERS 8 Document set source parameters
SO_REPORT_USAGES 8 Document set usages
SO_RESULTS_B 24 Cycle action results for order cycles
SO_RESULTS_TL 10 Translation table for SO_RESULTS_B
SO_RULE_FORMULA_COMPONENTS 29 Pricing components and associated pricing columns
SO_SALES_CREDITS 28 Order and order line sales credits
SO_SALES_CREDITS_INTERFACE 40 Imported sales credit information
SO_SALES_CREDIT_TYPES_115 26 Sales credit types
SO_SECURITY_RULES 32 Order security rules
SO_SERVICE_DETAILS_INTERFACE 39 Imported installation details for order lines
SO_STANDARD_VALUE_RULES 45 Standard value rules
SO_STANDARD_VALUE_RULE_SETS 25 Standard value rule sets
WSH_CONTAINER_LOAD 29 Container load
WSH_DELIVERIES 76 Shipping deliveries
WSH_DELIVERIES_INTERFACE 109 Interface table containing deliveries
WSH_DELIVERY_TEMPLATES 64 Shipping Delivery Templates
WSH_DEPARTURES 48 Shipping departures
WSH_DEPARTURE_TEMPLATES 37
WSH_FREIGHT_CHARGES_INTERFACE 54 Interface table for freight charges
WSH_INVOICE_NUMBERS 12 Shipping invoice numbers
WSH_PACKED_CONTAINERS 48 Packed containers
WSH_PACKED_CONTAINER_INTERFACE 49 Interface table for packed containers
WSH_PARAMETERS 42 Shipping parameters
WSH_PICK_SLIP_RULES 38 Pick slip rules
WSH_RELEASE_SEQ_RULES 40 Release sequence rules
WSH_REPORT_TEMP 37 Temporary table