Anw: Initial Creation

2025-10-31T15:38:52Z

Initial Creation

New page

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 ===
{| class="wikitable"
!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
[[Category:Technical Guides]]
[[Category:WMS]]
[[Category:Bay Diary]]

Bay Diary - Revision history

Anw: Initial Creation