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 | GLACCS | | INTEGER | No | The GL account's Account Group. |
ACCNO | JOBCOST_HDR | FK | INTEGER | No | The number of the Debtor account that the job belongs to. |
ACCNO | GLACCS | PK | INTEGER | Yes | The unique GL account number. |
ACCOUNT_STATUS | STAFF | | INTEGER | Yes | The staff member's account status. Will be one of: 0 = Account OK 1 = Account Locked 2 = Password Expired |
ACTIONBY | JOBCOST_HDR | FK | INTEGER | No | The staff member who is the Job Manager for the job. |
ACTUAL_UNITCOST | JOBCOST_LINES | | FLOAT(53) | No | The original unit cost on the line. |
ADMIN_STAT | JOB_STATUS | | VARCHAR(1) | No | If this field contains 'Y', the status prevents entry of new transactions. |
ALERT | STOCK_ITEMS | | VARCHAR(60) | No | Text of the pop-up alert message that appears when the stock item is sold or purchased. |
ALINENO | JOBCOST_LINES | | INTEGER | No | A rank ID that determines the order in which lines are displayed. |
ALINENO | JOB_TRANSACTIONS | | INTEGER | Yes | A rank ID that determines the order in which lines are displayed. |
ALLOCATED_COSTS | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The Allocated Costs amount on the line. |
ALLOWANCE | JOB_TRANSACTIONS | | FLOAT(53) | Yes | Unit labour allowance associated with the stock item. |
ALLOWANCE | JOBCOST_HDR | | FLOAT(53) | Yes | |
ALLOWANCE_FACTOR | JOB_TIMESHEET_ALLOWANCE_TYPES | | INTEGER | No | |
ALLOWANCE_ID | JOB_TIMESHEET_ALLOWANCE | FK | VARCHAR(5) | No | The short ID code of the allowance type on this line. |
ALLOWANCE_ID | JOB_TIMESHEET_ALLOWANCE_TYPES | | VARCHAR(5) | No | A short ID code for the type. |
ALLOWJOURNAL | GLACCS | | CHAR(1) | No | This field is set to 'Y' if the GL account allows journals. |
ALLOW_ALLOCATION | JOB_CONTRACT_BILLINGS | | CHAR(1) | Yes | |
ANALYSIS | JOB_TRANSACTIONS | | INTEGER | No | |
ANALYSIS | JOBCOST_LINES | | INTEGER | No | |
API_ACCESS | STAFF | | CHAR(1) | No | This field contains 'Y' if the staff member is authorised to use the EXO API. |
APPOINTMENT_SCHEDULED | JOB_RESOURCE_ALLOCATION | | CHAR(1) | Yes | This field contains 'Y' if an appointment has been scheduled for the allocation. |
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. |
ASSET_COST | JOBCOST_HDR | | FLOAT(53) | No | The cost of the asset(s) created on the job. |
ASSET_VALUE | JOBCOST_HDR | | FLOAT(53) | No | The value of the asset(s) created on the job. |
AUTH_AMT | STAFF | | FLOAT(53) | No | The staff member's Credit Invoice Authorisation Limit. |
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. |
AVECOST_IN | JOB_TRANSACTIONS | | FLOAT(53) | No | The Average cost of the item coming into the WIP location. |
AVECOST_OUT | JOB_TRANSACTIONS | | FLOAT(53) | No | The Average cost of the item going out of the WIP location |
BAD_LOGIN_COUNT | STAFF | | INTEGER | Yes | The number of times the staff member has attempted to log in but failed. |
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. |
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. |
BATCHCODE | JOBCOST_LINES | | VARCHAR(20) | No | The batch code on the line, if there is one. |
BATCHCODE | JOB_TRANSACTIONS | | VARCHAR(20) | No | Batch code. |
BILLINGMODE | JOBCOST_HDR | | INTEGER | No | The billing mode on the job. Will be one of: 0 = Charge-up 1 = Invoice ex-quote 2 = Manufacture - output items 3 = Progress invoices |
BILLING_ID | JOB_TRANSACTIONS | | INTEGER | No | The Billing ID, if one exists. |
BILLING_REF | JOB_TRANSACTIONS | | VARCHAR(20) | No | The Billing Reference, if one exists. |
BINCODE | STOCK_ITEMS | | VARCHAR(12) | No | Bincode for the stock item. |
BOMPRICING | JOB_TRANSACTIONS | | CHAR(1) | No | Will be one of: N = normal C = pricing by component (BOMs) T= pricing by total (BOMs) |
BOMPRICING | JOBCOST_LINES | | CHAR(1) | No | Will be one of: N = normal C = pricing by component (BOMs) T= pricing by total (BOMs) |
BOMTYPE | JOBCOST_LINES | | CHAR(1) | No | Will be one of: N = Normal stock item B = Build K = Kit L = Lookup item |
BOMTYPE | JOB_TRANSACTIONS | | CHAR(1) | No | Will be one of: N = Normal stock item B = Build K = Kit L = Lookup item |
BRANCHNO | JOB_TRANSACTIONS | FK | INTEGER | No | The ID number of the branch that the line belongs to (from BRANCHES). |
BRANCHNO | JOBCOST_HDR | FK | INTEGER | No | The job's branch. |
BRANCHNO | JOBCOST_LINES | FK | INTEGER | No | The ID number of the branch that the line belongs to (from BRANCHES). |
BRANCHNO | STOCK_ITEMS | | INTEGER | No | Branch number for the stock item. |
CALLBACKDATE | JOBCOST_HDR | | DATETIME | No | The Follow Up date on the job. |
CAMPAIGN_WAVE_SEQNO | JOBCOST_HDR | FK | INTEGER | No | The ID number of the campaign wave (EXO CRM) that the job is associated with, if there is one. |
CATDESC | JOB_CATEGORIES | | VARCHAR(40) | No | A descriptive name for the category. |
CATEGORY | JOBCOST_HDR | FK | INTEGER | No | The ID number of the job's category (from JOB_CATEGORIES). |
CATNO | JOB_CATEGORIES | PK | INTEGER | Yes | A unique ID number for the Job Category. |
COGSMETHOD | STOCK_ITEMS | | INTEGER | Yes | |
COMPLETED | JOBCOST_HDR | | DATETIME | No | The date when the job was completed. |
CONSOLIDATE | JOB_COSTGROUPS | | CHAR(1) | No | This field contains 'T' if the group's "Consolidate" option is ticked; otherwise 'F'. |
CONSOLIDATE | JOB_COSTTYPES | | CHAR(1) | No | This field contains 'T' if the type's "Consolidate" option is ticked; otherwise 'F'. |
CONTACT | JOBCOST_HDR | | VARCHAR(50) | No | The contact person associated with the job. |
CONTACTNO | JOBCOST_HDR | | INTEGER | No | The ID number of the contact person on the job. |
COPY_FROM_QUOTE | JOBCOST_LINES | | CHAR(1) | Yes | The destination of quote lines. Will be one of: T = Timesheets tab P = Purchases tab C = Costs tab N = none |
COPY_FROM_QUOTE | JOB_COSTTYPES | | CHAR(1) | No | This field indicates what the group's "Copy from quote to:" option is set to. Will be one of: N = None C = Costs T = Timesheet P = Purchase |
COPY_FROM_QUOTE | JOB_COSTGROUPS | | CHAR(1) | No | This field indicates what the group's "Copy from quote to:" option is set to. Will be one of: N = None C = Costs T = Timesheet P = Purchase |
COSTDESC | JOB_COSTTYPES | | VARCHAR(50) | No | A descriptive name for the type. |
COSTDESC | JOB_COSTGROUPS | | VARCHAR(50) | No | A descriptive name for the group. |
COSTGL | JOBCOST_HDR | FK | INTEGER | No | The Cost GL account. |
COSTGLSQL | JOBCOST_GENERAL_INFO | | VARCHAR(500) | No | No longer used. |
COSTGROUP | STOCK_ITEMS | | INTEGER | Yes | |
COSTRATE | JOB_TIMESHEETS_RATES | | FLOAT(53) | No | The factor by which the cost of transactions entered with this rate type will be multiplied when posting to a job. |
COSTRATE0 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
COSTRATE1 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
COSTRATE2 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
COSTRATE3 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
COSTSELECTSQL | JOBCOST_GENERAL_INFO | | VARCHAR(255) | No | No longer used. |
COSTSUBGL | JOBCOST_HDR | | INTEGER | No | The Cost GL sub-account. |
COSTTYPE | STOCK_ITEMS | | INTEGER | Yes | |
COST_CENTRE | JOBCOST_LINES | FK | INTEGER | No | The ID number of the Cost Type on the line (from JOB_COSTTYPES). |
COST_CENTRE | JOB_TRANSACTIONS | | BIGINT | Yes | Cost Centre ID (only applicable when timesheets are integrated with MYOB EXO Payroll). |
COST_CENTRE2 | JOBCOST_LINES | FK | INTEGER | No | The ID number of the Cost Group on the line (from JOB_COSTGROUPS). |
COST_GROUP | JOB_TRANSACTIONS | FK | INTEGER | No | The ID number of the Cost Group on the line (from JOB_COSTGROUPS). |
COST_GROUP | JOB_TIMESHEETS | | INTEGER | No | |
COST_LINENO | JOBCOST_LINES | | INTEGER | Yes | This field stores the COST_LINENO from DR_INVLINES/DR_INVLINES_PARK. |
COST_LINENO | JOB_TRANSACTIONS | | INTEGER | Yes | This field stores the COST_LINENO from DR_INVLINES. |
COST_TYPE | JOB_TIMESHEETS | | INTEGER | No | |
COST_TYPE | JOB_TRANSACTIONS | FK | INTEGER | No | The ID number of the Cost Type on the line (from JOB_COSTTYPES). |
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. |
CREDIT_SCHEDULE_SEQNO | JOB_TRANSACTIONS | | INTEGER | Yes | This field stores the ID number of the Billing Schedule record that the current record was credited in. |
CUBIC | STOCK_ITEMS | | FLOAT(53) | No | Cubic weight of the item. |
CURRENCYNO | JOB_TRANSACTIONS | FK | INTEGER | No | The ID number of the currency on the line (from CURRENCIES). |
CURRENCYNO | JOBCOST_LINES | FK | INTEGER | No | The ID number of the currency on the line (from CURRENCIES). |
CURRENCYNO | GLACCS | FK | INTEGER | No | The ID number of the currency that the GL account is in. |
CURRENCYNO | JOB_CONTRACT_BILLINGS | FK | INTEGER | Yes | This field displays the ID number of the currency that the billing record is in. |
CUSTORDNO | JOBCOST_HDR | | VARCHAR(15) | No | The customer's order number. |
DATAVERSION | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
DAY1 | JOB_TIMESHEETS | | FLOAT(53) | No | The number of hours entered for day 1. |
DAY1_NARRATIVE | JOB_TIMESHEETS | | INTEGER | No | If a narrative has been entered for the day, its ID number is recorded here. |
DAY1_POSTED | JOB_TIMESHEETS | | CHAR(1) | No | This field contain 'Y' day's times have been approved. |
DAY2 | JOB_TIMESHEETS | | FLOAT(53) | No | The number of hours entered for day 2. |
DAY2_NARRATIVE | JOB_TIMESHEETS | | INTEGER | No | If a narrative has been entered for the day, its ID number is recorded here. |
DAY2_POSTED | JOB_TIMESHEETS | | CHAR(1) | No | This field contain 'Y' day's times have been approved. |
DAY3 | JOB_TIMESHEETS | | FLOAT(53) | No | The number of hours entered for day 3. |
DAY3_NARRATIVE | JOB_TIMESHEETS | | INTEGER | No | If a narrative has been entered for the day, its ID number is recorded here. |
DAY3_POSTED | JOB_TIMESHEETS | | CHAR(1) | No | This field contain 'Y' day's times have been approved. |
DAY4 | JOB_TIMESHEETS | | FLOAT(53) | No | The number of hours entered for day 4. |
DAY4_NARRATIVE | JOB_TIMESHEETS | | INTEGER | No | If a narrative has been entered for the day, its ID number is recorded here. |
DAY4_POSTED | JOB_TIMESHEETS | | CHAR(1) | No | This field contain 'Y' day's times have been approved. |
DAY5 | JOB_TIMESHEETS | | FLOAT(53) | No | The number of hours entered for day 5. |
DAY5_NARRATIVE | JOB_TIMESHEETS | | INTEGER | No | If a narrative has been entered for the day, its ID number is recorded here. |
DAY5_POSTED | JOB_TIMESHEETS | | CHAR(1) | No | This field contain 'Y' day's times have been approved. |
DAY6 | JOB_TIMESHEETS | | FLOAT(53) | No | The number of hours entered for day 6. |
DAY6_NARRATIVE | JOB_TIMESHEETS | | INTEGER | No | If a narrative has been entered for the day, its ID number is recorded here. |
DAY6_POSTED | JOB_TIMESHEETS | | CHAR(1) | No | This field contain 'Y' day's times have been approved. |
DAY7 | JOB_TIMESHEETS | | FLOAT(53) | No | The number of hours entered for day 7. |
DAY7_NARRATIVE | JOB_TIMESHEETS | | INTEGER | No | If a narrative has been entered for the day, its ID number is recorded here. |
DAY7_POSTED | JOB_TIMESHEETS | | CHAR(1) | No | This field contain 'Y' day's times have been approved. |
DEFAULTWARRANTYNO | STOCK_ITEMS | | INTEGER | Yes | The default Warranty No for the stock item. |
DEFAULT_STOCKCODE | JOBCOST_RESOURCE | | VARCHAR(23) | No | If the resource has a default stockcode, it is recorded here. |
DEFDAYS | STOCK_ITEMS | | INTEGER | No | |
DEFDAYS | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
DEFFOLLOWUPDAYS | JOBCOST_GENERAL_INFO | | INTEGER | Yes | No longer used. |
DEFHOURS | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
DEFNONSTOCKCODE | JOBCOST_GENERAL_INFO | | VARCHAR(23) | No | No longer used. |
DEF_COSTGROUP | JOB_COSTTYPES | FK | INTEGER | No | The ID number of the Cost Group that this type belongs to. |
DEF_MARKUP | JOB_COSTGROUPS | | FLOAT(53) | No | The default markup on the group. |
DEF_MARKUP | JOB_COSTTYPES | | FLOAT(53) | No | The default markup percentage for the type. |
DEF_OVERHEAD | JOB_COSTGROUPS | | FLOAT(53) | No | The default overhead on the group. |
DEF_OVERHEAD | JOB_COSTTYPES | | FLOAT(53) | No | The default overhead percentage for the type. |
DEF_OVERHEAD | JOBCOST_HDR | | FLOAT(53) | No | The default overhead on the job. |
DEF_PURCH_GLCODE | JOB_COSTTYPES | | INTEGER | No | The General Ledger code for the Purchasing Account related to this type. |
DEF_PURCH_GLSUBCODE | JOB_COSTTYPES | | INTEGER | No | The General Ledger sub-account code for the Purchasing Account related to this type. |
DELADDR1 | JOBCOST_HDR | | VARCHAR(30) | No | Delivery address line 1. |
DELADDR2 | JOBCOST_HDR | | VARCHAR(30) | No | Delivery address line 2. |
DELADDR3 | JOBCOST_HDR | | VARCHAR(30) | No | Delivery address line 3. |
DELADDR4 | JOBCOST_HDR | | VARCHAR(30) | No | Delivery address line 4. |
DELADDR5 | JOBCOST_HDR | | VARCHAR(30) | No | Delivery address line 5. |
DELADDR6 | JOBCOST_HDR | | VARCHAR(30) | No | Delivery address line 6. |
DEL_ADDR | JOBCOST_HDR | | INTEGER | No | Delivery address. |
DESCRIPTION | JOB_STATUS_CONSTRAINT | | VARCHAR(50) | Yes | A description of the constraint. |
DESCRIPTION | JOBCOST_PROJ | | TEXT | No | Descriptive text for the project. |
DESCRIPTION | JOBCOST_LINES | FK | VARCHAR(60) | No | The description of the stock item on this line. |
DESCRIPTION | JOB_TIMESHEETS | | VARCHAR(60) | No | The description of the labour pay item for this line. |
DESCRIPTION | JOB_CONTRACT_BILLINGS | | VARCHAR(60) | Yes | A descriptive name for the billing record. |
DESCRIPTION | JOB_TIMESHEET_ALLOWANCE | FK | VARCHAR(50) | No | The description of the allowance type on this line. |
DESCRIPTION | JOB_TIMESHEET_ALLOWANCE_TYPES | | VARCHAR(50) | No | Descriptive text for the Allowance Type. |
DESCRIPTION | JOB_OUTPUT_ITEMS | FK | VARCHAR(60) | Yes | The description of the output stock item. |
DESCRIPTION | STOCK_ITEMS | | VARCHAR(40) | No | The stock item's description. |
DESCRIPTION | JOBCOST_HDR | | VARCHAR(5000) | No | The job's description. |
DESCRIPTION | JOB_TRANSACTIONS | FK | VARCHAR(60) | No | The description of the stock item on this line. |
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 |
DIM_DEPTH | JOB_TRANSACTIONS | | FLOAT(53) | Yes | Dimension depth |
DIM_DEPTH | JOBCOST_LINES | | FLOAT(53) | Yes | Dimension depth. |
DIM_LENGTH | JOB_TRANSACTIONS | | FLOAT(53) | Yes | Dimension length |
DIM_LENGTH | JOBCOST_LINES | | FLOAT(53) | Yes | Dimension length. |
DIM_WIDTH | JOB_TRANSACTIONS | | FLOAT(53) | Yes | Dimension width |
DIM_WIDTH | JOBCOST_LINES | | FLOAT(53) | Yes | Dimension width. |
DISCOUNT | JOB_TRANSACTIONS | | FLOAT(53) | No | The percentage discount on the line. |
DISCOUNT | JOBCOST_LINES | | FLOAT(53) | No | The percentage discount on the line. |
DISCOUNTLEVEL | STOCK_ITEMS | | INTEGER | No | |
DISCOUNTRATE | STAFF | | FLOAT(53) | Yes | The staff member's Discount Rate Limit. |
DISP_COLOUR | JOB_CATEGORIES | | VARCHAR(15) | No | Not used. |
DRCR | GLACCS | | CHAR(1) | No | This field is set to 'C' for Credit accounts or 'D' for Debit accounts. |
DUEDATE | JOBCOST_HDR | | DATETIME | No | The date when the job is due. |
DUE_DATE | JOB_CONTRACT_BILLINGS | | DATETIME | No | The date that this billing entry is due on. |
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_ADDRESS | JOBCOST_RESOURCE | | VARCHAR(40) | No | |
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. |
ENDDATE | JOB_TRANSACTIONS | | DATETIME | No | The end date on the line (applies to timesheets). |
ENDTIME | JOB_TRANSACTIONS | | VARCHAR(15) | No | End Time (only applies to timesheets). |
END_DATE | JOB_RESOURCE_ALLOCATION | | DATETIME | No | The allocation's end date. |
END_TIME | JOB_RESOURCE_ALLOCATION | | DATETIME | No | The allocation's end time. |
ENTRYDATE | JOBCOST_HDR | | DATETIME | No | The date and time when the job was entered. |
ESTIMATE | JOBCOST_HDR | | FLOAT(53) | No | An estimate of the job's value. |
ESTIMATECOST | JOBCOST_HDR | | FLOAT(53) | No | The estimated cost of the job. |
EST_HOURS | JOBCOST_HDR | | FLOAT(53) | No | Estimated hours on the job. |
EXCHRATE | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The exchange rate for the line at the time of the transaction. |
EXCHRATE | JOB_TRANSACTIONS | | FLOAT(53) | No | The exchange rate applicable to the line. |
EXCHRATE | JOBCOST_HDR | | FLOAT(53) | Yes | The exchange rate used by the job. |
EXCHRATE | JOBCOST_LINES | | FLOAT(53) | No | The exchange rate applicable to the line. |
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. |
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. |
FILTERSQL | JOBCOST_RESOURCE | | VARCHAR(100) | No | If the resource uses a SQL statement to filter stock item searches for times, it is recorded here. |
FLAG01 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 1 is ticked for the job. |
FLAG02 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 2 is ticked for the job. |
FLAG03 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 3 is ticked for the job. |
FLAG04 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 4 is ticked for the job. |
FLAG05 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 5 is ticked for the job. |
FLAG06 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 6 is ticked for the job. |
FLAG07 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 7 is ticked for the job. |
FLAG08 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 8 is ticked for the job. |
FLAG09 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 9 is ticked for the job. |
FLAG10 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 10 is ticked for the job. |
FLAG11 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 11 is ticked for the job. |
FLAG12 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 12 is ticked for the job. |
FLAG13 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 13 is ticked for the job. |
FLAG14 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 14 is ticked for the job. |
FLAG15 | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if custom flag 15 is ticked for the job. |
FLAGCODE | JOBCOST_FLAGSDESC | PK | VARCHAR(8) | Yes | The Job Flag's ID number. |
FLAGDESC | JOBCOST_FLAGSDESC | | VARCHAR(60) | No | The Job Flag's description. |
FROMLOC | JOBCOST_LINES | | INTEGER | No | |
FROMLOC | JOB_TRANSACTIONS | | INTEGER | No | The location origin for stock movements. |
FROM_STATUS | JOB_STATUS_CONSTRAINT | | CHAR(1) | No | The source stage for the constraint. |
FX_PRICE | JOB_TRANSACTIONS | | FLOAT(53) | No | |
GANTTBAR_COLOUR | JOB_TYPES | | INTEGER | No | A colour code that determines how jobs of this type should appear on the diagram on the Job Overview tab. |
GANTTBAR_COLOUR | JOB_STATUS | | INTEGER | No | A colour code that determines how jobs of this status should appear on the diagram on the Job Overview tab. |
GANTTBAR_COLOUR | JOB_CATEGORIES | | INTEGER | No | A colour code that determines how jobs of this category should appear on the diagram on the Job Overview tab. |
GLACC_TO_USE | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
GLCODE | JOB_COSTTYPES | | INTEGER | No | The General Ledger code for the Sales Account related to this type. |
GLCODE | JOB_TRANSACTIONS | FK | INTEGER | No | The GL account code of the P&L revenue account. |
GLCODE | JOB_CONTRACT_BILLINGS | FK | INTEGER | Yes | The ID number of the GL account for this line. |
GLCODE | JOBCOST_LINES | FK | INTEGER | No | The GL account code of the P&L revenue account. |
GLSUBCODE | JOB_COSTTYPES | | INTEGER | No | The General Ledger sub-account code for the Sales Account related to this type. |
GLSUBCODE | JOB_CONTRACT_BILLINGS | FK | INTEGER | Yes | The ID number of the GL sub-account for this line. |
HASUNBILLED | JOBCOST_HDR | | CHAR(1) | Yes | |
HAS_ALLOWANCE | JOB_TIMESHEETS | | CHAR(1) | No | This field contains 'Y' if allowances/deductions have been added to the line. |
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. |
HIDDEN_COST | JOBCOST_LINES | | FLOAT(53) | Yes | This field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level cost prices. For builds that use individual stock lines, this field stores the real cost. |
HIDDEN_COST | JOB_TRANSACTIONS | | FLOAT(53) | Yes | This field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level cost prices. For builds that use individual stock lines, this field stores the real cost. |
HIDDEN_LINETOTAL | JOBCOST_LINES | | FLOAT(53) | Yes | |
HIDDEN_LINETOTAL | JOB_TRANSACTIONS | | FLOAT(53) | Yes | For Kit type BOMs, this field stores the line total against the header line. |
HIDDEN_SELL | JOBCOST_LINES | | FLOAT(53) | Yes | This field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level sell prices. For builds that use individual stock lines, this field stores the sell price. |
HIDDEN_SELL | JOB_TRANSACTIONS | | FLOAT(53) | Yes | This field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level sell prices. For builds that use individual stock lines, this field stores the sell price. |
HOMEPHONE | STAFF | | VARCHAR(30) | No | The staff member's home telephone number. |
INVLINE_SEQNO | JOB_TRANSACTIONS | FK | INTEGER | Yes | The related Debtor Invoice line ID, if applicable (from DR_INVLINES). |
INVNO | JOB_CONTRACT_BILLINGS | | VARCHAR(20) | No | If the line has been invoiced, this field contains the invoice number for the invoice. |
INVOICED | JOB_CONTRACT_BILLINGS | | CHAR(1) | Yes | This field contains 'Y' if the line has been invoiced. |
INVOICED | JOBCOST_HDR | | FLOAT(53) | No | The amount of the job that has been invoiced. |
INVOICED | JOB_TRANSACTIONS | | FLOAT(53) | Yes | The amount invoiced. |
INVOICEDATE | JOB_TRANSACTIONS | | DATETIME | No | The invoice date |
INVOICEDCOST | JOBCOST_HDR | | FLOAT(53) | No | The total cost of all invoiced lines on the job. |
INVOICEDQTY | JOB_TRANSACTIONS | | FLOAT(53) | Yes | The quantity invoiced. |
INVOICEREADY | JOBCOST_HDR | | CHAR(1) | Yes | |
INVOICEREADY | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if the job's Invoice Ready flag is ticked. |
INVSEQNO | JOB_TRANSACTIONS | FK | INTEGER | Yes | The related Debtor Invoice ID, if applicable (from DR_TRANS). |
INV_SEQNO | JOB_CONTRACT_BILLINGS | | INTEGER | No | If the line has been invoiced, this field contains the ID number (SEQNO) of the invoice in the DR_TRANS table. |
ISACTIVE | JOB_STATUS | | CHAR(1) | Yes | If this field contains 'Y', the status causes the job to be marked as Active. |
ISACTIVE | JOB_STATUS_CONSTRAINT | | CHAR(1) | Yes | If this field contains 'Y', the constraint applies, so that users are permitted to change a job from the stage specified by the FROM_STATUS to the stage specified by the TO_STATUS. |
ISACTIVE | GLACCS | | CHAR(1) | No | This field contains 'Y' if the GL account 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 | JOBCOST_PROJ | | CHAR(1) | Yes | This field contains 'Y' if the project is currently active. |
ISACTIVE | JOBCOST_HDR | | CHAR(1) | Yes | This field contains 'Y' if the job is currently active. |
ISACTIVE | STOCK_ITEMS | | CHAR(1) | No | If this field is set to 'Y', the stock item is active. |
ISACTIVE | JOBCOST_RESOURCE | | CHAR(1) | Yes | This field contains 'Y' if the resource is currently active. |
ISACTIVE | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if the job's Active Job flag is ticked. |
ISARCHIVED | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if the job's Archived Job flag is ticked. |
ISARCHIVED | JOB_STATUS | | CHAR(1) | Yes | If this field contains 'Y', the status causes the job to be archived. |
ISCOMPLETE | JOBCOST_FLAGS | | CHAR(1) | Yes | This field contains 'Y' if the job's Completed flag is ticked. |
ISCOMPLETE | JOB_STATUS | | CHAR(1) | Yes | If this field contains 'Y', the status causes the job to be marked as Complete. |
ISINVOICEREADY | JOB_STATUS | | CHAR(1) | Yes | If this field contains 'Y', the status causes the job to be marked as Ready for Invoice. |
ISLOCKQUOTE | JOB_STATUS | | CHAR(1) | Yes | If this field contains 'Y', the status causes quotations on the job to be read-only. |
ISSUPPLIED | JOB_TRANSACTIONS | | CHAR(1) | Yes | This field contains 'Y' if the line is supplied; otherwise 'N'. |
IS_DISCOUNTABLE | STOCK_ITEMS | | CHAR(1) | Yes | This field is set to 'Y' if the stock item is discountable. |
IS_OVERTIME | JOB_TIMESHEETS | | CHAR(1) | No | This field contains 'Y' if the line is a Special Hours rate. |
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. |
JOBCAT | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
JOBCODE | JOBCOST_HDR | | VARCHAR(15) | No | An alphanumeric ID code for the job. |
JOBCOSTLINEID | JOBCOST_LINES | | INTEGER | No | ID of the job line. |
JOBLINEID | JOB_TRANSACTIONS | | INTEGER | Yes | ID of the job transaction line |
JOBNO | JOBCOST_FLAGS | FK | INTEGER | Yes | The job's ID number. |
JOBNO | JOBCOST_LINES | FK | INTEGER | Yes | The ID number of the job that this line is on. |
JOBNO | JOB_OUTPUT_ITEMS | FK | INTEGER | No | The ID number of the job that the item belongs to. |
JOBNO | JOB_CONTRACT_BILLINGS | FK | INTEGER | No | The ID number of the job that the billing record is attached to. |
JOBNO | JOB_HIST | FK | INTEGER | No | The ID number of the job that the History Note is attached to. |
JOBNO | JOBCOST_HDR | PK | INTEGER | Yes | A unique ID number for the job. |
JOBNO | JOB_TIMESHEETS | FK | INTEGER | No | The ID number of the job that the line relates to. |
JOBNO | JOB_QUOTE_OPTIONS | | INTEGER | No | The ID number of the job that this option applies to. |
JOBNO | JOB_RESOURCE_ALLOCATION | FK | INTEGER | Yes | The ID number of the job that the resource is allocated to. |
JOBNO | JOB_TRANSACTIONS | FK | INTEGER | No | The ID number of the job that this line is on. |
JOBNO_PROMPT | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
JOBSTAT | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
JOBTITLE | STAFF | | VARCHAR(30) | No | The staff member's job title. |
JOBTYPE | JOBCOST_HDR | FK | INTEGER | No | The ID number of the job's type (from JOB_TYPES). |
JOBTYPE | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
KITCODE | JOB_TRANSACTIONS | FK | VARCHAR(23) | No | The ID code of the Bill of Materials, if the stock line belongs to a one (from BILLOMAT_HDR). |
KITCODE | JOBCOST_LINES | FK | VARCHAR(23) | No | The ID code of the Bill of Materials, if the stock line belongs to a one (from BILLOMAT_HDR). |
KITSEQNO | JOBCOST_LINES | | INTEGER | Yes | The ID number of the Bill of Materials, if the stock line belongs to a one. |
KITSEQNO | JOB_TRANSACTIONS | | INTEGER | Yes | The ID number of the Bill of Materials, if the stock line belongs to a one. |
LABEL_QTY | STOCK_ITEMS | | INTEGER | Yes | |
LABOUR_ALLOWANCE | JOB_TIMESHEETS | | FLOAT(53) | No | |
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. |
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 | 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. |
LATESTCOST | STOCK_ITEMS | | FLOAT(53) | No | The stock item's Last Cost Price. |
LATESTCOST_IN | JOB_TRANSACTIONS | | FLOAT(53) | No | The Latest cost of the item coming into the WIP location. |
LATESTCOST_OUT | JOB_TRANSACTIONS | | FLOAT(53) | No | The Latest cost of the item going out of the WIP location. |
LINECHARGE | JOB_TRANSACTIONS | | AS | No | Calculated field giving the total price of the transaction line (excluding discount). |
LINECHARGE_WRITEOFF | JOB_TRANSACTIONS | | FLOAT(53) | No | This field stores the value of LINECHARGE before the line was written off. |
LINECHARGE_WRITEOFF | JOBCOST_HDR | | FLOAT(53) | No | This field stores the sum of value of all JOB_TRANSACTIONS.LINECHARGE_WRITEOFF values on the transaction lines. |
LINECOST | JOB_TRANSACTIONS | | AS | No | Calculated field giving the cost of the transactions line. |
LINESORT | JOB_TRANSACTIONS | | INTEGER | No | |
LINETOTAL | JOBCOST_LINES | | AS | No | Total value of the stock line. |
LINETOTAL | JOB_TRANSACTIONS | | AS | No | Total price of the transaction line including discount. |
LINETOTAL_INCTAX | JOBCOST_LINES | | AS | No | Total value of the line, inclusive of tax. |
LINETOTAL_INCTAX | JOB_TRANSACTIONS | | AS | No | Line total inclusive of discount and tax(Calculated field) |
LINETOTAL_TAX | JOB_TRANSACTIONS | | FLOAT(53) | Yes | The total tax value for line |
LINETOTAL_TAX | JOBCOST_LINES | | FLOAT(53) | Yes | The tax value on the line. |
LINETYPE | JOBCOST_LINES | | INTEGER | Yes | Will be one of: 0 = normal 1 = BOM header 2 = COM component 4 = comment line |
LINETYPE | JOB_TRANSACTIONS | | INTEGER | Yes | The type of line. Will be one of: 0 = Normal 1 = BOM header 2 = Component 4 = Comment line |
LINE_ID | JOB_TIMESHEETS | | INTEGER | No | |
LINE_SOURCE | JOBCOST_LINES | | VARCHAR(10) | No | |
LINE_SOURCE | JOB_TRANSACTIONS | | VARCHAR(10) | No | Where the line was sourced from. Will be one of: P = Purchase Q = Quote |
LINE_STATUS | JOB_TRANSACTIONS | | VARCHAR(30) | No | The line's status. Will be one of: R = Ready to invoice W = Writeoff I = Invoiced X = Cancelled A = Asset C = Committed Stock |
LINE_STATUS | JOBCOST_LINES | | VARCHAR(30) | No | The status on the job line. Will be one of: Q = quote line J = line has been committed and ready for invoice I = line has been invoiced P = line is a part of a Purchase Order |
LINE_TAX | JOB_TRANSACTIONS | | FLOAT(53) | Yes | The tax value on the line. |
LINE_TAX | JOBCOST_LINES | | FLOAT(53) | Yes | |
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 | JOB_TRANSACTIONS | | CHAR(1) | No | S= Stocked, L= Lookup, N= Not Applicable |
LINKEDSTATUS | JOBCOST_LINES | | CHAR(1) | No | S = Stocked, L = Lookup |
LINKED_BILLCODE | STOCK_ITEMS | | VARCHAR(23) | No | |
LINKED_QTY | JOBCOST_LINES | | FLOAT(53) | No | Quantity (if the item is a linked stock item). |
LINKED_QTY | JOB_TRANSACTIONS | | FLOAT(53) | No | Quantity (if the item is a linked stock item). |
LINKED_STOCKCODE | JOB_TRANSACTIONS | | VARCHAR(23) | No | Code of the linked stock item |
LINKED_STOCKCODE | JOBCOST_LINES | | VARCHAR(23) | No | Linked stockcode. |
LISTPRICE | JOBCOST_LINES | | FLOAT(53) | No | The list price of the stock item. |
LISTPRICE | JOB_TRANSACTIONS | | FLOAT(53) | No | The original sell price of the item. |
LOCATION | JOB_RESOURCE_ALLOCATION | | INTEGER | No | The Location code entered for the allocation. |
LOCATION | JOB_TRANSACTIONS | | INTEGER | No | The location that the item moves to. |
LOCATION | JOB_OUTPUT_ITEMS | FK | INTEGER | No | The location specified for the output item (from STOCK_LOCATIONS). |
LOCK_JOB | JOB_STATUS | | VARCHAR(1) | No | If this field contains 'Y', the status makes the job read-only. |
LOGINID | STAFF | | VARCHAR(30) | Yes | The staff member's login ID. This is the ID used to log in to the EXO Business system. |
LOOKUP_RECOVERABLE | STOCK_ITEMS | | CHAR(1) | No | If this field contains 'Y', the stock item is a recoverable expense in EXO Job Costing. |
LOOKUP_RECOVERABLE | JOB_TRANSACTIONS | | CHAR(1) | No | This field contains 'Y' if lookups are recoverable against expenses in Job Costing. |
MASTER_JOBNO | JOB_CONTRACT_BILLINGS | FK | INTEGER | Yes | If the job is a sub-job, this field contains the ID number of the master job. |
MASTER_JOBNO | JOBCOST_HDR | | INTEGER | Yes | If the job is a sub-job, this field stores the ID number of the master job. |
MASTER_JOBNO | JOB_TRANSACTIONS | FK | INTEGER | No | If the line belongs to a sub-job, this field contains the ID of the master job. |
MASTER_JOBNO | JOBCOST_LINES | FK | INTEGER | No | If the line belongs to a sub-job, this field contains the ID of the master job. |
MATERIALS | JOBCOST_HDR | | FLOAT(53) | No | Total amount on the Costs tab for the job. |
MATERIALSCOST | JOBCOST_HDR | | FLOAT(53) | No | The total costs on the Costs tab. |
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. |
MINSTOCK | STOCK_ITEMS | | FLOAT(53) | No | The minimum default stock level for each location. |
MONTHUNITS | STOCK_ITEMS | | FLOAT(53) | No | Sales totals in terms of quantity for the current month. |
MONTHVALUE | STOCK_ITEMS | | FLOAT(53) | No | Sales value for the current month. |
MOVE_STOCK | JOBCOST_GENERAL_INFO | | CHAR(1) | Yes | No longer used. |
NAME | GLACCS | | VARCHAR(40) | No | The account name. |
NAME | STAFF | | VARCHAR(30) | No | The staff member's full name. |
NARRATIVE | JOBCOST_LINES | | VARCHAR(1) | No | |
NARRATIVE | NARRATIVES | | VARCHAR(4096) | No | The text of the narrative. |
NARRATIVE | JOB_TRANSACTIONS | | VARCHAR(1) | No | |
NARRATIVE_SEQNO | JOBCOST_LINES | FK | INTEGER | No | The ID number of the narrative on the line, if there is one (from NARRATIVES). |
NARRATIVE_SEQNO | JOB_TRANSACTIONS | FK | INTEGER | No | The ID number of the narrative on the line, if there is one (from NARRATIVES). |
NARRATIVE_SEQNO | JOB_CONTRACT_BILLINGS | FK | INTEGER | No | The ID number of the narrative on the line, if there is one. |
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. |
NORMALHOURS | JOBCOST_RESOURCE | | FLOAT(53) | No | |
NOTE | JOB_HIST | | VARCHAR(4096) | No | The text of the History Note. |
NOTES | GLACCS | | VARCHAR(4096) | No | Any notes on the GL account. |
NOTES | STOCK_ITEMS | | VARCHAR(4096) | No | Any notes for the stock item. |
NUMDECIMALS | STOCK_ITEMS | | INTEGER | Yes | The number of decimal places that can be entered for the stock item's quantity. |
NUNITPR | JOB_TRANSACTIONS | | AS | No | The unit price after discount. |
NUNITPR | JOBCOST_LINES | | AS | No | |
OPENINGBAL | GLACCS | | FLOAT(53) | No | The account's opening balance. |
OPPLINEID | JOBCOST_LINES | | INTEGER | No | If the job was created from an Opportunity in EXO CRM, this field contains the ID of the Opportunity line that this line was created from. |
OPPORTUNITY_SEQNO | JOBCOST_HDR | FK | INTEGER | No | The ID number of the Opportunity (EXO CRM) that the job is associated with, if there is one. |
OPTION_1 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_10 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_2 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_3 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_4 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_5 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_6 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_7 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_8 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_9 | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
OPTION_NAME | JOB_QUOTE_OPTIONS | | VARCHAR(30) | No | The option's name. |
OPTION_NO | JOB_QUOTE_OPTIONS | | INTEGER | No | A job-specific ID number for the option. |
OPTION_NO | JOBCOST_LINES | FK | INTEGER | Yes | The ID number of the quote option assigned to the line. |
OPTION_SELECTED | JOB_QUOTE_OPTIONS | | CHAR(1) | Yes | This field contains 'Y' if the option is currently selected for the job. |
OURREF | JOBCOST_GENERAL_INFO | | VARCHAR(30) | No | No longer used. |
OUTLOOK_LINK | JOB_HIST | | VARCHAR(40) | No | If the History Note was emailed, this field contains a link to the email in MS Outlook. |
OVERHEAD | JOB_TRANSACTIONS | | FLOAT(53) | No | The overhead amount on the line, if applicable. |
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. |
PAYRATE | JOB_TRANSACTIONS | | FLOAT(53) | Yes | Pay Rate percentage (only applicable when timesheets are integrated with MYOB EXO Payroll). |
PAYRATE_NO | JOB_TRANSACTIONS | | INTEGER | Yes | Pay Rate ID (only applicable when timesheets are integrated with MYOB EXO Payroll). |
PAYRATE_OVERRIDEN | JOB_TRANSACTIONS | | FLOAT(53) | Yes | This field contains 'Y' if the payrate has been modified; otherwise 'N' (only applicable when timesheets are integrated with MYOB EXO Payroll). |
PAYROLLRATE | JOB_TIMESHEETS_RATES | | FLOAT(53) | No | The factor by which the pay rate of transactions exported via a timecard data file to your payroll base rate may be multiplied, e.g. where an employee is to be paid time-and-a-half or double time. |
PAYROLL_ALLOWANCE_ID | JOB_TIMESHEET_ALLOWANCE_TYPES | | VARCHAR(5) | No | An ID number for mapping Allowances and Deductions with those defined in your payroll via your timecard data file. |
PAYROLL_ALLOWANCE_ID | JOB_TIMESHEETS_RATES | | VARCHAR(5) | No | An ID number for mapping Allowances and Deductions with those defined in your payroll via your timecard data file. |
PAYROLL_HOURS | JOB_TRANSACTIONS | | FLOAT(53) | Yes | Payroll hours (only applicable when timesheets are integrated with MYOB EXO Payroll). |
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. |
PAYROLL_STATUS | JOB_TRANSACTIONS | | CHAR(1) | Yes | Only applicable when timesheets are integrated with MYOB EXO Payroll. Will be one of: Y = the line is ready to invoice N = the line is not ready to post P = the line has been invoiced |
PERCENTAGE_COMPLETE | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The Percentage Complete amount for the line. |
PHONE | STAFF | | VARCHAR(30) | No | The staff member's work telephone number. |
POSTTIME | JOB_HIST | | DATETIME | No | The actual date and time that the record was posted. |
PO_LINESEQNO | JOB_TRANSACTIONS | FK | INTEGER | Yes | The related Purchase Order line ID, if applicable (from PURCHORD_LINES). |
PQTY | STOCK_ITEMS | | FLOAT(53) | No | |
PREF_SERIALNO | JOBCOST_LINES | | VARCHAR(50) | No | |
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. |
PRICE_OVERRIDDEN | JOBCOST_LINES | | CHAR(1) | Yes | This field contains 'Y' if the unit price or discount has been overridden. |
PRICE_OVERRIDDEN | JOB_TRANSACTIONS | | CHAR(1) | Yes | This field contains 'Y' if the unit price or discount has been overridden. |
PRINTDESC | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
PRIVATE_ACC | GLACCS | | CHAR(1) | Yes | This field is set to 'Y' if the GL account is a private account. |
PRIVATE_NOTE | JOBCOST_HDR | | CHAR(1000) | No | Any notes on the job. |
PROFORMA_NO | JOB_CONTRACT_BILLINGS | | VARCHAR(20) | No | |
PROGRESSINVOICE | JOB_TRANSACTIONS | | CHAR(1) | Yes | This field contains 'Y' if the line is allocated to a Billing Schedule. |
PROJ_CODE | JOBCOST_PROJ | | VARCHAR(15) | Yes | An alphanumerical ID code for the project. |
PROJ_SEQNO | JOBCOST_HDR | FK | INTEGER | No | The ID number of the project that the job belongs to. |
PROJ_TITLE | JOBCOST_PROJ | | VARCHAR(60) | No | A descriptive title for the project. |
PURCHTAXRATE | STOCK_ITEMS | | INTEGER | No | Default GST rate for purchase transactions. |
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 | JOB_TRANSACTIONS | | FLOAT(53) | No | The quantity on the line. |
QUANTITY | JOB_OUTPUT_ITEMS | | FLOAT(53) | No | The quantity of the item that will be produced. |
QUOTECOST | JOBCOST_GENERAL_INFO | | INTEGER | Yes | No longer used. |
QUOTEDATE | JOBCOST_HDR | | DATETIME | No | The quote date on the job. |
QUOTE_QTY | JOBCOST_LINES | | FLOAT(53) | No | The quantity on the quote. |
QUOTE_TERMS | JOBCOST_GENERAL_INFO | | VARCHAR(1000) | No | No longer used. |
QUOTE_UNITPR | JOBCOST_LINES | | FLOAT(53) | No | The unit price on the line. |
RATECOLOR | JOB_TIMESHEETS_RATES | | INTEGER | No | A colour code that determines how timesheet lines of this rate should appear on the EXO Job Costing Timesheets window. |
RATENAME | JOB_TIMESHEETS_RATES | | VARCHAR(30) | No | The rate's name. |
RATE_FACTOR | JOB_TIMESHEETS | | FLOAT(53) | No | |
RATE_SEQNO | JOB_TRANSACTIONS | FK | INTEGER | Yes | Timesheet Rate ID from JOB_TIMESHEETS_RATES) |
RATE_SEQNO | JOB_TIMESHEETS | FK | INTEGER | No | The ID number of the Timesheet Rate in the line. |
REPORTCODE | GLACCS | | VARCHAR(15) | No | The report code used by the GL account. |
REPORTDESC | JOB_OTHER_REPORTS | | VARCHAR(40) | No | No longer used. |
REPORTNO | JOB_OTHER_REPORTS | PK | INTEGER | Yes | No longer used. |
REPORTS_TO_STAFFNO | STAFF | | INTEGER | No | The ID number of the staff member that this staff member reports to. |
REPORT_PARAMS | JOB_OTHER_REPORTS | | VARCHAR(200) | No | No longer used. |
RESOURCENAME | JOBCOST_RESOURCE | | VARCHAR(30) | Yes | The resource's name. |
RESOURCE_SEQNO | JOB_RESOURCE_ALLOCATION | FK | INTEGER | Yes | The ID number of the resource being allocated. |
RESTRICTED_ITEM | STOCK_ITEMS | | CHAR(1) | Yes | This field is set to 'Y' if the stock item is a restricted item. |
RETENTION | JOB_CONTRACT_BILLINGS | | FLOAT(53) | No | The base retention percentage for the line. |
RETENTION2 | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The Retention 2 rate for the line. |
RETENTION2_MIN | JOBCOST_HDR | | FLOAT(53) | Yes | The Minimum Value for the Level 2 Retention on the job. |
RETENTION2_RATE | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The Retention 2 percentage for the line. |
RETENTION2_RATE | JOBCOST_HDR | | FLOAT(53) | Yes | The Level 2 retention rate on the job. |
RETENTION3 | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The Retention 3 rate for the line. |
RETENTION3_MIN | JOBCOST_HDR | | FLOAT(53) | Yes | The Minimum Value for the Level 3 Retention on the job. |
RETENTION3_RATE | JOBCOST_HDR | | FLOAT(53) | Yes | The Level 3 retention rate on the job. |
RETENTION3_RATE | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The Retention 3 percentage for the line. |
RETENTION_AMOUNT | JOB_TRANSACTIONS | | FLOAT(53) | No | The retention amount on the line, if applicable. |
RETENTION_DUE_DATE | JOB_CONTRACT_BILLINGS | | DATETIME | No | The retention due date. |
RETENTION_INVNO | JOB_CONTRACT_BILLINGS | | VARCHAR(20) | No | |
RETENTION_INV_SEQNO | JOB_CONTRACT_BILLINGS | | INTEGER | Yes | |
RETENTION_RATE | JOB_CONTRACT_BILLINGS | | FLOAT(53) | No | The base retention rate for the line. |
RETENTION_RATE | JOB_TRANSACTIONS | | FLOAT(53) | No | The retention rate on the line, if applicable. |
RETENTION_RATE | JOBCOST_HDR | | FLOAT(53) | Yes | The base retention rate on the job. |
RETENTION_REALISED | JOB_CONTRACT_BILLINGS | | FLOAT(53) | Yes | The retention amount realised on the line. |
REVIEWDATE | JOBCOST_RESOURCE | | DATETIME | No | |
RTN_2_MIN | JOB_RETENTION_LEVELS | | FLOAT(53) | No | The Minimum Value for the Level 2 Retention. |
RTN_2_RATE | JOB_RETENTION_LEVELS | | FLOAT(53) | No | The % Rate for the Level 2 Retention. |
RTN_3_MIN | JOB_RETENTION_LEVELS | | FLOAT(53) | No | The Minimum Value for the Level 3 Retention. |
RTN_3_RATE | JOB_RETENTION_LEVELS | | FLOAT(53) | No | The % Rate for the Level 3 Retention. |
SALESGL | JOBCOST_HDR | FK | INTEGER | No | The P&L revenue account for journals when invoicing. |
SALESGLSQL | JOBCOST_GENERAL_INFO | | VARCHAR(500) | No | No longer used. |
SALESNO | JOB_HIST | | INTEGER | No | The ID number of the EXO Business staff member who added the History Note. |
SALESSUBGL | JOBCOST_HDR | | INTEGER | No | The P&L revenue sub-account for journals when invoicing. |
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. |
SCHEDULER | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
SCHEDULE_SEQNO | JOB_TRANSACTIONS | FK | INTEGER | Yes | The related Billing Schedule ID, if the line is allocated to a Billing Schedule (from JOB_CONTRACT_BILLINGS). |
SCHEDULE_SEQNO | JOBCOST_LINES | FK | INTEGER | Yes | ID number of the Billing Schedule that applies to the line. |
SECTION | GLACCS | | INTEGER | No | This field is set to 0 for Profit and loss accounts or 1 for Balance sheet accounts. |
SECTION | JOBCOST_LINES | | INTEGER | No | |
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 | JOB_TIMESHEETS_RATES | | FLOAT(53) | No | The factor by which the charge-out rate of transactions entered with this rate type will be multiplied when posting to a job. |
SELLRATE0 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
SELLRATE1 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
SELLRATE2 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
SELLRATE3 | JOBCOST_RESOURCE | | FLOAT(53) | No | |
SEQNO | JOB_CONTRACT_BILLINGS | PK | INTEGER | Yes | A unique ID number for the billing record. |
SEQNO | JOB_COSTGROUPS | PK | INTEGER | Yes | A unique ID number for the Cost Group. |
SEQNO | JOB_RESOURCE_ALLOCATION | PK | INTEGER | Yes | A unique ID number for the allocation. |
SEQNO | JOBCOST_GENERAL_INFO | PK | INTEGER | Yes | No longer used. |
SEQNO | JOB_STATUS_CONSTRAINT | PK | INTEGER | Yes | A unique ID number for the workflow constraint. |
SEQNO | JOB_TIMESHEET_ALLOWANCE | PK | INTEGER | Yes | A unique ID number for the line. |
SEQNO | JOB_RETENTION_LEVELS | PK | INTEGER | Yes | A unique ID number of the line. |
SEQNO | JOB_TIMESHEETS | PK | INTEGER | Yes | A unique ID number for the timesheet line. |
SEQNO | JOB_TIMESHEET_ALLOWANCE_TYPES | PK | INTEGER | Yes | A unique ID number for the Allowance Type. |
SEQNO | NARRATIVES | PK | INTEGER | Yes | A unique ID number for the narrative. |
SEQNO | JOB_OUTPUT_ITEMS | PK | INTEGER | Yes | A unique ID number for the item. |
SEQNO | JOBCOST_PROJ | PK | INTEGER | Yes | A unique ID number for the project. |
SEQNO | JOBCOST_LINES | PK | INTEGER | Yes | A unique ID number for the line. |
SEQNO | JOB_TRANSACTIONS | PK | INTEGER | Yes | A unique ID number for the line. |
SEQNO | JOB_HIST | PK | INTEGER | Yes | A unique ID number for the History Note. |
SEQNO | JOB_TIMESHEETS_RATES | PK | INTEGER | Yes | A unique ID number for the Timesheet Rate. |
SEQNO | JOBCOST_RESOURCE | PK | INTEGER | Yes | A unique ID number for the resource. |
SEQNO | JOB_QUOTE_OPTIONS | PK | INTEGER | Yes | A unique ID number for the Quote Option. |
SEQNO | JOB_COSTTYPES | PK | INTEGER | Yes | A unique ID number for the Cost Type. |
SERIALNO | JOBCOST_HDR | | VARCHAR(50) | No | Reference. |
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 |
SHORTCODE | JOB_TIMESHEETS_RATES | | VARCHAR(5) | No | A short ID code for the rate. |
SHORTCODE | JOB_COSTGROUPS | | VARCHAR(3) | No | A short (max. three characters) code for the group. |
SHORTCODE | JOB_TYPES | | VARCHAR(3) | No | A short (max. three characters) ID code for the type. |
SHORTCODE | JOB_COSTTYPES | | VARCHAR(3) | Yes | A short (max. three characters) code for the type |
SHORTCODE | JOB_CATEGORIES | | VARCHAR(3) | No | A short (max. three characters) ID code for the category. |
SHORTCODE | JOBCOST_RESOURCE | | VARCHAR(3) | No | A short (max. three characters) ID code for the resource. |
SHORTDESC | JOB_STATUS_CONSTRAINT | | VARCHAR(5) | Yes | A short code (5 characters max) for the constraint. |
SHOWLINE | JOB_TRANSACTIONS | | CHAR(1) | No | Flag to indicate if the BOM item line should be printed on Clarity reports or not. |
SHOWLINE | JOBCOST_LINES | | CHAR(1) | No | Used by reports to display/hide lines. |
SHOWMAIN | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
SHOWONQUOTE | JOB_COSTGROUPS | | CHAR(1) | No | This field contains 'T' if the group's "Show on quote" option is ticked; otherwise 'F'. |
SHOWONQUOTE | JOB_COSTTYPES | | CHAR(1) | No | This field contains 'T' if the type's "Show on quote" option is ticked; otherwise 'F'. |
SHOW_ON_INVOICE | JOBCOST_LINES | | CHAR(1) | No | |
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. |
SNEXPDAYS | JOBCOST_LINES | | INTEGER | No | Expiry days (applicable only if the item is serialised). |
SNEXPDAYS | JOB_TRANSACTIONS | | INTEGER | No | Serial Number expiry days. |
SNTYPE | JOBCOST_LINES | | INTEGER | No | Serial number type (applicable only if the item is serialised). |
SNTYPE | JOB_TRANSACTIONS | | INTEGER | No | Serial number type. |
SOFTWARE_VERSION | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
SOURCE_ID | JOB_TRANSACTIONS | | INTEGER | No | If the line originated from a job quote, this field contains the ID of the original quote line (from JOBCOST_LINES). |
SOURCE_REF | JOB_TIMESHEETS | | VARCHAR(20) | No | |
SOURCE_REF | JOB_TRANSACTIONS | | VARCHAR(20) | No | Source reference. |
SOURCE_SEQNO | JOB_TRANSACTIONS | FK | INTEGER | Yes | If the line originated from a job quote, this field contains the ID of the original quote line (from JOBCOST_LINES). |
SPREADVALUE | JOB_TRANSACTIONS | | CHAR(1) | Yes | If this field contains 'Y', the line will be taken into account when using the spread function to alter the total. |
SPREADVALUE | JOBCOST_LINES | | CHAR(1) | Yes | |
STAFFNO | JOB_TRANSACTIONS | FK | INTEGER | No | ID number of the staff member on the line. |
STAFFNO | JOBCOST_RESOURCE | FK | INTEGER | No | If the resource relates to an EXO Business staff member, their ID number is recorded here. |
STAFFNO | JOBCOST_HDR | FK | INTEGER | No | The EXO Business staff member responsible for entering the job. |
STAFFNO | STAFF | PK | INTEGER | Yes | A unique identifier for the staff record. |
STAFFNO | JOB_TIMESHEETS | FK | INTEGER | No | The ID number of the staff member on the timesheet line. |
STAFFNO | JOB_TIMESHEET_ALLOWANCE | FK | INTEGER | No | The ID number of the staff member that the line relates to. |
STARTDATE | JOBCOST_HDR | | DATETIME | No | The job's start date. |
STARTTIME | JOB_TRANSACTIONS | | VARCHAR(15) | No | Start time (only applies to timesheets). |
START_DATE | JOB_RESOURCE_ALLOCATION | | DATETIME | No | The allocation's start date. |
START_TIME | JOB_RESOURCE_ALLOCATION | | DATETIME | No | The allocation's start time. |
STATUS | STOCK_ITEMS | | CHAR(1) | No | The stock item's status. Will be one of: S = Stock item L = Lookup item |
STATUS | JOBCOST_HDR | FK | CHAR(1) | No | The ID code of the job's status (from JOB_STATUS). |
STATUSDESC | JOB_STATUS | | VARCHAR(30) | Yes | A descriptive name for the status. |
STATUSKEY | JOB_STATUS | PK | VARCHAR(1) | Yes | A unique one letter ID code for the Job Status. |
STDCOST | STOCK_ITEMS | | FLOAT(53) | No | The stock item's standard cost. |
STDCOST_IN | JOB_TRANSACTIONS | | FLOAT(53) | No | The Standard cost of the item coming into the WIP location. |
STDCOST_OUT | JOB_TRANSACTIONS | | FLOAT(53) | No | The Standard cost of the item going out of the WIP location. |
STOCKCODE | JOB_TIMESHEETS | FK | VARCHAR(23) | Yes | The stockcode of the labour pay item for this line. |
STOCKCODE | JOB_CONTRACT_BILLINGS | FK | VARCHAR(23) | No | The stockcode for the billing record. |
STOCKCODE | JOBCOST_LINES | FK | VARCHAR(23) | No | The stockcode of the stock item on this line. |
STOCKCODE | JOB_OUTPUT_ITEMS | FK | VARCHAR(23) | Yes | The stockcode of the output stock item. |
STOCKCODE | JOB_TRANSACTIONS | FK | VARCHAR(23) | No | The stockcode of the stock item on this line. |
STOCKCODE | STOCK_ITEMS | PK | VARCHAR(23) | Yes | A unique ID code for the stock item. |
STOCKCOST | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
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. |
STOCKLOC | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
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. |
STOCK_TRANS_SEQ_IN | JOB_TRANSACTIONS | | INTEGER | Yes | This field stores the STOCK_TRANS.SEQNO from the Purchase Order line that inserted the job transaction. |
SUBCODE | JOBCOST_LINES | | INTEGER | No | The subcode of the P&L revenue account. |
SUBCODE | JOB_TRANSACTIONS | | INTEGER | No | The subcode of the P&L revenue account. |
SUBJECT | JOB_HIST | | VARCHAR(80) | No | The History Note's subject line. |
SUBJECT_NOTES | JOB_RESOURCE_ALLOCATION | | VARCHAR(255) | No | Any notes entered into the allocation's Subject field. |
SUBSADDUP | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
SUBTOTAL | JOB_CONTRACT_BILLINGS | | FLOAT(53) | No | The subtotal on the billing record. |
SUPPLIERCOST | STOCK_ITEMS | | FLOAT(53) | Yes | The supplier cost price. |
SUPPLIERNO | JOBCOST_LINES | FK | INTEGER | No | ID of the supplier (Creditor) for the stock item on this line (from CR_ACCS). |
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. |
SU_SEQNO | JOB_TRANSACTIONS | | INTEGER | Yes | The ID number of the Serviceable Unit that the line is associated with, if applicable. |
TAXNO | JOB_TRANSACTIONS | FK | INTEGER | No | The ID number of the tax rate on the line (from TAX_RATES). |
TAXNO | JOBCOST_LINES | FK | INTEGER | No | The ID number of the tax rate on the line (from TAX_RATES). |
TAXRATE | JOB_TRANSACTIONS | | FLOAT(53) | Yes | The tax rate percentage on the line. |
TAXRATE | JOBCOST_LINES | | FLOAT(53) | Yes | The tax rate percentage on the line. |
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 | JOB_CONTRACT_BILLINGS | | FLOAT(53) | No | The total tax amount on the billing record. |
THETIME | JOBCOST_HDR | | FLOAT(53) | No | Total amount on timesheets for the job. |
THETIMECOST | JOBCOST_HDR | | FLOAT(53) | No | The total costs on the Timesheets tab. |
TIMESELECTSQL | JOBCOST_GENERAL_INFO | | VARCHAR(255) | No | No longer used. |
TITLE | JOBCOST_RESOURCE | | VARCHAR(30) | No | The resource's title. |
TITLE | JOBCOST_HDR | | VARCHAR(60) | No | A descriptive title for the job. |
TITLE | JOB_TIMESHEETS | FK | VARCHAR(60) | No | The title of the job that the line relates to. |
TOTALCOST | JOBCOST_HDR | | AS | No | The total cost of the job (Timesheets and Costs tabs). |
TOTALSTOCK | STOCK_ITEMS | | FLOAT(53) | Yes | Total units of stock for the item. |
TOTALVALUE | JOBCOST_HDR | | AS | No | The total value of the job (Timesheets and Costs tabs). |
TOTAL_HOURS | JOB_RESOURCE_ALLOCATION | | FLOAT(53) | No | The total number of hours that the resource was allocated for. |
TOTAL_HOURS | JOBCOST_HDR | | FLOAT(53) | No | The total hours on the job. |
TOTAL_QUANTITY | JOB_TRANSACTIONS | | AS | No | The total quantity after considering the dimensions (if applicable). |
TOTAL_QUANTITY | JOBCOST_LINES | | AS | No | The total quantity after considering the dimensions (if applicable). |
TO_STATUS | JOB_STATUS_CONSTRAINT | | CHAR(1) | No | The destination stage for the constraint. |
TRACKEVENT | JOB_STATUS_CONSTRAINT | | CHAR(1) | No | If this field contains 'Y', when a job is changed from the FROM_STATUS to the TO_STATUS, the stage change is recorded in the Event Log. |
TRANSDATE | JOB_TRANSACTIONS | | DATETIME | No | For timesheets, this field identifies the start date; otherwise it contains the transaction date on the line. |
TRANSDATE | JOBCOST_LINES | | DATETIME | No | The transaction date on the line. |
TRANSDATE | JOB_HIST | | DATETIME | No | The transaction date against the History Note. |
TRANSTYPE | JOB_TRANSACTIONS | | VARCHAR(1) | No | The transaction type. Will be one of: T = Time C = Cost |
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. |
TYPEDESC | JOB_TYPES | | VARCHAR(40) | No | Descriptive text for the type. |
TYPENO | JOB_TYPES | PK | INTEGER | Yes | A unique ID number for the Job Type. |
UNIT | JOB_TIMESHEET_ALLOWANCE | | FLOAT(53) | No | The unit of the allowance (unit type, e.g. hours, KM, is determined by the allowance type). |
UNITCOST | JOB_TRANSACTIONS | | FLOAT(53) | No | The unit cost of the item on the line. |
UNITPRICE | JOB_TRANSACTIONS | | FLOAT(53) | No | The unit price of the item on the line. |
UNITPRICE | JOB_TIMESHEETS | | FLOAT(53) | No | |
UNITPRICE_INCTAX | JOBCOST_LINES | | FLOAT(53) | No | The unit price inclusive of tax. |
UNITPRICE_INCTAX | JOB_TRANSACTIONS | | FLOAT(53) | No | The unit price inclusive of tax. |
UNIT_OF_MEASURE | JOB_TIMESHEET_ALLOWANCE_TYPES | | VARCHAR(50) | No | The unit of measure that the type uses. Will be HOURS, KILOMETERS or CURRENCY. |
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. |
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. |
USE_SALES_ORD_NO | JOBCOST_GENERAL_INFO | | CHAR(1) | Yes | No longer used. |
VARIABLECOST | STOCK_ITEMS | | CHAR(1) | Yes | The field is set to 'Y for Variable Cost stock items. |
WAGE_CODE | JOB_TRANSACTIONS | | INTEGER | Yes | Wage code (only applicable when timesheets are integrated with MYOB EXO Payroll). |
WEB_SHOW | STOCK_ITEMS | | CHAR(1) | No | |
WEEK_START_DATE | JOB_TIMESHEETS | | DATETIME | No | The start date of the week that times are being entered for. |
WEEK_START_DATE | JOB_TIMESHEET_ALLOWANCE | | DATETIME | No | The start date of the week that the line belongs to. |
WEIGHT | STOCK_ITEMS | | FLOAT(53) | No | Physical weight of the stock item. |
WIPLOC | JOBCOST_HDR | | INTEGER | No | The Work in Progress location for the job. |
WIPNOTSOH | JOBCOST_GENERAL_INFO | | VARCHAR(1) | No | No longer used. |
WIP_IN_PERIOD_SEQNO | JOB_TRANSACTIONS | | INTEGER | Yes | PERIOD_SEQNO for WIP_IN_DATE |
WIP_OUT_DATE | JOB_TRANSACTIONS | | DATETIME | No | The date and time when the stock moved out of WIP. |
WIP_OUT_PERIOD_SEQNO | JOB_TRANSACTIONS | | INTEGER | Yes | PERIOD_SEQNO for WIP_OUT_DATE |
WORKFLOW_CONSTRAINED | JOB_STATUS | | CHAR(1) | Yes | If this field contains 'Y', workflow constraints (defined in the JOB_STATUS_CONSTRAINT table) apply to the status. |
WORKSHEETTYPE | JOBCOST_GENERAL_INFO | | INTEGER | No | No longer used. |
WRITE_OFF_COST | JOBCOST_HDR | | FLOAT(53) | No | The total cost of all written off lines on the job. |
X_COLOURID | STOCK_ITEMS | | INTEGER | No | Style colour ID of the stock item. Used by the Style, Size Colour functionality. |
X_LABOUR_ALLOWANCE | JOBCOST_LINES | | FLOAT(53) | Yes | |
X_SIZEID | STOCK_ITEMS | | INTEGER | No | Style size ID of the stock item. Used by the Style, Size Colour functionality. |
YEARUNITS | STOCK_ITEMS | | FLOAT(53) | No | Year to date sales totals in terms of quantity. |
YEARVALUE | STOCK_ITEMS | | FLOAT(53) | No | Sales value for the current year. |