TABLE DETAIL REFERENCE: InventorySite
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ParentSiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentSiteRefFullName12 VARCHAR 209TrueTrueTrueFalse%s
IsDefaultSite-7 BIT 1TrueTrueTrueFalse
1
0
true
false
SiteDesc12 VARCHAR 100TrueTrueTrueTrue%s
Contact12 VARCHAR 41TrueTrueTrueTrue%s
Phone12 VARCHAR 21TrueTrueTrueTrue%s
Fax12 VARCHAR 21TrueTrueTrueTrue%s
Email12 VARCHAR 1024TrueTrueTrueTrue%s
SiteAddressAddr112 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressAddr212 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressAddr312 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressAddr412 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressAddr512 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressCity12 VARCHAR 31TrueTrueTrueTrue%s
SiteAddressState12 VARCHAR 21TrueTrueTrueTrue%s
SiteAddressPostalCode12 VARCHAR 13TrueTrueTrueTrue%s
SiteAddressCountry12 VARCHAR 31TrueTrueTrueTrue%s
SiteAddressBlockAddr112 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressBlockAddr212 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressBlockAddr312 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressBlockAddr412 VARCHAR 41TrueTrueTrueTrue%s
SiteAddressBlockAddr512 VARCHAR 41TrueTrueTrueTrue%s