Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-233757 - Grain units should be 4 decimals across all grain screens (updated title)|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-233757]
Editing the schema of quantity columns in Contract module tables to use 20 decimal places, like quantities for other modules. Also, any stored procedures which use these quantities will have to be examined to ensure they will work with this change
This is to ensure that on the database level there will be consistency across modules when storing quantities.
While analyzing the decimal precision issue it was noticed that the database decimals for quantities differ between the modules (table below)
| *Module*
| *Quantity field*
| *I21 decimals (UI)*
| *Db data type (db decimals)*
|
|Contracts
(tblCTContractDetail)
|Contracted Quantity
|2
|6
6
|
| |Net Weight
| |6
|
| |Balance
|6
|6
|
| |Applied
|6
|6
|
| |Available
|6
|6
|
| |Scheduled
|4
|6
|
| | | | |
|Scale
| | | |
|(tblSCTicket)
|Gross weight
|4
|3
|
| |Gross units
|4
|20
|
| |Net units
|4
|20
|
| | | | |
|IR / IS
(tblICInventoryReceiptItem
tblICInventoryShipmentItem)
|Gross weight
Net weight
|2
|20
20
|
| | | | |
|AP/AR
(tblAPBillDetail
tblARInvoiceDetail)
|Quantity
|4
|15
|
|