Home > Technical > Table Definitions > TRADUNIT

TRADUNIT

Contains a record for each trading unit. What is a trading unit? Each store is a trading unit. Groups of related stores are trading units.

Column

Type

Description

STRTRADECODE

VARCHAR(10)

A unique code assigned by the user.

STRTRADENAME

VARCHAR(50)

Name of the location.

STRTRADETYPE

VARCHAR(10)

Type of trading unit.

Store  

A location which stocks and sells items

Group  

A group of locations

Comp  

A competition store

Comp  

A group of competition stores

Warehouse  

A location which stocks items

Venue  

A group of physically related locations, for example a pub.

Area  

A specialised Group code indicating a group of locations in a geographical area

Inactive  

The location is no longer active

Admin  

Office location where admin staff work

STRADDR1

VARCHAR(50)

Trading address.

STRADDR2

VARCHAR(50)

 

STRCITY

VARCHAR(50)

 

STRSTATE

VARCHAR(20)

 

STRPOSTCODE

VARCHAR(15)

 

STRADDR1POST VARCHAR(50) Postal address.
STRADDR2POST VARCHAR(50)

 

STRCITYPOST VARCHAR(50)

 

STRSTATEPOST VARCHAR(20)

 

STRPOSTCODEPOST VARCHAR(15)

 

STRPHONE VARCHAR(20) Phone number

STRFAX

VARCHAR(20)

Fax number

STRMOBILE

VARCHAR(20)

Mobile number

STREMAIL

VARCHAR(40)

Email address

STRCONTACTNAME

VARCHAR(50)

Main contact name

CURANNUALTURNOVER

DECIMAL(19,4)

Annual turnover. Info only.

CURWEEKLYTURNOVER

DECIMAL(19,4)

Weekly turnover. Info only.

INTFLOORSPACE

SMALLINT

Floor space in square metres. Info only.

INTLANES

SMALLINT

Number of lanes in store. Info only.

STRLATITUDE

VARCHAR(10)

Latitude of store. Info only.

STRLONGITUDE

VARCHAR(50)

Longitude of store. Info only.

INTCARPARK

SMALLINT

Number of car parks. Info only.

DBLAREASALESPER

DECIMAL(19,4)

Percentage of sales in catchment area. Info only.

INTAGE

SMALLINT

Year store was built. Info only.

INTREFERBISHMENT

SMALLINT

Year store was last refurbished. Info only.

STRSTORETYPE

VARCHAR(15)

The type of store.
TRADCODE.strText (where strType='T')

STRSTOREMEMBER

VARCHAR(15)

The retail chain this store belongs to.
TRADCODE.strText (where strType='M')

STRWHOLESALER

VARCHAR(15)

The wholesaler used by this store.
TRADCODE.strText (where strType='W')

YSNSHOPPINGCENTRE

VARCHAR(1)

‘T’ if the store is in a shopping centre.

STRSTORESYSTEM

VARCHAR(10)

The type of computer system used at the store.

STRPARENTUNIT

VARCHAR(10)

The direct parent trading unit of this trading unit. Used to get the hierarchical structure when calculating costs and sells.  This should be empty for the top level location to avoid recursive looping.
TRADUNIT.strTradeCode

STRACCTXREF

VARCHAR(10)

The code used for this trading unit by the accounting system. Not really used anymore.

STRSYSTEMXREF

VARCHAR(10)

The code used for this trading unit for any interfaced head office system, for example Scanmanager. Not really used anymore.

CURSCANMANLOYALTYUNIT

DECIMAL(19,4)

No longer used.

INTTRADECODE

INT

A unique number assigned to the trading unit. Does not have to be assigned but if it is, it must be unique.

STRSELL1DESCRIPTION

VARCHAR(15)

The description of the sell price 1.

STRSELL2DESCRIPTION

VARCHAR(15)

The description of the sell price 2.

STRSELL3DESCRIPTION

VARCHAR(15)

The description of the sell price 3.

STRSELL4DESCRIPTION

VARCHAR(15)

The description of the sell price 4.

STRSELL5DESCRIPTION

VARCHAR(15)

The description of the sell price 5.

STRPERIODOPENED

VARCHAR(7)

The stats period when the location opened.
STATSPER.strYearWeek

YSNELECSALESTOREPORTSALES

VARCHAR(1)

No longer used.

YSNREPORTSALESTOELECSALES

VARCHAR(1)

No longer used.

YSNUSEFORPRICING

VARCHAR(1)

If ‘T’ the trading unit will be displayed in the comboboxes when entering costs and sells.

STRSTOCKLOCATION

VARCHAR(10)

The trading unit at which stock is held for this trading unit. Normally this is the same value as strTradeCode. See TRADALTSTOCK for more specific control over stock locations.

STRMANAGEMENTAREA

VARCHAR(10)

The management area to which this trading unit belongs.
MANAGEMENTAREA.strAreaCode

STRGRADE

VARCHAR(10)

A free-format code to identify similar trading units.

DBLONCOSTPER

DECIMAL(19,4)

Used to calculate the On Costs associated with wages when entering details in the Statistics Entry Form. No longer used.

STRLIQUORTAXHEAVY

VARCHAR(10)

No longer used.

STRLIQUORTAXLIGHT

VARCHAR(10)

No longer used.

YSNTICKETSREQUIRED

VARCHAR(1)

‘T’ if tickets need to be printed for this location. If ‘T’ sell prices will not be sent to the POS, until the tickets have been hung and the user activates the sell pr

STRCOMMTYPE

VARCHAR(10)

The method used for communication with the location. Currently ‘None’ or ‘Modem’.

STRCOMMADDRESS

VARCHAR(100)

The address for the strCommType. If strCommType is ‘Modem’, this will be the modem phone number.

STRPRICECODE

VARCHAR(5)

No longer used.

STRPRTINVMEMB

VARCHAR(10)

If Invoice Printer is being used, this is the code of the invoice to be printed for member sales. ???

STRPRTINVNONMEMB

VARCHAR(10)

If Invoice Printer is being used, this is the code of the invoice to be printed for non-member sales. ???

STRPHONEID

VARCHAR(20)

No longer used.

YSNINCLUDEINSTOCKCHECK

VARCHAR(1)

No longer used.

STRLIQUORTAX3

VARCHAR(10)

No longer used.

STRPOSVERSION

VARCHAR(10)

The version of POS used as this location. This is just a notation field so head office can record what versions of software are at the stores.

INTOFFSETNUMBER

INT

The offset number used at the location's computer system. No longer used.

STRVERSIONCOMMENT

TEXT

General comments about the version of software at the store.

STRIPADDRESS

VARCHAR(32)

This is only used if you are using the TransferFiles program to transfer files between computers. This is the IP Address used to connect to this location. This can be a numeric IP address or a DNS name, for example micros.com

STRREMOTEACCESSNAME

VARCHAR(100)

This is only used if you are using the TransferFiles.exe program to transfer files between computers. This is the name of the Dial Up Networking connection used to connect to the computer. If this is entered, then TransferFiles.exe will use RAS to connect to this location. If you have a direct TCP/IP connection to the computer then you can leave this empty.

YSNUSEDRSCOMMS

VARCHAR(1)

'T' if you are using TransferFiles.exe to transfer files for this location then this should be 'T'. If not required for comms then set to 'F'.

INTCOMMCODE

INT

TransferFiles.exe uses Comms Profiles to determine which files need to be transferred. This is the code of the Comms Profile which is being used.
ZCOMMHDR.ctrCode

STRIMAGENAME

VARCHAR(100)

The name of an image file associated with the location. This can be used on the home shopping site to display a nice graphic. The file should be stored in the images directory used by the home shopping directory.

STRTAXNUMBER1

VARCHAR(20)

The tax number (ABN) for this location.

STRTAXNUMBER2

VARCHAR(20)

The tax number (BRN) for this location.

STREANCODE

VARCHAR(13)

The EAN number assigned to this location.

MEMPOSPECIALMESSAGE

TEXT

The default special instructions for purchase orders.

MEMTFRREQSPECIALMESSAGE

TEXT

The default special instructions for transfer requests.

MEMTFRSENDSPECIALMESSAGE

TEXT

The default special instructions for transfer sends.

STRADMINTILL

VARCHAR(10)

The till to be used for administration account payments.
TILL.strTillCode

YSNSUMMARISETILLREAD

VARCHAR(1)

No longer used.

DBLTELSTRACARD

DECIMAL(19,4)

Only used by BSL. This is the card number for the Telstraaccount when processing phone payments.
CUSTCARDS.dblCardNum

YSNINCREBATEINTRANSFERCOST

VARCHAR(1)

'T' if expected rebates should be included in costs when doing transfers using Transfer Send. Only used when using FIFO. Otherwise 'F'.

YSNPOSTRANSFEROPTION

VARCHAR(1)

Used to control the locations which can be seen by DynaPOSTouch when doing transfers. If 'T' location can be used by DynaPOSTouch. If 'F' then cannot be used.

YSNASKEMAILONTRANSFER

VARCHAR(1)

No longer used. Superseded by INTMSGTFRREQ and INTMSGTFRSEND

STRUNITNUM

VARCHAR(10)

The unit number of the location within a shopping centre.

STRLEASENUM

VARCHAR(30)

The lease number of the location within a shopping centre.

YSNUSECENTRALACCOUNTS

VARCHAR(1)

Only used by BSL. 'T' if this location uses central accounting.

STRBILLTOLOCATION

VARCHAR(10)

The location to which a supplier should sent the invoice for this location. If left empty, invoice is sent to the location the invoice was raised for.
TRADUNIT.strTradeCode

STRPOAUTHORISATION

TEXT

This is the message which will be displayed at the bottom of a purchase order. It usually consists of an underline to place an authorisation signature.

INTCOMMSERVICECODE

INT

Not currently used.

STRSTOCKGROUP

VARCHAR(10)

The location group to which this location belongs for stock enquiries. When POS does a stock enquiry, it looks up this location code then looks for SOH for all locations within it.
TRADUNIT.strTradeCode

YSNPOREQGR

VARCHAR(1)

If set to 'T' you can only do a goods receipt against an existing purchase order. Defaults to 'F'

YSNPOREQIM

VARCHAR(1)

If set to 'T' you can only do an invoice against an existing purchase order. Defaults to 'F'

YSNHIGHERRECQTYGR

VARCHAR(1)

If set to 'T' you can enter a received quantity higher than the ordered quantity in goods receipt. If 'F' you can only enter a quantity less than or equal the ordered quantity. Defaults to 'T'

YSNHIGHERRECQTYIM

VARCHAR(1)

If set to 'T' you can enter a received quantity higher than the ordered quantity in invoice matching. If 'F' you can only enter a quantity less than or equal the ordered quantity. Defaults to 'T'

YSNALLOWBACKORDER

VARCHAR(1)

'T' if this location is allowed to back order, 'F' otherwise. Defaults to 'T'.

STRFTPUSERNAME

VARCHAR(50)

User name to be used for ftp transfers.

STRFTPPASSWORD

VARCHAR(50)

Password to be used for ftp transfers.

DTMTRADESTART

DATETIME

The first date of trade for this location.

DBLORDERRATIO

DECIMAL(19,4)

Not used.

DTMTRADEEND

DATETIME

The last date of trade for this location.

STRTFRREQAUTHORISATION

TEXT

An authorisation message to be printed at the bottom of a transfer request document.

STRTFRSENDAUTHORISATION

TEXT

An authorisation message to be printed at the bottom of a transfer send document.

MEMGRRETURNMESSAGE

TEXT

A message to be displayed on a Goods Receipt Return document.

INTINVENTORYAUTHORISATIONLEVEL

INT

No longer used.

CURPOWARNINGVALUE

DECIMAL(19,4)

If the value of a purchase order is more than this amount, a warning will be displayed.

YSNDEFAULTQTYRECEIVED

VARCHAR(1)

If 'T' the quantity received for a goods receipt will default to the quantity ordered.

YSNSORTSTOCKTAKE

VARCHAR(1)

No longer used.

YSNAUTOPRINTTFRREQ

VARCHAR(1)

If 'T' the Transfer Request document will automatically be printed when the transaction is sent.

YSNAUTOPRINTTFRSEND

VARCHAR(1)

If 'T' the Transfer Send document will automatically be printed when the transaction is accepted.

STRMERCHANTID

VARCHAR(20)

Merchant ID assigned for EFTPOS use.

STRCOMPLOCATION

VARCHAR(10)

The competition location associated with this location.
TRADUNIT.strTradeCode

STRREPORTFOOTER

VARCHAR(100)

The text that will be displayed at the bottom of the page for reports generated for this location.

STRCURRENCYCODE

VARCHAR(5)

The primary currency code this locations uses.
CURRENCYCODE.strCurrencyCode

STRTAXSYSTEMCODE

VARCHAR(10)

The code of the tax system this location uses.
TAXSYSTEM.strTaxSystemCode

STRREPORTLOGO

VARCHAR(100)

The name of the bitmap file that should be used when generating reports.

INTQUEUENUM

INT

Queues can be used to separate locations for processing by Statistics Updater and TillIncoming. Usually this will be 0. Any locations with the same number will share the same queue.

STRCURRENCYCODE2

VARCHAR(5)

The secondary currency code this locations uses at POS.
CURRENCYCODE.strCurrencyCode

STRCURRENCYCODE3

VARCHAR(5)

The tertiary currency code this locations uses at POS.
CURRENCYCODE.strCurrencyCode

INTCHANGEFLAG

INT

An incrementing number assigned by the system each time the location changes. It can be used by EOD processes to determine if the location has been changed

INTNEWFLAG

INT

Similar to INTCHANGEFLAG but is set when a new location is created.

YSNTAXFREESALES

VARCHAR(1)

Used for duty free locations. 'T' indicates the location is allowed to sell the item tax free.

YSNTAXFREEPURCHASES

VARCHAR(1)

Used for duty free locations. 'T' indicates the location is allowed to purchase the item tax free.

INTROSMETHOD

INT

Determines how the Rate Of Sale is calculated.

0  

Sales only

1  

Sales plus transfers

STRWAREHOUSE

VARCHAR(10)

The warehouse from which the location will get its stock for Warehoused items.
TRADUNIT.strTradeCode

YSNSENDMORETHANREQUESTED

VARCHAR(1)

'T' if you are allowed to send more units in a Transfer Send than was actually requested.

CURINVOICEVARIANCE

DECIMAL(19,4)

The maximum acceptable variance between the invoice line items and the batch total. By default this is zero. However, for small variances its sometimes its not worth the cost of tracking down the discrepancy.

INTCLASSSOURCE

INT

Indicates how the system should check for classifications allowed for this location.

0  

Any classification is allowed.

1  

Classifications are listed in the TRADUNITCLASS for this location code

2  

The system will look up the TRADUNITCLASStable for records belonging to the location in STRCLASSTRADECODE

STRCLASSTRADECODE

VARCHAR(10)

If INTCLASSCODE is 2, the system will look up TRADUNITCLASSrecords for this location code to determine the valid classifications for the STRTRADECODE location.

STRREPORTIMAGE

VARCHAR(100)

Not currently used.

MEMREMITTANCE

TEXT

The message that will appear on the remittance advice for any payments received by a debtor.

YSNTFRWARNIFNOSOH

VARCHAR(1)

If this is 'T' POS will give a warning if there is no stock on hand of the item. This implies POS has to go back to Merchant Central Server each scan to check the SOH.

STRACCOUNTSINTERFACE

VARCHAR(10)

Indicates the type of accounts system used by this location.

YSNACCOUNTDR

VARCHAR(1)

'T' if customer account details should be exported (note this is the account header not the account transactions).

YSNACCOUNTDRTRANS

VARCHAR(1)

'T' if debtor transactions should be exported.

YSNACCOUNTSUMMARISEDRTRANS

VARCHAR(1)

'T' if debtor transactions should be summarised. If 'F', transactions will be listed individually.

YSNACCOUNTCR

VARCHAR(1)

'T' if supplier account details should be exported (note this is the account header not the account transactions).

YSNACCOUNTCRTRANS

VARCHAR(1)

'T' if creditor transactions should be exported.

YSNACCOUNTSUMMARISECRTRANS

VARCHAR(1)

'T' if creditor transactions should be summarised. If 'F', transactions will be listed individually.

YSNACCOUNTCASHSALES

VARCHAR(1)

'T' if POS sales should be exported.

YSNACCOUNTSTOCK

VARCHAR(1)

'T' if stock/inventory transactions should be exported.

YSNACCOUNTREBATES

VARCHAR(1)

'T' if creditor rebates should be exported.

YSNSELLPRICERECEIVEREPS

VARCHAR(1)

If 'T' the current sell price of the item will appear on the goods receipt report.

YSNUPDATEINVENTORY

VARCHAR(1)

If 'T' then inventory will be updated for this location. Should only be 'F' under direction from MICROS.

STRLOCALTRADECODE

VARCHAR(10)

Statistics are usually recorded against STRTRADECODE based on the location's currency code. If you trade across multiple countries you can't easily compare statistics because they are in different currencies. There is an EOD process that will allow you to convert statistics to a specific currency code. You need two location codes set up. One being the main location and one being the same location but for the required currency code. You can then compare statistics based on these 'local' locations. This field contains the location code to which you want to convert statistics.
TRADUNIT.strTradeCode

MEMGRAUTHORISATION

TEXT

An authorisation message to be printed at the bottom of a Goods Receipt.

MEMPORETURNAUTHORISATION

TEXT

An authorisation message to be printed at the bottom of a Purchase Order Return document.

YSNALLOWTRANSFERTAX

VARCHAR(1)

If 'T' you are allowed to transfer stock between a taxed and taxfree locations. If either the request or send location has this set to 'F', a transfer is not allowed.

STRREPORTTRADECODE

VARCHAR(10)

The location code that is recorded against any reports generated by this location. Stores that share the same strReportTradeCode will be able to view each others reports.
TRADUNIT.strTradeCode

STRCOMMSCONFIG1

VARCHAR(10)

The primary communication configuration that programs run at this location should use to connect to Merchant Central Server.

link.gif (858 bytes) COMMSCONFIG.strCode

STRCOMMSCONFIG2

VARCHAR(10)

The first backup communication configuration that programs run at this location should use to connect to Merchant Central Server if connection cannot be made using the primary communication configuration.

link.gif (858 bytes) COMMSCONFIG.strCode

STRCOMMSCONFIG3

VARCHAR(10)

The second backup communication configuration that programs run at this location  should use to connect to Merchant Central Server if connection cannot be made using the first backup communication configuration.

link.gif (858 bytes) COMMSCONFIG.strCode

YSNUSEFORBANKING

VARCHAR(1)

'T' if this location can be used for banking purposes.

YSNUSEFORREPORTING

VARCHAR(1)

'T' if this location can be used as a reporting location.

INTMSGTFRREQ

INT

This code indicates whether any messages need to be generated when a Transfer Request is sent.

0  

Don't send a message

1  

Send message to send location's email address

2  

Send POS BE message to send location's inventory contact. See TRADCONTACT.

INTMSGTFRSEND

INT

This code indicates whether any messages need to be generated when a Transfer Send is sent.

0  

Don't send a message

1  

Send message to request location's email address

2  

Send POS BE message to request location's inventory contact. See TRADCONTACT.

YSNBUYCOSTFORCOGS

VARCHAR(1)

Usually this if 'F'. A 'T' indicates that instead of using Average of FIFO cost, the COGS should be calculated using the current buy cost.

STRCOMMCODE

VARCHAR(10)

The commission code that will be used to calculate commission for this location.

COMMISSIONHDR.strCode

INTBOOKINGSTARTOFFSET

INT

Used by Stena to indicate the number of hours before a cruise starts that a booking can be used.

INTBOOKINGENDOFFSET

INT

Used by Stena to indicate the number of hours after a cruise starts that a booking can be used.

STRPOSCURRENCYCODE 

VARCHAR(5)

The currency code to be used for POS. If it is set, it overrides the strCurrencyCode.

CURRENCYCODE.strCurrencyCode

YSNDEFAULTTFRSENDTORECVQTY

VARCHAR(1)

If 'T', the Transfer Send transaction's Send quantity will default to the Transfer Request transaction's Requested quantity.

YSNDEFAULTTFRRECVTOSENDQTY

VARCHAR(1)

If 'T' the Transfer Request transaction's Received quantity will default to the Transfer Send transaction's Send quantity.

YSNCONSIGNLANDEDCOST

VARCHAR(1)

If 'T' the COGS for consignment items will use the expected buy cost. If 'F' it will use the average or FIFO cost as required.

INTTFRSENDPICKSLIPSEQ

INTEGER

The sort order of the items printed on the transfer picking slip.

0=Bay/Reference/Seq#

1=Bay/Reference/D/C/G/SG/Family/IPN

INTTFRSENDREPSEQ

INTEGER

The sort of order the items printed on the Transfer Send Report.

0=Reference/Seq#

1=Reference/D/C/G/SG/Family/IPN

INTTFRREQREPSEQ

INTEGER

The sort of order the items printed on the Transfer Request Report.

0=Reference/Seq#

1=Reference/D/C/G/SG/Family/IPN

STRTVLAREGNUMBER

VARCHAR(6)

The number assigned to this location by the TVLA (UK only).

YSNTFRSENDSHOWZERO

VARCHAR(1)

If 'T' then the Transfer Send Picking Slip will show items even if they have zero stock on hand.

INTUPDATECODE

INTEGER

A sequential number used for record locking purposes.

INTPOREPORTTYPE

INTEGER

 

INTPOAVAILABLEREPORTTYPE

INTEGER

 

DBLINVOICEVARIANCEPROMPT

DECIMAL(19,4)

 

STRMPOSLOCATION

VARCHAR(100)

 

YSNACCOUNTBANKING   

VARCHAR(1)

'T' indicates that Banking Variance will be shown on the Accounts Interface report. Default behavior is false ('F').

STRFISCALID

VARCHAR(50)

This is the Resolution Dian number. Leading zero’s are removed on screen, but filled to print the 15 number length field on the receipt with leading zero if required when printed.

STRFISCALDATE

VARCHAR(50)

This is the Resolution Date, note that this field is plain text, so what you type in this field is what you get displayed on the receipt.

INTFISCALTYPE

INTEGER

This is used to select which Fiscal solution if any to be used, default is None.

STREXPERTID

VARCHAR(50)

 

STRSTATEID

VARCHAR(50)

 

STRMUNICIPAL

VARCHAR(50)

 

MEMFISCALPRIVATEKEY

TEXT

 

MEMFISCALPUBLICKEY

TEXT

 

STRDEFSTKADJCODE

VARCHAR(20)

Default stock adjustment code.

DBLADJTHRESHMIN

DECIMAL(19,4)

Highlight threshold minimum.

DBLADJTHRESHMAX

DECIMAL(19,4)

Highlight threshold maximum.

DBLADJTHRESHNEG

DECIMAL(19,4)

Warning message negative.

DBLADJTHRESHPOS

DECIMAL(19,4)

Warning message positive.

 

Primary Key: STRTRADECODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)