Promotion SQL Job
Log Successful flag
Add Promotion to eligible customers
Insert Extenstion Promotions for Customers
Insert Promotions for New Customers
Customer_Payments_ExtraData
DSL_Customers_SUM_New_Payments
DSL_Customers_SUM_Old_Payments
Archive Balances and Payments
DSL_Customers_Balances_Log
Archive Invoices
Invoice_Balance_Local
Update Sale Data
Subtopic
Update Sale Date
Update Activation Date
Update Paid Visits
Update Paid Visits c
Update Paid Visits b
Update Paid Visits a
Update CPE2 Sold
Update CPE1 Sold
Update LocalLoop
Update Monthly Payment
Update IP
Update CPE2 Rent
Update CPE1 Rent
Update Speed And Package Id and User_Purchsae_Detail_Id
Create Columns Tables Values
Update User_Id For Mono User UCIDs
Mark UCIDs have promotions
Log UCIDs have promotions
Mark LDN Employees
Log LDN Employees
Mark UCIDs Not In Tracer
Mark UCIDs with multi user
Log UCIDs with Multi Users
Initialize Last Invocies
Copy Balances
From Customer_Master_ExtraData
Delete DSL_Customers_Balances_Log
Read Status of BillingDB to Tracer transfere operation
Set Promotion with 0 duration to be processed
Payment Table
Balance Table