NameDescriptionTypeAdditional information
ID

integer

None.

IsMaster

boolean

None.

ShortName

string

None.

URL

Web address for store (eg stores website / online store)

string

Data type: Url

SortOrder

integer

None.

Name

string

None.

Phone

string

None.

Fax

string

None.

Email

string

None.

Address1

string

None.

Address2

string

None.

City

string

None.

State

string

None.

Country

string

None.

PostCode

string

None.

Delivery

How the Store’s pricing file will be delivered

StoreDelivery

None.

ExportAccounts

integer

None.

SalesAccountFolder

string

None.

PurchaseAccountFolder

string

None.

InitLoad

Used in SEO for synchronising new Stores to groups

integer

None.

InitIDs

Used in SEO for synchronising new Stores to groups

integer

None.

ZoneID

integer

None.

ActAsMaster

integer

None.

LastActiveUtc

date

None.

Active

boolean

None.

Warehouse

boolean

None.

ABN

string

None.

PhoneOrderSubjectLine

string

None.

CaseConfiguration

CaseConfiguration

None.

IsNormalPriceChangesCampaign

boolean

None.

GeneratePrintLabels

Whether this store will automatically generate print labels

boolean

None.

HeaderLogo

string

None.

CustNo

string

Deprecated. use HostStoreSettings records instead.

StateCode

Host State Indicator

string

Deprecated. use HostStoreSettings records instead.

String length: inclusive between 0 and 2

HostIdentifier

Collection of byte

Deprecated. use HostStoreSettings records instead.

HostIdentifierGuid

globally unique identifier

Deprecated. use HostStoreSettings records instead.

HostName

HostProvider

Deprecated. use HostStoreSettings records instead.

HostAddress

string

Deprecated. use HostStoreSettings records instead.

HostUsername

string

Deprecated. use HostStoreSettings records instead.

HostPassword

string

Deprecated. use HostStoreSettings records instead.

ExcludeFromLeadInOut

boolean

Deprecated. use HostStoreSettings records instead.

AccountingProvider

AccountingProvider

Deprecated. Search the settings table for this value, Section='Accounting', KeyName='AccountingProvider'.

AccountingAddress

string

None.

AccountingUsername

string

None.

AccountingPassword

string

None.

StoreAccountingCode

string

None.

SoftwareVariance

integer

None.

FuelWarningVariance

decimal number

None.

FuelErrorVariance

decimal number

None.

FuelAccumulatedWarningVariance

decimal number

None.

FuelAccumulatedErrorVariance

decimal number

None.

DrawManagment

CashBalancingDrawerManagement

None.

EndOfDayManagment

boolean

None.

AutoFillCashBalancing

boolean

None.

FuelDayVariance

integer

None.

AccountingTradingTime

time interval

None.

StockActivateProduct

ActivateProducts

None.

GiftCardSalesAccountingDeptCode

string

None.

TransactionDiscountAccountingDeptCode

string

None.

Size

integer

None.

Updated

date

None.

PriceZoneName

string

Relation. This field may not always be loaded or used for updates.

StoreFuelConfigured

boolean

Relation. This field may not always be loaded or used for updates.

ShippingAddressCopied

boolean

Relation. This field may not always be loaded or used for updates.

ShippingAddress

StoreAddress

Relation. This field may not always be loaded or used for updates.

BillingAddress

StoreAddress

Relation. This field may not always be loaded or used for updates.

HostStoreSettings

Collection of HostStoreSetting

Relation. This field may not always be loaded or used for updates.

Accounts

Collection of StoreAccount

Relation. This field may not always be loaded or used for updates.

Sales

Collection of StoreExternalSale

Relation. This field may not always be loaded or used for updates.

ZoneMatrix

Collection of ZoneMatrix

Relation. This field may not always be loaded or used for updates.

CashManagements

Collection of CashManagement

Relation. This field may not always be loaded or used for updates.

UpdateStoreID

SaaS Store ID

globally unique identifier

Relation. This field may not always be loaded or used for updates.

UpdateStore

SaaS Store Connection

UpdateStore

Relation. This field may not always be loaded or used for updates.

TimeZoneId

Windows TimeZoneId to set store to

string

Relation. This field may not always be loaded or used for updates.

SecurityOptions

SecurityOptions

Relation. This field may not always be loaded or used for updates.