MYOB Exo Business Debtors

Attribute details

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	DR_ACCGROUPS
Comment	A unique ID for the Primary Debtor Group.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: ACCGROUP

Table	DR_ACCGROUP2S
Comment	A unique ID for the Secondary Debtor Group.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: ACCGROUP

Table	DR_ACCS
Comment	The Debtor's primary Debtor Account Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	DR_ACCGROUPS.ACCGROUP

Attribute: ACCGROUP

Table	DR_PRICES
Comment	The Debtors Account Group that the price rule belongs to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to	DR_ACCGROUPS.ACCGROUP

Attribute: ACCGROUP

Table	DR_PRICE_POLICY_ACC
Comment	The relevant Debtor account group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	DR_ACCGROUPS.ACCGROUP

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: ACCGROUP2

Table	DR_ACCS
Comment	The Debtor's secondary Debtor Account Group.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	DR_ACCGROUP2S.ACCGROUP

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	DR_CONT_HIST
Comment	The ID number of the Debtor account that the History Note is attached to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	-1
Refers to	DR_ACCS.ACCNO

Attribute: ACCNO

Table	DR_TRANS
Comment	The ID number of the Debtor account against which the transaction was generated. If the transaction is against a branch account, this field is set to the head account's ACCNO.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	DR_ACCS.ACCNO

Attribute: ACCNO

Table	DR_PRICES
Comment	The Debtor account that the price rule is defined for. Has the value -1 if the price rule belongs to a generic price policy.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	DR_ACCS.ACCNO

Attribute: ACCNO

Table	DR_PRICE_POLICY_ACC
Comment	The relevant Debtor account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	DR_ACCS.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	DR_CONTACTS
Comment	The account number of the Debtor account that the Contact is associated with.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	DR_ACCS.ACCNO

Attribute: ACCNO

Table	DR_ADDRESSES
Comment	The account number of the Debtor record that the address applies to.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to	DR_ACCS.ACCNO

Attribute: ACCNO

Table	SALESORD_HDR
Comment	The ID number of the Debtor account that the Sales Order was created for.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	DR_INVLINES.ACCNO

Attribute: ACCNO

Table	DR_ACCS
Comment	The unique ID number for the Debtor account.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
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: ACC_MASK

Table	PAYMENT_TYPES
Comment
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: ACTIONDUEDATE

Table	DR_CONT_HIST
Comment	This field is used by the Serviceable Units add-on module - it is not set from the Debtors UI.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
Refers to

Attribute: ACTIONSTATUS

Table	DR_CONT_HIST
Comment	This field is used by the Serviceable Units add-on module - it is not set from the Debtors UI.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ACTIVATION_DATE

Table	SALESORD_HDR
Comment	The date and time when the Sales Order was activated.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default
Refers to

Attribute: ACTIVE_CR

Table	PAYMENT_TYPES
Comment	This field is ticked if the Payment Type is active for Creditors, i.e. if its "Active for creditors" flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: ACTIVE_DR

Table	PAYMENT_TYPES
Comment	This field is ticked if the Payment Type is active for Debtors, i.e. if its "Active for debtors" flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: ACTIVE_POS

Table	PAYMENT_TYPES
Comment	This field is ticked if the Payment Type is active for the EXO POS module, i.e. if its "Active for POS" flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: ADDRESS1

Table	CONTACTS
Comment	Postal address line 1.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS1

Table	DR_ACCS
Comment	Postal address line 1.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS1

Table	DR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS1

Table	SALESORD_HDR
Comment	Delivery address line 1.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS2

Table	DR_ACCS
Comment	Postal address line 2.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS2

Table	SALESORD_HDR
Comment	Delivery address line 2.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS2

Table	DR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS2

Table	CONTACTS
Comment	Postal address line 2.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS3

Table	SALESORD_HDR
Comment	Delivery address line 3.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS3

Table	DR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS3

Table	CONTACTS
Comment	Postal address line 3.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS3

Table	DR_ACCS
Comment	Postal address line 3.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS4

Table	DR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS4

Table	DR_ACCS
Comment	Postal address line 4
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS4

Table	SALESORD_HDR
Comment	Delivery address line 4.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS4

Table	CONTACTS
Comment	Postal address line 4.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS5

Table	DR_ACCS
Comment	Postal address line 5. This line is only available on the Debtor Account Details screen if the Additional Postal Address Row profile setting is enabled.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS5

Table	CONTACTS
Comment	Postal address line 5. This line is only available on the Contacts window if the Additional Postal Address Row profile setting is enabled.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS5

Table	SALESORD_HDR
Comment	Delivery address line 5.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS5

Table	DR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADDRESS6

Table	SALESORD_HDR
Comment	Delivery address line 6.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
Refers to

Attribute: ADVERTSOURCE

Table	DR_CONTACTS
Comment	Taken from the associated record in the CONTACTS table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ADVERTSOURCE

Table	CONTACTS
Comment	The Contact's Advertising Source - corresponds to the SEQNO of the type in the ADVERT_TYPES table.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to	ADVERT_TYPES.SEQNO

Attribute: AGE

Table	PERIOD_STATUS
Comment	The age of the period. The current period has an age of 0.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	0
Refers to

Attribute: AGE

Table	DR_ALLOCATIONS
Comment	The allocation'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

Table	DR_TRANS
Comment	The transaction's age. This is calculated based on PERIOD_SEQNO.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: AGEDBAL0

Table	DR_ACCS
Comment	Aged Balance for the current month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AGEDBAL1

Table	DR_ACCS
Comment	Aged Balance for the previous month.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AGEDBAL2

Table	DR_ACCS
Comment	Aged Balance for two months back.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AGEDBAL3

Table	DR_ACCS
Comment	Aged Balance for three months back.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AGE_STAMP

Table	DR_ALLOCATIONS
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	DR_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: ALERT

Table	DR_ACCS
Comment	Pop-up alert text to display when dealing with the Debtor.
Primary key	No
Data type	VARCHAR(60)
Domain name
Not NULL	No
Default
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: ALERTPC

Table	CURRENCIES
Comment	The % Change Alert for the currency - when editing currencies, the user will be alerted if the currency is changed by a percentage greater than this.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	5
Refers to

Attribute: ALLOCAGE

Table	DR_TRANS
Comment	The age in which the transaction was allocated.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALLOCATED

Table	DR_TRANS
Comment	0 = Unallocated or partially allocated. 1 = Allocated in the current period. 2 = Allocated in any prior period.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALLOCATEDBAL

Table	DR_TRANS
Comment	The amount that has been allocated.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ALLOCNO

Table	DR_ALLOCATIONS
Comment	A unique ID number for the allocation set.
Primary key	Yes
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to

Attribute: ALLOCTIME

Table	DR_ALLOCATIONS
Comment	The date and time of the allocation.
Primary key	No
Data type	DATETIME
Domain name
Not NULL	No
Default	getdate()
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: ALLOW_RESTRICTED_STOCK

Table	DR_ACCS
Comment	If 'Y', it is possible to sell stock items that have been flagged as restricted goods to this Debtor. If the profile setting "Use customised customer stock restrictions logic" (CUSTOM_STOCK_RESTRICTION) is enabled, a custom function (FN_RESTRICTED_ITEM) is used instead of this field.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	Yes
Default	Y
Refers to

Attribute: ALPHACODE

Table	DR_ACCS
Comment	A non-unique alphanumeric ID code for the Debtor. Can be used for sorting accounts alphabetically, e.g. give "The Warehouse" the code "WARE" to sort under W instead of T. Sometimes used as an alternate account reference.
Primary key	No
Data type	VARCHAR(15)
Domain name
Not NULL	No
Default
Refers to

Attribute: AMOUNT

Table	DR_TRANS
Comment	The amount of the transaction, including tax, in the currency of the Debtor account.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
Refers to

Attribute: AMOUNT

Table	OPPORTUNITY
Comment	The quote value for the Opportunity.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AMOUNT

Table	DR_ALLOCATIONS
Comment	The amount allocated.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: ANALYSIS

Table	DR_TRANS
Comment	For payments, this field holds the payment type.
Primary key	No
Data type	VARCHAR(12)
Domain name
Not NULL	No
Default
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: 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_BY

Table	OPPORTUNITY
Comment	The ID of the staff member who assigned the Opportunity.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: ASSIGNED_TO

Table	OPPORTUNITY
Comment	The ID of the staff member to whom the Opportunity has been assigned.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
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: AUTOBILLCODE

Table	DR_ACCS
Comment	The Bill of Materials (Order Template) used by the Debtor.
Primary key	No
Data type	VARCHAR(23)
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: AVERAGE_RATE

Table	CURRENCIES
Comment	This field relates to the Intercompany module.
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: AVE_DAYS_TO_PAY

Table	DR_ACCS
Comment	Average Debtor days, calculated by the Stored Procedure DR_CR_ALLOCATION_AVE_DAYS_SP every time you access the Analysis tab.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default	-1
Refers to

Attribute: BACKORDER

Table	SALESORD_HDR
Comment	Set to 'Y' if the Sales Order is on back order.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BAD_CHEQUE

Table	DR_ACCS
Comment	If 'Y', cheques are not accepted from the Debtor. Set by the "Do Not Accept Cheque" flag on the Details 2 tab.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
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

Table	DR_ACCS
Comment	Current balance.
Primary key	No
Data type	AS
Domain name
Not NULL	No
Default
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: BANK

Table	DR_ACCS
Comment	The Bank detail from the last update of a payment header. Populated via right-clicking on a payment on the Transactions tab and selecting Edit Ref Field. This option is only available if the profile setting "Permitted level of access to debtor transaction editing" (EDITDRTRANS) is set to allow transaction editing.
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BANKACCNAME

Table	DR_TRANS
Comment
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BANKACCNO

Table	DR_TRANS
Comment
Primary key	No
Data type	VARCHAR(20)
Domain name
Not NULL	No
Default
Refers to

Attribute: BANKFEE

Table	PAYMENT_TYPES
Comment	This value is set to 'Y' if the Payment Type's "Apply payment group bank fee" flag is ticked.
Primary key	No
Data type	CHAR(1)
Domain name
Not NULL	No
Default	N
Refers to

Attribute: BANKFEED_REFRESHTOKEN

Table	STAFF
Comment	Encrypted OAuth refresh token used for Bank Feeds.
Primary key	No
Data type	VARCHAR(500)
Domain name
Not NULL	No
Default
Refers to

Attribute: BANK_ACCOUNT

Table	DR_ACCS
Comment	The Debtor's bank account number, used for Direct Debit payments.
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: BANK_ACC_NAME

Table	DR_ACCS
Comment	The Debtor's bank account name, used for Direct Debit payments.
Primary key	No
Data type	VARCHAR(40)
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: BASE

Table	TAX_RATES
Comment
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
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: BATCHNO

Table	DR_TRANS
Comment	If the transaction was a part of a Debtors receipt batch, the batch number is stored here.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
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: 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: 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	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: BRANCH

Table	DR_ACCS
Comment	The Branch detail from the last update of a payment header. Populated via right-clicking on a payment on the Transactions tab and selecting Edit Ref Field. This option is only available if the profile setting "Permitted level of access to debtor transaction editing" (EDITDRTRANS) is set to allow transaction editing.
Primary key	No
Data type	VARCHAR(30)
Domain name
Not NULL	No
Default
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: BRANCHNO

Table	SALESORD_HDR
Comment	The Branch number on the Sales Order.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BRANCHNO

Table	DR_TRANS
Comment	The branch ID number.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default	0
Refers to

Attribute: BRANCHNO

Table	DR_ACCS
Comment	Branch number - only used by specific sites.
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: BRANCH_ACCNO

Table	DR_TRANS
Comment	Only used in head account/branch account scenarios. This field contains the account number of the branch account.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	No
Default
Refers to

Attribute: BSBNO

Table	DR_ACCS
Comment	The Debtor's Bank State Branch number (Australian databases only).
Primary key	No
Data type	VARCHAR(40)
Domain name
Not NULL	No
Default
Refers to

Attribute: BUYRATE

Table	CURRENCIES
Comment	The buy rate (for purchases).
Primary key	No
Data type	FLOAT(53)
Domain name
Not NULL	No
Default	0
Refers to

Attribute: CAMPAIGN_SEQNO

Table	CAMPAIGN_WAVE
Comment	The ID number of the campaign that the campaign wave is part of.
Primary key	No
Data type	INTEGER
Domain name
Not NULL	Yes
Default
Refers to	CAMPAIGN.SEQNO