ORDITEMCONF

This table is used to check order item shipment confirmation and capture the order serial numbers

Column Descriptions:

NameTypeDescription
ORDITEMCONF_IDBIGINT NOT NULLThe generated order items confirmation identifier.
ORDERITEMS_IDBIGINT NOT NULLThe identifier of the orderitem associated with this serial number.
OICOMPLIST_IDBIGINTThe identifier of the component of a configured OrderItem associated with the serial number.
SERIALNUMBERVARCHAR (128)The string representation of the serial number.
MANIFEST_IDBIGINTThe identifier of the shipping manifest during which this item was shipped.
ORDRELEASENUMINTEGER NOT NULLthe identifier of the release.
QUANTITYDOUBLE NOT NULLThe quantity that has been shipped within this package (same as inventory UOM)
CONFIRMTYPESMALLINT NOT NULLThis 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_TIMESTAMPTIMESTAMP NOT NULLTime when the confirmation was recorded.
LASTUPDATETIMESTAMP NOT NULLTime when last update.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDITEMCONF_IDPrimary Key
I0000974ORDERITEMS_ID+OICOMPLIST_IDNon-Unique Index
I0000975SERIALNUMBERNon-Unique Index
I0001268OICOMPLIST_IDNon-Unique Index
I0001269MANIFEST_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3473OICOMPLIST_IDOICOMPLISTOICOMPLIST_IDCascade
F_3474ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_3475MANIFEST_IDMANIFESTMANIFEST_IDCascade