InventorySite 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
ListID 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
Name 12 VARCHAR 31 True True True True %s 10.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 10.0 US, CA, UK
ParentSiteRef_ListID 12 VARCHAR 36 True True True False %s 12.0 US, CA, UK
ParentSiteRef_FullName 12 VARCHAR 31 True True True False %s 12.0 US, CA, UK
IsDefaultSite -7 BIT 2 True True True False
1
0
true
false
 10.0 US, CA, UK
SiteDesc 12 VARCHAR 100 True True True True %s 10.0 US, CA, UK
Contact 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
Phone 12 VARCHAR 21 True True True True %s 10.0 US, CA, UK
Fax 12 VARCHAR 21 True True True True %s 10.0 US, CA, UK
Email 12 VARCHAR 1023 True True True True %s 10.0 US, CA, UK
SiteAddress_Addr1 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddress_Addr2 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddress_Addr3 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddress_Addr4 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddress_Addr5 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddress_City 12 VARCHAR 31 True True True True %s 10.0 US, CA, UK
SiteAddress_State 12 VARCHAR 21 True True True True %s 10.0 US, CA, UK
SiteAddress_PostalCode 12 VARCHAR 13 True True True True %s 10.0 US, CA, UK
SiteAddress_Country 12 VARCHAR 31 True True True True %s 10.0 US, CA, UK
SiteAddressBlock_Addr1 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddressBlock_Addr2 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddressBlock_Addr3 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddressBlock_Addr4 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK
SiteAddressBlock_Addr5 12 VARCHAR 41 True True True True %s 10.0 US, CA, UK

Back to list of tables.