From: "Dale E. Reed Jr." <daler@iea-software.com> Subject: RE: [Emerald] Bill Day Date: Wed, 6 Nov 2002 14:57:34 -0800 Message-ID: <LAELKJHLOBGMNAFCOPIEMEHCCCAA.daler@iea-software.com>
> What is the significance of the "BillDay" column is the
> MasterAccounts table
> of Emerald4?
>
> We are adding users via a custom interface and it appears the BillDay
> defaults to 1 if a day is not provided. Assuming a user is anniversary
> billing and the anniversary is the 8th of the month, what happens if the
> BillDay is 1?
BillDay should be the anniversary of the account. Its used when
new services are added to align the new services to the same
anniversary so they are all billed on the same cycles (ie, 8th-7th).
The BillDay is typicalled Day(GetDate()), in TSQL terms. :)
Dale