DatabaseProgramming
Attachments (30)
- Customer subscription summary.sql (943 bytes ) - added by 231094 4 months ago.
- Outstanding customer balance.sql (1.3 KB ) - added by 231094 4 months ago.
- SIM ready for use check.sql (1015 bytes ) - added by 231094 4 months ago.
- Total monthly reccuring charge.sql (1.3 KB ) - added by 231094 4 months ago.
- Change plan procedure.sql (1.7 KB ) - added by 231094 4 months ago.
- Customer sim assignment.sql (2.1 KB ) - added by 231094 4 months ago.
- Suppor ticket creation.sql (1.4 KB ) - added by 231094 4 months ago.
- Suspend accounts for invoice overdue.sql (2.0 KB ) - added by 231094 4 months ago.
- Account balance trigger.sql (2.7 KB ) - added by 231094 4 months ago.
- AutoClose ticket trigger.sql (741 bytes ) - added by 231094 4 months ago.
- One active subscription for SIM.sql (1.1 KB ) - added by 231094 4 months ago.
- Prevent already paid trigger.sql (1.9 KB ) - added by 231094 4 months ago.
- Subscription status change trigger .sql (985 bytes ) - added by 231094 4 months ago.
- 01 Total monthly recurring charge.sql (1.0 KB ) - added by 231139 2 weeks ago.
- 02 Outstanding customer balance.sql (658 bytes ) - added by 231139 2 weeks ago.
- 03 Invoice remaining balance.sql (434 bytes ) - added by 231139 2 weeks ago.
- 04 SIM ready for use check.sql (922 bytes ) - added by 231139 2 weeks ago.
- 05 Customer subscription summary.sql (1.1 KB ) - added by 231139 2 weeks ago.
- 06 Customer usage between dates.sql (956 bytes ) - added by 231139 2 weeks ago.
- 01 Customer SIM activation.sql (3.1 KB ) - added by 231139 2 weeks ago.
- 02 Change plan procedure.sql (2.3 KB ) - added by 231139 2 weeks ago.
- 03 Support ticket creation.sql (2.9 KB ) - added by 231139 2 weeks ago.
- 04 Suspend overdue accounts.sql (1.6 KB ) - added by 231139 2 weeks ago.
- 05 Record invoice payment.sql (1.3 KB ) - added by 231139 2 weeks ago.
- 01 Subscription status change trigger.sql (1.4 KB ) - added by 231139 2 weeks ago.
- 02 Auto close ticket trigger.sql (515 bytes ) - added by 231139 2 weeks ago.
- 03 Prevent overpaid invoice trigger.sql (1.8 KB ) - added by 231139 2 weeks ago.
- 04 Payment financial sync trigger.sql (2.8 KB ) - added by 231139 2 weeks ago.
- 05 Invoice balance trigger.sql (806 bytes ) - added by 231139 2 weeks ago.
- 06 SIM history status trigger.sql (2.2 KB ) - added by 231139 2 weeks ago.
Download all attachments as: .zip
