JDBC Driver for Sage Intacct

Build 22.0.8462

ItemWarehouseInfo

Retrieves Item Warehouse data.

Columns

Name Type ReadOnly Description
Recordno Int64 False

The Recordno field of the Item object.

Itemid [KEY] String False

The Itemid field of the Item object.

Warehouseid String False

The Warehouseid field of the Item object.

DefaultSubsection String False

The DefaultSubsection field of the Item object.

Cycle String False

The Cycle field of the Item object.

StandardCost String False

The StandardCost field of the Item object.

LastCost String False

The LastCost field of the Item object.

AverageCost String False

The AverageCost field of the Item object.

ReorderMethod String False

The ReorderMethod field of the Item object.

EconomicOrderQty Int64 False

The EconomicOrderQty field of the Item object.

ReorderPoint Int64 False

The ReorderPoint field of the Item object.

ReorderQty Int64 False

The ReorderQty field of the Item object.

MinOrderQty Int64 False

The MinOrderQty field of the Item object.

MaxOrderQty Int64 False

The MaxOrderQty field of the Item object.

MaxStock Int64 False

The MaxStock field of the Item object.

MinStock Int64 False

The MinStock field of the Item object.

DateLastsold Datetime False

The DateLastsold field of the Item object.

DateLastreceived Datetime False

The DateLastreceived field of the Item object.

DefaultAisle String False

The DefaultAisle field of the Item object.

DefaultRow String False

The DefaultRow field of the Item object.

DefaultBin String False

The DefaultBin field of the Item object.

Wonorder Decimal False

The Wonorder field of the Item object.

Wintransit Decimal False

The Wintransit field of the Item object.

Wonhand Decimal False

The Wonhand field of the Item object.

Wonhold Decimal False

The Wonhold field of the Item object.

Wreserved Decimal False

The Wreserved field of the Item object.

Wallocated Decimal False

The Wallocated field of the Item object.

WhseCurrency String False

The WhseCurrency field of the Item object.

SafetyStock Int64 False

The SafetyStock field of the Item object.

ReplenishmentMethod String False

The ReplenishmentMethod field of the Item object.

EnableReplenishment Bool False

The EnableReplenishment field of the Item object.

RecordUrl String False

The RecordUrl field of the Item object.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462