Transaction_inventory_numbers

This table exposes inventory numbers, also known as serial or lot numbers, for transaction lines. The Transaction Column Fields and Item Fields custom fields are available for the Transaction Inventory Numbers table.

Note: This table replaces the inventory_numbers column in the Transaction Lines table, which has been removed.

Columns

Name Type Length Precision Scale References In Description
inventory_number VARCHAR2 100 Inventory number
quantity NUMBER 39 0 Number of transaction items. For serial numbers, this value is always 1. For lot numbers, this value is the lot quantity.
transaction_id NUMBER 39 0 Transaction ID
transaction_line NUMBER 39 0 Transaction line ID