MYOB EXO Business Stock
List of attributes
Attribute details
Attribute: ABSENT
TableSTAFF
CommentThis field is set to 'Y' if the staff member is currently absent, i.e. if their Absent flag is ticked in EXO Business Configurator.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: ACCGROUP
TableGLACCS
CommentThe GL account's Account Group.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: ACCNO
TableCR_INVLINES
CommentThe account number of the Creditor that the transaction belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toCR_ACCS.ACCNO


Attribute: ACCNO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: ACCNO
TableINWARDS_GOODS_COSTS
CommentThe supplier (Creditor account ID).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toCR_ACCS.ACCNO


Attribute: ACCNO
TableSTOCKREQUIREMENT
CommentThe ID number of the stock item's supplier (from CRACCS).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: ACCNO
TableDR_INVLINES
CommentThe account number of the Debtor that the transaction belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toDR_TRANS.ACCNO


Attribute: ACCNO
TableGLACCS
CommentThe unique GL account number.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: ACCNO
TableSUPPLIER_STOCK_ITEMS
CommentThe ID number of the supplier (Creditor) account.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: ACCNO
TableSTOCK_TRANS
CommentFor manual stock movements this field is NULL. For movements originating from other ledgers, this contains the account number against the source transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: ACCOUNT_STATUS
TableSTAFF
CommentThe staff member's account status. Will be one of:
0 = Account OK
1 = Account Locked
2 = Password Expired
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: ACTUALREORD
TableSTOCKREQUIREMENT
CommentActual reorder quantity for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ACTUAL_COST
TableSTOCK_SERIALNOS
CommentThe actual cost of the item when moved into stock.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: AGE
TableSTOCK_TRANS
CommentCalculated field that indicates the age of the transaction.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: AGE
TableSTOCK_TRANS_HDR
CommentCalculated field that indicates the age the record belongs to.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: AGE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: AGE
TableINWARDS_GOODS_COSTS
CommentThe invoice's age. This is calculated based on PERIOD_SEQNO.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: AGE_STAMP
TableSTOCK_TRANS
CommentThis is a historical field that has been superseded by the AGE calculated field.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: AGE_STAMP
TableSTOCK_TRANS_HDR
CommentThis is a historical field that has been superseded by the AGE calculated field.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: AGE_STAMP
TableINWARDS_GOODS_COSTS
CommentThis is a historical field that has been superseded by the AGE calculated field.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: AGE_STAMP
TableINWARDS_GOODS_LINES
CommentThis is a historical field that has been superseded by the AGE calculated field.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: ALERT
TableSTOCK_ITEMS
CommentText of the pop-up alert message that appears when the stock item is sold or purchased.
Primary keyNo
Data typeVARCHAR(60)
Domain name
Not NULLNo
Default
Refers to


Attribute: ALLOWJOURNAL
TableGLACCS
CommentThis field is set to 'Y' if the GL account allows journals.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ALT_AVECOST
TableSTOCK_TRANS
CommentAlternate weighted average cost.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ALT_AVECOST
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ALT_QUANTITY
TableSTOCK_TRANS
CommentAlternate quantity.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ALT_QUANTITY
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ALT_SEQNO
TableSTOCK_TRANS
CommentAlternate SEQNO.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: ALT_SEQNO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: ANALYSIS
TableDR_INVLINES
CommentGL code for the Stock line. Can be overridden. The visibility of this column onscreen is controlled by the profile "Enable display and override of GL code from stock item".
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: ANALYSIS
TableCR_INVLINES
CommentGL code for the Stock line. Can be overridden. The visibility of this column onscreen is controlled by the profile "Enable display and override of GL code from stock item".
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: API_ACCESS
TableSTAFF
CommentThis field contains 'Y' if the staff member is authorised to use the EXO API.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: APP_PASSWORD
TableSTAFF
CommentThe staff member's password, used when logging in to the EXO Business system. Passwords are stored in an encrypted format.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: ASSIGNED_LINESEQNO
TableSTOCK_SERIALNOS
CommentThe 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.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: ASSIGNED_SEQNO
TableSTOCK_SERIALNOS
CommentThe 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.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: AUTH_AMT
TableSTAFF
CommentThe staff member's Credit Invoice Authorisation Limit.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: AUTOBUILD
TableBILLOMAT_HDR
CommentApplies 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.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: AUTOCODE
TableSTOCK_GROUPS
CommentThe One-off Stock Item autocode prefix for the group.
Primary keyNo
Data typeVARCHAR(10)
Domain name
Not NULLNo
Default
Refers to


Attribute: AUTOCODE
TableSTOCK_GROUP2S
CommentThe One-off Stock Item autocode prefix for the group.
Primary keyNo
Data typeVARCHAR(10)
Domain name
Not NULLNo
Default
Refers to


Attribute: AUTOCODENO
TableSTOCK_GROUP2S
CommentThe One-off Stock Item autocode suffix for the group.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: AUTOCODENO
TableSTOCK_GROUPS
CommentThe One-off Stock Item autocode suffix for the group.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: AUTO_NARRATIVE
TableSTOCK_ITEMS
CommentThe setting of the stock item's Auto Narrative property. Will be one of:
0=No
1=Yes with Blank
2=Yes with Notes
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: AVECOST
TableSTOCK_ITEMS
CommentThe stock item's Average Cost Price.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: BAD_LOGIN_COUNT
TableSTAFF
CommentThe number of times the staff member has attempted to log in but failed.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: BALANCE
TableGLACCS
CommentThe account's balance.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: BALANCE_SHEET_TYPE
TableGLACCS
CommentFor balance sheet accounts, this field indicates the balance sheet type. Will be one of:
-1 = Not a balance sheet account
0 = Asset
1 = Liability
2 = Equity
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: BALSHEETACCTOT
TableGLACCS
CommentThe balance sheet total for the account.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: BARCODE1
TableSTOCKTAKE_TOTALS
CommentBarcode/alternate code 1.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: BARCODE1
TableSTOCK_ITEMS
CommentBarcode/alternate code 1.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: BARCODE2
TableSTOCK_ITEMS
CommentBarcode/alternate code 2.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: BARCODE3
TableSTOCK_ITEMS
CommentBarcode/alternate code 3.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHCODE
TableCR_INVLINES
CommentThe batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHCODE
TableINWARDS_GOODS_LINES
CommentThe batch code on the line.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHCODE
TableDR_INVLINES
CommentThe batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHCODE
TableSTOCK_REQUESTLINES
CommentThe batch code on the line.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHCODE
TableSTOCKTAKE_TOTALS
CommentThe batchcode for the stock item.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHCODE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHCODE
TableSTOCK_TRANS
CommentThe batch number.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCHNO
TableINWARDS_GOODS_LINES
CommentThe batch number on the record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: BATCHQUANTITY
TableBILLOMAT_TEMP
CommentThe batch quantity on the record.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: BATCH_QTY
TableBILLOMAT_HDR
CommentThe BOM's Batch Quantity.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default1
Refers to


Attribute: BILLCODE
TableBILLOMAT_LINES
CommentThe ID code of the BOM header (BILLOMAT_HDR.BILLCODE).
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toBILLOMAT_HDR.BILLCODE


Attribute: BILLCODE
TableBILLOMAT_TEMP
CommentThe BOM code.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toBILLOMAT_HDR.BILLCODE


Attribute: BILLCODE
TableBILLOMAT_HDR
CommentThe BOM's unique ID code.
Primary keyYes
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers to


Attribute: BINCODE
TableSTOCK_ITEMS
CommentBincode for the stock item.
Primary keyNo
Data typeVARCHAR(12)
Domain name
Not NULLNo
Default
Refers to


Attribute: BINCODE
TableSTOCKTAKE_TOTALS
CommentThe Bin Code for the stock item being counted.
Primary keyNo
Data typeVARCHAR(12)
Domain name
Not NULLNo
Default
Refers to


Attribute: BINCODE
TableSTOCK_LOC_INFO
CommentThe stock item's bin or shelf code at the location.
Primary keyNo
Data typeVARCHAR(12)
Domain name
Not NULLNo
Default
Refers to


Attribute: BKORDQTY
TableDR_INVLINES
CommentBack Order Qty from the Sales Order.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: BOMBATCHSEQNO
TableBILLOMAT_TEMP
CommentThe BOM batch ID number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: BOMPRICING
TableCR_INVLINES
CommentHow Bills of Materials are priced. Will be one of:
C = Pricing by Component
T = Pricing by total
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BOMPRICING
TableSTOCK_REQUESTLINES
CommentHow Bills of Materials are priced. Will be one of:
C = Pricing by Component
T = Pricing by total
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BOMPRICING
TableINWARDS_GOODS_LINES
CommentC = BOM priced by Component, T = BOM priced by total, N = Normal
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BOMPRICING
TableDR_INVLINES
CommentHow Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BOMTYPE
TableBILLOMAT_HDR
CommentThe type of BOM. Will be one of:
K = Kit
B = Build
O = Order Template
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultK
Refers to


Attribute: BOMTYPE
TableSTOCK_REQUESTLINES
CommentThe type of Bill of Materials that the line relates to:
N = Normal stock item
B = Build
K = Kit
L = Lookup
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BOMTYPE
TableCR_INVLINES
CommentThe type of Bill of Materials that the line relates to:
N = Normal stock item
B = Build
K = Kit
L = Lookup
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BOMTYPE
TableDR_INVLINES
CommentThe type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BOMTYPE
TableINWARDS_GOODS_LINES
CommentThe Bill of Materials type on the line. Will be one of:
N = Normal
K = Kit
B = Build
L = Linked
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: BRANCHNO
TableSTOCK_GROUPS
CommentThe ID number of the group's branch (from BRANCHES).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toBRANCHES.BRANCHNO


Attribute: BRANCHNO
TableSTOCK_GROUP2S
CommentThe ID number of the group's branch (from BRANCHES).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toBRANCHES.BRANCHNO


Attribute: BRANCHNO
TableINWARDS_GOODS_LINES
CommentThe ID number of the branch on the record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toBRANCHES.BRANCHNO


Attribute: BRANCHNO
TableCR_INVLINES
CommentThe branch number. Lines generally inherit the branch specified on the invoice header.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: BRANCHNO
TableDR_INVLINES
CommentThe branch number. Lines generally inherit the branch specified on the invoice header.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: BRANCHNO
TableSTOCK_ITEMS
CommentBranch number for the stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: CALCREORD
TableSTOCKREQUIREMENT
CommentReorder quantity, calculated taking into account minimum stock, maximum stock and available free stock.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: CAN_SPREAD
TableINWARDS_GOODS_COSTS
Comment
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultY
Refers to


Attribute: CLASSNAME
TableSTOCK_CLASSIFICATIONS
CommentThe name of the classification.
Primary keyNo
Data typeVARCHAR(100)
Domain name
Not NULLYes
Default
Refers to


Attribute: CLASSNO
TableSTOCK_CLASSIFICATIONS
CommentA unique ID number for the classification.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: CODETYPE
TableDR_INVLINES
CommentThe type of code on the line. Will be one of: G - GL code S - Stock code
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultS
Refers to


Attribute: CODETYPE
TableCR_INVLINES
CommentThe type of code on the line. Will be one of:
G - GL code
S - Stock code
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: COGSMETHOD
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: COLOURCODE
TableSTOCK_COLOUR
CommentA user-defined ID code for the colour.
Primary keyNo
Data typeVARCHAR(5)
Domain name
Not NULLYes
Default
Refers to


Attribute: COLOURID
TableSTOCK_COLOUR
CommentA unique ID number for the colour.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: COLOURNAME
TableSTOCK_COLOUR
CommentA descriptive name for the colour.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: COMMENT
TableSTOCK_REQUESTLINES
CommentThe comment entered on the line, if any.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: COMPLETE
TableINWARDS_GOODS
CommentThis field contains 'Y' if the receipt has been completed.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: COMPLETE
TableINWARDS_GOODS_COSTS
CommentIndicates if the line has been marked as completed, which controls whether or not the line can be edited.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: COMPLETE
TableINWARDS_GOODS_LINES
CommentThis field contains 'Y' if the inwards goods receipt has been completed (and therefore cannot be altered).
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: COMPNO
TableSTOCK_SERIALNOS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: COMPONENTLOCATION
TableBILLOMAT_TEMP
CommentThe location of the BOM component stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: CONTRACT_HDR
TableDR_INVLINES
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: COST
TableINWARDS_GOODS_COSTS
CommentThe cost in local currency.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: COSTCODE
TableINWARDS_GOODS_COSTS
CommentThe on cost code for the record.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: COSTED_PERIOD_SEQNO
TableINWARDS_GOODS
CommentThe period to which the receipt belongs.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: COSTGROUP
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: COSTPRICE
TableBILLOMAT_HDR
CommentCost price for the BOM.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: COSTTYPE
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: COST_GROUP
TableINWARDS_GOODS_LINES
CommentIf the order originates from a job, this field records the ID number of the job's cost group.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toJOB_COSTGROUPS.SEQNO


Attribute: COST_GROUP
TableCR_INVLINES
CommentThis field only applies if EXO Job Costing is installed. It identifies the Cost Group that the transaction belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: COST_LINENO
TableDR_INVLINES
CommentThis field is the link used when allocating cost lines to DR_INVLINES.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: COST_TYPE
TableINWARDS_GOODS_LINES
CommentIf the order originates from a job, this field records the ID number of the job's cost type.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toJOB_COSTTYPES.SEQNO


Attribute: COST_TYPE
TableCR_INVLINES
CommentThis field only applies if EXO Job Costing is installed. It identifies the Cost Type that the transaction belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: COS_GLSUBCODE
TableSTOCK_ITEMS
CommentThe Cost of Sales sub-account updated in the General Ledger when the stock item is sold.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: COS_GLSUBCODE
TableSTOCK_GROUPS
CommentThe code of the GL subaccount for Cost of Sales.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: COS_GL_CODE
TableSTOCK_GROUPS
CommentThe code of the GL account for Cost of Sales.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toGLACCS.ACCNO


Attribute: COS_GL_CODE
TableSTOCK_ITEMS
CommentThe Cost of Sales account updated in the General Ledger when this stock item is sold.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toGLACCS.ACCNO


Attribute: COUNTQTY
TableSTOCKTAKE_TOTALS
CommentThe physical count taken for the item at this location.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: CREATED_DATE
TableGLACCS
CommentThe date and time that the GL account was created.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: CREDITQTY
TableDR_INVLINES
CommentContains the sum of quantities which have been a part of credit notes against the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: CRINVLINEID
TableCR_INVLINES
CommentA unique ID for the invoice line, which should be used to link to other tables. Every time an invoice is edited, the lines are essentially removed and reinserted again, which changes the SEQNO. However, the CRINVLINEID field retains its value. Hence, any relationships built on this field are still valid in such a scenario.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: CRINVLINESEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Creditors Invoice line that the item is linked to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: CRINVSEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Creditors Invoice that the item has been receipted in against.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: CR_ACCNO
TableSTOCK_SERIALNOS
CommentThe ID number of the related Creditor account.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: CUBIC
TableSTOCK_ITEMS
CommentCubic weight of the item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: CURRENCYNO
TableDR_INVLINES
CommentThe currency number for the line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toCURRENCIES.CURRENCYNO


Attribute: CURRENCYNO
TableGLACCS
CommentThe ID number of the currency that the GL account is in.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toCURRENCIES.CURRENCYNO


Attribute: CURRENCYNO
TableCR_INVLINES
CommentThe ID number of the currency used on the line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toCURRENCIES.CURRENCYNO


Attribute: CUSTOMFIELD
TableDR_INVLINES
Comment
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: CUSTOM_FILTER
TableSTOCKTAKE_CTRL
CommentThis field contains the custom SQL filter defined for the location, if there is one.
Primary keyNo
Data typeVARCHAR(100)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: CUSTORDERNO
TableSTOCK_REQUESTS
CommentThe customer order number, if there is one.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: DATAX_EXCHANGE_FLAG
TableSTOCK_GROUP2S
Comment
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultI
Refers to


Attribute: DATAX_EXCHNO
TableSTOCK_GROUP2S
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: DATAX_SITE_NO2
TableSTOCK_GROUP2S
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: DATAX_SOURCE_SITE
TableSTOCK_GROUP2S
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: DEFAULTWARRANTYNO
TableSTOCK_ITEMS
CommentThe default Warranty No for the stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: DEFDAYS
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: DELADDR1
TableSTOCK_LOCATIONS
CommentLine 1 of the location's address.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: DELADDR2
TableSTOCK_LOCATIONS
CommentLine 2 of the location's address.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: DELADDR3
TableSTOCK_LOCATIONS
CommentLine 3 of the location's address.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: DELADDR4
TableSTOCK_LOCATIONS
CommentLine 4 of the location's address.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: DELADDR5
TableSTOCK_LOCATIONS
CommentLine 5 of the location's address.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: DELADDR6
TableSTOCK_LOCATIONS
CommentLine 6 of the location's address.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableCR_INVLINES
CommentDescription of the Stock item on this line.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableINWARDS_GOODS_LINES
CommentThe description of the stock item on the line.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableDR_INVLINES
CommentDescription of the Stock item on this line.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableSTOCKTAKE_TOTALS
CommentThe description of the stock item being counted.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableBILLOMAT_HDR
CommentA descriptive name for the BOM.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableSTOCKREQUIREMENT
CommentThe stock item's description.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableSTOCK_ITEMS
CommentThe stock item's description.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableSUPPLIER_STOCK_ITEMS
CommentThe supplier's description for the stock item.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DESCRIPTION
TableSTOCK_REQUESTLINES
CommentThe description of the stock item on the line.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLYes
Default
Refers toSTOCK_ITEMS.DESCRIPTION


Attribute: DESCRIPTION
TableBILLOMAT_LINES
CommentThe description of the stock item on this line.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DETAILS
TableINWARDS_GOODS_COSTS
CommentDetails of the on cost.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: DIMENSIONS
TableSTOCK_ITEMS
CommentHow the dimensions of the stock item are specified. Will be one of:
0=None
1=Length
2=Square
3=Cubic
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: DISCOUNT
TableSUPPLIER_STOCK_ITEMS
CommentThe percentage discount when purchasing the stock item from the supplier.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: DISCOUNT
TableCR_INVLINES
CommentThe percentage discount for the Stock item on this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: DISCOUNT
TableDR_INVLINES
CommentThe percentage discount for the Stock item on this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: DISCOUNT
TableINWARDS_GOODS_LINES
CommentThe discount percentage on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: DISCOUNTAMT
TableCR_INVLINES
CommentThe discount amount on a stock line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: DISCOUNTLEVEL
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: DISCOUNTPCT
TableCR_INVLINES
CommentThe discount percentage on a stock line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: DISCOUNTRATE
TableSTAFF
CommentThe staff member's Discount Rate Limit.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: DISPLAY_NAME
TableSTOCK_REQUESTTYPES
CommentThe name of the request type.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLYes
Default
Refers to


Attribute: DRCR
TableGLACCS
CommentThis field is set to 'C' for Credit accounts or 'D' for Debit accounts.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultD
Refers to


Attribute: DRINVLINEID
TableDR_INVLINES
CommentA 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.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: DRINVLINESEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Debtors Invoice line that the item is linked to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: DR_ACCNO
TableSTOCK_SERIALNOS
CommentThe ID number of the related Debtor account.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: DUTY
TableSTOCK_ITEMS
CommentThe duty percentage on the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: DUTYCOST
TableINWARDS_GOODS_LINES
CommentThe duty cost on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ECONORDERQTY
TableSUPPLIER_STOCK_ITEMS
CommentThe Minimum Order Quantity for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: ECONORDERQTY
TableSTOCK_ITEMS
CommentThe economic order quantity (EOQ) for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: EMAIL_ADDRESS
TableSTAFF
CommentThe staff member's email address.
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: EMPLOYEE_CODE
TableSTAFF
CommentThis field is used by the payroll integration functionality.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: EXCHRATE
TableDR_INVLINES
CommentThe exchange rate for the line at the time of the transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default1
Refers to


Attribute: EXCHRATE
TableINWARDS_GOODS_COSTS
CommentThe exchange rate.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: EXCHRATE
TableCR_INVLINES
CommentThe exchange rate for the line at the time of the transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default1
Refers to


Attribute: EXCHRATE
TableINWARDS_GOODS_LINES
CommentThe exchange rate on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: EXCLUDE_FROMFREE_STOCK
TableSTOCK_LOCATIONS
CommentThis field contains 'Y' if the location's "Exclude from Free Stock" option is ticked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: EXCLUDE_FROMSALES
TableSTOCK_LOCATIONS
CommentThis field contains 'Y' if the location's "Exclude from Sales" option is ticked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: EXCLUDE_FROMVALUATION
TableSTOCK_LOCATIONS
CommentThis field contains 'Y' if the location's "Exclude from Valuation" option is ticked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: EXCLUDE_FROM_REVAL
TableGLACCS
CommentIf this field is set to 'Y', the account is excluded from revaluation.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: EXPECTEDPROFIT
TableSTOCK_GROUPS
CommentThe expected profit margin for the group.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: EXPIRY_DATE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: EXPIRY_DATE
TableINWARDS_GOODS_LINES
CommentThe expiry date of the stock item, if there is one.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: EXPIRY_DATE
TableSTOCKTAKE_TOTALS
CommentThe date when the stock item batch expires.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: EXPIRY_DATE
TableSTOCK_TRANS
CommentThe Expiry Date for a batch tracked item.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: EXPIRY_DATE
TableSTOCK_SERIALNOS
CommentThe expiry date on the record.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLYes
Defaultgetdate()
Refers to


Attribute: EXPIRY_DAYS
TableSTOCKTAKE_TOTALS
CommentThe number of days until the stock item batch expires.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default1
Refers toSTOCK_ITEMS.EXPIRY_DAYS


Attribute: EXPIRY_DAYS
TableSTOCK_ITEMS
CommentNumber of days before expiry of the stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default1
Refers to


Attribute: EXTENSION
TableSTAFF
CommentThe staff member's telephone extension.
Primary keyNo
Data typeVARCHAR(12)
Domain name
Not NULLNo
Default
Refers to


Attribute: FACEBOOK_ACCESS_TOKEN
TableSTAFF
CommentIf the staff member uses their own Facebook account when using the EXO Business social media functions, their encrypted access token is stored here.
Primary keyNo
Data typeVARCHAR(max)
Domain name
Not NULLNo
Default
Refers to


Attribute: FC_COST
TableINWARDS_GOODS_COSTS
CommentThe cost in the currency of the supplier account.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: FILENAME
TableSTOCK_GROUPS
CommentThis field contains the filename of the website picture for the group.
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: FILENAME
TableSTOCK_GROUP2S
CommentThis field contains the filename of the website picture for the group.
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: FIXEDCOST
TableINWARDS_GOODS_LINES
CommentThe fixed cost on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: FREIGHT_FREE
TableDR_INVLINES
Comment'Y' or 'N' depending on whether the line is freight free. This comes from the price policy for the line.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: FROM_HDR
TableSTOCK_TRANS
CommentFor 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.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: FROM_HDR
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: FROM_LEDGER
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: FROM_LEDGER
TableSTOCK_TRANS
Commentd = Debtor
c = Creditor
s = Stock
j = Job Costing
i = Inwards Goods Receipt
o = Sales Orders
p = Purchase Orders
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: FROM_LOC
TableSTOCK_REQUESTS
CommentThe ID number of the location that stock is to be transferred from.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: FXCOST
TableINWARDS_GOODS_LINES
CommentThe cost on the line in local currency.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: FX_VAR
TableINWARDS_GOODS_LINES
CommentThe foreign exchange variance applicable to the line at the time of invoicing.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: FX_VAR
TableINWARDS_GOODS_COSTS
CommentThe foreign exchange variance applicable to the invoice raised against this record.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: GLACC
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: GLACC
TableSTOCK_TRANS
CommentThe General Ledger Account that is affected when the transaction is posted to GL.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toGLACCS.ACCNO


Attribute: GLACCNO
TableCR_INVLINES
CommentGL account number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: GLBATCH
TableINWARDS_GOODS_COSTS
CommentGL batch number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: GLBATCHNO
TableINWARDS_GOODS
CommentThe GL batch number on the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: GLBATCHNO
TableSTOCK_TRANS
CommentID number of the GL Batch that the posted stock journal belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: GLBATCHNO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: GLBRANCH
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: GLBRANCH
TableSTOCK_TRANS
CommentThe Branch used for posting to the General Ledger.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: GLPOSTED
TableINWARDS_GOODS_COSTS
CommentThis field contains 'Y' if a GL journal exists for the record.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: GLPOSTED
TableSTOCK_TRANS
CommentThis field contains 'Y' if the transaction has been posted to the General Ledger.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: GLPOSTED
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: GLSUBACC
TableSTOCK_TRANS
CommentThe General Ledger Sub Account that is affected when the transaction is posted to GL.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: GLSUBACC
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: GLSUBACC
TableCR_INVLINES
CommentSL sub-account number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: GROUP2_SEQNO
TableSTOCK_GROUPS
CommentThe ID number of the related Alternate Stock Group.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_GROUP2S.GROUPNO


Attribute: GROUPNAME
TableSTOCK_GROUP2S
CommentThe group's name/description.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: GROUPNAME
TableSTOCK_PRICEGROUPS
CommentThe Price Group's name.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: GROUPNAME
TableSTOCK_GROUPS
CommentThe group's name/description.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: GROUPNO
TableSTOCK_PRICEGROUPS
CommentA unique ID number for the Price Group.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: GROUPNO
TableSTOCK_GROUPS
CommentA unique ID code for the group.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: GROUPNO
TableSTOCK_GROUP2S
CommentA unique ID number for the group.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: HAS_BN
TableSTOCK_ITEMS
CommentThis field is set to 'Y' if the stock item is batch tracked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: HAS_BN
TableSTOCKTAKE_TOTALS
CommentThis field is set to 'Y' if the stock item is batch tracked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers toSTOCK_ITEMS.HAS_BN


Attribute: HAS_BUDGETS
TableSTAFF
CommentThis field is set to 'Y' if the staff member has been assigned a Sales Team Budget, i.e. if their Has Budget flag is ticked in EXO Business Configurator.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: HAS_EXPIRY
TableSTOCKTAKE_TOTALS
CommentThis field is set to 'Y' if the stock item has an expiry date.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers toSTOCK_ITEMS.HAS_EXPIRY


Attribute: HAS_EXPIRY
TableSTOCK_ITEMS
CommentThis field is set to 'Y' if the stock item has an expiry date. This flag is only available in the UI if the "Use expiry dates for batched & serial numbers" profile setting is enabled.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: HAS_SN
TableSTOCK_ITEMS
CommentThis field is set to 'Y' if the stock item is serial number tracked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: HDR_SEQNO
TableCR_INVLINES
CommentThe SEQNO of the record in the CR_TRANS table that this record related to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toCR_TRANS.SEQNO


Attribute: HDR_SEQNO
TableSTOCK_REQUESTLINES
CommentThe ID number of the stock transfer request that the line belongs to (from STOCK_REQUESTS).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toSTOCK_REQUESTS.SEQNO


Attribute: HDR_SEQNO
TableDR_INVLINES
CommentThe SEQNO of the record in the DR_TRANS table that this record related to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toDR_TRANS.SEQNO


Attribute: HDR_SEQNO
TableINWARDS_GOODS_LINES
CommentThe ID number of the header Inwards Goods record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toINWARDS_GOODS.SEQNO


Attribute: HIDDEN
TableDR_INVLINES
Comment
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: HIDDEN_COST
TableDR_INVLINES
CommentThis 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.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: HIDDEN_SELL
TableDR_INVLINES
CommentThis 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.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: HIDE_LINES
TableBILLOMAT_HDR
CommentThis field is set to 'Y' if the BOM's "Hide lines on reports" option is ticked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: HOMEPHONE
TableSTAFF
CommentThe staff member's home telephone number.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: IGRLINESEQNO
TableCR_INVLINES
CommentID number of the Inwards Goods receipt line (if the source of the line is from Inwards Goods).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: IGRLINESEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Inwards Goods line that the item is linked to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: IGRSEQNO
TableSTOCK_SERIALNOS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INC_FIFO_STOCKTAKE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: INC_FIFO_STOCKTAKE
TableSTOCK_TRANS
CommentNot supported.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: INSTOCK
TableSTOCK_SERIALNOS
CommentThis field contains 'Y' if the serial number is in stock.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultY
Refers to


Attribute: INSTOCKQTY
TableSTOCKREQUIREMENT
CommentPhysical stock.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTERCO_BATCH_DESC
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the batch description.
Primary keyNo
Data typeVARCHAR(80)
Domain name
Not NULLNo
Default
Refers to


Attribute: INTERCO_COMPANYNO
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the Company ID number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTERCO_CR_ACCNO
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the Creditor GL account number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTERCO_CR_BRANCHNO
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the Creditor branch number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTERCO_CR_SUBACCNO
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the Creditor GL sub-account number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTERCO_DR_ACCNO
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the Debtor GL account number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTERCO_DR_BRANCHNO
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the Debtor branch number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTERCO_DR_SUBACCNO
TableCR_INVLINES
CommentThis field only applies if EXO InterCompany is used. It contains the Debtor GL sub-account number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: INTRANS_QUANT
TableSTOCK_REQUESTLINES
CommentThe In Transit Qty on the line.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: INVNO
TableDR_INVLINES
CommentThe invoice number.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: INVNO
TableCR_INVLINES
CommentThe invoice number.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: INVOICED
TableINWARDS_GOODS
CommentThis field contains 'Y' if the receipt has been invoiced.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: INVOICE_NOW
TableINWARDS_GOODS_COSTS
Comment
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INVSEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Debtors Invoice ID the item has been sold against.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: INV_AGE
TableINWARDS_GOODS_LINES
CommentThe invoice's age. This is calculated based on PERIOD_SEQNO.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: INV_COMPLETE
TableINWARDS_GOODS_LINES
CommentThis field contains 'Y' if the invoice is complete.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: INV_COST
TableINWARDS_GOODS_COSTS
CommentThe invoiced amount in local currency.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INV_COST
TableINWARDS_GOODS_LINES
CommentThe cost as on the related invoice, in local currency.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INV_EXCHRATE
TableINWARDS_GOODS_LINES
CommentThe exchange rate applicable to the invoice line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INV_EXCHRATE
TableINWARDS_GOODS_COSTS
CommentThe exchange rate applicable to the invoice.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INV_FC_COST
TableINWARDS_GOODS_LINES
CommentThe cost as on the related invoice.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INV_FC_COST
TableINWARDS_GOODS_COSTS
CommentThe invoiced amount in the currency of the supplier account.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: INV_QUANT
TableINWARDS_GOODS_LINES
CommentThe invoiced quantity on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: INV_TRANSDATE
TableINWARDS_GOODS_LINES
CommentThe transaction date of the invoice related to this line.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: INWARDS_GOODS_SEQNO
TableINWARDS_GOODS_COSTS
CommentThe ID number of the Inwards Goods header record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toINWARDS_GOODS.SEQNO


Attribute: INWGLID
TableINWARDS_GOODS_LINES
CommentAn ID number for the inwards goods lines record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: ISACTIVE
TableSTOCK_COLOUR
CommentThis field contains 'Y' if the colour is currently active.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ISACTIVE
TableSTOCK_GROUPS
CommentThis field contains 'Y' if the group is currently active.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ISACTIVE
TableSTOCKTAKE_CTRL
CommentThis field contains 'Y' is the location is currently active.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: ISACTIVE
TableSTOCK_ITEMS
CommentIf this field is set to 'Y', the stock item is active.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ISACTIVE
TableSTOCK_SIZE
CommentThis field contains 'Y' if the size is currently active.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ISACTIVE
TableGLACCS
CommentThis field contains 'Y' if the GL account is active.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ISACTIVE
TableSTOCK_LOCATIONS
CommentThis field contains 'Y' if the location is active.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ISACTIVE
TableBILLOMAT_HDR
CommentThis field contains 'Y' if the BOM is active; otherwise it is inactive.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: ISACTIVE
TableSTAFF
CommentThis field is set to 'Y' if the staff member is currently active, i.e. if their Active flag is ticked in EXO Business Configurator.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: ISASSIGNED
TableSTOCK_SERIALNOS
CommentN = 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
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: IS_DEFAULT
TableSUPPLIER_STOCK_ITEMS
Comment
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: IS_DISCOUNTABLE
TableSTOCK_ITEMS
CommentThis field is set to 'Y' if the stock item is discountable.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultY
Refers to


Attribute: IS_SUPERVISOR
TableSTAFF
CommentThis field is set to 'Y' if the staff member is designated as a supervisor, i.e. if their Has supervisory override authority flag is ticked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: IS_WIPLOCATION
TableSTOCK_LOCATIONS
CommentThis field contains 'Y' if the location represents Work in Progress in EXO Job Costing.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: JOBCODE
TableCR_INVLINES
CommentIf the line originates from a job, the job's code is recorded in this field.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: JOBCODE
TableDR_INVLINES
CommentIf the line originates from a job, the job's code is recorded in this field.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: JOBLINESEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the job line that the item is linked to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: JOBNO
TableSTOCK_SERIALNOS
CommentThe ID number of the job that the serial number belongs to (if there is one).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: JOBNO
TableCR_INVLINES
CommentIf the line originates from a job, the job's ID number is recorded in this field.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: JOBNO
TableSTOCK_TRANS
CommentJob Number if the stock movement sources from a job.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: JOBNO
TableDR_INVLINES
CommentIf the line originates from a job, the job's ID number is recorded in this field.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: JOBNO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: JOBNO
TableINWARDS_GOODS_LINES
CommentIf the order originates from a job, this field records the ID number of the job.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toJOBCOST_HDR.JOBNO


Attribute: JOBTITLE
TableSTAFF
CommentThe staff member's job title.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: JOB_CONTRACT_BILLINGS_SEQNO
TableDR_INVLINES
CommentIf 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).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: KITCODE
TableINWARDS_GOODS_LINES
CommentThe ID code of the Bill of Materials on the line.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: KITCODE
TableSTOCK_TRANS
CommentCode of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: KITCODE
TableSTOCK_SERIALNOS
Comment
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: KITCODE
TableDR_INVLINES
CommentThe Bill of Materials code, if the line is part of a BOM.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: KITCODE
TableCR_INVLINES
CommentThe Bill of Materials code, if the line is part of a BOM.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: KITCODE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: KITID_SERIAL
TableSTOCK_SERIALNOS
Comment
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: KITSEQNO
TableBILLOMAT_TEMP
CommentThe ID number of the BOM.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: KITSEQNO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: KITSEQNO
TableCR_INVLINES
CommentA Bill of Materials SEQNO used to group BOM lines together.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: KITSEQNO
TableINWARDS_GOODS_LINES
CommentThe ID number of the Bill of Materials on the line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: KITSEQNO
TableSTOCK_TRANS
CommentID number of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: KITSEQNO
TableDR_INVLINES
CommentA Bill of Materials SEQNO used to group BOM lines together.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: KIT_TYPE
TableBILLOMAT_HDR
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: LABEL_QTY
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default1
Refers to


Attribute: LASTINVSEQNO
TableINWARDS_GOODS
CommentThe ID number of the last invoice generated against the receipt.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: LASTMONTHUNITS
TableSTOCK_ITEMS
CommentUnits of stock item sold in the previous month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LASTMONTHVALUE
TableSTOCK_ITEMS
CommentSales value for the previous month for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LASTUPDATED
TableSTOCK_SERIALNOS
CommentThe date and time when the record was last updated.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLYes
Defaultgetdate()
Refers to


Attribute: LASTYEARUNITS
TableSTOCK_ITEMS
CommentUnits of stock item sold in for the previous year.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LASTYEARVALUE
TableSTOCK_ITEMS
CommentSales value for last year.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LAST_BAD_LOGIN
TableSTAFF
CommentThe date and time when the staff member last attempted to log in but failed.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: LAST_LOGIN
TableSTAFF
CommentThe date and time when the staff member last successfully logged in.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: LAST_UPDATE
TableSUPPLIER_STOCK_ITEMS
CommentThe date when the record was last updated (not set automatically - it must be specified on the Alternate Suppliers / Stock Codes window).
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: LAST_UPDATED
TableGLACCS
CommentThe date and time when the GL account was last updated.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: LAST_UPDATED
TableSTOCK_ITEMS
CommentDate and time when the stock item record was last updated.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: LATESTCOST
TableSUPPLIER_STOCK_ITEMS
CommentThe supplier's latest cost for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LATESTCOST
TableSTOCK_ITEMS
CommentThe stock item's Last Cost Price.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LCODE
TableSTOCK_LOCATIONS
CommentA short alphanumeric ID code for the location.
Primary keyNo
Data typeVARCHAR(8)
Domain name
Not NULLNo
Default
Refers to


Attribute: LCOST
TableINWARDS_GOODS_LINES
CommentThe landed cost on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: LINETAX_OVERRIDDEN
TableDR_INVLINES
CommentContains 'Y' if the tax on the line has been manually modified.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINETAX_OVERRIDDEN
TableCR_INVLINES
CommentContains 'Y' if the tax on the line has been manually modified.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINETOTAL
TableDR_INVLINES
CommentA computed field containing the total value for the line, excluding tax.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: LINETOTAL
TableCR_INVLINES
CommentA computed field containing the total value for the line, excluding tax.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: LINETOTAL_INCTAX
TableCR_INVLINES
CommentA computed field containing the total value for the line, including tax.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: LINETOTAL_INCTAX
TableDR_INVLINES
CommentA computed field containing the total value for the line, including tax.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: LINETOTAL_TAX
TableDR_INVLINES
CommentThe tax total for the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LINETOTAL_TAX
TableCR_INVLINES
CommentThe tax total for the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LINETYPE
TableINWARDS_GOODS_LINES
CommentThe line type. Will be one of:
0 = Normal line
1 = BOM header
2 = BOM component
4 = Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: LINETYPE
TableCR_INVLINES
CommentThis field indicates the type of line. Will be one of:
0 = Normal stock line
1 = BOM header line
2 = BOM component line
4 = Narrative line
5 = GL code
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: LINETYPE
TableDR_INVLINES
CommentThis field indicates the type of line. Will be one of:
0 = Normal stockline
1 = BOM header line
2 = BOM component line
4 = Narrative line
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: LINETYPE
TableSTOCK_REQUESTLINES
CommentThis 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
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: LINE_SEQNO
TableSTOCK_TRANS
CommentFor manual stock movements this field is NULL. For movements originating from other ledgers, this contains the Line ID of the source line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: LINE_SEQNO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: LINE_SOURCE
TableDR_INVLINES
CommentThe source SEQNO of the line, if it originated from a Sales Order or job.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: LINE_SOURCE
TableCR_INVLINES
CommentThe source SEQNO of the line, if it originated from a Sales Order or job.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKEDIN_TOKEN_KEY
TableSTAFF
CommentIf the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token key is stored here.
Primary keyNo
Data typeVARCHAR(max)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKEDIN_TOKEN_SECRET
TableSTAFF
CommentIf the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token secret is stored here.
Primary keyNo
Data typeVARCHAR(max)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKEDSTATUS
TableINWARDS_GOODS_LINES
CommentS = Stock item, L = Lookup item.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: LINKEDSTATUS
TableSTOCK_REQUESTLINES
CommentWill be one of:
S = Stocked
L = Lookup
N = Not applicable
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: LINKEDSTATUS
TableDR_INVLINES
CommentWill be one of: S = Stocked L = Lookup N = Not applicable
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: LINKEDSTATUS
TableCR_INVLINES
CommentWill be one of:
S = Stocked
L = Lookup
N = Not applicable
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: LINKED_BILLCODE
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKED_QTY
TableCR_INVLINES
CommentThe physical stock unit quantity.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LINKED_QTY
TableSTOCK_REQUESTLINES
CommentThe physical stock unit quantity.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKED_QTY
TableINWARDS_GOODS_LINES
CommentThe linked quantity on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LINKED_QTY
TableDR_INVLINES
CommentThe physical stock unit quantity.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKED_STOCKCODE
TableSTOCK_REQUESTLINES
CommentThe physical stock unit.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKED_STOCKCODE
TableINWARDS_GOODS_LINES
CommentThe linked stock item code on the line.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKED_STOCKCODE
TableDR_INVLINES
CommentThe physical stock unit.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: LINKED_STOCKCODE
TableCR_INVLINES
CommentThe physical stock unit.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: LISTPRICE
TableDR_INVLINES
CommentThe original unit price for the Stock item on this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: LNAME
TableSTOCK_LOCATIONS
CommentA descriptive name for the location.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: LOCATION
TableCR_INVLINES
CommentThe location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default1
Refers to


Attribute: LOCATION
TableSTOCKTAKE_TOTALS
CommentThe ID number of the location where the stock was counted.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOCATION
TableSTOCK_TRANS
CommentID number of the Location involved in the stock movement.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default1
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOCATION
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: LOCATION
TableDR_INVLINES
CommentThe location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default1
Refers to


Attribute: LOCATION
TableSTOCK_LOC_INFO
CommentThe ID number of the location.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOCNAME
TableSTOCKTAKE_CTRL
CommentThe name of the stock location.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: LOCNO
TableSTOCKTAKE_CTRL
CommentThe ID number of the stock location.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOCNO
TableSTOCK_LOCATIONS
CommentA unique ID number for the location.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: LOCNO
TableINWARDS_GOODS_LINES
CommentThe ID of the location on the record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOCNO
TableINWARDS_GOODS
CommentThe ID number of the location on the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOCNO
TableSTOCK_SERIALNOS
CommentThe location of the serialised stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOCNO
TableSTOCKREQUIREMENT
CommentThe ID number of the stock item's location (from STOCK_LOCATIONS).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: LOGINID
TableSTAFF
CommentThe staff member's login ID. This is the ID used to log in to the EXO Business system.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLYes
Default
Refers to


Attribute: LOOKUP_RECOVERABLE
TableSTOCK_ITEMS
CommentIf this field contains 'Y', the stock item is a recoverable expense in EXO Job Costing.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: LOOKUP_RECOVERABLE
TableSTOCK_TRANS
CommentThis field contains 'Y' if lookup items are recoverable against expenses in EXO Job Costing.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: LOST_QUANT
TableSTOCK_REQUESTLINES
Comment
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MAXSTOCK
TableSTOCK_LOC_INFO
CommentThe maximum stock quantity for the stock code at the location.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MAXSTOCK
TableSTOCKREQUIREMENT
CommentThe maximum stock level for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MAXSTOCK
TableSTOCK_ITEMS
CommentThe maximum default stock level for each location.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MENU_NO
TableSTAFF
CommentThe ID number of the Menu Definition specified for the staff member. Corresponds to the menu's SEQNO field in the MENU_COLLECTION table.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toMENU_COLLECTION.SEQNO


Attribute: MINSTOCK
TableSTOCK_LOC_INFO
CommentThe minimum stock quantity for the stock code at the location.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MINSTOCK
TableSTOCK_ITEMS
CommentThe minimum default stock level for each location.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MINSTOCK
TableSTOCKREQUIREMENT
CommentThe minimum stock level for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MOBILE_ACCESS
TableSTAFF
CommentThis field contains 'Y' if the staff member is authorised to use the EXO OnTheGo mobile app.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: MONTHUNITS
TableSTOCK_ITEMS
CommentSales totals in terms of quantity for the current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: MONTHVALUE
TableSTOCK_ITEMS
CommentSales value for the current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: NAME
TableGLACCS
CommentThe account name.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: NAME
TableSTAFF
CommentThe staff member's full name.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: NARRATIVE_SEQNO
TableSTOCK_TRANS_HDR
CommentID of the narrative on the transaction (entered via manual stock movement).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: NARRATIVE_SEQNO
TableCR_INVLINES
CommentThe SEQNO for the narrative on this line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toNARRATIVES.SEQNO


Attribute: NARRATIVE_SEQNO
TableDR_INVLINES
CommentThe SEQNO for the narrative on this line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: NARRATIVE_SEQNO
TableSTOCK_REQUESTS
CommentThe ID number for the narrative on this request.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toNARRATIVES.SEQNO


Attribute: NARRATIVE_SEQNO
TableSTOCK_REQUESTLINES
CommentThe ID number for the narrative on this line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toNARRATIVES.SEQNO


Attribute: NEW_AVECOST
TableSTOCK_TRANS
CommentAverage cost of the item after this transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: NEW_LOC_QTY
TableSTOCK_TRANS
CommentQuantity of the item in the location the movement took place after this transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: NEW_QUANTITY
TableSTOCK_TRANS
CommentStock on hand of the item after this transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: NEW_SEQORDER
TableSTOCK_TRANS
CommentNew sequence order of the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: NICKNAME
TableSTAFF
CommentA short nickname for the employee.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: NON_STOCK_AUTH_AMT
TableSTAFF
CommentThe staff member's Non-Stock Purchase Order Authorisation Limit.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: NOTES
TableINWARDS_GOODS
CommentAny receipt notes on the transaction.
Primary keyNo
Data typeVARCHAR(500)
Domain name
Not NULLNo
Default
Refers to


Attribute: NOTES
TableBILLOMAT_HDR
CommentAny notes recorded for the BOM.
Primary keyNo
Data typeVARCHAR(2048)
Domain name
Not NULLNo
Default
Refers to


Attribute: NOTES
TableSTOCK_ITEMS
CommentAny notes for the stock item.
Primary keyNo
Data typeVARCHAR(4096)
Domain name
Not NULLNo
Default
Refers to


Attribute: NOTES
TableGLACCS
CommentAny notes on the GL account.
Primary keyNo
Data typeVARCHAR(4096)
Domain name
Not NULLNo
Default
Refers to


Attribute: NUMDECIMALS
TableSTOCK_ITEMS
CommentThe number of decimal places that can be entered for the stock item's quantity.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: NUM_CARTONS
TableINWARDS_GOODS
CommentThe number of cartons.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: NUNITPR
TableDR_INVLINES
CommentA computed field containing the unit price, taking into account the discount on the line.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: ON_COSTS
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: ON_COSTS
TableSTOCK_TRANS
CommentOn costs (only applicable to lines sourcing from inwards goods receipts).
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: OPENINGBAL
TableGLACCS
CommentThe account's opening balance.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ORDERQTY
TableDR_INVLINES
CommentThe Order Qty from the Sales Order.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: ORIG_SEQNO
TableSTOCK_REQUESTS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: OUTPUT_CODE
TableBILLOMAT_HDR
CommentStock code of the BOM's output item.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: PACK
TableSTOCK_ITEMS
CommentDescribes the unit of sale for pricing, e.g. EACH or PACK.
Primary keyNo
Data typeVARCHAR(10)
Domain name
Not NULLNo
Default
Refers to


Attribute: PACKREFERENCE
TableSUPPLIER_STOCK_ITEMS
CommentAn optional reference code for the pack.
Primary keyNo
Data typeVARCHAR(20)
Domain name
Not NULLNo
Default
Refers to


Attribute: PACKSLIP
TableINWARDS_GOODS
CommentThe packing slip reference.
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: PACK_SIZE
TableSTOCK_REQUESTLINES
CommentThe pack size of the stock item on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: PASSWORD_CHANGED
TableSTAFF
CommentThe date and time when the staff member's password was last changed.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLYes
Defaultgetdate()
Refers to


Attribute: PAYROLL_ID
TableSTAFF
CommentThe staff member's Employee ID (Payroll) number. This field is used when EXO Business is integrating with an external payroll system, e.g. MYOB EXO Payroll. It must contain the employee's corresponding ID number in the payroll system.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: PERIOD_SEQNO
TableSTOCK_TRANS_HDR
CommentID number of the period that the record belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: PERIOD_SEQNO
TableSTOCK_TRANS
CommentID number of the period the transaction belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toPERIOD_STATUS.SEQNO


Attribute: PERIOD_SEQNO
TableINWARDS_GOODS_COSTS
CommentThe period ID of the invoice linked to this record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toPERIOD_STATUS.SEQNO


Attribute: PERIOD_SEQNO
TableINWARDS_GOODS_LINES
CommentThe ID number of the period on the invoice linked to this record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toPERIOD_STATUS.SEQNO


Attribute: PERIOD_TRADED_IN_SEQ
TableSTOCK_TRANS
CommentThis field contains 'N' if the transaction was in a prior period.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: PHONE
TableSTAFF
CommentThe staff member's work telephone number.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: PICTURE_URL
TableSTOCK_WEB
CommentThe URL of the picture to be displayed for the stock item.
Primary keyNo
Data typeVARCHAR(80)
Domain name
Not NULLNo
Default
Refers to


Attribute: PLU
TableSTOCK_TRANS
CommentPrice Lookup Unit (applies to lookup items).
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: PLU
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: POSTTIME
TableSTOCK_TRANS
CommentA timestamp of when the record was entered.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: POSTTIME
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: POST_LOOKUP_TO_GL
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: POST_LOOKUP_TO_GL
TableSTOCK_TRANS
CommentIf this field contains 'N' and the stock item is a lookup item, there is no journal against the transaction.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: POST_TO_GL
TableSTOCK_TRANS
CommentIf this field is set to 'Y', the stock line is posted to GL; otherwise it is not.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: POST_TO_GL
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: PO_INVLINESEQNO
TableSTOCK_SERIALNOS
CommentThe invoice line ID linked to the Purchase Order for the serial number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: PO_INVSEQNO
TableSTOCK_SERIALNOS
CommentThe invoice ID linked to the Purchase Order for the serial number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: PO_LINE_NUM
TableINWARDS_GOODS_LINES
CommentThe ID number of the related Purchase Order line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toPURCHORD_LINES.SEQNO


Attribute: PO_NUMBER
TableINWARDS_GOODS_LINES
CommentThe ID number of the related Purchase Order header.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toPURCHORD_HDR.SEQNO


Attribute: PQTY
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default1
Refers to


Attribute: PREV_AVECOST
TableSTOCK_TRANS
CommentAverage cost of the stock item before this transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: PREV_AVECOST
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: PREV_QUANTITY
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: PREV_QUANTITY
TableSTOCK_TRANS
CommentQuantity of the stock item before the transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: PRICEPERKG
TableSTOCK_ITEMS
CommentThe stock item's sell price per kg.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: PRICEQTY
TableSTOCK_ITEMS
CommentThe stock item's sell price per quantity.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: PRICE_OVERRIDDEN
TableDR_INVLINES
CommentContains 'Y' if the price on the line has been manually modified.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: PRICING_MODE
TableBILLOMAT_HDR
CommentHow the output item is priced. 0 = Priced by total. 1 = Priced by components.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: PRIVATE_ACC
TableGLACCS
CommentThis field is set to 'Y' if the GL account is a private account.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: PRODUCTLOCATION
TableBILLOMAT_TEMP
CommentThe location of the BOM product stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: PROFITVARIANCE
TableSTOCK_GROUPS
CommentThe expected margin variance for the group.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: PURCHORDLINESEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Purchase Order line that the item is linked to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: PURCHORDNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Purchase Order that the item has been receipted in against.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: PURCHORDQTY
TableSTOCKREQUIREMENT
CommentIncoming stock.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: PURCHPACKPRICE
TableINWARDS_GOODS_LINES
CommentThe purchase pack price on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: PURCHPACKPRICE
TableSUPPLIER_STOCK_ITEMS
CommentThe Pack Cost when purchasing the stock item from the supplier.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: PURCHPACKQUANT
TableSUPPLIER_STOCK_ITEMS
CommentThe Qty per Pack when purchasing the stock item from the supplier.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default1
Refers to


Attribute: PURCHPACKQUANT
TableINWARDS_GOODS_LINES
CommentThe purchase pack quantity on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default1
Refers to


Attribute: PURCHTAXRATE
TableSTOCK_ITEMS
CommentDefault GST rate for purchase transactions.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: PURCH_GLSUBCODE
TableSTOCK_ITEMS
CommentThe default GL sub-account code that purchase transactions for this stock item are posted to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: PURCH_GLSUBCODE
TableSTOCK_GROUPS
CommentThe code of the GL subaccount for Purchases Clearing.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: PURCH_GL_CODE
TableSTOCK_ITEMS
CommentThe GL code that purchase transactions for this stock are posted to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toGLACCS.ACCNO


Attribute: PURCH_GL_CODE
TableSTOCK_GROUPS
CommentThe code of the GL account for Purchases Clearing.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toGLACCS.ACCNO


Attribute: QTY
TableSTOCK_LOC_INFO
CommentThe current stock quantity for the stock code at the location.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: QTY_TRADED_IN_NEG
TableSTOCK_TRANS
CommentQuantity traded when total stock on hand for the item was in negative at the time of the transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: QUANTITY
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: QUANTITY
TableDR_INVLINES
CommentThe quantity for this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: QUANTITY
TableINWARDS_GOODS_LINES
CommentThe receipt quantity on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: QUANTITY
TableSTOCK_TRANS
CommentQuantity of stock.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: QUANTITY
TableCR_INVLINES
CommentThe quantity for this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: QUANTITY
TableBILLOMAT_LINES
CommentThe quantity on this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default1
Refers to


Attribute: QUANTITY
TableBILLOMAT_TEMP
CommentThe quantity of the BOM component item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: RECEIPT_NO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: RECEIPT_NO
TableSTOCK_TRANS
CommentReceipt number when the source of the transaction is an Inwards Goods Receipt.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: REF1
TableSTOCK_TRANS
CommentSource transaction reference. Usually contains the Debtor/Creditor's invoice number, Purchase Order number, Sales Order number, job number, etc.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: REF1
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: REF2
TableSTOCK_TRANS
CommentReference text with details of source of this stock movement.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: REF2
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: REFERENCE
TableSTOCK_SERIALNOS
CommentA reference code for the record.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: REFERENCE
TableSTOCK_TRANS_HDR
CommentReference text for the transaction.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: REFERENCECODE
TableBILLOMAT_TEMP
CommentA reference code for the record.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: RELATED_SEQNO
TableINWARDS_GOODS
CommentFor reversals, this field contains the source Inwards Goods ID number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: REPORTCODE
TableSTOCK_GROUPS
CommentA report code for the group.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: REPORTCODE
TableSTOCK_GROUP2S
CommentA report code for the group.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: REPORTCODE
TableGLACCS
CommentThe report code used by the GL account.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers to


Attribute: REPORTS_TO_STAFFNO
TableSTAFF
CommentThe ID number of the staff member that this staff member reports to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: REQUESTLINESEQNO
TableSTOCK_SERIALNOS
CommentStock request Line ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: REQUESTSEQNO
TableSTOCK_SERIALNOS
CommentStock request ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: REQUEST_DATE
TableSTOCK_REQUESTS
CommentThe date and time when the request was created.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: REQUIRE_DATE
TableSTOCK_REQUESTS
CommentThe date and time that the request must be completed by.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: REQ_QUANT
TableSTOCK_REQUESTLINES
CommentThe Requested Qty on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: RESTRICTED_ITEM
TableSTOCK_ITEMS
CommentThis field is set to 'Y' if the stock item is a restricted item.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: REVERSALSTATUS
TableINWARDS_GOODS
CommentThe reversal status. Will be one of:
0 = Normal
1 = Reversed
2 = Reversal
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: REVERSED
TableSTOCK_TRANS
CommentThis field contains 'Y' if the transaction has been reversed.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: REVERSED
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: RMALINESEQNO
TableSTOCK_SERIALNOS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: RMASEQNO
TableSTOCK_SERIALNOS
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SALES0
TableSTOCKREQUIREMENT
CommentCurrent month sales quantity for the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES1
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item for the month prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES10
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item ten months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES11
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item eleven months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES12
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item twelve months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES2
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item two months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES3
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item three months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES4
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item four months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES5
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item five months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES6
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item six months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES7
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item seven months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES8
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item eight months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES9
TableSTOCKREQUIREMENT
CommentSales quantity for the stock item nine months prior to current month.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALESORDLINESEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Sales Order line that the item is linked to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: SALESORDNO
TableSTOCK_SERIALNOS
CommentThe ID number of the Sales Order ID that the item has been committed against.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: SALESORDQTY
TableSTOCKREQUIREMENT
CommentCommitted stock.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALESTAXRATE
TableSTOCK_ITEMS
CommentDefault GST rate for sales transactions.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SALES_GLSUBCODE
TableSTOCK_GROUPS
CommentThe code of the GL subaccount for Sales.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES_GLSUBCODE
TableSTOCK_ITEMS
CommentThe default GL sub-account code that sales transactions for this stock item are posted to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: SALES_GL_CODE
TableSTOCK_GROUPS
CommentThe code of the GL account for Sales.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toGLACCS.ACCNO


Attribute: SALES_GL_CODE
TableSTOCK_ITEMS
CommentThe default GL code that sales transactions for this stock item are posted to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toGLACCS.ACCNO


Attribute: SALES_HTML
TableSTOCK_WEB
CommentThe Sales text (HTML) for the specified stock item.
Primary keyNo
Data typeVARCHAR(4096)
Domain name
Not NULLNo
Default
Refers to


Attribute: SECTION
TableGLACCS
CommentThis field is set to 0 for Profit and loss accounts or 1 for Balance sheet accounts.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: SECURITYPROFILEID
TableSTAFF
CommentThe ID number of the staff member's Security profile. Corresponds to the profile's ID field in the PROFILE table.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: SELLPRICE1
TableBILLOMAT_HDR
CommentSell price 1.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE1
TableSTOCK_ITEMS
CommentSell price 1.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE10
TableBILLOMAT_HDR
CommentSell price 10.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE10
TableSTOCK_ITEMS
CommentSell price 10.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE2
TableBILLOMAT_HDR
CommentSell price 2.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE2
TableSTOCK_ITEMS
CommentSell price 2.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE3
TableBILLOMAT_HDR
CommentSell price 3.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE3
TableSTOCK_ITEMS
CommentSell price 3.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE4
TableBILLOMAT_HDR
CommentSell price 4.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE4
TableSTOCK_ITEMS
CommentSell price 4.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE5
TableBILLOMAT_HDR
CommentSell price 5.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE5
TableSTOCK_ITEMS
CommentSell price 5.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE6
TableBILLOMAT_HDR
CommentSell price 6.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE6
TableSTOCK_ITEMS
CommentSell price 6.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE7
TableBILLOMAT_HDR
CommentSell price 7.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE7
TableSTOCK_ITEMS
CommentSell price 7.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE8
TableBILLOMAT_HDR
CommentSell price 8.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE8
TableSTOCK_ITEMS
CommentSell price 8.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE9
TableBILLOMAT_HDR
CommentSell price 9.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SELLPRICE9
TableSTOCK_ITEMS
CommentSell price 9.
Primary keyNo
Data typeAS
Domain name
Not NULLNo
Default
Refers to


Attribute: SEND_NOW
TableSTOCK_REQUESTLINES
CommentThe Send Now quantity on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SENT_QUANT
TableSTOCK_REQUESTLINES
CommentThe Sent Qty on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SEQNO
TableSTOCKTAKE_TOTALS
CommentA unique ID number for the stocktake line.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableINWARDS_GOODS_LINES
CommentA unique ID number for the record.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableINWARDS_GOODS_COSTS
CommentA unique ID number for the record.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableCR_INVLINES
CommentA unique transaction line ID.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableBILLOMAT_TEMP
CommentA unique ID number for the record.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableDR_INVLINES
CommentA unique transaction ID.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers toNARRATIVES.SEQNO


Attribute: SEQNO
TableINWARDS_GOODS
CommentA unique ID number for the transaction.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableSTOCK_REQUESTLINES
CommentA unique ID number for the stock transfer request line.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableSTOCK_SERIALNOS
CommentA unique ID number for the record.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableSTOCK_TRANS
CommentA unique ID for the record.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableSTOCK_REQUESTS
CommentA unique ID number for the transfer request
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableSTOCK_REQUESTTYPES
CommentA unique ID number for the request type.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableSTOCK_TRANS_HDR
CommentA unique ID for the record.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SEQNO
TableBILLOMAT_LINES
CommentA unique ID number for the line.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SERIALNO
TableSTOCK_SERIALNOS
CommentThe serial number assigned to the stock item.
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: SERIALNO
TableDR_INVLINES
Comment
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: SERIALNO_TYPE
TableSTOCK_ITEMS
CommentHow the stock item is serialised. Will be one of:
0 = Not Serialised
1 = Fully Tracked (In & Internal & Out)
2 = Creditor & Internal (In & Internal)
3 = Debtor Only (Out only)
4 = Creditor & Debtor (In & Out Only)
5 = Creditor Only (In Only)
6 = Internal & Debtor (Internal & Out only)
7 = Internal Only
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: SERIALNO_TYPE
TableSTOCKTAKE_TOTALS
CommentHow the stock item is serialised. Will be one of:
0 = Not Serialised
1 = Fully Tracked (In & Internal & Out)
2 = Creditor & Internal (In & Internal)
3 = Debtor Only (Out only)
4 = Creditor & Debtor (In & Out Only)
5 = Creditor Only (In Only)
6 = Internal & Debtor (Internal & Out only)
7 = Internal Only
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_ITEMS.SERIALNO_TYPE


Attribute: SESSION_ID
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SESSION_ID
TableSTOCK_TRANS
CommentSession ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SESSION_ID
TableINWARDS_GOODS
CommentThe session ID for the record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SHIPMENTNO
TableINWARDS_GOODS_COSTS
CommentThe shipment number on the record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SHIPMENTNO
TableINWARDS_GOODS_LINES
CommentThe shipment number on the record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: SHIPMENTNO
TableINWARDS_GOODS
CommentThe shipment number on the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: SHOWLINE
TableCR_INVLINES
CommentThis field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: SHOWLINE
TableINWARDS_GOODS_LINES
CommentThis field is used to control the visibility of the line on Clarity forms.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: SHOWLINE
TableSTOCK_REQUESTLINES
CommentThis field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: SHOWLINE
TableDR_INVLINES
CommentThis field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: SIZECODE
TableSTOCK_SIZE
CommentA user-defined code number for the size.
Primary keyNo
Data typeVARCHAR(5)
Domain name
Not NULLYes
Default
Refers to


Attribute: SIZEID
TableSTOCK_SIZE
CommentA unique ID number for the size.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: SIZENAME
TableSTOCK_SIZE
CommentA descriptive name for the size.
Primary keyNo
Data typeVARCHAR(30)
Domain name
Not NULLNo
Default
Refers to


Attribute: SMTP_SEQNO
TableSTAFF
CommentWhere emails are sent via SMTP using the EXO Business Email Sender, this field contains the ID of the SMTP settings that apply to the staff member (SMTP_ACCOUNT.SEQNO). Set up via the SMTP Server Settings window.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SOLINEID
TableSTOCK_REQUESTLINES
Comment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: SORTORDER
TableSTOCK_SIZE
CommentThis field contains the sort order value, which is used to order sizes on the Style Picker window.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: SORTORDER
TableSTOCK_COLOUR
CommentThis field contains the sort order value, which is used to order colours on the Style Picker window.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: SO_INVLINESEQNO
TableSTOCK_SERIALNOS
CommentThe invoice line ID linked to the Sales Order for the serial number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: SO_INVSEQNO
TableSTOCK_SERIALNOS
CommentThe invoice ID linked to the Sales Order for the serial number.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: SPREAD_TYPE
TableINWARDS_GOODS_COSTS
CommentThe spread type for on costs:
0 = Quantity
1 = Value
2 = Weight
3 = Cubic
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: STAFFNO
TableSTOCK_REQUESTS
CommentThe ID number of the staff member assigned to the request.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTAFF.STAFFNO


Attribute: STAFFNO
TableSTAFF
CommentA unique identifier for the staff record.
Primary keyYes
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: STAFFNO
TableBILLOMAT_TEMP
CommentThe ID number of the staff member on the record.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers toSTAFF.STAFFNO


Attribute: STAFFNO
TableSTOCK_TRANS_HDR
CommentID number of the staff member who entered the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers toSTAFF.STAFFNO


Attribute: STATUS
TableSTOCK_GROUPS
CommentThis field contains 'Y' if the 'Display on website option' for the group is ticked.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: STATUS
TableSTOCK_GROUP2S
CommentThis field contains 'Y' if the 'Display on website option' for the group is ticked.
Primary keyNo
Data typeVARCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: STATUS
TableSTOCK_REQUESTS
CommentThe status of the stock transfer. Will be one of:
0 = New Request
1 = Picking
2 = In Transit
3 = Complete
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: STATUS
TableSTOCK_ITEMS
CommentThe stock item's status. Will be one of:
S = Stock item
L = Lookup item
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultL
Refers to


Attribute: STDCOST
TableSTOCK_ITEMS
CommentThe stock item's standard cost.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: STKMOVLINESEQNO
TableSTOCK_SERIALNOS
CommentStock transaction ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: STKMOVSEQNO
TableSTOCK_SERIALNOS
CommentStock transaction header ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: STOCKCODE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: STOCKCODE
TableSTOCKREQUIREMENT
CommentThe stock item's ID code.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSTOCK_SERIALNOS
CommentThe stock code of the serialised stock item.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableBILLOMAT_TEMP
CommentThe stock code of the BOM component item.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSTOCK_ITEMS
CommentA unique ID code for the stock item.
Primary keyYes
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers to


Attribute: STOCKCODE
TableBILLOMAT_LINES
CommentThe stock code of the stock item on this line.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableCR_INVLINES
CommentCode of the Stock item on this line.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSTOCK_WEB
CommentThe stock code of the stock item that this record applies to.
Primary keyNo
Data typeCHAR(23)
Domain name
Not NULLYes
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableINWARDS_GOODS_LINES
CommentThe stock code of the stock item on the line.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableDR_INVLINES
CommentCode of the Stock item on this line.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSTOCKTAKE_TOTALS
CommentThe ID code of the stock item being counted.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSTOCK_REQUESTLINES
CommentThe ID code of the stock item on the line.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSTOCK_LOC_INFO
CommentThe unique ID code of the stock item.
Primary keyYes
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSUPPLIER_STOCK_ITEMS
CommentThe stock item's ID code in EXO Business.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKCODE
TableSTOCK_TRANS
CommentThe ID code of the stock item.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers toSTOCK_ITEMS.STOCKCODE


Attribute: STOCKGROUP
TableSTOCKREQUIREMENT
CommentThe ID number of the stock item's Primary Stock Group.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_GROUPS.GROUPNO


Attribute: STOCKGROUP
TableSTOCK_ITEMS
CommentThe Primary (Fine) Stock Group that the item belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_GROUPS.GROUPNO


Attribute: STOCKGROUP
TableSTOCKTAKE_TOTALS
CommentThe Stock Group that the stock item belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_GROUPS.GROUPNO


Attribute: STOCKGROUP2
TableSTOCKTAKE_TOTALS
CommentThe Alternative Stock Group
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_GROUP2S.GROUPNO


Attribute: STOCKGROUP2
TableSTOCK_ITEMS
CommentThe stock item's Secondary (Coarse) Stock Group.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_GROUP2S.GROUPNO


Attribute: STOCKGROUP2_REPC
TableSTOCKTAKE_TOTALS
CommentThe report code of the stock item's Secondary Stock Group.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers toSTOCK_GROUP2S.REPORTCODE


Attribute: STOCKGROUP_REPC
TableSTOCKTAKE_TOTALS
CommentThe report code of the stock item's Primary Stock Group.
Primary keyNo
Data typeVARCHAR(15)
Domain name
Not NULLNo
Default
Refers toSTOCK_GROUPS.REPORTCODE


Attribute: STOCKINSEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the stock transaction that the item was receipted in against.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: STOCKOUTSEQNO
TableSTOCK_SERIALNOS
CommentThe ID number of the stock transaction against which the item was moved out of inventory.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: STOCKPRICEGROUP
TableSTOCK_ITEMS
CommentThe price group that the stock item belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_PRICEGROUPS.GROUPNO


Attribute: STOCK_AUTH_AMT
TableSTAFF
CommentThe staff member's Stock Purchase Order Authorisation Limit.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: STOCK_CLASSIFICATION
TableSTOCK_ITEMS
CommentThe stock classification that the item belongs to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toSTOCK_CLASSIFICATIONS.CLASSNO


Attribute: SUBCODE
TableDR_INVLINES
CommentThe GL subaccount code on the line.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: SUPPLIERCODE
TableINWARDS_GOODS_LINES
CommentThe supplier code on the line.
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: SUPPLIERCODE
TableSUPPLIER_STOCK_ITEMS
CommentThe supplier's ID code for the stock item.
Primary keyYes
Data typeVARCHAR(23)
Domain name
Not NULLYes
Default
Refers to


Attribute: SUPPLIERCOST
TableSTOCK_ITEMS
CommentThe supplier cost price.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: SUPPLIERNAME
TableINWARDS_GOODS
CommentThe name of the supplier on the transaction.
Primary keyNo
Data typeVARCHAR(70)
Domain name
Not NULLNo
Default
Refers to


Attribute: SUPPLIERNO
TableSTOCK_ITEMS
CommentThe ID number (CR_ACCS.ACCNO) of the stock item's main supplier.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toCR_ACCS.ACCNO


Attribute: SUPPLIERNO
TableINWARDS_GOODS
CommentThe ID number of the supplier (Creditor) account.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers toCR_ACCS.ACCNO


Attribute: SUPPLIERNO
TableSTOCKTAKE_TOTALS
CommentThe ID number of the Creditor who supplies the stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: SUPPLIERNO2
TableSTOCK_ITEMS
CommentAlternate supplier for the stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: SUPPLIERNO3
TableSTOCK_ITEMS
CommentAlternate supplier for the stock item.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: SUPPLIERREF
TableINWARDS_GOODS
CommentThe shipping reference on the transaction.
Primary keyNo
Data typeVARCHAR(50)
Domain name
Not NULLNo
Default
Refers to


Attribute: SUP_NOW
TableSTOCK_REQUESTLINES
CommentThe Receive Now quantity on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SUP_QUANT
TableSTOCK_REQUESTLINES
CommentThe Received Qty on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: SU_SEQNO
TableSTOCK_SERIALNOS
CommentServiceable Unit ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SWATCHID
TableSTOCK_COLOUR
CommentThe colour value of the colour record's swatch.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: SYSTEMQTY
TableSTOCKTAKE_TOTALS
CommentThe quantity recorded in the EXO Business system for the item at this location.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: TAXRATE
TableDR_INVLINES
CommentThe percentage tax rate on the line at the time of the transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: TAXRATE
TableCR_INVLINES
CommentThe percentage tax rate on the line at the time of the transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: TAXRATE_NO
TableDR_INVLINES
CommentThe ID number of the tax rate used by the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toTAX_RATES.SEQNO


Attribute: TAXRATE_NO
TableCR_INVLINES
CommentThe ID number of the tax rate used by the transaction.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers toTAX_RATES.SEQNO


Attribute: TAXSTATUS
TableGLACCS
CommentThe Override GST rate specified for the GL account. A value of -1 corresponds to the AUTO SELECT RATE option.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: TIME_COUNTSHEETS
TableSTOCKTAKE_CTRL
CommentThe date and time when count sheets were printed for the location.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: TIME_INITIALISED
TableSTOCKTAKE_CTRL
CommentThe date and time when the location was initialised for stocktake.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: TIME_KEYED
TableSTOCKTAKE_CTRL
CommentThe date and time when counted quantities were keyed for the location.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: TIME_UPLOADED
TableSTOCKTAKE_CTRL
CommentThe date and time when stock transactions were uploaded to the Stock ledger.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: TOLOCATION
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: TOLOCATION
TableSTOCK_TRANS
CommentID of the Destination location (applies in case of stock transfers).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_LOCATIONS.LOCNO


Attribute: TOTALSTOCK
TableSTOCK_ITEMS
CommentTotal units of stock for the item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLYes
Default0
Refers to


Attribute: TO_LOC
TableSTOCK_REQUESTS
CommentThe ID number of the location that stock is to be transferred to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: TRANSDATE
TableDR_INVLINES
CommentThe date of the transaction.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: TRANSDATE
TableINWARDS_GOODS_COSTS
CommentThe transaction date of the invoice linked to this record.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: TRANSDATE
TableINWARDS_GOODS
CommentThe transaction date.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: TRANSDATE
TableSTOCK_TRANS_HDR
CommentThe date and time when the transaction took place.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLYes
Default
Refers to


Attribute: TRANSDATE
TableBILLOMAT_TEMP
CommentThe date and time when the transaction occurred.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: TRANSDATE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Default
Refers to


Attribute: TRANSDATE
TableSTOCK_TRANS
CommentThe date when the stock movement took place.
Primary keyNo
Data typeDATETIME
Domain name
Not NULLNo
Defaultgetdate()
Refers to


Attribute: TRANSTYPE
TableSTOCK_TRANS_HDR
CommentThe transaction type. Will be one of:
0=Sales
1=Receipt
2=Transfer
3=Adjust Out
4=Adjust In
5=Average Cost Adjustment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default
Refers to


Attribute: TRANSTYPE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default
Refers to


Attribute: TRANSTYPE
TableSTOCK_TRANS
CommentThe type of the transaction. Will be one of: 0=Sales 1=Receipt 2=Transfer 3=Adjust Out 4=Adjust In 5=Average Cost Adjustment
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: TRANSTYPE
TableSTOCK_REQUESTS
CommentThe ID number of the Stock Request Type (from STOCK_REQUESTTYPES).
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers toSTOCK_REQUESTTYPES.SEQNO


Attribute: TWITTER_TOKEN_KEY
TableSTAFF
CommentIf the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token key is stored here.
Primary keyNo
Data typeVARCHAR(max)
Domain name
Not NULLNo
Default
Refers to


Attribute: TWITTER_TOKEN_SECRET
TableSTAFF
CommentIf the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token secret is stored here.
Primary keyNo
Data typeVARCHAR(max)
Domain name
Not NULLNo
Default
Refers to


Attribute: UNITCOST
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: UNITCOST
TableSTOCK_TRANS
CommentThe unit cost price of the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: UNITCOST
TableDR_INVLINES
CommentThe unit cost of the Stock item on this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UNITCOST
TableSTOCKTAKE_TOTALS
CommentThe unit cost for the stock item. Unit costs are only entered during stock take if the "Initialise cost prices" stock take option is enabled.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UNITNO
TableSTOCK_SERIALNOS
CommentThe ID number of the serviceable unit that the item is linked to.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default-1
Refers to


Attribute: UNITPRICE
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: UNITPRICE
TableSTOCK_TRANS
CommentUnit price of the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UNITPRICE
TableINWARDS_GOODS_LINES
CommentThe unit price of the stock item on the line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UNITPRICE
TableCR_INVLINES
CommentThe unit price of the Stock item on this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UNITPRICE
TableBILLOMAT_TEMP
CommentThe unit price of the BOM component item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default
Refers to


Attribute: UNITPRICE
TableDR_INVLINES
CommentThe unit price of the Stock item on this line.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UNITPRICE_INCTAX
TableCR_INVLINES
CommentThe unit price of the Stock item on this line, inclusive of tax.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UNITPRICE_INCTAX
TableDR_INVLINES
CommentThe unit price of the Stock item on this line, inclusive of tax.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UPDATEITEM_CODE
TableSTOCK_ITEMS
CommentOnly applies to lookup items. The ID number of the stocked item that maintains the actual stock.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: UPDATEITEM_FLAG
TableSTOCK_TRANS
CommentThis 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.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultY
Refers to


Attribute: UPDATEITEM_FLAG
TableSTOCK_TRANS_ARCHIVE
CommentSee STOCK_TRANS.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
Default
Refers to


Attribute: UPDATEITEM_QTY
TableSTOCK_ITEMS
CommentOnly applies to lookup items. Quantity of the stocked item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: UPDATE_STOCK
TableCR_INVLINES
CommentIf this field is set to 'Y', stock movements are created via the trigger CR_INVLINES_POST. The field is then set to 'T'.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: UPDATE_STOCK
TableDR_INVLINES
CommentIf this field is set to 'Y', stock movements are created via the trigger DR_INVLINES_POST. The field is then set to 'T'.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers to


Attribute: USERPROFILEID
TableSTAFF
CommentThe ID number of the staff member's User profile. Corresponds to the profile's ID field in the PROFILE table.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLYes
Default0
Refers to


Attribute: USESUBCODES
TableGLACCS
CommentNot used.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: VALUE_TRADED_IN_NEG
TableSTOCK_TRANS
CommentValue traded when total stock on hand for the item was in negative at the time of the transaction.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: VARIABLECOST
TableSTOCK_ITEMS
CommentThe field is set to 'Y for Variable Cost stock items.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLYes
DefaultN
Refers to


Attribute: VARIANCE
TableSTOCKTAKE_TOTALS
CommentThe difference between the system quantity and the counted quantity. Populated automatically when the Stocktake Variance Report is run for the Stock Take utility.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: VARIANTLINE
TableBILLOMAT_LINES
CommentThis field contains 'Y' if the line is not included in the BOM by default.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: VAR_GLPOSTED
TableINWARDS_GOODS_LINES
CommentThis field contains 'Y' if variance has been posted against this line.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: VIRTSTOCK
TableSTOCKREQUIREMENT
CommentFree stock taking into account the incoming and committed stock.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: WASTAGE
TableBILLOMAT_HDR
CommentThe BOM's Overhead Allocation percentage.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: WEB_SHOW
TableSTOCK_ITEMS
Comment
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: WEIGHT
TableSTOCK_ITEMS
CommentPhysical weight of the stock item.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: WORKSORDLINESEQNO
TableSTOCK_SERIALNOS
CommentWorks Order Line ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: WORKSORDSEQNO
TableSTOCK_SERIALNOS
CommentWorks order ID
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default-1
Refers to


Attribute: X_BINCODE
TableSTOCK_GROUPS
CommentThe bin code for the style.
Primary keyNo
Data typeVARCHAR(12)
Domain name
Not NULLNo
Default
Refers to


Attribute: X_COLOURID
TableSTOCK_ITEMS
CommentStyle colour ID of the stock item. Used by the Style, Size Colour functionality.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_COLOURIDS
TableSTOCK_GROUPS
CommentThis field contains a comma-separated list of colour IDs applicable to the style.
Primary keyNo
Data typeVARCHAR(255)
Domain name
Not NULLNo
Default
Refers to


Attribute: X_DESCRIPTION_FORMULA
TableSTOCK_GROUPS
CommentThe stock item description formula for the group.
Primary keyNo
Data typeVARCHAR(40)
Domain name
Not NULLNo
Default
Refers to


Attribute: X_ISSTYLE
TableSTOCK_GROUPS
CommentThis field contains 'Y' if the group is a style.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultN
Refers to


Attribute: X_MAXSTOCK
TableSTOCK_GROUPS
CommentThe maximum stock level for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_MINSTOCK
TableSTOCK_GROUPS
CommentThe minimum stock level for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_PRICEGROUP
TableSTOCK_GROUPS
CommentThis field contains 'Y' if the style has a matching Price Group.
Primary keyNo
Data typeCHAR(1)
Domain name
Not NULLNo
DefaultY
Refers toSTOCK_PRICEGROUPS.GROUPNO


Attribute: X_SELLPRICE1
TableSTOCK_GROUPS
CommentSell price 1 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE10
TableSTOCK_GROUPS
CommentSell price 10 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE2
TableSTOCK_GROUPS
CommentSell price 2 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE3
TableSTOCK_GROUPS
CommentSell price 3 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE4
TableSTOCK_GROUPS
CommentSell price 4 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE5
TableSTOCK_GROUPS
CommentSell price 5 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE6
TableSTOCK_GROUPS
CommentSell price 6 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE7
TableSTOCK_GROUPS
CommentSell price 7 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE8
TableSTOCK_GROUPS
CommentSell price 8 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SELLPRICE9
TableSTOCK_GROUPS
CommentSell price 9 for the style.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SIZEID
TableSTOCK_ITEMS
CommentStyle size ID of the stock item. Used by the Style, Size Colour functionality.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SIZEIDS
TableSTOCK_GROUPS
CommentThis field contains a comma-separated list of size IDs applicable to the style.
Primary keyNo
Data typeVARCHAR(255)
Domain name
Not NULLNo
Default
Refers to


Attribute: X_STOCKCODE_FORMULA
TableSTOCK_GROUPS
CommentThe stock item code formula for the group.
Primary keyNo
Data typeVARCHAR(23)
Domain name
Not NULLNo
Default
Refers to


Attribute: X_SUPPLIERCOST
TableSTOCK_GROUPS
CommentThe supplier cost in the currency of the supplier account.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: X_SUPPLIERNO
TableSTOCK_GROUPS
CommentThe ID number of the main supplier of the style.
Primary keyNo
Data typeINTEGER
Domain name
Not NULLNo
Default0
Refers to


Attribute: YEARUNITS
TableSTOCK_ITEMS
CommentYear to date sales totals in terms of quantity.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to


Attribute: YEARVALUE
TableSTOCK_ITEMS
CommentSales value for the current year.
Primary keyNo
Data typeFLOAT(53)
Domain name
Not NULLNo
Default0
Refers to