Kategorier: Alle - payments - update - customers - promotion

av George Nairooze 15 år siden

340

Promotion SQL Job

The process involves a series of SQL tasks aimed at managing customer promotions, logging user actions, and updating system records. Initially, it focuses on identifying and marking UCIDs associated with multiple users, followed by archiving existing balances and payments.

Promotion SQL Job

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