Oracle Reporting Suite
From WMS
Oracle Reporting Suite Options
| Report Type | Description | Report Level |
|---|---|---|
| SUBSTITUTE | For warehouse & owner all master stock codes and their substitute products | Header |
| POST_OML | Order Management Layer - Client Specific | Header |
| SUPPLIER | Suppler codes, names and addresses | Header |
| ORDER | Sales order information from header to pallet level | Header Well Detail Pallet |
| PACK | Packing Information from header to detail | Level Detail |
| USERS_AUD | System Users and SQL being used | Header |
| JOURNAL | System Transactions, including serial numbers | Header Serial |
| WMS_AUDIT | Client Specific | Header |
| WARRANT | Despatch Information – Client Specific | Detail |
| ANTIC_OML | Order Management Layer – Client Specific | Header |
| CUSTOMER | Customer codes, names and address details | Header |
| INBOUND | GRN information from advice to putaway and header to pallet | Header Detail |
| INVENTORY | Current stock level information at warehouse & owner level | Warehouse Stock Pallet Serial |
| STOCK | Stock Code parameter information and replenishment locations and levels | Header Location |
| DATE_DISC | Stock with sell by dates, including stock description | Header |
| LOGON_AUD | System Users and system logging | Header |
| MASTER_OML | Order Management Layer – Client Specific | Header Detail |
| CY_CON_DTL Container and Hazardous Information Detail | ||
| CY_MOV_DTL Container Movement and Hazardous Information Detail | ||
| EDI_ERRORS Extract containing file failure for EDI Header | ||
| INVTRY_HAZ | Similar to INVENTORY but including Hazardous information | Warehouse Stock Pallet Hazardous |
| KMOVES_DTL | Client Specific | Detail |
| KMOVES_HDR | Client Specific | Header |
| METAPACK | Pack Message information – Client Specific |
Header |
| PICK_CONT | Pick Container information – Client Specific |
Pick Container |
| OINV_CHGS | Generated charges and Invoices | Charges Invoices |
| OINV_RATES | Defined Charges and Rates | Bands Charges Rates |
| OINV_SETUP | Owner level charges and Invoices setup | Owner |
| STOCK_TAKE | Inventory data required to run a stock take check sheet | Detail |
| SW_MINLEV | Stock Warehouse Minimum stock levels | Header |
| WRSC | Stock Take Information generated via RF – Client Specific (Not released) |
Detail |