Locations Database Table

Distrbuted Access: Lanes( read )

Fields

location_id

#100, Datatype: Integer
Internal reference number allocated by the system. Numbers greater than 0 are constant, negative numbers are reserved to Fieldpine may change without warning. Zero is an invalid value.

Name

#101, Datatype: String 50 bytes
Name of the location as shown on reports

latitude

#102, Datatype: Double

longitude

#103, Datatype: Double

city

#104

location

#105

address1

#106

address2

#107

address3

#108

address4

#109

address5

#110

address6

#111

Comments

#112

rid

#113

stockinserver

#117, Datatype: Integer
Are stock levels maintained in the server, or individual lanes as a source of truth

stockflags

#120, Datatype: Integer
Range of flags to control operation of this location. Despite being called stockflags it also controls non stock related functions

Possible Values

Value	Description
1	If set location cannot purchase stock
2	If set location cannot receive stock, this includes store transfers and supplier deliveries
4	If set store provided stock levels are forced into upstream servers. Rarely used, special cases only
1024	Hidden stock levels. Stock held by this location may be hidden from some reports
2048	Selling disabled. If set the store cannot raise sales

companyid

#121, Datatype: Integer
Company Id#. Used only in multiple brand configurations. Deprecated do not use for new development

active

#122, Datatype: Boolean (stored in integer field)
Active Store

publish

#123

Parent

#124, Datatype: Integer
Parent store that controls this store, if stores have structure, otherwise blank

OpenDt

#125

CloseDt

#126

postcode

#127, Datatype: String 14 bytes

taxregion

#128, Datatype: Integer
Region or State this store operates within. Only required for countries that have state or local taxes

taxid0

#129, Datatype: String 40 bytes

bankbsb

#130, Datatype: String 16 bytes
Australian BSB code

bankaccountno

#131, Datatype: String 30 bytes

bankaccountname

#132, Datatype: String 40 bytes

lastip

#149

phone

#150

Email

#151 Internal use email typically used for admin contact

Contact

#154 A published name of the person acting as primary contact for this location

descaddr

#155 A descriptive address for shoppers describing how to find the store

deladdr

#160

BuyerPhone

#161

FormalName

#162, Datatype: String 180 bytes
Legal name of store that might be used on documents such as purchase orders

OrderCC

#163, Datatype: String 120 bytes
Email address to receive a CC copy of all Purchase Orders emailed.

TypeCode

#164, Datatype: Integer
Actual type of location. See Locations database definition for acceptable values.

Possible Values

Value	Description
1	Retail Outlet
2	Remote Outlet
3	Mobile Store
4	Non Physical Store
5	Store in a store
6	Warehouse
7	Container
8	Internet Storefront
9	Head Office
10	Branch Office
11	Agency
12	Offsite

PublicAccess

#165, Datatype: Integer
Public have access to this location

Possible Values

Value	Description
0	Public
1	Restricted
2	No

GeoReportArea

#166 Geographic area for reporting and management. Stores do not need to physically be in this area

Possible Values

Value	Description
6400001	NZL, Auckland
6400002	NZL, Wellington
6400003	NZL, Christchurch
6400004	NZL, Dunedin
6400005	NZL, Hamilton
6400006	NZL, Bay of Plenty
6400007	NZL, Canterbury
6400008	NZL, Central
6400009	NZL, Northland
6400010	NZL, Otago & Southland
6400011	NZL, Waikato
6400012	NZL, National
6400013	NZL, Other
6400014	NZL, Auckland Central
6400015	NZL, Auckland North
6400016	NZL, Auckland South
6400017	NZL, Auckland West
6400018	NZL, Auckland East

PostAddr

#167 Postal Address of store

externalid

#168 External Id number. Used as reference to other systems code for this location

region

#169 Region code

branch

#170 Branch code

fax

#171

shortcode

#176, Datatype: String 20 bytes
A short abbreviated code to describe this location. Must be uniqe

installpassword

#177, Datatype: String 40 bytes
A simple password that must be entered in order to install new software into this store.

installallow

#178, Datatype: Integer
An encoded bitmask that controls what sort of software can be installed into this location

Possible Values

Value	Description
1	PosGreen allowed
2	Direct to server permitted
256	StoreServer allowed

receiptmessage

#179, Datatype: String 240 bytes
Store specific message to place on customer receipts. The receipt format must specifically include this symbol

StockLoc

#183, Datatype: Integer
Location number stock is taken from

commission

#184, Datatype: Double
Commission payable by store. This value is not directly used by Fieldpine but is available for site specific reports

StoreControllerType

#185, Datatype: Integer
Where this stores controller is located

Possible Values

Value	Description
0	Undefined
2	Self Hosted
4	External
8	Child
256	Fieldpine Online/Sandbox
257	Fieldpine Online/ArmsLength

StoreControllerLoc

#186, Datatype: Integer
Location id of owning store controller

altnames

#190 Alternative List. Other names this store can be known by. Often used when matching supplier store names. Names must be unique, no single value can match multiple locations.

operatingprofile

#200, Datatype: String 40 bytes
Key to profile this store uses

rve

#253, Datatype: Double

physkey

#254 Internal identifying key. This value can always be used to refer to a specific location

RmSystem

#255, Datatype: String 44 bytes

backupflags

#261, Datatype: Integer
Internal flags controlling how backups are performed

permdesc

#262, Datatype: String 40 bytes

labelcontrol

#263 JSON data to override label formats when printing

timezone

#264, Datatype: String 80 bytes

PublicName

#300 Friendly version of store name for general public use

CostCentre

#301 Financial cost centre used in accounting system

phone_quick

#302 Quick dial phone number for internal PABX

fax_quick

#303 Quick dial fax number for internal PABX

Mobile

#304 Mobile phone number of store

EmailMgr

#305 Managers email

IPRangeInStore

#306

IPNetmaskInStore

#307

StoreServer1Addr

#308, Datatype: String 150 bytes
Store Server 1

StoreServer2Addr

#309, Datatype: String 150 bytes
Store Server 2

StoreDNS

#310, Datatype: String 150 bytes
Store DNS

RouterProfile

#311 Router Profile

PriceBand

#312 Price Band

AgencyLogin

#313, Datatype: String 64 bytes
login name (email) used for an agency to access fieldpine.com

AgencyLoginPass

#314, Datatype: String 64 bytes
login password used for an agency to access fieldpine.com

CountryState

#315, Datatype: String 16 bytes
Regional state of this location

deployedsscode

#316, Datatype: Integer
Approved server code that can be run in this location

Possible Values

Value	Description
0	Not specified

GeoAllow

#318, Datatype: String 120 bytes

InstalledProfile

#319, Datatype: String 180 bytes

ScLaneAuthKey

#320, Datatype: String 60 bytes
An auth key that can be used to authorise lanes onto remote RmSystem

ScOwnerAuthKey

#321, Datatype: String 60 bytes
An auth key that we can use to access the remote RmSystem

ScRmSystem

#322, Datatype: String 40 bytes
The RmSystem allocated to the remote RmSystem

CountryCode

#323, Datatype: Integer
Country code number for where this store is located

GeoArea

#324, Datatype: Integer
Geographic area of this store

pickingemail

#325, Datatype: String 96 bytes
Email address to receive internal notices about web sales

purchaseordertemplate

#326, Datatype: String 196 bytes
Url of default purchase order template for this store

heartbeatdt

#1600

zone

#1601

zid

#1602

station

#1603, Datatype: Integer
Holds an alternative number for location, used by some retailers that need to hold additional values. This value is not used directly by Fieldpine

poweraccountno

#6000 Power Supplier Account Number

nzl_mtano

#1064000 MTA Membership number

nzl_powericp

#1064001 Power supplier ICP reference number

nzl_powerretailer

#1064002 Power supplier (retailer)

avic

#1064003, Datatype: String 6 bytes

NZTAApproval

#1064004, Datatype: Integer

NZTAAssesor

#1064005, Datatype: String

nzl_datacom_payroll_id

#2064000, Datatype: String 6 bytes

InStoreRadio

#3000000, Datatype: Boolean (stored in integer field)