Promotion SQL Job

Mere som dette

ASCICS

af Chris Cottell

Evidence Selection

af Nathiya A/P Sasitheran

Business english

af Premysl Miksovsky

App Savvy

af Kirill Madorin

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