Inventory Balance Lot Import
The Inventory Balance Lot loader has a single set of header columns.
Overview
The Inventory Balance Lot import process reads files from ./Incoming/InventoryBalanceLot/
SFTP folder. These files will be moved to the archive folder located at ./Incoming/Archive/InventoryBalanceLot/
before being processed in alpha-numeric order.
Keys and Validations
Item number
is the unique identifier.
Column | Description | Hidden | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|---|
Balance | Indicates the type of row | false | true | false | - | Balance |
Item Number | Item Number. | false | true | false | string(255) | Any |
Item Name | Item Name. To be deprecated. Use Item Number. | false | false | false | string(255) | Any |
Warehouse | Warehouse Name | false | true | false | string(255) | Must be an active warehouse |
Aisle | Warehouse Location Aisle | false | true | false | string(255) | Must be a valid warehouse location |
Bin | Warehouse Location Bin | false | true | false | string(255) | Must be a valid warehouse location |
Level | Warehouse Location Level | false | true | false | string(255) | Must be a valid warehouse location |
Quantity | Quantity | false | true | false | decimal(32,4) | Any |
UOM | The unit of measure name | false | true | false | string(6) | Must exist in Coupa. Must match item UoM. |
Price | Price | false | true | false | decimal(30,6) | Any |
Currency | The currency code | false | true | false | string(6) | Must exist in Coupa. |
Warning
The bulk loader doesn't support modifying the on-hand balance with items that have a quantity of 0 and a price of $0.
Inventory lot columns
Column | Description | Hidden | Req'd | Unique | Type | Allowable Values |
---|---|---|---|---|---|---|
Lot | Indicates the row type. Required if the item has lot tracking enabled. | false | true | false | - | Lot |
Lot Number | Lot Number. Required if the item has lot tracking enabled. | false | true | false | string(255) | Any |
Quantity | Lot quantity. Required if the item has lot tracking enabled. | false | true | false | decimal(32,4) | Any |
Expiration Date | Lot Expiration Date | false | false | false | date | Any |