InventoryAdjustmentLine Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 36
TxnID 12 VARCHAR 36 True False False False %s TxnID 2.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 2.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False True False %12.0f 2.0 US, CA, UK
AccountRef_ListID 12 VARCHAR 36 True False True True %s ListID 2.0 US, CA, UK
AccountRef_FullName 12 VARCHAR 159 True False True True %s FullName 2.0 US, CA, UK
TxnDate 91 DATE 10 True False True False CCCC-MM-DD 2.0 US, CA, UK
TxnDateMacro 12 VARCHAR 25 True False False False
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
 2.0 US, CA, UK
RefNumber 12 VARCHAR 11 True False True False %s 2.0 US, CA, UK
InventorySiteRef_ListID 12 VARCHAR 36 True True True False %s ListID 10.0 US, CA, UK
InventorySiteRef_FullName 12 VARCHAR 31 True True True False %s Name 10.0 US, CA, UK
CustomerRef_ListID 12 VARCHAR 36 True False True False %s ListID 2.0 US, CA, UK
CustomerRef_FullName 12 VARCHAR 209 True False True False %s FullName 2.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True False True False %s ListID 2.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 209 True False True False %s FullName 2.0 US, CA, UK
Memo 12 VARCHAR 4095 True False True False %s 2.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 9.0 US, CA, UK
InventoryAdjustmentLine_TxnLineID 12 VARCHAR 36 True True False False %s 1.0 US, CA, UK
InventoryAdjustmentLine_ItemRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
InventoryAdjustmentLine_ItemRef_FullName 12 VARCHAR 159 True True True True %s FullName 1.0 US, CA, UK
InventoryAdjustmentLine_SerialNumber 12 VARCHAR 4095 True True False True %s 1.0 US, CA, UK
InventoryAdjustmentLine_SerialNumberAddedOrRemoved 12 VARCHAR 7 True False False True
Added
Removed
 1.0 US, CA, UK
InventoryAdjustmentLine_LotNumber 12 VARCHAR 40 True True False True %s 1.0 US, CA, UK
InventoryAdjustmentLine_CountAdjustment 4 INTEGER 9 True True False True %11.0f 1.0 US, CA, UK
InventoryAdjustmentLine_InventorySiteLocationRef_ListID 12 VARCHAR 36 True True False True %s 1.0 US, CA, UK
InventoryAdjustmentLine_InventorySiteLocationRef_FullName 12 VARCHAR 31 True True False True %s 1.0 US, CA, UK
InventoryAdjustmentLine_QuantityDifference 4 INTEGER 9 True True False False %10.5f 1.0 US, CA, UK
InventoryAdjustmentLine_ValueDifference 2 NUMERIC 15 True True False False %10.2f 1.0 US, CA, UK
InventoryAdjustmentLine_QuantityAdjustment_NewQuantity 4 INTEGER 9 True True True False %10.5f 1.0 US, CA, UK
InventoryAdjustmentLine_QuantityAdjustment_QuantityDifference 4 INTEGER 9 True True True False %10.5f 1.0 US, CA, UK
InventoryAdjustmentLine_QuantityAdjustment_SerialNumber 12 VARCHAR 91 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_QuantityAdjustment_LotNumber 12 VARCHAR 31 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_QuantityAdjustment_ISLRef_ListID 12 VARCHAR 36 True True True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_QuantityAdjustment_ISLRef_FullName 12 VARCHAR 31 True True True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_ValueAdjustment_NewQuantity 4 INTEGER 9 True True True False %10.5f 1.0 US, CA, UK
InventoryAdjustmentLine_ValueAdjustment_QuantityDifference 4 INTEGER 9 True True True False %10.5f 1.0 US, CA, UK
InventoryAdjustmentLine_ValueAdjustment_NewValue 2 NUMERIC 15 False False True False %10.2f 1.0 US, CA, UK
InventoryAdjustmentLine_ValueAdjustment_ValueDifference 2 NUMERIC 15 False False True False %10.2f 1.0 US, CA, UK
InventoryAdjustmentLine_SerialNumberAdjustment_AddSerialNumber 12 VARCHAR 91 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_SerialNumberAdjustment_RemoveSNumber 12 VARCHAR 91 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_SerialNumberAdjustment_ISLRef_ListID 12 VARCHAR 36 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_SerialNumberAdjustment_ISLRef_FullName 12 VARCHAR 31 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_LotNumberAdjustment_LotNumber 12 VARCHAR 31 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_LotNumberAdjustment_CountAdjustment 4 INTEGER 9 False False True True %11.0f 1.0 US, CA, UK
InventoryAdjustmentLine_LotNumberAdjustment_ISLRef_ListID 12 VARCHAR 36 False False True True %s 1.0 US, CA, UK
InventoryAdjustmentLine_LotNumberAdjustment_ISLRef_FullName 12 VARCHAR 31 False False True True %s 1.0 US, CA, UK
RQUseCachedID -7 BIT 2

Back to list of tables.