InventoryStockedItems |
Catalog: Autotask
Schema: InventoryStockedItems
This is a read-only table. The Autotask API may not support changing the data or the Invantive UniversalSQL driver for Autotask does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Autotask API.
Table Columns
The columns of the table InventoryStockedItems are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
availableUnits |
int32 |
|
☐ |
|
companyID |
int32 |
Company ID |
☐ |
|
configurationItemID |
int32 |
Configuration Item ID |
☐ |
|
contractChargeID |
int32 |
Contract Charge ID |
☐ |
|
createDateTime |
datetime |
Created |
☐ |
|
createdByResourceID |
int32 |
Created by Resource ID |
☐ |
|
currentInventoryLocationID |
int32 |
|
☐ |
|
deliveredUnits |
int32 |
|
☐ |
|
id |
int64 |
ID |
☐ |
|
inventoryProductID |
int32 |
|
☐ |
|
onHandUnits |
int32 |
|
☐ |
|
parentInventoryStockedItemID |
int32 |
|
☐ |
|
parentStockedItemReceivedUnits |
int32 |
|
☐ |
|
pickedRemovedByResourceID |
int32 |
|
☐ |
|
pickedRemovedDateTime |
datetime |
|
☐ |
|
pickedUnits |
int32 |
|
☐ |
|
projectChargeID |
int32 |
Project Charge ID |
☐ |
|
purchaseOrderID |
int32 |
|
☐ |
|
purchaseOrderItemID |
int32 |
Purchase Order Item ID |
☐ |
|
purchaseOrderItemReceivingID |
int32 |
|
☐ |
|
quoteItemID |
int32 |
Quote Item ID |
☐ |
|
removedUnits |
int32 |
|
☐ |
|
reservedUnits |
int32 |
|
☐ |
|
returnPrice |
double |
|
☐ |
|
returnTypeID |
int32 |
|
☐ |
|
serialNumber |
string |
Serial Number |
☐ |
|
soapParentPropertyId_body_canReduce |
boolean |
|
☐ |
|
soapParentPropertyId_body_nodeType |
string |
|
☐ |
|
soapParentPropertyId_body_type |
string |
|
☐ |
|
soapParentPropertyId_canReduce |
boolean |
|
☐ |
|
soapParentPropertyId_name |
string |
|
☐ |
|
soapParentPropertyId_nodeType |
string |
|
☐ |
|
soapParentPropertyId_returnType |
string |
|
☐ |
|
soapParentPropertyId_tailCall |
boolean |
|
☐ |
|
soapParentPropertyId_type |
string |
|
☐ |
|
statusID |
int32 |
|
☐ |
|
ticketChargeID |
int32 |
Ticket Charge ID |
☐ |
|
transferredUnits |
int32 |
|
☐ |
|
unitCost |
double |
Unit Cost |
☐ |
|
vendorID |
int32 |
Vendor ID |
☐ |
|
vendorInvoiceNumber |
string |
Vendor Invoice Number |
☐ |
|
10-06-2024 18:39 Version 24.1.3-BETA+4689