Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Send Us Your Comments
- Preface
- 1 Introduction
-
2
Administration Batch
- Program Summary
- Archive and Truncate Purge History Tables (batch_archive_purge_hist.ksh)
- Daily Purge of Foundation Data (daily_purge_job)
- Daily Purge of Foundation Data (dlyprg)
- Increment Virtual Business Date (dtesys)
- Load Spreadsheet Templates (ld_iindfiles.ksh and loadods.ksh)
- Merch API Cache Refresh Wrapper Script (merchapirefreshwrap)
- Merch API Data Rebuild Request Wrapper Script (merchapidatarebuildrequest)
- Merch API Delta Processing Wrapper Script (merchapiwrap)
- Pre/Post Helper Processes for Batch Programs (prepost)
- Purge Aged Competitive Pricing Data (cmpprg.pc)
- Purge Aged Competitive Pricing Data (comp_pricing_purge_job)
- Purge and Archive Old Files in Batch Server (archivelogs)
- Purge Asynchronous Job Tables (async_job_status_retry_cleanup.ksh)
- Purge Dashboard Working Tables (rms_oi_purge.ksh)
- Purge Export Data (data_export_purge_job)
- Purge Export Data (export_stg_purge.ksh)
- Purge Forecast Data (fcstprg)
- Purge Forecast Data (forecast_data_purge_job)
- Purge Job Auditing Logs (job_audit_logs_purge_job)
- Purge Manage Admin Records (admin_api_purge.ksh)
- Purge Notifications (raf_notification_purge.ksh)
- Refresh Materialized Views (refreshmview.ksh)
- Retail Business Metrics Calculation (rbm_metrics_calc_job)
- Retain Item Forecast History (rms_oi_forecast_history.ksh)
- Subscription Metrics Update (subscription_metrics_update_job)
- Tax Event Purge (tax_event_purge_job)
- Tax Event Purge (taxevntprg)
- Truncate Table Script (trunctbl.ksh)
-
3
Foundation Data Maintenance
- Apply Pending Cost Component and ELC Changes to Purchase Orders (batch_ordcostcompupd)
- Apply Pending Item Cost Component Updates (batch_itmcostcompupd)
- Apply Pending Rate Changes to Expense Profiles (batch_expprofupd)
- Apply Pending Up-Charge Cost Component Changes to Departments (batch_depchrgupd)
- Build Diff Ratios Based on Sales History (dfrtbld)
- Like Store Batch Processing (likestorebatch)
- Process Pending Merchandise Hierarchy Changes from External Systems (cremhierdly)
- Purge Aged Cost Component Exceptions (elc_except_purge_job)
- Purge Aged Cost Component Exceptions (elcexcprg)
- Purge Aged Price History Data (prchstprg)
- Purge Aged Price History Data (price_hist_purge_job)
- Purge Aged Store Ship Schedule (activity_sched_purge_job)
- Purge Aged Store Ship Schedule (schedprg)
- Purge Inactive Currency Rates (currency_rates_purge_job)
- Purge Manage Admin Records (admin_api_purge)
- Rebuild Dynamic Item Lists (itmlrbld)
- Rebuild Dynamic Location Lists (lclrbld)
- Rebuild Dynamic Location Lists (loc_list_rebuild_job)
- Reclassify Items in Merchandise Hierarchy (reclsdly)
- Refresh Address Materialized View (refmvlocprimaddr)
- Refresh Currency Conversion Materialized View (batch_rfmvcurrconv)
- Refresh Localization Materialized View (refmvl10entity)
- Rollup of Supplier Data (supmth)
- Store Add Asynchronous Process (CORESVC_STORE_ADD_SQL. ADD_STORE)
- Store Add Asynchronous Process (straddbatch.ksh)
- Update Allocation and Transfer Based on Changes to Up-Charges (batch_alloctsfupd)
- Update ELC Components (batch_compeffupd)
- 4 Item Maintenance
-
5
Purchase Order
- Program Summary
- Apply Deal Discounts to Purchase Orders (orddscnt)
- Auto Close Purchase Orders (ordautcl)
- Auto Close Purchase Orders (order_auto_close_job)
- Build Purchase Orders for Vendor Generated Orders (vrplbld)
- Generate Pre-Issued Order Numbers (genpreiss)
- Purge Aged Open To Buy Data (otb_purge_job)
- Purge Aged Open To Buy Data (otbprg)
- Purge Aged Purchase Orders (order_purge_job)
- Purge Aged Purchase Orders (ordprg)
- Purge PO Induction Staging Tables (po_indctn_purge.ksh)
- Scale Purchase Orders Based on Supplier Constraints (supcnstr)
- Update Retail Values on Open Purchase Orders (ordupd)
- Write Purchase Order Information to Purchase Order History Tables (order_revision_job)
- Write Purchase Order Information to Purchase Order History Tables (ordrev)
-
6
Deals
- Program Summary
- Calculate Actual Impact of Billback Deals (dealact)
- Calculate Weekly/Monthly Income Based on Turnover (dealinc)
- Calculates/Update Forecasted Values for Deals (dealfct)
- Close Expired Deals (deal_close_job)
- Close Expired Deals (dealcls)
- Daily Posting of Deal Income to Stock Ledger (dealday)
- Deal Calculation Queue Insert Multithreading (batch_ditinsrt.ksh)
- Insert into Deal Calculation Queue (ditinsrt)
- Purge Closed Deals (deal_purge_job)
- Purge Closed Deals (dealprg)
- Purge Closed Deals Actuals Item/Location (deal_actuals_purge_job)
- Update OTB After Deal Discounts (discotbapply)
- 7 Contracts
- 8 Cost Changes
-
9
Future Cost
- Future Cost Events
- Future Cost Engine Run Type Configuration
- Future Cost Engine Concurrency Control
- Future Cost Engine Error Handling
- Future Cost Engine Threading/Chunking
- Future Cost Process
- Program Summary
- Execute Batch Calculation/Recalculation of Future Cost Values (fcexec)
- Future Cost Table Maintenance (future_cost_purge_job)
- Prepare Threads for Batch Calculation/Recalculation of Future Cost Values (fcthreadexec)
- Pricing Cost Refresh (rms_oi_pricecostrefresh.ksh)
- Purge Aged Cost Events (cost_event_purge_job)
- Purge Aged Cost Events (costeventprg)
- Use Pending Price Changes to Drive Recalculation of Pricing Cost for some Franchise Item/Locations (fc_pricechg)
- WAC Refresh (rms_oi_wacvarrefresh.ksh)
- 10 Invoice Matching
-
11
Replenishment
- Replenishment Sub Processes
- Approve Replenishment Orders (rplapprv)
- Build Replenishment Orders (rplbld)
- Calculate Net Inventory (replroq.ksh)
- Calculate ROQ for Profitable Investment Buys (ibcalc)
- Determines Eligible Investment Buy Opportunities (ibexpl)
- Multithreading Wrapper for reqext (batch_reqext.ksh)
- Purge Aged Buyer Worksheet Results (buyer_wksht_purge_job)
- Purge Aged Investment Buy Results (investment_buy_purge_job)
- Purge Aged Replenishment Results (replenishment_purge_job)
- Purge Aged Replenishment Results (rplprg)
- Purge Aged Store Orders Results (store_orders_purge_job)
- Purge Replenishment Attribute History (rplathistprg)
- Purge Replenishment Results History by Month (rplprg_month)
- Purge Scheduled Replenishment Induction Staging Tables (repl_indctn_purge.ksh)
- Recalculate Maximum Levels for Floating Point Replenishment (repladj)
- ROQ Calculation and Distribution for Item/Locs Replenished from WH (reqext)
- ROQ Calculation and Distribution for Item/Locs Replenished from Supplier (rplext.ksh)
- Split Replenishment Orders Among Suppliers (supsplit)
- Sync Replenishment Franchise Orders (repl_wf_order_sync.ksh)
- Truck Splitting Optimization for Replenishment (rplsplit)
- Update Replenishment Calculation Attributes (rplatupd)
- Update Replenishment Calculation Attributes by Item/Locrilmaint)
- Update Replenishment Order Taxes (batch_rplapprvgtax.ksh)
- Update Replenishment Size Profile (replsizeprofile)
-
12
Inventory
- Program Summary
- Adjust Inventory for Wastage Items (wasteadj)
- Purge Aged Customer Orders (customer_order_purge.ksh)
- Purge Aged Customer Orders (customer_orders_purge_job)
- Purge Aged Inventory Adjustments (inv_adj_purge_job)
- Purge Aged Inventory Adjustments (invaprg)
- Refresh End of Day Inventory Snapshot (refeodinventory)
-
13
Transfers, Allocation, and RTV
- Program Summary
- Close Mass Return Transfers (mrtupd)
- Close Overdue Transfers (transfer_close_job)
- Close Overdue Transfers (tsfclose)
- Close Transactions with no Expected Appointments, Shipments or Receipts (doc_queue_close_job)
- Close Transactions with no Expected Appointments, Shipments or Receipts (docclose)
- Create Book Transfers for Allocations Between Warehouses in the Same Physical Warehouse (allocbt)
- Create Return to Vendor for Mass Return Transfer (mrtrtv)
- Create Transfers for Mass Return Transfer (mrt)
- Detail Receive Damaged or Tampered with Cartons (tamperctn)
- Purge Aged Mass Return Transfers and RTV (mrt_purge_job)
- Purge Aged Mass Return Transfers and RTV (mrtprg)
- Purge Aged Returns to Vendors (rtv_purge_job)
- Purge Aged Returns to Vendors (rtvprg)
- Purge Aged Transfers (transfer_purge_job)
- Purge Aged Transfers (tsfprg)
- Reconcile Received Dummy Carton IDs with Expected Cartons (dummyctn)
- Stage Regular Price Changes on Open Allocations and Transfers (distropcpub)
- 14 Sales Posting
-
15
Sales History
- Program Summary
- Monthly Sales History Rollup By Department, Class And Subclass (hstbldmth)
- Monthly Sales History Rollup By Diffs (hstbldmth_diff)
- Monthly Stock on Hand, Retail and Average Cost Values Update (hstmthupd)
- Purge Aged Sales History (history_purge_job)
- Purge Aged Sales History (hstprg)
- Purge Aged Sales History by Diff (hist_diff_purge_job)
- Purge Aged Sales History by Diff (hstprg_diff)
- Weekly Sales History Rollup by Department, Class, and Subclass (hstbld)
- Weekly Sales History Rollup by Diff (hstbld_diff)
- Weekly Stock on Hand and Retail Value Update for Item/Location (hstwkupd)
-
16
Stock Count
- Program Summary
- Calculate Actual Current Shrinkage and Budgeted Shrink to Apply to Stock Ledger (stkdly)
- Create Stock Count Requests Based on Schedules (stake_sched_explode_job)
- Create Stock Count Requests Based on Schedules (stkschedxpld)
- Explode Stock Count Requests to Item Level (stkxpld)
- Process Stock Count Results (stockcountprocess.ksh)
- Purge Aged Stock Count (stkprg)
- Purge Aged Stock Count (stock_count_purge_job)
- Stock Count Snapshot Update (stkupd)
- Update Stock On Hand Based on Stock Count Results (stkvar)
-
17
Stock Ledger
- Program Summary
- Append Stock Ledger Information to History Tables (salapnd)
- Daily Rollup of Transaction Data for Stock Ledger (saldly)
- End Of Half Rollup of Data/Calculations for Stock Ledger (saleoh)
- End of Year Inventory Position Snapshot (nwpyearend)
- External Transaction Data Process (trandataprocess.ksh)
- Monthly Rollup of Data/Calculations for Stock Ledger (salmth)
- Purge of Aged End of Year Inventory Positions (nwp_purge_job)
- Purge of Aged End of Year Inventory Positions (nwppurge)
- Purge Stock Ledger History (salprg)
- Purge Stock Ledger History (stkledgr_hist_purge_job)
- Stage Stock Ledger Transactions for Additional Processing (salstage)
- Stock Ledger Table Maintenance (salmaint)
- Stock Ledger Table Maintenance (stock_ledger_purge_job)
- Weekly Rollup of Data/Calculations for Stock Ledger (salweek)
-
18
Franchise Management
- Program Summary
- Apply Supplier Cost Change to Franchise Orders (wf_apply_supp_cc.ksh)
- Franchise Customer Staging Purge (fcustupldpurge)
- Franchise Order Close (wf_orders_close_job)
- Franchise Order Close (wfordcls)
- Franchise Order Purge (wf_orders_purge_job)
- Franchise Order Purge (wfordprg)
- Franchise Return Close (wf_returns_close_job)
- Franchise Return Close (wfretcls)
- Franchise Return Purge (wf_returns_purge_job)
- Franchise Return Purge (wfrtnprg)
- Process Cost Buildup Template Upload (fcosttmplprocess)
- Process Uploaded Franchise Customers and Customer Groups (fcustomerprocess)
- Purge Staged Cost Template Data (fcosttmplpurge)
- Purge Staged Cost Template Data (wf_cost_template_purge_job)
-
19
Sales Audit
- Import Process
- Auditing Processing Programs
- Export Process
- Calculate Totals Based on Client Defined Rules (sa_totals_calc_job)
- Calculate Totals Based on Client Defined Rules (satotals)
- Complete Transaction Import Processing (saimptlogfin)
- Create Store Day for Expected Transactions (sastdycr)
- Evaluate Transactions and Totals based on Client Defined Rules (sa_rules_eval_job)
- Evaluate Transactions and Totals based on Client Defined Rules (sarules)
- Extract Totals and Rules (sa_rules_total_extract)
- Generate Next Sequence for Escheatment Processing (saescheat_nextesn)
-
Get Reference Data for Sales Audit Import Processing (sagetref)
- Schedule
- Design Overview
- Restart/Recovery
-
I/O Specification
- File Name: Item File
- File Name: Waste Data File
- File Name: Reference Item Data
- File Name: Primary Variant Data File
- File Name: Variable Weight UPC Definition File
- File Name: Valid Store/Day Combination File
- File Name: Codes File
- File Name: Error Information File
- File Name: Store POS Mapping File
- File Name: Tender Type Mapping File
- File Name: Merchant Code Mapping File
- File Name: Partner Mapping File
- File Name: Supplier Mapping File
- File Name: Employee Mapping File
- File Name: Banner Information File
- File Name: Currency Information File
- File Name: Promotion Information File
- File Name: Warehouse Information File
- File Name: Inventory Status Information File
- Design Assumptions
- A Note about Primary Variant Relationships
- Migrate Totals and Rules (sa_rules_total_upload)
- Pre/Post Helper Processes for ReSA Batch Programs (saprepost)
- Prevent Duplicate Export of Total Values from ReSA (sapreexp)
- Processing to Allow Re-Upload of Deleted Transactions (saimptlogtdup_upd)
- Purge Aged RTLOG Data (sartlogdatapurge)
- Purge Aged Store/Day Transaction, Total Value and Error Data from Sales Audit (sapurge)
- Purge Into History Tables (b8d_sa_purge)
- Purge the Invalid In-progress Sales Bucket (sainprogresspurge)