TransferInventory 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
TxnID 12 VARCHAR 36 True False False False %s 10.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 10.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 10.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 10.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False False False %110.0f 10.0 US, CA, UK
TxnDate 91 DATE 10 True True True False CCCC-MM-DD 10.0 US, CA, UK
TxnDateMacro 12 VARCHAR 25 True True True 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		 10.0 US, CA, UK
RefNumber 12 VARCHAR 11 True True True False %s 10.0 US, CA, UK
FromInventorySiteRef_ListID 12 VARCHAR 36 True True True True %s 10.0 US, CA, UK
FromInventorySiteRef_FullName 12 VARCHAR 31 True True True True %s 10.0 US, CA, UK
ToInventorySiteRef_ListID 12 VARCHAR 36 True True True True %s 10.0 US, CA, UK
ToInventorySiteRef_FullName 12 VARCHAR 31 True True True True %s 10.0 US, CA, UK
Memo 12 VARCHAR 255 True True True False %s 10.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False {XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX} 10.0 US, CA, UK