JDBC Driver for Acumatica

Build 22.0.8462

StockItem

StockItem is an auto-generated table.

Columns

Name Type ReadOnly Description
DefaultPrice Double False

PriceWorkgroup String False

LandedCostVarianceSubaccount String False

InventorySubaccount String False

LandedCostVarianceAccount String False

POAccrualSubaccount String False

ItemStatus String False

LinkedWarehouseDetails String False

LastModified Datetime False

DefaultIssueLocationID String False

DefaultReceiptLocationID String False

UseOnEntry Bool False

SalesSubaccount String False

LinkedVendorDetails String False

DefaultSubitem String False

LotSerialClass String False

SubjectToCommission Bool False

PriceManager String False

LinkedReplenishmentParameters String False

LastCost Double False

COGSAccount String False

SalesAccount String False

StandardCostVarianceSubaccount String False

COGSSubaccount String False

PackSeparately Bool False

ReasonCodeSubaccount String False

ImageUrl String False

ItemClass String False

ItemType String False

MinMarkup Double False

DeferralAccount String False

VolumeUOM String False

StandardCostVarianceAccount String False

AverageCost Double False

IsAKit Bool False

CurrentStdCost Double False

SalesUOM String False

DefaultWarehouseID String False

BaseUOM String False

ProductWorkgroup String False

ProductManager String False

AutoIncrementalValue String False

Description String False

PackagingOption String False

DimensionVolume Double False

PostingClass String False

DimensionWeight Double False

InventoryAccount String False

ABCCode String False

ValuationMethod String False

LinkedCrossReferences String False

LinkedUOMConversions String False

MSRP Double False

PriceClass String False

PurchaseUOM String False

LinkedBoxes String False

DiscountAccount String False

MaxCost Double False

Markup Double False

StandardCostRevaluationSubaccount String False

DeferralSubaccount String False

StandardCostRevaluationAccount String False

WeightUOM String False

LastStdCost Double False

LinkedAttributes String False

TaxCategory String False

LinkedCategories String False

PurchasePriceVarianceSubaccount String False

MinCost Double False

POAccrualAccount String False

LinkedSubItems String False

DiscountSubaccount String False

InventoryID [KEY] String False

Content String False

PendingStdCost Double False

PurchasePriceVarianceAccount String False

Custom_ItemSettings_Body String False

Custom_ItemSettings_NoteID String False

Custom_ItemSettings_MovementClassID String False

Custom_ItemSettings_StdCstRevSubID String False

Custom_ItemSettings_LCVarianceSubID String False

Custom_ItemSettings_DefaultTermUOM String False

Custom_ItemSettings_ABCCodeID String False

Custom_ItemSettings_InvtSubID String False

Custom_ItemSettings_ABCCodeIsFixed Bool False

Custom_ItemSettings_BaseItemVolume String False

Custom_ItemSettings_DiscAcctID String False

Custom_ItemSettings_ImageUrl String False

Custom_ItemSettings_PurchaseUnit String False

Custom_ItemSettings_BaseItemWeight String False

Custom_ItemSettings_DeferralSubID String False

Custom_ItemSettings_UseParentSubID Bool False

Custom_ItemSettings_PPVAcctID String False

Custom_ItemSettings_DefaultTerm String False

Custom_ItemSettings_StdCstVarSubID String False

Custom_ItemSettings_PackSeparately Bool False

Custom_ItemSettings_DfltReceiptLocationID String False

Custom_ItemSettings_COGSAcctID String False

Custom_ItemSettings_LCVarianceAcctID String False

Custom_ItemSettings_MarkupPct String False

Custom_ItemSettings_DiscSubID String False

Custom_ItemSettings_COGSSubID String False

Custom_ItemSettings_BaseUnit String False

Custom_ItemSettings_PriceClassID String False

Custom_ItemSettings_TotalPercentage String False

Custom_ItemSettings_DeferralAcctID String False

Custom_ItemSettings_CycleID String False

Custom_ItemSettings_StdCstRevAcctID String False

Custom_ItemSettings_DeferredCode String False

Custom_ItemSettings_MovementClassIsFixed Bool False

Custom_ItemSettings_LastStdCost String False

Custom_ItemSettings_StdCstVarAcctID String False

Custom_ItemSettings_DefaultSubItemID String False

Custom_ItemSettings_StdCostDate String False

Custom_ItemSettings_StdCost String False

Custom_ItemSettings_SalesAcctID String False

Custom_ItemSettings_Commisionable Bool False

Custom_ItemSettings_SalesUnit String False

Custom_ItemSettings_PendingStdCost String False

Custom_ItemSettings_DefaultSubItemOnEntry Bool False

Custom_ItemSettings_DfltSiteID String False

Custom_ItemSettings_RecPrice String False

Custom_ItemSettings_ReasonCodeSubID String False

Custom_ItemSettings_SalesSubID String False

Custom_ItemSettings_PriceWorkgroupID String False

Custom_Item_NoteID String False

Custom_ItemSettings_WeightUOM String False

Custom_ItemSettings_VolumeUOM String False

Custom_ItemSettings_POAccrualSubID String False

Custom_ItemSettings_PPVSubID String False

Custom_ItemSettings_DfltShipLocationID String False

Custom_ItemSettings_BasePrice String False

Custom_ItemSettings_PriceManagerID String False

Custom_ItemSettings_MinGrossProfitPct String False

Custom_Item_NoteText String False

Custom_ItemSettings_POAccrualAcctID String False

Custom_ItemSettings_InvtAcctID String False

Custom_ItemSettings_PendingStdCostDate String False

Custom_ItemSettings_PackageOption String False

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