| Column name | Table | Key | Data type | Not NULL | Comment |
| ABSENT | STAFF | | CHAR(1) | Yes | 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. |
| ACCGROUP | CR_ACCGROUP2S | PK | INTEGER | Yes | A unique ID for the Secondary Creditor Group. |
| ACCGROUP | GLACCS | | INTEGER | No | The GL account's Account Group. |
| ACCGROUP | CR_ACCS | FK | INTEGER | No | The Creditor's Primary Group. |
| ACCGROUP | CR_ACCGROUPS | PK | INTEGER | Yes | A unique ID for the Primary Creditor Group. |
| ACCGROUP2 | CR_ACCS | FK | INTEGER | No | The Creditor's Secondary Group. |
| ACCNO | CR_INVLINES | FK | INTEGER | No | The account number of the Creditor that the transaction belongs to. |
| ACCNO | CR_CONTACTS | FK | INTEGER | No | The account number of the Creditor account that the Contact is associated with. |
| ACCNO | GLACCS | PK | INTEGER | Yes | The unique GL account number. |
| ACCNO | CR_CONT_HIST | FK | INTEGER | No | The ID number of the Creditor account that the History Note is attached to. |
| ACCNO | CR_LISTS | FK | INTEGER | Yes | The ID number of the Creditor account. |
| ACCNO | PURCHORD_HDR | FK | INTEGER | No | The ID number of the Creditor account that the Purchase Order was created for. |
| ACCNO | CR_ACCS | PK | INTEGER | Yes | The unique ID number for the Creditor account. |
| ACCNO | CR_TRANS | FK | INTEGER | No | 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. |
| ACCNO | CR_PRICES | | INTEGER | No | The Creditor account that the price rule is defined for. Has the value -1 if the price rule belongs to a generic price policy. |
| ACCOUNT_STATUS | STAFF | | INTEGER | Yes | The staff member's account status. Will be one of:
0 = Account OK
1 = Account Locked
2 = Password Expired |
| ACTIONDUEDATE | CR_CONT_HIST | | DATETIME | No | This field is used by the Serviceable Units add-on module - it is not set from the Creditors UI. |
| ACTIONSTATUS | CR_CONT_HIST | | INTEGER | No | This field is used by the Serviceable Units add-on module - it is not set from the Creditors UI. |
| ACTIVATION_DATE | PURCHORD_HDR | | DATETIME | No | The date and time when the Purchase Order was activated. |
| ADDRESS1 | CR_ACCS | | VARCHAR(30) | No | Postal address line 1. |
| ADDRESS1 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| ADDRESS1 | CONTACTS | | VARCHAR(30) | No | Postal address line 1. |
| ADDRESS1 | PURCHORD_HDR | | VARCHAR(30) | No | Delivery address line 1. |
| ADDRESS2 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| ADDRESS2 | CR_ACCS | | VARCHAR(30) | No | Postal address line 2. |
| ADDRESS2 | CONTACTS | | VARCHAR(30) | No | Postal address line 2. |
| ADDRESS2 | PURCHORD_HDR | | VARCHAR(30) | No | Delivery address line 2. |
| ADDRESS3 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| ADDRESS3 | PURCHORD_HDR | | VARCHAR(30) | No | Delivery address line 3. |
| ADDRESS3 | CR_ACCS | | VARCHAR(30) | No | Postal address line 3. |
| ADDRESS3 | CONTACTS | | VARCHAR(30) | No | Postal address line 3. |
| ADDRESS4 | CONTACTS | | VARCHAR(30) | No | Postal address line 4. |
| ADDRESS4 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| ADDRESS4 | PURCHORD_HDR | | VARCHAR(30) | No | Delivery address line 4. |
| ADDRESS4 | CR_ACCS | | VARCHAR(30) | No | Postal address line 4. |
| ADDRESS5 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| ADDRESS5 | CR_ACCS | | VARCHAR(30) | No | 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. |
| ADDRESS5 | CONTACTS | | VARCHAR(30) | No | Postal address line 5. This line is only available on the Contacts window if the Additional Postal Address Row profile setting is enabled. |
| ADDRESS5 | PURCHORD_HDR | | VARCHAR(30) | No | Delivery address line 5. |
| ADDRESS6 | PURCHORD_HDR | | VARCHAR(30) | No | Delivery address line 6. |
| ADVERTSOURCE | CONTACTS | FK | INTEGER | No | The Contact's Advertising Source - corresponds to the SEQNO of the type in the ADVERT_TYPES table. |
| ADVERTSOURCE | CR_CONTACTS | | INTEGER | No | Taken from the associated record in the CONTACTS table. |
| AGE | CR_TRANS | | AS | No | The transaction's age. This is calculated based on PERIOD_SEQNO. |
| AGE | PERIOD_STATUS | | INTEGER | Yes | The age of the period. The current period has an age of 0. |
| AGE | CR_ALLOCATIONS | | AS | No | The allocation's age. This is calculated based on PERIOD_SEQNO. |
| AGEDBAL0 | CR_ACCS | | FLOAT(53) | No | Aged Balance for the current month. |
| AGEDBAL1 | CR_ACCS | | FLOAT(53) | No | Aged Balance for the previous month. |
| AGEDBAL2 | CR_ACCS | | FLOAT(53) | No | Aged Balance for two months back. |
| AGEDBAL3 | CR_ACCS | | FLOAT(53) | No | Aged Balance for three months back. |
| AGE_STAMP | CR_ALLOCATIONS | | INTEGER | No | This is a historical field that has been superseded by the AGE calculated field. |
| AGE_STAMP | CR_TRANS | | INTEGER | No | This is a historical field that has been superseded by the AGE calculated field. |
| ALERT | STOCK_ITEMS | | VARCHAR(60) | No | Text of the pop-up alert message that appears when the stock item is sold or purchased. |
| ALERT | CR_ACCS | | VARCHAR(60) | No | Pop-up alert text to display when dealing with the Creditor. |
| ALERTPC | CURRENCIES | | INTEGER | Yes | 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. |
| ALLOCAGE | CR_TRANS | | INTEGER | No | The age in which the transaction was allocated. |
| ALLOCATED | CR_TRANS | | CHAR(1) | No | 0 = Unallocated or partially allocated. 1 = Allocated in the current period. 2 = Allocated in any prior period. |
| ALLOCATEDBAL | CR_TRANS | | FLOAT(53) | No | The amount that has been allocated. |
| ALLOCNO | CR_ALLOCATIONS | PK | INTEGER | Yes | A unique ID number for the allocation set. |
| ALLOCTIME | CR_ALLOCATIONS | | DATETIME | No | The date and time of the allocation. |
| ALLOWJOURNAL | GLACCS | | CHAR(1) | No | This field is set to 'Y' if the GL account allows journals. |
| ALPHACODE | CR_ACCS | | VARCHAR(15) | No | 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. |
| AMOUNT | CR_TRANS | | AS | No | The amount of the transaction, including tax, in the currency of the Creditor account. |
| AMOUNT | CR_ALLOCATIONS | | FLOAT(53) | No | The amount allocated. |
| ANALYSIS | CR_INVLINES | | INTEGER | No | 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". |
| ANALYSIS | CR_TRANS | | VARCHAR(12) | No | For payments, this field holds the payment type. |
| API_ACCESS | STAFF | | CHAR(1) | No | This field contains 'Y' if the staff member is authorised to use the EXO API. |
| APP_PASSWORD | STAFF | | VARCHAR(30) | No | The staff member's password, used when logging in to the EXO Business system. Passwords are stored in an encrypted format. |
| AUTHORISED | CR_TRANS | | CHAR(1) | No | If this field contains 'Y', the transaction was authorised |
| AUTHORISEDBY | CR_TRANS | | INTEGER | No | The ID number of the staff member who authorised the transaction. |
| AUTH_AMT | STAFF | | FLOAT(53) | No | The staff member's Credit Invoice Authorisation Limit. |
| AUTH_DATE | CR_TRANS | | DATETIME | No | The time and date when the transaction was authorised. |
| AUTH_DATE | PURCHORD_HDR | | DATETIME | No | The date and time when the Purchase Order was authorised. |
| AUTH_STAFFNO | PURCHORD_HDR | | INTEGER | No | The ID number of the staff member who authorised the Purchase Order. |
| AUTOFREIGHT | CR_ACCS | | FLOAT(53) | No | Not used. |
| AUTO_AUTH_AMT | CR_ACCS | | FLOAT(53) | No | The amount that can be automatically authorised by the trigger AUTHORISE_TRANS on the CR_TRANS table. |
| AUTO_NARRATIVE | STOCK_ITEMS | | INTEGER | No | The setting of the stock item's Auto Narrative property. Will be one of:
0=No
1=Yes with Blank
2=Yes with Notes |
| AVECOST | STOCK_ITEMS | | FLOAT(53) | No | The stock item's Average Cost Price. |
| AVERAGE_RATE | CURRENCIES | | FLOAT(53) | No | This field relates to the Intercompany module. |
| AVE_DAYS_TO_PAY | CR_ACCS | | INTEGER | Yes | Average Creditor days, calculated by the Stored Procedure DR_CR_ALLOCATION_AVE_DAYS_SP every time you access the Analysis tab. |
| BAD_LOGIN_COUNT | STAFF | | INTEGER | Yes | The number of times the staff member has attempted to log in but failed. |
| BALANCE | CR_ACCS | | AS | No | The total of all aged balances. |
| BALANCE | GLACCS | | FLOAT(53) | No | The account's balance. |
| BALANCE_SHEET_TYPE | GLACCS | | INTEGER | Yes | 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 |
| BALSHEETACCTOT | GLACCS | | AS | No | The balance sheet total for the account. |
| BANKFEED_REFRESHTOKEN | STAFF | | VARCHAR(500) | No | Encrypted OAuth refresh token used for Bank Feeds. |
| BANKNO | CR_TRANS | | INTEGER | No | The Bank ID number (entered via payment entry). |
| BANK_ACCOUNT | CR_ACCS | | VARCHAR(40) | No | The Creditor's bank account number, used for Direct Credit payments. |
| BANK_ACC_NAME | CR_ACCS | | VARCHAR(40) | No | The Creditor's bank account name, used for Direct Credit payments. |
| BARCODE1 | STOCK_ITEMS | | VARCHAR(30) | No | Barcode/alternate code 1. |
| BARCODE2 | STOCK_ITEMS | | VARCHAR(30) | No | Barcode/alternate code 2. |
| BARCODE3 | STOCK_ITEMS | | VARCHAR(30) | No | Barcode/alternate code 3. |
| BASE | TAX_RATES | | FLOAT(53) | No | |
| BATCHCODE | CR_INVLINES | | VARCHAR(20) | No | 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. |
| BINCODE | STOCK_ITEMS | | VARCHAR(12) | No | Bincode for the stock item. |
| BOMPRICING | CR_INVLINES | | CHAR(1) | No | How Bills of Materials are priced. Will be one of:
C = Pricing by Component
T = Pricing by total |
| BOMTYPE | CR_INVLINES | | CHAR(1) | No | The type of Bill of Materials that the line relates to:
N = Normal stock item
B = Build
K = Kit
L = Lookup |
| BRANCHNO | CR_TRANS | | INTEGER | No | The branch ID number. |
| BRANCHNO | STOCK_ITEMS | | INTEGER | No | Branch number for the stock item. |
| BRANCHNO | CR_INVLINES | | INTEGER | No | The branch number. Lines generally inherit the branch specified on the invoice header. |
| BRANCHNO | CR_ACCS | | INTEGER | No | Branch number - only used by specific sites. |
| BRANCHNO | PURCHORD_HDR | | INTEGER | No | The Branch number on the Purchase Order. |
| BRANCH_ACCNO | CR_TRANS | | INTEGER | No | Only used in head account/branch account scenarios. This field contains the account number of the branch account. |
| BSBNO | CR_ACCS | | VARCHAR(40) | No | The Creditor's Bank State Branch number (Australian databases only). |
| BUYRATE | CURRENCIES | | FLOAT(53) | No | The buy rate (for purchases). |
| CAMPAIGN_WAVE_SEQNO | PURCHORD_HDR | | INTEGER | No | If the Purchase Order is associated with a campaign wave (EXO CRM), its ID number is recorded here. |
| CAMPAIGN_WAVE_SEQNO | CONTACTS | FK | INTEGER | No | If the Contact is included in a campaign wave (EXO Business CRM), the wave's ID number is stored here. |
| CITP | CR_TRANS | | CHAR(1) | Yes | 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". |
| CLOSING_RATE | CURRENCIES | | FLOAT(53) | No | This field relates to the Intercompany module. |
| CODETYPE | CR_INVLINES | | CHAR(1) | No | The type of code on the line. Will be one of:
G - GL code
S - Stock code |
| COGSMETHOD | STOCK_ITEMS | | INTEGER | Yes | |
| COMPANY_ACCNO | CONTACTS | | INTEGER | No | If the Contact is associated with a company (Debtor, Creditor or Non Account) the company's ID number is recorded here. |
| COMPANY_ACCTYPE | CONTACTS | | INTEGER | No | 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 |
| COMTYPE | CR_CONT_HIST | | INTEGER | No | This field is used by the Serviceable Units add-on module - it is not set from the Creditor UI. |
| CONTACT_SEQNO | CR_CONTACTS | FK | INTEGER | No | The ID number of the Contact record in the CONTACTS table. |
| CONTACT_SEQNO | CR_TRANS | FK | INTEGER | No | The SEQNO of the Contact assigned to this transaction. |
| CONTACT_SEQNO | CR_CONT_HIST | FK | INTEGER | No | The ID number of the associated Contact record. |
| CONTACT_SEQNO | PURCHORD_HDR | | INTEGER | No | The ID number of the Contact assigned to the Purchase Order. |
| COSTGROUP | STOCK_ITEMS | | INTEGER | Yes | |
| COSTTYPE | STOCK_ITEMS | | INTEGER | Yes | |
| COST_GROUP | CR_INVLINES | | INTEGER | No | This field only applies if EXO Job Costing is installed. It identifies the Cost Group that the transaction belongs to. |
| COST_TYPE | CR_INVLINES | | INTEGER | No | This field only applies if EXO Job Costing is installed. It identifies the Cost Type that the transaction belongs to. |
| COS_GLSUBCODE | STOCK_ITEMS | | INTEGER | No | The Cost of Sales sub-account updated in the General Ledger when the stock item is sold. |
| COS_GL_CODE | STOCK_ITEMS | FK | INTEGER | No | The Cost of Sales account updated in the General Ledger when this stock item is sold. |
| CREATED_DATE | GLACCS | | DATETIME | No | The date and time that the GL account was created. |
| CREATE_DATE | PURCHORD_HDR | | DATETIME | No | The date and time when the Purchase Order was created. |
| CREDITSTATUS | CR_ACCS | | INTEGER | No | Credit terms for the Creditor. |
| CREDLIMIT | CR_ACCS | | FLOAT(53) | No | The credit limit for the Creditor account. |
| CRINVLINEID | CR_INVLINES | | INTEGER | No | 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. |
| CUBIC | STOCK_ITEMS | | FLOAT(53) | No | Cubic weight of the item. |
| CURRCODE | CURRENCIES | | VARCHAR(3) | No | The three-letter currency code, e.g. AUD, NZD. |
| CURRENCY | CR_ALLOCATIONS | FK | INTEGER | No | The ID number of the currency in which the transaction took place. |
| CURRENCYNO | CR_ACCS | | INTEGER | Yes | The ID number of the currency used by the Creditor account. |
| CURRENCYNO | CR_TRANS | FK | INTEGER | No | The ID of the currency being used for the transaction. |
| CURRENCYNO | CR_INVLINES | FK | INTEGER | No | The ID number of the currency used on the line. |
| CURRENCYNO | CURRENCIES | PK | INTEGER | Yes | A unique ID code for the currency. |
| CURRENCYNO | PURCHORD_HDR | | INTEGER | No | The ID number of the currency that the Purchase Order is in. |
| CURRENCYNO | GLACCS | FK | INTEGER | No | The ID number of the currency that the GL account is in. |
| CURRNAME | CURRENCIES | | VARCHAR(30) | No | The descriptive name for the currency. |
| CURRSYMBOL | CURRENCIES | | VARCHAR(5) | No | The symbol for the currency, e.g. $, £. |
| DEFACCOUNT | CR_CONTACTS | | CHAR(1) | Yes | 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. |
| DEFAULTWARRANTYNO | STOCK_ITEMS | | INTEGER | Yes | The default Warranty No for the stock item. |
| DEFAULT_CODE | CR_ACCS | | VARCHAR(15) | No | The default GL code on a Creditors Invoice (when in GL mode). |
| DEFCONTACT | CR_CONTACTS | | CHAR(1) | No | This field is set to 'Y' if the Contact is set as the default Contact for the Creditor account. |
| DEFDAYS | STOCK_ITEMS | | INTEGER | No | |
| DEFLOCNO | PURCHORD_HDR | | INTEGER | No | The default location that stock is being supplied from. |
| DEF_INVMODE | CR_ACCS | | INTEGER | Yes | The Default Invoice Mode for the Creditor. Will be one of:
0 = GL
1 = STOCK |
| DELADDR1 | CR_ACCS | | VARCHAR(30) | No | Delivery address line 1. |
| DELADDR1 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DELADDR1 | CONTACTS | | VARCHAR(30) | No | Delivery address line 1. |
| DELADDR2 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DELADDR2 | CONTACTS | | VARCHAR(30) | No | Delivery address line 2. |
| DELADDR2 | CR_ACCS | | VARCHAR(30) | No | Delivery address line 2. |
| DELADDR3 | CR_ACCS | | VARCHAR(30) | No | Delivery address line 3. |
| DELADDR3 | CONTACTS | | VARCHAR(30) | No | Delivery address line 3. |
| DELADDR3 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DELADDR4 | CONTACTS | | VARCHAR(30) | No | Delivery address line 4. |
| DELADDR4 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DELADDR4 | CR_ACCS | | VARCHAR(30) | No | Delivery address line 4. |
| DELADDR5 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DELADDR5 | CONTACTS | | VARCHAR(30) | No | Delivery address line 5. |
| DELADDR5 | CR_ACCS | | VARCHAR(30) | No | Delivery address line 5. |
| DELADDR6 | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DELADDR6 | CR_ACCS | | VARCHAR(30) | No | Delivery address line 6. |
| DELADDR6 | CONTACTS | | VARCHAR(30) | No | Delivery address line 6. |
| DESCRIPTION | CR_INVLINES | | VARCHAR(40) | No | Description of the Stock item on this line. |
| DESCRIPTION | STOCK_ITEMS | | VARCHAR(40) | No | The stock item's description. |
| DIMENSIONS | STOCK_ITEMS | | INTEGER | Yes | How the dimensions of the stock item are specified. Will be one of:
0=None
1=Length
2=Square
3=Cubic |
| DIRECTFAX | CONTACTS | | VARCHAR(30) | No | The Contact's fax number. |
| DIRECTFAX | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DIRECTPHONE | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| DIRECTPHONE | CONTACTS | | VARCHAR(30) | No | The Contact's direct telephone number. |
| DISCOUNT | CR_INVLINES | | FLOAT(53) | No | The percentage discount for the Stock item on this line. |
| DISCOUNT | CR_PRICES | | FLOAT(53) | No | The percentage discount to be applied, as per a price rule. |
| DISCOUNTAMT | CR_INVLINES | | FLOAT(53) | No | The discount amount on a stock line. |
| DISCOUNTLEVEL | CR_ACCS | | INTEGER | No | The Creditor's discount level - this is only populated via EXO APIs. |
| DISCOUNTLEVEL | STOCK_ITEMS | | INTEGER | No | |
| DISCOUNTPCT | CR_INVLINES | | FLOAT(53) | No | The discount percentage on a stock line. |
| DISCOUNTRATE | STAFF | | FLOAT(53) | Yes | The staff member's Discount Rate Limit. |
| DRCR | GLACCS | | CHAR(1) | No | This field is set to 'C' for Credit accounts or 'D' for Debit accounts. |
| DUEDATE | PURCHORD_HDR | | DATETIME | No | The date and time when the Purchase Order is due. |
| DUEDATE | CR_TRANS | | DATETIME | No | The payment due date. |
| DUTY | STOCK_ITEMS | | FLOAT(53) | Yes | The duty percentage on the stock item. |
| ECONORDERQTY | STOCK_ITEMS | | FLOAT(53) | No | The economic order quantity (EOQ) for the stock item. |
| EMAIL | CR_ACCS | | VARCHAR(60) | No | The Creditor's email address. |
| EMAIL | CR_CONTACTS | | VARCHAR(60) | No | Taken from the associated record in the CONTACTS table. |
| EMAIL | CONTACTS | | VARCHAR(60) | No | The Contact's email address. |
| EMAIL_ADDRESS | STAFF | | VARCHAR(50) | No | The staff member's email address. |
| EMPLOYEE_CODE | STAFF | | INTEGER | Yes | This field is used by the payroll integration functionality. |
| EVENT_SEQNO | CR_CONT_HIST | | INTEGER | No | 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. |
| EXCHRATE | CR_INVLINES | | FLOAT(53) | No | The exchange rate for the line at the time of the transaction. |
| EXCHRATE | CR_ALLOCATIONS | | FLOAT(53) | Yes | The exchange rate used for conversion at the time of the allocation. |
| EXCHRATE | PURCHORD_HDR | | FLOAT(53) | No | The exchange rate for the currency that the Purchase Order is in. |
| EXCHRATE | CR_TRANS | | FLOAT(53) | No | The exchange rate being used for the transaction, as determined by the currency in use. |
| EXCLUDE_FROM_REVAL | GLACCS | | CHAR(1) | No | If this field is set to 'Y', the account is excluded from revaluation. |
| EXPIRY_DAYS | STOCK_ITEMS | | INTEGER | No | Number of days before expiry of the stock item. |
| EXTENSION | STAFF | | VARCHAR(12) | No | The staff member's telephone extension. |
| EXTERNAL_ID | CR_ACCS | | VARCHAR(50) | No | An ID used for external systems. |
| FACEBOOK | CR_ACCS | | VARCHAR(500) | No | The Creditor's Facebook account ID or username. |
| FACEBOOK | CONTACTS | | VARCHAR(500) | No | The Contact's Facebook username or ID number. |
| FACEBOOK_ACCESS_TOKEN | STAFF | | VARCHAR(max) | No | If the staff member uses their own Facebook account when using the EXO Business social media functions, their encrypted access token is stored here. |
| FAX | CR_ACCS | | VARCHAR(30) | No | The Creditor's fax number. |
| FINALISATION_DATE | PURCHORD_HDR | | DATETIME | No | The date and time when the Purchase Order was finalised. |
| FIN_QTR | PERIOD_STATUS | | INTEGER | Yes | The financial quarter that the period belongs to. |
| FIRSTNAME | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| FIRSTNAME | CONTACTS | | VARCHAR(30) | No | The Contact's first name. |
| FIXED | CR_PRICES | | CHAR(1) | Yes | This field contains 'Y' if the rule is a fixed price rule. |
| FULLNAME | CONTACTS | | AS | No | The Contact's full name, formed by joining the FIRSTNAME and LASTNAME fields. |
| GEOCODE_STATUS | CONTACTS | | INTEGER | No | Result of the geocode lookup. Will be one of:
Null or -1 - lookup not yet attempted
0 - lookup successful
>0 - lookup failed |
| GEOCODE_STATUS | CR_ACCS | | INTEGER | No | Result of the geocode lookup. Will be one of:
Null or -1 - lookup not yet attempted
0 - lookup successful
>0 - lookup failed |
| GLACC | TAX_RATES | | INTEGER | No | The GL account used for the tax rate (if it is not using the default control account). |
| GLACCNO | CR_INVLINES | | INTEGER | No | GL account number. |
| GLBATCHNO | CR_TRANS | | INTEGER | No | The batch number for the journals that have sourced from this transaction. |
| GLCODE | CR_TRANS | FK | INTEGER | No | For payments, this field contains the GL code of the bank account. |
| GLCONTROLACC | CR_ACCS | | INTEGER | No | Not currently used. |
| GLCONTROLSUBACC | CR_ACCS | | INTEGER | No | Not currently used. |
| GLPOSTED | CR_TRANS | | CHAR(1) | No | Y = the transaction has been posted to GL. N = the transaction has not been posted to GL. |
| GLSUBACC | TAX_RATES | | INTEGER | No | The GL subaccount used for the tax rate (if it is not using the default control subaccount). |
| GLSUBACC | CR_INVLINES | | INTEGER | No | SL sub-account number. |
| GLSUBCODE | CR_TRANS | | INTEGER | No | For payments, this field contains the GL subcode of the bank account. |
| GROUPNAME | CR_ACCGROUPS | | VARCHAR(30) | No | The name of the group. |
| GROUPNAME | CR_ACCGROUP2S | | VARCHAR(30) | No | The name of the group. |
| HAS_BN | STOCK_ITEMS | | CHAR(1) | No | This field is set to 'Y' if the stock item is batch tracked. |
| HAS_BUDGETS | STAFF | | CHAR(1) | No | 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. |
| HAS_EXPIRY | STOCK_ITEMS | | CHAR(1) | Yes | 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. |
| HAS_SN | STOCK_ITEMS | | CHAR(1) | No | This field is set to 'Y' if the stock item is serial number tracked. |
| HDR_SEQNO | CR_INVLINES | FK | INTEGER | No | The SEQNO of the record in the CR_TRANS table that this record related to. |
| HEAD_ACCNO | CR_ACCS | | INTEGER | Yes | The ACCNO of the Creditor's head office account. If no head office, this is set to -1. |
| HOMEPHONE | STAFF | | VARCHAR(30) | No | The staff member's home telephone number. |
| HOMEPHONE | CONTACTS | | VARCHAR(30) | No | The Contact's home phone number. |
| HOMEPHONE | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| HSTATUS | PURCHORD_HDR | | INTEGER | No | For On-Demand Purchase orders, this field contains the line status. Comes from the profile setting 'B2B new purchase line status'. |
| IGNOREABNCHECK | CR_ACCS | | CHAR(1) | Yes | Indicates whether or not the ABN validation check on the creditor's name should be ignored. |
| IGRLINESEQNO | CR_INVLINES | | INTEGER | No | ID number of the Inwards Goods receipt line (if the source of the line is from Inwards Goods). |
| IMAGE_URL | CR_TRANS | | VARCHAR(80) | No | URL of the image. |
| INSTRUCTIONS | PURCHORD_HDR | | VARCHAR(255) | No | This field is set via the On-Demand Purchase Orders function of the EXO Distribution Advantage module. |
| INTERCO_BATCH_DESC | CR_INVLINES | | VARCHAR(80) | No | This field only applies if EXO InterCompany is used. It contains the batch description. |
| INTERCO_COMPANYNO | CR_INVLINES | | INTEGER | No | This field only applies if EXO InterCompany is used. It contains the Company ID number. |
| INTERCO_CR_ACCNO | CR_INVLINES | | INTEGER | No | This field only applies if EXO InterCompany is used. It contains the Creditor GL account number. |
| INTERCO_CR_BRANCHNO | CR_INVLINES | | INTEGER | No | This field only applies if EXO InterCompany is used. It contains the Creditor branch number. |
| INTERCO_CR_SUBACCNO | CR_INVLINES | | INTEGER | No | This field only applies if EXO InterCompany is used. It contains the Creditor GL sub-account number. |
| INTERCO_DR_ACCNO | CR_INVLINES | | INTEGER | No | This field only applies if EXO InterCompany is used. It contains the Debtor GL account number. |
| INTERCO_DR_BRANCHNO | CR_INVLINES | | INTEGER | No | This field only applies if EXO InterCompany is used. It contains the Debtor branch number. |
| INTERCO_DR_SUBACCNO | CR_INVLINES | | INTEGER | No | This field only applies if EXO InterCompany is used. It contains the Debtor GL sub-account number. |
| INVLINEID | CR_INVLINES_SERIALS | FK | INTEGER | No | The associated Creditors Invoice line - links to CR_INVLINES.CRINVLINEID. |
| INVNO | CR_INVLINES | | VARCHAR(20) | No | The invoice number. |
| INVNO | CR_TRANS | | VARCHAR(20) | No | The invoice number. |
| INVOICETYPE | CR_ACCS | | INTEGER | No | 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. |
| ISACTIVE | CR_ACCS | | CHAR(1) | No | Whether the account is active (Y) or inactive (N). |
| ISACTIVE | GLACCS | | CHAR(1) | No | This field contains 'Y' if the GL account is active. |
| ISACTIVE | CR_PRICES | | CHAR(1) | No | This field is set to 'Y' if the pricing rule is active. |
| ISACTIVE | STAFF | | CHAR(1) | No | 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. |
| ISACTIVE | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| ISACTIVE | STOCK_ITEMS | | CHAR(1) | No | If this field is set to 'Y', the stock item is active. |
| ISACTIVE | CONTACTS | | CHAR(1) | No | Whether the Contact is active (Y) or inactive (N). |
| ISCONFIRMED | PURCHORD_HDR | | CHAR(1) | No | 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. |
| IS_DISCOUNTABLE | STOCK_ITEMS | | CHAR(1) | Yes | This field is set to 'Y' if the stock item is discountable. |
| IS_SUPERVISOR | STAFF | | CHAR(1) | Yes | 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. |
| JOBCODE | CR_INVLINES | | VARCHAR(15) | No | If the line originates from a job, the job's code is recorded in this field. |
| JOBNO | CR_CONT_HIST | | INTEGER | Yes | This is a legacy field that is no longer used. |
| JOBNO | CR_INVLINES | | INTEGER | No | If the line originates from a job, the job's ID number is recorded in this field. |
| JOBTITLE | STAFF | | VARCHAR(30) | No | The staff member's job title. |
| KEY_POINT | TAX_RATES | | VARCHAR(5) | No | The tax return key point that applies to the tax rate. |
| KITCODE | CR_INVLINES | | VARCHAR(23) | No | The Bill of Materials code, if the line is part of a BOM. |
| KITSEQNO | CR_INVLINES | | INTEGER | No | A Bill of Materials SEQNO used to group BOM lines together. |
| LABEL_QTY | STOCK_ITEMS | | INTEGER | Yes | |
| LASTMONTH | CR_ACCS | | FLOAT(53) | No | Turnover for the last month. |
| LASTMONTHUNITS | STOCK_ITEMS | | FLOAT(53) | No | Units of stock item sold in the previous month. |
| LASTMONTHVALUE | STOCK_ITEMS | | FLOAT(53) | No | Sales value for the previous month for the stock item. |
| LASTNAME | CONTACTS | | VARCHAR(30) | No | The Contact's last/family name. |
| LASTNAME | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| LASTYEAR | CR_ACCS | | FLOAT(53) | No | Turnover for the last year |
| LASTYEARUNITS | STOCK_ITEMS | | FLOAT(53) | No | Units of stock item sold in for the previous year. |
| LASTYEARVALUE | STOCK_ITEMS | | FLOAT(53) | No | Sales value for last year. |
| LAST_BAD_LOGIN | STAFF | | DATETIME | No | The date and time when the staff member last attempted to log in but failed. |
| LAST_LOGIN | STAFF | | DATETIME | No | The date and time when the staff member last successfully logged in. |
| LAST_UPDATED | CONTACTS | | DATETIME | No | The date and time when the Contact record was last updated. |
| LAST_UPDATED | STOCK_ITEMS | | DATETIME | No | Date and time when the stock item record was last updated. |
| LAST_UPDATED | GLACCS | | DATETIME | No | The date and time when the GL account was last updated. |
| LAST_UPDATED | CR_ACCS | | DATETIME | No | Time and date stamp when the Creditor's account details were last updated. |
| LAST_UPDATED | PURCHORD_HDR | | DATETIME | No | The date and time when the Purchase Order was last updated. |
| LATESTCOST | STOCK_ITEMS | | FLOAT(53) | No | The stock item's Last Cost Price. |
| LATITUDE | CONTACTS | | FLOAT(53) | No | The Contact's latitude. |
| LATITUDE | CR_ACCS | | FLOAT(53) | No | The Creditor's latitude. |
| LEADTIME | CR_ACCS | | INTEGER | No | The Primary Lead Time defined for the Creditor, i.e. the number of days between placing an order and its arrival. |
| LEADTIME2 | CR_ACCS | | INTEGER | No | The Secondary Lead Time defined for the Creditor (the alternate lead delivery time in days). |
| LEADTIMEUSED | PURCHORD_HDR | | INTEGER | No | 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 |
| LEDGER | PERIOD_STATUS | | CHAR(1) | Yes | The ledger for a specific age. |
| LINETAX_OVERRIDDEN | CR_INVLINES | | CHAR(1) | No | Contains 'Y' if the tax on the line has been manually modified. |
| LINETOTAL | CR_INVLINES | | AS | No | A computed field containing the total value for the line, excluding tax. |
| LINETOTAL_INCTAX | CR_INVLINES | | AS | No | A computed field containing the total value for the line, including tax. |
| LINETOTAL_TAX | CR_INVLINES | | FLOAT(53) | No | The tax total for the line. |
| LINETYPE | CR_INVLINES | | INTEGER | No | 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 |
| LINE_SOURCE | CR_INVLINES | | INTEGER | No | The source SEQNO of the line, if it originated from a Sales Order or job. |
| LINKEDIN | CR_ACCS | | VARCHAR(20) | No | The Creditor's LinkedIn account ID. |
| LINKEDIN | CONTACTS | | VARCHAR(20) | No | The Contact's LinkedIn account ID. |
| LINKEDIN_TOKEN_KEY | STAFF | | VARCHAR(max) | No | 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. |
| LINKEDIN_TOKEN_SECRET | STAFF | | VARCHAR(max) | No | 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. |
| LINKEDSTATUS | CR_INVLINES | | CHAR(1) | No | Will be one of:
S = Stocked
L = Lookup
N = Not applicable |
| LINKED_BILLCODE | STOCK_ITEMS | | VARCHAR(23) | No | |
| LINKED_QTY | CR_INVLINES | | FLOAT(53) | No | The physical stock unit quantity. |
| LINKED_STOCKCODE | CR_INVLINES | | VARCHAR(23) | No | The physical stock unit. |
| LIST_NAME | CR_LIST_NAME | | VARCHAR(50) | No | The name of the list. |
| LIST_NO | CR_LISTS | PK | INTEGER | Yes | The ID number of the Account List that this line applies to (CR_LIST_NAMES.LIST_NO). |
| LIST_NO | CR_LIST_NAME | PK, FK | INTEGER | Yes | A unique ID number for the list. |
| LOCALVALUE | PURCHORD_HDR | | AS | No | The value of the Purchase Order in the local currency. |
| LOCATION | CR_INVLINES | | INTEGER | No | The location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header. |
| LOCKED | PERIOD_STATUS | | CHAR(1) | No | 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 |
| LOGINID | STAFF | | VARCHAR(30) | Yes | The staff member's login ID. This is the ID used to log in to the EXO Business system. |
| LONGITUDE | CR_ACCS | | FLOAT(53) | No | The Creditor's longitude. |
| LONGITUDE | CONTACTS | | FLOAT(53) | No | The Contact's longitude. |
| LOOKUP_RECOVERABLE | STOCK_ITEMS | | CHAR(1) | No | If this field contains 'Y', the stock item is a recoverable expense in EXO Job Costing. |
| MANUAL_ROUNDING | CR_TRANS | | FLOAT(53) | Yes | This field contains the manual rounding amount (if any). |
| MAXSTOCK | STOCK_ITEMS | | FLOAT(53) | No | The maximum default stock level for each location. |
| MENU_NO | STAFF | FK | INTEGER | No | The ID number of the Menu Definition specified for the staff member. Corresponds to the menu's SEQNO field in the MENU_COLLECTION table. |
| MINGLSEQNO | PERIOD_STATUS | | INTEGER | No | The first transaction for the period found in the GLTRANS table. |
| MINORDLINESEQNO | PERIOD_STATUS | | INTEGER | No | 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. |
| MINORDSEQNO | PERIOD_STATUS | | INTEGER | No | 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. |
| MINQTY | CR_PRICES | | FLOAT(53) | No | Minimum quantity for the price rule to apply. |
| MINSTOCK | STOCK_ITEMS | | FLOAT(53) | No | The minimum default stock level for each location. |
| MINSTOCKSEQNO | PERIOD_STATUS | | INTEGER | No | The first transaction for the period found in the Stock ledger. |
| MINTRANLINESEQNO | PERIOD_STATUS | | INTEGER | No | 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. |
| MINTRANSEQNO | PERIOD_STATUS | | INTEGER | No | 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. |
| MOBILE | CONTACTS | | VARCHAR(30) | No | The Contact's mobile phone number. |
| MOBILE | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| MOBILE_ACCESS | STAFF | | CHAR(1) | Yes | This field contains 'Y' if the staff member is authorised to use the EXO OnTheGo mobile app. |
| MONTHUNITS | STOCK_ITEMS | | FLOAT(53) | No | Sales totals in terms of quantity for the current month. |
| MONTHVAL | CR_ACCS | | FLOAT(53) | No | Turnover for the current month. |
| MONTHVALUE | STOCK_ITEMS | | FLOAT(53) | No | Sales value for the current month. |
| MSN_ID | CONTACTS | | VARCHAR(45) | No | The Contact's MSN ID number. |
| NAME | CR_ACCS | | VARCHAR(60) | No | The Creditor's name. |
| NAME | STAFF | | VARCHAR(30) | No | The staff member's full name. |
| NAME | TAX_RATES | | VARCHAR(30) | No | The full name of the taxation rate. |
| NAME | GLACCS | | VARCHAR(40) | No | The account name. |
| NAME | CR_TRANS | | VARCHAR(70) | No | The ID number and name of the Creditor account against which the transaction was generated. |
| NARRATIVE | NARRATIVES | | VARCHAR(4096) | No | The text of the narrative. |
| NARRATIVE_SEQNO | CR_PRICES | | INTEGER | No | Not used. |
| NARRATIVE_SEQNO | CR_INVLINES | FK | INTEGER | No | The SEQNO for the narrative on this line. |
| NARRATIVE_SEQNO | PURCHORD_HDR | FK | INTEGER | No | The ID number of the narrative attached to the Sales Order header. |
| NARRATIVE_SEQNO | CR_TRANS | | INTEGER | No | ID number of the narrative attached to the transaction. |
| NICKNAME | STAFF | | VARCHAR(15) | No | A short nickname for the employee. |
| NON_STOCK_AUTH_AMT | STAFF | | FLOAT(53) | No | The staff member's Non-Stock Purchase Order Authorisation Limit. |
| NOTE | CR_CONT_HIST | | VARCHAR(4096) | No | The main body of the History Note. |
| NOTES | CR_ACCS | | VARCHAR(4096) | No | All notes entered for the Creditor on the Notes tab. |
| NOTES | CONTACTS | | VARCHAR(4096) | No | All notes entered for the Contact on the Notes tab. |
| NOTES | GLACCS | | VARCHAR(4096) | No | Any notes on the GL account. |
| NOTES | STOCK_ITEMS | | VARCHAR(4096) | No | Any notes for the stock item. |
| NOTES | CR_CONTACTS | | VARCHAR(4096) | No | Taken from the associated record in the CONTACTS table. |
| NUMDECIMALS | STOCK_ITEMS | | INTEGER | Yes | The number of decimal places that can be entered for the stock item's quantity. |
| N_CR_DISC | CR_ACCS | | FLOAT(53) | No | 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'). |
| N_LAND_COST_PROVN | CR_ACCS | | FLOAT(53) | No | This value is used to calculate the Fixed cost for any Inwards Goods for the account. |
| N_TOTVENDISC | CR_TRANS | | FLOAT(53) | No | The total vendor discount. |
| N_TOTVENDISC_EXCLTAX | CR_TRANS | | FLOAT(53) | No | The total vendor discount, excluding tax. |
| OPENINGBAL | GLACCS | | FLOAT(53) | No | The account's opening balance. |
| OPENITEM | CR_ACCS | | CHAR(1) | No | This field contains 'Y' if this is not a balance brought forward account. |
| OPTOUT_EMARKETING | CONTACTS | | CHAR(1) | No | 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). |
| ORDERDATE | PURCHORD_HDR | | DATETIME | No | The date and time when the Purchase Order was created. |
| ORDTOTAL | PURCHORD_HDR | | AS | No | The total amount for the Sales Order. |
| OUTLOOK_LINK | CR_CONT_HIST | | VARCHAR(40) | No | If the History Note was emailed, this field contains a link to the email in MS Outlook. |
| PACK | STOCK_ITEMS | | VARCHAR(10) | No | Describes the unit of sale for pricing, e.g. EACH or PACK. |
| PASSWORD_CHANGED | STAFF | | DATETIME | Yes | The date and time when the staff member's password was last changed. |
| PAYROLL_ID | STAFF | | VARCHAR(15) | No | 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. |
| PAYSTATUS | CR_TRANS | | INTEGER | No | The pay status of the transaction. Will be one of: -1 = HELD 0 = NOT RELEASED 1 = RELEASED |
| PAY_TYPE | CR_ACCS | | INTEGER | No | The default payment method. |
| PERIODNAME | PERIOD_STATUS | | VARCHAR(20) | No | The name/description for the period. |
| PERIOD_SEQNO | PERIOD_STATUS | | INTEGER | Yes | The period's sequence number within fiscal year. |
| PERIOD_SEQNO | CR_TRANS | FK | INTEGER | Yes | ID number of the period that the transaction is in. |
| PERIOD_SEQNO | CR_ALLOCATIONS | FK | INTEGER | Yes | The period in which the allocation took place. |
| PERIOD_SHORTNAME | PERIOD_STATUS | | VARCHAR(8) | No | A short name for the period. |
| PHONE | CR_ACCS | | VARCHAR(30) | No | The Creditor's phone number. |
| PHONE | STAFF | | VARCHAR(30) | No | The staff member's work telephone number. |
| POSTTIME | CR_TRANS | | DATETIME | No | The actual date/time the transaction was posted at. |
| POSTTIME | CR_CONT_HIST | | DATETIME | No | The actual date and time that the record was posted. |
| POSTTIME | CR_INVLINES_SERIALS | | DATETIME | No | The date and time when the line was saved to the database. |
| POST_CODE | CONTACTS | | VARCHAR(12) | No | The Contact's post code. |
| POST_CODE | CR_CONTACTS | | VARCHAR(12) | No | Taken from the associated record in the CONTACTS table. |
| POST_CODE | CR_ACCS | | VARCHAR(12) | No | The Creditor's postal code. |
| PO_SEQNO | CR_TRANS | FK | INTEGER | No | For invoices generated from Purchase Orders, this field holds the SEQNO of the Purchase Order. |
| PP_BATCHREF | CR_TRANS | | VARCHAR(20) | No | This field contains the Creditors Payment Processor batch reference. |
| PP_TOPAY | CR_ACCS | | CHAR(1) | No | The pay status from the Creditors Payment Processor. |
| PQTY | STOCK_ITEMS | | FLOAT(53) | No | |
| PREV_PERIOD_CLOSE | CR_TRANS | | FLOAT(53) | No | Balance as at the end of the previous period. |
| PREV_PERIOD_OPEN | CR_TRANS | | FLOAT(53) | No | Balance as at the start of the previous period. |
| PRICE | CR_PRICES | | FLOAT(53) | No | The substitute price to be applied to the stockcode/group. |
| PRICEPERKG | STOCK_ITEMS | | FLOAT(53) | No | The stock item's sell price per kg. |
| PRICEQTY | STOCK_ITEMS | | FLOAT(53) | No | The stock item's sell price per quantity. |
| PRIOR_AGEDBAL0 | CR_ACCS | | FLOAT(53) | No | Prior Aged Balance for the current month. |
| PRIOR_AGEDBAL1 | CR_ACCS | | FLOAT(53) | No | Prior Aged Balance for the previous month. |
| PRIOR_AGEDBAL2 | CR_ACCS | | FLOAT(53) | No | Prior Aged Balance for two months ago. |
| PRIOR_AGEDBAL3 | CR_ACCS | | FLOAT(53) | No | Prior Aged Balance for three months ago. |
| PRIOR_BALANCE | CR_ACCS | | AS | No | The sum of all Prior Aged Balances. |
| PRIVATE_ACC | GLACCS | | CHAR(1) | Yes | This field is set to 'Y' if the GL account is a private account. |
| PRIVATE_ACC | CR_ACCS | | CHAR(1) | Yes | 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. |
| PROCESSFINALISATION | PURCHORD_HDR | | INTEGER | No | Will be one of:
0 = Normal
1 = Deleted
2 = Forced Fully Processed |
| PROMPT_PAY_DISC | CR_ACCS | | FLOAT(53) | No | The prompt payment discount percentage for the Creditor. |
| PTNO | CR_TRANS | | INTEGER | No | The payment number. |
| PURCHTAXRATE | STOCK_ITEMS | | INTEGER | No | Default GST rate for purchase transactions. |
| PURCH_ACCNO | CR_TRANS | | INTEGER | No | 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. |
| PURCH_GLSUBCODE | STOCK_ITEMS | | INTEGER | No | The default GL sub-account code that purchase transactions for this stock item are posted to. |
| PURCH_GL_CODE | STOCK_ITEMS | FK | INTEGER | No | The GL code that purchase transactions for this stock are posted to. |
| QUANTITY | CR_INVLINES | | FLOAT(53) | No | The quantity for this line. |
| RATE | TAX_RATES | | FLOAT(53) | No | The percentage taxation rate. |
| RECEIPTNO | CR_TRANS | | INTEGER | No | If the transaction is sourced from Inwards Goods, this field contains the Inwards Goods receipt ID. |
| REF1 | CR_TRANS | | VARCHAR(20) | No | 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. |
| REF2 | CR_TRANS | | VARCHAR(20) | No | 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. |
| REF3 | CR_TRANS | | VARCHAR(30) | No | For payments, this field contains the text 'PAYMENT'. For invoices, this field contains the text 'Invoice'. |
| REFERENCE | PURCHORD_HDR | | VARCHAR(20) | No | An additional reference code for the Purchase Order. |
| RELEASEDAMT | CR_TRANS | | FLOAT(53) | No | The released amount (applies to the Creditors Payment Processor). |
| REMITTANCE_METHOD | CR_ACCS | | VARCHAR(20) | No | How remittance advice should be sent to the Creditor. Will be one of:
None
E-Mail
Print
Both |
| REPORTCODE | CR_ACCGROUP2S | | VARCHAR(15) | No | A report code for the group. |
| REPORTCODE | GLACCS | | VARCHAR(15) | No | The report code used by the GL account. |
| REPORTCODE | CR_ACCGROUPS | | VARCHAR(15) | No | A report code for the group. |
| REPORTCODE | PERIOD_STATUS | | VARCHAR(8) | No | A code used for reporting purposes. |
| REPORTS_TO_STAFFNO | STAFF | | INTEGER | No | The ID number of the staff member that this staff member reports to. |
| RESTRICTED_ITEM | STOCK_ITEMS | | CHAR(1) | Yes | This field is set to 'Y' if the stock item is a restricted item. |
| RE_MOVEMENTS | CURRENCIES | | FLOAT(53) | No | This field relates to the Intercompany module. |
| SALESNO | CONTACTS | FK | INTEGER | No | The STAFFNO of staff member who is set as the Sales person for the Contact. |
| SALESNO | CR_CONT_HIST | FK | INTEGER | No | The ID of the staff member selected on the History Note. |
| SALESNO | PURCHORD_HDR | | INTEGER | No | The ID number of the staff member assigned to the Purchase Order. |
| SALESNO | CR_TRANS | | INTEGER | No | The ID number of the salesperson assigned to the transaction. |
| SALESNO | CR_ACCS | FK | INTEGER | No | ID number of the staff member assigned to the Creditor account. |
| SALESTAXRATE | STOCK_ITEMS | | INTEGER | No | Default GST rate for sales transactions. |
| SALES_GLSUBCODE | STOCK_ITEMS | | INTEGER | No | The default GL sub-account code that sales transactions for this stock item are posted to. |
| SALES_GL_CODE | STOCK_ITEMS | FK | INTEGER | No | The default GL code that sales transactions for this stock item are posted to. |
| SALUTATION | CR_CONTACTS | | VARCHAR(4) | No | Taken from the associated record in the CONTACTS table. |
| SALUTATION | CONTACTS | | VARCHAR(4) | No | The Contact's preferred salutation, e.g. Mr, Mrs. |
| SBR_REFRESHTOKEN | STAFF | | VARCHAR(1024) | No | The refresh token used for SBR authentication. |
| SECTION | GLACCS | | INTEGER | No | This field is set to 0 for Profit and loss accounts or 1 for Balance sheet accounts. |
| SECURITYPROFILEID | STAFF | | INTEGER | Yes | The ID number of the staff member's Security profile. Corresponds to the profile's ID field in the PROFILE table. |
| SELLPRICE1 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 1. |
| SELLPRICE10 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 10. |
| SELLPRICE2 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 2. |
| SELLPRICE3 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 3. |
| SELLPRICE4 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 4. |
| SELLPRICE5 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 5. |
| SELLPRICE6 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 6. |
| SELLPRICE7 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 7. |
| SELLPRICE8 | STOCK_ITEMS | | FLOAT(53) | No | Sell price 8. |
| SELLPRICE9 | STOCK_ITEMS | | AS | No | Sell price 9. |
| SELLRATE | CURRENCIES | | FLOAT(53) | No | The sell rate (for sales). |
| SEND_PAYMENT_REMITTANCE | CR_ACCS | | CHAR(1) | Yes | 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. |
| SEQNO | CONTACTS | PK | INTEGER | Yes | A unique identifier for the Contact record. |
| SEQNO | CR_ALLOCATIONS | PK | INTEGER | Yes | A unique ID number for the allocation. |
| SEQNO | TAX_RATES | PK | INTEGER | Yes | A unique ID number for the tax rate. |
| SEQNO | CR_CONTACTS | PK | INTEGER | Yes | A unique identifier for the Creditor Contact. The identifier for the Contact record is specified by the CONTACT_SEQNO field. |
| SEQNO | CR_CONT_HIST | PK | INTEGER | Yes | A unique identifier for the record. |
| SEQNO | CR_INVLINES_SERIALS | PK | INTEGER | Yes | A unique ID number for the line. |
| SEQNO | PERIOD_STATUS | PK | INTEGER | Yes | A unique ID number for the period. |
| SEQNO | CR_PRICES | PK | INTEGER | Yes | A unique ID number for the price record. |
| SEQNO | CR_TRANS | PK, FK | INTEGER | Yes | A unique transaction ID. |
| SEQNO | PURCHORD_HDR | PK | INTEGER | Yes | A unique ID number for the Purchase Order. |
| SEQNO | CR_INVLINES | PK | INTEGER | Yes | A unique transaction line ID. |
| SEQNO | NARRATIVES | PK | INTEGER | Yes | A unique ID number for the narrative. |
| SERIALNO | CR_INVLINES_SERIALS | | VARCHAR(50) | No | The serial number. |
| SERIALNO_TYPE | STOCK_ITEMS | | INTEGER | Yes | 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 |
| SESSION_ID | CR_TRANS | | INTEGER | No | The session ID number. |
| SHORTNAME | TAX_RATES | | VARCHAR(6) | No | A short name for the taxation rate. |
| SHOWLINE | CR_INVLINES | | CHAR(1) | No | This field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed. |
| SKYPE_ID | CONTACTS | | VARCHAR(45) | No | The Contact's Skype ID number. |
| SMTP_SEQNO | STAFF | | INTEGER | No | 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. |
| SO_SOURCE_REF | PURCHORD_HDR | | VARCHAR(20) | No | If the Purchase Order was generated from a Sales Order, the Sales Order's ID number is recorded here. |
| STAFFNO | STAFF | PK | INTEGER | Yes | A unique identifier for the staff record. |
| STARTDATE | PERIOD_STATUS | | DATETIME | No | The start date for the period. |
| STARTDATE | CR_PRICES | | DATETIME | No | Date from which the price rule is active. |
| STATEMENT_CONTACT_SEQNO | CR_ACCS | | INTEGER | No | The ID number of the Contact who is assigned as the Creditor's Remittance Contact. |
| STATEMENT_TEXT | CR_ACCS | | VARCHAR(256) | No | 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. |
| STATUS | PURCHORD_HDR | | INTEGER | No | The status of the Purchase Order. Will be one of:
0 = Not Processed
1 = Partly Processed
2 = Fully Processed |
| STATUS | STOCK_ITEMS | | CHAR(1) | No | The stock item's status. Will be one of:
S = Stock item
L = Lookup item |
| STDCOST | STOCK_ITEMS | | FLOAT(53) | No | The stock item's standard cost. |
| STOCKCODE | STOCK_ITEMS | PK | VARCHAR(23) | Yes | A unique ID code for the stock item. |
| STOCKCODE | CR_PRICES | | VARCHAR(23) | No | If the price rule is defined for an individual Stock item, this field stores the item's stockcode. |
| STOCKCODE | CR_INVLINES | FK | VARCHAR(23) | No | Code of the Stock item on this line. |
| STOCKGROUP | STOCK_ITEMS | FK | INTEGER | No | The Primary (Fine) Stock Group that the item belongs to. |
| STOCKGROUP2 | STOCK_ITEMS | FK | INTEGER | No | The stock item's Secondary (Coarse) Stock Group. |
| STOCKPRICEGROUP | CR_PRICES | | INTEGER | No | If the price rule is defined against a price group rather than an individual product, this field stores the Stock price group. |
| STOCKPRICEGROUP | STOCK_ITEMS | FK | INTEGER | No | The price group that the stock item belongs to. |
| STOCK_AUTH_AMT | STAFF | | FLOAT(53) | No | The staff member's Stock Purchase Order Authorisation Limit. |
| STOCK_CLASSIFICATION | STOCK_ITEMS | FK | INTEGER | Yes | The stock classification that the item belongs to. |
| STOPCREDIT | CR_ACCS | | CHAR(1) | No | If 'Y', the Creditor is on Stop Credit, and no further transactions will take place. |
| STOPDATE | CR_PRICES | | DATETIME | No | Date to which the price rule remains active. |
| STOPDATE | PERIOD_STATUS | | DATETIME | No | The end date for the period. |
| SUB1 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB1 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 1 is ticked on the Marketing tab. |
| SUB10 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB10 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 10 is ticked on the Marketing tab. |
| SUB11 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 11 is ticked on the Marketing tab. |
| SUB11 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB12 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 12 is ticked on the Marketing tab. |
| SUB12 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB13 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB13 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 13 is ticked on the Marketing tab. |
| SUB14 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 14 is ticked on the Marketing tab. |
| SUB14 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB15 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB15 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 15 is ticked on the Marketing tab. |
| SUB16 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB16 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 16 is ticked on the Marketing tab. |
| SUB17 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 17 is ticked on the Marketing tab. |
| SUB17 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB18 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 18 is ticked on the Marketing tab. |
| SUB18 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB19 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB19 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 19 is ticked on the Marketing tab. |
| SUB2 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 2 is ticked on the Marketing tab. |
| SUB2 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB20 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 20 is ticked on the Marketing tab. |
| SUB20 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB21 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 21 is ticked on the Marketing tab. |
| SUB21 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB22 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 22 is ticked on the Marketing tab. |
| SUB22 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB23 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 23 is ticked on the Marketing tab. |
| SUB23 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB24 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 24 is ticked on the Marketing tab. |
| SUB24 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB25 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 25 is ticked on the Marketing tab. |
| SUB25 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB26 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 26 is ticked on the Marketing tab. |
| SUB26 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB3 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB3 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 3 is ticked on the Marketing tab. |
| SUB4 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 4 is ticked on the Marketing tab. |
| SUB4 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB5 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB5 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 5 is ticked on the Marketing tab. |
| SUB6 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB6 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 6 is ticked on the Marketing tab. |
| SUB7 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 7 is ticked on the Marketing tab. |
| SUB7 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB8 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 8 is ticked on the Marketing tab. |
| SUB8 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUB9 | CONTACTS | | CHAR(1) | No | This field is set to 'Y' if Marketing Class number 9 is ticked on the Marketing tab. |
| SUB9 | CR_CONTACTS | | CHAR(1) | No | Taken from the associated record in the CONTACTS table. |
| SUBJECT | CR_CONT_HIST | | VARCHAR(80) | No | The subject line of the History Note. |
| SUBTOTAL | PURCHORD_HDR | | FLOAT(53) | No | The subtotal amount on the Purchase Order. |
| SUBTOTAL | CR_TRANS | | FLOAT(53) | No | The tax-exclusive amount, in the currency of the Creditor account. |
| SUPPLIERCOST | STOCK_ITEMS | | FLOAT(53) | Yes | The supplier cost price. |
| SUPPLIERNO | STOCK_ITEMS | FK | INTEGER | No | The ID number (CR_ACCS.ACCNO) of the stock item's main supplier. |
| SUPPLIERNO2 | STOCK_ITEMS | | INTEGER | No | Alternate supplier for the stock item. |
| SUPPLIERNO3 | STOCK_ITEMS | | INTEGER | No | Alternate supplier for the stock item. |
| SYNC_CONTACTS | CONTACTS | | CHAR(1) | Yes | This field is set to 'Y' if the Contact is set to sync with Microsoft Outlook. |
| TAKENUP | CR_ALLOCATIONS | | CHAR(1) | No | This field is a flag that specify whether or not the allocation has been a part of realised gain/losses. |
| TAXINC | CR_TRANS | | CHAR(1) | No | Y = tax inclusive, N = tax exclusive. |
| TAXINC | PURCHORD_HDR | | CHAR(1) | No | Set to 'Y' if the Purchase Order is tax-inclusive. |
| TAXRATE | CR_TRANS | | FLOAT(53) | No | The tax rate used by the transaction, e.g. 12.5 = 12.5%. |
| TAXRATE | CR_INVLINES | | FLOAT(53) | No | The percentage tax rate on the line at the time of the transaction. |
| TAXRATE_NO | CR_INVLINES | FK | INTEGER | No | The ID number of the tax rate used by the transaction. |
| TAXRATE_NO | CR_TRANS | FK | INTEGER | No | The ID number of the tax rate used by the transaction. |
| TAXREG | CR_ACCS | | VARCHAR(30) | No | GST/ABN number of the Creditor. |
| TAXRETCODE | CR_TRANS | | VARCHAR(15) | No | The tax return code for the GST return that this transaction applies to. |
| TAXSTATUS | CR_ACCS | | INTEGER | No | The Override GST rate for the Creditor. |
| TAXSTATUS | GLACCS | | INTEGER | No | The Override GST rate specified for the GL account. A value of -1 corresponds to the AUTO SELECT RATE option. |
| TAXTOTAL | PURCHORD_HDR | | FLOAT(53) | No | The total tax amount on the Purchase Order. |
| TAXTOTAL | CR_TRANS | | FLOAT(53) | No | The tax total in the currency of the Creditor account. |
| TAX_LOCALITY | CR_ACCS | | VARCHAR(27) | No | Suburb, Town or Locality used for online tax submissions, e.g. TPAR. |
| TITLE | CR_CONTACTS | | VARCHAR(30) | No | Taken from the associated record in the CONTACTS table. |
| TITLE | CONTACTS | | VARCHAR(30) | No | The Contact's job title. |
| TOAGEDBAL | CR_TRANS | | INTEGER | No | 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 |
| TOTALSTOCK | STOCK_ITEMS | | FLOAT(53) | Yes | Total units of stock for the item. |
| TRACK_CITP | CR_ACCS | | CHAR(1) | Yes | 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". |
| TRANSDATE | CR_CONT_HIST | | DATETIME | No | The transaction date against the History Note. |
| TRANSDATE | CR_TRANS | | DATETIME | No | The date/time mentioned in the transaction itself. |
| TRANSTYPE | CR_TRANS | | INTEGER | No | 1 = Postive amount is Invoice, Negative amount is Credit; 4 = Negative amount is Payment, Positive amount is Refund |
| TRANS_SEQNO | CR_ALLOCATIONS | FK | INTEGER | No | This field is a link back to the original transaction line in CR_TRANS table (CR_TRANS.SEQNO). |
| TWITTER | CONTACTS | | VARCHAR(500) | No | The Contact's Twitter username. |
| TWITTER | CR_ACCS | | VARCHAR(500) | No | The Creditor's Twitter username. |
| TWITTER_TOKEN_KEY | STAFF | | VARCHAR(max) | No | 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. |
| TWITTER_TOKEN_SECRET | STAFF | | VARCHAR(max) | No | 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. |
| TXID | PURCHORD_HDR | | VARBINARY(256) | No | The Transaction ID assigned to the Purchase Order - this applies when using a payment gateway. |
| TXID | CR_TRANS | | VARBINARY(256) | No | 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. |
| UNITPRICE | CR_INVLINES | | FLOAT(53) | No | The unit price of the Stock item on this line. |
| UNITPRICE_INCTAX | CR_INVLINES | | FLOAT(53) | No | The unit price of the Stock item on this line, inclusive of tax. |
| UNREALISED_GAINS_GL_BATCH | CR_TRANS | | INTEGER | Yes | The batch number for the unrealised gains journal that the transaction is a part of. Reset to zero when the journal is reversed. |
| UPDATEITEM_CODE | STOCK_ITEMS | | VARCHAR(23) | No | Only applies to lookup items. The ID number of the stocked item that maintains the actual stock. |
| UPDATEITEM_QTY | STOCK_ITEMS | | FLOAT(53) | No | Only applies to lookup items. Quantity of the stocked item. |
| UPDATE_STOCK | CR_INVLINES | | CHAR(1) | No | If this field is set to 'Y', stock movements are created via the trigger CR_INVLINES_POST. The field is then set to 'T'. |
| USERPROFILEID | STAFF | | INTEGER | Yes | The ID number of the staff member's User profile. Corresponds to the profile's ID field in the PROFILE table. |
| USESUBCODES | GLACCS | | CHAR(1) | No | Not used. |
| VARIABLECOST | STOCK_ITEMS | | CHAR(1) | Yes | The field is set to 'Y for Variable Cost stock items. |
| WEBSITE | CR_ACCS | | VARCHAR(30) | No | URL of the Creditor's website. |
| WEB_SHOW | STOCK_ITEMS | | CHAR(1) | No | |
| WEIGHT | STOCK_ITEMS | | FLOAT(53) | No | Physical weight of the stock item. |
| X_COLOURID | STOCK_ITEMS | | INTEGER | No | Style colour ID of the stock item. Used by the Style, Size Colour functionality. |
| X_SIZEID | STOCK_ITEMS | | INTEGER | No | Style size ID of the stock item. Used by the Style, Size Colour functionality. |
| YAHOO_ID | CONTACTS | | VARCHAR(45) | No | The Contact's Yahoo! ID number. |
| YEARAGE | PERIOD_STATUS | | INTEGER | Yes | The ageing of the year that the period falls in. The current year has an age of 0. |
| YEARUNITS | STOCK_ITEMS | | FLOAT(53) | No | Year to date sales totals in terms of quantity. |
| YEARVAL | CR_ACCS | | FLOAT(53) | No | Turnover for the current year. |
| YEARVALUE | STOCK_ITEMS | | FLOAT(53) | No | Sales value for the current year. |