MYOB EXO Business Stock
List of attributes
Attribute details
Column nameTableKeyData typeNot NULLComment
ABSENTSTAFFCHAR(1)YesThis field is set to 'Y' if the staff member is currently absent, i.e. if their Absent flag is ticked in EXO Business Configurator.
ACCGROUPGLACCSINTEGERNoThe GL account's Account Group.
ACCNOCR_INVLINESFKINTEGERNoThe account number of the Creditor that the transaction belongs to.
ACCNOSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
ACCNOINWARDS_GOODS_COSTSFKINTEGERNoThe supplier (Creditor account ID).
ACCNOSTOCKREQUIREMENTINTEGERNoThe ID number of the stock item's supplier (from CRACCS).
ACCNODR_INVLINESFKINTEGERNoThe account number of the Debtor that the transaction belongs to.
ACCNOGLACCSPKINTEGERYesThe unique GL account number.
ACCNOSUPPLIER_STOCK_ITEMSPKINTEGERYesThe ID number of the supplier (Creditor) account.
ACCNOSTOCK_TRANSINTEGERNoFor manual stock movements this field is NULL. For movements originating from other ledgers, this contains the account number against the source transaction.
ACCOUNT_STATUSSTAFFINTEGERYesThe staff member's account status. Will be one of:
0 = Account OK
1 = Account Locked
2 = Password Expired
ACTUALREORDSTOCKREQUIREMENTFLOAT(53)NoActual reorder quantity for the stock item.
ACTUAL_COSTSTOCK_SERIALNOSFLOAT(53)YesThe actual cost of the item when moved into stock.
AGESTOCK_TRANSASNoCalculated field that indicates the age of the transaction.
AGESTOCK_TRANS_HDRASNoCalculated field that indicates the age the record belongs to.
AGESTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
AGEINWARDS_GOODS_COSTSASNoThe invoice's age. This is calculated based on PERIOD_SEQNO.
AGE_STAMPSTOCK_TRANSINTEGERNoThis is a historical field that has been superseded by the AGE calculated field.
AGE_STAMPSTOCK_TRANS_HDRINTEGERNoThis is a historical field that has been superseded by the AGE calculated field.
AGE_STAMPINWARDS_GOODS_COSTSINTEGERNoThis is a historical field that has been superseded by the AGE calculated field.
AGE_STAMPINWARDS_GOODS_LINESINTEGERNoThis is a historical field that has been superseded by the AGE calculated field.
ALERTSTOCK_ITEMSVARCHAR(60)NoText of the pop-up alert message that appears when the stock item is sold or purchased.
ALLOWJOURNALGLACCSCHAR(1)NoThis field is set to 'Y' if the GL account allows journals.
ALT_AVECOSTSTOCK_TRANSFLOAT(53)NoAlternate weighted average cost.
ALT_AVECOSTSTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
ALT_QUANTITYSTOCK_TRANSFLOAT(53)NoAlternate quantity.
ALT_QUANTITYSTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
ALT_SEQNOSTOCK_TRANSINTEGERNoAlternate SEQNO.
ALT_SEQNOSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
ANALYSISDR_INVLINESINTEGERNoGL 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".
ANALYSISCR_INVLINESINTEGERNoGL 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".
API_ACCESSSTAFFCHAR(1)NoThis field contains 'Y' if the staff member is authorised to use the EXO API.
APP_PASSWORDSTAFFVARCHAR(30)NoThe staff member's password, used when logging in to the EXO Business system. Passwords are stored in an encrypted format.
ASSIGNED_LINESEQNOSTOCK_SERIALNOSINTEGERYesThe line ID of the record that the serial number is linked to. The details of type of record can be determined from the ISASSIGNED field.
ASSIGNED_SEQNOSTOCK_SERIALNOSINTEGERYesThe header ID of the record that the serial number is linked to. The details of type of record can be determined from the ISASSIGNED field.
AUTH_AMTSTAFFFLOAT(53)NoThe staff member's Credit Invoice Authorisation Limit.
AUTOBUILDBILLOMAT_HDRCHAR(1)YesApplies to Build type BOMs. This field is set to 'Y' if the BOM's "AutoBuild" option is ticked. This gives the option of building an out-of-stock BOM immediately instead of placing it on backorder.
AUTOCODESTOCK_GROUPSVARCHAR(10)NoThe One-off Stock Item autocode prefix for the group.
AUTOCODESTOCK_GROUP2SVARCHAR(10)NoThe One-off Stock Item autocode prefix for the group.
AUTOCODENOSTOCK_GROUP2SINTEGERNoThe One-off Stock Item autocode suffix for the group.
AUTOCODENOSTOCK_GROUPSINTEGERNoThe One-off Stock Item autocode suffix for the group.
AUTO_NARRATIVESTOCK_ITEMSINTEGERNoThe setting of the stock item's Auto Narrative property. Will be one of:
0=No
1=Yes with Blank
2=Yes with Notes
AVECOSTSTOCK_ITEMSFLOAT(53)NoThe stock item's Average Cost Price.
BAD_LOGIN_COUNTSTAFFINTEGERYesThe number of times the staff member has attempted to log in but failed.
BALANCEGLACCSFLOAT(53)NoThe account's balance.
BALANCE_SHEET_TYPEGLACCSINTEGERYesFor 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
BALSHEETACCTOTGLACCSASNoThe balance sheet total for the account.
BARCODE1STOCKTAKE_TOTALSVARCHAR(30)NoBarcode/alternate code 1.
BARCODE1STOCK_ITEMSVARCHAR(30)NoBarcode/alternate code 1.
BARCODE2STOCK_ITEMSVARCHAR(30)NoBarcode/alternate code 2.
BARCODE3STOCK_ITEMSVARCHAR(30)NoBarcode/alternate code 3.
BATCHCODECR_INVLINESVARCHAR(20)NoThe batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes.
BATCHCODEINWARDS_GOODS_LINESVARCHAR(20)NoThe batch code on the line.
BATCHCODEDR_INVLINESVARCHAR(20)NoThe batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes.
BATCHCODESTOCK_REQUESTLINESVARCHAR(20)NoThe batch code on the line.
BATCHCODESTOCKTAKE_TOTALSVARCHAR(20)NoThe batchcode for the stock item.
BATCHCODESTOCK_TRANS_ARCHIVEVARCHAR(20)NoSee STOCK_TRANS.
BATCHCODESTOCK_TRANSVARCHAR(20)NoThe batch number.
BATCHNOINWARDS_GOODS_LINESINTEGERYesThe batch number on the record.
BATCHQUANTITYBILLOMAT_TEMPFLOAT(53)NoThe batch quantity on the record.
BATCH_QTYBILLOMAT_HDRFLOAT(53)NoThe BOM's Batch Quantity.
BILLCODEBILLOMAT_LINESFKVARCHAR(23)NoThe ID code of the BOM header (BILLOMAT_HDR.BILLCODE).
BILLCODEBILLOMAT_TEMPFKVARCHAR(23)NoThe BOM code.
BILLCODEBILLOMAT_HDRPKVARCHAR(23)YesThe BOM's unique ID code.
BINCODESTOCK_ITEMSVARCHAR(12)NoBincode for the stock item.
BINCODESTOCKTAKE_TOTALSVARCHAR(12)NoThe Bin Code for the stock item being counted.
BINCODESTOCK_LOC_INFOVARCHAR(12)NoThe stock item's bin or shelf code at the location.
BKORDQTYDR_INVLINESFLOAT(53)NoBack Order Qty from the Sales Order.
BOMBATCHSEQNOBILLOMAT_TEMPINTEGERNoThe BOM batch ID number.
BOMPRICINGCR_INVLINESCHAR(1)NoHow Bills of Materials are priced. Will be one of:
C = Pricing by Component
T = Pricing by total
BOMPRICINGSTOCK_REQUESTLINESCHAR(1)NoHow Bills of Materials are priced. Will be one of:
C = Pricing by Component
T = Pricing by total
BOMPRICINGINWARDS_GOODS_LINESCHAR(1)NoC = BOM priced by Component, T = BOM priced by total, N = Normal
BOMPRICINGDR_INVLINESCHAR(1)NoHow Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total
BOMTYPEBILLOMAT_HDRCHAR(1)YesThe type of BOM. Will be one of:
K = Kit
B = Build
O = Order Template
BOMTYPESTOCK_REQUESTLINESCHAR(1)NoThe type of Bill of Materials that the line relates to:
N = Normal stock item
B = Build
K = Kit
L = Lookup
BOMTYPECR_INVLINESCHAR(1)NoThe type of Bill of Materials that the line relates to:
N = Normal stock item
B = Build
K = Kit
L = Lookup
BOMTYPEDR_INVLINESCHAR(1)NoThe type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup
BOMTYPEINWARDS_GOODS_LINESCHAR(1)NoThe Bill of Materials type on the line. Will be one of:
N = Normal
K = Kit
B = Build
L = Linked
BRANCHNOSTOCK_GROUPSFKINTEGERNoThe ID number of the group's branch (from BRANCHES).
BRANCHNOSTOCK_GROUP2SFKINTEGERNoThe ID number of the group's branch (from BRANCHES).
BRANCHNOINWARDS_GOODS_LINESFKINTEGERYesThe ID number of the branch on the record.
BRANCHNOCR_INVLINESINTEGERNoThe branch number. Lines generally inherit the branch specified on the invoice header.
BRANCHNODR_INVLINESINTEGERNoThe branch number. Lines generally inherit the branch specified on the invoice header.
BRANCHNOSTOCK_ITEMSINTEGERNoBranch number for the stock item.
CALCREORDSTOCKREQUIREMENTFLOAT(53)NoReorder quantity, calculated taking into account minimum stock, maximum stock and available free stock.
CAN_SPREADINWARDS_GOODS_COSTSCHAR(1)Yes
CLASSNAMESTOCK_CLASSIFICATIONSVARCHAR(100)YesThe name of the classification.
CLASSNOSTOCK_CLASSIFICATIONSPKINTEGERYesA unique ID number for the classification.
CODETYPEDR_INVLINESCHAR(1)YesThe type of code on the line. Will be one of: G - GL code S - Stock code
CODETYPECR_INVLINESCHAR(1)NoThe type of code on the line. Will be one of:
G - GL code
S - Stock code
COGSMETHODSTOCK_ITEMSINTEGERYes
COLOURCODESTOCK_COLOURVARCHAR(5)YesA user-defined ID code for the colour.
COLOURIDSTOCK_COLOURPKINTEGERYesA unique ID number for the colour.
COLOURNAMESTOCK_COLOURVARCHAR(30)NoA descriptive name for the colour.
COMMENTSTOCK_REQUESTLINESVARCHAR(30)NoThe comment entered on the line, if any.
COMPLETEINWARDS_GOODSCHAR(1)YesThis field contains 'Y' if the receipt has been completed.
COMPLETEINWARDS_GOODS_COSTSCHAR(1)YesIndicates if the line has been marked as completed, which controls whether or not the line can be edited.
COMPLETEINWARDS_GOODS_LINESCHAR(1)NoThis field contains 'Y' if the inwards goods receipt has been completed (and therefore cannot be altered).
COMPNOSTOCK_SERIALNOSINTEGERYes
COMPONENTLOCATIONBILLOMAT_TEMPFKINTEGERNoThe location of the BOM component stock item.
CONTRACT_HDRDR_INVLINESINTEGERYes
COSTINWARDS_GOODS_COSTSFLOAT(53)YesThe cost in local currency.
COSTCODEINWARDS_GOODS_COSTSVARCHAR(15)NoThe on cost code for the record.
COSTED_PERIOD_SEQNOINWARDS_GOODSINTEGERNoThe period to which the receipt belongs.
COSTGROUPSTOCK_ITEMSINTEGERYes
COSTPRICEBILLOMAT_HDRFLOAT(53)NoCost price for the BOM.
COSTTYPESTOCK_ITEMSINTEGERYes
COST_GROUPINWARDS_GOODS_LINESFKINTEGERYesIf the order originates from a job, this field records the ID number of the job's cost group.
COST_GROUPCR_INVLINESINTEGERNoThis field only applies if EXO Job Costing is installed. It identifies the Cost Group that the transaction belongs to.
COST_LINENODR_INVLINESINTEGERYesThis field is the link used when allocating cost lines to DR_INVLINES.
COST_TYPEINWARDS_GOODS_LINESFKINTEGERYesIf the order originates from a job, this field records the ID number of the job's cost type.
COST_TYPECR_INVLINESINTEGERNoThis field only applies if EXO Job Costing is installed. It identifies the Cost Type that the transaction belongs to.
COS_GLSUBCODESTOCK_ITEMSINTEGERNoThe Cost of Sales sub-account updated in the General Ledger when the stock item is sold.
COS_GLSUBCODESTOCK_GROUPSINTEGERNoThe code of the GL subaccount for Cost of Sales.
COS_GL_CODESTOCK_GROUPSFKINTEGERNoThe code of the GL account for Cost of Sales.
COS_GL_CODESTOCK_ITEMSFKINTEGERNoThe Cost of Sales account updated in the General Ledger when this stock item is sold.
COUNTQTYSTOCKTAKE_TOTALSFLOAT(53)NoThe physical count taken for the item at this location.
CREATED_DATEGLACCSDATETIMENoThe date and time that the GL account was created.
CREDITQTYDR_INVLINESINTEGERYesContains the sum of quantities which have been a part of credit notes against the transaction.
CRINVLINEIDCR_INVLINESINTEGERNoA 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.
CRINVLINESEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Creditors Invoice line that the item is linked to.
CRINVSEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Creditors Invoice that the item has been receipted in against.
CR_ACCNOSTOCK_SERIALNOSINTEGERYesThe ID number of the related Creditor account.
CUBICSTOCK_ITEMSFLOAT(53)NoCubic weight of the item.
CURRENCYNODR_INVLINESFKINTEGERNoThe currency number for the line.
CURRENCYNOGLACCSFKINTEGERNoThe ID number of the currency that the GL account is in.
CURRENCYNOCR_INVLINESFKINTEGERNoThe ID number of the currency used on the line.
CUSTOMFIELDDR_INVLINESVARCHAR(30)No
CUSTOM_FILTERSTOCKTAKE_CTRLVARCHAR(100)NoThis field contains the custom SQL filter defined for the location, if there is one.
CUSTORDERNOSTOCK_REQUESTSVARCHAR(20)NoThe customer order number, if there is one.
DATAX_EXCHANGE_FLAGSTOCK_GROUP2SCHAR(1)Yes
DATAX_EXCHNOSTOCK_GROUP2SINTEGERYes
DATAX_SITE_NO2STOCK_GROUP2SINTEGERYes
DATAX_SOURCE_SITESTOCK_GROUP2SINTEGERYes
DEFAULTWARRANTYNOSTOCK_ITEMSINTEGERYesThe default Warranty No for the stock item.
DEFDAYSSTOCK_ITEMSINTEGERNo
DELADDR1STOCK_LOCATIONSVARCHAR(30)NoLine 1 of the location's address.
DELADDR2STOCK_LOCATIONSVARCHAR(30)NoLine 2 of the location's address.
DELADDR3STOCK_LOCATIONSVARCHAR(30)NoLine 3 of the location's address.
DELADDR4STOCK_LOCATIONSVARCHAR(30)NoLine 4 of the location's address.
DELADDR5STOCK_LOCATIONSVARCHAR(30)NoLine 5 of the location's address.
DELADDR6STOCK_LOCATIONSVARCHAR(30)NoLine 6 of the location's address.
DESCRIPTIONCR_INVLINESVARCHAR(40)NoDescription of the Stock item on this line.
DESCRIPTIONINWARDS_GOODS_LINESVARCHAR(40)NoThe description of the stock item on the line.
DESCRIPTIONDR_INVLINESVARCHAR(40)NoDescription of the Stock item on this line.
DESCRIPTIONSTOCKTAKE_TOTALSVARCHAR(40)NoThe description of the stock item being counted.
DESCRIPTIONBILLOMAT_HDRVARCHAR(40)NoA descriptive name for the BOM.
DESCRIPTIONSTOCKREQUIREMENTVARCHAR(40)NoThe stock item's description.
DESCRIPTIONSTOCK_ITEMSVARCHAR(40)NoThe stock item's description.
DESCRIPTIONSUPPLIER_STOCK_ITEMSVARCHAR(40)NoThe supplier's description for the stock item.
DESCRIPTIONSTOCK_REQUESTLINESFKVARCHAR(40)YesThe description of the stock item on the line.
DESCRIPTIONBILLOMAT_LINESVARCHAR(40)NoThe description of the stock item on this line.
DETAILSINWARDS_GOODS_COSTSVARCHAR(40)NoDetails of the on cost.
DIMENSIONSSTOCK_ITEMSINTEGERYesHow the dimensions of the stock item are specified. Will be one of:
0=None
1=Length
2=Square
3=Cubic
DISCOUNTSUPPLIER_STOCK_ITEMSFLOAT(53)NoThe percentage discount when purchasing the stock item from the supplier.
DISCOUNTCR_INVLINESFLOAT(53)NoThe percentage discount for the Stock item on this line.
DISCOUNTDR_INVLINESFLOAT(53)NoThe percentage discount for the Stock item on this line.
DISCOUNTINWARDS_GOODS_LINESFLOAT(53)NoThe discount percentage on the line.
DISCOUNTAMTCR_INVLINESFLOAT(53)NoThe discount amount on a stock line.
DISCOUNTLEVELSTOCK_ITEMSINTEGERNo
DISCOUNTPCTCR_INVLINESFLOAT(53)NoThe discount percentage on a stock line.
DISCOUNTRATESTAFFFLOAT(53)YesThe staff member's Discount Rate Limit.
DISPLAY_NAMESTOCK_REQUESTTYPESVARCHAR(40)YesThe name of the request type.
DRCRGLACCSCHAR(1)NoThis field is set to 'C' for Credit accounts or 'D' for Debit accounts.
DRINVLINEIDDR_INVLINESINTEGERNoA unique ID for the invoice line, which should be used to link to other tables. Every time an invoice is edited, the lines are essentially removed and reinserted again, which changes the SEQNO. However, the DRINVLINEID field retains its value. Hence, any relationships built on this field are still valid in such a scenario.
DRINVLINESEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Debtors Invoice line that the item is linked to.
DR_ACCNOSTOCK_SERIALNOSINTEGERYesThe ID number of the related Debtor account.
DUTYSTOCK_ITEMSFLOAT(53)YesThe duty percentage on the stock item.
DUTYCOSTINWARDS_GOODS_LINESFLOAT(53)NoThe duty cost on the line.
ECONORDERQTYSUPPLIER_STOCK_ITEMSFLOAT(53)NoThe Minimum Order Quantity for the stock item.
ECONORDERQTYSTOCK_ITEMSFLOAT(53)NoThe economic order quantity (EOQ) for the stock item.
EMAIL_ADDRESSSTAFFVARCHAR(50)NoThe staff member's email address.
EMPLOYEE_CODESTAFFINTEGERYesThis field is used by the payroll integration functionality.
EXCHRATEDR_INVLINESFLOAT(53)NoThe exchange rate for the line at the time of the transaction.
EXCHRATEINWARDS_GOODS_COSTSFLOAT(53)YesThe exchange rate.
EXCHRATECR_INVLINESFLOAT(53)NoThe exchange rate for the line at the time of the transaction.
EXCHRATEINWARDS_GOODS_LINESFLOAT(53)NoThe exchange rate on the line.
EXCLUDE_FROMFREE_STOCKSTOCK_LOCATIONSCHAR(1)NoThis field contains 'Y' if the location's "Exclude from Free Stock" option is ticked.
EXCLUDE_FROMSALESSTOCK_LOCATIONSCHAR(1)NoThis field contains 'Y' if the location's "Exclude from Sales" option is ticked.
EXCLUDE_FROMVALUATIONSTOCK_LOCATIONSCHAR(1)NoThis field contains 'Y' if the location's "Exclude from Valuation" option is ticked.
EXCLUDE_FROM_REVALGLACCSCHAR(1)NoIf this field is set to 'Y', the account is excluded from revaluation.
EXPECTEDPROFITSTOCK_GROUPSFLOAT(53)NoThe expected profit margin for the group.
EXPIRY_DATESTOCK_TRANS_ARCHIVEDATETIMENoSee STOCK_TRANS.
EXPIRY_DATEINWARDS_GOODS_LINESDATETIMENoThe expiry date of the stock item, if there is one.
EXPIRY_DATESTOCKTAKE_TOTALSDATETIMENoThe date when the stock item batch expires.
EXPIRY_DATESTOCK_TRANSDATETIMENoThe Expiry Date for a batch tracked item.
EXPIRY_DATESTOCK_SERIALNOSDATETIMEYesThe expiry date on the record.
EXPIRY_DAYSSTOCKTAKE_TOTALSFKINTEGERNoThe number of days until the stock item batch expires.
EXPIRY_DAYSSTOCK_ITEMSINTEGERNoNumber of days before expiry of the stock item.
EXTENSIONSTAFFVARCHAR(12)NoThe staff member's telephone extension.
FACEBOOK_ACCESS_TOKENSTAFFVARCHAR(max)NoIf the staff member uses their own Facebook account when using the EXO Business social media functions, their encrypted access token is stored here.
FC_COSTINWARDS_GOODS_COSTSFLOAT(53)YesThe cost in the currency of the supplier account.
FILENAMESTOCK_GROUPSVARCHAR(50)NoThis field contains the filename of the website picture for the group.
FILENAMESTOCK_GROUP2SVARCHAR(50)NoThis field contains the filename of the website picture for the group.
FIXEDCOSTINWARDS_GOODS_LINESFLOAT(53)NoThe fixed cost on the line.
FREIGHT_FREEDR_INVLINESCHAR(1)Yes'Y' or 'N' depending on whether the line is freight free. This comes from the price policy for the line.
FROM_HDRSTOCK_TRANSINTEGERNoFor manual stock movements this field contains STOCK_TRANS_HDR.SEQNO. For other types of movements, it contains the SEQNO of the header table of source transactions.
FROM_HDRSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
FROM_LEDGERSTOCK_TRANS_ARCHIVECHAR(1)NoSee STOCK_TRANS.
FROM_LEDGERSTOCK_TRANSCHAR(1)Nod = Debtor
c = Creditor
s = Stock
j = Job Costing
i = Inwards Goods Receipt
o = Sales Orders
p = Purchase Orders
FROM_LOCSTOCK_REQUESTSINTEGERNoThe ID number of the location that stock is to be transferred from.
FXCOSTINWARDS_GOODS_LINESFLOAT(53)YesThe cost on the line in local currency.
FX_VARINWARDS_GOODS_LINESFLOAT(53)NoThe foreign exchange variance applicable to the line at the time of invoicing.
FX_VARINWARDS_GOODS_COSTSFLOAT(53)NoThe foreign exchange variance applicable to the invoice raised against this record.
GLACCSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
GLACCSTOCK_TRANSFKINTEGERNoThe General Ledger Account that is affected when the transaction is posted to GL.
GLACCNOCR_INVLINESINTEGERNoGL account number.
GLBATCHINWARDS_GOODS_COSTSINTEGERNoGL batch number.
GLBATCHNOINWARDS_GOODSINTEGERYesThe GL batch number on the transaction.
GLBATCHNOSTOCK_TRANSINTEGERNoID number of the GL Batch that the posted stock journal belongs to.
GLBATCHNOSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
GLBRANCHSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
GLBRANCHSTOCK_TRANSINTEGERNoThe Branch used for posting to the General Ledger.
GLPOSTEDINWARDS_GOODS_COSTSCHAR(1)YesThis field contains 'Y' if a GL journal exists for the record.
GLPOSTEDSTOCK_TRANSCHAR(1)NoThis field contains 'Y' if the transaction has been posted to the General Ledger.
GLPOSTEDSTOCK_TRANS_ARCHIVECHAR(1)NoSee STOCK_TRANS.
GLSUBACCSTOCK_TRANSINTEGERNoThe General Ledger Sub Account that is affected when the transaction is posted to GL.
GLSUBACCSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
GLSUBACCCR_INVLINESINTEGERNoSL sub-account number.
GROUP2_SEQNOSTOCK_GROUPSFKINTEGERNoThe ID number of the related Alternate Stock Group.
GROUPNAMESTOCK_GROUP2SVARCHAR(30)NoThe group's name/description.
GROUPNAMESTOCK_PRICEGROUPSVARCHAR(30)NoThe Price Group's name.
GROUPNAMESTOCK_GROUPSVARCHAR(30)NoThe group's name/description.
GROUPNOSTOCK_PRICEGROUPSPKINTEGERYesA unique ID number for the Price Group.
GROUPNOSTOCK_GROUPSPKINTEGERYesA unique ID code for the group.
GROUPNOSTOCK_GROUP2SPKINTEGERYesA unique ID number for the group.
HAS_BNSTOCK_ITEMSCHAR(1)NoThis field is set to 'Y' if the stock item is batch tracked.
HAS_BNSTOCKTAKE_TOTALSFKCHAR(1)YesThis field is set to 'Y' if the stock item is batch tracked.
HAS_BUDGETSSTAFFCHAR(1)NoThis 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_EXPIRYSTOCKTAKE_TOTALSFKCHAR(1)YesThis field is set to 'Y' if the stock item has an expiry date.
HAS_EXPIRYSTOCK_ITEMSCHAR(1)YesThis 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_SNSTOCK_ITEMSCHAR(1)NoThis field is set to 'Y' if the stock item is serial number tracked.
HDR_SEQNOCR_INVLINESFKINTEGERNoThe SEQNO of the record in the CR_TRANS table that this record related to.
HDR_SEQNOSTOCK_REQUESTLINESFKINTEGERYesThe ID number of the stock transfer request that the line belongs to (from STOCK_REQUESTS).
HDR_SEQNODR_INVLINESFKINTEGERNoThe SEQNO of the record in the DR_TRANS table that this record related to.
HDR_SEQNOINWARDS_GOODS_LINESFKINTEGERYesThe ID number of the header Inwards Goods record.
HIDDENDR_INVLINESCHAR(1)No
HIDDEN_COSTDR_INVLINESFLOAT(53)NoThis field applies to Bills of Materials. For kits that use pricing by components, this field stores the header-level cost. For builds that use individual stocklines, this fields stores the lines' real costs.
HIDDEN_SELLDR_INVLINESFLOAT(53)NoThis field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level sell prices For builds that use individual stocklines, this fields stores the lines' real prices.
HIDE_LINESBILLOMAT_HDRCHAR(1)NoThis field is set to 'Y' if the BOM's "Hide lines on reports" option is ticked.
HOMEPHONESTAFFVARCHAR(30)NoThe staff member's home telephone number.
IGRLINESEQNOCR_INVLINESINTEGERNoID number of the Inwards Goods receipt line (if the source of the line is from Inwards Goods).
IGRLINESEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Inwards Goods line that the item is linked to.
IGRSEQNOSTOCK_SERIALNOSINTEGERNo
INC_FIFO_STOCKTAKESTOCK_TRANS_ARCHIVECHAR(1)NoSee STOCK_TRANS.
INC_FIFO_STOCKTAKESTOCK_TRANSCHAR(1)NoNot supported.
INSTOCKSTOCK_SERIALNOSCHAR(1)YesThis field contains 'Y' if the serial number is in stock.
INSTOCKQTYSTOCKREQUIREMENTFLOAT(53)NoPhysical stock.
INTERCO_BATCH_DESCCR_INVLINESVARCHAR(80)NoThis field only applies if EXO InterCompany is used. It contains the batch description.
INTERCO_COMPANYNOCR_INVLINESINTEGERNoThis field only applies if EXO InterCompany is used. It contains the Company ID number.
INTERCO_CR_ACCNOCR_INVLINESINTEGERNoThis field only applies if EXO InterCompany is used. It contains the Creditor GL account number.
INTERCO_CR_BRANCHNOCR_INVLINESINTEGERNoThis field only applies if EXO InterCompany is used. It contains the Creditor branch number.
INTERCO_CR_SUBACCNOCR_INVLINESINTEGERNoThis field only applies if EXO InterCompany is used. It contains the Creditor GL sub-account number.
INTERCO_DR_ACCNOCR_INVLINESINTEGERNoThis field only applies if EXO InterCompany is used. It contains the Debtor GL account number.
INTERCO_DR_BRANCHNOCR_INVLINESINTEGERNoThis field only applies if EXO InterCompany is used. It contains the Debtor branch number.
INTERCO_DR_SUBACCNOCR_INVLINESINTEGERNoThis field only applies if EXO InterCompany is used. It contains the Debtor GL sub-account number.
INTRANS_QUANTSTOCK_REQUESTLINESASNoThe In Transit Qty on the line.
INVNODR_INVLINESVARCHAR(20)NoThe invoice number.
INVNOCR_INVLINESVARCHAR(20)NoThe invoice number.
INVOICEDINWARDS_GOODSCHAR(1)YesThis field contains 'Y' if the receipt has been invoiced.
INVOICE_NOWINWARDS_GOODS_COSTSFLOAT(53)No
INVSEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Debtors Invoice ID the item has been sold against.
INV_AGEINWARDS_GOODS_LINESASNoThe invoice's age. This is calculated based on PERIOD_SEQNO.
INV_COMPLETEINWARDS_GOODS_LINESCHAR(1)NoThis field contains 'Y' if the invoice is complete.
INV_COSTINWARDS_GOODS_COSTSFLOAT(53)NoThe invoiced amount in local currency.
INV_COSTINWARDS_GOODS_LINESFLOAT(53)NoThe cost as on the related invoice, in local currency.
INV_EXCHRATEINWARDS_GOODS_LINESFLOAT(53)NoThe exchange rate applicable to the invoice line.
INV_EXCHRATEINWARDS_GOODS_COSTSFLOAT(53)NoThe exchange rate applicable to the invoice.
INV_FC_COSTINWARDS_GOODS_LINESFLOAT(53)NoThe cost as on the related invoice.
INV_FC_COSTINWARDS_GOODS_COSTSFLOAT(53)NoThe invoiced amount in the currency of the supplier account.
INV_QUANTINWARDS_GOODS_LINESFLOAT(53)YesThe invoiced quantity on the line.
INV_TRANSDATEINWARDS_GOODS_LINESDATETIMENoThe transaction date of the invoice related to this line.
INWARDS_GOODS_SEQNOINWARDS_GOODS_COSTSFKINTEGERYesThe ID number of the Inwards Goods header record.
INWGLIDINWARDS_GOODS_LINESINTEGERNoAn ID number for the inwards goods lines record.
ISACTIVESTOCK_COLOURCHAR(1)NoThis field contains 'Y' if the colour is currently active.
ISACTIVESTOCK_GROUPSCHAR(1)NoThis field contains 'Y' if the group is currently active.
ISACTIVESTOCKTAKE_CTRLCHAR(1)NoThis field contains 'Y' is the location is currently active.
ISACTIVESTOCK_ITEMSCHAR(1)NoIf this field is set to 'Y', the stock item is active.
ISACTIVESTOCK_SIZECHAR(1)NoThis field contains 'Y' if the size is currently active.
ISACTIVEGLACCSCHAR(1)NoThis field contains 'Y' if the GL account is active.
ISACTIVESTOCK_LOCATIONSCHAR(1)NoThis field contains 'Y' if the location is active.
ISACTIVEBILLOMAT_HDRCHAR(1)NoThis field contains 'Y' if the BOM is active; otherwise it is inactive.
ISACTIVESTAFFCHAR(1)NoThis field is set to 'Y' if the staff member is currently active, i.e. if their Active flag is ticked in EXO Business Configurator.
ISASSIGNEDSTOCK_SERIALNOSCHAR(1)YesN = Not assigned
o = assigned to a Sales Order
i = assigned to inwards goods
j = assigned to Job Costing
q = assigned to a stock request
p = assigned to a POS parked Sales Order
P = assigned to a POS parked invoice
IS_DEFAULTSUPPLIER_STOCK_ITEMSCHAR(1)Yes
IS_DISCOUNTABLESTOCK_ITEMSCHAR(1)YesThis field is set to 'Y' if the stock item is discountable.
IS_SUPERVISORSTAFFCHAR(1)YesThis 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.
IS_WIPLOCATIONSTOCK_LOCATIONSCHAR(1)YesThis field contains 'Y' if the location represents Work in Progress in EXO Job Costing.
JOBCODECR_INVLINESVARCHAR(15)NoIf the line originates from a job, the job's code is recorded in this field.
JOBCODEDR_INVLINESVARCHAR(15)NoIf the line originates from a job, the job's code is recorded in this field.
JOBLINESEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the job line that the item is linked to.
JOBNOSTOCK_SERIALNOSINTEGERYesThe ID number of the job that the serial number belongs to (if there is one).
JOBNOCR_INVLINESINTEGERNoIf the line originates from a job, the job's ID number is recorded in this field.
JOBNOSTOCK_TRANSINTEGERNoJob Number if the stock movement sources from a job.
JOBNODR_INVLINESINTEGERNoIf the line originates from a job, the job's ID number is recorded in this field.
JOBNOSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
JOBNOINWARDS_GOODS_LINESFKINTEGERYesIf the order originates from a job, this field records the ID number of the job.
JOBTITLESTAFFVARCHAR(30)NoThe staff member's job title.
JOB_CONTRACT_BILLINGS_SEQNODR_INVLINESINTEGERYesIf the invoice is related to a Progress Billing invoice in EXO Job Costing, the ID number of that invoice is recorded here (from JOB_CONTRACT_BILLINGS).
KITCODEINWARDS_GOODS_LINESVARCHAR(23)NoThe ID code of the Bill of Materials on the line.
KITCODESTOCK_TRANSVARCHAR(23)NoCode of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM.
KITCODESTOCK_SERIALNOSVARCHAR(50)No
KITCODEDR_INVLINESVARCHAR(23)NoThe Bill of Materials code, if the line is part of a BOM.
KITCODECR_INVLINESVARCHAR(23)NoThe Bill of Materials code, if the line is part of a BOM.
KITCODESTOCK_TRANS_ARCHIVEVARCHAR(23)NoSee STOCK_TRANS.
KITID_SERIALSTOCK_SERIALNOSVARCHAR(50)No
KITSEQNOBILLOMAT_TEMPINTEGERNoThe ID number of the BOM.
KITSEQNOSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
KITSEQNOCR_INVLINESINTEGERNoA Bill of Materials SEQNO used to group BOM lines together.
KITSEQNOINWARDS_GOODS_LINESINTEGERNoThe ID number of the Bill of Materials on the line.
KITSEQNOSTOCK_TRANSINTEGERYesID number of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM.
KITSEQNODR_INVLINESINTEGERNoA Bill of Materials SEQNO used to group BOM lines together.
KIT_TYPEBILLOMAT_HDRINTEGERYes
LABEL_QTYSTOCK_ITEMSINTEGERYes
LASTINVSEQNOINWARDS_GOODSINTEGERNoThe ID number of the last invoice generated against the receipt.
LASTMONTHUNITSSTOCK_ITEMSFLOAT(53)NoUnits of stock item sold in the previous month.
LASTMONTHVALUESTOCK_ITEMSFLOAT(53)NoSales value for the previous month for the stock item.
LASTUPDATEDSTOCK_SERIALNOSDATETIMEYesThe date and time when the record was last updated.
LASTYEARUNITSSTOCK_ITEMSFLOAT(53)NoUnits of stock item sold in for the previous year.
LASTYEARVALUESTOCK_ITEMSFLOAT(53)NoSales value for last year.
LAST_BAD_LOGINSTAFFDATETIMENoThe date and time when the staff member last attempted to log in but failed.
LAST_LOGINSTAFFDATETIMENoThe date and time when the staff member last successfully logged in.
LAST_UPDATESUPPLIER_STOCK_ITEMSDATETIMENoThe date when the record was last updated (not set automatically - it must be specified on the Alternate Suppliers / Stock Codes window).
LAST_UPDATEDGLACCSDATETIMENoThe date and time when the GL account was last updated.
LAST_UPDATEDSTOCK_ITEMSDATETIMENoDate and time when the stock item record was last updated.
LATESTCOSTSUPPLIER_STOCK_ITEMSFLOAT(53)NoThe supplier's latest cost for the stock item.
LATESTCOSTSTOCK_ITEMSFLOAT(53)NoThe stock item's Last Cost Price.
LCODESTOCK_LOCATIONSVARCHAR(8)NoA short alphanumeric ID code for the location.
LCOSTINWARDS_GOODS_LINESFLOAT(53)YesThe landed cost on the line.
LINETAX_OVERRIDDENDR_INVLINESCHAR(1)NoContains 'Y' if the tax on the line has been manually modified.
LINETAX_OVERRIDDENCR_INVLINESCHAR(1)NoContains 'Y' if the tax on the line has been manually modified.
LINETOTALDR_INVLINESASNoA computed field containing the total value for the line, excluding tax.
LINETOTALCR_INVLINESASNoA computed field containing the total value for the line, excluding tax.
LINETOTAL_INCTAXCR_INVLINESASNoA computed field containing the total value for the line, including tax.
LINETOTAL_INCTAXDR_INVLINESASNoA computed field containing the total value for the line, including tax.
LINETOTAL_TAXDR_INVLINESFLOAT(53)NoThe tax total for the line.
LINETOTAL_TAXCR_INVLINESFLOAT(53)NoThe tax total for the line.
LINETYPEINWARDS_GOODS_LINESINTEGERNoThe line type. Will be one of:
0 = Normal line
1 = BOM header
2 = BOM component
4 = Comment
LINETYPECR_INVLINESINTEGERNoThis 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
LINETYPEDR_INVLINESINTEGERYesThis field indicates the type of line. Will be one of:
0 = Normal stockline
1 = BOM header line
2 = BOM component line
4 = Narrative line
LINETYPESTOCK_REQUESTLINESINTEGERNoThis field indicates the type of line. Will be one of:
0 = Normal stockline
1 = BOM header line
2 = BOM component line
4 = Narrative line
5 = GL code
LINE_SEQNOSTOCK_TRANSINTEGERNoFor manual stock movements this field is NULL. For movements originating from other ledgers, this contains the Line ID of the source line.
LINE_SEQNOSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
LINE_SOURCEDR_INVLINESINTEGERNoThe source SEQNO of the line, if it originated from a Sales Order or job.
LINE_SOURCECR_INVLINESINTEGERNoThe source SEQNO of the line, if it originated from a Sales Order or job.
LINKEDIN_TOKEN_KEYSTAFFVARCHAR(max)NoIf 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_SECRETSTAFFVARCHAR(max)NoIf the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token secret is stored here.
LINKEDSTATUSINWARDS_GOODS_LINESCHAR(1)NoS = Stock item, L = Lookup item.
LINKEDSTATUSSTOCK_REQUESTLINESCHAR(1)NoWill be one of:
S = Stocked
L = Lookup
N = Not applicable
LINKEDSTATUSDR_INVLINESCHAR(1)NoWill be one of: S = Stocked L = Lookup N = Not applicable
LINKEDSTATUSCR_INVLINESCHAR(1)NoWill be one of:
S = Stocked
L = Lookup
N = Not applicable
LINKED_BILLCODESTOCK_ITEMSVARCHAR(23)No
LINKED_QTYCR_INVLINESFLOAT(53)NoThe physical stock unit quantity.
LINKED_QTYSTOCK_REQUESTLINESFLOAT(53)NoThe physical stock unit quantity.
LINKED_QTYINWARDS_GOODS_LINESFLOAT(53)NoThe linked quantity on the line.
LINKED_QTYDR_INVLINESFLOAT(53)NoThe physical stock unit quantity.
LINKED_STOCKCODESTOCK_REQUESTLINESVARCHAR(23)NoThe physical stock unit.
LINKED_STOCKCODEINWARDS_GOODS_LINESVARCHAR(23)NoThe linked stock item code on the line.
LINKED_STOCKCODEDR_INVLINESVARCHAR(23)NoThe physical stock unit.
LINKED_STOCKCODECR_INVLINESVARCHAR(23)NoThe physical stock unit.
LISTPRICEDR_INVLINESFLOAT(53)NoThe original unit price for the Stock item on this line.
LNAMESTOCK_LOCATIONSVARCHAR(30)NoA descriptive name for the location.
LOCATIONCR_INVLINESINTEGERNoThe location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header.
LOCATIONSTOCKTAKE_TOTALSFKINTEGERNoThe ID number of the location where the stock was counted.
LOCATIONSTOCK_TRANSFKINTEGERNoID number of the Location involved in the stock movement.
LOCATIONSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
LOCATIONDR_INVLINESINTEGERNoThe location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header.
LOCATIONSTOCK_LOC_INFOFKINTEGERYesThe ID number of the location.
LOCNAMESTOCKTAKE_CTRLVARCHAR(30)NoThe name of the stock location.
LOCNOSTOCKTAKE_CTRLPK, FKINTEGERYesThe ID number of the stock location.
LOCNOSTOCK_LOCATIONSPKINTEGERYesA unique ID number for the location.
LOCNOINWARDS_GOODS_LINESFKINTEGERYesThe ID of the location on the record.
LOCNOINWARDS_GOODSFKINTEGERYesThe ID number of the location on the transaction.
LOCNOSTOCK_SERIALNOSFKINTEGERYesThe location of the serialised stock item.
LOCNOSTOCKREQUIREMENTFKINTEGERNoThe ID number of the stock item's location (from STOCK_LOCATIONS).
LOGINIDSTAFFVARCHAR(30)YesThe staff member's login ID. This is the ID used to log in to the EXO Business system.
LOOKUP_RECOVERABLESTOCK_ITEMSCHAR(1)NoIf this field contains 'Y', the stock item is a recoverable expense in EXO Job Costing.
LOOKUP_RECOVERABLESTOCK_TRANSCHAR(1)NoThis field contains 'Y' if lookup items are recoverable against expenses in EXO Job Costing.
LOST_QUANTSTOCK_REQUESTLINESFLOAT(53)No
MAXSTOCKSTOCK_LOC_INFOFLOAT(53)NoThe maximum stock quantity for the stock code at the location.
MAXSTOCKSTOCKREQUIREMENTFLOAT(53)NoThe maximum stock level for the stock item.
MAXSTOCKSTOCK_ITEMSFLOAT(53)NoThe maximum default stock level for each location.
MENU_NOSTAFFFKINTEGERNoThe ID number of the Menu Definition specified for the staff member. Corresponds to the menu's SEQNO field in the MENU_COLLECTION table.
MINSTOCKSTOCK_LOC_INFOFLOAT(53)NoThe minimum stock quantity for the stock code at the location.
MINSTOCKSTOCK_ITEMSFLOAT(53)NoThe minimum default stock level for each location.
MINSTOCKSTOCKREQUIREMENTFLOAT(53)NoThe minimum stock level for the stock item.
MOBILE_ACCESSSTAFFCHAR(1)YesThis field contains 'Y' if the staff member is authorised to use the EXO OnTheGo mobile app.
MONTHUNITSSTOCK_ITEMSFLOAT(53)NoSales totals in terms of quantity for the current month.
MONTHVALUESTOCK_ITEMSFLOAT(53)NoSales value for the current month.
NAMEGLACCSVARCHAR(40)NoThe account name.
NAMESTAFFVARCHAR(30)NoThe staff member's full name.
NARRATIVE_SEQNOSTOCK_TRANS_HDRINTEGERNoID of the narrative on the transaction (entered via manual stock movement).
NARRATIVE_SEQNOCR_INVLINESFKINTEGERNoThe SEQNO for the narrative on this line.
NARRATIVE_SEQNODR_INVLINESINTEGERNoThe SEQNO for the narrative on this line.
NARRATIVE_SEQNOSTOCK_REQUESTSFKINTEGERNoThe ID number for the narrative on this request.
NARRATIVE_SEQNOSTOCK_REQUESTLINESFKINTEGERNoThe ID number for the narrative on this line.
NEW_AVECOSTSTOCK_TRANSFLOAT(53)NoAverage cost of the item after this transaction.
NEW_LOC_QTYSTOCK_TRANSFLOAT(53)NoQuantity of the item in the location the movement took place after this transaction.
NEW_QUANTITYSTOCK_TRANSFLOAT(53)NoStock on hand of the item after this transaction.
NEW_SEQORDERSTOCK_TRANSINTEGERNoNew sequence order of the transaction.
NICKNAMESTAFFVARCHAR(15)NoA short nickname for the employee.
NON_STOCK_AUTH_AMTSTAFFFLOAT(53)NoThe staff member's Non-Stock Purchase Order Authorisation Limit.
NOTESINWARDS_GOODSVARCHAR(500)NoAny receipt notes on the transaction.
NOTESBILLOMAT_HDRVARCHAR(2048)NoAny notes recorded for the BOM.
NOTESSTOCK_ITEMSVARCHAR(4096)NoAny notes for the stock item.
NOTESGLACCSVARCHAR(4096)NoAny notes on the GL account.
NUMDECIMALSSTOCK_ITEMSINTEGERYesThe number of decimal places that can be entered for the stock item's quantity.
NUM_CARTONSINWARDS_GOODSINTEGERYesThe number of cartons.
NUNITPRDR_INVLINESASNoA computed field containing the unit price, taking into account the discount on the line.
ON_COSTSSTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
ON_COSTSSTOCK_TRANSFLOAT(53)NoOn costs (only applicable to lines sourcing from inwards goods receipts).
OPENINGBALGLACCSFLOAT(53)NoThe account's opening balance.
ORDERQTYDR_INVLINESFLOAT(53)NoThe Order Qty from the Sales Order.
ORIG_SEQNOSTOCK_REQUESTSINTEGERNo
OUTPUT_CODEBILLOMAT_HDRVARCHAR(23)NoStock code of the BOM's output item.
PACKSTOCK_ITEMSVARCHAR(10)NoDescribes the unit of sale for pricing, e.g. EACH or PACK.
PACKREFERENCESUPPLIER_STOCK_ITEMSVARCHAR(20)NoAn optional reference code for the pack.
PACKSLIPINWARDS_GOODSVARCHAR(50)NoThe packing slip reference.
PACK_SIZESTOCK_REQUESTLINESFLOAT(53)NoThe pack size of the stock item on the line.
PASSWORD_CHANGEDSTAFFDATETIMEYesThe date and time when the staff member's password was last changed.
PAYROLL_IDSTAFFVARCHAR(15)NoThe 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.
PERIOD_SEQNOSTOCK_TRANS_HDRINTEGERYesID number of the period that the record belongs to.
PERIOD_SEQNOSTOCK_TRANSFKINTEGERYesID number of the period the transaction belongs to.
PERIOD_SEQNOINWARDS_GOODS_COSTSFKINTEGERYesThe period ID of the invoice linked to this record.
PERIOD_SEQNOINWARDS_GOODS_LINESFKINTEGERYesThe ID number of the period on the invoice linked to this record.
PERIOD_TRADED_IN_SEQSTOCK_TRANSCHAR(1)NoThis field contains 'N' if the transaction was in a prior period.
PHONESTAFFVARCHAR(30)NoThe staff member's work telephone number.
PICTURE_URLSTOCK_WEBVARCHAR(80)NoThe URL of the picture to be displayed for the stock item.
PLUSTOCK_TRANSVARCHAR(23)NoPrice Lookup Unit (applies to lookup items).
PLUSTOCK_TRANS_ARCHIVEVARCHAR(23)NoSee STOCK_TRANS.
POSTTIMESTOCK_TRANSDATETIMENoA timestamp of when the record was entered.
POSTTIMESTOCK_TRANS_ARCHIVEDATETIMENoSee STOCK_TRANS.
POST_LOOKUP_TO_GLSTOCK_TRANS_ARCHIVECHAR(1)NoSee STOCK_TRANS.
POST_LOOKUP_TO_GLSTOCK_TRANSCHAR(1)NoIf this field contains 'N' and the stock item is a lookup item, there is no journal against the transaction.
POST_TO_GLSTOCK_TRANSCHAR(1)NoIf this field is set to 'Y', the stock line is posted to GL; otherwise it is not.
POST_TO_GLSTOCK_TRANS_ARCHIVECHAR(1)NoSee STOCK_TRANS.
PO_INVLINESEQNOSTOCK_SERIALNOSINTEGERYesThe invoice line ID linked to the Purchase Order for the serial number.
PO_INVSEQNOSTOCK_SERIALNOSINTEGERYesThe invoice ID linked to the Purchase Order for the serial number.
PO_LINE_NUMINWARDS_GOODS_LINESFKINTEGERYesThe ID number of the related Purchase Order line.
PO_NUMBERINWARDS_GOODS_LINESFKINTEGERYesThe ID number of the related Purchase Order header.
PQTYSTOCK_ITEMSFLOAT(53)No
PREV_AVECOSTSTOCK_TRANSFLOAT(53)NoAverage cost of the stock item before this transaction.
PREV_AVECOSTSTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
PREV_QUANTITYSTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
PREV_QUANTITYSTOCK_TRANSFLOAT(53)NoQuantity of the stock item before the transaction.
PRICEPERKGSTOCK_ITEMSFLOAT(53)NoThe stock item's sell price per kg.
PRICEQTYSTOCK_ITEMSFLOAT(53)NoThe stock item's sell price per quantity.
PRICE_OVERRIDDENDR_INVLINESCHAR(1)YesContains 'Y' if the price on the line has been manually modified.
PRICING_MODEBILLOMAT_HDRINTEGERNoHow the output item is priced. 0 = Priced by total. 1 = Priced by components.
PRIVATE_ACCGLACCSCHAR(1)YesThis field is set to 'Y' if the GL account is a private account.
PRODUCTLOCATIONBILLOMAT_TEMPFKINTEGERNoThe location of the BOM product stock item.
PROFITVARIANCESTOCK_GROUPSFLOAT(53)NoThe expected margin variance for the group.
PURCHORDLINESEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Purchase Order line that the item is linked to.
PURCHORDNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Purchase Order that the item has been receipted in against.
PURCHORDQTYSTOCKREQUIREMENTFLOAT(53)NoIncoming stock.
PURCHPACKPRICEINWARDS_GOODS_LINESFLOAT(53)YesThe purchase pack price on the line.
PURCHPACKPRICESUPPLIER_STOCK_ITEMSFLOAT(53)YesThe Pack Cost when purchasing the stock item from the supplier.
PURCHPACKQUANTSUPPLIER_STOCK_ITEMSFLOAT(53)YesThe Qty per Pack when purchasing the stock item from the supplier.
PURCHPACKQUANTINWARDS_GOODS_LINESFLOAT(53)YesThe purchase pack quantity on the line.
PURCHTAXRATESTOCK_ITEMSINTEGERNoDefault GST rate for purchase transactions.
PURCH_GLSUBCODESTOCK_ITEMSINTEGERNoThe default GL sub-account code that purchase transactions for this stock item are posted to.
PURCH_GLSUBCODESTOCK_GROUPSINTEGERNoThe code of the GL subaccount for Purchases Clearing.
PURCH_GL_CODESTOCK_ITEMSFKINTEGERNoThe GL code that purchase transactions for this stock are posted to.
PURCH_GL_CODESTOCK_GROUPSFKINTEGERNoThe code of the GL account for Purchases Clearing.
QTYSTOCK_LOC_INFOFLOAT(53)YesThe current stock quantity for the stock code at the location.
QTY_TRADED_IN_NEGSTOCK_TRANSFLOAT(53)NoQuantity traded when total stock on hand for the item was in negative at the time of the transaction.
QUANTITYSTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
QUANTITYDR_INVLINESFLOAT(53)NoThe quantity for this line.
QUANTITYINWARDS_GOODS_LINESFLOAT(53)NoThe receipt quantity on the line.
QUANTITYSTOCK_TRANSFLOAT(53)NoQuantity of stock.
QUANTITYCR_INVLINESFLOAT(53)NoThe quantity for this line.
QUANTITYBILLOMAT_LINESFLOAT(53)NoThe quantity on this line.
QUANTITYBILLOMAT_TEMPFLOAT(53)NoThe quantity of the BOM component item.
RECEIPT_NOSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
RECEIPT_NOSTOCK_TRANSINTEGERNoReceipt number when the source of the transaction is an Inwards Goods Receipt.
REF1STOCK_TRANSVARCHAR(30)NoSource transaction reference. Usually contains the Debtor/Creditor's invoice number, Purchase Order number, Sales Order number, job number, etc.
REF1STOCK_TRANS_ARCHIVEVARCHAR(30)NoSee STOCK_TRANS.
REF2STOCK_TRANSVARCHAR(30)NoReference text with details of source of this stock movement.
REF2STOCK_TRANS_ARCHIVEVARCHAR(30)NoSee STOCK_TRANS.
REFERENCESTOCK_SERIALNOSVARCHAR(30)NoA reference code for the record.
REFERENCESTOCK_TRANS_HDRVARCHAR(30)NoReference text for the transaction.
REFERENCECODEBILLOMAT_TEMPVARCHAR(30)NoA reference code for the record.
RELATED_SEQNOINWARDS_GOODSINTEGERNoFor reversals, this field contains the source Inwards Goods ID number.
REPORTCODESTOCK_GROUPSVARCHAR(15)NoA report code for the group.
REPORTCODESTOCK_GROUP2SVARCHAR(15)NoA report code for the group.
REPORTCODEGLACCSVARCHAR(15)NoThe report code used by the GL account.
REPORTS_TO_STAFFNOSTAFFINTEGERNoThe ID number of the staff member that this staff member reports to.
REQUESTLINESEQNOSTOCK_SERIALNOSINTEGERNoStock request Line ID
REQUESTSEQNOSTOCK_SERIALNOSINTEGERNoStock request ID
REQUEST_DATESTOCK_REQUESTSDATETIMENoThe date and time when the request was created.
REQUIRE_DATESTOCK_REQUESTSDATETIMENoThe date and time that the request must be completed by.
REQ_QUANTSTOCK_REQUESTLINESFLOAT(53)NoThe Requested Qty on the line.
RESTRICTED_ITEMSTOCK_ITEMSCHAR(1)YesThis field is set to 'Y' if the stock item is a restricted item.
REVERSALSTATUSINWARDS_GOODSINTEGERNoThe reversal status. Will be one of:
0 = Normal
1 = Reversed
2 = Reversal
REVERSEDSTOCK_TRANSCHAR(1)NoThis field contains 'Y' if the transaction has been reversed.
REVERSEDSTOCK_TRANS_ARCHIVECHAR(1)NoSee STOCK_TRANS.
RMALINESEQNOSTOCK_SERIALNOSINTEGERNo
RMASEQNOSTOCK_SERIALNOSINTEGERNo
SALES0STOCKREQUIREMENTFLOAT(53)NoCurrent month sales quantity for the stock item.
SALES1STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item for the month prior to current month.
SALES10STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item ten months prior to current month.
SALES11STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item eleven months prior to current month.
SALES12STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item twelve months prior to current month.
SALES2STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item two months prior to current month.
SALES3STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item three months prior to current month.
SALES4STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item four months prior to current month.
SALES5STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item five months prior to current month.
SALES6STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item six months prior to current month.
SALES7STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item seven months prior to current month.
SALES8STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item eight months prior to current month.
SALES9STOCKREQUIREMENTFLOAT(53)NoSales quantity for the stock item nine months prior to current month.
SALESORDLINESEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Sales Order line that the item is linked to.
SALESORDNOSTOCK_SERIALNOSINTEGERYesThe ID number of the Sales Order ID that the item has been committed against.
SALESORDQTYSTOCKREQUIREMENTFLOAT(53)NoCommitted stock.
SALESTAXRATESTOCK_ITEMSINTEGERNoDefault GST rate for sales transactions.
SALES_GLSUBCODESTOCK_GROUPSINTEGERNoThe code of the GL subaccount for Sales.
SALES_GLSUBCODESTOCK_ITEMSINTEGERNoThe default GL sub-account code that sales transactions for this stock item are posted to.
SALES_GL_CODESTOCK_GROUPSFKINTEGERNoThe code of the GL account for Sales.
SALES_GL_CODESTOCK_ITEMSFKINTEGERNoThe default GL code that sales transactions for this stock item are posted to.
SALES_HTMLSTOCK_WEBVARCHAR(4096)NoThe Sales text (HTML) for the specified stock item.
SECTIONGLACCSINTEGERNoThis field is set to 0 for Profit and loss accounts or 1 for Balance sheet accounts.
SECURITYPROFILEIDSTAFFINTEGERYesThe ID number of the staff member's Security profile. Corresponds to the profile's ID field in the PROFILE table.
SELLPRICE1BILLOMAT_HDRFLOAT(53)NoSell price 1.
SELLPRICE1STOCK_ITEMSFLOAT(53)NoSell price 1.
SELLPRICE10BILLOMAT_HDRFLOAT(53)NoSell price 10.
SELLPRICE10STOCK_ITEMSFLOAT(53)NoSell price 10.
SELLPRICE2BILLOMAT_HDRFLOAT(53)NoSell price 2.
SELLPRICE2STOCK_ITEMSFLOAT(53)NoSell price 2.
SELLPRICE3BILLOMAT_HDRFLOAT(53)NoSell price 3.
SELLPRICE3STOCK_ITEMSFLOAT(53)NoSell price 3.
SELLPRICE4BILLOMAT_HDRFLOAT(53)NoSell price 4.
SELLPRICE4STOCK_ITEMSFLOAT(53)NoSell price 4.
SELLPRICE5BILLOMAT_HDRFLOAT(53)NoSell price 5.
SELLPRICE5STOCK_ITEMSFLOAT(53)NoSell price 5.
SELLPRICE6BILLOMAT_HDRFLOAT(53)NoSell price 6.
SELLPRICE6STOCK_ITEMSFLOAT(53)NoSell price 6.
SELLPRICE7BILLOMAT_HDRFLOAT(53)NoSell price 7.
SELLPRICE7STOCK_ITEMSFLOAT(53)NoSell price 7.
SELLPRICE8BILLOMAT_HDRFLOAT(53)NoSell price 8.
SELLPRICE8STOCK_ITEMSFLOAT(53)NoSell price 8.
SELLPRICE9BILLOMAT_HDRFLOAT(53)NoSell price 9.
SELLPRICE9STOCK_ITEMSASNoSell price 9.
SEND_NOWSTOCK_REQUESTLINESFLOAT(53)NoThe Send Now quantity on the line.
SENT_QUANTSTOCK_REQUESTLINESFLOAT(53)NoThe Sent Qty on the line.
SEQNOSTOCKTAKE_TOTALSPKINTEGERYesA unique ID number for the stocktake line.
SEQNOINWARDS_GOODS_LINESPKINTEGERYesA unique ID number for the record.
SEQNOINWARDS_GOODS_COSTSPKINTEGERYesA unique ID number for the record.
SEQNOCR_INVLINESPKINTEGERYesA unique transaction line ID.
SEQNOBILLOMAT_TEMPPKINTEGERYesA unique ID number for the record.
SEQNODR_INVLINESFKINTEGERYesA unique transaction ID.
SEQNOINWARDS_GOODSPKINTEGERYesA unique ID number for the transaction.
SEQNOSTOCK_REQUESTLINESPKINTEGERYesA unique ID number for the stock transfer request line.
SEQNOSTOCK_SERIALNOSPKINTEGERYesA unique ID number for the record.
SEQNOSTOCK_TRANSPKINTEGERYesA unique ID for the record.
SEQNOSTOCK_REQUESTSPKINTEGERYesA unique ID number for the transfer request
SEQNOSTOCK_REQUESTTYPESPKINTEGERYesA unique ID number for the request type.
SEQNOSTOCK_TRANS_HDRPKINTEGERYesA unique ID for the record.
SEQNOSTOCK_TRANS_ARCHIVEPKINTEGERYesSee STOCK_TRANS.
SEQNOBILLOMAT_LINESPKINTEGERYesA unique ID number for the line.
SERIALNOSTOCK_SERIALNOSVARCHAR(50)NoThe serial number assigned to the stock item.
SERIALNODR_INVLINESVARCHAR(50)No
SERIALNO_TYPESTOCK_ITEMSINTEGERYesHow 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
SERIALNO_TYPESTOCKTAKE_TOTALSFKINTEGERNoHow 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_IDSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
SESSION_IDSTOCK_TRANSINTEGERNoSession ID
SESSION_IDINWARDS_GOODSINTEGERNoThe session ID for the record.
SHIPMENTNOINWARDS_GOODS_COSTSINTEGERNoThe shipment number on the record.
SHIPMENTNOINWARDS_GOODS_LINESINTEGERYesThe shipment number on the record.
SHIPMENTNOINWARDS_GOODSINTEGERYesThe shipment number on the transaction.
SHOWLINECR_INVLINESCHAR(1)NoThis field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
SHOWLINEINWARDS_GOODS_LINESCHAR(1)NoThis field is used to control the visibility of the line on Clarity forms.
SHOWLINESTOCK_REQUESTLINESCHAR(1)NoThis field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
SHOWLINEDR_INVLINESCHAR(1)NoThis field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
SIZECODESTOCK_SIZEVARCHAR(5)YesA user-defined code number for the size.
SIZEIDSTOCK_SIZEPKINTEGERYesA unique ID number for the size.
SIZENAMESTOCK_SIZEVARCHAR(30)NoA descriptive name for the size.
SMTP_SEQNOSTAFFINTEGERNoWhere 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.
SOLINEIDSTOCK_REQUESTLINESINTEGERYes
SORTORDERSTOCK_SIZEINTEGERNoThis field contains the sort order value, which is used to order sizes on the Style Picker window.
SORTORDERSTOCK_COLOURINTEGERNoThis field contains the sort order value, which is used to order colours on the Style Picker window.
SO_INVLINESEQNOSTOCK_SERIALNOSINTEGERYesThe invoice line ID linked to the Sales Order for the serial number.
SO_INVSEQNOSTOCK_SERIALNOSINTEGERYesThe invoice ID linked to the Sales Order for the serial number.
SPREAD_TYPEINWARDS_GOODS_COSTSINTEGERYesThe spread type for on costs:
0 = Quantity
1 = Value
2 = Weight
3 = Cubic
STAFFNOSTOCK_REQUESTSFKINTEGERNoThe ID number of the staff member assigned to the request.
STAFFNOSTAFFPKINTEGERYesA unique identifier for the staff record.
STAFFNOBILLOMAT_TEMPFKINTEGERYesThe ID number of the staff member on the record.
STAFFNOSTOCK_TRANS_HDRFKINTEGERYesID number of the staff member who entered the transaction.
STATUSSTOCK_GROUPSCHAR(1)NoThis field contains 'Y' if the 'Display on website option' for the group is ticked.
STATUSSTOCK_GROUP2SVARCHAR(1)NoThis field contains 'Y' if the 'Display on website option' for the group is ticked.
STATUSSTOCK_REQUESTSINTEGERNoThe status of the stock transfer. Will be one of:
0 = New Request
1 = Picking
2 = In Transit
3 = Complete
STATUSSTOCK_ITEMSCHAR(1)NoThe stock item's status. Will be one of:
S = Stock item
L = Lookup item
STDCOSTSTOCK_ITEMSFLOAT(53)NoThe stock item's standard cost.
STKMOVLINESEQNOSTOCK_SERIALNOSINTEGERNoStock transaction ID
STKMOVSEQNOSTOCK_SERIALNOSINTEGERNoStock transaction header ID
STOCKCODESTOCK_TRANS_ARCHIVEVARCHAR(23)NoSee STOCK_TRANS.
STOCKCODESTOCKREQUIREMENTFKVARCHAR(23)YesThe stock item's ID code.
STOCKCODESTOCK_SERIALNOSFKVARCHAR(23)YesThe stock code of the serialised stock item.
STOCKCODEBILLOMAT_TEMPFKVARCHAR(23)NoThe stock code of the BOM component item.
STOCKCODESTOCK_ITEMSPKVARCHAR(23)YesA unique ID code for the stock item.
STOCKCODEBILLOMAT_LINESFKVARCHAR(23)NoThe stock code of the stock item on this line.
STOCKCODECR_INVLINESFKVARCHAR(23)NoCode of the Stock item on this line.
STOCKCODESTOCK_WEBFKCHAR(23)YesThe stock code of the stock item that this record applies to.
STOCKCODEINWARDS_GOODS_LINESFKVARCHAR(23)NoThe stock code of the stock item on the line.
STOCKCODEDR_INVLINESFKVARCHAR(23)NoCode of the Stock item on this line.
STOCKCODESTOCKTAKE_TOTALSFKVARCHAR(23)NoThe ID code of the stock item being counted.
STOCKCODESTOCK_REQUESTLINESFKVARCHAR(23)YesThe ID code of the stock item on the line.
STOCKCODESTOCK_LOC_INFOPK, FKVARCHAR(23)YesThe unique ID code of the stock item.
STOCKCODESUPPLIER_STOCK_ITEMSFKVARCHAR(23)YesThe stock item's ID code in EXO Business.
STOCKCODESTOCK_TRANSFKVARCHAR(23)NoThe ID code of the stock item.
STOCKGROUPSTOCKREQUIREMENTFKINTEGERNoThe ID number of the stock item's Primary Stock Group.
STOCKGROUPSTOCK_ITEMSFKINTEGERNoThe Primary (Fine) Stock Group that the item belongs to.
STOCKGROUPSTOCKTAKE_TOTALSFKINTEGERNoThe Stock Group that the stock item belongs to.
STOCKGROUP2STOCKTAKE_TOTALSFKINTEGERNoThe Alternative Stock Group
STOCKGROUP2STOCK_ITEMSFKINTEGERNoThe stock item's Secondary (Coarse) Stock Group.
STOCKGROUP2_REPCSTOCKTAKE_TOTALSFKVARCHAR(15)NoThe report code of the stock item's Secondary Stock Group.
STOCKGROUP_REPCSTOCKTAKE_TOTALSFKVARCHAR(15)NoThe report code of the stock item's Primary Stock Group.
STOCKINSEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the stock transaction that the item was receipted in against.
STOCKOUTSEQNOSTOCK_SERIALNOSINTEGERYesThe ID number of the stock transaction against which the item was moved out of inventory.
STOCKPRICEGROUPSTOCK_ITEMSFKINTEGERNoThe price group that the stock item belongs to.
STOCK_AUTH_AMTSTAFFFLOAT(53)NoThe staff member's Stock Purchase Order Authorisation Limit.
STOCK_CLASSIFICATIONSTOCK_ITEMSFKINTEGERYesThe stock classification that the item belongs to.
SUBCODEDR_INVLINESINTEGERNoThe GL subaccount code on the line.
SUPPLIERCODEINWARDS_GOODS_LINESVARCHAR(50)NoThe supplier code on the line.
SUPPLIERCODESUPPLIER_STOCK_ITEMSPKVARCHAR(23)YesThe supplier's ID code for the stock item.
SUPPLIERCOSTSTOCK_ITEMSFLOAT(53)YesThe supplier cost price.
SUPPLIERNAMEINWARDS_GOODSVARCHAR(70)NoThe name of the supplier on the transaction.
SUPPLIERNOSTOCK_ITEMSFKINTEGERNoThe ID number (CR_ACCS.ACCNO) of the stock item's main supplier.
SUPPLIERNOINWARDS_GOODSFKINTEGERYesThe ID number of the supplier (Creditor) account.
SUPPLIERNOSTOCKTAKE_TOTALSINTEGERNoThe ID number of the Creditor who supplies the stock item.
SUPPLIERNO2STOCK_ITEMSINTEGERNoAlternate supplier for the stock item.
SUPPLIERNO3STOCK_ITEMSINTEGERNoAlternate supplier for the stock item.
SUPPLIERREFINWARDS_GOODSVARCHAR(50)NoThe shipping reference on the transaction.
SUP_NOWSTOCK_REQUESTLINESFLOAT(53)NoThe Receive Now quantity on the line.
SUP_QUANTSTOCK_REQUESTLINESFLOAT(53)NoThe Received Qty on the line.
SU_SEQNOSTOCK_SERIALNOSINTEGERNoServiceable Unit ID
SWATCHIDSTOCK_COLOURINTEGERNoThe colour value of the colour record's swatch.
SYSTEMQTYSTOCKTAKE_TOTALSFLOAT(53)NoThe quantity recorded in the EXO Business system for the item at this location.
TAXRATEDR_INVLINESFLOAT(53)NoThe percentage tax rate on the line at the time of the transaction.
TAXRATECR_INVLINESFLOAT(53)NoThe percentage tax rate on the line at the time of the transaction.
TAXRATE_NODR_INVLINESFKINTEGERNoThe ID number of the tax rate used by the transaction.
TAXRATE_NOCR_INVLINESFKINTEGERNoThe ID number of the tax rate used by the transaction.
TAXSTATUSGLACCSINTEGERNoThe Override GST rate specified for the GL account. A value of -1 corresponds to the AUTO SELECT RATE option.
TIME_COUNTSHEETSSTOCKTAKE_CTRLDATETIMENoThe date and time when count sheets were printed for the location.
TIME_INITIALISEDSTOCKTAKE_CTRLDATETIMENoThe date and time when the location was initialised for stocktake.
TIME_KEYEDSTOCKTAKE_CTRLDATETIMENoThe date and time when counted quantities were keyed for the location.
TIME_UPLOADEDSTOCKTAKE_CTRLDATETIMENoThe date and time when stock transactions were uploaded to the Stock ledger.
TOLOCATIONSTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
TOLOCATIONSTOCK_TRANSFKINTEGERNoID of the Destination location (applies in case of stock transfers).
TOTALSTOCKSTOCK_ITEMSFLOAT(53)YesTotal units of stock for the item.
TO_LOCSTOCK_REQUESTSINTEGERNoThe ID number of the location that stock is to be transferred to.
TRANSDATEDR_INVLINESDATETIMENoThe date of the transaction.
TRANSDATEINWARDS_GOODS_COSTSDATETIMENoThe transaction date of the invoice linked to this record.
TRANSDATEINWARDS_GOODSDATETIMENoThe transaction date.
TRANSDATESTOCK_TRANS_HDRDATETIMEYesThe date and time when the transaction took place.
TRANSDATEBILLOMAT_TEMPDATETIMENoThe date and time when the transaction occurred.
TRANSDATESTOCK_TRANS_ARCHIVEDATETIMENoSee STOCK_TRANS.
TRANSDATESTOCK_TRANSDATETIMENoThe date when the stock movement took place.
TRANSTYPESTOCK_TRANS_HDRINTEGERYesThe transaction type. Will be one of:
0=Sales
1=Receipt
2=Transfer
3=Adjust Out
4=Adjust In
5=Average Cost Adjustment
TRANSTYPESTOCK_TRANS_ARCHIVEINTEGERNoSee STOCK_TRANS.
TRANSTYPESTOCK_TRANSINTEGERNoThe type of the transaction. Will be one of: 0=Sales 1=Receipt 2=Transfer 3=Adjust Out 4=Adjust In 5=Average Cost Adjustment
TRANSTYPESTOCK_REQUESTSFKINTEGERNoThe ID number of the Stock Request Type (from STOCK_REQUESTTYPES).
TWITTER_TOKEN_KEYSTAFFVARCHAR(max)NoIf 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_SECRETSTAFFVARCHAR(max)NoIf the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token secret is stored here.
UNITCOSTSTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
UNITCOSTSTOCK_TRANSFLOAT(53)NoThe unit cost price of the stock item.
UNITCOSTDR_INVLINESFLOAT(53)NoThe unit cost of the Stock item on this line.
UNITCOSTSTOCKTAKE_TOTALSFLOAT(53)NoThe unit cost for the stock item. Unit costs are only entered during stock take if the "Initialise cost prices" stock take option is enabled.
UNITNOSTOCK_SERIALNOSINTEGERYesThe ID number of the serviceable unit that the item is linked to.
UNITPRICESTOCK_TRANS_ARCHIVEFLOAT(53)NoSee STOCK_TRANS.
UNITPRICESTOCK_TRANSFLOAT(53)NoUnit price of the stock item.
UNITPRICEINWARDS_GOODS_LINESFLOAT(53)NoThe unit price of the stock item on the line.
UNITPRICECR_INVLINESFLOAT(53)NoThe unit price of the Stock item on this line.
UNITPRICEBILLOMAT_TEMPFLOAT(53)NoThe unit price of the BOM component item.
UNITPRICEDR_INVLINESFLOAT(53)NoThe unit price of the Stock item on this line.
UNITPRICE_INCTAXCR_INVLINESFLOAT(53)NoThe unit price of the Stock item on this line, inclusive of tax.
UNITPRICE_INCTAXDR_INVLINESFLOAT(53)NoThe unit price of the Stock item on this line, inclusive of tax.
UPDATEITEM_CODESTOCK_ITEMSVARCHAR(23)NoOnly applies to lookup items. The ID number of the stocked item that maintains the actual stock.
UPDATEITEM_FLAGSTOCK_TRANSCHAR(1)YesThis field contains 'Y' for a normal stocked item, 'T' for a linked stock code, or 'U' for a transaction created for the SKU of the linked stock code.
UPDATEITEM_FLAGSTOCK_TRANS_ARCHIVECHAR(1)NoSee STOCK_TRANS.
UPDATEITEM_QTYSTOCK_ITEMSFLOAT(53)NoOnly applies to lookup items. Quantity of the stocked item.
UPDATE_STOCKCR_INVLINESCHAR(1)NoIf this field is set to 'Y', stock movements are created via the trigger CR_INVLINES_POST. The field is then set to 'T'.
UPDATE_STOCKDR_INVLINESCHAR(1)NoIf this field is set to 'Y', stock movements are created via the trigger DR_INVLINES_POST. The field is then set to 'T'.
USERPROFILEIDSTAFFINTEGERYesThe ID number of the staff member's User profile. Corresponds to the profile's ID field in the PROFILE table.
USESUBCODESGLACCSCHAR(1)NoNot used.
VALUE_TRADED_IN_NEGSTOCK_TRANSFLOAT(53)NoValue traded when total stock on hand for the item was in negative at the time of the transaction.
VARIABLECOSTSTOCK_ITEMSCHAR(1)YesThe field is set to 'Y for Variable Cost stock items.
VARIANCESTOCKTAKE_TOTALSFLOAT(53)NoThe difference between the system quantity and the counted quantity. Populated automatically when the Stocktake Variance Report is run for the Stock Take utility.
VARIANTLINEBILLOMAT_LINESCHAR(1)NoThis field contains 'Y' if the line is not included in the BOM by default.
VAR_GLPOSTEDINWARDS_GOODS_LINESCHAR(1)NoThis field contains 'Y' if variance has been posted against this line.
VIRTSTOCKSTOCKREQUIREMENTFLOAT(53)NoFree stock taking into account the incoming and committed stock.
WASTAGEBILLOMAT_HDRFLOAT(53)NoThe BOM's Overhead Allocation percentage.
WEB_SHOWSTOCK_ITEMSCHAR(1)No
WEIGHTSTOCK_ITEMSFLOAT(53)NoPhysical weight of the stock item.
WORKSORDLINESEQNOSTOCK_SERIALNOSINTEGERNoWorks Order Line ID
WORKSORDSEQNOSTOCK_SERIALNOSINTEGERNoWorks order ID
X_BINCODESTOCK_GROUPSVARCHAR(12)NoThe bin code for the style.
X_COLOURIDSTOCK_ITEMSINTEGERNoStyle colour ID of the stock item. Used by the Style, Size Colour functionality.
X_COLOURIDSSTOCK_GROUPSVARCHAR(255)NoThis field contains a comma-separated list of colour IDs applicable to the style.
X_DESCRIPTION_FORMULASTOCK_GROUPSVARCHAR(40)NoThe stock item description formula for the group.
X_ISSTYLESTOCK_GROUPSCHAR(1)NoThis field contains 'Y' if the group is a style.
X_MAXSTOCKSTOCK_GROUPSFLOAT(53)NoThe maximum stock level for the style.
X_MINSTOCKSTOCK_GROUPSFLOAT(53)NoThe minimum stock level for the style.
X_PRICEGROUPSTOCK_GROUPSFKCHAR(1)NoThis field contains 'Y' if the style has a matching Price Group.
X_SELLPRICE1STOCK_GROUPSFLOAT(53)NoSell price 1 for the style.
X_SELLPRICE10STOCK_GROUPSFLOAT(53)NoSell price 10 for the style.
X_SELLPRICE2STOCK_GROUPSFLOAT(53)NoSell price 2 for the style.
X_SELLPRICE3STOCK_GROUPSFLOAT(53)NoSell price 3 for the style.
X_SELLPRICE4STOCK_GROUPSFLOAT(53)NoSell price 4 for the style.
X_SELLPRICE5STOCK_GROUPSFLOAT(53)NoSell price 5 for the style.
X_SELLPRICE6STOCK_GROUPSFLOAT(53)NoSell price 6 for the style.
X_SELLPRICE7STOCK_GROUPSFLOAT(53)NoSell price 7 for the style.
X_SELLPRICE8STOCK_GROUPSFLOAT(53)NoSell price 8 for the style.
X_SELLPRICE9STOCK_GROUPSFLOAT(53)NoSell price 9 for the style.
X_SIZEIDSTOCK_ITEMSINTEGERNoStyle size ID of the stock item. Used by the Style, Size Colour functionality.
X_SIZEIDSSTOCK_GROUPSVARCHAR(255)NoThis field contains a comma-separated list of size IDs applicable to the style.
X_STOCKCODE_FORMULASTOCK_GROUPSVARCHAR(23)NoThe stock item code formula for the group.
X_SUPPLIERCOSTSTOCK_GROUPSFLOAT(53)NoThe supplier cost in the currency of the supplier account.
X_SUPPLIERNOSTOCK_GROUPSINTEGERNoThe ID number of the main supplier of the style.
YEARUNITSSTOCK_ITEMSFLOAT(53)NoYear to date sales totals in terms of quantity.
YEARVALUESTOCK_ITEMSFLOAT(53)NoSales value for the current year.