Attribute: ABSENT
Table | STAFF |
Comment | This field is set to 'Y' if the staff member is currently absent, i.e. if their Absent flag is ticked in EXO Business Configurator. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: ACCGROUP
Table | GLACCS |
Comment | The GL account's Account Group. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ACCNO
Table | CR_INVLINES |
Comment | The account number of the Creditor that the transaction belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | CR_ACCS.ACCNO |
Attribute: ACCNO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ACCNO
Table | INWARDS_GOODS_COSTS |
Comment | The supplier (Creditor account ID). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | CR_ACCS.ACCNO |
Attribute: ACCNO
Table | STOCKREQUIREMENT |
Comment | The ID number of the stock item's supplier (from CRACCS). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ACCNO
Table | DR_INVLINES |
Comment | The account number of the Debtor that the transaction belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | DR_TRANS.ACCNO |
Attribute: ACCNO
Table | GLACCS |
Comment | The unique GL account number. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: ACCNO
Table | SUPPLIER_STOCK_ITEMS |
Comment | The ID number of the supplier (Creditor) account. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: ACCNO
Table | STOCK_TRANS |
Comment | For manual stock movements this field is NULL. For movements originating from other ledgers, this contains the account number against the source transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ACCOUNT_STATUS
Table | STAFF |
Comment | The staff member's account status. Will be one of: 0 = Account OK 1 = Account Locked 2 = Password Expired |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: ACTUALREORD
Table | STOCKREQUIREMENT |
Comment | Actual reorder quantity for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ACTUAL_COST
Table | STOCK_SERIALNOS |
Comment | The actual cost of the item when moved into stock. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: AGE
Table | STOCK_TRANS |
Comment | Calculated field that indicates the age of the transaction. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AGE
Table | STOCK_TRANS_HDR |
Comment | Calculated field that indicates the age the record belongs to. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AGE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AGE
Table | INWARDS_GOODS_COSTS |
Comment | The invoice's age. This is calculated based on PERIOD_SEQNO. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AGE_STAMP
Table | STOCK_TRANS |
Comment | This is a historical field that has been superseded by the AGE calculated field. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: AGE_STAMP
Table | STOCK_TRANS_HDR |
Comment | This is a historical field that has been superseded by the AGE calculated field. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: AGE_STAMP
Table | INWARDS_GOODS_COSTS |
Comment | This is a historical field that has been superseded by the AGE calculated field. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: AGE_STAMP
Table | INWARDS_GOODS_LINES |
Comment | This is a historical field that has been superseded by the AGE calculated field. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: ALERT
Table | STOCK_ITEMS |
Comment | Text of the pop-up alert message that appears when the stock item is sold or purchased. |
Primary key | No |
Data type | VARCHAR(60) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ALLOWJOURNAL
Table | GLACCS |
Comment | This field is set to 'Y' if the GL account allows journals. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ALT_AVECOST
Table | STOCK_TRANS |
Comment | Alternate weighted average cost. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ALT_AVECOST
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ALT_QUANTITY
Table | STOCK_TRANS |
Comment | Alternate quantity. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ALT_QUANTITY
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ALT_SEQNO
Table | STOCK_TRANS |
Comment | Alternate SEQNO. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: ALT_SEQNO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: ANALYSIS
Table | DR_INVLINES |
Comment | GL code for the Stock line. Can be overridden. The visibility of this column onscreen is controlled by the profile "Enable display and override of GL code from stock item". |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ANALYSIS
Table | CR_INVLINES |
Comment | GL code for the Stock line. Can be overridden. The visibility of this column onscreen is controlled by the profile "Enable display and override of GL code from stock item". |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: API_ACCESS
Table | STAFF |
Comment | This field contains 'Y' if the staff member is authorised to use the EXO API. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: APP_PASSWORD
Table | STAFF |
Comment | The staff member's password, used when logging in to the EXO Business system. Passwords are stored in an encrypted format. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ASSIGNED_LINESEQNO
Table | STOCK_SERIALNOS |
Comment | The 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 key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: ASSIGNED_SEQNO
Table | STOCK_SERIALNOS |
Comment | The 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 key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: AUTH_AMT
Table | STAFF |
Comment | The staff member's Credit Invoice Authorisation Limit. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AUTOBUILD
Table | BILLOMAT_HDR |
Comment | Applies 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 key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: AUTOCODE
Table | STOCK_GROUPS |
Comment | The One-off Stock Item autocode prefix for the group. |
Primary key | No |
Data type | VARCHAR(10) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AUTOCODE
Table | STOCK_GROUP2S |
Comment | The One-off Stock Item autocode prefix for the group. |
Primary key | No |
Data type | VARCHAR(10) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AUTOCODENO
Table | STOCK_GROUP2S |
Comment | The One-off Stock Item autocode suffix for the group. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AUTOCODENO
Table | STOCK_GROUPS |
Comment | The One-off Stock Item autocode suffix for the group. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: AUTO_NARRATIVE
Table | STOCK_ITEMS |
Comment | The setting of the stock item's Auto Narrative property. Will be one of: 0=No 1=Yes with Blank 2=Yes with Notes |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: AVECOST
Table | STOCK_ITEMS |
Comment | The stock item's Average Cost Price. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: BAD_LOGIN_COUNT
Table | STAFF |
Comment | The number of times the staff member has attempted to log in but failed. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: BALANCE
Table | GLACCS |
Comment | The account's balance. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: BALANCE_SHEET_TYPE
Table | GLACCS |
Comment | For balance sheet accounts, this field indicates the balance sheet type. Will be one of: -1 = Not a balance sheet account 0 = Asset 1 = Liability 2 = Equity |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: BALSHEETACCTOT
Table | GLACCS |
Comment | The balance sheet total for the account. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BARCODE1
Table | STOCKTAKE_TOTALS |
Comment | Barcode/alternate code 1. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BARCODE1
Table | STOCK_ITEMS |
Comment | Barcode/alternate code 1. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BARCODE2
Table | STOCK_ITEMS |
Comment | Barcode/alternate code 2. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BARCODE3
Table | STOCK_ITEMS |
Comment | Barcode/alternate code 3. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHCODE
Table | CR_INVLINES |
Comment | The batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHCODE
Table | INWARDS_GOODS_LINES |
Comment | The batch code on the line. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHCODE
Table | DR_INVLINES |
Comment | The batch code on the line. The "Enable stock batch codes" Company-level profile setting must be enabled to be able to use batch codes. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHCODE
Table | STOCK_REQUESTLINES |
Comment | The batch code on the line. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHCODE
Table | STOCKTAKE_TOTALS |
Comment | The batchcode for the stock item. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHCODE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHCODE
Table | STOCK_TRANS |
Comment | The batch number. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCHNO
Table | INWARDS_GOODS_LINES |
Comment | The batch number on the record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: BATCHQUANTITY
Table | BILLOMAT_TEMP |
Comment | The batch quantity on the record. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BATCH_QTY
Table | BILLOMAT_HDR |
Comment | The BOM's Batch Quantity. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: BILLCODE
Table | BILLOMAT_LINES |
Comment | The ID code of the BOM header (BILLOMAT_HDR.BILLCODE). |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | BILLOMAT_HDR.BILLCODE |
Attribute: BILLCODE
Table | BILLOMAT_TEMP |
Comment | The BOM code. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | BILLOMAT_HDR.BILLCODE |
Attribute: BILLCODE
Table | BILLOMAT_HDR |
Comment | The BOM's unique ID code. |
Primary key | Yes |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: BINCODE
Table | STOCK_ITEMS |
Comment | Bincode for the stock item. |
Primary key | No |
Data type | VARCHAR(12) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BINCODE
Table | STOCKTAKE_TOTALS |
Comment | The Bin Code for the stock item being counted. |
Primary key | No |
Data type | VARCHAR(12) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BINCODE
Table | STOCK_LOC_INFO |
Comment | The stock item's bin or shelf code at the location. |
Primary key | No |
Data type | VARCHAR(12) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: BKORDQTY
Table | DR_INVLINES |
Comment | Back Order Qty from the Sales Order. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: BOMBATCHSEQNO
Table | BILLOMAT_TEMP |
Comment | The BOM batch ID number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: BOMPRICING
Table | CR_INVLINES |
Comment | How Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BOMPRICING
Table | STOCK_REQUESTLINES |
Comment | How Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BOMPRICING
Table | INWARDS_GOODS_LINES |
Comment | C = BOM priced by Component, T = BOM priced by total, N = Normal |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BOMPRICING
Table | DR_INVLINES |
Comment | How Bills of Materials are priced. Will be one of: C = Pricing by Component T = Pricing by total |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BOMTYPE
Table | BILLOMAT_HDR |
Comment | The type of BOM. Will be one of: K = Kit B = Build O = Order Template |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | K |
Refers to | |
Attribute: BOMTYPE
Table | STOCK_REQUESTLINES |
Comment | The type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BOMTYPE
Table | CR_INVLINES |
Comment | The type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BOMTYPE
Table | DR_INVLINES |
Comment | The type of Bill of Materials that the line relates to: N = Normal stock item B = Build K = Kit L = Lookup |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BOMTYPE
Table | INWARDS_GOODS_LINES |
Comment | The Bill of Materials type on the line. Will be one of: N = Normal K = Kit B = Build L = Linked |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: BRANCHNO
Table | STOCK_GROUPS |
Comment | The ID number of the group's branch (from BRANCHES). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | BRANCHES.BRANCHNO |
Attribute: BRANCHNO
Table | STOCK_GROUP2S |
Comment | The ID number of the group's branch (from BRANCHES). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | BRANCHES.BRANCHNO |
Attribute: BRANCHNO
Table | INWARDS_GOODS_LINES |
Comment | The ID number of the branch on the record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | BRANCHES.BRANCHNO |
Attribute: BRANCHNO
Table | CR_INVLINES |
Comment | The branch number. Lines generally inherit the branch specified on the invoice header. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: BRANCHNO
Table | DR_INVLINES |
Comment | The branch number. Lines generally inherit the branch specified on the invoice header. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: BRANCHNO
Table | STOCK_ITEMS |
Comment | Branch number for the stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: CALCREORD
Table | STOCKREQUIREMENT |
Comment | Reorder quantity, calculated taking into account minimum stock, maximum stock and available free stock. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: CAN_SPREAD
Table | INWARDS_GOODS_COSTS |
Comment | |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | Y |
Refers to | |
Attribute: CLASSNAME
Table | STOCK_CLASSIFICATIONS |
Comment | The name of the classification. |
Primary key | No |
Data type | VARCHAR(100) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: CLASSNO
Table | STOCK_CLASSIFICATIONS |
Comment | A unique ID number for the classification. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: CODETYPE
Table | DR_INVLINES |
Comment | The type of code on the line. Will be one of: G - GL code S - Stock code |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | S |
Refers to | |
Attribute: CODETYPE
Table | CR_INVLINES |
Comment | The type of code on the line. Will be one of: G - GL code S - Stock code |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: COGSMETHOD
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: COLOURCODE
Table | STOCK_COLOUR |
Comment | A user-defined ID code for the colour. |
Primary key | No |
Data type | VARCHAR(5) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: COLOURID
Table | STOCK_COLOUR |
Comment | A unique ID number for the colour. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: COLOURNAME
Table | STOCK_COLOUR |
Comment | A descriptive name for the colour. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: COMMENT
Table | STOCK_REQUESTLINES |
Comment | The comment entered on the line, if any. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: COMPLETE
Table | INWARDS_GOODS |
Comment | This field contains 'Y' if the receipt has been completed. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: COMPLETE
Table | INWARDS_GOODS_COSTS |
Comment | Indicates if the line has been marked as completed, which controls whether or not the line can be edited. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: COMPLETE
Table | INWARDS_GOODS_LINES |
Comment | This field contains 'Y' if the inwards goods receipt has been completed (and therefore cannot be altered). |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: COMPNO
Table | STOCK_SERIALNOS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: COMPONENTLOCATION
Table | BILLOMAT_TEMP |
Comment | The location of the BOM component stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: CONTRACT_HDR
Table | DR_INVLINES |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: COST
Table | INWARDS_GOODS_COSTS |
Comment | The cost in local currency. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: COSTCODE
Table | INWARDS_GOODS_COSTS |
Comment | The on cost code for the record. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: COSTED_PERIOD_SEQNO
Table | INWARDS_GOODS |
Comment | The period to which the receipt belongs. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: COSTGROUP
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: COSTPRICE
Table | BILLOMAT_HDR |
Comment | Cost price for the BOM. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: COSTTYPE
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: COST_GROUP
Table | INWARDS_GOODS_LINES |
Comment | If the order originates from a job, this field records the ID number of the job's cost group. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | JOB_COSTGROUPS.SEQNO |
Attribute: COST_GROUP
Table | CR_INVLINES |
Comment | This field only applies if EXO Job Costing is installed. It identifies the Cost Group that the transaction belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: COST_LINENO
Table | DR_INVLINES |
Comment | This field is the link used when allocating cost lines to DR_INVLINES. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: COST_TYPE
Table | INWARDS_GOODS_LINES |
Comment | If the order originates from a job, this field records the ID number of the job's cost type. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | JOB_COSTTYPES.SEQNO |
Attribute: COST_TYPE
Table | CR_INVLINES |
Comment | This field only applies if EXO Job Costing is installed. It identifies the Cost Type that the transaction belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: COS_GLSUBCODE
Table | STOCK_ITEMS |
Comment | The Cost of Sales sub-account updated in the General Ledger when the stock item is sold. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: COS_GLSUBCODE
Table | STOCK_GROUPS |
Comment | The code of the GL subaccount for Cost of Sales. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: COS_GL_CODE
Table | STOCK_GROUPS |
Comment | The code of the GL account for Cost of Sales. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | GLACCS.ACCNO |
Attribute: COS_GL_CODE
Table | STOCK_ITEMS |
Comment | The Cost of Sales account updated in the General Ledger when this stock item is sold. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | GLACCS.ACCNO |
Attribute: COUNTQTY
Table | STOCKTAKE_TOTALS |
Comment | The physical count taken for the item at this location. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: CREATED_DATE
Table | GLACCS |
Comment | The date and time that the GL account was created. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: CREDITQTY
Table | DR_INVLINES |
Comment | Contains the sum of quantities which have been a part of credit notes against the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: CRINVLINEID
Table | CR_INVLINES |
Comment | A unique ID for the invoice line, which should be used to link to other tables. Every time an invoice is edited, the lines are essentially removed and reinserted again, which changes the SEQNO. However, the CRINVLINEID field retains its value. Hence, any relationships built on this field are still valid in such a scenario. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: CRINVLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Creditors Invoice line that the item is linked to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: CRINVSEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Creditors Invoice that the item has been receipted in against. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: CR_ACCNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the related Creditor account. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: CUBIC
Table | STOCK_ITEMS |
Comment | Cubic weight of the item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: CURRENCYNO
Table | DR_INVLINES |
Comment | The currency number for the line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | CURRENCIES.CURRENCYNO |
Attribute: CURRENCYNO
Table | GLACCS |
Comment | The ID number of the currency that the GL account is in. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | CURRENCIES.CURRENCYNO |
Attribute: CURRENCYNO
Table | CR_INVLINES |
Comment | The ID number of the currency used on the line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | CURRENCIES.CURRENCYNO |
Attribute: CUSTOMFIELD
Table | DR_INVLINES |
Comment | |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: CUSTOM_FILTER
Table | STOCKTAKE_CTRL |
Comment | This field contains the custom SQL filter defined for the location, if there is one. |
Primary key | No |
Data type | VARCHAR(100) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: CUSTORDERNO
Table | STOCK_REQUESTS |
Comment | The customer order number, if there is one. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DATAX_EXCHANGE_FLAG
Table | STOCK_GROUP2S |
Comment | |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | I |
Refers to | |
Attribute: DATAX_EXCHNO
Table | STOCK_GROUP2S |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: DATAX_SITE_NO2
Table | STOCK_GROUP2S |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: DATAX_SOURCE_SITE
Table | STOCK_GROUP2S |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: DEFAULTWARRANTYNO
Table | STOCK_ITEMS |
Comment | The default Warranty No for the stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: DEFDAYS
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DELADDR1
Table | STOCK_LOCATIONS |
Comment | Line 1 of the location's address. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DELADDR2
Table | STOCK_LOCATIONS |
Comment | Line 2 of the location's address. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DELADDR3
Table | STOCK_LOCATIONS |
Comment | Line 3 of the location's address. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DELADDR4
Table | STOCK_LOCATIONS |
Comment | Line 4 of the location's address. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DELADDR5
Table | STOCK_LOCATIONS |
Comment | Line 5 of the location's address. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DELADDR6
Table | STOCK_LOCATIONS |
Comment | Line 6 of the location's address. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | CR_INVLINES |
Comment | Description of the Stock item on this line. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | INWARDS_GOODS_LINES |
Comment | The description of the stock item on the line. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | DR_INVLINES |
Comment | Description of the Stock item on this line. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | STOCKTAKE_TOTALS |
Comment | The description of the stock item being counted. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | BILLOMAT_HDR |
Comment | A descriptive name for the BOM. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | STOCKREQUIREMENT |
Comment | The stock item's description. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | STOCK_ITEMS |
Comment | The stock item's description. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | SUPPLIER_STOCK_ITEMS |
Comment | The supplier's description for the stock item. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DESCRIPTION
Table | STOCK_REQUESTLINES |
Comment | The description of the stock item on the line. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_ITEMS.DESCRIPTION |
Attribute: DESCRIPTION
Table | BILLOMAT_LINES |
Comment | The description of the stock item on this line. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DETAILS
Table | INWARDS_GOODS_COSTS |
Comment | Details of the on cost. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: DIMENSIONS
Table | STOCK_ITEMS |
Comment | How the dimensions of the stock item are specified. Will be one of: 0=None 1=Length 2=Square 3=Cubic |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: DISCOUNT
Table | SUPPLIER_STOCK_ITEMS |
Comment | The percentage discount when purchasing the stock item from the supplier. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DISCOUNT
Table | CR_INVLINES |
Comment | The percentage discount for the Stock item on this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DISCOUNT
Table | DR_INVLINES |
Comment | The percentage discount for the Stock item on this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DISCOUNT
Table | INWARDS_GOODS_LINES |
Comment | The discount percentage on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DISCOUNTAMT
Table | CR_INVLINES |
Comment | The discount amount on a stock line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DISCOUNTLEVEL
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DISCOUNTPCT
Table | CR_INVLINES |
Comment | The discount percentage on a stock line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DISCOUNTRATE
Table | STAFF |
Comment | The staff member's Discount Rate Limit. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: DISPLAY_NAME
Table | STOCK_REQUESTTYPES |
Comment | The name of the request type. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: DRCR
Table | GLACCS |
Comment | This field is set to 'C' for Credit accounts or 'D' for Debit accounts. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | D |
Refers to | |
Attribute: DRINVLINEID
Table | DR_INVLINES |
Comment | A unique ID for the invoice line, which should be used to link to other tables. Every time an invoice is edited, the lines are essentially removed and reinserted again, which changes the SEQNO. However, the DRINVLINEID field retains its value. Hence, any relationships built on this field are still valid in such a scenario. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: DRINVLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Debtors Invoice line that the item is linked to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: DR_ACCNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the related Debtor account. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: DUTY
Table | STOCK_ITEMS |
Comment | The duty percentage on the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: DUTYCOST
Table | INWARDS_GOODS_LINES |
Comment | The duty cost on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ECONORDERQTY
Table | SUPPLIER_STOCK_ITEMS |
Comment | The Minimum Order Quantity for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ECONORDERQTY
Table | STOCK_ITEMS |
Comment | The economic order quantity (EOQ) for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: EMAIL_ADDRESS
Table | STAFF |
Comment | The staff member's email address. |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: EMPLOYEE_CODE
Table | STAFF |
Comment | This field is used by the payroll integration functionality. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: EXCHRATE
Table | DR_INVLINES |
Comment | The exchange rate for the line at the time of the transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: EXCHRATE
Table | INWARDS_GOODS_COSTS |
Comment | The exchange rate. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: EXCHRATE
Table | CR_INVLINES |
Comment | The exchange rate for the line at the time of the transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: EXCHRATE
Table | INWARDS_GOODS_LINES |
Comment | The exchange rate on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: EXCLUDE_FROMFREE_STOCK
Table | STOCK_LOCATIONS |
Comment | This field contains 'Y' if the location's "Exclude from Free Stock" option is ticked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: EXCLUDE_FROMSALES
Table | STOCK_LOCATIONS |
Comment | This field contains 'Y' if the location's "Exclude from Sales" option is ticked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: EXCLUDE_FROMVALUATION
Table | STOCK_LOCATIONS |
Comment | This field contains 'Y' if the location's "Exclude from Valuation" option is ticked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: EXCLUDE_FROM_REVAL
Table | GLACCS |
Comment | If this field is set to 'Y', the account is excluded from revaluation. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: EXPECTEDPROFIT
Table | STOCK_GROUPS |
Comment | The expected profit margin for the group. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: EXPIRY_DATE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: EXPIRY_DATE
Table | INWARDS_GOODS_LINES |
Comment | The expiry date of the stock item, if there is one. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: EXPIRY_DATE
Table | STOCKTAKE_TOTALS |
Comment | The date when the stock item batch expires. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: EXPIRY_DATE
Table | STOCK_TRANS |
Comment | The Expiry Date for a batch tracked item. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: EXPIRY_DATE
Table | STOCK_SERIALNOS |
Comment | The expiry date on the record. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | Yes |
Default | getdate() |
Refers to | |
Attribute: EXPIRY_DAYS
Table | STOCKTAKE_TOTALS |
Comment | The number of days until the stock item batch expires. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | STOCK_ITEMS.EXPIRY_DAYS |
Attribute: EXPIRY_DAYS
Table | STOCK_ITEMS |
Comment | Number of days before expiry of the stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: EXTENSION
Table | STAFF |
Comment | The staff member's telephone extension. |
Primary key | No |
Data type | VARCHAR(12) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FACEBOOK_ACCESS_TOKEN
Table | STAFF |
Comment | If the staff member uses their own Facebook account when using the EXO Business social media functions, their encrypted access token is stored here. |
Primary key | No |
Data type | VARCHAR(max) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FC_COST
Table | INWARDS_GOODS_COSTS |
Comment | The cost in the currency of the supplier account. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: FILENAME
Table | STOCK_GROUPS |
Comment | This field contains the filename of the website picture for the group. |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FILENAME
Table | STOCK_GROUP2S |
Comment | This field contains the filename of the website picture for the group. |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FIXEDCOST
Table | INWARDS_GOODS_LINES |
Comment | The fixed cost on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: FREIGHT_FREE
Table | DR_INVLINES |
Comment | 'Y' or 'N' depending on whether the line is freight free. This comes from the price policy for the line. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: FROM_HDR
Table | STOCK_TRANS |
Comment | For 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 key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FROM_HDR
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FROM_LEDGER
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FROM_LEDGER
Table | STOCK_TRANS |
Comment | d = Debtor c = Creditor s = Stock j = Job Costing i = Inwards Goods Receipt o = Sales Orders p = Purchase Orders |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: FROM_LOC
Table | STOCK_REQUESTS |
Comment | The ID number of the location that stock is to be transferred from. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: FXCOST
Table | INWARDS_GOODS_LINES |
Comment | The cost on the line in local currency. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: FX_VAR
Table | INWARDS_GOODS_LINES |
Comment | The foreign exchange variance applicable to the line at the time of invoicing. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: FX_VAR
Table | INWARDS_GOODS_COSTS |
Comment | The foreign exchange variance applicable to the invoice raised against this record. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: GLACC
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GLACC
Table | STOCK_TRANS |
Comment | The General Ledger Account that is affected when the transaction is posted to GL. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | GLACCS.ACCNO |
Attribute: GLACCNO
Table | CR_INVLINES |
Comment | GL account number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: GLBATCH
Table | INWARDS_GOODS_COSTS |
Comment | GL batch number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: GLBATCHNO
Table | INWARDS_GOODS |
Comment | The GL batch number on the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: GLBATCHNO
Table | STOCK_TRANS |
Comment | ID number of the GL Batch that the posted stock journal belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GLBATCHNO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GLBRANCH
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GLBRANCH
Table | STOCK_TRANS |
Comment | The Branch used for posting to the General Ledger. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: GLPOSTED
Table | INWARDS_GOODS_COSTS |
Comment | This field contains 'Y' if a GL journal exists for the record. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: GLPOSTED
Table | STOCK_TRANS |
Comment | This field contains 'Y' if the transaction has been posted to the General Ledger. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: GLPOSTED
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GLSUBACC
Table | STOCK_TRANS |
Comment | The General Ledger Sub Account that is affected when the transaction is posted to GL. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: GLSUBACC
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GLSUBACC
Table | CR_INVLINES |
Comment | SL sub-account number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: GROUP2_SEQNO
Table | STOCK_GROUPS |
Comment | The ID number of the related Alternate Stock Group. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_GROUP2S.GROUPNO |
Attribute: GROUPNAME
Table | STOCK_GROUP2S |
Comment | The group's name/description. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GROUPNAME
Table | STOCK_PRICEGROUPS |
Comment | The Price Group's name. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GROUPNAME
Table | STOCK_GROUPS |
Comment | The group's name/description. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: GROUPNO
Table | STOCK_PRICEGROUPS |
Comment | A unique ID number for the Price Group. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: GROUPNO
Table | STOCK_GROUPS |
Comment | A unique ID code for the group. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: GROUPNO
Table | STOCK_GROUP2S |
Comment | A unique ID number for the group. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: HAS_BN
Table | STOCK_ITEMS |
Comment | This field is set to 'Y' if the stock item is batch tracked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: HAS_BN
Table | STOCKTAKE_TOTALS |
Comment | This field is set to 'Y' if the stock item is batch tracked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | STOCK_ITEMS.HAS_BN |
Attribute: HAS_BUDGETS
Table | STAFF |
Comment | This field is set to 'Y' if the staff member has been assigned a Sales Team Budget, i.e. if their Has Budget flag is ticked in EXO Business Configurator. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: HAS_EXPIRY
Table | STOCKTAKE_TOTALS |
Comment | This field is set to 'Y' if the stock item has an expiry date. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | STOCK_ITEMS.HAS_EXPIRY |
Attribute: HAS_EXPIRY
Table | STOCK_ITEMS |
Comment | This field is set to 'Y' if the stock item has an expiry date. This flag is only available in the UI if the "Use expiry dates for batched & serial numbers" profile setting is enabled. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: HAS_SN
Table | STOCK_ITEMS |
Comment | This field is set to 'Y' if the stock item is serial number tracked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: HDR_SEQNO
Table | CR_INVLINES |
Comment | The SEQNO of the record in the CR_TRANS table that this record related to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | CR_TRANS.SEQNO |
Attribute: HDR_SEQNO
Table | STOCK_REQUESTLINES |
Comment | The ID number of the stock transfer request that the line belongs to (from STOCK_REQUESTS). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | STOCK_REQUESTS.SEQNO |
Attribute: HDR_SEQNO
Table | DR_INVLINES |
Comment | The SEQNO of the record in the DR_TRANS table that this record related to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | DR_TRANS.SEQNO |
Attribute: HDR_SEQNO
Table | INWARDS_GOODS_LINES |
Comment | The ID number of the header Inwards Goods record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | INWARDS_GOODS.SEQNO |
Attribute: HIDDEN
Table | DR_INVLINES |
Comment | |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: HIDDEN_COST
Table | DR_INVLINES |
Comment | This 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 key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: HIDDEN_SELL
Table | DR_INVLINES |
Comment | This field applies to Bills of Materials. For kits that use pricing by components, this field stores header-level sell prices For builds that use individual stocklines, this fields stores the lines' real prices. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: HIDE_LINES
Table | BILLOMAT_HDR |
Comment | This field is set to 'Y' if the BOM's "Hide lines on reports" option is ticked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: HOMEPHONE
Table | STAFF |
Comment | The staff member's home telephone number. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: IGRLINESEQNO
Table | CR_INVLINES |
Comment | ID number of the Inwards Goods receipt line (if the source of the line is from Inwards Goods). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: IGRLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Inwards Goods line that the item is linked to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: IGRSEQNO
Table | STOCK_SERIALNOS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INC_FIFO_STOCKTAKE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: INC_FIFO_STOCKTAKE
Table | STOCK_TRANS |
Comment | Not supported. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: INSTOCK
Table | STOCK_SERIALNOS |
Comment | This field contains 'Y' if the serial number is in stock. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | Y |
Refers to | |
Attribute: INSTOCKQTY
Table | STOCKREQUIREMENT |
Comment | Physical stock. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTERCO_BATCH_DESC
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the batch description. |
Primary key | No |
Data type | VARCHAR(80) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: INTERCO_COMPANYNO
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the Company ID number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTERCO_CR_ACCNO
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the Creditor GL account number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTERCO_CR_BRANCHNO
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the Creditor branch number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTERCO_CR_SUBACCNO
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the Creditor GL sub-account number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTERCO_DR_ACCNO
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the Debtor GL account number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTERCO_DR_BRANCHNO
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the Debtor branch number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTERCO_DR_SUBACCNO
Table | CR_INVLINES |
Comment | This field only applies if EXO InterCompany is used. It contains the Debtor GL sub-account number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INTRANS_QUANT
Table | STOCK_REQUESTLINES |
Comment | The In Transit Qty on the line. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: INVNO
Table | DR_INVLINES |
Comment | The invoice number. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: INVNO
Table | CR_INVLINES |
Comment | The invoice number. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: INVOICED
Table | INWARDS_GOODS |
Comment | This field contains 'Y' if the receipt has been invoiced. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: INVOICE_NOW
Table | INWARDS_GOODS_COSTS |
Comment | |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INVSEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Debtors Invoice ID the item has been sold against. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: INV_AGE
Table | INWARDS_GOODS_LINES |
Comment | The invoice's age. This is calculated based on PERIOD_SEQNO. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: INV_COMPLETE
Table | INWARDS_GOODS_LINES |
Comment | This field contains 'Y' if the invoice is complete. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: INV_COST
Table | INWARDS_GOODS_COSTS |
Comment | The invoiced amount in local currency. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INV_COST
Table | INWARDS_GOODS_LINES |
Comment | The cost as on the related invoice, in local currency. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INV_EXCHRATE
Table | INWARDS_GOODS_LINES |
Comment | The exchange rate applicable to the invoice line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INV_EXCHRATE
Table | INWARDS_GOODS_COSTS |
Comment | The exchange rate applicable to the invoice. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INV_FC_COST
Table | INWARDS_GOODS_LINES |
Comment | The cost as on the related invoice. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INV_FC_COST
Table | INWARDS_GOODS_COSTS |
Comment | The invoiced amount in the currency of the supplier account. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: INV_QUANT
Table | INWARDS_GOODS_LINES |
Comment | The invoiced quantity on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: INV_TRANSDATE
Table | INWARDS_GOODS_LINES |
Comment | The transaction date of the invoice related to this line. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: INWARDS_GOODS_SEQNO
Table | INWARDS_GOODS_COSTS |
Comment | The ID number of the Inwards Goods header record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | INWARDS_GOODS.SEQNO |
Attribute: INWGLID
Table | INWARDS_GOODS_LINES |
Comment | An ID number for the inwards goods lines record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ISACTIVE
Table | STOCK_COLOUR |
Comment | This field contains 'Y' if the colour is currently active. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ISACTIVE
Table | STOCK_GROUPS |
Comment | This field contains 'Y' if the group is currently active. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ISACTIVE
Table | STOCKTAKE_CTRL |
Comment | This field contains 'Y' is the location is currently active. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: ISACTIVE
Table | STOCK_ITEMS |
Comment | If this field is set to 'Y', the stock item is active. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ISACTIVE
Table | STOCK_SIZE |
Comment | This field contains 'Y' if the size is currently active. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ISACTIVE
Table | GLACCS |
Comment | This field contains 'Y' if the GL account is active. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ISACTIVE
Table | STOCK_LOCATIONS |
Comment | This field contains 'Y' if the location is active. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ISACTIVE
Table | BILLOMAT_HDR |
Comment | This field contains 'Y' if the BOM is active; otherwise it is inactive. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: ISACTIVE
Table | STAFF |
Comment | This field is set to 'Y' if the staff member is currently active, i.e. if their Active flag is ticked in EXO Business Configurator. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ISASSIGNED
Table | STOCK_SERIALNOS |
Comment | N = 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 key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: IS_DEFAULT
Table | SUPPLIER_STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: IS_DISCOUNTABLE
Table | STOCK_ITEMS |
Comment | This field is set to 'Y' if the stock item is discountable. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | Y |
Refers to | |
Attribute: IS_SUPERVISOR
Table | STAFF |
Comment | This field is set to 'Y' if the staff member is designated as a supervisor, i.e. if their Has supervisory override authority flag is ticked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: IS_WIPLOCATION
Table | STOCK_LOCATIONS |
Comment | This field contains 'Y' if the location represents Work in Progress in EXO Job Costing. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: JOBCODE
Table | CR_INVLINES |
Comment | If the line originates from a job, the job's code is recorded in this field. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: JOBCODE
Table | DR_INVLINES |
Comment | If the line originates from a job, the job's code is recorded in this field. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: JOBLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the job line that the item is linked to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: JOBNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the job that the serial number belongs to (if there is one). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: JOBNO
Table | CR_INVLINES |
Comment | If the line originates from a job, the job's ID number is recorded in this field. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: JOBNO
Table | STOCK_TRANS |
Comment | Job Number if the stock movement sources from a job. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: JOBNO
Table | DR_INVLINES |
Comment | If the line originates from a job, the job's ID number is recorded in this field. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: JOBNO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: JOBNO
Table | INWARDS_GOODS_LINES |
Comment | If the order originates from a job, this field records the ID number of the job. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | JOBCOST_HDR.JOBNO |
Attribute: JOBTITLE
Table | STAFF |
Comment | The staff member's job title. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: JOB_CONTRACT_BILLINGS_SEQNO
Table | DR_INVLINES |
Comment | If 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 key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: KITCODE
Table | INWARDS_GOODS_LINES |
Comment | The ID code of the Bill of Materials on the line. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITCODE
Table | STOCK_TRANS |
Comment | Code of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITCODE
Table | STOCK_SERIALNOS |
Comment | |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITCODE
Table | DR_INVLINES |
Comment | The Bill of Materials code, if the line is part of a BOM. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITCODE
Table | CR_INVLINES |
Comment | The Bill of Materials code, if the line is part of a BOM. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITCODE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITID_SERIAL
Table | STOCK_SERIALNOS |
Comment | |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITSEQNO
Table | BILLOMAT_TEMP |
Comment | The ID number of the BOM. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: KITSEQNO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: KITSEQNO
Table | CR_INVLINES |
Comment | A Bill of Materials SEQNO used to group BOM lines together. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: KITSEQNO
Table | INWARDS_GOODS_LINES |
Comment | The ID number of the Bill of Materials on the line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: KITSEQNO
Table | STOCK_TRANS |
Comment | ID number of the Kit/Bill of Materials, if in this specific transaction, the stock item belonged to a Kit/BOM. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: KITSEQNO
Table | DR_INVLINES |
Comment | A Bill of Materials SEQNO used to group BOM lines together. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: KIT_TYPE
Table | BILLOMAT_HDR |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: LABEL_QTY
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 1 |
Refers to | |
Attribute: LASTINVSEQNO
Table | INWARDS_GOODS |
Comment | The ID number of the last invoice generated against the receipt. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: LASTMONTHUNITS
Table | STOCK_ITEMS |
Comment | Units of stock item sold in the previous month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LASTMONTHVALUE
Table | STOCK_ITEMS |
Comment | Sales value for the previous month for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LASTUPDATED
Table | STOCK_SERIALNOS |
Comment | The date and time when the record was last updated. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | Yes |
Default | getdate() |
Refers to | |
Attribute: LASTYEARUNITS
Table | STOCK_ITEMS |
Comment | Units of stock item sold in for the previous year. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LASTYEARVALUE
Table | STOCK_ITEMS |
Comment | Sales value for last year. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LAST_BAD_LOGIN
Table | STAFF |
Comment | The date and time when the staff member last attempted to log in but failed. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LAST_LOGIN
Table | STAFF |
Comment | The date and time when the staff member last successfully logged in. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LAST_UPDATE
Table | SUPPLIER_STOCK_ITEMS |
Comment | The date when the record was last updated (not set automatically - it must be specified on the Alternate Suppliers / Stock Codes window). |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LAST_UPDATED
Table | GLACCS |
Comment | The date and time when the GL account was last updated. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LAST_UPDATED
Table | STOCK_ITEMS |
Comment | Date and time when the stock item record was last updated. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LATESTCOST
Table | SUPPLIER_STOCK_ITEMS |
Comment | The supplier's latest cost for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LATESTCOST
Table | STOCK_ITEMS |
Comment | The stock item's Last Cost Price. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LCODE
Table | STOCK_LOCATIONS |
Comment | A short alphanumeric ID code for the location. |
Primary key | No |
Data type | VARCHAR(8) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LCOST
Table | INWARDS_GOODS_LINES |
Comment | The landed cost on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: LINETAX_OVERRIDDEN
Table | DR_INVLINES |
Comment | Contains 'Y' if the tax on the line has been manually modified. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINETAX_OVERRIDDEN
Table | CR_INVLINES |
Comment | Contains 'Y' if the tax on the line has been manually modified. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINETOTAL
Table | DR_INVLINES |
Comment | A computed field containing the total value for the line, excluding tax. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINETOTAL
Table | CR_INVLINES |
Comment | A computed field containing the total value for the line, excluding tax. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINETOTAL_INCTAX
Table | CR_INVLINES |
Comment | A computed field containing the total value for the line, including tax. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINETOTAL_INCTAX
Table | DR_INVLINES |
Comment | A computed field containing the total value for the line, including tax. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINETOTAL_TAX
Table | DR_INVLINES |
Comment | The tax total for the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LINETOTAL_TAX
Table | CR_INVLINES |
Comment | The tax total for the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LINETYPE
Table | INWARDS_GOODS_LINES |
Comment | The line type. Will be one of: 0 = Normal line 1 = BOM header 2 = BOM component 4 = Comment |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: LINETYPE
Table | CR_INVLINES |
Comment | This field indicates the type of line. Will be one of: 0 = Normal stock line 1 = BOM header line 2 = BOM component line 4 = Narrative line 5 = GL code |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: LINETYPE
Table | DR_INVLINES |
Comment | This 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 key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: LINETYPE
Table | STOCK_REQUESTLINES |
Comment | This 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 key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: LINE_SEQNO
Table | STOCK_TRANS |
Comment | For manual stock movements this field is NULL. For movements originating from other ledgers, this contains the Line ID of the source line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINE_SEQNO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINE_SOURCE
Table | DR_INVLINES |
Comment | The source SEQNO of the line, if it originated from a Sales Order or job. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINE_SOURCE
Table | CR_INVLINES |
Comment | The source SEQNO of the line, if it originated from a Sales Order or job. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKEDIN_TOKEN_KEY
Table | STAFF |
Comment | If the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token key is stored here. |
Primary key | No |
Data type | VARCHAR(max) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKEDIN_TOKEN_SECRET
Table | STAFF |
Comment | If the staff member uses their own LinkedIn account when using the EXO Business social media functions, their encrypted access token secret is stored here. |
Primary key | No |
Data type | VARCHAR(max) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKEDSTATUS
Table | INWARDS_GOODS_LINES |
Comment | S = Stock item, L = Lookup item. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: LINKEDSTATUS
Table | STOCK_REQUESTLINES |
Comment | Will be one of: S = Stocked L = Lookup N = Not applicable |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: LINKEDSTATUS
Table | DR_INVLINES |
Comment | Will be one of: S = Stocked L = Lookup N = Not applicable |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: LINKEDSTATUS
Table | CR_INVLINES |
Comment | Will be one of: S = Stocked L = Lookup N = Not applicable |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: LINKED_BILLCODE
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKED_QTY
Table | CR_INVLINES |
Comment | The physical stock unit quantity. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LINKED_QTY
Table | STOCK_REQUESTLINES |
Comment | The physical stock unit quantity. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKED_QTY
Table | INWARDS_GOODS_LINES |
Comment | The linked quantity on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LINKED_QTY
Table | DR_INVLINES |
Comment | The physical stock unit quantity. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKED_STOCKCODE
Table | STOCK_REQUESTLINES |
Comment | The physical stock unit. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKED_STOCKCODE
Table | INWARDS_GOODS_LINES |
Comment | The linked stock item code on the line. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKED_STOCKCODE
Table | DR_INVLINES |
Comment | The physical stock unit. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LINKED_STOCKCODE
Table | CR_INVLINES |
Comment | The physical stock unit. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LISTPRICE
Table | DR_INVLINES |
Comment | The original unit price for the Stock item on this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: LNAME
Table | STOCK_LOCATIONS |
Comment | A descriptive name for the location. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LOCATION
Table | CR_INVLINES |
Comment | The location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: LOCATION
Table | STOCKTAKE_TOTALS |
Comment | The ID number of the location where the stock was counted. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOCATION
Table | STOCK_TRANS |
Comment | ID number of the Location involved in the stock movement. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOCATION
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LOCATION
Table | DR_INVLINES |
Comment | The location that the Stock item will be moved out of. Generally, lines inherit the location from the invoice header. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: LOCATION
Table | STOCK_LOC_INFO |
Comment | The ID number of the location. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOCNAME
Table | STOCKTAKE_CTRL |
Comment | The name of the stock location. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: LOCNO
Table | STOCKTAKE_CTRL |
Comment | The ID number of the stock location. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOCNO
Table | STOCK_LOCATIONS |
Comment | A unique ID number for the location. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: LOCNO
Table | INWARDS_GOODS_LINES |
Comment | The ID of the location on the record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOCNO
Table | INWARDS_GOODS |
Comment | The ID number of the location on the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOCNO
Table | STOCK_SERIALNOS |
Comment | The location of the serialised stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOCNO
Table | STOCKREQUIREMENT |
Comment | The ID number of the stock item's location (from STOCK_LOCATIONS). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: LOGINID
Table | STAFF |
Comment | The staff member's login ID. This is the ID used to log in to the EXO Business system. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: LOOKUP_RECOVERABLE
Table | STOCK_ITEMS |
Comment | If this field contains 'Y', the stock item is a recoverable expense in EXO Job Costing. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: LOOKUP_RECOVERABLE
Table | STOCK_TRANS |
Comment | This field contains 'Y' if lookup items are recoverable against expenses in EXO Job Costing. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: LOST_QUANT
Table | STOCK_REQUESTLINES |
Comment | |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MAXSTOCK
Table | STOCK_LOC_INFO |
Comment | The maximum stock quantity for the stock code at the location. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MAXSTOCK
Table | STOCKREQUIREMENT |
Comment | The maximum stock level for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MAXSTOCK
Table | STOCK_ITEMS |
Comment | The maximum default stock level for each location. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MENU_NO
Table | STAFF |
Comment | The ID number of the Menu Definition specified for the staff member. Corresponds to the menu's SEQNO field in the MENU_COLLECTION table. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | MENU_COLLECTION.SEQNO |
Attribute: MINSTOCK
Table | STOCK_LOC_INFO |
Comment | The minimum stock quantity for the stock code at the location. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MINSTOCK
Table | STOCK_ITEMS |
Comment | The minimum default stock level for each location. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MINSTOCK
Table | STOCKREQUIREMENT |
Comment | The minimum stock level for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MOBILE_ACCESS
Table | STAFF |
Comment | This field contains 'Y' if the staff member is authorised to use the EXO OnTheGo mobile app. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: MONTHUNITS
Table | STOCK_ITEMS |
Comment | Sales totals in terms of quantity for the current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: MONTHVALUE
Table | STOCK_ITEMS |
Comment | Sales value for the current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: NAME
Table | GLACCS |
Comment | The account name. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NAME
Table | STAFF |
Comment | The staff member's full name. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NARRATIVE_SEQNO
Table | STOCK_TRANS_HDR |
Comment | ID of the narrative on the transaction (entered via manual stock movement). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NARRATIVE_SEQNO
Table | CR_INVLINES |
Comment | The SEQNO for the narrative on this line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | NARRATIVES.SEQNO |
Attribute: NARRATIVE_SEQNO
Table | DR_INVLINES |
Comment | The SEQNO for the narrative on this line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NARRATIVE_SEQNO
Table | STOCK_REQUESTS |
Comment | The ID number for the narrative on this request. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | NARRATIVES.SEQNO |
Attribute: NARRATIVE_SEQNO
Table | STOCK_REQUESTLINES |
Comment | The ID number for the narrative on this line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | NARRATIVES.SEQNO |
Attribute: NEW_AVECOST
Table | STOCK_TRANS |
Comment | Average cost of the item after this transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: NEW_LOC_QTY
Table | STOCK_TRANS |
Comment | Quantity of the item in the location the movement took place after this transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: NEW_QUANTITY
Table | STOCK_TRANS |
Comment | Stock on hand of the item after this transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: NEW_SEQORDER
Table | STOCK_TRANS |
Comment | New sequence order of the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: NICKNAME
Table | STAFF |
Comment | A short nickname for the employee. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NON_STOCK_AUTH_AMT
Table | STAFF |
Comment | The staff member's Non-Stock Purchase Order Authorisation Limit. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NOTES
Table | INWARDS_GOODS |
Comment | Any receipt notes on the transaction. |
Primary key | No |
Data type | VARCHAR(500) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NOTES
Table | BILLOMAT_HDR |
Comment | Any notes recorded for the BOM. |
Primary key | No |
Data type | VARCHAR(2048) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NOTES
Table | STOCK_ITEMS |
Comment | Any notes for the stock item. |
Primary key | No |
Data type | VARCHAR(4096) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NOTES
Table | GLACCS |
Comment | Any notes on the GL account. |
Primary key | No |
Data type | VARCHAR(4096) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: NUMDECIMALS
Table | STOCK_ITEMS |
Comment | The number of decimal places that can be entered for the stock item's quantity. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: NUM_CARTONS
Table | INWARDS_GOODS |
Comment | The number of cartons. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: NUNITPR
Table | DR_INVLINES |
Comment | A computed field containing the unit price, taking into account the discount on the line. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ON_COSTS
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: ON_COSTS
Table | STOCK_TRANS |
Comment | On costs (only applicable to lines sourcing from inwards goods receipts). |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: OPENINGBAL
Table | GLACCS |
Comment | The account's opening balance. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ORDERQTY
Table | DR_INVLINES |
Comment | The Order Qty from the Sales Order. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: ORIG_SEQNO
Table | STOCK_REQUESTS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: OUTPUT_CODE
Table | BILLOMAT_HDR |
Comment | Stock code of the BOM's output item. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PACK
Table | STOCK_ITEMS |
Comment | Describes the unit of sale for pricing, e.g. EACH or PACK. |
Primary key | No |
Data type | VARCHAR(10) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PACKREFERENCE
Table | SUPPLIER_STOCK_ITEMS |
Comment | An optional reference code for the pack. |
Primary key | No |
Data type | VARCHAR(20) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PACKSLIP
Table | INWARDS_GOODS |
Comment | The packing slip reference. |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PACK_SIZE
Table | STOCK_REQUESTLINES |
Comment | The pack size of the stock item on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PASSWORD_CHANGED
Table | STAFF |
Comment | The date and time when the staff member's password was last changed. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | Yes |
Default | getdate() |
Refers to | |
Attribute: PAYROLL_ID
Table | STAFF |
Comment | The staff member's Employee ID (Payroll) number. This field is used when EXO Business is integrating with an external payroll system, e.g. MYOB EXO Payroll. It must contain the employee's corresponding ID number in the payroll system. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PERIOD_SEQNO
Table | STOCK_TRANS_HDR |
Comment | ID number of the period that the record belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: PERIOD_SEQNO
Table | STOCK_TRANS |
Comment | ID number of the period the transaction belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | PERIOD_STATUS.SEQNO |
Attribute: PERIOD_SEQNO
Table | INWARDS_GOODS_COSTS |
Comment | The period ID of the invoice linked to this record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | PERIOD_STATUS.SEQNO |
Attribute: PERIOD_SEQNO
Table | INWARDS_GOODS_LINES |
Comment | The ID number of the period on the invoice linked to this record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | PERIOD_STATUS.SEQNO |
Attribute: PERIOD_TRADED_IN_SEQ
Table | STOCK_TRANS |
Comment | This field contains 'N' if the transaction was in a prior period. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: PHONE
Table | STAFF |
Comment | The staff member's work telephone number. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PICTURE_URL
Table | STOCK_WEB |
Comment | The URL of the picture to be displayed for the stock item. |
Primary key | No |
Data type | VARCHAR(80) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PLU
Table | STOCK_TRANS |
Comment | Price Lookup Unit (applies to lookup items). |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PLU
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: POSTTIME
Table | STOCK_TRANS |
Comment | A timestamp of when the record was entered. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: POSTTIME
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: POST_LOOKUP_TO_GL
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: POST_LOOKUP_TO_GL
Table | STOCK_TRANS |
Comment | If this field contains 'N' and the stock item is a lookup item, there is no journal against the transaction. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: POST_TO_GL
Table | STOCK_TRANS |
Comment | If this field is set to 'Y', the stock line is posted to GL; otherwise it is not. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: POST_TO_GL
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PO_INVLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The invoice line ID linked to the Purchase Order for the serial number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: PO_INVSEQNO
Table | STOCK_SERIALNOS |
Comment | The invoice ID linked to the Purchase Order for the serial number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: PO_LINE_NUM
Table | INWARDS_GOODS_LINES |
Comment | The ID number of the related Purchase Order line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | PURCHORD_LINES.SEQNO |
Attribute: PO_NUMBER
Table | INWARDS_GOODS_LINES |
Comment | The ID number of the related Purchase Order header. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | PURCHORD_HDR.SEQNO |
Attribute: PQTY
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: PREV_AVECOST
Table | STOCK_TRANS |
Comment | Average cost of the stock item before this transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PREV_AVECOST
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PREV_QUANTITY
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PREV_QUANTITY
Table | STOCK_TRANS |
Comment | Quantity of the stock item before the transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PRICEPERKG
Table | STOCK_ITEMS |
Comment | The stock item's sell price per kg. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PRICEQTY
Table | STOCK_ITEMS |
Comment | The stock item's sell price per quantity. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: PRICE_OVERRIDDEN
Table | DR_INVLINES |
Comment | Contains 'Y' if the price on the line has been manually modified. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: PRICING_MODE
Table | BILLOMAT_HDR |
Comment | How the output item is priced. 0 = Priced by total. 1 = Priced by components. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PRIVATE_ACC
Table | GLACCS |
Comment | This field is set to 'Y' if the GL account is a private account. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: PRODUCTLOCATION
Table | BILLOMAT_TEMP |
Comment | The location of the BOM product stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: PROFITVARIANCE
Table | STOCK_GROUPS |
Comment | The expected margin variance for the group. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PURCHORDLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Purchase Order line that the item is linked to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: PURCHORDNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Purchase Order that the item has been receipted in against. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: PURCHORDQTY
Table | STOCKREQUIREMENT |
Comment | Incoming stock. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PURCHPACKPRICE
Table | INWARDS_GOODS_LINES |
Comment | The purchase pack price on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: PURCHPACKPRICE
Table | SUPPLIER_STOCK_ITEMS |
Comment | The Pack Cost when purchasing the stock item from the supplier. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: PURCHPACKQUANT
Table | SUPPLIER_STOCK_ITEMS |
Comment | The Qty per Pack when purchasing the stock item from the supplier. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 1 |
Refers to | |
Attribute: PURCHPACKQUANT
Table | INWARDS_GOODS_LINES |
Comment | The purchase pack quantity on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 1 |
Refers to | |
Attribute: PURCHTAXRATE
Table | STOCK_ITEMS |
Comment | Default GST rate for purchase transactions. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: PURCH_GLSUBCODE
Table | STOCK_ITEMS |
Comment | The default GL sub-account code that purchase transactions for this stock item are posted to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PURCH_GLSUBCODE
Table | STOCK_GROUPS |
Comment | The code of the GL subaccount for Purchases Clearing. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: PURCH_GL_CODE
Table | STOCK_ITEMS |
Comment | The GL code that purchase transactions for this stock are posted to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | GLACCS.ACCNO |
Attribute: PURCH_GL_CODE
Table | STOCK_GROUPS |
Comment | The code of the GL account for Purchases Clearing. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | GLACCS.ACCNO |
Attribute: QTY
Table | STOCK_LOC_INFO |
Comment | The current stock quantity for the stock code at the location. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: QTY_TRADED_IN_NEG
Table | STOCK_TRANS |
Comment | Quantity traded when total stock on hand for the item was in negative at the time of the transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: QUANTITY
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: QUANTITY
Table | DR_INVLINES |
Comment | The quantity for this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: QUANTITY
Table | INWARDS_GOODS_LINES |
Comment | The receipt quantity on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: QUANTITY
Table | STOCK_TRANS |
Comment | Quantity of stock. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: QUANTITY
Table | CR_INVLINES |
Comment | The quantity for this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: QUANTITY
Table | BILLOMAT_LINES |
Comment | The quantity on this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 1 |
Refers to | |
Attribute: QUANTITY
Table | BILLOMAT_TEMP |
Comment | The quantity of the BOM component item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: RECEIPT_NO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: RECEIPT_NO
Table | STOCK_TRANS |
Comment | Receipt number when the source of the transaction is an Inwards Goods Receipt. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REF1
Table | STOCK_TRANS |
Comment | Source transaction reference. Usually contains the Debtor/Creditor's invoice number, Purchase Order number, Sales Order number, job number, etc. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REF1
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REF2
Table | STOCK_TRANS |
Comment | Reference text with details of source of this stock movement. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REF2
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REFERENCE
Table | STOCK_SERIALNOS |
Comment | A reference code for the record. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REFERENCE
Table | STOCK_TRANS_HDR |
Comment | Reference text for the transaction. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REFERENCECODE
Table | BILLOMAT_TEMP |
Comment | A reference code for the record. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: RELATED_SEQNO
Table | INWARDS_GOODS |
Comment | For reversals, this field contains the source Inwards Goods ID number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: REPORTCODE
Table | STOCK_GROUPS |
Comment | A report code for the group. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REPORTCODE
Table | STOCK_GROUP2S |
Comment | A report code for the group. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REPORTCODE
Table | GLACCS |
Comment | The report code used by the GL account. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: REPORTS_TO_STAFFNO
Table | STAFF |
Comment | The ID number of the staff member that this staff member reports to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: REQUESTLINESEQNO
Table | STOCK_SERIALNOS |
Comment | Stock request Line ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: REQUESTSEQNO
Table | STOCK_SERIALNOS |
Comment | Stock request ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: REQUEST_DATE
Table | STOCK_REQUESTS |
Comment | The date and time when the request was created. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: REQUIRE_DATE
Table | STOCK_REQUESTS |
Comment | The date and time that the request must be completed by. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: REQ_QUANT
Table | STOCK_REQUESTLINES |
Comment | The Requested Qty on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: RESTRICTED_ITEM
Table | STOCK_ITEMS |
Comment | This field is set to 'Y' if the stock item is a restricted item. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: REVERSALSTATUS
Table | INWARDS_GOODS |
Comment | The reversal status. Will be one of: 0 = Normal 1 = Reversed 2 = Reversal |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: REVERSED
Table | STOCK_TRANS |
Comment | This field contains 'Y' if the transaction has been reversed. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: REVERSED
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: RMALINESEQNO
Table | STOCK_SERIALNOS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: RMASEQNO
Table | STOCK_SERIALNOS |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SALES0
Table | STOCKREQUIREMENT |
Comment | Current month sales quantity for the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES1
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item for the month prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES10
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item ten months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES11
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item eleven months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES12
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item twelve months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES2
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item two months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES3
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item three months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES4
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item four months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES5
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item five months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES6
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item six months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES7
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item seven months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES8
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item eight months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES9
Table | STOCKREQUIREMENT |
Comment | Sales quantity for the stock item nine months prior to current month. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALESORDLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Sales Order line that the item is linked to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: SALESORDNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the Sales Order ID that the item has been committed against. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: SALESORDQTY
Table | STOCKREQUIREMENT |
Comment | Committed stock. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALESTAXRATE
Table | STOCK_ITEMS |
Comment | Default GST rate for sales transactions. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SALES_GLSUBCODE
Table | STOCK_GROUPS |
Comment | The code of the GL subaccount for Sales. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES_GLSUBCODE
Table | STOCK_ITEMS |
Comment | The default GL sub-account code that sales transactions for this stock item are posted to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SALES_GL_CODE
Table | STOCK_GROUPS |
Comment | The code of the GL account for Sales. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | GLACCS.ACCNO |
Attribute: SALES_GL_CODE
Table | STOCK_ITEMS |
Comment | The default GL code that sales transactions for this stock item are posted to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | GLACCS.ACCNO |
Attribute: SALES_HTML
Table | STOCK_WEB |
Comment | The Sales text (HTML) for the specified stock item. |
Primary key | No |
Data type | VARCHAR(4096) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SECTION
Table | GLACCS |
Comment | This field is set to 0 for Profit and loss accounts or 1 for Balance sheet accounts. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SECURITYPROFILEID
Table | STAFF |
Comment | The ID number of the staff member's Security profile. Corresponds to the profile's ID field in the PROFILE table. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: SELLPRICE1
Table | BILLOMAT_HDR |
Comment | Sell price 1. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE1
Table | STOCK_ITEMS |
Comment | Sell price 1. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE10
Table | BILLOMAT_HDR |
Comment | Sell price 10. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE10
Table | STOCK_ITEMS |
Comment | Sell price 10. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE2
Table | BILLOMAT_HDR |
Comment | Sell price 2. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE2
Table | STOCK_ITEMS |
Comment | Sell price 2. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE3
Table | BILLOMAT_HDR |
Comment | Sell price 3. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE3
Table | STOCK_ITEMS |
Comment | Sell price 3. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE4
Table | BILLOMAT_HDR |
Comment | Sell price 4. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE4
Table | STOCK_ITEMS |
Comment | Sell price 4. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE5
Table | BILLOMAT_HDR |
Comment | Sell price 5. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE5
Table | STOCK_ITEMS |
Comment | Sell price 5. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE6
Table | BILLOMAT_HDR |
Comment | Sell price 6. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE6
Table | STOCK_ITEMS |
Comment | Sell price 6. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE7
Table | BILLOMAT_HDR |
Comment | Sell price 7. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE7
Table | STOCK_ITEMS |
Comment | Sell price 7. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE8
Table | BILLOMAT_HDR |
Comment | Sell price 8. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE8
Table | STOCK_ITEMS |
Comment | Sell price 8. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE9
Table | BILLOMAT_HDR |
Comment | Sell price 9. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SELLPRICE9
Table | STOCK_ITEMS |
Comment | Sell price 9. |
Primary key | No |
Data type | AS |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SEND_NOW
Table | STOCK_REQUESTLINES |
Comment | The Send Now quantity on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SENT_QUANT
Table | STOCK_REQUESTLINES |
Comment | The Sent Qty on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SEQNO
Table | STOCKTAKE_TOTALS |
Comment | A unique ID number for the stocktake line. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | INWARDS_GOODS_LINES |
Comment | A unique ID number for the record. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | INWARDS_GOODS_COSTS |
Comment | A unique ID number for the record. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | CR_INVLINES |
Comment | A unique transaction line ID. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | BILLOMAT_TEMP |
Comment | A unique ID number for the record. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | DR_INVLINES |
Comment | A unique transaction ID. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | NARRATIVES.SEQNO |
Attribute: SEQNO
Table | INWARDS_GOODS |
Comment | A unique ID number for the transaction. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | STOCK_REQUESTLINES |
Comment | A unique ID number for the stock transfer request line. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | STOCK_SERIALNOS |
Comment | A unique ID number for the record. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | STOCK_TRANS |
Comment | A unique ID for the record. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | STOCK_REQUESTS |
Comment | A unique ID number for the transfer request |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | STOCK_REQUESTTYPES |
Comment | A unique ID number for the request type. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | STOCK_TRANS_HDR |
Comment | A unique ID for the record. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SEQNO
Table | BILLOMAT_LINES |
Comment | A unique ID number for the line. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SERIALNO
Table | STOCK_SERIALNOS |
Comment | The serial number assigned to the stock item. |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SERIALNO
Table | DR_INVLINES |
Comment | |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SERIALNO_TYPE
Table | STOCK_ITEMS |
Comment | How the stock item is serialised. Will be one of: 0 = Not Serialised 1 = Fully Tracked (In & Internal & Out) 2 = Creditor & Internal (In & Internal) 3 = Debtor Only (Out only) 4 = Creditor & Debtor (In & Out Only) 5 = Creditor Only (In Only) 6 = Internal & Debtor (Internal & Out only) 7 = Internal Only |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: SERIALNO_TYPE
Table | STOCKTAKE_TOTALS |
Comment | How the stock item is serialised. Will be one of: 0 = Not Serialised 1 = Fully Tracked (In & Internal & Out) 2 = Creditor & Internal (In & Internal) 3 = Debtor Only (Out only) 4 = Creditor & Debtor (In & Out Only) 5 = Creditor Only (In Only) 6 = Internal & Debtor (Internal & Out only) 7 = Internal Only |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_ITEMS.SERIALNO_TYPE |
Attribute: SESSION_ID
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SESSION_ID
Table | STOCK_TRANS |
Comment | Session ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SESSION_ID
Table | INWARDS_GOODS |
Comment | The session ID for the record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SHIPMENTNO
Table | INWARDS_GOODS_COSTS |
Comment | The shipment number on the record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SHIPMENTNO
Table | INWARDS_GOODS_LINES |
Comment | The shipment number on the record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: SHIPMENTNO
Table | INWARDS_GOODS |
Comment | The shipment number on the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: SHOWLINE
Table | CR_INVLINES |
Comment | This field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: SHOWLINE
Table | INWARDS_GOODS_LINES |
Comment | This field is used to control the visibility of the line on Clarity forms. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: SHOWLINE
Table | STOCK_REQUESTLINES |
Comment | This field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: SHOWLINE
Table | DR_INVLINES |
Comment | This field applies to Bills of Materials, and is used by Clarity to determine if the line can be printed. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: SIZECODE
Table | STOCK_SIZE |
Comment | A user-defined code number for the size. |
Primary key | No |
Data type | VARCHAR(5) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SIZEID
Table | STOCK_SIZE |
Comment | A unique ID number for the size. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SIZENAME
Table | STOCK_SIZE |
Comment | A descriptive name for the size. |
Primary key | No |
Data type | VARCHAR(30) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SMTP_SEQNO
Table | STAFF |
Comment | Where emails are sent via SMTP using the EXO Business Email Sender, this field contains the ID of the SMTP settings that apply to the staff member (SMTP_ACCOUNT.SEQNO). Set up via the SMTP Server Settings window. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SOLINEID
Table | STOCK_REQUESTLINES |
Comment | |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: SORTORDER
Table | STOCK_SIZE |
Comment | This field contains the sort order value, which is used to order sizes on the Style Picker window. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SORTORDER
Table | STOCK_COLOUR |
Comment | This field contains the sort order value, which is used to order colours on the Style Picker window. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SO_INVLINESEQNO
Table | STOCK_SERIALNOS |
Comment | The invoice line ID linked to the Sales Order for the serial number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: SO_INVSEQNO
Table | STOCK_SERIALNOS |
Comment | The invoice ID linked to the Sales Order for the serial number. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: SPREAD_TYPE
Table | INWARDS_GOODS_COSTS |
Comment | The spread type for on costs: 0 = Quantity 1 = Value 2 = Weight 3 = Cubic |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: STAFFNO
Table | STOCK_REQUESTS |
Comment | The ID number of the staff member assigned to the request. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STAFF.STAFFNO |
Attribute: STAFFNO
Table | STAFF |
Comment | A unique identifier for the staff record. |
Primary key | Yes |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: STAFFNO
Table | BILLOMAT_TEMP |
Comment | The ID number of the staff member on the record. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | STAFF.STAFFNO |
Attribute: STAFFNO
Table | STOCK_TRANS_HDR |
Comment | ID number of the staff member who entered the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STAFF.STAFFNO |
Attribute: STATUS
Table | STOCK_GROUPS |
Comment | This field contains 'Y' if the 'Display on website option' for the group is ticked. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: STATUS
Table | STOCK_GROUP2S |
Comment | This field contains 'Y' if the 'Display on website option' for the group is ticked. |
Primary key | No |
Data type | VARCHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: STATUS
Table | STOCK_REQUESTS |
Comment | The status of the stock transfer. Will be one of: 0 = New Request 1 = Picking 2 = In Transit 3 = Complete |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: STATUS
Table | STOCK_ITEMS |
Comment | The stock item's status. Will be one of: S = Stock item L = Lookup item |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | L |
Refers to | |
Attribute: STDCOST
Table | STOCK_ITEMS |
Comment | The stock item's standard cost. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: STKMOVLINESEQNO
Table | STOCK_SERIALNOS |
Comment | Stock transaction ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: STKMOVSEQNO
Table | STOCK_SERIALNOS |
Comment | Stock transaction header ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: STOCKCODE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: STOCKCODE
Table | STOCKREQUIREMENT |
Comment | The stock item's ID code. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | STOCK_SERIALNOS |
Comment | The stock code of the serialised stock item. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | BILLOMAT_TEMP |
Comment | The stock code of the BOM component item. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | STOCK_ITEMS |
Comment | A unique ID code for the stock item. |
Primary key | Yes |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: STOCKCODE
Table | BILLOMAT_LINES |
Comment | The stock code of the stock item on this line. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | CR_INVLINES |
Comment | Code of the Stock item on this line. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | STOCK_WEB |
Comment | The stock code of the stock item that this record applies to. |
Primary key | No |
Data type | CHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | INWARDS_GOODS_LINES |
Comment | The stock code of the stock item on the line. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | DR_INVLINES |
Comment | Code of the Stock item on this line. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | STOCKTAKE_TOTALS |
Comment | The ID code of the stock item being counted. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | STOCK_REQUESTLINES |
Comment | The ID code of the stock item on the line. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | STOCK_LOC_INFO |
Comment | The unique ID code of the stock item. |
Primary key | Yes |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | SUPPLIER_STOCK_ITEMS |
Comment | The stock item's ID code in EXO Business. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKCODE
Table | STOCK_TRANS |
Comment | The ID code of the stock item. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_ITEMS.STOCKCODE |
Attribute: STOCKGROUP
Table | STOCKREQUIREMENT |
Comment | The ID number of the stock item's Primary Stock Group. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_GROUPS.GROUPNO |
Attribute: STOCKGROUP
Table | STOCK_ITEMS |
Comment | The Primary (Fine) Stock Group that the item belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_GROUPS.GROUPNO |
Attribute: STOCKGROUP
Table | STOCKTAKE_TOTALS |
Comment | The Stock Group that the stock item belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_GROUPS.GROUPNO |
Attribute: STOCKGROUP2
Table | STOCKTAKE_TOTALS |
Comment | The Alternative Stock Group |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_GROUP2S.GROUPNO |
Attribute: STOCKGROUP2
Table | STOCK_ITEMS |
Comment | The stock item's Secondary (Coarse) Stock Group. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_GROUP2S.GROUPNO |
Attribute: STOCKGROUP2_REPC
Table | STOCKTAKE_TOTALS |
Comment | The report code of the stock item's Secondary Stock Group. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_GROUP2S.REPORTCODE |
Attribute: STOCKGROUP_REPC
Table | STOCKTAKE_TOTALS |
Comment | The report code of the stock item's Primary Stock Group. |
Primary key | No |
Data type | VARCHAR(15) |
Domain name | |
Not NULL | No |
Default | |
Refers to | STOCK_GROUPS.REPORTCODE |
Attribute: STOCKINSEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the stock transaction that the item was receipted in against. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: STOCKOUTSEQNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the stock transaction against which the item was moved out of inventory. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: STOCKPRICEGROUP
Table | STOCK_ITEMS |
Comment | The price group that the stock item belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_PRICEGROUPS.GROUPNO |
Attribute: STOCK_AUTH_AMT
Table | STAFF |
Comment | The staff member's Stock Purchase Order Authorisation Limit. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: STOCK_CLASSIFICATION
Table | STOCK_ITEMS |
Comment | The stock classification that the item belongs to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | STOCK_CLASSIFICATIONS.CLASSNO |
Attribute: SUBCODE
Table | DR_INVLINES |
Comment | The GL subaccount code on the line. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SUPPLIERCODE
Table | INWARDS_GOODS_LINES |
Comment | The supplier code on the line. |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SUPPLIERCODE
Table | SUPPLIER_STOCK_ITEMS |
Comment | The supplier's ID code for the stock item. |
Primary key | Yes |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: SUPPLIERCOST
Table | STOCK_ITEMS |
Comment | The supplier cost price. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: SUPPLIERNAME
Table | INWARDS_GOODS |
Comment | The name of the supplier on the transaction. |
Primary key | No |
Data type | VARCHAR(70) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SUPPLIERNO
Table | STOCK_ITEMS |
Comment | The ID number (CR_ACCS.ACCNO) of the stock item's main supplier. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | CR_ACCS.ACCNO |
Attribute: SUPPLIERNO
Table | INWARDS_GOODS |
Comment | The ID number of the supplier (Creditor) account. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | CR_ACCS.ACCNO |
Attribute: SUPPLIERNO
Table | STOCKTAKE_TOTALS |
Comment | The ID number of the Creditor who supplies the stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SUPPLIERNO2
Table | STOCK_ITEMS |
Comment | Alternate supplier for the stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SUPPLIERNO3
Table | STOCK_ITEMS |
Comment | Alternate supplier for the stock item. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SUPPLIERREF
Table | INWARDS_GOODS |
Comment | The shipping reference on the transaction. |
Primary key | No |
Data type | VARCHAR(50) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: SUP_NOW
Table | STOCK_REQUESTLINES |
Comment | The Receive Now quantity on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SUP_QUANT
Table | STOCK_REQUESTLINES |
Comment | The Received Qty on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: SU_SEQNO
Table | STOCK_SERIALNOS |
Comment | Serviceable Unit ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SWATCHID
Table | STOCK_COLOUR |
Comment | The colour value of the colour record's swatch. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: SYSTEMQTY
Table | STOCKTAKE_TOTALS |
Comment | The quantity recorded in the EXO Business system for the item at this location. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: TAXRATE
Table | DR_INVLINES |
Comment | The percentage tax rate on the line at the time of the transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TAXRATE
Table | CR_INVLINES |
Comment | The percentage tax rate on the line at the time of the transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TAXRATE_NO
Table | DR_INVLINES |
Comment | The ID number of the tax rate used by the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | TAX_RATES.SEQNO |
Attribute: TAXRATE_NO
Table | CR_INVLINES |
Comment | The ID number of the tax rate used by the transaction. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | TAX_RATES.SEQNO |
Attribute: TAXSTATUS
Table | GLACCS |
Comment | The Override GST rate specified for the GL account. A value of -1 corresponds to the AUTO SELECT RATE option. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: TIME_COUNTSHEETS
Table | STOCKTAKE_CTRL |
Comment | The date and time when count sheets were printed for the location. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TIME_INITIALISED
Table | STOCKTAKE_CTRL |
Comment | The date and time when the location was initialised for stocktake. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TIME_KEYED
Table | STOCKTAKE_CTRL |
Comment | The date and time when counted quantities were keyed for the location. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TIME_UPLOADED
Table | STOCKTAKE_CTRL |
Comment | The date and time when stock transactions were uploaded to the Stock ledger. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TOLOCATION
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TOLOCATION
Table | STOCK_TRANS |
Comment | ID of the Destination location (applies in case of stock transfers). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_LOCATIONS.LOCNO |
Attribute: TOTALSTOCK
Table | STOCK_ITEMS |
Comment | Total units of stock for the item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: TO_LOC
Table | STOCK_REQUESTS |
Comment | The ID number of the location that stock is to be transferred to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: TRANSDATE
Table | DR_INVLINES |
Comment | The date of the transaction. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: TRANSDATE
Table | INWARDS_GOODS_COSTS |
Comment | The transaction date of the invoice linked to this record. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: TRANSDATE
Table | INWARDS_GOODS |
Comment | The transaction date. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: TRANSDATE
Table | STOCK_TRANS_HDR |
Comment | The date and time when the transaction took place. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: TRANSDATE
Table | BILLOMAT_TEMP |
Comment | The date and time when the transaction occurred. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TRANSDATE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TRANSDATE
Table | STOCK_TRANS |
Comment | The date when the stock movement took place. |
Primary key | No |
Data type | DATETIME |
Domain name | |
Not NULL | No |
Default | getdate() |
Refers to | |
Attribute: TRANSTYPE
Table | STOCK_TRANS_HDR |
Comment | The transaction type. Will be one of: 0=Sales 1=Receipt 2=Transfer 3=Adjust Out 4=Adjust In 5=Average Cost Adjustment |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | |
Refers to | |
Attribute: TRANSTYPE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TRANSTYPE
Table | STOCK_TRANS |
Comment | The 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 key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: TRANSTYPE
Table | STOCK_REQUESTS |
Comment | The ID number of the Stock Request Type (from STOCK_REQUESTTYPES). |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | STOCK_REQUESTTYPES.SEQNO |
Attribute: TWITTER_TOKEN_KEY
Table | STAFF |
Comment | If the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token key is stored here. |
Primary key | No |
Data type | VARCHAR(max) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: TWITTER_TOKEN_SECRET
Table | STAFF |
Comment | If the staff member uses their own Twitter account when using the EXO Business social media functions, their encrypted access token secret is stored here. |
Primary key | No |
Data type | VARCHAR(max) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: UNITCOST
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: UNITCOST
Table | STOCK_TRANS |
Comment | The unit cost price of the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: UNITCOST
Table | DR_INVLINES |
Comment | The unit cost of the Stock item on this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UNITCOST
Table | STOCKTAKE_TOTALS |
Comment | The 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 key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UNITNO
Table | STOCK_SERIALNOS |
Comment | The ID number of the serviceable unit that the item is linked to. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | -1 |
Refers to | |
Attribute: UNITPRICE
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: UNITPRICE
Table | STOCK_TRANS |
Comment | Unit price of the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UNITPRICE
Table | INWARDS_GOODS_LINES |
Comment | The unit price of the stock item on the line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UNITPRICE
Table | CR_INVLINES |
Comment | The unit price of the Stock item on this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UNITPRICE
Table | BILLOMAT_TEMP |
Comment | The unit price of the BOM component item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: UNITPRICE
Table | DR_INVLINES |
Comment | The unit price of the Stock item on this line. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UNITPRICE_INCTAX
Table | CR_INVLINES |
Comment | The unit price of the Stock item on this line, inclusive of tax. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UNITPRICE_INCTAX
Table | DR_INVLINES |
Comment | The unit price of the Stock item on this line, inclusive of tax. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UPDATEITEM_CODE
Table | STOCK_ITEMS |
Comment | Only applies to lookup items. The ID number of the stocked item that maintains the actual stock. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: UPDATEITEM_FLAG
Table | STOCK_TRANS |
Comment | This 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 key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | Y |
Refers to | |
Attribute: UPDATEITEM_FLAG
Table | STOCK_TRANS_ARCHIVE |
Comment | See STOCK_TRANS. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: UPDATEITEM_QTY
Table | STOCK_ITEMS |
Comment | Only applies to lookup items. Quantity of the stocked item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: UPDATE_STOCK
Table | CR_INVLINES |
Comment | If this field is set to 'Y', stock movements are created via the trigger CR_INVLINES_POST. The field is then set to 'T'. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: UPDATE_STOCK
Table | DR_INVLINES |
Comment | If this field is set to 'Y', stock movements are created via the trigger DR_INVLINES_POST. The field is then set to 'T'. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | |
Attribute: USERPROFILEID
Table | STAFF |
Comment | The ID number of the staff member's User profile. Corresponds to the profile's ID field in the PROFILE table. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | Yes |
Default | 0 |
Refers to | |
Attribute: USESUBCODES
Table | GLACCS |
Comment | Not used. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: VALUE_TRADED_IN_NEG
Table | STOCK_TRANS |
Comment | Value traded when total stock on hand for the item was in negative at the time of the transaction. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: VARIABLECOST
Table | STOCK_ITEMS |
Comment | The field is set to 'Y for Variable Cost stock items. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | Yes |
Default | N |
Refers to | |
Attribute: VARIANCE
Table | STOCKTAKE_TOTALS |
Comment | The difference between the system quantity and the counted quantity. Populated automatically when the Stocktake Variance Report is run for the Stock Take utility. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: VARIANTLINE
Table | BILLOMAT_LINES |
Comment | This field contains 'Y' if the line is not included in the BOM by default. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: VAR_GLPOSTED
Table | INWARDS_GOODS_LINES |
Comment | This field contains 'Y' if variance has been posted against this line. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: VIRTSTOCK
Table | STOCKREQUIREMENT |
Comment | Free stock taking into account the incoming and committed stock. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: WASTAGE
Table | BILLOMAT_HDR |
Comment | The BOM's Overhead Allocation percentage. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: WEB_SHOW
Table | STOCK_ITEMS |
Comment | |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: WEIGHT
Table | STOCK_ITEMS |
Comment | Physical weight of the stock item. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: WORKSORDLINESEQNO
Table | STOCK_SERIALNOS |
Comment | Works Order Line ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: WORKSORDSEQNO
Table | STOCK_SERIALNOS |
Comment | Works order ID |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | -1 |
Refers to | |
Attribute: X_BINCODE
Table | STOCK_GROUPS |
Comment | The bin code for the style. |
Primary key | No |
Data type | VARCHAR(12) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: X_COLOURID
Table | STOCK_ITEMS |
Comment | Style colour ID of the stock item. Used by the Style, Size Colour functionality. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_COLOURIDS
Table | STOCK_GROUPS |
Comment | This field contains a comma-separated list of colour IDs applicable to the style. |
Primary key | No |
Data type | VARCHAR(255) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: X_DESCRIPTION_FORMULA
Table | STOCK_GROUPS |
Comment | The stock item description formula for the group. |
Primary key | No |
Data type | VARCHAR(40) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: X_ISSTYLE
Table | STOCK_GROUPS |
Comment | This field contains 'Y' if the group is a style. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | N |
Refers to | |
Attribute: X_MAXSTOCK
Table | STOCK_GROUPS |
Comment | The maximum stock level for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_MINSTOCK
Table | STOCK_GROUPS |
Comment | The minimum stock level for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_PRICEGROUP
Table | STOCK_GROUPS |
Comment | This field contains 'Y' if the style has a matching Price Group. |
Primary key | No |
Data type | CHAR(1) |
Domain name | |
Not NULL | No |
Default | Y |
Refers to | STOCK_PRICEGROUPS.GROUPNO |
Attribute: X_SELLPRICE1
Table | STOCK_GROUPS |
Comment | Sell price 1 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE10
Table | STOCK_GROUPS |
Comment | Sell price 10 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE2
Table | STOCK_GROUPS |
Comment | Sell price 2 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE3
Table | STOCK_GROUPS |
Comment | Sell price 3 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE4
Table | STOCK_GROUPS |
Comment | Sell price 4 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE5
Table | STOCK_GROUPS |
Comment | Sell price 5 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE6
Table | STOCK_GROUPS |
Comment | Sell price 6 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE7
Table | STOCK_GROUPS |
Comment | Sell price 7 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE8
Table | STOCK_GROUPS |
Comment | Sell price 8 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SELLPRICE9
Table | STOCK_GROUPS |
Comment | Sell price 9 for the style. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SIZEID
Table | STOCK_ITEMS |
Comment | Style size ID of the stock item. Used by the Style, Size Colour functionality. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SIZEIDS
Table | STOCK_GROUPS |
Comment | This field contains a comma-separated list of size IDs applicable to the style. |
Primary key | No |
Data type | VARCHAR(255) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: X_STOCKCODE_FORMULA
Table | STOCK_GROUPS |
Comment | The stock item code formula for the group. |
Primary key | No |
Data type | VARCHAR(23) |
Domain name | |
Not NULL | No |
Default | |
Refers to | |
Attribute: X_SUPPLIERCOST
Table | STOCK_GROUPS |
Comment | The supplier cost in the currency of the supplier account. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: X_SUPPLIERNO
Table | STOCK_GROUPS |
Comment | The ID number of the main supplier of the style. |
Primary key | No |
Data type | INTEGER |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: YEARUNITS
Table | STOCK_ITEMS |
Comment | Year to date sales totals in terms of quantity. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
Attribute: YEARVALUE
Table | STOCK_ITEMS |
Comment | Sales value for the current year. |
Primary key | No |
Data type | FLOAT(53) |
Domain name | |
Not NULL | No |
Default | 0 |
Refers to | |
|