Oracle Reporting Suite: Difference between revisions
From WMS
Lwinchester (talk | contribs) No edit summary |
Lwinchester (talk | contribs) No edit summary |
||
| Line 41: | Line 41: | ||
|MASTER_OML || Order Management Layer – Client Specific || Header <br> Detail | |MASTER_OML || Order Management Layer – Client Specific || Header <br> Detail | ||
|- | |- | ||
|CY_CON_DTL Container and Hazardous Information Detail | |CY_CON_DTL || Container and Hazardous Information ||Detail | ||
|- | |- | ||
|CY_MOV_DTL Container Movement and Hazardous Information | |CY_MOV_DTL|| Container Movement and Hazardous Information || Detail | ||
|- | |- | ||
|EDI_ERRORS Extract containing file failure for EDI Header | |EDI_ERRORS|| Extract containing file failure for EDI ||Header | ||
|- | |- | ||
|INVTRY_HAZ|| Similar to INVENTORY but including Hazardous information|| Warehouse <br> Stock <br>Pallet <br> | |INVTRY_HAZ|| Similar to INVENTORY but including Hazardous information|| Warehouse <br> Stock <br>Pallet <br> | ||
Revision as of 14:57, 17 April 2013
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 |
