Oracle Reporting Suite

From WMS
Revision as of 12:55, 19 September 2011 by Lwinchester (talk | contribs)

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 |- |}