MYOB EXO Business Stock

Attribute details

Attribute: ABSENT

Table	STAFF
Comment	This field is set to 'Y' if the staff member is currently absent, i.e. if their Absent flag is ticked in EXO Business Configurator.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ACCGROUP

Table	GLACCS
Comment	The GL account's Account Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ACCNO

Table	SUPPLIER_STOCK_ITEMS
Comment	The ID number of the supplier (Creditor) account.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: ACCNO

Table	CR_INVLINES
Comment	The account number of the Creditor that the transaction belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCS.ACCNO

Attribute: ACCNO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: ACCNO

Table	INWARDS_GOODS_COSTS
Comment	The supplier (Creditor account ID).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCS.ACCNO

Attribute: ACCNO

Table	DR_INVLINES
Comment	The account number of the Debtor that the transaction belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	DR_TRANS.ACCNO

Attribute: ACCNO

Table	GLACCS
Comment	The unique GL account number.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: ACCNO

Table	STOCKREQUIREMENT
Comment	The ID number of the stock item's supplier (from CRACCS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ACCNO

Table	STOCK_TRANS
Comment	For manual stock movements this field is NULL. For movements originating from other ledgers, this contains the account number against the source transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: ACCOUNT_STATUS

Table	STAFF
Comment	The staff member's account status. Will be one of: 0 = Account OK 1 = Account Locked 2 = Password Expired
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: ACTUALREORD

Table	STOCKREQUIREMENT
Comment	Actual reorder quantity for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ACTUAL_COST

Table	STOCK_SERIALNOS
Comment	The actual cost of the item when moved into stock.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: AGE

Table	INWARDS_GOODS_COSTS
Comment	The invoice's age. This is calculated based on PERIOD_SEQNO.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: AGE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: AGE

Table	STOCK_TRANS
Comment	Calculated field that indicates the age of the transaction.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: AGE

Table	STOCK_TRANS_HDR
Comment	Calculated field that indicates the age the record belongs to.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: AGE_STAMP

Table	STOCK_TRANS
Comment	This is a historical field that has been superseded by the AGE calculated field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: AGE_STAMP

Table	INWARDS_GOODS_LINES
Comment	This is a historical field that has been superseded by the AGE calculated field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: AGE_STAMP

Table	INWARDS_GOODS_COSTS
Comment	This is a historical field that has been superseded by the AGE calculated field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: AGE_STAMP

Table	STOCK_TRANS_HDR
Comment	This is a historical field that has been superseded by the AGE calculated field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: ALERT

Table	STOCK_ITEMS
Comment	Text of the pop-up alert message that appears when the stock item is sold or purchased.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to

Attribute: ALLOWJOURNAL

Table	GLACCS
Comment	This field is set to 'Y' if the GL account allows journals.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ALT_AVECOST

Table	STOCK_TRANS
Comment	Alternate weighted average cost.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALT_AVECOST

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALT_QUANTITY

Table	STOCK_TRANS
Comment	Alternate quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALT_QUANTITY

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALT_SEQNO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: ALT_SEQNO

Table	STOCK_TRANS
Comment	Alternate SEQNO.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: ANALYSIS

Table	DR_INVLINES
Comment	GL code for the Stock line. Can be overridden. The visibility of this column onscreen is controlled by the profile "Enable display and override of GL code from stock item".
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ANALYSIS

Table	CR_INVLINES
Comment	GL code for the Stock line. Can be overridden. The visibility of this column onscreen is controlled by the profile "Enable display and override of GL code from stock item".
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: API_ACCESS

Table	STAFF
Comment	This field contains 'Y' if the staff member is authorised to use the EXO API.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: APP_PASSWORD

Table	STAFF
Comment	The staff member's password, used when logging in to the EXO Business system. Passwords are stored in an encrypted format.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ASSIGNED_LINESEQNO

Table	STOCK_SERIALNOS
Comment	The line ID of the record that the serial number is linked to. The details of type of record can be determined from the ISASSIGNED field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: ASSIGNED_SEQNO

Table	STOCK_SERIALNOS
Comment	The header ID of the record that the serial number is linked to. The details of type of record can be determined from the ISASSIGNED field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: AUTH_AMT

Table	STAFF
Comment	The staff member's Credit Invoice Authorisation Limit.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: AUTOBUILD

Table	BILLOMAT_HDR
Comment	Applies to Build type BOMs. This field is set to 'Y' if the BOM's "AutoBuild" option is ticked. This gives the option of building an out-of-stock BOM immediately instead of placing it on backorder.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: AUTOCODE

Table	STOCK_GROUP2S
Comment	The One-off Stock Item autocode prefix for the group.
Primary key	No
Data type	VARCHAR(10)
Domain name
Not NULL	No
Default
Refers to

Attribute: AUTOCODE

Table	STOCK_GROUPS
Comment	The One-off Stock Item autocode prefix for the group.
Primary key	No
Data type	VARCHAR(10)
Domain name
Not NULL	No
Default
Refers to

Attribute: AUTOCODENO

Table	STOCK_GROUPS
Comment	The One-off Stock Item autocode suffix for the group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: AUTOCODENO

Table	STOCK_GROUP2S
Comment	The One-off Stock Item autocode suffix for the group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: AUTO_NARRATIVE

Table	STOCK_ITEMS
Comment	The setting of the stock item's Auto Narrative property. Will be one of: 0=No 1=Yes with Blank 2=Yes with Notes
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AVECOST

Table	STOCK_ITEMS
Comment	The stock item's Average Cost Price.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BAD_LOGIN_COUNT

Table	STAFF
Comment	The number of times the staff member has attempted to log in but failed.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: BALANCE

Table	GLACCS
Comment	The account's balance.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BALANCE_SHEET_TYPE

Table	GLACCS
Comment	For balance sheet accounts, this field indicates the balance sheet type. Will be one of: -1 = Not a balance sheet account 0 = Asset 1 = Liability 2 = Equity
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: BALSHEETACCTOT

Table	GLACCS
Comment	The balance sheet total for the account.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: BARCODE1

Table	STOCK_ITEMS
Comment	Barcode/alternate code 1.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: BARCODE1

Table	STOCKTAKE_TOTALS
Comment	Barcode/alternate code 1.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: BARCODE2

Table	STOCK_ITEMS
Comment	Barcode/alternate code 2.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: BARCODE3

Table	STOCK_ITEMS
Comment	Barcode/alternate code 3.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	CR_INVLINES
Comment	The batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	STOCK_TRANS
Comment	The batch number.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	INWARDS_GOODS_LINES
Comment	The batch code on the line.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	STOCKTAKE_TOTALS
Comment	The batchcode for the stock item.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	DR_INVLINES
Comment	The batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	STOCK_REQUESTLINES
Comment	The batch code on the line.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHNO

Table	INWARDS_GOODS_LINES
Comment	The batch number on the record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: BATCHQUANTITY

Table	BILLOMAT_TEMP
Comment	The batch quantity on the record.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCH_QTY

Table	BILLOMAT_HDR
Comment	The BOM's Batch Quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	1
Refers to

Attribute: BILLCODE

Table	BILLOMAT_HDR
Comment	The BOM's unique ID code.
Primary key	Yes
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: BILLCODE

Table	BILLOMAT_LINES
Comment	The ID code of the BOM header (BILLOMAT_HDR.BILLCODE).
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	BILLOMAT_HDR.BILLCODE

Attribute: BILLCODE

Table	BILLOMAT_TEMP
Comment	The BOM code.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	BILLOMAT_HDR.BILLCODE

Attribute: BINCODE

Table	STOCK_ITEMS
Comment	Bincode for the stock item.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: BINCODE

Table	STOCK_LOC_INFO
Comment	The stock item's bin or shelf code at the location.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: BINCODE

Table	STOCKTAKE_TOTALS
Comment	The Bin Code for the stock item being counted.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: BKORDQTY

Table	DR_INVLINES
Comment	Back Order Qty from the Sales Order.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BOMBATCHSEQNO

Table	BILLOMAT_TEMP
Comment	The BOM batch ID number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: BOMPRICING

Table	CR_INVLINES
Comment	How Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMPRICING

Table	DR_INVLINES
Comment	How Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMPRICING

Table	INWARDS_GOODS_LINES
Comment	C = BOM priced by Component, T = BOM priced by total, N = Normal
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMPRICING

Table	STOCK_REQUESTLINES
Comment	How Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMTYPE

Table	INWARDS_GOODS_LINES
Comment	The Bill of Materials type on the line. Will be one of: N = Normal K = Kit B = Build L = Linked
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMTYPE

Table	DR_INVLINES
Comment	The type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMTYPE

Table	BILLOMAT_HDR
Comment	The type of BOM. Will be one of: K = Kit B = Build O = Order Template
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	K
Refers to

Attribute: BOMTYPE

Table	CR_INVLINES
Comment	The type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMTYPE

Table	STOCK_REQUESTLINES
Comment	The type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BRANCHNO

Table	INWARDS_GOODS_LINES
Comment	The ID number of the branch on the record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	BRANCHES.BRANCHNO

Attribute: BRANCHNO

Table	STOCK_GROUP2S
Comment	The ID number of the group's branch (from BRANCHES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	BRANCHES.BRANCHNO

Attribute: BRANCHNO

Table	CR_INVLINES
Comment	The branch number. Lines generally inherit the branch specified on the invoice header.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BRANCHNO

Table	STOCK_GROUPS
Comment	The ID number of the group's branch (from BRANCHES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	BRANCHES.BRANCHNO

Attribute: BRANCHNO

Table	STOCK_ITEMS
Comment	Branch number for the stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BRANCHNO

Table	DR_INVLINES
Comment	The branch number. Lines generally inherit the branch specified on the invoice header.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CALCREORD

Table	STOCKREQUIREMENT
Comment	Reorder quantity, calculated taking into account minimum stock, maximum stock and available free stock.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CAN_SPREAD

Table	INWARDS_GOODS_COSTS
Comment
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: CLASSNAME

Table	STOCK_CLASSIFICATIONS
Comment	The name of the classification.
Primary key	No
Data type	VARCHAR(100)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: CLASSNO

Table	STOCK_CLASSIFICATIONS
Comment	A unique ID number for the classification.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: CODETYPE

Table	DR_INVLINES
Comment	The type of code on the line. Will be one of: G - GL code S - Stock code
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	S
Refers to

Attribute: CODETYPE

Table	CR_INVLINES
Comment	The type of code on the line. Will be one of: G - GL code S - Stock code
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: COGSMETHOD

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: COLOURCODE

Table	STOCK_COLOUR
Comment	A user-defined ID code for the colour.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: COLOURID

Table	STOCK_COLOUR
Comment	A unique ID number for the colour.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: COLOURNAME

Table	STOCK_COLOUR
Comment	A descriptive name for the colour.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: COMMENT

Table	STOCK_REQUESTLINES
Comment	The comment entered on the line, if any.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: COMPLETE

Table	INWARDS_GOODS
Comment	This field contains 'Y' if the receipt has been completed.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: COMPLETE

Table	INWARDS_GOODS_COSTS
Comment	Indicates if the line has been marked as completed, which controls whether or not the line can be edited.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: COMPLETE

Table	INWARDS_GOODS_LINES
Comment	This field contains 'Y' if the inwards goods receipt has been completed (and therefore cannot be altered).
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: COMPNO

Table	STOCK_SERIALNOS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: COMPONENTLOCATION

Table	BILLOMAT_TEMP
Comment	The location of the BOM component stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: CONTRACT_HDR

Table	DR_INVLINES
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: COST

Table	INWARDS_GOODS_COSTS
Comment	The cost in local currency.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: COSTCODE

Table	INWARDS_GOODS_COSTS
Comment	The on cost code for the record.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: COSTED_PERIOD_SEQNO

Table	INWARDS_GOODS
Comment	The period to which the receipt belongs.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: COSTGROUP

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: COSTPRICE

Table	BILLOMAT_HDR
Comment	Cost price for the BOM.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: COSTTYPE

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: COST_GROUP

Table	CR_INVLINES
Comment	This field only applies if EXO Job Costing is installed. It identifies the Cost Group that the transaction belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: COST_GROUP

Table	INWARDS_GOODS_LINES
Comment	If the order originates from a job, this field records the ID number of the job's cost group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOB_COSTGROUPS.SEQNO

Attribute: COST_TYPE

Table	INWARDS_GOODS_LINES
Comment	If the order originates from a job, this field records the ID number of the job's cost type.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOB_COSTTYPES.SEQNO

Attribute: COST_TYPE

Table	CR_INVLINES
Comment	This field only applies if EXO Job Costing is installed. It identifies the Cost Type that the transaction belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: COS_GLSUBCODE

Table	STOCK_GROUPS
Comment	The code of the GL subaccount for Cost of Sales.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: COS_GLSUBCODE

Table	STOCK_ITEMS
Comment	The Cost of Sales sub-account updated in the General Ledger when the stock item is sold.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: COS_GL_CODE

Table	STOCK_ITEMS
Comment	The Cost of Sales account updated in the General Ledger when this stock item is sold.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: COS_GL_CODE

Table	STOCK_GROUPS
Comment	The code of the GL account for Cost of Sales.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: COUNTQTY

Table	STOCKTAKE_TOTALS
Comment	The physical count taken for the item at this location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CREATED_DATE

Table	GLACCS
Comment	The date and time that the GL account was created.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: CREDITQTY

Table	DR_INVLINES
Comment	Contains the sum of quantities which have been a part of credit notes against the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: CRINVLINEID

Table	CR_INVLINES
Comment	A unique ID for the invoice line, which should be used to link to other tables. Every time an invoice is edited, the lines are essentially removed and reinserted again, which changes the SEQNO. However, the CRINVLINEID field retains its value. Hence, any relationships built on this field are still valid in such a scenario.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CRINVLINESEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Creditors Invoice line that the item is linked to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: CRINVSEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Creditors Invoice that the item has been receipted in against.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: CR_ACCNO

Table	STOCK_SERIALNOS
Comment	The ID number of the related Creditor account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: CUBIC

Table	STOCK_ITEMS
Comment	Cubic weight of the item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CURRENCYNO

Table	GLACCS
Comment	The ID number of the currency that the GL account is in.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CURRENCIES.CURRENCYNO

Attribute: CURRENCYNO

Table	CR_INVLINES
Comment	The ID number of the currency used on the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CURRENCIES.CURRENCYNO

Attribute: CURRENCYNO

Table	DR_INVLINES
Comment	The currency number for the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CURRENCIES.CURRENCYNO

Attribute: CUSTOMFIELD

Table	DR_INVLINES
Comment
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: CUSTOM_FILTER

Table	STOCKTAKE_CTRL
Comment	This field contains the custom SQL filter defined for the location, if there is one.
Primary key	No
Data type	VARCHAR(100)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: CUSTORDERNO

Table	STOCK_REQUESTS
Comment	The customer order number, if there is one.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: DATAX_EXCHANGE_FLAG

Table	STOCK_GROUP2S
Comment
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	I
Refers to

Attribute: DATAX_EXCHNO

Table	STOCK_GROUP2S
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DATAX_SITE_NO2

Table	STOCK_GROUP2S
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DATAX_SOURCE_SITE

Table	STOCK_GROUP2S
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DEFAULTWARRANTYNO

Table	STOCK_ITEMS
Comment	The default Warranty No for the stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: DEFDAYS

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DELADDR1

Table	STOCK_LOCATIONS
Comment	Line 1 of the location's address.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR2

Table	STOCK_LOCATIONS
Comment	Line 2 of the location's address.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR3

Table	STOCK_LOCATIONS
Comment	Line 3 of the location's address.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR4

Table	STOCK_LOCATIONS
Comment	Line 4 of the location's address.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR5

Table	STOCK_LOCATIONS
Comment	Line 5 of the location's address.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR6

Table	STOCK_LOCATIONS
Comment	Line 6 of the location's address.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	STOCK_REQUESTLINES
Comment	The description of the stock item on the line.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.DESCRIPTION

Attribute: DESCRIPTION

Table	DR_INVLINES
Comment	Description of the Stock item on this line.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	CR_INVLINES
Comment	Description of the Stock item on this line.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	STOCKTAKE_TOTALS
Comment	The description of the stock item being counted.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	BILLOMAT_HDR
Comment	A descriptive name for the BOM.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	STOCKREQUIREMENT
Comment	The stock item's description.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	SUPPLIER_STOCK_ITEMS
Comment	The supplier's description for the stock item.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	INWARDS_GOODS_LINES
Comment	The description of the stock item on the line.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	BILLOMAT_LINES
Comment	The description of the stock item on this line.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	STOCK_ITEMS
Comment	The stock item's description.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DETAILS

Table	INWARDS_GOODS_COSTS
Comment	Details of the on cost.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: DIMENSIONS

Table	STOCK_ITEMS
Comment	How the dimensions of the stock item are specified. Will be one of: 0=None 1=Length 2=Square 3=Cubic
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DISCOUNT

Table	DR_INVLINES
Comment	The percentage discount for the Stock item on this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNT

Table	INWARDS_GOODS_LINES
Comment	The discount percentage on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNT

Table	SUPPLIER_STOCK_ITEMS
Comment	The percentage discount when purchasing the stock item from the supplier.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNT

Table	CR_INVLINES
Comment	The percentage discount for the Stock item on this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNTAMT

Table	CR_INVLINES
Comment	The discount amount on a stock line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNTLEVEL

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNTPCT

Table	CR_INVLINES
Comment	The discount percentage on a stock line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNTRATE

Table	STAFF
Comment	The staff member's Discount Rate Limit.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DISPLAY_NAME

Table	STOCK_REQUESTTYPES
Comment	The name of the request type.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: DRCR

Table	GLACCS
Comment	This field is set to 'C' for Credit accounts or 'D' for Debit accounts.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	D
Refers to

Attribute: DRINVLINEID

Table	DR_INVLINES
Comment	A unique ID for the invoice line, which should be used to link to other tables. Every time an invoice is edited, the lines are essentially removed and reinserted again, which changes the SEQNO. However, the DRINVLINEID field retains its value. Hence, any relationships built on this field are still valid in such a scenario.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DRINVLINESEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Debtors Invoice line that the item is linked to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: DR_ACCNO

Table	STOCK_SERIALNOS
Comment	The ID number of the related Debtor account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: DUTY

Table	STOCK_ITEMS
Comment	The duty percentage on the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DUTYCOST

Table	INWARDS_GOODS_LINES
Comment	The duty cost on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ECONORDERQTY

Table	STOCK_ITEMS
Comment	The economic order quantity (EOQ) for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: ECONORDERQTY

Table	SUPPLIER_STOCK_ITEMS
Comment	The Minimum Order Quantity for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: EMAIL_ADDRESS

Table	STAFF
Comment	The staff member's email address.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: EMPLOYEE_CODE

Table	STAFF
Comment	This field is used by the payroll integration functionality.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: EXCHRATE

Table	INWARDS_GOODS_COSTS
Comment	The exchange rate.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: EXCHRATE

Table	INWARDS_GOODS_LINES
Comment	The exchange rate on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: EXCHRATE

Table	CR_INVLINES
Comment	The exchange rate for the line at the time of the transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	1
Refers to

Attribute: EXCHRATE

Table	DR_INVLINES
Comment	The exchange rate for the line at the time of the transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	1
Refers to

Attribute: EXCLUDE_FROMFREE_STOCK

Table	STOCK_LOCATIONS
Comment	This field contains 'Y' if the location's "Exclude from Free Stock" option is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: EXCLUDE_FROMSALES

Table	STOCK_LOCATIONS
Comment	This field contains 'Y' if the location's "Exclude from Sales" option is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: EXCLUDE_FROMVALUATION

Table	STOCK_LOCATIONS
Comment	This field contains 'Y' if the location's "Exclude from Valuation" option is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: EXCLUDE_FROM_REVAL

Table	GLACCS
Comment	If this field is set to 'Y', the account is excluded from revaluation.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: EXPECTEDPROFIT

Table	STOCK_GROUPS
Comment	The expected profit margin for the group.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: EXPIRY_DATE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: EXPIRY_DATE

Table	STOCK_TRANS
Comment	The Expiry Date for a batch tracked item.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: EXPIRY_DATE

Table	INWARDS_GOODS_LINES
Comment	The expiry date of the stock item, if there is one.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: EXPIRY_DATE

Table	STOCKTAKE_TOTALS
Comment	The date when the stock item batch expires.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: EXPIRY_DATE

Table	STOCK_SERIALNOS
Comment	The expiry date on the record.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	Yes
Default	getdate()
Refers to

Attribute: EXPIRY_DAYS

Table	STOCKTAKE_TOTALS
Comment	The number of days until the stock item batch expires.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	1
Refers to	STOCK_ITEMS.EXPIRY_DAYS

Attribute: EXPIRY_DAYS

Table	STOCK_ITEMS
Comment	Number of days before expiry of the stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	1
Refers to

Attribute: EXTENSION

Table	STAFF
Comment	The staff member's telephone extension.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: FACEBOOK_ACCESS_TOKEN

Table	STAFF
Comment	If the staff member uses their own Facebook account when using the EXO Business social media functions, their encrypted access token is stored here.
Primary key	No
Data type	VARCHAR(max)
Domain name
Not NULL	No
Default
Refers to

Attribute: FC_COST

Table	INWARDS_GOODS_COSTS
Comment	The cost in the currency of the supplier account.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: FILENAME

Table	STOCK_GROUPS
Comment	This field contains the filename of the website picture for the group.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: FILENAME

Table	STOCK_GROUP2S
Comment	This field contains the filename of the website picture for the group.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: FIXEDCOST

Table	INWARDS_GOODS_LINES
Comment	The fixed cost on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: FREIGHT_FREE

Table	DR_INVLINES
Comment	'Y' or 'N' depending on whether the line is freight free. This comes from the price policy for the line.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FROM_HDR

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: FROM_HDR

Table	STOCK_TRANS
Comment	For manual stock movements this field contains STOCK_TRANS_HDR.SEQNO. For other types of movements, it contains the SEQNO of the header table of source transactions.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: FROM_LEDGER

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: FROM_LEDGER

Table	STOCK_TRANS
Comment	d = Debtor c = Creditor s = Stock j = Job Costing i = Inwards Goods Receipt o = Sales Orders p = Purchase Orders
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: FROM_LOC

Table	STOCK_REQUESTS
Comment	The ID number of the location that stock is to be transferred from.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: FXCOST

Table	INWARDS_GOODS_LINES
Comment	The cost on the line in local currency.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: FX_VAR

Table	INWARDS_GOODS_LINES
Comment	The foreign exchange variance applicable to the line at the time of invoicing.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: FX_VAR

Table	INWARDS_GOODS_COSTS
Comment	The foreign exchange variance applicable to the invoice raised against this record.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLACC

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLACC

Table	STOCK_TRANS
Comment	The General Ledger Account that is affected when the transaction is posted to GL.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: GLACCNO

Table	CR_INVLINES
Comment	GL account number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLBATCH

Table	INWARDS_GOODS_COSTS
Comment	GL batch number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLBATCHNO

Table	INWARDS_GOODS
Comment	The GL batch number on the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: GLBATCHNO

Table	STOCK_TRANS
Comment	ID number of the GL Batch that the posted stock journal belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLBATCHNO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLBRANCH

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLBRANCH

Table	STOCK_TRANS
Comment	The Branch used for posting to the General Ledger.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLPOSTED

Table	INWARDS_GOODS_COSTS
Comment	This field contains 'Y' if a GL journal exists for the record.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: GLPOSTED

Table	STOCK_TRANS
Comment	This field contains 'Y' if the transaction has been posted to the General Ledger.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: GLPOSTED

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: GLSUBACC

Table	CR_INVLINES
Comment	SL sub-account number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLSUBACC

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLSUBACC

Table	STOCK_TRANS
Comment	The General Ledger Sub Account that is affected when the transaction is posted to GL.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GROUP2_SEQNO

Table	STOCK_GROUPS
Comment	The ID number of the related Alternate Stock Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_GROUP2S.GROUPNO

Attribute: GROUPNAME

Table	STOCK_PRICEGROUPS
Comment	The Price Group's name.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: GROUPNAME

Table	STOCK_GROUP2S
Comment	The group's name/description.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: GROUPNAME

Table	STOCK_GROUPS
Comment	The group's name/description.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: GROUPNO

Table	STOCK_GROUPS
Comment	A unique ID code for the group.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: GROUPNO

Table	STOCK_PRICEGROUPS
Comment	A unique ID number for the Price Group.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: GROUPNO

Table	STOCK_GROUP2S
Comment	A unique ID number for the group.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: HAS_BN

Table	STOCK_ITEMS
Comment	This field is set to 'Y' if the stock item is batch tracked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: HAS_BN

Table	STOCKTAKE_TOTALS
Comment	This field is set to 'Y' if the stock item is batch tracked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to	STOCK_ITEMS.HAS_BN

Attribute: HAS_BUDGETS

Table	STAFF
Comment	This field is set to 'Y' if the staff member has been assigned a Sales Team Budget, i.e. if their Has Budget flag is ticked in EXO Business Configurator.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: HAS_EXPIRY

Table	STOCK_ITEMS
Comment	This field is set to 'Y' if the stock item has an expiry date. This flag is only available in the UI if the "Use expiry dates for batched & serial numbers" profile setting is enabled.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: HAS_EXPIRY

Table	STOCKTAKE_TOTALS
Comment	This field is set to 'Y' if the stock item has an expiry date.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to	STOCK_ITEMS.HAS_EXPIRY

Attribute: HAS_SN

Table	STOCK_ITEMS
Comment	This field is set to 'Y' if the stock item is serial number tracked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: HDR_SEQNO

Table	DR_INVLINES
Comment	The SEQNO of the record in the DR_TRANS table that this record related to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	DR_TRANS.SEQNO

Attribute: HDR_SEQNO

Table	CR_INVLINES
Comment	The SEQNO of the record in the CR_TRANS table that this record related to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_TRANS.SEQNO

Attribute: HDR_SEQNO

Table	STOCK_REQUESTLINES
Comment	The ID number of the stock transfer request that the line belongs to (from STOCK_REQUESTS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	STOCK_REQUESTS.SEQNO

Attribute: HDR_SEQNO

Table	INWARDS_GOODS_LINES
Comment	The ID number of the header Inwards Goods record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	INWARDS_GOODS.SEQNO

Attribute: HIDDEN

Table	DR_INVLINES
Comment
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: HIDDEN_COST

Table	DR_INVLINES
Comment	This field applies to Bills of Materials. For kits that use pricing by components, this field stores the header-level cost. For builds that use individual stocklines, this fields stores the lines' real costs.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: HIDDEN_SELL

Table	DR_INVLINES
Comment	This field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level sell prices For builds that use individual stocklines, this fields stores the lines' real prices.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: HIDE_LINES

Table	BILLOMAT_HDR
Comment	This field is set to 'Y' if the BOM's "Hide lines on reports" option is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: HOMEPHONE

Table	STAFF
Comment	The staff member's home telephone number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: IGRLINESEQNO

Table	CR_INVLINES
Comment	ID number of the Inwards Goods receipt line (if the source of the line is from Inwards Goods).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: IGRLINESEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Inwards Goods line that the item is linked to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: IGRSEQNO

Table	STOCK_SERIALNOS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INC_FIFO_STOCKTAKE

Table	STOCK_TRANS
Comment	Not supported.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: INC_FIFO_STOCKTAKE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: INSTOCK

Table	STOCK_SERIALNOS
Comment	This field contains 'Y' if the serial number is in stock.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: INSTOCKQTY

Table	STOCKREQUIREMENT
Comment	Physical stock.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTERCO_BATCH_DESC

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the batch description.
Primary key	No
Data type	VARCHAR(80)
Domain name
Not NULL	No
Default
Refers to

Attribute: INTERCO_COMPANYNO

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the Company ID number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTERCO_CR_ACCNO

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the Creditor GL account number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTERCO_CR_BRANCHNO

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the Creditor branch number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTERCO_CR_SUBACCNO

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the Creditor GL sub-account number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTERCO_DR_ACCNO

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the Debtor GL account number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTERCO_DR_BRANCHNO

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the Debtor branch number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTERCO_DR_SUBACCNO

Table	CR_INVLINES
Comment	This field only applies if EXO InterCompany is used. It contains the Debtor GL sub-account number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INTRANS_QUANT

Table	STOCK_REQUESTLINES
Comment	The In Transit Qty on the line.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: INVNO

Table	CR_INVLINES
Comment	The invoice number.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: INVNO

Table	DR_INVLINES
Comment	The invoice number.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: INVOICED

Table	INWARDS_GOODS
Comment	This field contains 'Y' if the receipt has been invoiced.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: INVOICE_NOW

Table	INWARDS_GOODS_COSTS
Comment
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INVSEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Debtors Invoice ID the item has been sold against.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: INV_AGE

Table	INWARDS_GOODS_LINES
Comment	The invoice's age. This is calculated based on PERIOD_SEQNO.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: INV_COMPLETE

Table	INWARDS_GOODS_LINES
Comment	This field contains 'Y' if the invoice is complete.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: INV_COST

Table	INWARDS_GOODS_COSTS
Comment	The invoiced amount in local currency.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INV_COST

Table	INWARDS_GOODS_LINES
Comment	The cost as on the related invoice, in local currency.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INV_EXCHRATE

Table	INWARDS_GOODS_LINES
Comment	The exchange rate applicable to the invoice line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INV_EXCHRATE

Table	INWARDS_GOODS_COSTS
Comment	The exchange rate applicable to the invoice.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INV_FC_COST

Table	INWARDS_GOODS_LINES
Comment	The cost as on the related invoice.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INV_FC_COST

Table	INWARDS_GOODS_COSTS
Comment	The invoiced amount in the currency of the supplier account.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INV_QUANT

Table	INWARDS_GOODS_LINES
Comment	The invoiced quantity on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: INV_TRANSDATE

Table	INWARDS_GOODS_LINES
Comment	The transaction date of the invoice related to this line.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: INWARDS_GOODS_SEQNO

Table	INWARDS_GOODS_COSTS
Comment	The ID number of the Inwards Goods header record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	INWARDS_GOODS.SEQNO

Attribute: INWGLID

Table	INWARDS_GOODS_LINES
Comment	An ID number for the inwards goods lines record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ISACTIVE

Table	STOCK_LOCATIONS
Comment	This field contains 'Y' if the location is active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	STOCK_SIZE
Comment	This field contains 'Y' if the size is currently active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	BILLOMAT_HDR
Comment	This field contains 'Y' if the BOM is active; otherwise it is inactive.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	STOCK_COLOUR
Comment	This field contains 'Y' if the colour is currently active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	GLACCS
Comment	This field contains 'Y' if the GL account is active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	STOCK_ITEMS
Comment	If this field is set to 'Y', the stock item is active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	STAFF
Comment	This field is set to 'Y' if the staff member is currently active, i.e. if their Active flag is ticked in EXO Business Configurator.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: ISACTIVE

Table	STOCK_GROUPS
Comment	This field contains 'Y' if the group is currently active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	STOCKTAKE_CTRL
Comment	This field contains 'Y' is the location is currently active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: ISASSIGNED

Table	STOCK_SERIALNOS
Comment	N = Not assigned o = assigned to a Sales Order i = assigned to inwards goods j = assigned to Job Costing q = assigned to a stock request p = assigned to a POS parked Sales Order P = assigned to a POS parked invoice
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: IS_DEFAULT

Table	SUPPLIER_STOCK_ITEMS
Comment
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: IS_DISCOUNTABLE

Table	STOCK_ITEMS
Comment	This field is set to 'Y' if the stock item is discountable.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: IS_SUPERVISOR

Table	STAFF
Comment	This field is set to 'Y' if the staff member is designated as a supervisor, i.e. if their Has supervisory override authority flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: IS_WIPLOCATION

Table	STOCK_LOCATIONS
Comment	This field contains 'Y' if the location represents Work in Progress in EXO Job Costing.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: JOBCODE

Table	DR_INVLINES
Comment	If the line originates from a job, the job's code is recorded in this field.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: JOBCODE

Table	CR_INVLINES
Comment	If the line originates from a job, the job's code is recorded in this field.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: JOBLINESEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the job line that the item is linked to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: JOBNO

Table	INWARDS_GOODS_LINES
Comment	If the order originates from a job, this field records the ID number of the job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

Table	STOCK_SERIALNOS
Comment	The ID number of the job that the serial number belongs to (if there is one).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: JOBNO

Table	STOCK_TRANS
Comment	Job Number if the stock movement sources from a job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: JOBNO

Table	DR_INVLINES
Comment	If the line originates from a job, the job's ID number is recorded in this field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: JOBNO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: JOBNO

Table	CR_INVLINES
Comment	If the line originates from a job, the job's ID number is recorded in this field.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: JOBTITLE

Table	STAFF
Comment	The staff member's job title.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: JOB_CONTRACT_BILLINGS_SEQNO

Table	DR_INVLINES
Comment	If the invoice is related to a Progress Billing invoice in EXO Job Costing, the ID number of that invoice is recorded here (from JOB_CONTRACT_BILLINGS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: KITCODE

Table	CR_INVLINES
Comment	The Bill of Materials code, if the line is part of a BOM.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITCODE

Table	STOCK_SERIALNOS
Comment
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITCODE

Table	INWARDS_GOODS_LINES
Comment	The ID code of the Bill of Materials on the line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITCODE

Table	DR_INVLINES
Comment	The Bill of Materials code, if the line is part of a BOM.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITCODE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITCODE

Table	STOCK_TRANS
Comment	Code of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITID_SERIAL

Table	STOCK_SERIALNOS
Comment
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITSEQNO

Table	BILLOMAT_TEMP
Comment	The ID number of the BOM.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: KITSEQNO

Table	INWARDS_GOODS_LINES
Comment	The ID number of the Bill of Materials on the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: KITSEQNO

Table	DR_INVLINES
Comment	A Bill of Materials SEQNO used to group BOM lines together.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: KITSEQNO

Table	STOCK_TRANS
Comment	ID number of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: KITSEQNO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: KITSEQNO

Table	CR_INVLINES
Comment	A Bill of Materials SEQNO used to group BOM lines together.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: KIT_TYPE

Table	BILLOMAT_HDR
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: LABEL_QTY

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: LASTINVSEQNO

Table	INWARDS_GOODS
Comment	The ID number of the last invoice generated against the receipt.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: LASTMONTHUNITS

Table	STOCK_ITEMS
Comment	Units of stock item sold in the previous month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LASTMONTHVALUE

Table	STOCK_ITEMS
Comment	Sales value for the previous month for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LASTUPDATED

Table	STOCK_SERIALNOS
Comment	The date and time when the record was last updated.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	Yes
Default	getdate()
Refers to

Attribute: LASTYEARUNITS

Table	STOCK_ITEMS
Comment	Units of stock item sold in for the previous year.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LASTYEARVALUE

Table	STOCK_ITEMS
Comment	Sales value for last year.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LAST_BAD_LOGIN

Table	STAFF
Comment	The date and time when the staff member last attempted to log in but failed.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: LAST_LOGIN

Table	STAFF
Comment	The date and time when the staff member last successfully logged in.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: LAST_UPDATE

Table	SUPPLIER_STOCK_ITEMS
Comment	The date when the record was last updated (not set automatically - it must be specified on the Alternate Suppliers / Stock Codes window).
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: LAST_UPDATED

Table	GLACCS
Comment	The date and time when the GL account was last updated.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: LAST_UPDATED

Table	STOCK_ITEMS
Comment	Date and time when the stock item record was last updated.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: LATESTCOST

Table	SUPPLIER_STOCK_ITEMS
Comment	The supplier's latest cost for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LATESTCOST

Table	STOCK_ITEMS
Comment	The stock item's Last Cost Price.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LCODE

Table	STOCK_LOCATIONS
Comment	A short alphanumeric ID code for the location.
Primary key	No
Data type	VARCHAR(8)
Domain name
Not NULL	No
Default
Refers to

Attribute: LCOST

Table	INWARDS_GOODS_LINES
Comment	The landed cost on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: LINETAX_OVERRIDDEN

Table	CR_INVLINES
Comment	Contains 'Y' if the tax on the line has been manually modified.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETAX_OVERRIDDEN

Table	DR_INVLINES
Comment	Contains 'Y' if the tax on the line has been manually modified.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL

Table	DR_INVLINES
Comment	A computed field containing the total value for the line, excluding tax.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL

Table	CR_INVLINES
Comment	A computed field containing the total value for the line, excluding tax.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL_INCTAX

Table	DR_INVLINES
Comment	A computed field containing the total value for the line, including tax.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL_INCTAX

Table	CR_INVLINES
Comment	A computed field containing the total value for the line, including tax.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL_TAX

Table	DR_INVLINES
Comment	The tax total for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINETOTAL_TAX

Table	CR_INVLINES
Comment	The tax total for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINETYPE

Table	STOCK_REQUESTLINES
Comment	This field indicates the type of line. Will be one of: 0 = Normal stockline 1 = BOM header line 2 = BOM component line 4 = Narrative line 5 = GL code
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: LINETYPE

Table	INWARDS_GOODS_LINES
Comment	The line type. Will be one of: 0 = Normal line 1 = BOM header 2 = BOM component 4 = Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: LINETYPE

Table	CR_INVLINES
Comment	This field indicates the type of line. Will be one of: 0 = Normal stock line 1 = BOM header line 2 = BOM component line 4 = Narrative line 5 = GL code
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: LINETYPE

Table	DR_INVLINES
Comment	This field indicates the type of line. Will be one of: 0 = Normal stockline 1 = BOM header line 2 = BOM component line 4 = Narrative line 5 = GL code
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: LINE_SEQNO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: LINE_SEQNO

Table	STOCK_TRANS
Comment	For manual stock movements this field is NULL. For movements originating from other ledgers, this contains the Line ID of the source line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: LINE_SOURCE

Table	DR_INVLINES
Comment	The source SEQNO of the line, if it originated from a Sales Order or job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: LINE_SOURCE

Table	CR_INVLINES
Comment	The source SEQNO of the line, if it originated from a Sales Order or job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKEDIN_TOKEN_KEY

Table	STAFF
Comment	If the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token key is stored here.
Primary key	No
Data type	VARCHAR(max)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKEDIN_TOKEN_SECRET

Table	STAFF
Comment	If the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token secret is stored here.
Primary key	No
Data type	VARCHAR(max)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKEDSTATUS

Table	INWARDS_GOODS_LINES
Comment	S = Stock item, L = Lookup item.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: LINKEDSTATUS

Table	STOCK_REQUESTLINES
Comment	Will be one of: S = Stocked L = Lookup N = Not applicable
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: LINKEDSTATUS

Table	CR_INVLINES
Comment	Will be one of: S = Stocked L = Lookup N = Not applicable
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: LINKEDSTATUS

Table	DR_INVLINES
Comment	Will be one of: S = Stocked L = Lookup N = Not applicable
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: LINKED_BILLCODE

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKED_QTY

Table	DR_INVLINES
Comment	The physical stock unit quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKED_QTY

Table	INWARDS_GOODS_LINES
Comment	The linked quantity on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINKED_QTY

Table	STOCK_REQUESTLINES
Comment	The physical stock unit quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKED_QTY

Table	CR_INVLINES
Comment	The physical stock unit quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINKED_STOCKCODE

Table	INWARDS_GOODS_LINES
Comment	The linked stock item code on the line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKED_STOCKCODE

Table	STOCK_REQUESTLINES
Comment	The physical stock unit.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKED_STOCKCODE

Table	DR_INVLINES
Comment	The physical stock unit.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKED_STOCKCODE

Table	CR_INVLINES
Comment	The physical stock unit.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: LISTPRICE

Table	DR_INVLINES
Comment	The original unit price for the Stock item on this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LNAME

Table	STOCK_LOCATIONS
Comment	A descriptive name for the location.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: LOCATION

Table	DR_INVLINES
Comment	The location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	1
Refers to

Attribute: LOCATION

Table	STOCKTAKE_TOTALS
Comment	The ID number of the location where the stock was counted.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCATION

Table	STOCK_LOC_INFO
Comment	The ID number of the location.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCATION

Table	STOCK_TRANS
Comment	ID number of the Location involved in the stock movement.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	1
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCATION

Table	CR_INVLINES
Comment	The location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	1
Refers to

Attribute: LOCATION

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: LOCNAME

Table	STOCKTAKE_CTRL
Comment	The name of the stock location.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: LOCNO

Table	STOCK_SERIALNOS
Comment	The location of the serialised stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCNO

Table	STOCKTAKE_CTRL
Comment	The ID number of the stock location.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCNO

Table	INWARDS_GOODS_LINES
Comment	The ID of the location on the record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCNO

Table	INWARDS_GOODS
Comment	The ID number of the location on the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCNO

Table	STOCKREQUIREMENT
Comment	The ID number of the stock item's location (from STOCK_LOCATIONS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCNO

Table	STOCK_LOCATIONS
Comment	A unique ID number for the location.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: LOGINID

Table	STAFF
Comment	The staff member's login ID. This is the ID used to log in to the EXO Business system.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: LOOKUP_RECOVERABLE

Table	STOCK_TRANS
Comment	This field contains 'Y' if lookup items are recoverable against expenses in EXO Job Costing.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: LOOKUP_RECOVERABLE

Table	STOCK_ITEMS
Comment	If this field contains 'Y', the stock item is a recoverable expense in EXO Job Costing.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: LOST_QUANT

Table	STOCK_REQUESTLINES
Comment
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MAXSTOCK

Table	STOCK_LOC_INFO
Comment	The maximum stock quantity for the stock code at the location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MAXSTOCK

Table	STOCKREQUIREMENT
Comment	The maximum stock level for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MAXSTOCK

Table	STOCK_ITEMS
Comment	The maximum default stock level for each location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MENU_NO

Table	STAFF
Comment	The ID number of the Menu Definition specified for the staff member. Corresponds to the menu's SEQNO field in the MENU_COLLECTION table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	MENU_COLLECTION.SEQNO

Attribute: MINSTOCK

Table	STOCKREQUIREMENT
Comment	The minimum stock level for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MINSTOCK

Table	STOCK_ITEMS
Comment	The minimum default stock level for each location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MINSTOCK

Table	STOCK_LOC_INFO
Comment	The minimum stock quantity for the stock code at the location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MONTHUNITS

Table	STOCK_ITEMS
Comment	Sales totals in terms of quantity for the current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: MONTHVALUE

Table	STOCK_ITEMS
Comment	Sales value for the current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: NAME

Table	STAFF
Comment	The staff member's full name.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: NAME

Table	GLACCS
Comment	The account name.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: NARRATIVE_SEQNO

Table	DR_INVLINES
Comment	The SEQNO for the narrative on this line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	NARRATIVES.SEQNO

Attribute: NARRATIVE_SEQNO

Table	STOCK_REQUESTS
Comment	The ID number for the narrative on this request.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	NARRATIVES.SEQNO

Attribute: NARRATIVE_SEQNO

Table	STOCK_TRANS_HDR
Comment	ID of the narrative on the transaction (entered via manual stock movement).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: NARRATIVE_SEQNO

Table	STOCK_REQUESTLINES
Comment	The ID number for the narrative on this line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	NARRATIVES.SEQNO

Attribute: NARRATIVE_SEQNO

Table	CR_INVLINES
Comment	The SEQNO for the narrative on this line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	NARRATIVES.SEQNO

Attribute: NEW_AVECOST

Table	STOCK_TRANS
Comment	Average cost of the item after this transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: NEW_LOC_QTY

Table	STOCK_TRANS
Comment	Quantity of the item in the location the movement took place after this transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: NEW_QUANTITY

Table	STOCK_TRANS
Comment	Stock on hand of the item after this transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: NEW_SEQORDER

Table	STOCK_TRANS
Comment	New sequence order of the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: NICKNAME

Table	STAFF
Comment	A short nickname for the employee.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: NON_STOCK_AUTH_AMT

Table	STAFF
Comment	The staff member's Non-Stock Purchase Order Authorisation Limit.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: NOTES

Table	INWARDS_GOODS
Comment	Any receipt notes on the transaction.
Primary key	No
Data type	VARCHAR(500)
Domain name
Not NULL	No
Default
Refers to

Attribute: NOTES

Table	STOCK_ITEMS
Comment	Any notes for the stock item.
Primary key	No
Data type	VARCHAR(4096)
Domain name
Not NULL	No
Default
Refers to

Attribute: NOTES

Table	BILLOMAT_HDR
Comment	Any notes recorded for the BOM.
Primary key	No
Data type	VARCHAR(2048)
Domain name
Not NULL	No
Default
Refers to

Attribute: NOTES

Table	GLACCS
Comment	Any notes on the GL account.
Primary key	No
Data type	VARCHAR(4096)
Domain name
Not NULL	No
Default
Refers to

Attribute: NUMDECIMALS

Table	STOCK_ITEMS
Comment	The number of decimal places that can be entered for the stock item's quantity.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: NUM_CARTONS

Table	INWARDS_GOODS
Comment	The number of cartons.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: NUNITPR

Table	DR_INVLINES
Comment	A computed field containing the unit price, taking into account the discount on the line.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: ON_COSTS

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: ON_COSTS

Table	STOCK_TRANS
Comment	On costs (only applicable to lines sourcing from inwards goods receipts).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: OPENINGBAL

Table	GLACCS
Comment	The account's opening balance.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ORDERQTY

Table	DR_INVLINES
Comment	The Order Qty from the Sales Order.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ORIG_SEQNO

Table	STOCK_REQUESTS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: OUTPUT_CODE

Table	BILLOMAT_HDR
Comment	Stock code of the BOM's output item.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: PACK

Table	STOCK_ITEMS
Comment	Describes the unit of sale for pricing, e.g. EACH or PACK.
Primary key	No
Data type	VARCHAR(10)
Domain name
Not NULL	No
Default
Refers to

Attribute: PACKREFERENCE

Table	SUPPLIER_STOCK_ITEMS
Comment	An optional reference code for the pack.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: PACKSLIP

Table	INWARDS_GOODS
Comment	The packing slip reference.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: PACK_SIZE

Table	STOCK_REQUESTLINES
Comment	The pack size of the stock item on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PASSWORD_CHANGED

Table	STAFF
Comment	The date and time when the staff member's password was last changed.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	Yes
Default	getdate()
Refers to

Attribute: PAYROLL_ID

Table	STAFF
Comment	The staff member's Employee ID (Payroll) number. This field is used when EXO Business is integrating with an external payroll system, e.g. MYOB EXO Payroll. It must contain the employee's corresponding ID number in the payroll system.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: PERIOD_SEQNO

Table	STOCK_TRANS
Comment	ID number of the period the transaction belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	PERIOD_STATUS.SEQNO

Attribute: PERIOD_SEQNO

Table	INWARDS_GOODS_COSTS
Comment	The period ID of the invoice linked to this record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	PERIOD_STATUS.SEQNO

Attribute: PERIOD_SEQNO

Table	STOCK_TRANS_HDR
Comment	ID number of the period that the record belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: PERIOD_SEQNO

Table	INWARDS_GOODS_LINES
Comment	The ID number of the period on the invoice linked to this record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	PERIOD_STATUS.SEQNO

Attribute: PERIOD_TRADED_IN_SEQ

Table	STOCK_TRANS
Comment	This field contains 'N' if the transaction was in a prior period.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: PHONE

Table	STAFF
Comment	The staff member's work telephone number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: PICTURE_URL

Table	STOCK_WEB
Comment	The URL of the picture to be displayed for the stock item.
Primary key	No
Data type	VARCHAR(80)
Domain name
Not NULL	No
Default
Refers to

Attribute: PLU

Table	STOCK_TRANS
Comment	Price Lookup Unit (applies to lookup items).
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: PLU

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: POSTTIME

Table	STOCK_TRANS
Comment	A timestamp of when the record was entered.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: POSTTIME

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: POST_LOOKUP_TO_GL

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: POST_LOOKUP_TO_GL

Table	STOCK_TRANS
Comment	If this field contains 'N' and the stock item is a lookup item, there is no journal against the transaction.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: POST_TO_GL

Table	STOCK_TRANS
Comment	If this field is set to 'Y', the stock line is posted to GL; otherwise it is not.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: POST_TO_GL

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: PO_INVLINESEQNO

Table	STOCK_SERIALNOS
Comment	The invoice line ID linked to the Purchase Order for the serial number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: PO_INVSEQNO

Table	STOCK_SERIALNOS
Comment	The invoice ID linked to the Purchase Order for the serial number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: PO_LINE_NUM

Table	INWARDS_GOODS_LINES
Comment	The ID number of the related Purchase Order line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	PURCHORD_LINES.SEQNO

Attribute: PO_NUMBER

Table	INWARDS_GOODS_LINES
Comment	The ID number of the related Purchase Order header.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	PURCHORD_HDR.SEQNO

Attribute: PQTY

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	1
Refers to

Attribute: PREV_AVECOST

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PREV_AVECOST

Table	STOCK_TRANS
Comment	Average cost of the stock item before this transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PREV_QUANTITY

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PREV_QUANTITY

Table	STOCK_TRANS
Comment	Quantity of the stock item before the transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PRICEPERKG

Table	STOCK_ITEMS
Comment	The stock item's sell price per kg.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: PRICEQTY

Table	STOCK_ITEMS
Comment	The stock item's sell price per quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: PRICE_OVERRIDDEN

Table	DR_INVLINES
Comment	Contains 'Y' if the price on the line has been manually modified.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: PRICING_MODE

Table	BILLOMAT_HDR
Comment	How the output item is priced. 0 = Priced by total. 1 = Priced by components.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PRIVATE_ACC

Table	GLACCS
Comment	This field is set to 'Y' if the GL account is a private account.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: PRODUCTLOCATION

Table	BILLOMAT_TEMP
Comment	The location of the BOM product stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: PROFITVARIANCE

Table	STOCK_GROUPS
Comment	The expected margin variance for the group.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PURCHORDLINESEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Purchase Order line that the item is linked to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: PURCHORDNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Purchase Order that the item has been receipted in against.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: PURCHORDQTY

Table	STOCKREQUIREMENT
Comment	Incoming stock.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PURCHPACKPRICE

Table	SUPPLIER_STOCK_ITEMS
Comment	The Pack Cost when purchasing the stock item from the supplier.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: PURCHPACKPRICE

Table	INWARDS_GOODS_LINES
Comment	The purchase pack price on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: PURCHPACKQUANT

Table	SUPPLIER_STOCK_ITEMS
Comment	The Qty per Pack when purchasing the stock item from the supplier.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: PURCHPACKQUANT

Table	INWARDS_GOODS_LINES
Comment	The purchase pack quantity on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: PURCHTAXRATE

Table	STOCK_ITEMS
Comment	Default GST rate for purchase transactions.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: PURCH_GLSUBCODE

Table	STOCK_GROUPS
Comment	The code of the GL subaccount for Purchases Clearing.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PURCH_GLSUBCODE

Table	STOCK_ITEMS
Comment	The default GL sub-account code that purchase transactions for this stock item are posted to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PURCH_GL_CODE

Table	STOCK_ITEMS
Comment	The GL code that purchase transactions for this stock are posted to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: PURCH_GL_CODE

Table	STOCK_GROUPS
Comment	The code of the GL account for Purchases Clearing.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: QTY

Table	STOCK_LOC_INFO
Comment	The current stock quantity for the stock code at the location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: QTY_TRADED_IN_NEG

Table	STOCK_TRANS
Comment	Quantity traded when total stock on hand for the item was in negative at the time of the transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: QUANTITY

Table	BILLOMAT_LINES
Comment	The quantity on this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	1
Refers to

Attribute: QUANTITY

Table	BILLOMAT_TEMP
Comment	The quantity of the BOM component item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: QUANTITY

Table	CR_INVLINES
Comment	The quantity for this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: QUANTITY

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: QUANTITY

Table	STOCK_TRANS
Comment	Quantity of stock.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: QUANTITY

Table	INWARDS_GOODS_LINES
Comment	The receipt quantity on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: QUANTITY

Table	DR_INVLINES
Comment	The quantity for this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: RECEIPT_NO

Table	STOCK_TRANS
Comment	Receipt number when the source of the transaction is an Inwards Goods Receipt.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: RECEIPT_NO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: REF1

Table	STOCK_TRANS
Comment	Source transaction reference. Usually contains the Debtor/Creditor's invoice number, Purchase Order number, Sales Order number, job number, etc.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: REF1

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: REF2

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: REF2

Table	STOCK_TRANS
Comment	Reference text with details of source of this stock movement.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: REFERENCE

Table	STOCK_SERIALNOS
Comment	A reference code for the record.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: REFERENCE

Table	STOCK_TRANS_HDR
Comment	Reference text for the transaction.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: REFERENCECODE

Table	BILLOMAT_TEMP
Comment	A reference code for the record.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: RELATED_SEQNO

Table	INWARDS_GOODS
Comment	For reversals, this field contains the source Inwards Goods ID number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: REPORTCODE

Table	GLACCS
Comment	The report code used by the GL account.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: REPORTCODE

Table	STOCK_GROUPS
Comment	A report code for the group.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: REPORTCODE

Table	STOCK_GROUP2S
Comment	A report code for the group.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: REPORTS_TO_STAFFNO

Table	STAFF
Comment	The ID number of the staff member that this staff member reports to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: REQUESTLINESEQNO

Table	STOCK_SERIALNOS
Comment	Stock request Line ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: REQUESTSEQNO

Table	STOCK_SERIALNOS
Comment	Stock request ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: REQUEST_DATE

Table	STOCK_REQUESTS
Comment	The date and time when the request was created.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: REQUIRE_DATE

Table	STOCK_REQUESTS
Comment	The date and time that the request must be completed by.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: REQ_QUANT

Table	STOCK_REQUESTLINES
Comment	The Requested Qty on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: RESTRICTED_ITEM

Table	STOCK_ITEMS
Comment	This field is set to 'Y' if the stock item is a restricted item.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: REVERSALSTATUS

Table	INWARDS_GOODS
Comment	The reversal status. Will be one of: 0 = Normal 1 = Reversed 2 = Reversal
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: REVERSED

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: REVERSED

Table	STOCK_TRANS
Comment	This field contains 'Y' if the transaction has been reversed.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: RMALINESEQNO

Table	STOCK_SERIALNOS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: RMASEQNO

Table	STOCK_SERIALNOS
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SALES0

Table	STOCKREQUIREMENT
Comment	Current month sales quantity for the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES1

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item for the month prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES10

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item ten months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES11

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item eleven months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES12

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item twelve months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES2

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item two months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES3

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item three months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES4

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item four months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES5

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item five months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES6

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item six months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES7

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item seven months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES8

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item eight months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES9

Table	STOCKREQUIREMENT
Comment	Sales quantity for the stock item nine months prior to current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALESORDLINESEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Sales Order line that the item is linked to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: SALESORDNO

Table	STOCK_SERIALNOS
Comment	The ID number of the Sales Order ID that the item has been committed against.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: SALESORDQTY

Table	STOCKREQUIREMENT
Comment	Committed stock.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALESTAXRATE

Table	STOCK_ITEMS
Comment	Default GST rate for sales transactions.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SALES_GLSUBCODE

Table	STOCK_GROUPS
Comment	The code of the GL subaccount for Sales.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES_GLSUBCODE

Table	STOCK_ITEMS
Comment	The default GL sub-account code that sales transactions for this stock item are posted to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALES_GL_CODE

Table	STOCK_ITEMS
Comment	The default GL code that sales transactions for this stock item are posted to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: SALES_GL_CODE

Table	STOCK_GROUPS
Comment	The code of the GL account for Sales.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: SALES_HTML

Table	STOCK_WEB
Comment	The Sales text (HTML) for the specified stock item.
Primary key	No
Data type	VARCHAR(4096)
Domain name
Not NULL	No
Default
Refers to

Attribute: SECTION

Table	GLACCS
Comment	This field is set to 0 for Profit and loss accounts or 1 for Balance sheet accounts.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SECURITYPROFILEID

Table	STAFF
Comment	The ID number of the staff member's Security profile. Corresponds to the profile's ID field in the PROFILE table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: SELLPRICE1

Table	STOCK_ITEMS
Comment	Sell price 1.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE1

Table	BILLOMAT_HDR
Comment	Sell price 1.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE10

Table	STOCK_ITEMS
Comment	Sell price 10.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE10

Table	BILLOMAT_HDR
Comment	Sell price 10.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE2

Table	STOCK_ITEMS
Comment	Sell price 2.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE2

Table	BILLOMAT_HDR
Comment	Sell price 2.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE3

Table	STOCK_ITEMS
Comment	Sell price 3.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE3

Table	BILLOMAT_HDR
Comment	Sell price 3.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE4

Table	BILLOMAT_HDR
Comment	Sell price 4.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE4

Table	STOCK_ITEMS
Comment	Sell price 4.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE5

Table	STOCK_ITEMS
Comment	Sell price 5.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE5

Table	BILLOMAT_HDR
Comment	Sell price 5.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE6

Table	BILLOMAT_HDR
Comment	Sell price 6.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE6

Table	STOCK_ITEMS
Comment	Sell price 6.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE7

Table	STOCK_ITEMS
Comment	Sell price 7.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE7

Table	BILLOMAT_HDR
Comment	Sell price 7.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE8

Table	BILLOMAT_HDR
Comment	Sell price 8.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE8

Table	STOCK_ITEMS
Comment	Sell price 8.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE9

Table	BILLOMAT_HDR
Comment	Sell price 9.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SELLPRICE9

Table	STOCK_ITEMS
Comment	Sell price 9.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: SEND_NOW

Table	STOCK_REQUESTLINES
Comment	The Send Now quantity on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SENT_QUANT

Table	STOCK_REQUESTLINES
Comment	The Sent Qty on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SEQNO

Table	STOCK_REQUESTLINES
Comment	A unique ID number for the stock transfer request line.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	BILLOMAT_TEMP
Comment	A unique ID number for the record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	STOCK_SERIALNOS
Comment	A unique ID number for the record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	BILLOMAT_LINES
Comment	A unique ID number for the line.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	STOCK_REQUESTTYPES
Comment	A unique ID number for the request type.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	INWARDS_GOODS_COSTS
Comment	A unique ID number for the record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	INWARDS_GOODS_LINES
Comment	A unique ID number for the record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	STOCK_TRANS_HDR
Comment	A unique ID for the record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	INWARDS_GOODS
Comment	A unique ID number for the transaction.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	CR_INVLINES
Comment	A unique transaction line ID.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	STOCK_TRANS
Comment	A unique ID for the record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	STOCKTAKE_TOTALS
Comment	A unique ID number for the stocktake line.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	DR_INVLINES
Comment	A unique transaction ID.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

Table	STOCK_REQUESTS
Comment	A unique ID number for the transfer request
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SERIALNO

Table	STOCK_SERIALNOS
Comment	The serial number assigned to the stock item.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: SERIALNO

Table	DR_INVLINES
Comment
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: SERIALNO_TYPE

Table	STOCKTAKE_TOTALS
Comment	How the stock item is serialised. Will be one of: 0 = Not Serialised 1 = Fully Tracked (In & Internal & Out) 2 = Creditor & Internal (In & Internal) 3 = Debtor Only (Out only) 4 = Creditor & Debtor (In & Out Only) 5 = Creditor Only (In Only) 6 = Internal & Debtor (Internal & Out only) 7 = Internal Only
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_ITEMS.SERIALNO_TYPE

Attribute: SERIALNO_TYPE

Table	STOCK_ITEMS
Comment	How the stock item is serialised. Will be one of: 0 = Not Serialised 1 = Fully Tracked (In & Internal & Out) 2 = Creditor & Internal (In & Internal) 3 = Debtor Only (Out only) 4 = Creditor & Debtor (In & Out Only) 5 = Creditor Only (In Only) 6 = Internal & Debtor (Internal & Out only) 7 = Internal Only
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: SESSION_ID

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SESSION_ID

Table	STOCK_TRANS
Comment	Session ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SESSION_ID

Table	INWARDS_GOODS
Comment	The session ID for the record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SHIPMENTNO

Table	INWARDS_GOODS_COSTS
Comment	The shipment number on the record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SHIPMENTNO

Table	INWARDS_GOODS_LINES
Comment	The shipment number on the record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: SHIPMENTNO

Table	INWARDS_GOODS
Comment	The shipment number on the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: SHOWLINE

Table	STOCK_REQUESTLINES
Comment	This field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SHOWLINE

Table	INWARDS_GOODS_LINES
Comment	This field is used to control the visibility of the line on Clarity forms.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SHOWLINE

Table	DR_INVLINES
Comment	This field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SHOWLINE

Table	CR_INVLINES
Comment	This field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SIZECODE

Table	STOCK_SIZE
Comment	A user-defined code number for the size.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SIZEID

Table	STOCK_SIZE
Comment	A unique ID number for the size.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SIZENAME

Table	STOCK_SIZE
Comment	A descriptive name for the size.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: SMTP_SEQNO

Table	STAFF
Comment	Where emails are sent via SMTP using the EXO Business Email Sender, this field contains the ID of the SMTP settings that apply to the staff member (SMTP_ACCOUNT.SEQNO). Set up via the SMTP Server Settings window.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SOLINEID

Table	STOCK_REQUESTLINES
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: SORTORDER

Table	STOCK_SIZE
Comment	This field contains the sort order value, which is used to order sizes on the Style Picker window.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SORTORDER

Table	STOCK_COLOUR
Comment	This field contains the sort order value, which is used to order colours on the Style Picker window.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SO_INVLINESEQNO

Table	STOCK_SERIALNOS
Comment	The invoice line ID linked to the Sales Order for the serial number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: SO_INVSEQNO

Table	STOCK_SERIALNOS
Comment	The invoice ID linked to the Sales Order for the serial number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: SPREAD_TYPE

Table	INWARDS_GOODS_COSTS
Comment	The spread type for on costs: 0 = Quantity 1 = Value 2 = Weight 3 = Cubic
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: STAFFNO

Table	BILLOMAT_TEMP
Comment	The ID number of the staff member on the record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to	STAFF.STAFFNO

Attribute: STAFFNO

Table	STOCK_TRANS_HDR
Comment	ID number of the staff member who entered the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	STAFF.STAFFNO

Attribute: STAFFNO

Table	STOCK_REQUESTS
Comment	The ID number of the staff member assigned to the request.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STAFF.STAFFNO

Attribute: STAFFNO

Table	STAFF
Comment	A unique identifier for the staff record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: STATUS

Table	STOCK_GROUPS
Comment	This field contains 'Y' if the 'Display on website option' for the group is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: STATUS

Table	STOCK_REQUESTS
Comment	The status of the stock transfer. Will be one of: 0 = New Request 1 = Picking 2 = In Transit 3 = Complete
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: STATUS

Table	STOCK_GROUP2S
Comment	This field contains 'Y' if the 'Display on website option' for the group is ticked.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: STATUS

Table	STOCK_ITEMS
Comment	The stock item's status. Will be one of: S = Stock item L = Lookup item
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	L
Refers to

Attribute: STDCOST

Table	STOCK_ITEMS
Comment	The stock item's standard cost.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: STKMOVLINESEQNO

Table	STOCK_SERIALNOS
Comment	Stock transaction ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: STKMOVSEQNO

Table	STOCK_SERIALNOS
Comment	Stock transaction header ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: STOCKCODE

Table	BILLOMAT_TEMP
Comment	The stock code of the BOM component item.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCK_TRANS
Comment	The ID code of the stock item.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: STOCKCODE

Table	CR_INVLINES
Comment	Code of the Stock item on this line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCKTAKE_TOTALS
Comment	The ID code of the stock item being counted.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	DR_INVLINES
Comment	Code of the Stock item on this line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCK_WEB
Comment	The stock code of the stock item that this record applies to.
Primary key	No
Data type	CHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCK_ITEMS
Comment	A unique ID code for the stock item.
Primary key	Yes
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: STOCKCODE

Table	STOCK_SERIALNOS
Comment	The stock code of the serialised stock item.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	SUPPLIER_STOCK_ITEMS
Comment	The stock item's ID code in EXO Business.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	INWARDS_GOODS_LINES
Comment	The stock code of the stock item on the line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCK_LOC_INFO
Comment	The unique ID code of the stock item.
Primary key	Yes
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCK_REQUESTLINES
Comment	The ID code of the stock item on the line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	BILLOMAT_LINES
Comment	The stock code of the stock item on this line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	STOCKREQUIREMENT
Comment	The stock item's ID code.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKGROUP

Table	STOCKREQUIREMENT
Comment	The ID number of the stock item's Primary Stock Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_GROUPS.GROUPNO

Attribute: STOCKGROUP

Table	STOCK_ITEMS
Comment	The Primary (Fine) Stock Group that the item belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_GROUPS.GROUPNO

Attribute: STOCKGROUP

Table	STOCKTAKE_TOTALS
Comment	The Stock Group that the stock item belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_GROUPS.GROUPNO

Attribute: STOCKGROUP2

Table	STOCK_ITEMS
Comment	The stock item's Secondary (Coarse) Stock Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_GROUP2S.GROUPNO

Attribute: STOCKGROUP2

Table	STOCKTAKE_TOTALS
Comment	The Alternative Stock Group
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_GROUP2S.GROUPNO

Attribute: STOCKGROUP2_REPC

Table	STOCKTAKE_TOTALS
Comment	The report code of the stock item's Secondary Stock Group.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to	STOCK_GROUP2S.REPORTCODE

Attribute: STOCKGROUP_REPC

Table	STOCKTAKE_TOTALS
Comment	The report code of the stock item's Primary Stock Group.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to	STOCK_GROUPS.REPORTCODE

Attribute: STOCKINSEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the stock transaction that the item was receipted in against.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: STOCKOUTSEQNO

Table	STOCK_SERIALNOS
Comment	The ID number of the stock transaction against which the item was moved out of inventory.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: STOCKPRICEGROUP

Table	STOCK_ITEMS
Comment	The price group that the stock item belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_PRICEGROUPS.GROUPNO

Attribute: STOCK_AUTH_AMT

Table	STAFF
Comment	The staff member's Stock Purchase Order Authorisation Limit.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: STOCK_CLASSIFICATION

Table	STOCK_ITEMS
Comment	The stock classification that the item belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	STOCK_CLASSIFICATIONS.CLASSNO

Attribute: SUBCODE

Table	DR_INVLINES
Comment	The GL subaccount code on the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SUPPLIERCODE

Table	INWARDS_GOODS_LINES
Comment	The supplier code on the line.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: SUPPLIERCODE

Table	SUPPLIER_STOCK_ITEMS
Comment	The supplier's ID code for the stock item.
Primary key	Yes
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SUPPLIERCOST

Table	STOCK_ITEMS
Comment	The supplier cost price.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: SUPPLIERNAME

Table	INWARDS_GOODS
Comment	The name of the supplier on the transaction.
Primary key	No
Data type	VARCHAR(70)
Domain name
Not NULL	No
Default
Refers to

Attribute: SUPPLIERNO

Table	STOCK_ITEMS
Comment	The ID number (CR_ACCS.ACCNO) of the stock item's main supplier.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCS.ACCNO

Attribute: SUPPLIERNO

Table	INWARDS_GOODS
Comment	The ID number of the supplier (Creditor) account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	CR_ACCS.ACCNO

Attribute: SUPPLIERNO

Table	STOCKTAKE_TOTALS
Comment	The ID number of the Creditor who supplies the stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SUPPLIERNO2

Table	STOCK_ITEMS
Comment	Alternate supplier for the stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: SUPPLIERNO3

Table	STOCK_ITEMS
Comment	Alternate supplier for the stock item.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: SUPPLIERREF

Table	INWARDS_GOODS
Comment	The shipping reference on the transaction.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: SUP_NOW

Table	STOCK_REQUESTLINES
Comment	The Receive Now quantity on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SUP_QUANT

Table	STOCK_REQUESTLINES
Comment	The Received Qty on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SU_SEQNO

Table	STOCK_SERIALNOS
Comment	Serviceable Unit ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SWATCHID

Table	STOCK_COLOUR
Comment	The colour value of the colour record's swatch.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SYSTEMQTY

Table	STOCKTAKE_TOTALS
Comment	The quantity recorded in the EXO Business system for the item at this location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TAXRATE

Table	CR_INVLINES
Comment	The percentage tax rate on the line at the time of the transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: TAXRATE

Table	DR_INVLINES
Comment	The percentage tax rate on the line at the time of the transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: TAXRATE_NO

Table	CR_INVLINES
Comment	The ID number of the tax rate used by the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	TAX_RATES.SEQNO

Attribute: TAXRATE_NO

Table	DR_INVLINES
Comment	The ID number of the tax rate used by the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	TAX_RATES.SEQNO

Attribute: TAXSTATUS

Table	GLACCS
Comment	The Override GST rate specified for the GL account. A value of -1 corresponds to the AUTO SELECT RATE option.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TIME_COUNTSHEETS

Table	STOCKTAKE_CTRL
Comment	The date and time when count sheets were printed for the location.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: TIME_INITIALISED

Table	STOCKTAKE_CTRL
Comment	The date and time when the location was initialised for stocktake.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: TIME_KEYED

Table	STOCKTAKE_CTRL
Comment	The date and time when counted quantities were keyed for the location.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: TIME_UPLOADED

Table	STOCKTAKE_CTRL
Comment	The date and time when stock transactions were uploaded to the Stock ledger.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: TOLOCATION

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: TOLOCATION

Table	STOCK_TRANS
Comment	ID of the Destination location (applies in case of stock transfers).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: TOTALSTOCK

Table	STOCK_ITEMS
Comment	Total units of stock for the item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: TO_LOC

Table	STOCK_REQUESTS
Comment	The ID number of the location that stock is to be transferred to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TRANSDATE

Table	STOCK_TRANS_HDR
Comment	The date and time when the transaction took place.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	Yes
Default
Refers to

Attribute: TRANSDATE

Table	BILLOMAT_TEMP
Comment	The date and time when the transaction occurred.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: TRANSDATE

Table	DR_INVLINES
Comment	The date of the transaction.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: TRANSDATE

Table	STOCK_TRANS
Comment	The date when the stock movement took place.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: TRANSDATE

Table	INWARDS_GOODS
Comment	The transaction date.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: TRANSDATE

Table	INWARDS_GOODS_COSTS
Comment	The transaction date of the invoice linked to this record.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: TRANSDATE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: TRANSTYPE

Table	STOCK_TRANS_HDR
Comment	The transaction type. Will be one of: 0=Sales 1=Receipt 2=Transfer 3=Adjust Out 4=Adjust In 5=Average Cost Adjustment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: TRANSTYPE

Table	STOCK_REQUESTS
Comment	The ID number of the Stock Request Type (from STOCK_REQUESTTYPES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STOCK_REQUESTTYPES.SEQNO

Attribute: TRANSTYPE

Table	STOCK_TRANS
Comment	The type of the transaction. Will be one of: 0=Sales 1=Receipt 2=Transfer 3=Adjust Out 4=Adjust In 5=Average Cost Adjustment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TRANSTYPE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: TWITTER_TOKEN_KEY

Table	STAFF
Comment	If the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token key is stored here.
Primary key	No
Data type	VARCHAR(max)
Domain name
Not NULL	No
Default
Refers to

Attribute: TWITTER_TOKEN_SECRET

Table	STAFF
Comment	If the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token secret is stored here.
Primary key	No
Data type	VARCHAR(max)
Domain name
Not NULL	No
Default
Refers to

Attribute: UNITCOST

Table	STOCKTAKE_TOTALS
Comment	The unit cost for the stock item. Unit costs are only entered during stock take if the "Initialise cost prices" stock take option is enabled.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITCOST

Table	STOCK_TRANS
Comment	The unit cost price of the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: UNITCOST

Table	DR_INVLINES
Comment	The unit cost of the Stock item on this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITCOST

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: UNITNO

Table	STOCK_SERIALNOS
Comment	The ID number of the serviceable unit that the item is linked to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: UNITPRICE

Table	CR_INVLINES
Comment	The unit price of the Stock item on this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITPRICE

Table	DR_INVLINES
Comment	The unit price of the Stock item on this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITPRICE

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: UNITPRICE

Table	INWARDS_GOODS_LINES
Comment	The unit price of the stock item on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITPRICE

Table	BILLOMAT_TEMP
Comment	The unit price of the BOM component item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: UNITPRICE

Table	STOCK_TRANS
Comment	Unit price of the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITPRICE_INCTAX

Table	CR_INVLINES
Comment	The unit price of the Stock item on this line, inclusive of tax.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITPRICE_INCTAX

Table	DR_INVLINES
Comment	The unit price of the Stock item on this line, inclusive of tax.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UPDATEITEM_CODE

Table	STOCK_ITEMS
Comment	Only applies to lookup items. The ID number of the stocked item that maintains the actual stock.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: UPDATEITEM_FLAG

Table	STOCK_TRANS
Comment	This field contains 'Y' for a normal stocked item, 'T' for a linked stock code, or 'U' for a transaction created for the SKU of the linked stock code.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: UPDATEITEM_FLAG

Table	STOCK_TRANS_ARCHIVE
Comment	See STOCK_TRANS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: UPDATEITEM_QTY

Table	STOCK_ITEMS
Comment	Only applies to lookup items. Quantity of the stocked item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UPDATE_STOCK

Table	CR_INVLINES
Comment	If this field is set to 'Y', stock movements are created via the trigger CR_INVLINES_POST. The field is then set to 'T'.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: UPDATE_STOCK

Table	DR_INVLINES
Comment	If this field is set to 'Y', stock movements are created via the trigger DR_INVLINES_POST. The field is then set to 'T'.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: USERPROFILEID

Table	STAFF
Comment	The ID number of the staff member's User profile. Corresponds to the profile's ID field in the PROFILE table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: USESUBCODES

Table	GLACCS
Comment	Not used.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: VALUE_TRADED_IN_NEG

Table	STOCK_TRANS
Comment	Value traded when total stock on hand for the item was in negative at the time of the transaction.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: VARIABLECOST

Table	STOCK_ITEMS
Comment	The field is set to 'Y for Variable Cost stock items.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: VARIANCE

Table	STOCKTAKE_TOTALS
Comment	The difference between the system quantity and the counted quantity. Populated automatically when the Stocktake Variance Report is run for the Stock Take utility.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: VARIANTLINE

Table	BILLOMAT_LINES
Comment	This field contains 'Y' if the line is not included in the BOM by default.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: VAR_GLPOSTED

Table	INWARDS_GOODS_LINES
Comment	This field contains 'Y' if variance has been posted against this line.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: VIRTSTOCK

Table	STOCKREQUIREMENT
Comment	Free stock taking into account the incoming and committed stock.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: WASTAGE

Table	BILLOMAT_HDR
Comment	The BOM's Overhead Allocation percentage.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: WEB_SHOW

Table	STOCK_ITEMS
Comment
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: WEIGHT

Table	STOCK_ITEMS
Comment	Physical weight of the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: WORKSORDLINESEQNO

Table	STOCK_SERIALNOS
Comment	Works Order Line ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: WORKSORDSEQNO

Table	STOCK_SERIALNOS
Comment	Works order ID
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: X_BINCODE

Table	STOCK_GROUPS
Comment	The bin code for the style.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: X_COLOURID

Table	STOCK_ITEMS
Comment	Style colour ID of the stock item. Used by the Style, Size Colour functionality.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_COLOURIDS

Table	STOCK_GROUPS
Comment	This field contains a comma-separated list of colour IDs applicable to the style.
Primary key	No
Data type	VARCHAR(255)
Domain name
Not NULL	No
Default
Refers to

Attribute: X_DESCRIPTION_FORMULA

Table	STOCK_GROUPS
Comment	The stock item description formula for the group.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: X_ISSTYLE

Table	STOCK_GROUPS
Comment	This field contains 'Y' if the group is a style.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: X_MAXSTOCK

Table	STOCK_GROUPS
Comment	The maximum stock level for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_MINSTOCK

Table	STOCK_GROUPS
Comment	The minimum stock level for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_PRICEGROUP

Table	STOCK_GROUPS
Comment	This field contains 'Y' if the style has a matching Price Group.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to	STOCK_PRICEGROUPS.GROUPNO

Attribute: X_SELLPRICE1

Table	STOCK_GROUPS
Comment	Sell price 1 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE10

Table	STOCK_GROUPS
Comment	Sell price 10 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE2

Table	STOCK_GROUPS
Comment	Sell price 2 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE3

Table	STOCK_GROUPS
Comment	Sell price 3 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE4

Table	STOCK_GROUPS
Comment	Sell price 4 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE5

Table	STOCK_GROUPS
Comment	Sell price 5 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE6

Table	STOCK_GROUPS
Comment	Sell price 6 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE7

Table	STOCK_GROUPS
Comment	Sell price 7 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE8

Table	STOCK_GROUPS
Comment	Sell price 8 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SELLPRICE9

Table	STOCK_GROUPS
Comment	Sell price 9 for the style.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SIZEID

Table	STOCK_ITEMS
Comment	Style size ID of the stock item. Used by the Style, Size Colour functionality.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SIZEIDS

Table	STOCK_GROUPS
Comment	This field contains a comma-separated list of size IDs applicable to the style.
Primary key	No
Data type	VARCHAR(255)
Domain name
Not NULL	No
Default
Refers to

Attribute: X_STOCKCODE_FORMULA

Table	STOCK_GROUPS
Comment	The stock item code formula for the group.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: X_SUPPLIERCOST

Table	STOCK_GROUPS
Comment	The supplier cost in the currency of the supplier account.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: X_SUPPLIERNO

Table	STOCK_GROUPS
Comment	The ID number of the main supplier of the style.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: YEARUNITS

Table	STOCK_ITEMS
Comment	Year to date sales totals in terms of quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: YEARVALUE

Table	STOCK_ITEMS
Comment	Sales value for the current year.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to