Print this Page
Finance Director
1.3 Finance
06. Subscription Application
Close this Page

1.3.06 Subscription Application:
1. The Finance Director provides many subscription application services to business-to-business customers.   Subscriptions are dependent on a pair of CRM customer company records where once customer is the supplier.   A subscription application service can only be deployed as part of a CRM application service.
2. Subscriptions tend to be in consideration for fixed-monthly-price services, but may involve variable transaction charges.   CRM details include terms of such subscription agreements.
3. Quarterly VAT accrual includes optional UK and non-UK amounts.   Base currency is typically GBP with transaction amounts converted to GBP on the transaction date using the exchange rate quoted.
4. To balance with bank accounts, transaction amounts are shown gross of tax, however all internal management accounts are shown as net amounts without VAT.   Subscription invoices tend to show a single invoiced line service, however many line services can be accomodated.
  09 Open Book Account...  

2. Objective:
1. To replace not-fit-for-purpose public email with professional messaging using secure envelope links that expire in a few days.
2. To increase the level of automation so every invoice is demonstrably created and sent without human intevention as a marketing assertion.
3. To demonstrate that excessive encryption can cause business data to become meaningless and worthless to a criminal.

3. Business Requirement:
1. For any selected business-to-business service, show statement.
2. For any statement, drill down to selected invoice or payment.
3. For any payment, clone as new payment.
4. For any invoice, clone as new invoice.
5. Automatically create and send envelope with link to statement and invoice on scheduled day of month.
6. Manually send envelope with link to statement and invoice.
7. Hide application below a private computer management access point with complex URL.

4. Customer Relationship Management:
1. In this context, Customer will include Suppliers in a business-to-business supply chain.   A company may be a customer in one context or agreement and a supplier in a different context or agreement.
2. CRM data is basic name and address with contact details.   Each customer may have any number of dependent agreements or contracts that are the subject of invoicing.   Business is normally conducted between a pair of named financial people, but an exception may require an owner to be included in certain transactions.
3. Every customer and supplier have the right to sign-in and view their statement with drill down to any invoice or payment advice.   A CRM business email envelope may contain a link to grant direct access to the company statement.

5. Financial Transactions:
1. Each financial transaction can be treated as write-once and read-only in that once it is transacted, it will never change.   An unusual feature is that integer and decimal database field types are used to enforce data integrity.   As encryption levels are increased, all such field values shall be stored as integers without exception.
2. Currency is held as decimal 8 digits where the last 2 digits are after the decimal point as 123456.78.   TEXT-D82 shall enforce this display format but shall store the data in an integer.
3. Rates are held as decimal 6 digits where the last 4 digits are after the decimal point as 12.3456.   TEXT-D64 shall enforce this display format but shall store the data in an integer.
24. Transaction Type is encoded as: 1=Invoice, 2=Payment, 3=Credit, 4=Contra.
34. VAT Rate is encoded as: 1=Standard, 2=Reduced, 3=Zero.
36. Currency Code is encoded as: 1=GB Pounds, 2=Euro, 3=US Dollars.
38. Country Code (for VAT reporting) is encoded as: 1=UK, 2=France, 3=USA.
46. Payment Method is encoded as: 1=Bank Transfer, 2=Cheque, 3=Standing Order, 4=Direct Debit.

6. Transaction:
01. INT Primary Key.
02. INT Active.
03. INT Service Key.
04. INT Customer Key.
05. INT Customer Contract Key.
06. INT Supplier Key.
07. INT Supplier Agreement Key.
08. INT Secondary Key (01).
15. INT Year and Week filter.
16. INT Year and Month filter.
17. INT Last Changed User Key.
18. INT Last Changed Date.
19. INT Last Change Time.
20. INT Created User Key.
21. INT Created Date.
22. INT Created Time.
23. INT Transaction Date (sort order).
24. SINT Transaction Type (1-4).
25. MINT Invoice Number (4 digits).
26. V32 Payment Reference (what invoices paid).
27. INT .spare.
28. INT Service From Date.
29. INT Service To Date.
30. V32 Invoice Line (CRM Agreement line key).
31. V32 Comment Hidden.
32. INT Tax Point Date.
33. D82 Net Amount.
34. SINT VAT Rate (1-3).
35. D82 Gross Amount.
36. SINT Currency Code (1-3).
37. D64 Exchange Rate (4 decimal places).
38. SINT Country Code (1-3).
39. D82 Balance Amount.
40. INT .spare.
41. SINT VAT Percentage (2 digits).
42. D64 VAT Multiplier Fraction.
43. D82 VAT Amount.
44. INT .spare.
45. INT payment terms (days).
46. INT payment method.
47. INT .spare.
64. V64 Comment.

7. To Do:
1. Every transaction field to become an integer without exception. SINT and MINT are too descriptive.
2. Invoice line field to be stored in CRM contract.
3. Payment Ref may have to remain a 26.V32 exception when more than one invoice is paid.
4. One comment as 64.V32 may remain.
5. DB Update rules for TEXT-D82 and TEXT-D64 to be verified.

8. CRM (company data is public):
01. INT Primary Key.
02. INT Active.
03. INT Service Key.
04. INT Customer Secondary Key.
15. INT Year and Week filter.
16. INT Year and Month filter.
17. INT Last Changed User Key.
18. INT Last Changed Date.
19. INT Last Change Time.
20. INT Created User Key.
21. INT Created Date.
22. INT Created Time.
23. INT Token to contact name.
24. INT Token to job title.
25. INT Contact By Method.
26. INT Token to Direct number.
27. INT Token to Mobile number.
28. INT Token to email prefix.
29. INT Token to email suffix.
30. V32 Legal company name.
31. V32 Trading name.
32. V32 Registration country and number.
33. V32 VAT country and number.
34. V32 Company Telephone.
35. V64 Company web site.
36. V08 .
37. V08 Postcode.
38. V16 Country name.
39. V16 County name.
40. V32 Town name.
41. V32 District name.
42. V32 Street name.
43. V32 Building name.
44. V08 .

9. Contract:
01. INT Primary Key.
02. INT Active.
03. INT Service Key.
04. INT Customer Key.
05. INT Secondary (01) Key.
06. INT Supplier Key.
07. INT Supplier Agreement Key.
15. INT Year and Week filter.
16. INT Year and Month filter.
17. INT Last Changed User Key.
18. INT Last Changed Date.
19. INT Last Change Time.
20. INT Created User Key.
21. INT Created Date.
22. INT Created Time.
23. INT Start Date.
24. INT End Date.
25. INT Net Amount (or rate).
26. INT VAT Code.
27. INT Payment Terms Days.
28. INT Invoice Day of Month.
29. INT Invoice Template Number.
30. INT Payment Template Number.
32. V32 Invoice Line Description.

10. Token:
01. INT Primary Key.
02. INT Field Number.
03. V32 Description.

Document Control:
1. Document Title: Subscription Application.
2. Reference: 161306.
3. Keywords: Subscription Application.
4. Description: Subscription Application.
5. Privacy: Public education service as a benefit to humanity.
6. Issued: 11 Jan 2017.
7. Edition: 1.2.