Bay Diary

This page is intended to hold technical information regarding Bay Diary for WMS.

Packages

DP_NET_PORTAL - main package

DP_MSG_EMAIL - sending of email from Bay Diary

Tables

Note: The majority of BAY_DIARY_* files are not in use.

CONFIGURATION

Field Config Master

select * from bay_diary_config t

Field Config per User

select * from bay_diary_config_users t

The bays per warehouse

select * from bay_headers t

OPERATIONAL

Table	Notes
ware_diary_details
ware_diary_headers
ware_diary_slots

SQL:

select *
from ware_diary_details t
where company_code = 'POD'
and warehouse_id = 'RCT'
order by delivery_receipt_date desc

select *
from ware_diary_headers t
where company_code = 'JP1'
and warehouse_id = 'NFT'
order by delivery_receipt_date desc

select *
from ware_diary_slots t

Select * from CARRIERS

Select * from STK_STOCKIST