This table is used to check order item shipment confirmation and capture the order serial numbers
Column Descriptions
| Column Name
| Column Type
| Description |
| ORDITEMCONF_ID
| BIGINT NOT NULL
| The generated order items confirmation identifier.
|
| ORDERITEMS_ID
| BIGINT NOT NULL
| The identifier of the orderitem associated with this serial number.
|
| OICOMPLIST_ID
| BIGINT
| The identifier of the component of a configured OrderItem associated with the serial number.
|
| SERIALNUMBER
| VARCHAR(128)
| The string representation of the serial number.
|
| MANIFEST_ID
| BIGINT
| The identifier of the shipping manifest during which this item was shipped.
|
| ORDRELEASENUM
| INTEGER NOT NULL
| the identifier of the release.
|
| QUANTITY
| DOUBLE NOT NULL
| The quantity that has been shipped within this package (same as inventory UOM)
|
| CONFIRMTYPE
| SMALLINT NOT NULL
| This field indicates the confirmation type of the item. 0 - order item shipment confirmation 1 - serial number shipment confirmation 2 - order item receipt confirmation 3 - serial number receipt confirmation
|
| CREATION_TIMESTAMP
| TIMESTAMP NOT NULL
| Time when the confirmation was recorded.
|
| LASTUPDATE
| TIMESTAMP NOT NULL
| Time when last update.
|
| OPTCOUNTER
| SMALLINT
| IBM internal use
|