Promotion SQL Job

Lisää tämän kaltaisia

Application_046

luonut RAVININAN SIVIJIT

how to sell a franchise

luonut Sergey Zharkov

Create a strategy to achive an engagement between merchants and customers throught contactless cards technology by 30% in the currently debit and credit card middle stratum holders in Bogota within one years by training.

luonut Andres sanchez

Marketing Research

luonut charlie siau

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