StockItem
StockItem is an auto-generated table.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True | |
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 |