MYOB EXO Business Job Costing

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	JOBCOST_HDR
Comment	The number of the Debtor account that the job belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	DR_ACCS.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: 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: ACTIONBY

Table	JOBCOST_HDR
Comment	The staff member who is the Job Manager for the job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STAFF.STAFFNO

Attribute: ACTUAL_UNITCOST

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

Attribute: ADMIN_STAT

Table	JOB_STATUS
Comment	If this field contains 'Y', the status prevents entry of new transactions.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
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: ALINENO

Table	JOBCOST_LINES
Comment	A rank ID that determines the order in which lines are displayed.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALINENO

Table	JOB_TRANSACTIONS
Comment	A rank ID that determines the order in which lines are displayed.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: ALLOCATED_COSTS

Table	JOB_CONTRACT_BILLINGS
Comment	The Allocated Costs amount on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: ALLOWANCE

Table	JOB_TRANSACTIONS
Comment	Unit labour allowance associated with the stock item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: ALLOWANCE

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

Attribute: ALLOWANCE_FACTOR

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

Attribute: ALLOWANCE_ID

Table	JOB_TIMESHEET_ALLOWANCE
Comment	The short ID code of the allowance type on this line.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	No
Default
Refers to	JOB_TIMESHEET_ALLOWANCE_TYPES.ALLOWANCE_ID

Attribute: ALLOWANCE_ID

Table	JOB_TIMESHEET_ALLOWANCE_TYPES
Comment	A short ID code for the type.
Primary key	No
Data type	VARCHAR(5)
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: ALLOW_ALLOCATION

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

Attribute: ANALYSIS

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

Attribute: ANALYSIS

Table	JOBCOST_LINES
Comment
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: APPOINTMENT_SCHEDULED

Table	JOB_RESOURCE_ALLOCATION
Comment	This field contains 'Y' if an appointment has been scheduled for the allocation.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
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: ASSET_COST

Table	JOBCOST_HDR
Comment	The cost of the asset(s) created on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ASSET_VALUE

Table	JOBCOST_HDR
Comment	The value of the asset(s) created on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
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: 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: AVECOST_IN

Table	JOB_TRANSACTIONS
Comment	The Average cost of the item coming into the WIP location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: AVECOST_OUT

Table	JOB_TRANSACTIONS
Comment	The Average cost of the item going out of the WIP location
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
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: 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	JOBCOST_LINES
Comment	The batch code on the line, if there is one.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BATCHCODE

Table	JOB_TRANSACTIONS
Comment	Batch code.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BILLINGMODE

Table	JOBCOST_HDR
Comment	The billing mode on the job. Will be one of: 0 = Charge-up 1 = Invoice ex-quote 2 = Manufacture - output items 3 = Progress invoices
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BILLING_ID

Table	JOB_TRANSACTIONS
Comment	The Billing ID, if one exists.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: BILLING_REF

Table	JOB_TRANSACTIONS
Comment	The Billing Reference, if one exists.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

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: BOMPRICING

Table	JOB_TRANSACTIONS
Comment	Will be one of: N = normal C = pricing by component (BOMs) T= pricing by total (BOMs)
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMPRICING

Table	JOBCOST_LINES
Comment	Will be one of: N = normal C = pricing by component (BOMs) T= pricing by total (BOMs)
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMTYPE

Table	JOBCOST_LINES
Comment	Will be one of: N = Normal stock item B = Build K = Kit L = Lookup item
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMTYPE

Table	JOB_TRANSACTIONS
Comment	Will be one of: N = Normal stock item B = Build K = Kit L = Lookup item
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BRANCHNO

Table	JOB_TRANSACTIONS
Comment	The ID number of the branch that the line belongs to (from BRANCHES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	BRANCHES.BRANCHNO

Attribute: BRANCHNO

Table	JOBCOST_HDR
Comment	The job's branch.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	BRANCHES.BRANCHNO

Attribute: BRANCHNO

Table	JOBCOST_LINES
Comment	The ID number of the branch that the line belongs to (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: CALLBACKDATE

Table	JOBCOST_HDR
Comment	The Follow Up date on the job.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: CAMPAIGN_WAVE_SEQNO

Table	JOBCOST_HDR
Comment	The ID number of the campaign wave (EXO CRM) that the job is associated with, if there is one.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to	CAMPAIGN_WAVE.SEQNO

Attribute: CATDESC

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

Attribute: CATEGORY

Table	JOBCOST_HDR
Comment	The ID number of the job's category (from JOB_CATEGORIES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOB_CATEGORIES.CATNO

Attribute: CATNO

Table	JOB_CATEGORIES
Comment	A unique ID number for the Job Category.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
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: COMPLETED

Table	JOBCOST_HDR
Comment	The date when the job was completed.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: CONSOLIDATE

Table	JOB_COSTGROUPS
Comment	This field contains 'T' if the group's "Consolidate" option is ticked; otherwise 'F'.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	F
Refers to

Attribute: CONSOLIDATE

Table	JOB_COSTTYPES
Comment	This field contains 'T' if the type's "Consolidate" option is ticked; otherwise 'F'.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	F
Refers to

Attribute: CONTACT

Table	JOBCOST_HDR
Comment	The contact person associated with the job.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: CONTACTNO

Table	JOBCOST_HDR
Comment	The ID number of the contact person on the job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: COPY_FROM_QUOTE

Table	JOBCOST_LINES
Comment	The destination of quote lines. Will be one of: T = Timesheets tab P = Purchases tab C = Costs tab N = none
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: COPY_FROM_QUOTE

Table	JOB_COSTTYPES
Comment	This field indicates what the group's "Copy from quote to:" option is set to. Will be one of: N = None C = Costs T = Timesheet P = Purchase
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	F
Refers to

Attribute: COPY_FROM_QUOTE

Table	JOB_COSTGROUPS
Comment	This field indicates what the group's "Copy from quote to:" option is set to. Will be one of: N = None C = Costs T = Timesheet P = Purchase
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	F
Refers to

Attribute: COSTDESC

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

Attribute: COSTDESC

Table	JOB_COSTGROUPS
Comment	A descriptive name for the group.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: COSTGL

Table	JOBCOST_HDR
Comment	The Cost GL account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	GLACCS.ACCNO

Attribute: COSTGLSQL

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(500)
Domain name
Not NULL	No
Default
Refers to

Attribute: COSTGROUP

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

Attribute: COSTRATE

Table	JOB_TIMESHEETS_RATES
Comment	The factor by which the cost of transactions entered with this rate type will be multiplied when posting to a job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: COSTRATE0

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

Attribute: COSTRATE1

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

Attribute: COSTRATE2

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

Attribute: COSTRATE3

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

Attribute: COSTSELECTSQL

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(255)
Domain name
Not NULL	No
Default
Refers to

Attribute: COSTSUBGL

Table	JOBCOST_HDR
Comment	The Cost GL sub-account.
Primary key	No
Data type	INTEGER
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_CENTRE

Table	JOBCOST_LINES
Comment	The ID number of the Cost Type on the line (from JOB_COSTTYPES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOB_COSTTYPES.SEQNO

Attribute: COST_CENTRE

Table	JOB_TRANSACTIONS
Comment	Cost Centre ID (only applicable when timesheets are integrated with MYOB EXO Payroll).
Primary key	No
Data type	BIGINT
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: COST_CENTRE2

Table	JOBCOST_LINES
Comment	The ID number of the Cost Group on the line (from JOB_COSTGROUPS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOB_COSTGROUPS.SEQNO

Attribute: COST_GROUP

Table	JOB_TRANSACTIONS
Comment	The ID number of the Cost Group on the line (from JOB_COSTGROUPS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOB_COSTGROUPS.SEQNO

Attribute: COST_GROUP

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

Attribute: COST_LINENO

Table	JOBCOST_LINES
Comment	This field stores the COST_LINENO from DR_INVLINES/DR_INVLINES_PARK.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: COST_LINENO

Table	JOB_TRANSACTIONS
Comment	This field stores the COST_LINENO from DR_INVLINES.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: COST_TYPE

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

Attribute: COST_TYPE

Table	JOB_TRANSACTIONS
Comment	The ID number of the Cost Type on the line (from JOB_COSTTYPES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOB_COSTTYPES.SEQNO

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: 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: CREDIT_SCHEDULE_SEQNO

Table	JOB_TRANSACTIONS
Comment	This field stores the ID number of the Billing Schedule record that the current record was credited in.
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	JOB_TRANSACTIONS
Comment	The ID number of the currency on the line (from CURRENCIES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CURRENCIES.CURRENCYNO

Attribute: CURRENCYNO

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

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	JOB_CONTRACT_BILLINGS
Comment	This field displays the ID number of the currency that the billing record is in.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	CURRENCIES.CURRENCYNO

Attribute: CUSTORDNO

Table	JOBCOST_HDR
Comment	The customer's order number.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: DATAVERSION

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DAY1

Table	JOB_TIMESHEETS
Comment	The number of hours entered for day 1.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY1_NARRATIVE

Table	JOB_TIMESHEETS
Comment	If a narrative has been entered for the day, its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY1_POSTED

Table	JOB_TIMESHEETS
Comment	This field contain 'Y' day's times have been approved.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY2

Table	JOB_TIMESHEETS
Comment	The number of hours entered for day 2.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY2_NARRATIVE

Table	JOB_TIMESHEETS
Comment	If a narrative has been entered for the day, its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY2_POSTED

Table	JOB_TIMESHEETS
Comment	This field contain 'Y' day's times have been approved.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY3

Table	JOB_TIMESHEETS
Comment	The number of hours entered for day 3.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY3_NARRATIVE

Table	JOB_TIMESHEETS
Comment	If a narrative has been entered for the day, its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY3_POSTED

Table	JOB_TIMESHEETS
Comment	This field contain 'Y' day's times have been approved.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY4

Table	JOB_TIMESHEETS
Comment	The number of hours entered for day 4.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY4_NARRATIVE

Table	JOB_TIMESHEETS
Comment	If a narrative has been entered for the day, its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY4_POSTED

Table	JOB_TIMESHEETS
Comment	This field contain 'Y' day's times have been approved.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY5

Table	JOB_TIMESHEETS
Comment	The number of hours entered for day 5.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY5_NARRATIVE

Table	JOB_TIMESHEETS
Comment	If a narrative has been entered for the day, its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY5_POSTED

Table	JOB_TIMESHEETS
Comment	This field contain 'Y' day's times have been approved.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY6

Table	JOB_TIMESHEETS
Comment	The number of hours entered for day 6.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY6_NARRATIVE

Table	JOB_TIMESHEETS
Comment	If a narrative has been entered for the day, its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY6_POSTED

Table	JOB_TIMESHEETS
Comment	This field contain 'Y' day's times have been approved.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY7

Table	JOB_TIMESHEETS
Comment	The number of hours entered for day 7.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY7_NARRATIVE

Table	JOB_TIMESHEETS
Comment	If a narrative has been entered for the day, its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DAY7_POSTED

Table	JOB_TIMESHEETS
Comment	This field contain 'Y' day's times have been approved.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
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: DEFAULT_STOCKCODE

Table	JOBCOST_RESOURCE
Comment	If the resource has a default stockcode, it is recorded here.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEFDAYS

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

Attribute: DEFDAYS

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DEFFOLLOWUPDAYS

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DEFHOURS

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DEFNONSTOCKCODE

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEF_COSTGROUP

Table	JOB_COSTTYPES
Comment	The ID number of the Cost Group that this type belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOB_COSTGROUPS.SEQNO

Attribute: DEF_MARKUP

Table	JOB_COSTGROUPS
Comment	The default markup on the group.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEF_MARKUP

Table	JOB_COSTTYPES
Comment	The default markup percentage for the type.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEF_OVERHEAD

Table	JOB_COSTGROUPS
Comment	The default overhead on the group.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEF_OVERHEAD

Table	JOB_COSTTYPES
Comment	The default overhead percentage for the type.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEF_OVERHEAD

Table	JOBCOST_HDR
Comment	The default overhead on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DEF_PURCH_GLCODE

Table	JOB_COSTTYPES
Comment	The General Ledger code for the Purchasing Account related to this type.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DEF_PURCH_GLSUBCODE

Table	JOB_COSTTYPES
Comment	The General Ledger sub-account code for the Purchasing Account related to this type.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR1

Table	JOBCOST_HDR
Comment	Delivery address line 1.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR2

Table	JOBCOST_HDR
Comment	Delivery address line 2.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR3

Table	JOBCOST_HDR
Comment	Delivery address line 3.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR4

Table	JOBCOST_HDR
Comment	Delivery address line 4.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR5

Table	JOBCOST_HDR
Comment	Delivery address line 5.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR6

Table	JOBCOST_HDR
Comment	Delivery address line 6.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEL_ADDR

Table	JOBCOST_HDR
Comment	Delivery address.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: DESCRIPTION

Table	JOB_STATUS_CONSTRAINT
Comment	A description of the constraint.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: DESCRIPTION

Table	JOBCOST_PROJ
Comment	Descriptive text for the project.
Primary key	No
Data type	TEXT
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

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

Attribute: DESCRIPTION

Table	JOB_TIMESHEETS
Comment	The description of the labour pay item for this line.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	JOB_CONTRACT_BILLINGS
Comment	A descriptive name for the billing record.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: DESCRIPTION

Table	JOB_TIMESHEET_ALLOWANCE
Comment	The description of the allowance type on this line.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to	JOB_TIMESHEET_ALLOWANCE_TYPES.DESCRIPTION

Attribute: DESCRIPTION

Table	JOB_TIMESHEET_ALLOWANCE_TYPES
Comment	Descriptive text for the Allowance Type.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

Table	JOB_OUTPUT_ITEMS
Comment	The description of the output stock item.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.DESCRIPTION

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: DESCRIPTION

Table	JOBCOST_HDR
Comment	The job's description.
Primary key	No
Data type	VARCHAR(5000)
Domain name
Not NULL	No
Default
Refers to

Attribute: DESCRIPTION

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

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: DIM_DEPTH

Table	JOB_TRANSACTIONS
Comment	Dimension depth
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: DIM_DEPTH

Table	JOBCOST_LINES
Comment	Dimension depth.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: DIM_LENGTH

Table	JOB_TRANSACTIONS
Comment	Dimension length
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: DIM_LENGTH

Table	JOBCOST_LINES
Comment	Dimension length.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: DIM_WIDTH

Table	JOB_TRANSACTIONS
Comment	Dimension width
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: DIM_WIDTH

Table	JOBCOST_LINES
Comment	Dimension width.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: DISCOUNT

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

Attribute: DISCOUNT

Table	JOBCOST_LINES
Comment	The percentage discount on the 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: 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: DISP_COLOUR

Table	JOB_CATEGORIES
Comment	Not used.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
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: DUEDATE

Table	JOBCOST_HDR
Comment	The date when the job is due.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: DUE_DATE

Table	JOB_CONTRACT_BILLINGS
Comment	The date that this billing entry is due on.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
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: 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: EMAIL_ADDRESS

Table	JOBCOST_RESOURCE
Comment
Primary key	No
Data type	VARCHAR(40)
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: ENDDATE

Table	JOB_TRANSACTIONS
Comment	The end date on the line (applies to timesheets).
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: ENDTIME

Table	JOB_TRANSACTIONS
Comment	End Time (only applies to timesheets).
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: END_DATE

Table	JOB_RESOURCE_ALLOCATION
Comment	The allocation's end date.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: END_TIME

Table	JOB_RESOURCE_ALLOCATION
Comment	The allocation's end time.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: ENTRYDATE

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

Attribute: ESTIMATE

Table	JOBCOST_HDR
Comment	An estimate of the job's value.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: ESTIMATECOST

Table	JOBCOST_HDR
Comment	The estimated cost of the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: EST_HOURS

Table	JOBCOST_HDR
Comment	Estimated hours on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: EXCHRATE

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

Attribute: EXCHRATE

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

Attribute: EXCHRATE

Table	JOBCOST_HDR
Comment	The exchange rate used by the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: EXCHRATE

Table	JOBCOST_LINES
Comment	The exchange rate applicable to the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
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: 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: FILTERSQL

Table	JOBCOST_RESOURCE
Comment	If the resource uses a SQL statement to filter stock item searches for times, it is recorded here.
Primary key	No
Data type	VARCHAR(100)
Domain name
Not NULL	No
Default
Refers to

Attribute: FLAG01

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 1 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG02

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 2 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG03

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 3 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG04

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 4 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG05

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 5 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG06

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 6 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG07

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 7 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG08

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 8 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG09

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 9 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG10

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 10 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG11

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 11 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG12

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 12 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG13

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 13 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG14

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 14 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAG15

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if custom flag 15 is ticked for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FLAGCODE

Table	JOBCOST_FLAGSDESC
Comment	The Job Flag's ID number.
Primary key	Yes
Data type	VARCHAR(8)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: FLAGDESC

Table	JOBCOST_FLAGSDESC
Comment	The Job Flag's description.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to

Attribute: FROMLOC

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

Attribute: FROMLOC

Table	JOB_TRANSACTIONS
Comment	The location origin for stock movements.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: FROM_STATUS

Table	JOB_STATUS_CONSTRAINT
Comment	The source stage for the constraint.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: FX_PRICE

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

Attribute: GANTTBAR_COLOUR

Table	JOB_TYPES
Comment	A colour code that determines how jobs of this type should appear on the diagram on the Job Overview tab.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GANTTBAR_COLOUR

Table	JOB_STATUS
Comment	A colour code that determines how jobs of this status should appear on the diagram on the Job Overview tab.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GANTTBAR_COLOUR

Table	JOB_CATEGORIES
Comment	A colour code that determines how jobs of this category should appear on the diagram on the Job Overview tab.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLACC_TO_USE

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLCODE

Table	JOB_COSTTYPES
Comment	The General Ledger code for the Sales Account related to this type.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLCODE

Table	JOB_TRANSACTIONS
Comment	The GL account code of the P&L revenue account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: GLCODE

Table	JOB_CONTRACT_BILLINGS
Comment	The ID number of the GL account for this line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	GLACCS.ACCNO

Attribute: GLCODE

Table	JOBCOST_LINES
Comment	The GL account code of the P&L revenue account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	GLACCS.ACCNO

Attribute: GLSUBCODE

Table	JOB_COSTTYPES
Comment	The General Ledger sub-account code for the Sales Account related to this type.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLSUBCODE

Table	JOB_CONTRACT_BILLINGS
Comment	The ID number of the GL sub-account for this line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	GLACCS.ACCNO

Attribute: HASUNBILLED

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

Attribute: HAS_ALLOWANCE

Table	JOB_TIMESHEETS
Comment	This field contains 'Y' if allowances/deductions have been added to the line.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
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_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_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: HIDDEN_COST

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

Attribute: HIDDEN_COST

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

Attribute: HIDDEN_LINETOTAL

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

Attribute: HIDDEN_LINETOTAL

Table	JOB_TRANSACTIONS
Comment	For Kit type BOMs, this field stores the line total against the header line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: HIDDEN_SELL

Table	JOBCOST_LINES
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 stock lines, this field stores the sell price.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: HIDDEN_SELL

Table	JOB_TRANSACTIONS
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 stock lines, this field stores the sell price.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
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: INVLINE_SEQNO

Table	JOB_TRANSACTIONS
Comment	The related Debtor Invoice line ID, if applicable (from DR_INVLINES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to	DR_INVLINES.SEQNO

Attribute: INVNO

Table	JOB_CONTRACT_BILLINGS
Comment	If the line has been invoiced, this field contains the invoice number for the invoice.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: INVOICED

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

Attribute: INVOICED

Table	JOBCOST_HDR
Comment	The amount of the job that has been invoiced.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: INVOICED

Table	JOB_TRANSACTIONS
Comment	The amount invoiced.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: INVOICEDATE

Table	JOB_TRANSACTIONS
Comment	The invoice date
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: INVOICEDCOST

Table	JOBCOST_HDR
Comment	The total cost of all invoiced lines on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: INVOICEDQTY

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

Attribute: INVOICEREADY

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

Attribute: INVOICEREADY

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if the job's Invoice Ready flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: INVSEQNO

Table	JOB_TRANSACTIONS
Comment	The related Debtor Invoice ID, if applicable (from DR_TRANS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to	DR_TRANS.SEQNO

Attribute: INV_SEQNO

Table	JOB_CONTRACT_BILLINGS
Comment	If the line has been invoiced, this field contains the ID number (SEQNO) of the invoice in the DR_TRANS table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: ISACTIVE

Table	JOB_STATUS
Comment	If this field contains 'Y', the status causes the job to be marked as Active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ISACTIVE

Table	JOB_STATUS_CONSTRAINT
Comment	If this field contains 'Y', the constraint applies, so that users are permitted to change a job from the stage specified by the FROM_STATUS to the stage specified by the TO_STATUS.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
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	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	JOBCOST_PROJ
Comment	This field contains 'Y' if the project is currently active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: ISACTIVE

Table	JOBCOST_HDR
Comment	This field contains 'Y' if the job is currently active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
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	JOBCOST_RESOURCE
Comment	This field contains 'Y' if the resource is currently active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: ISACTIVE

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if the job's Active Job flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: ISARCHIVED

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if the job's Archived Job flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ISARCHIVED

Table	JOB_STATUS
Comment	If this field contains 'Y', the status causes the job to be archived.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ISCOMPLETE

Table	JOBCOST_FLAGS
Comment	This field contains 'Y' if the job's Completed flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ISCOMPLETE

Table	JOB_STATUS
Comment	If this field contains 'Y', the status causes the job to be marked as Complete.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ISINVOICEREADY

Table	JOB_STATUS
Comment	If this field contains 'Y', the status causes the job to be marked as Ready for Invoice.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ISLOCKQUOTE

Table	JOB_STATUS
Comment	If this field contains 'Y', the status causes quotations on the job to be read-only.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: ISSUPPLIED

Table	JOB_TRANSACTIONS
Comment	This field contains 'Y' if the line is supplied; otherwise 'N'.
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_OVERTIME

Table	JOB_TIMESHEETS
Comment	This field contains 'Y' if the line is a Special Hours rate.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
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: JOBCAT

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: JOBCODE

Table	JOBCOST_HDR
Comment	An alphanumeric ID code for the job.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: JOBCOSTLINEID

Table	JOBCOST_LINES
Comment	ID of the job line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: JOBLINEID

Table	JOB_TRANSACTIONS
Comment	ID of the job transaction line
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: JOBNO

Table	JOBCOST_FLAGS
Comment	The job's ID number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

Table	JOBCOST_LINES
Comment	The ID number of the job that this line is on.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

Table	JOB_OUTPUT_ITEMS
Comment	The ID number of the job that the item belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

Table	JOB_CONTRACT_BILLINGS
Comment	The ID number of the job that the billing record is attached to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

Table	JOB_HIST
Comment	The ID number of the job that the History Note is attached to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

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

Attribute: JOBNO

Table	JOB_TIMESHEETS
Comment	The ID number of the job that the line relates to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

Table	JOB_QUOTE_OPTIONS
Comment	The ID number of the job that this option applies to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: JOBNO

Table	JOB_RESOURCE_ALLOCATION
Comment	The ID number of the job that the resource is allocated to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO

Table	JOB_TRANSACTIONS
Comment	The ID number of the job that this line is on.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOBCOST_HDR.JOBNO

Attribute: JOBNO_PROMPT

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: JOBSTAT

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
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: JOBTYPE

Table	JOBCOST_HDR
Comment	The ID number of the job's type (from JOB_TYPES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOB_TYPES.TYPENO

Attribute: JOBTYPE

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: KITCODE

Table	JOB_TRANSACTIONS
Comment	The ID code of the Bill of Materials, if the stock line belongs to a one (from BILLOMAT_HDR).
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	BILLOMAT_HDR.BILLCODE

Attribute: KITCODE

Table	JOBCOST_LINES
Comment	The ID code of the Bill of Materials, if the stock line belongs to a one (from BILLOMAT_HDR).
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	BILLOMAT_HDR.BILLCODE

Attribute: KITSEQNO

Table	JOBCOST_LINES
Comment	The ID number of the Bill of Materials, if the stock line belongs to a one.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: KITSEQNO

Table	JOB_TRANSACTIONS
Comment	The ID number of the Bill of Materials, if the stock line belongs to a one.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
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: LABOUR_ALLOWANCE

Table	JOB_TIMESHEETS
Comment
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
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: 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_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: 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: 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: LATESTCOST_IN

Table	JOB_TRANSACTIONS
Comment	The Latest cost of the item coming into the WIP location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LATESTCOST_OUT

Table	JOB_TRANSACTIONS
Comment	The Latest cost of the item going out of the WIP location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINECHARGE

Table	JOB_TRANSACTIONS
Comment	Calculated field giving the total price of the transaction line (excluding discount).
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINECHARGE_WRITEOFF

Table	JOB_TRANSACTIONS
Comment	This field stores the value of LINECHARGE before the line was written off.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINECHARGE_WRITEOFF

Table	JOBCOST_HDR
Comment	This field stores the sum of value of all JOB_TRANSACTIONS.LINECHARGE_WRITEOFF values on the transaction lines.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINECOST

Table	JOB_TRANSACTIONS
Comment	Calculated field giving the cost of the transactions line.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINESORT

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

Attribute: LINETOTAL

Table	JOBCOST_LINES
Comment	Total value of the stock line.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL

Table	JOB_TRANSACTIONS
Comment	Total price of the transaction line including discount.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL_INCTAX

Table	JOBCOST_LINES
Comment	Total value of the line, inclusive of tax.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL_INCTAX

Table	JOB_TRANSACTIONS
Comment	Line total inclusive of discount and tax(Calculated field)
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LINETOTAL_TAX

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

Attribute: LINETOTAL_TAX

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

Attribute: LINETYPE

Table	JOBCOST_LINES
Comment	Will be one of: 0 = normal 1 = BOM header 2 = COM component 4 = comment line
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: LINETYPE

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

Attribute: LINE_ID

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

Attribute: LINE_SOURCE

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

Attribute: LINE_SOURCE

Table	JOB_TRANSACTIONS
Comment	Where the line was sourced from. Will be one of: P = Purchase Q = Quote
Primary key	No
Data type	VARCHAR(10)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINE_STATUS

Table	JOB_TRANSACTIONS
Comment	The line's status. Will be one of: R = Ready to invoice W = Writeoff I = Invoiced X = Cancelled A = Asset C = Committed Stock
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINE_STATUS

Table	JOBCOST_LINES
Comment	The status on the job line. Will be one of: Q = quote line J = line has been committed and ready for invoice I = line has been invoiced P = line is a part of a Purchase Order
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINE_TAX

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

Attribute: LINE_TAX

Table	JOBCOST_LINES
Comment
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
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	JOB_TRANSACTIONS
Comment	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	JOBCOST_LINES
Comment	S = Stocked, L = Lookup
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	JOBCOST_LINES
Comment	Quantity (if the item is a linked stock item).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINKED_QTY

Table	JOB_TRANSACTIONS
Comment	Quantity (if the item is a linked stock item).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINKED_STOCKCODE

Table	JOB_TRANSACTIONS
Comment	Code of the linked stock item
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKED_STOCKCODE

Table	JOBCOST_LINES
Comment	Linked stockcode.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to

Attribute: LISTPRICE

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

Attribute: LISTPRICE

Table	JOB_TRANSACTIONS
Comment	The original sell price of the item.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LOCATION

Table	JOB_RESOURCE_ALLOCATION
Comment	The Location code entered for the allocation.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: LOCATION

Table	JOB_TRANSACTIONS
Comment	The location that the item moves to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LOCATION

Table	JOB_OUTPUT_ITEMS
Comment	The location specified for the output item (from STOCK_LOCATIONS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STOCK_LOCATIONS.LOCNO

Attribute: LOCK_JOB

Table	JOB_STATUS
Comment	If this field contains 'Y', the status makes the job read-only.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default	N
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_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: LOOKUP_RECOVERABLE

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

Attribute: MASTER_JOBNO

Table	JOB_CONTRACT_BILLINGS
Comment	If the job is a sub-job, this field contains the ID number of the master job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOBCOST_HDR.JOBNO

Attribute: MASTER_JOBNO

Table	JOBCOST_HDR
Comment	If the job is a sub-job, this field stores the ID number of the master job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: MASTER_JOBNO

Table	JOB_TRANSACTIONS
Comment	If the line belongs to a sub-job, this field contains the ID of the master job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOBCOST_HDR.JOBNO

Attribute: MASTER_JOBNO

Table	JOBCOST_LINES
Comment	If the line belongs to a sub-job, this field contains the ID of the master job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	JOBCOST_HDR.JOBNO

Attribute: MATERIALS

Table	JOBCOST_HDR
Comment	Total amount on the Costs tab for the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: MATERIALSCOST

Table	JOBCOST_HDR
Comment	The total costs on the Costs tab.
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	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: 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: MOVE_STOCK

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
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: 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: NARRATIVE

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

Attribute: NARRATIVE

Table	NARRATIVES
Comment	The text of the narrative.
Primary key	No
Data type	VARCHAR(4096)
Domain name
Not NULL	No
Default
Refers to

Attribute: NARRATIVE

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

Attribute: NARRATIVE_SEQNO

Table	JOBCOST_LINES
Comment	The ID number of the narrative on the line, if there is one (from NARRATIVES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	NARRATIVES.SEQNO

Attribute: NARRATIVE_SEQNO

Table	JOB_TRANSACTIONS
Comment	The ID number of the narrative on the line, if there is one (from NARRATIVES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	NARRATIVES.SEQNO

Attribute: NARRATIVE_SEQNO

Table	JOB_CONTRACT_BILLINGS
Comment	The ID number of the narrative on the line, if there is one.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	NARRATIVES.SEQNO

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: NORMALHOURS

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

Attribute: NOTE

Table	JOB_HIST
Comment	The text of the History Note.
Primary key	No
Data type	VARCHAR(4096)
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: 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: 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: NUNITPR

Table	JOB_TRANSACTIONS
Comment	The unit price after discount.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: NUNITPR

Table	JOBCOST_LINES
Comment
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
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: OPPLINEID

Table	JOBCOST_LINES
Comment	If the job was created from an Opportunity in EXO CRM, this field contains the ID of the Opportunity line that this line was created from.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: OPPORTUNITY_SEQNO

Table	JOBCOST_HDR
Comment	The ID number of the Opportunity (EXO CRM) that the job is associated with, if there is one.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to	OPPORTUNITY.SEQNO

Attribute: OPTION_1

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_10

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_2

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_3

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_4

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_5

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_6

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_7

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_8

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_9

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: OPTION_NAME

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

Attribute: OPTION_NO

Table	JOB_QUOTE_OPTIONS
Comment	A job-specific ID number for the option.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: OPTION_NO

Table	JOBCOST_LINES
Comment	The ID number of the quote option assigned to the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOB_QUOTE_OPTIONS.SEQNO

Attribute: OPTION_SELECTED

Table	JOB_QUOTE_OPTIONS
Comment	This field contains 'Y' if the option is currently selected for the job.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: OURREF

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: OUTLOOK_LINK

Table	JOB_HIST
Comment	If the History Note was emailed, this field contains a link to the email in MS Outlook.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: OVERHEAD

Table	JOB_TRANSACTIONS
Comment	The overhead amount on the line, if applicable.
Primary key	No
Data type	FLOAT(53)
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: 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: PAYRATE

Table	JOB_TRANSACTIONS
Comment	Pay Rate percentage (only applicable when timesheets are integrated with MYOB EXO Payroll).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: PAYRATE_NO

Table	JOB_TRANSACTIONS
Comment	Pay Rate ID (only applicable when timesheets are integrated with MYOB EXO Payroll).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: PAYRATE_OVERRIDEN

Table	JOB_TRANSACTIONS
Comment	This field contains 'Y' if the payrate has been modified; otherwise 'N' (only applicable when timesheets are integrated with MYOB EXO Payroll).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: PAYROLLRATE

Table	JOB_TIMESHEETS_RATES
Comment	The factor by which the pay rate of transactions exported via a timecard data file to your payroll base rate may be multiplied, e.g. where an employee is to be paid time-and-a-half or double time.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: PAYROLL_ALLOWANCE_ID

Table	JOB_TIMESHEET_ALLOWANCE_TYPES
Comment	An ID number for mapping Allowances and Deductions with those defined in your payroll via your timecard data file.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	No
Default
Refers to

Attribute: PAYROLL_ALLOWANCE_ID

Table	JOB_TIMESHEETS_RATES
Comment	An ID number for mapping Allowances and Deductions with those defined in your payroll via your timecard data file.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	No
Default
Refers to

Attribute: PAYROLL_HOURS

Table	JOB_TRANSACTIONS
Comment	Payroll hours (only applicable when timesheets are integrated with MYOB EXO Payroll).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
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: PAYROLL_STATUS

Table	JOB_TRANSACTIONS
Comment	Only applicable when timesheets are integrated with MYOB EXO Payroll. Will be one of: Y = the line is ready to invoice N = the line is not ready to post P = the line has been invoiced
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: PERCENTAGE_COMPLETE

Table	JOB_CONTRACT_BILLINGS
Comment	The Percentage Complete amount for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
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: POSTTIME

Table	JOB_HIST
Comment	The actual date and time that the record was posted.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: PO_LINESEQNO

Table	JOB_TRANSACTIONS
Comment	The related Purchase Order line ID, if applicable (from PURCHORD_LINES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to	PURCHORD_LINES.SEQNO

Attribute: PQTY

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

Attribute: PREF_SERIALNO

Table	JOBCOST_LINES
Comment
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
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	JOBCOST_LINES
Comment	This field contains 'Y' if the unit price or discount has been overridden.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: PRICE_OVERRIDDEN

Table	JOB_TRANSACTIONS
Comment	This field contains 'Y' if the unit price or discount has been overridden.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: PRINTDESC

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
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: PRIVATE_NOTE

Table	JOBCOST_HDR
Comment	Any notes on the job.
Primary key	No
Data type	CHAR(1000)
Domain name
Not NULL	No
Default
Refers to

Attribute: PROFORMA_NO

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

Attribute: PROGRESSINVOICE

Table	JOB_TRANSACTIONS
Comment	This field contains 'Y' if the line is allocated to a Billing Schedule.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: PROJ_CODE

Table	JOBCOST_PROJ
Comment	An alphanumerical ID code for the project.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: PROJ_SEQNO

Table	JOBCOST_HDR
Comment	The ID number of the project that the job belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	JOBCOST_PROJ.SEQNO

Attribute: PROJ_TITLE

Table	JOBCOST_PROJ
Comment	A descriptive title for the project.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
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_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: QUANTITY

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

Attribute: QUANTITY

Table	JOB_OUTPUT_ITEMS
Comment	The quantity of the item that will be produced.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: QUOTECOST

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	1
Refers to

Attribute: QUOTEDATE

Table	JOBCOST_HDR
Comment	The quote date on the job.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: QUOTE_QTY

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

Attribute: QUOTE_TERMS

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1000)
Domain name
Not NULL	No
Default
Refers to

Attribute: QUOTE_UNITPR

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

Attribute: RATECOLOR

Table	JOB_TIMESHEETS_RATES
Comment	A colour code that determines how timesheet lines of this rate should appear on the EXO Job Costing Timesheets window.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: RATENAME

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

Attribute: RATE_FACTOR

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

Attribute: RATE_SEQNO

Table	JOB_TRANSACTIONS
Comment	Timesheet Rate ID from JOB_TIMESHEETS_RATES)
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOB_TIMESHEETS_RATES.SEQNO

Attribute: RATE_SEQNO

Table	JOB_TIMESHEETS
Comment	The ID number of the Timesheet Rate in the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	JOB_TIMESHEETS_RATES.SEQNO

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: REPORTDESC

Table	JOB_OTHER_REPORTS
Comment	No longer used.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: REPORTNO

Table	JOB_OTHER_REPORTS
Comment	No longer used.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
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: REPORT_PARAMS

Table	JOB_OTHER_REPORTS
Comment	No longer used.
Primary key	No
Data type	VARCHAR(200)
Domain name
Not NULL	No
Default
Refers to

Attribute: RESOURCENAME

Table	JOBCOST_RESOURCE
Comment	The resource's name.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: RESOURCE_SEQNO

Table	JOB_RESOURCE_ALLOCATION
Comment	The ID number of the resource being allocated.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	JOBCOST_RESOURCE.SEQNO

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: RETENTION

Table	JOB_CONTRACT_BILLINGS
Comment	The base retention percentage for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: RETENTION2

Table	JOB_CONTRACT_BILLINGS
Comment	The Retention 2 rate for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION2_MIN

Table	JOBCOST_HDR
Comment	The Minimum Value for the Level 2 Retention on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION2_RATE

Table	JOB_CONTRACT_BILLINGS
Comment	The Retention 2 percentage for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION2_RATE

Table	JOBCOST_HDR
Comment	The Level 2 retention rate on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION3

Table	JOB_CONTRACT_BILLINGS
Comment	The Retention 3 rate for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION3_MIN

Table	JOBCOST_HDR
Comment	The Minimum Value for the Level 3 Retention on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION3_RATE

Table	JOBCOST_HDR
Comment	The Level 3 retention rate on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION3_RATE

Table	JOB_CONTRACT_BILLINGS
Comment	The Retention 3 percentage for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION_AMOUNT

Table	JOB_TRANSACTIONS
Comment	The retention amount on the line, if applicable.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: RETENTION_DUE_DATE

Table	JOB_CONTRACT_BILLINGS
Comment	The retention due date.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: RETENTION_INVNO

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

Attribute: RETENTION_INV_SEQNO

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

Attribute: RETENTION_RATE

Table	JOB_CONTRACT_BILLINGS
Comment	The base retention rate for the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: RETENTION_RATE

Table	JOB_TRANSACTIONS
Comment	The retention rate on the line, if applicable.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: RETENTION_RATE

Table	JOBCOST_HDR
Comment	The base retention rate on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: RETENTION_REALISED

Table	JOB_CONTRACT_BILLINGS
Comment	The retention amount realised on the line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: REVIEWDATE

Table	JOBCOST_RESOURCE
Comment
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: RTN_2_MIN

Table	JOB_RETENTION_LEVELS
Comment	The Minimum Value for the Level 2 Retention.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: RTN_2_RATE

Table	JOB_RETENTION_LEVELS
Comment	The % Rate for the Level 2 Retention.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: RTN_3_MIN

Table	JOB_RETENTION_LEVELS
Comment	The Minimum Value for the Level 3 Retention.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: RTN_3_RATE

Table	JOB_RETENTION_LEVELS
Comment	The % Rate for the Level 3 Retention.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: SALESGL

Table	JOBCOST_HDR
Comment	The P&L revenue account for journals when invoicing.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	GLACCS.ACCNO

Attribute: SALESGLSQL

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(500)
Domain name
Not NULL	No
Default
Refers to

Attribute: SALESNO

Table	JOB_HIST
Comment	The ID number of the EXO Business staff member who added the History Note.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: SALESSUBGL

Table	JOBCOST_HDR
Comment	The P&L revenue sub-account for journals when invoicing.
Primary key	No
Data type	INTEGER
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_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: SCHEDULER

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: SCHEDULE_SEQNO

Table	JOB_TRANSACTIONS
Comment	The related Billing Schedule ID, if the line is allocated to a Billing Schedule (from JOB_CONTRACT_BILLINGS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOB_CONTRACT_BILLINGS.SEQNO

Attribute: SCHEDULE_SEQNO

Table	JOBCOST_LINES
Comment	ID number of the Billing Schedule that applies to the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	JOB_CONTRACT_BILLINGS.SEQNO

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: SECTION

Table	JOBCOST_LINES
Comment
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
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: 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: 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: 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: 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: 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: 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	STOCK_ITEMS
Comment	Sell price 9.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: SELLRATE

Table	JOB_TIMESHEETS_RATES
Comment	The factor by which the charge-out rate of transactions entered with this rate type will be multiplied when posting to a job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: SELLRATE0

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

Attribute: SELLRATE1

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

Attribute: SELLRATE2

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

Attribute: SELLRATE3

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

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

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

Attribute: SEQNO

Table	JOB_TIMESHEET_ALLOWANCE
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	JOB_RETENTION_LEVELS
Comment	A unique ID number of the line.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

Table	JOBCOST_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	JOB_TRANSACTIONS
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	JOB_HIST
Comment	A unique ID number for the History Note.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SERIALNO

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

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: SHORTCODE

Table	JOB_TIMESHEETS_RATES
Comment	A short ID code for the rate.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	No
Default
Refers to

Attribute: SHORTCODE

Table	JOB_COSTGROUPS
Comment	A short (max. three characters) code for the group.
Primary key	No
Data type	VARCHAR(3)
Domain name
Not NULL	No
Default
Refers to

Attribute: SHORTCODE

Table	JOB_TYPES
Comment	A short (max. three characters) ID code for the type.
Primary key	No
Data type	VARCHAR(3)
Domain name
Not NULL	No
Default
Refers to

Attribute: SHORTCODE

Table	JOB_COSTTYPES
Comment	A short (max. three characters) code for the type
Primary key	No
Data type	VARCHAR(3)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SHORTCODE

Table	JOB_CATEGORIES
Comment	A short (max. three characters) ID code for the category.
Primary key	No
Data type	VARCHAR(3)
Domain name
Not NULL	No
Default
Refers to

Attribute: SHORTCODE

Table	JOBCOST_RESOURCE
Comment	A short (max. three characters) ID code for the resource.
Primary key	No
Data type	VARCHAR(3)
Domain name
Not NULL	No
Default
Refers to

Attribute: SHORTDESC

Table	JOB_STATUS_CONSTRAINT
Comment	A short code (5 characters max) for the constraint.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SHOWLINE

Table	JOB_TRANSACTIONS
Comment	Flag to indicate if the BOM item line should be printed on Clarity reports or not.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SHOWLINE

Table	JOBCOST_LINES
Comment	Used by reports to display/hide lines.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SHOWMAIN

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

Attribute: SHOWONQUOTE

Table	JOB_COSTGROUPS
Comment	This field contains 'T' if the group's "Show on quote" option is ticked; otherwise 'F'.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	F
Refers to

Attribute: SHOWONQUOTE

Table	JOB_COSTTYPES
Comment	This field contains 'T' if the type's "Show on quote" option is ticked; otherwise 'F'.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	F
Refers to

Attribute: SHOW_ON_INVOICE

Table	JOBCOST_LINES
Comment
Primary key	No
Data type	CHAR(1)
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: SNEXPDAYS

Table	JOBCOST_LINES
Comment	Expiry days (applicable only if the item is serialised).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SNEXPDAYS

Table	JOB_TRANSACTIONS
Comment	Serial Number expiry days.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SNTYPE

Table	JOBCOST_LINES
Comment	Serial number type (applicable only if the item is serialised).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SNTYPE

Table	JOB_TRANSACTIONS
Comment	Serial number type.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: SOFTWARE_VERSION

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SOURCE_ID

Table	JOB_TRANSACTIONS
Comment	If the line originated from a job quote, this field contains the ID of the original quote line (from JOBCOST_LINES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: SOURCE_REF

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

Attribute: SOURCE_REF

Table	JOB_TRANSACTIONS
Comment	Source reference.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: SOURCE_SEQNO

Table	JOB_TRANSACTIONS
Comment	If the line originated from a job quote, this field contains the ID of the original quote line (from JOBCOST_LINES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	JOBCOST_LINES.SEQNO

Attribute: SPREADVALUE

Table	JOB_TRANSACTIONS
Comment	If this field contains 'Y', the line will be taken into account when using the spread function to alter the total.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: SPREADVALUE

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

Attribute: STAFFNO

Table	JOB_TRANSACTIONS
Comment	ID number of the staff member on the line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STAFF.STAFFNO

Attribute: STAFFNO

Table	JOBCOST_RESOURCE
Comment	If the resource relates to an EXO Business staff member, their ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STAFF.STAFFNO

Attribute: STAFFNO

Table	JOBCOST_HDR
Comment	The EXO Business staff member responsible for entering the job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
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: STAFFNO

Table	JOB_TIMESHEETS
Comment	The ID number of the staff member on the timesheet line.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STAFF.STAFFNO

Attribute: STAFFNO

Table	JOB_TIMESHEET_ALLOWANCE
Comment	The ID number of the staff member that the line relates to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	STAFF.STAFFNO

Attribute: STARTDATE

Table	JOBCOST_HDR
Comment	The job's start date.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: STARTTIME

Table	JOB_TRANSACTIONS
Comment	Start time (only applies to timesheets).
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: START_DATE

Table	JOB_RESOURCE_ALLOCATION
Comment	The allocation's start date.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: START_TIME

Table	JOB_RESOURCE_ALLOCATION
Comment	The allocation's start time.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
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: STATUS

Table	JOBCOST_HDR
Comment	The ID code of the job's status (from JOB_STATUS).
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to	JOB_STATUS.STATUSKEY

Attribute: STATUSDESC

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

Attribute: STATUSKEY

Table	JOB_STATUS
Comment	A unique one letter ID code for the Job Status.
Primary key	Yes
Data type	VARCHAR(1)
Domain name
Not NULL	Yes
Default
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: STDCOST_IN

Table	JOB_TRANSACTIONS
Comment	The Standard cost of the item coming into the WIP location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: STDCOST_OUT

Table	JOB_TRANSACTIONS
Comment	The Standard cost of the item going out of the WIP location.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: STOCKCODE

Table	JOB_TIMESHEETS
Comment	The stockcode of the labour pay item for this line.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	JOB_CONTRACT_BILLINGS
Comment	The stockcode for the billing record.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	JOBCOST_LINES
Comment	The stockcode 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	JOB_OUTPUT_ITEMS
Comment	The stockcode of the output stock item.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	Yes
Default
Refers to	STOCK_ITEMS.STOCKCODE

Attribute: STOCKCODE

Table	JOB_TRANSACTIONS
Comment	The stockcode 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_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: STOCKCOST

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

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: 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: STOCKLOC

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
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: STOCK_TRANS_SEQ_IN

Table	JOB_TRANSACTIONS
Comment	This field stores the STOCK_TRANS.SEQNO from the Purchase Order line that inserted the job transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: SUBCODE

Table	JOBCOST_LINES
Comment	The subcode of the P&L revenue account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SUBCODE

Table	JOB_TRANSACTIONS
Comment	The subcode of the P&L revenue account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SUBJECT

Table	JOB_HIST
Comment	The History Note's subject line.
Primary key	No
Data type	VARCHAR(80)
Domain name
Not NULL	No
Default
Refers to

Attribute: SUBJECT_NOTES

Table	JOB_RESOURCE_ALLOCATION
Comment	Any notes entered into the allocation's Subject field.
Primary key	No
Data type	VARCHAR(255)
Domain name
Not NULL	No
Default
Refers to

Attribute: SUBSADDUP

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: SUBTOTAL

Table	JOB_CONTRACT_BILLINGS
Comment	The subtotal on the billing record.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
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: SUPPLIERNO

Table	JOBCOST_LINES
Comment	ID of the supplier (Creditor) for the stock item on this line (from CR_ACCS).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCS.ACCNO

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: 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: SU_SEQNO

Table	JOB_TRANSACTIONS
Comment	The ID number of the Serviceable Unit that the line is associated with, if applicable.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: TAXNO

Table	JOB_TRANSACTIONS
Comment	The ID number of the tax rate on the line (from TAX_RATES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	TAX_RATES.SEQNO

Attribute: TAXNO

Table	JOBCOST_LINES
Comment	The ID number of the tax rate on the line (from TAX_RATES).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	TAX_RATES.SEQNO

Attribute: TAXRATE

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

Attribute: TAXRATE

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

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: TAXTOTAL

Table	JOB_CONTRACT_BILLINGS
Comment	The total tax amount on the billing record.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: THETIME

Table	JOBCOST_HDR
Comment	Total amount on timesheets for the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: THETIMECOST

Table	JOBCOST_HDR
Comment	The total costs on the Timesheets tab.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TIMESELECTSQL

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	VARCHAR(255)
Domain name
Not NULL	No
Default
Refers to

Attribute: TITLE

Table	JOBCOST_RESOURCE
Comment	The resource's title.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: TITLE

Table	JOBCOST_HDR
Comment	A descriptive title for the job.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to

Attribute: TITLE

Table	JOB_TIMESHEETS
Comment	The title of the job that the line relates to.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to	JOBCOST_HDR.TITLE

Attribute: TOTALCOST

Table	JOBCOST_HDR
Comment	The total cost of the job (Timesheets and Costs tabs).
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

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: TOTALVALUE

Table	JOBCOST_HDR
Comment	The total value of the job (Timesheets and Costs tabs).
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: TOTAL_HOURS

Table	JOB_RESOURCE_ALLOCATION
Comment	The total number of hours that the resource was allocated for.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: TOTAL_HOURS

Table	JOBCOST_HDR
Comment	The total hours on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TOTAL_QUANTITY

Table	JOB_TRANSACTIONS
Comment	The total quantity after considering the dimensions (if applicable).
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: TOTAL_QUANTITY

Table	JOBCOST_LINES
Comment	The total quantity after considering the dimensions (if applicable).
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: TO_STATUS

Table	JOB_STATUS_CONSTRAINT
Comment	The destination stage for the constraint.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: TRACKEVENT

Table	JOB_STATUS_CONSTRAINT
Comment	If this field contains 'Y', when a job is changed from the FROM_STATUS to the TO_STATUS, the stage change is recorded in the Event Log.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default
Refers to

Attribute: TRANSDATE

Table	JOB_TRANSACTIONS
Comment	For timesheets, this field identifies the start date; otherwise it contains the transaction date on the line.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: TRANSDATE

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

Attribute: TRANSDATE

Table	JOB_HIST
Comment	The transaction date against the History Note.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: TRANSTYPE

Table	JOB_TRANSACTIONS
Comment	The transaction type. Will be one of: T = Time C = Cost
Primary key	No
Data type	VARCHAR(1)
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: TYPEDESC

Table	JOB_TYPES
Comment	Descriptive text for the type.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: TYPENO

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

Attribute: UNIT

Table	JOB_TIMESHEET_ALLOWANCE
Comment	The unit of the allowance (unit type, e.g. hours, KM, is determined by the allowance type).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: UNITCOST

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

Attribute: UNITPRICE

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

Attribute: UNITPRICE

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

Attribute: UNITPRICE_INCTAX

Table	JOBCOST_LINES
Comment	The unit price inclusive of tax.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNITPRICE_INCTAX

Table	JOB_TRANSACTIONS
Comment	The unit price inclusive of tax.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: UNIT_OF_MEASURE

Table	JOB_TIMESHEET_ALLOWANCE_TYPES
Comment	The unit of measure that the type uses. Will be HOURS, KILOMETERS or CURRENCY.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
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_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: 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: USE_SALES_ORD_NO

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
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: WAGE_CODE

Table	JOB_TRANSACTIONS
Comment	Wage code (only applicable when timesheets are integrated with MYOB EXO Payroll).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
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: WEEK_START_DATE

Table	JOB_TIMESHEETS
Comment	The start date of the week that times are being entered for.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: WEEK_START_DATE

Table	JOB_TIMESHEET_ALLOWANCE
Comment	The start date of the week that the line belongs to.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
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: WIPLOC

Table	JOBCOST_HDR
Comment	The Work in Progress location for the job.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: WIPNOTSOH

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

Attribute: WIP_IN_PERIOD_SEQNO

Table	JOB_TRANSACTIONS
Comment	PERIOD_SEQNO for WIP_IN_DATE
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: WIP_OUT_DATE

Table	JOB_TRANSACTIONS
Comment	The date and time when the stock moved out of WIP.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: WIP_OUT_PERIOD_SEQNO

Table	JOB_TRANSACTIONS
Comment	PERIOD_SEQNO for WIP_OUT_DATE
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: WORKFLOW_CONSTRAINED

Table	JOB_STATUS
Comment	If this field contains 'Y', workflow constraints (defined in the JOB_STATUS_CONSTRAINT table) apply to the status.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: WORKSHEETTYPE

Table	JOBCOST_GENERAL_INFO
Comment	No longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	1
Refers to

Attribute: WRITE_OFF_COST

Table	JOBCOST_HDR
Comment	The total cost of all written off lines on the job.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
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_LABOUR_ALLOWANCE

Table	JOBCOST_LINES
Comment
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
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: 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