IBM Support

Increasing Length or Scale of Quantity Attributes

Troubleshooting


Problem

This document provides information on other fields which must be considered when increasing the length or scale of Inventory Quantity fields in Maximo 7.5.x and Maximo 7.6.x.

Resolving The Problem


Customers may choose to increase or decrease the length or scale of Quantity fields related to Items and Inventory. For example, the length of the Current Balance for an Inventory Balances record (INVBALANCES.CURBAL) may be increased to 17, and the scale to 4. After increasing or decreasing the length or scale of a field related to item quantity, other attributes must also be configured.


This document lists objects and attributes which must be configured in out-of-box base Maximo 7.5 or 7.6 installations. In addition, customer must identify customization attributes related to item quantity and update those as well.

Steps

1. In Database Configuration, Select Action “Field Length and Format”. Change Amount Length or Scale to the new length or scale.

2. In Database Configuration, open each Object record listed below, and navigate to the Attributes tab. Make changes to the length or scale of each attribute listed. Save the Object record. When all edits are complete, apply the configuration changes. Database backup is recommended before any structural database configuration.

CONSTRANSACTION
INVOICEQTY

INVADJUSTMENT
OLDCURBAL
OLDPHYSCNT
QUANTITY

INVBALANCES
ADJUSTEDPHYSCNT
CURBAL
PHYSCNT

INVENTORY
AVBLBALANCE
CURBAL
CURBALTOTAL
EXPIREDQTY
HARDQTYSHIPPED
HARDRESERVEDQTY
HOLDINGBAL
ISSUE1YRAGO
ISSUE2YRAGO
ISSUE3YRAGO
ISSUEYTD
MAXLEVEL
MINLEVEL
ORDERQTY
PHYSCNTTOTAL
RESERVEDQTY
RQTYNOTSTAGED
SHIPPEDQTY
SOFTRESERVEDQTY
SSTOCK
STAGEDQTY

INVLIFOFIFOCOST
QUANTITY

INVOICECOST
QTYFORUI
QUANTITY

INVOICELINE
INVOICEQTY
QTYFORUI
QTYOVERRECEIVED

INVOICEMATCH
QUANTITY

INVRESERVE
ACTUALQTY
PENDINGQTY
RESERVEDQTY
SHIPPEDQTY
STAGEDQTY

INVTRANS
CURBAL
PHYSCNT
QUANTITY

INVUSELINE
DISPLAYRETURNEDQTY
NEWPHYSCNT
PHYSCNT
QUANTITY
RECEIVEDQTY
RETURNEDQTY

INVUSELINESPLIT
NEWPHYSCNT
PHYSCNT
QUANTITY

INVVENDOR
ORDERQTY
QTYRECEIVED
QTYRECEIVEDYTD
QTYREJECTED
QTYREJECTEDYTD

ISSUECURRENTITEM
QUANTITY

ISSUEDITEMFORRETURN
QTYRETURNED
QUANTITY

ISSUEITEMTOASSET
QUANTITY

JOBITEM
ITEMQTY

LINESPLIT
NEWPHYSCNT
PHYSCNT

MATRECTRANS
ACCEPTEDQTY
INSPECTEDQTY
NEWPHYSCNT
ORDERQTY
QTYALREADYRECVD
QTYHELD
QTYOVERRECEIVED
QTYREQUESTED
QUANTITY
RECEIPTQUANTITY
REJECTQTY
RESERVEDQTY
UNINVOICEDQUANTITY

MATUSETRANS
NEWPHYSCNT
PHYSCNT
POSITIVEQUANTITY
QTYREQUESTED
QTYRETURNED
QUANTITY
RESERVEDQTY

MRLINE
QTY
QTY_V

POLINE
AMOUNTTORECEIVE
INTRANSITQTY
QTYTORECEIVE
RECEIPTTOLAMT
RECEIPTTOLERANCE
RECEIPTTOLQTY
RECEIVEDQTY
UNINVOICEDQUANTITY

REORDERPAD
REORDERQTYINISSUEUNIT

RESERVATION
ACTUALQTY
PENDINGQTY
RESERVEDQTY
SHIPPEDQTY
STAGEDQTY

SHIPMENTLINE
BACKORDERQTY
INVOICEDQTY
SHIPPEDQTY

SPAREPART
ISSUEDQTY
QUANTITY

TOOLINV
AVBLBALANCE
CURBALTOTAL
EXPIREDQTY
HOLDINGBAL
PHYSCNTTOTAL
RESERVEDQTY

TRANSFERCURITEM
QUANTITY

Should you need any assistance, please contact IBM Maximo Support.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Inventory","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5;7.6","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
17 June 2018

UID

swg21963976