MYOB EXO Business Creditors

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	CR_ACCS
Comment	The Creditor's Primary Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCGROUPS.ACCGROUP

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

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

Attribute: ACCGROUP

Table	CR_ACCGROUP2S
Comment	A unique ID for the Secondary Creditor Group.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: ACCGROUP2

Table	CR_ACCS
Comment	The Creditor's Secondary Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCGROUP2S.ACCGROUP

Attribute: ACCNO

Table	PURCHORD_HDR
Comment	The ID number of the Creditor account that the Purchase Order was created for.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCS.ACCNO

Attribute: ACCNO

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

Attribute: ACCNO

Table	CR_CONTACTS
Comment	The account number of the Creditor account that the Contact is associated with.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	CR_ACCS.ACCNO

Attribute: ACCNO

Table	CR_PRICES
Comment	The Creditor account that the price rule is defined for. Has the value -1 if the price rule belongs to a generic price policy.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: ACCNO

Table	CR_TRANS
Comment	The ID number of the Creditor account against which the transaction was generated. If the transaction is against a branch account, this field is set to the head account's ACCNO.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CR_ACCS.ACCNO

Attribute: ACCNO

Table	CR_LISTS
Comment	The ID number of the Creditor account.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	CR_ACCS.ACCNO

Attribute: ACCNO

Table	CR_CONT_HIST
Comment	The ID number of the Creditor account that the History Note is attached to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to	CR_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: ACCNO

Table	CR_ACCS
Comment	The unique ID number for the Creditor account.
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: ACTIONDUEDATE

Table	CR_CONT_HIST
Comment	This field is used by the Serviceable Units add-on module - it is not set from the Creditors UI.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: ACTIONSTATUS

Table	CR_CONT_HIST
Comment	This field is used by the Serviceable Units add-on module - it is not set from the Creditors UI.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ACTIVATION_DATE

Table	PURCHORD_HDR
Comment	The date and time when the Purchase Order was activated.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS1

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS1

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

Attribute: ADDRESS1

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

Attribute: ADDRESS1

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

Attribute: ADDRESS2

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

Attribute: ADDRESS2

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

Attribute: ADDRESS2

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS2

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

Attribute: ADDRESS3

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

Attribute: ADDRESS3

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS3

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

Attribute: ADDRESS3

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

Attribute: ADDRESS4

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

Attribute: ADDRESS4

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

Attribute: ADDRESS4

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

Attribute: ADDRESS4

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS5

Table	CONTACTS
Comment	Postal address line 5. This line is only available on the Contacts window if the Additional Postal Address Row profile setting is enabled.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS5

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS5

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

Attribute: ADDRESS5

Table	CR_ACCS
Comment	Postal address line 5. This line is only available on the Creditor Account Details screen if the Additional Postal Address Row profile setting is enabled.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS6

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

Attribute: ADVERTSOURCE

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ADVERTSOURCE

Table	CONTACTS
Comment	The Contact's Advertising Source - corresponds to the SEQNO of the type in the ADVERT_TYPES table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	ADVERT_TYPES.SEQNO

Attribute: AGE

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

Attribute: AGE

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

Attribute: AGE

Table	PERIOD_STATUS
Comment	The age of the period. The current period has an age of 0.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: AGEDBAL0

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

Attribute: AGEDBAL1

Table	CR_ACCS
Comment	Aged Balance for the previous month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AGEDBAL2

Table	CR_ACCS
Comment	Aged Balance for two months back.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AGEDBAL3

Table	CR_ACCS
Comment	Aged Balance for three months back.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AGE_STAMP

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

Attribute: AGE_STAMP

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

Attribute: ALERT

Table	CR_ACCS
Comment	Pop-up alert text to display when dealing with the Creditor.
Primary key	No
Data type	VARCHAR(60)
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: ALERTPC

Table	CURRENCIES
Comment	The % Change Alert for the currency - when editing currencies, the user will be alerted if the currency is changed by a percentage greater than this.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	5
Refers to

Attribute: ALLOCAGE

Table	CR_TRANS
Comment	The age in which the transaction was allocated.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALLOCATED

Table	CR_TRANS
Comment	0 = Unallocated or partially allocated. 1 = Allocated in the current period. 2 = Allocated in any prior period.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALLOCATEDBAL

Table	CR_TRANS
Comment	The amount that has been allocated.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALLOCNO

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

Attribute: ALLOCTIME

Table	CR_ALLOCATIONS
Comment	The date and time of the allocation.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
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: ALPHACODE

Table	CR_ACCS
Comment	A non-unique alphanumeric ID code for the Creditor. Can be used for sorting accounts alphabetically, e.g. give "The Warehouse" the code "WARE" to sort under W instead of T. Sometimes used as an alternate account reference.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: AMOUNT

Table	CR_TRANS
Comment	The amount of the transaction, including tax, in the currency of the Creditor account.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: AMOUNT

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

Attribute: ANALYSIS

Table	CR_TRANS
Comment	For payments, this field holds the payment type.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: ANALYSIS

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

Attribute: API_ACCESS

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

Attribute: APP_PASSWORD

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

Attribute: AUTHORISED

Table	CR_TRANS
Comment	If this field contains 'Y', the transaction was authorised
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: AUTHORISEDBY

Table	CR_TRANS
Comment	The ID number of the staff member who authorised the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
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: AUTH_DATE

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

Attribute: AUTH_DATE

Table	PURCHORD_HDR
Comment	The date and time when the Purchase Order was authorised.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: AUTH_STAFFNO

Table	PURCHORD_HDR
Comment	The ID number of the staff member who authorised the Purchase Order.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: AUTOFREIGHT

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

Attribute: AUTO_AUTH_AMT

Table	CR_ACCS
Comment	The amount that can be automatically authorised by the trigger AUTHORISE_TRANS on the CR_TRANS table.
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: AVERAGE_RATE

Table	CURRENCIES
Comment	This field relates to the Intercompany module.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AVE_DAYS_TO_PAY

Table	CR_ACCS
Comment	Average Creditor days, calculated by the Stored Procedure DR_CR_ALLOCATION_AVE_DAYS_SP every time you access the Analysis tab.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
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	CR_ACCS
Comment	The total of all aged balances.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
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: BANKNO

Table	CR_TRANS
Comment	The Bank ID number (entered via payment entry).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: BANK_ACCOUNT

Table	CR_ACCS
Comment	The Creditor's bank account number, used for Direct Credit payments.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: BANK_ACC_NAME

Table	CR_ACCS
Comment	The Creditor's bank account name, used for Direct Credit payments.
Primary key	No
Data type	VARCHAR(40)
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: BASE

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

Attribute: BATCHCODE

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

Attribute: 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	CR_INVLINES
Comment	How Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BOMTYPE

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

Attribute: BRANCHNO

Table	CR_ACCS
Comment	Branch number - only used by specific sites.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BRANCHNO

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

Attribute: BRANCHNO

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

Attribute: BRANCHNO

Table	PURCHORD_HDR
Comment	The Branch number on the Purchase Order.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BRANCHNO

Table	CR_TRANS
Comment	The branch ID number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BRANCH_ACCNO

Table	CR_TRANS
Comment	Only used in head account/branch account scenarios. This field contains the account number of the branch account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: BSBNO

Table	CR_ACCS
Comment	The Creditor's Bank State Branch number (Australian databases only).
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: BUYRATE

Table	CURRENCIES
Comment	The buy rate (for purchases).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CAMPAIGN_WAVE_SEQNO

Table	PURCHORD_HDR
Comment	If the Purchase Order is associated with a campaign wave (EXO CRM), its ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: CAMPAIGN_WAVE_SEQNO

Table	CONTACTS
Comment	If the Contact is included in a campaign wave (EXO Business CRM), the wave's ID number is stored here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to	CAMPAIGN_WAVE.SEQNO

Attribute: CITP

Table	CR_TRANS
Comment	Australian companies only. This field is set to 'Y' if the transaction should be tracked for reporting to the ATO on the "Taxable payments annual report".
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: CLOSING_RATE

Table	CURRENCIES
Comment	This field relates to the Intercompany module.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CODETYPE

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

Attribute: COGSMETHOD

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

Attribute: COMPANY_ACCNO

Table	CONTACTS
Comment	If the Contact is associated with a company (Debtor, Creditor or Non Account) the company's ID number is recorded here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: COMPANY_ACCTYPE

Table	CONTACTS
Comment	If the Contact is associated with a company (Debtor, Creditor or Non Account) the type of company account is recorded here: 1 = Debtor account 2 = Creditor account 3 = Non Account
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: COMTYPE

Table	CR_CONT_HIST
Comment	This field is used by the Serviceable Units add-on module - it is not set from the Creditor UI.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CONTACT_SEQNO

Table	CR_TRANS
Comment	The SEQNO of the Contact assigned to this transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	CONTACTS.SEQNO

Attribute: CONTACT_SEQNO

Table	CR_CONT_HIST
Comment	The ID number of the associated Contact record.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	CONTACTS.SEQNO

Attribute: CONTACT_SEQNO

Table	PURCHORD_HDR
Comment	The ID number of the Contact assigned to the Purchase Order.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: CONTACT_SEQNO

Table	CR_CONTACTS
Comment	The ID number of the Contact record in the CONTACTS table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CONTACTS.SEQNO

Attribute: COSTGROUP

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

Attribute: COSTTYPE

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

Attribute: COST_GROUP

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

Attribute: COST_TYPE

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

Attribute: COS_GLSUBCODE

Table	STOCK_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: CREATE_DATE

Table	PURCHORD_HDR
Comment	The date and time when the Purchase Order was created.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: CREDITSTATUS

Table	CR_ACCS
Comment	Credit terms for the Creditor.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CREDLIMIT

Table	CR_ACCS
Comment	The credit limit for the Creditor account.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CRINVLINEID

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

Attribute: 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: CURRCODE

Table	CURRENCIES
Comment	The three-letter currency code, e.g. AUD, NZD.
Primary key	No
Data type	VARCHAR(3)
Domain name
Not NULL	No
Default
Refers to

Attribute: CURRENCY

Table	CR_ALLOCATIONS
Comment	The ID number of the currency in which the transaction took place.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	CURRENCIES.CURRENCYNO

Attribute: CURRENCYNO

Table	CR_TRANS
Comment	The ID of the currency being used for the transaction.
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	PURCHORD_HDR
Comment	The ID number of the currency that the Purchase Order is in.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CURRENCYNO

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

Attribute: CURRENCYNO

Table	CR_ACCS
Comment	The ID number of the currency used by the Creditor account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: CURRENCYNO

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

Attribute: CURRNAME

Table	CURRENCIES
Comment	The descriptive name for the currency.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: CURRSYMBOL

Table	CURRENCIES
Comment	The symbol for the currency, e.g. $, �.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEFACCOUNT

Table	CR_CONTACTS
Comment	This field is set to 'Y' if the Creditor account is the default company for the Contact, i.e. if it is the company specified in the Company field on the Details tab of the Contacts window.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
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_CODE

Table	CR_ACCS
Comment	The default GL code on a Creditors Invoice (when in GL mode).
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: DEFCONTACT

Table	CR_CONTACTS
Comment	This field is set to 'Y' if the Contact is set as the default Contact for the Creditor account.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: DEFDAYS

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

Attribute: DEFLOCNO

Table	PURCHORD_HDR
Comment	The default location that stock is being supplied from.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DEF_INVMODE

Table	CR_ACCS
Comment	The Default Invoice Mode for the Creditor. Will be one of: 0 = GL 1 = STOCK
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: DELADDR1

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR1

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

Attribute: DELADDR1

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

Attribute: DELADDR2

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

Attribute: DELADDR2

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR2

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

Attribute: DELADDR3

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR3

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

Attribute: DELADDR3

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

Attribute: DELADDR4

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR4

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

Attribute: DELADDR4

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

Attribute: DELADDR5

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

Attribute: DELADDR5

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR5

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

Attribute: DELADDR6

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DELADDR6

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

Attribute: DELADDR6

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

Attribute: DESCRIPTION

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

Attribute: DESCRIPTION

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

Attribute: 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: DIRECTFAX

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DIRECTFAX

Table	CONTACTS
Comment	The Contact's fax number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DIRECTPHONE

Table	CONTACTS
Comment	The Contact's direct telephone number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DIRECTPHONE

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: DISCOUNT

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

Attribute: DISCOUNT

Table	CR_PRICES
Comment	The percentage discount to be applied, as per a price rule.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: DISCOUNTAMT

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

Attribute: DISCOUNTLEVEL

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

Attribute: DISCOUNTLEVEL

Table	CR_ACCS
Comment	The Creditor's discount level - this is only populated via EXO APIs.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: DISCOUNTPCT

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

Attribute: DISCOUNTRATE

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

Attribute: 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	CR_TRANS
Comment	The payment due date.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: DUEDATE

Table	PURCHORD_HDR
Comment	The date and time when the Purchase Order is due.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
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

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to

Attribute: EMAIL

Table	CONTACTS
Comment	The Contact's email address.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to

Attribute: EMAIL

Table	CR_ACCS
Comment	The Creditor's email address.
Primary key	No
Data type	VARCHAR(60)
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: EVENT_SEQNO

Table	CR_CONT_HIST
Comment	If the History Note was created as a result of event logging, this field contains the ID number of the reason event from the REASONS table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: EXCHRATE

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

Attribute: EXCHRATE

Table	CR_TRANS
Comment	The exchange rate being used for the transaction, as determined by the currency in use.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	1
Refers to

Attribute: EXCHRATE

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

Attribute: EXCHRATE

Table	PURCHORD_HDR
Comment	The exchange rate for the currency that the Purchase Order is in.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	1
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

Table	CR_ACCS
Comment	The Creditor's Facebook account ID or username.
Primary key	No
Data type	VARCHAR(500)
Domain name
Not NULL	No
Default
Refers to

Attribute: FACEBOOK

Table	CONTACTS
Comment	The Contact's Facebook username or ID number.
Primary key	No
Data type	VARCHAR(500)
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: FAX

Table	CR_ACCS
Comment	The Creditor's fax number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: FINALISATION_DATE

Table	PURCHORD_HDR
Comment	The date and time when the Purchase Order was finalised.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: FIN_QTR

Table	PERIOD_STATUS
Comment	The financial quarter that the period belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: FIRSTNAME

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: FIRSTNAME

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

Attribute: FIXED

Table	CR_PRICES
Comment	This field contains 'Y' if the rule is a fixed price rule.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: FULLNAME

Table	CONTACTS
Comment	The Contact's full name, formed by joining the FIRSTNAME and LASTNAME fields.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: GEOCODE_STATUS

Table	CR_ACCS
Comment	Result of the geocode lookup. Will be one of: Null or -1 - lookup not yet attempted 0 - lookup successful >0 - lookup failed
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	NULL
Refers to

Attribute: GEOCODE_STATUS

Table	CONTACTS
Comment	Result of the geocode lookup. Will be one of: Null or -1 - lookup not yet attempted 0 - lookup successful >0 - lookup failed
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLACC

Table	TAX_RATES
Comment	The GL account used for the tax rate (if it is not using the default control account).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLACCNO

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

Attribute: GLBATCHNO

Table	CR_TRANS
Comment	The batch number for the journals that have sourced from this transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: GLCODE

Table	CR_TRANS
Comment	For payments, this field contains the GL code of the bank account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	GLACCS.ACCNO

Attribute: GLCONTROLACC

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

Attribute: GLCONTROLSUBACC

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

Attribute: GLPOSTED

Table	CR_TRANS
Comment	Y = the transaction has been posted to GL. N = the transaction has not been posted to GL.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: GLSUBACC

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

Attribute: GLSUBACC

Table	TAX_RATES
Comment	The GL subaccount used for the tax rate (if it is not using the default control subaccount).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GLSUBCODE

Table	CR_TRANS
Comment	For payments, this field contains the GL subcode of the bank account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: GROUPNAME

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

Attribute: GROUPNAME

Table	CR_ACCGROUPS
Comment	The name of the group.
Primary key	No
Data type	VARCHAR(30)
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: HDR_SEQNO

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

Attribute: HEAD_ACCNO

Table	CR_ACCS
Comment	The ACCNO of the Creditor's head office account. If no head office, this is set to -1.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
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: HOMEPHONE

Table	CONTACTS
Comment	The Contact's home phone number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: HOMEPHONE

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: HSTATUS

Table	PURCHORD_HDR
Comment	For On-Demand Purchase orders, this field contains the line status. Comes from the profile setting 'B2B new purchase line status'.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: IGRLINESEQNO

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

Attribute: IMAGE_URL

Table	CR_TRANS
Comment	URL of the image.
Primary key	No
Data type	VARCHAR(80)
Domain name
Not NULL	No
Default
Refers to

Attribute: INSTRUCTIONS

Table	PURCHORD_HDR
Comment	This field is set via the On-Demand Purchase Orders function of the EXO Distribution Advantage module.
Primary key	No
Data type	VARCHAR(255)
Domain name
Not NULL	No
Default
Refers to

Attribute: INTERCO_BATCH_DESC

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

Attribute: INTERCO_COMPANYNO

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

Attribute: INTERCO_CR_ACCNO

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

Attribute: INTERCO_CR_BRANCHNO

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

Attribute: INTERCO_CR_SUBACCNO

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

Attribute: INTERCO_DR_ACCNO

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

Attribute: INTERCO_DR_BRANCHNO

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

Attribute: INTERCO_DR_SUBACCNO

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

Attribute: INVLINEID

Table	CR_INVLINES_SERIALS
Comment	The associated Creditors Invoice line - links to CR_INVLINES.CRINVLINEID.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	CR_INVLINES.CRINVLINEID

Attribute: INVNO

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

Attribute: INVNO

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

Attribute: INVOICETYPE

Table	CR_ACCS
Comment	This field only applies to Australian databases where M-Powered Invoices are enabled. If set to 1, search results on the Transactions tab of the Creditor Account Details window will only include accounts with the M-Powered invoice type.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ISACTIVE

Table	CONTACTS
Comment	Whether the Contact is active (Y) or inactive (N).
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

Table	CR_ACCS
Comment	Whether the account is active (Y) or inactive (N).
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	CR_PRICES
Comment	This field is set to 'Y' if the pricing rule is active.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: ISACTIVE

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

Attribute: ISACTIVE

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

Attribute: ISCONFIRMED

Table	PURCHORD_HDR
Comment	If this field is set to 'Y', this means that all lines in the Purchase Order have been confirmed, i.e. the supplier/creditor has acknowledged the order.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: IS_DISCOUNTABLE

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

Attribute: IS_SUPERVISOR

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

Attribute: JOBCODE

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

Attribute: JOBNO

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

Attribute: JOBNO

Table	CR_CONT_HIST
Comment	This is a legacy field that is no longer used.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: JOBTITLE

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

Attribute: KEY_POINT

Table	TAX_RATES
Comment	The tax return key point that applies to the tax rate.
Primary key	No
Data type	VARCHAR(5)
Domain name
Not NULL	No
Default
Refers to

Attribute: KITCODE

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

Attribute: KITSEQNO

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

Attribute: LABEL_QTY

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

Attribute: LASTMONTH

Table	CR_ACCS
Comment	Turnover for the last month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
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: LASTNAME

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: LASTNAME

Table	CONTACTS
Comment	The Contact's last/family name.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: LASTYEAR

Table	CR_ACCS
Comment	Turnover for the last year
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	GLACCS
Comment	The date and time when the GL account was last updated.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: LAST_UPDATED

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

Attribute: LAST_UPDATED

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

Attribute: LAST_UPDATED

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

Attribute: LAST_UPDATED

Table	CR_ACCS
Comment	Time and date stamp when the Creditor's account details were 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: LATITUDE

Table	CONTACTS
Comment	The Contact's latitude.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LATITUDE

Table	CR_ACCS
Comment	The Creditor's latitude.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LEADTIME

Table	CR_ACCS
Comment	The Primary Lead Time defined for the Creditor, i.e. the number of days between placing an order and its arrival.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LEADTIME2

Table	CR_ACCS
Comment	The Secondary Lead Time defined for the Creditor (the alternate lead delivery time in days).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LEADTIMEUSED

Table	PURCHORD_HDR
Comment	Specifies which of the Lead Times defined for the Creditor the Purchase Order uses. Will be one of: 0 = Primary Lead Time 1 = Secondary Lead Time
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LEDGER

Table	PERIOD_STATUS
Comment	The ledger for a specific age.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default
Refers to

Attribute: LINETAX_OVERRIDDEN

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

Attribute: LINETOTAL

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

Attribute: LINETOTAL_INCTAX

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

Attribute: LINETOTAL_TAX

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

Attribute: LINETYPE

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

Attribute: LINE_SOURCE

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

Attribute: LINKEDIN

Table	CONTACTS
Comment	The Contact's LinkedIn account ID.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKEDIN

Table	CR_ACCS
Comment	The Creditor's LinkedIn account ID.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: LINKEDIN_TOKEN_KEY

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

Attribute: LINKEDIN_TOKEN_SECRET

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

Attribute: LINKEDSTATUS

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

Attribute: 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	CR_INVLINES
Comment	The physical stock unit quantity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: LINKED_STOCKCODE

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

Attribute: LIST_NAME

Table	CR_LIST_NAME
Comment	The name of the list.
Primary key	No
Data type	VARCHAR(50)
Domain name
Not NULL	No
Default
Refers to

Attribute: LIST_NO

Table	CR_LIST_NAME
Comment	A unique ID number for the list.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	CR_LISTS.LIST_NO

Attribute: LIST_NO

Table	CR_LISTS
Comment	The ID number of the Account List that this line applies to (CR_LIST_NAMES.LIST_NO).
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: LOCALVALUE

Table	PURCHORD_HDR
Comment	The value of the Purchase Order in the local currency.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: LOCATION

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

Attribute: LOCKED

Table	PERIOD_STATUS
Comment	If set to 'Y', the period is locked, implying that this age in a specific ledger is closed and no more transactions should take place
Primary key	No
Data type	CHAR(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: LONGITUDE

Table	CR_ACCS
Comment	The Creditor's longitude.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: LONGITUDE

Table	CONTACTS
Comment	The Contact's longitude.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
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: MANUAL_ROUNDING

Table	CR_TRANS
Comment	This field contains the manual rounding amount (if any).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	Yes
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: MINGLSEQNO

Table	PERIOD_STATUS
Comment	The first transaction for the period found in the GLTRANS table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: MINORDLINESEQNO

Table	PERIOD_STATUS
Comment	For the Debtors ledger, this specifies the first transaction for the period found in the SALESORD_LINES table. For the Creditors ledger, this specifies the first transaction for the period found in the PURCHORD_LINES table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: MINORDSEQNO

Table	PERIOD_STATUS
Comment	For the Debtors ledger, this specifies the first transaction for the period found in the SALESORD_HDR table. For the Creditors ledger, this specifies the first transaction for the period found in the PURCHORD_HDR table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: MINQTY

Table	CR_PRICES
Comment	Minimum quantity for the price rule to apply.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: MINSTOCK

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

Attribute: MINSTOCKSEQNO

Table	PERIOD_STATUS
Comment	The first transaction for the period found in the Stock ledger.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: MINTRANLINESEQNO

Table	PERIOD_STATUS
Comment	For the Debtors ledger, this specifies the first transaction for the period found in the DR_INVLINES table. For the Creditors ledger, this specifies the first transaction for the period found in the CR_INVLINES table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: MINTRANSEQNO

Table	PERIOD_STATUS
Comment	For the Debtors ledger, this specifies the first transaction for the period found in the DR_TRANS table. For the Creditors ledger, this specifies the first transaction for the period found in the CR_TRANS table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: MOBILE

Table	CONTACTS
Comment	The Contact's mobile phone number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: MOBILE

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
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: MONTHVAL

Table	CR_ACCS
Comment	Turnover 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: MSN_ID

Table	CONTACTS
Comment	The Contact's MSN ID number.
Primary key	No
Data type	VARCHAR(45)
Domain name
Not NULL	No
Default
Refers to

Attribute: NAME

Table	CR_ACCS
Comment	The Creditor's name.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
Refers to

Attribute: NAME

Table	TAX_RATES
Comment	The full name of the taxation rate.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: NAME

Table	CR_TRANS
Comment	The ID number and name of the Creditor account against which the transaction was generated.
Primary key	No
Data type	VARCHAR(70)
Domain name
Not NULL	No
Default
Refers to

Attribute: NAME

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

Attribute: 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	NARRATIVES
Comment	The text of the narrative.
Primary key	No
Data type	VARCHAR(4096)
Domain name
Not NULL	No
Default
Refers to

Attribute: NARRATIVE_SEQNO

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

Attribute: NARRATIVE_SEQNO

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

Attribute: NARRATIVE_SEQNO

Table	PURCHORD_HDR
Comment	The ID number of the narrative attached to the Sales Order header.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to	NARRATIVES.SEQNO

Attribute: NARRATIVE_SEQNO

Table	CR_TRANS
Comment	ID number of the narrative attached to the transaction.
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: NOTE

Table	CR_CONT_HIST
Comment	The main body 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	CONTACTS
Comment	All notes entered for the Contact on the Notes tab.
Primary key	No
Data type	VARCHAR(4096)
Domain name
Not NULL	No
Default
Refers to

Attribute: NOTES

Table	CR_ACCS
Comment	All notes entered for the Creditor on the Notes tab.
Primary key	No
Data type	VARCHAR(4096)
Domain name
Not NULL	No
Default
Refers to

Attribute: NOTES

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
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: N_CR_DISC

Table	CR_ACCS
Comment	The stock line discount for the account on invoice. This is only applicable if manual entry of discounts is allowed on Creditors Invoices (controlled by the profile setting 'Allow manual entry of discounts on creditor invoice and purchase order lines').
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: N_LAND_COST_PROVN

Table	CR_ACCS
Comment	This value is used to calculate the Fixed cost for any Inwards Goods for the account.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: N_TOTVENDISC

Table	CR_TRANS
Comment	The total vendor discount.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: N_TOTVENDISC_EXCLTAX

Table	CR_TRANS
Comment	The total vendor discount, excluding tax.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: OPENINGBAL

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

Attribute: OPENITEM

Table	CR_ACCS
Comment	This field contains 'Y' if this is not a balance brought forward account.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: OPTOUT_EMARKETING

Table	CONTACTS
Comment	This field is set to 'Y' if the Contact's Opt-Out eMarketing flag is ticked. Contacts who have opted out of eMarketing will not be included in campaign waves for campaigns whose Campaign Type is set to "Marketing" (EXO Business CRM).
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: ORDERDATE

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

Attribute: ORDTOTAL

Table	PURCHORD_HDR
Comment	The total amount for the Sales Order.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: OUTLOOK_LINK

Table	CR_CONT_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: 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: 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: PAYSTATUS

Table	CR_TRANS
Comment	The pay status of the transaction. Will be one of: -1 = HELD 0 = NOT RELEASED 1 = RELEASED
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PAY_TYPE

Table	CR_ACCS
Comment	The default payment method.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PERIODNAME

Table	PERIOD_STATUS
Comment	The name/description for the period.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: PERIOD_SEQNO

Table	CR_ALLOCATIONS
Comment	The period in which the allocation took place.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to	PERIOD_STATUS.SEQNO

Attribute: PERIOD_SEQNO

Table	PERIOD_STATUS
Comment	The period's sequence number within fiscal year.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: PERIOD_SEQNO

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

Attribute: PERIOD_SHORTNAME

Table	PERIOD_STATUS
Comment	A short name for the period.
Primary key	No
Data type	VARCHAR(8)
Domain name
Not NULL	No
Default
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: PHONE

Table	CR_ACCS
Comment	The Creditor's phone number.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: POSTTIME

Table	CR_CONT_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: POSTTIME

Table	CR_TRANS
Comment	The actual date/time the transaction was posted at.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: POSTTIME

Table	CR_INVLINES_SERIALS
Comment	The date and time when the line was saved to the database.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: POST_CODE

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: POST_CODE

Table	CONTACTS
Comment	The Contact's post code.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: POST_CODE

Table	CR_ACCS
Comment	The Creditor's postal code.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
Refers to

Attribute: PO_SEQNO

Table	CR_TRANS
Comment	For invoices generated from Purchase Orders, this field holds the SEQNO of the Purchase Order.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	PURCHORD_HDR.SEQNO

Attribute: PP_BATCHREF

Table	CR_TRANS
Comment	This field contains the Creditors Payment Processor batch reference.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: PP_TOPAY

Table	CR_ACCS
Comment	The pay status from the Creditors Payment Processor.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: PQTY

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

Attribute: PREV_PERIOD_CLOSE

Table	CR_TRANS
Comment	Balance as at the end of the previous period.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PREV_PERIOD_OPEN

Table	CR_TRANS
Comment	Balance as at the start of the previous period.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PRICE

Table	CR_PRICES
Comment	The substitute price to be applied to the stockcode/group.
Primary key	No
Data type	FLOAT(53)
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: PRIOR_AGEDBAL0

Table	CR_ACCS
Comment	Prior Aged Balance for the current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PRIOR_AGEDBAL1

Table	CR_ACCS
Comment	Prior Aged Balance for the previous month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PRIOR_AGEDBAL2

Table	CR_ACCS
Comment	Prior Aged Balance for two months ago.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PRIOR_AGEDBAL3

Table	CR_ACCS
Comment	Prior Aged Balance for three months ago.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PRIOR_BALANCE

Table	CR_ACCS
Comment	The sum of all Prior Aged Balances.
Primary key	No
Data type	AS
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_ACC

Table	CR_ACCS
Comment	If 'Y', the Creditor account is classed as private. It can only be accessed by users who have the profile setting "Allow access to private creditor accounts" (ALLOW_ACCESS_TO_PRIVATE_CR_ACC) enabled.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: PROCESSFINALISATION

Table	PURCHORD_HDR
Comment	Will be one of: 0 = Normal 1 = Deleted 2 = Forced Fully Processed
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: PROMPT_PAY_DISC

Table	CR_ACCS
Comment	The prompt payment discount percentage for the Creditor.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default
Refers to

Attribute: PTNO

Table	CR_TRANS
Comment	The payment number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: PURCHTAXRATE

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

Attribute: PURCH_ACCNO

Table	CR_TRANS
Comment	If the transaction is against a branch account, this field holds the account number for the branch account and the ACCNO field holds the account number of the head account. In all other cases, this field and the ACCNO field always have same number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
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	CR_INVLINES
Comment	The quantity for this line.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: RATE

Table	TAX_RATES
Comment	The percentage taxation rate.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: RECEIPTNO

Table	CR_TRANS
Comment	If the transaction is sourced from Inwards Goods, this field contains the Inwards Goods receipt ID.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: REF1

Table	CR_TRANS
Comment	For payments, this field contains the payment type, e.g. CASH, CHEQUE. For invoices, this field contains whatever was entered into the Order no field.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: REF2

Table	CR_TRANS
Comment	For payments, this field contains the payment reference/cheque number. For invoices, this field contains the ID number of the job selected for the Job no field.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: REF3

Table	CR_TRANS
Comment	For payments, this field contains the text 'PAYMENT'. For invoices, this field contains the text 'Invoice'.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: REFERENCE

Table	PURCHORD_HDR
Comment	An additional reference code for the Purchase Order.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: RELEASEDAMT

Table	CR_TRANS
Comment	The released amount (applies to the Creditors Payment Processor).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: REMITTANCE_METHOD

Table	CR_ACCS
Comment	How remittance advice should be sent to the Creditor. Will be one of: None E-Mail Print Both
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: REPORTCODE

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

Attribute: REPORTCODE

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

Attribute: REPORTCODE

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

Attribute: REPORTCODE

Table	PERIOD_STATUS
Comment	A code used for reporting purposes.
Primary key	No
Data type	VARCHAR(8)
Domain name
Not NULL	No
Default
Refers to

Attribute: REPORTS_TO_STAFFNO

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

Attribute: 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: RE_MOVEMENTS

Table	CURRENCIES
Comment	This field relates to the Intercompany module.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALESNO

Table	PURCHORD_HDR
Comment	The ID number of the staff member assigned to the Purchase Order.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALESNO

Table	CONTACTS
Comment	The STAFFNO of staff member who is set as the Sales person for the Contact.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STAFF.STAFFNO

Attribute: SALESNO

Table	CR_TRANS
Comment	The ID number of the salesperson assigned to the transaction.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SALESNO

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

Attribute: SALESNO

Table	CR_CONT_HIST
Comment	The ID of the staff member selected on the History Note.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	STAFF.STAFFNO

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

Table	CONTACTS
Comment	The Contact's preferred salutation, e.g. Mr, Mrs.
Primary key	No
Data type	VARCHAR(4)
Domain name
Not NULL	No
Default
Refers to

Attribute: SALUTATION

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(4)
Domain name
Not NULL	No
Default
Refers to

Attribute: SECTION

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

Attribute: SECURITYPROFILEID

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

Attribute: SELLPRICE1

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

Attribute: 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	CURRENCIES
Comment	The sell rate (for sales).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SEND_PAYMENT_REMITTANCE

Table	CR_ACCS
Comment	If this field contains 'Y', remittance advice will be sent to this Creditor whenever payments are made to them via the MYOB M-Powered Payments system.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

Table	CR_INVLINES_SERIALS
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	CR_PRICES
Comment	A unique ID number for the price record.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SEQNO

Table	CR_CONTACTS
Comment	A unique identifier for the Creditor Contact. The identifier for the Contact record is specified by the CONTACT_SEQNO field.
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	CR_ALLOCATIONS
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	CR_INVLINES
Comment	A unique transaction line ID.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: SEQNO

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

Attribute: SEQNO

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

Attribute: SERIALNO

Table	CR_INVLINES_SERIALS
Comment	The serial number.
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: SESSION_ID

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

Attribute: SHORTNAME

Table	TAX_RATES
Comment	A short name for the taxation rate.
Primary key	No
Data type	VARCHAR(6)
Domain name
Not NULL	No
Default
Refers to

Attribute: SHOWLINE

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

Attribute: SKYPE_ID

Table	CONTACTS
Comment	The Contact's Skype ID number.
Primary key	No
Data type	VARCHAR(45)
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: SO_SOURCE_REF

Table	PURCHORD_HDR
Comment	If the Purchase Order was generated from a Sales Order, the Sales Order's ID number is recorded here.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

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

Table	CR_PRICES
Comment	Date from which the price rule is active.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: STARTDATE

Table	PERIOD_STATUS
Comment	The start date for the period.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: STATEMENT_CONTACT_SEQNO

Table	CR_ACCS
Comment	The ID number of the Contact who is assigned as the Creditor's Remittance Contact.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to

Attribute: STATEMENT_TEXT

Table	CR_ACCS
Comment	This field is used for M-Powered Payments (AU only). Its value is copied to the REF3 field on CR_TRANS for M-Powered transactions.
Primary key	No
Data type	VARCHAR(256)
Domain name
Not NULL	No
Default
Refers to

Attribute: STATUS

Table	PURCHORD_HDR
Comment	The status of the Purchase Order. Will be one of: 0 = Not Processed 1 = Partly Processed 2 = Fully Processed 3 = Quotation 4 = Awaiting Authorisation
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: STATUS

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

Attribute: STDCOST

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

Attribute: STOCKCODE

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

Attribute: STOCKCODE

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

Attribute: STOCKCODE

Table	CR_PRICES
Comment	If the price rule is defined for an individual Stock item, this field stores the item's stockcode.
Primary key	No
Data type	VARCHAR(23)
Domain name
Not NULL	No
Default
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: STOCKPRICEGROUP

Table	CR_PRICES
Comment	If the price rule is defined against a price group rather than an individual product, this field stores the Stock price group.
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: STOPCREDIT

Table	CR_ACCS
Comment	If 'Y', the Creditor is on Stop Credit, and no further transactions will take place.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: STOPDATE

Table	CR_PRICES
Comment	Date to which the price rule remains active.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: STOPDATE

Table	PERIOD_STATUS
Comment	The end date for the period.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: SUB1

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 1 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB1

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB10

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB10

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 10 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB11

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB11

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 11 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB12

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB12

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 12 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB13

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB13

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 13 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB14

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 14 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB14

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB15

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB15

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 15 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB16

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 16 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB16

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB17

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB17

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 17 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB18

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB18

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 18 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB19

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 19 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB19

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB2

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB2

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 2 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB20

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB20

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 20 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB21

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SUB21

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 21 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB22

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SUB22

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 22 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB23

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SUB23

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 23 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB24

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SUB24

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 24 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB25

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 25 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB25

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SUB26

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 26 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB26

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	Y
Refers to

Attribute: SUB3

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB3

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 3 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB4

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 4 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB4

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB5

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 5 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB5

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB6

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB6

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 6 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB7

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 7 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB7

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB8

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 8 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB8

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB9

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUB9

Table	CONTACTS
Comment	This field is set to 'Y' if Marketing Class number 9 is ticked on the Marketing tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: SUBJECT

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

Attribute: SUBTOTAL

Table	PURCHORD_HDR
Comment	The subtotal amount on the Purchase Order.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: SUBTOTAL

Table	CR_TRANS
Comment	The tax-exclusive amount, in the currency of the Creditor account.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
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	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: SYNC_CONTACTS

Table	CONTACTS
Comment	This field is set to 'Y' if the Contact is set to sync with Microsoft Outlook.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: TAKENUP

Table	CR_ALLOCATIONS
Comment	This field is a flag that specify whether or not the allocation has been a part of realised gain/losses.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: TAXINC

Table	CR_TRANS
Comment	Y = tax inclusive, N = tax exclusive.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: TAXINC

Table	PURCHORD_HDR
Comment	Set to 'Y' if the Purchase Order is tax-inclusive.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: TAXRATE

Table	CR_TRANS
Comment	The tax rate used by the transaction, e.g. 12.5 = 12.5%.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TAXRATE

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

Attribute: TAXRATE_NO

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

Attribute: TAXRATE_NO

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

Attribute: TAXREG

Table	CR_ACCS
Comment	GST/ABN number of the Creditor.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: TAXRETCODE

Table	CR_TRANS
Comment	The tax return code for the GST return that this transaction applies to.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: TAXSTATUS

Table	CR_ACCS
Comment	The Override GST rate for the Creditor.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
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	PURCHORD_HDR
Comment	The total tax amount on the Purchase Order.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TAXTOTAL

Table	CR_TRANS
Comment	The tax total in the currency of the Creditor account.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TITLE

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

Attribute: TITLE

Table	CR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: TOAGEDBAL

Table	CR_TRANS
Comment	Only applicable in case of balance brought forward accounts payments and adjustments. Used in the trigger POST_CR_TRANS to refresh the aged balances on the account. 0 = current 1 = 1 months 2 = 2 months 3 = 3 months 4 = from oldest
Primary key	No
Data type	INTEGER
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: TRACK_CITP

Table	CR_ACCS
Comment	Australian companies only. This field is set to 'Y' if payments to the Creditor should be tracked for reporting to the ATO on the "Taxable payments annual report".
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	N
Refers to

Attribute: TRANSDATE

Table	CR_CONT_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: TRANSDATE

Table	CR_TRANS
Comment	The date/time mentioned in the transaction itself.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: TRANSTYPE

Table	CR_TRANS
Comment	1 = Postive amount is Invoice, Negative amount is Credit; 4 = Negative amount is Payment, Positive amount is Refund
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: TRANS_SEQNO

Table	CR_ALLOCATIONS
Comment	This field is a link back to the original transaction line in CR_TRANS table (CR_TRANS.SEQNO).
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	CR_TRANS.SEQNO

Attribute: TWITTER

Table	CONTACTS
Comment	The Contact's Twitter username.
Primary key	No
Data type	VARCHAR(500)
Domain name
Not NULL	No
Default
Refers to

Attribute: TWITTER

Table	CR_ACCS
Comment	The Creditor's Twitter username.
Primary key	No
Data type	VARCHAR(500)
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: TXID

Table	CR_TRANS
Comment	A unique transaction ID number, populated by the trigger TRG_TXID_CR_TRANS. Used to separate native transactions inserted by EXO Business from other transactions.
Primary key	No
Data type	VARBINARY(256)
Domain name
Not NULL	No
Default
Refers to

Attribute: TXID

Table	PURCHORD_HDR
Comment	The Transaction ID assigned to the Purchase Order - this applies when using a payment gateway.
Primary key	No
Data type	VARBINARY(256)
Domain name
Not NULL	No
Default
Refers to

Attribute: UNITPRICE

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

Attribute: UNITPRICE_INCTAX

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

Attribute: UNREALISED_GAINS_GL_BATCH

Table	CR_TRANS
Comment	The batch number for the unrealised gains journal that the transaction is a part of. Reset to zero when the journal is reversed.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: UPDATEITEM_CODE

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

Attribute: UPDATEITEM_QTY

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

Attribute: UPDATE_STOCK

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

Attribute: 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: 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: WEBSITE

Table	CR_ACCS
Comment	URL of the Creditor's website.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: WEB_SHOW

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

Attribute: WEIGHT

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

Attribute: 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_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: YAHOO_ID

Table	CONTACTS
Comment	The Contact's Yahoo! ID number.
Primary key	No
Data type	VARCHAR(45)
Domain name
Not NULL	No
Default
Refers to

Attribute: YEARAGE

Table	PERIOD_STATUS
Comment	The ageing of the year that the period falls in. The current year has an age of 0.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
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: YEARVAL

Table	CR_ACCS
Comment	Turnover for the current year.
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