
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 functionsPossible 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
- #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 locationPossible 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 locationPossible 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 locatedPossible 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 locationPossible 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)