Oracle Reporting Suite: Difference between revisions
Lwinchester (talk | contribs) (New page: 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 Manage...) |
Lwinchester (talk | contribs) No edit summary |
||
| Line 2: | Line 2: | ||
Report Type Description Report Level | Report Type Description Report Level | ||
SUBSTITUTE For warehouse & owner all Master stock codes and their substitute products Header | |SUBSTITUTE ||For warehouse & owner all Master stock codes and their substitute products ||Header | ||
POST_OML Order Management Layer - | |- | ||
Client Specific 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 | |SUPPLIER || Suppler codes, names and addresses ||Header | ||
Well | |- | ||
Detail | |ORDER || Sales order information from header to pallet level|| Header <br> Well <br> Detail <br> Pallet | ||
Pallet | |- | ||
|PACK ||Packing Information from header to detail ||Level <br> Detail | |||
PACK Packing Information from header to detail Level | |- | ||
|USERS_AUD ||System Users and SQL being used ||Header | |||
USERS_AUD System Users and SQL being used Header | |- | ||
JOURNAL System Transactions, including serial numbers Header | |JOURNAL|| System Transactions, including serial numbers ||Header <br> Serial | ||
|- | |||
WMS_AUDIT Client Specific Header | |WMS_AUDIT ||Client Specific ||Header | ||
WARRANT Despatch Information – | |- | ||
Client Specific Detail | |WARRANT || Despatch Information – Client Specific ||Detail | ||
ANTIC_OML Order Management Layer – | |- | ||
Client Specific Header | |ANTIC_OML || Order Management Layer – Client Specific ||Header | ||
CUSTOMER Customer codes, names and address details | |- | ||
INBOUND GRN information from advice to putaway and header to pallet Header | |CUSTOMER || Customer codes, names and address details || Header | ||
Detail | |- | ||
|INBOUND|| GRN information from advice to putaway and header to pallet || Header <br> | |||
INVENTORY Current stock level information at warehouse & owner level Warehouse | Detail <br> Pallet | ||
Stock | |- | ||
Pallet | |INVENTORY|| Current stock level information at warehouse & owner level || Warehouse <br> Stock <br> Pallet <br> Serial | ||
|- | |||
STOCK Stock Code parameter information and replenishment locations and levels Header | |STOCK || Stock Code parameter information and replenishment locations and levels ||Header <br> | ||
Location | Location | ||
DATE_DISC Stock with sell by dates, including stock description Header | |- | ||
LOGON_AUD System Users and system logging Header | |DATE_DISC ||Stock with sell by dates, including stock description || Header | ||
MASTER_OML Order Management Layer – | |- | ||
Client Specific Header | |LOGON_AUD || System Users and system logging || Header | ||
|- | |||
|MASTER_OML || Order Management Layer – Client Specific || Header <br> Detail | |||
|- | |||
|} | |||
Revision as of 12:55, 19 September 2011
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
Pallet
|-
|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
|-
|}
