Home > Technical > Table Definitions > SUPPLIER

SUPPLIER

Contains a record for each supplier. A supplier can be a wholesaler, manufacturer, direct or broker.

Column

Type Description

STRSUPPLIERCODE

VARCHAR(10) Unique code assigned by the user.

STRSUPPLIERNAME

VARCHAR(50) Name of supplier.

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 of supplier.

STRFAX

VARCHAR(20) Fax number of supplier.

STRMOBILE

VARCHAR(20) Mobile phone number of supplier.

STREMAIL

VARCHAR(40) Email address for supplier.

STRORDERPHONE

VARCHAR(20) Phone number used to place an order.

STRCONTACTNAME

VARCHAR(50) Name of contact.

STRSUPPLIERTYPE

VARCHAR(15) The type of supplier. Broker/ Direct/Manufacturer/Wholesaler

STRCLAIMTYPE

VARCHAR(10) Indicates if we make claims on sales or purchases data. Sales/Purchases. Not currently used.

STRCLAIMMETHOD

VARCHAR(10) Indicate how we claim. Invoice/Credit.

STRINVOICEQTY

VARCHAR(10) If we receive electronic invoice data, what is the quantity measured in? Cartons/Units.

STRACCOUNTCODE

VARCHAR(20) Not currently used.

INTORDERLEADDAYS

SMALLINT The number of days before a normal order is required when we should actually place the order.

INTPROMOLEADDAYS

SMALLINT The number of days before a promotion order is required when we should actually place the order.

INTPROMOENDDAYS

SMALLINT The number of days after a promotion has finished when we can still place an order.

YSNNEW

VARCHAR(1) No longer used.

YSNCHANGED

VARCHAR(1) No longer used.

LINTSUPPLIERCODE

INT Unique number assigned by the system. Used for systems that do not support alphanumeric codes.

STRGRADE

VARCHAR(10) Free-format field for grouping similar suppliers together.

YSNIMPORTZMPURCH

VARCHAR(1) No longer used.

STRFREIGHTCODE

VARCHAR(10) The freight rate used by this supplier.
FREIGHT.strFreightCode

STRPOOUTPUTMETHOD

VARCHAR(10) The type of electronic output to be generated when the purchase order is created.

STRACN

VARCHAR(12) No longer used.

STRLIQUORLICENCE

VARCHAR(10) The liquor licence number for this supplier.

STRPARENTCODE

VARCHAR(10) Code of the parent supplier.
SUPPLIER.strSupplierCode

YSNLINESERVICEFEE

VARCHAR(1) No longer used.

YSNLINEULLAGEFEE

VARCHAR(1) No longer used.

YSNLINESALESTAX

VARCHAR(1) No longer used.

YSNLINELIQUORTAX

VARCHAR(1) No longer used.

YSNLINEFREIGHT

VARCHAR(1) No longer used.

STRACCOUNTREF

VARCHAR(20) The supplier's account code for us.

YSNPREFERRED

VARCHAR(1) If 'T' then products from this supplier are preferred. This is used as part of determining where an item will be purchased from. If a product is available from two supplier's the system will choose the preferred supplier first. A trigger on the table will automatically set all RANGE.ysnPreferred flags to this value for all products from this supplier.

YSNCHANGETERMS

VARCHAR(1) No longer used.

YSNACKNOWLEDGESTOCK

VARCHAR(1) No longer used.

INTMINORDERQTY

INT The minimum quantity of items that can be ordered on one purchase order.

DBLFINANCEFEE

DECIMAL(19,4) No longer used.

STRORDERFREQUENCY

VARCHAR(10) No longer used.

STRIMAGENAME

VARCHAR(100) The name of an image file associated with the supplier. 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 supplier.

STRTAXNUMBER2

VARCHAR(20) The tax number (BRN) for this supplier.

YSNCOSTINCLUDESSERVICEFEE

VARCHAR(1) 'T' indicates that the invoice cost does include service fee otherwise 'F'. Replaces ysnLineServiceFee.

YSNCOSTINCLUDESULLAGEFEE

VARCHAR(1) 'T' indicates that the invoice cost does include ullage fee otherwise 'F'. Replaces ysnLineUllageFee.

YSNCOSTINCLUDESTAX

VARCHAR(1) 'T' indicates that the invoice cost does include tax (GST) otherwise 'F'.  Replaces ysnLineSalesTax.

YSNCOSTINCLUDESWET

VARCHAR(1) 'T' indicates that the invoice cost does include WET (Wine Equalisation Tax) otherwise 'F'.

YSNRECIPIENTINVOICE

VARCHAR(1) 'T' if this supplier uses Recipient Created Tax Invoice. Usually 'F'.

YSNCHARGEDGST

VARCHAR(1) 'T' if this supplier does not charge GST. Usually 'F'. You would only set this to 'T' if the supplier is internal to the company, for example internal warehouse.

STREANCODE

VARCHAR(13) The thirteen digit number assigned by EAN for this supplier.

YSNCREDITCENTRALACCOUNT

VARCHAR(1) 'T' if central accounts (a BSL feature) are used for this location. Defaults to 'F'

YSNLOCATION

VARCHAR(1) 'T' if this is actually a location which has been set up as a supplier. Defaults to 'F'.

YSNALLOWBACKORDER

VARCHAR(1) 'T' if this supplier allows us to back order, 'F' otherwise. Defaults to 'T'.

DBLLOADCOSTPER

DECIMAL(19,4) If the user is set up for loaded costs, then this percentage will be added to any cost the user sees for this supplier.

CURMINORDERVALUE

DECIMAL(19,4) The minimum value for an order placed with this supplier.

INTBACKORDERDAYS

INT The number of days that a back order should be considered valid for this supplier.

STRCURRENCYCODE

VARCHAR(5) The currency code this supplier uses for their costs.
CURRENCYCODE.strCurrencyCode

STRTAXSYSTEMCODE

VARCHAR(10) The code of the tax system this supplier uses.
TAXSYSTEM.strTaxSystemCode

INTCHANGEFLAG

INT An auto-incrementing number that is set when the supplier is changed. This is used by EOD processes to determine what has changed since the EOD processes were last run.

INTNEWFLAG

INT Similar to INTCHANGEFLAG but is set when a new supplier is added.

INTCHANGECOST

INT Similar to INTCHANGEFLAG but is set when a new supplier is added cost related details such as supplier fees or trading terms have been changed.

INTDELIVERYDAYS

INT The number of days that it can take to deliver an item.

INTSORTPO

INT

Controls the sequence in which the line items of purchase orders, goods receipts and invoices will be displayed.

0   Line# Sequence
1   IPN
2   Order Code
3   Description
4   D/C/G/SG/Description

STRWAREHOUSELOCATION

VARCHAR(10)

The code of the warehouse location that this supplier represents if any.

TRADUNIT.strTradeCode

YSNGRDISCREP

VARCHAR(1)

Indicates if the GR discrepancy report should be generated.

YSNGRMANUALDISCREP

VARCHAR(1)

Indicates if the GR discrepancy report should be generated for manual GRs.

YSNGREMAILDISCREP

VARCHAR(1)

Indicates if the GR discrepancy report should be emailed.

INTMAXDAYSADVANCE INT(4)

The maximum number of days in advance an order can be placed for a supplier.

This will define the dates available in the ‘Required By’ field on the purchase orders basic tab.

 

Primary Key: STRSUPPLIERCODE

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