Project progress work #148: Modify the store procedure to support the extended length of pallet - ATA Casting Technology Co., Ltd. - Tomas Tech Project Management

Actions

Copy link

Project progress work #148

closed

Parent project #544: [PJ230032]Traceability system for Delta line

Modify the store procedure to support the extended length of pallet

Added by Kittisak Isarapongporn about 2 years ago. Updated over 1 year ago.

Status:

Closed

Priority:

Normal

Assignee:

Kittisak Isarapongporn

Start date:

25 Oct 2023

Due date:

25 Oct 2023

% Done:

100%

Estimated time:

4.00 h

Finish date:

Programming skills:

DB skills:

OS skills:

Description

Modify the store procedure and change the table schema to support the extended 14-character length of the pallet.
List of modified table and store procedures.
1. tblPackingData and its triggers.
2. tblPackingDataHis and its trigger.
3. getPackingDataOnly
4. getPackingDataOnly_Delta
5. getTraceabilityDataOnly
6. getTraceabilityDataOnly_Delta