On Nov. 11, Dale mentioned a Taxable column in the MasterAccounts table
that was to be used in version 2.5. He also gave the code to implement the
adding of the column to currently existing versions. I have implemented
the column but was wondering what will the be values in the column for
taxable and non-taxable. Will it be 1 for tax and 0 for non-tax, what
would null be considered?
The code Dale gave was this:
ALTER TABLE MasterAccounts
Add Taxable tinyint NULL DEFAULT 0
GO
Could you please help me here.
TIA,
Vance Duke
MediaLink
------ =_NextPart_000_01BCFFE2.D86DD660
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IgERAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAPAEAAAEAAAAMAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAAaQAAAAAAAAC1O8LALHcQGqG8CAArKlbCFQAAAISQgaRR088RunAAAHmB
vXukhAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAAAZW1lcmFsZABTTVRQAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAAAAAB4AAjABAAAABQAAAFNNVFAAAAAAHgADMAEAAAAYAAAAZW1lcmFsZEBlbWVy
YWxkLmllYS5jb20AAwAVDAEAAAADAP4PBgAAAB4AATABAAAACgAAACdlbWVyYWxkJwAAAAIBCzAB
AAAAHQAAAFNNVFA6RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAAIB
9g8BAAAABAAAAAAAAAJXPAEEgAEAJwAAAFRheGFibGUgY29sdW1uIGluIE1hc3RlckFjY291bnRz
IHRhYmxlAFoOAQWAAwAOAAAAzQcMAAMACwA7AAAAAwAsAQEggAMADgAAAM0HDAADAAsAOgAFAAMA
MAEBCYABACEAAAAwNzlCMzRFOUQ1NkJEMTExQTE2RDAwMDA3OTgxQkQ3QgATBwEDkAYAhAcAABMA
AAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAEAAOQDApE8iFQC9AR4AcAABAAAAJwAA
AFRheGFibGUgY29sdW1uIGluIE1hc3RlckFjY291bnRzIHRhYmxlAAACAXEAAQAAABYAAAABvQAV
Ij7pNJsPa9UR0aFtAAB5gb17AAAeAB4MAQAAAAUAAABTTVRQAAAAAB4AHwwBAAAAFQAAAHZkdWtl
QHNhbmFudG9uaW8ubmV0AAAAAAMABhBwmMNwAwAHELIBAAAeAAgQAQAAAGUAAABPTk5PVjExLERB
TEVNRU5USU9ORURBVEFYQUJMRUNPTFVNTklOVEhFTUFTVEVSQUNDT1VOVFNUQUJMRVRIQVRXQVNU
T0JFVVNFRElOVkVSU0lPTjI1SEVBTFNPR0FWRVRIRUNPAAAAAAIBCRABAAAA8wUAAO8FAAD8DQAA
TFpGdQYEmLoDAAoAcmNwZzEyNXIyDGBjMQMwAQcLYG6RDhAwMzMPFmZlD5JPAfcCpANjAgBjaArA
c4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQNg+gMDUwNBQh8wHQFBA0fQdtAoMAUAPU+xH/Ewti
E+EUUBOyGPQU0K8HEwKAApEI5jsJbzAa3/plDjA1HAodIRzfHekb9P8eEhx/IE8gDR+PHb8cDxBg
/DI4Jdom8SavJ7kb9CfivyZPKh8p3SlfJ48rVDkOUB8upDABKCMwAAKCc3R56mwHkGgJ4HQAABNQ
A/BQZGN0bAqxXDJYYZhkanUxcAUQZ2gFQjsWMgwBYwnAMmADMHNufGV4FzAHsAWwAMACc3OxAFBz
YjIUUDFgYRPw9FxrCeBwC5AyPzKjCGDrMpALgGUxoHY5YAFAM5u/DDA0ZCgAN0AEoAuAZyfx6TTm
YmEXEGQCIDWgNUbnMdAzkDuRIDExMw5QNp//N684vwBROfwAoDRuPH89hv8xJA/APo8/n0CvDlA5
70MP20QfPbMzAoITEGM2YEuhkzOQPbB0aTmQIEQBEKhhdWwFQFAKwGEJwOBhcGggRgIhNiQlQOhm
aS0PkDgBQDkwUDPrRw8yo2ILIHIJUFJSFqDZUlJ3NCVBFwBwAdBNcn8zv0qfS6ZP0E6QBRACMC1D
TzADYTogVG9XsFModWJqBZB0V7BEYeh0ZTo2JDZP/1EPUh//Uy9UOTHAPaMOIUuhOrYOUJtVb1Z+
UjmBFwEgSD2R+wSQNiQ3WW9af1uPXJ05Dy9dvw+QaXAI0GIKsHQ4/0n6D1RGEF+/YMZqAGHQC1C8
eS9PQFywCxFiRXM2JP8oAGM/ZE9lX1yvVE9rX2xv7211V9JXdFipOW+/Mz8DMB1pszlzn3SveqBE
b2P+dQeAAjAF0E8APhQC0W7g/jNGcWdwfmJ4L3k/es9LPe1yoUwEAE9xfX+yfxB/UPtxUQGAblgw
AGAJ8E2gfQB3AgE14F5SZQDwfQAxgHBJHoBcdgiQd2sLgGTPa0CGggTwB0BlOSVADgDvcSI9gofV
AhBvBUIXIRLyDVjAbQtRWMAgQzpc6lxXAG9O4W1PMAMQB5BNioBNDeADYHNvAYAgrk8BIA3ghdBc
jDZFAMD1AxAuS3B0g7AXEH9QNSHtZ3J4AUCE4W4x0BrwjdQ9TjRjAyAS8wCABZBsdv9BoUbQDnA1
4JBiAZAAIJDy/4bRfUEBwZBhFuAPcAAARtDzDNABkCAuGhKQWA5QkRL/TnB/oJGPkp+Trw/ARtAF
gbeVT5Zfl29sa0BG0GyVD/uZz5rVKZPch8GYv52fmtP4YiAoApGer5CjWVCcX/+hH6Ivoz+Q0GMQ
pIKRX6Xv/6b/k9woAKSPqg+rH6wvkND/eACpD66fr6+wtAr5AzB/DzOAH4Ete08DoDXAdi5ZPfAx
LFiRMaAgfTJpiwIgCYAgmyBUYXgBoN+6UQjhfSADoLYRdDHQfXHTMXAEkEFjBaB1AjAEIG8BkbpR
vGBYsCBtkL1xb/wgYhOAt+C68bYRYfK6wblFYC41udBiQbsQbIvg+CBnYU3xvGIFoAEAvnL/B3AL
UIngfUK8Yk2SPdGL8O/BBbvjvoF9EHIa8AIwbTBeIDVwg2E9wr9lc8ARSd89cMDSwde68cNZYmdQ
vjPudwIgBIE9wne+AwMQAyD7vGK+sXYHQApQBCC8NbvFP4VRvYG7ZABwNSATUG4t+8u1wBFXyXJN
wL6iDpDLdX/MIzWgy3LMdboQyRQIYGz/zFFOYAMgvrEFoACBBIEJgPY/CoUKhVTBJrozwMO+Q/po
BAA60by1fH3/tl+3b0G4fkFMVEVSV8BB2EJMRbydCoVBTaC7N43FEXlXIQewVUxMThBoRUZB3aBU
E5AKhUf+T9TPth/X/9kPuUEKhQhR9dBReQhgIMHxS0E9ceDAF7pxPXEa8C7RvUlBLN0KhVYAcIxw
ThB1RqAKhc5NCYAHMINQbmvfC+A/L+FPBUDjZhoQAOywAAMAEBAAAAAAAwAREAAAAABAAAcwYI+z
ARUAvQFAAAgwYI+zARUAvQEeAD0AAQAAAAEAAAAAAAAAAwANNP03AADonA==
------ =_NextPart_000_01BCFFE2.D86DD660--