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.
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 |