Promotion SQL Job

Balance Table

Payment Table

Set Promotion with 0 duration to be processed

Read Status of BillingDB to Tracer transfere operation

Delete DSL_Customers_Balances_Log

Copy Balances

From Customer_Master_ExtraData

Initialize Last Invocies

Log UCIDs with Multi Users

Mark UCIDs with multi user

Mark UCIDs Not In Tracer

Log LDN Employees

Mark LDN Employees

Log UCIDs have promotions

Mark UCIDs have promotions

Update User_Id For Mono User UCIDs

Update Sale Data

Create Columns Tables Values

Update Speed And Package Id and User_Purchsae_Detail_Id

Update CPE1 Rent

Update CPE2 Rent

Update IP

Update Monthly Payment

Update LocalLoop

Update CPE1 Sold

Update CPE2 Sold

Update Paid Visits

Update Paid Visits a

Update Paid Visits b

Update Paid Visits c

Update Activation Date

Update Sale Date

Subtopic

Archive Invoices

Invoice_Balance_Local

Archive Balances and Payments

DSL_Customers_Balances_Log

Add Promotion to eligible customers

Insert Promotions for New Customers

Customer_Payments_ExtraData

DSL_Customers_SUM_Old_Payments

DSL_Customers_SUM_New_Payments

Insert Extenstion Promotions for Customers