Update Include in Lookups on Chart of Accounts

Providing that your include in lookups are laid out like this, the combinations below will apply.
Sales
Inventory
Purchasing
Payroll

Combination	SQL Value
NNNN	0X0
XNNN	0X1
NXNN	0X2
XXNN	0X3
NNXN	0X4
XNXN	0X5
NXXN	0X6
XXXN	0X7
NNNX	0X8
XNNX	0X9
NXNX	0XA
XXNX	0XB
NNXX	0XC
XNXX	0XD
NXXX	0XE
XXXX	0XF

Have the combination matched to each account.

Import the chart of accounts to the system.

Extract the chart of accounts after upload including the account index.

Use the following script and update in SQL it must include same spaces and apostrophe as seen below.

update GL00100 Set dsplkups =0x4 where actindx ='1'