View Categories

InventoryAdjustmentLineRet

< 1 min read

InventoryAdjustmentLineRet (old ->InventoryAdjustmentLineDetail)

FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnLineIDtruefalsefalsefalsefalse
ItemRef_ListIDtruetrueoptionaltruetrue
ItemRef_FullNametruetrueoptionaltruetrue
SerialNumbertruetrueoptionaltrueoptional
LotNumbertruetrueoptionaltrueoptional
CountAdjustmenttruetrueoptionaltrueoptional
NewQuantitytruefalseoptionaltrueoptional
QuantityDifferencetruetrueoptionaltrueoptional
NewValuetruefalseoptionaltrueoptional
ValueDifferencetruetrueoptionaltrueoptional
SerialNumberAddedOrRemovedtruefalseoptionalfalseoptional
InvSiteLocRef_ListIDtruetrueoptionaltrueoptional
InvSiteLocRef_FullNametruetrueoptionaltrueoptional
InventoryAdjustmentLineTypetruefalseoptionaltruetrue
PARENT_IDKEYIDKEY
SeqNumkeeps the seq

Parent tables

  • InventoryAdjustment

Fields

InventoryAdjustmentLineType possible values:

  • QuantityAdjustment
  • ValueAdjustment
  • SerialNumberAdjustment
  • LotNumberAdjustment

Powered by BetterDocs