Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SA300


SA300 - Sales Analysis Detail Purge

**Form Purpose
Run SA Detail Purge (SA300) to purge the Sales Analysis detail files.

Warning This program permanently deletes data. Before you run this program,
back up your data according to your organization's procedures. Before you
submit the report, carefully review the parameters.

**Processing Effect
These files include:

- Booked orders

- Booked order lines

- Booked order add-on charges

- Invoices

- Invoice lines

- Invoice add-on charges




Updated Files

    CKPOINT    - Used to store data used in restart logic.

    CUSTEP     -

    SABOOKADDR - Used to store Order Entry customer bill-to address overrides.

    SABOOKAOC  - Used to store bookings for add-on charges.

    SABOOKCOMP - Used to store booking information for kit components.

    SABOOKED   - Used to store order booking information.

    SABOOKLINE - Used to store order booking information.

    SAINVCAOC  - Used to store actual invoiced add-on charge information.

    SAINVCCOMP - Used to store actual invoiced information for kit components.

    SAINVCLINE - Used to store actual invoice information.

    SAINVOICE  - Used to store actual invoice information.

    SAPERFORM  - Used to store performance data for a fiscal year.

    SAREASON   - Used to store summary data by reason code for a fiscal year.

    SASUMMARY  - Used to store booked and actual data for company, customer,
                 and item.


Referenced Files

    AGINGCODE  - Used in the Customer Number Edit routine.

    ARCOMP     - Used in editing an Accounts Receivable company.

    ARCUSTFLDS - Used in the Customer Number Edit routine.

    ARCUSTGRP  - Used in the Customer Number Edit routine.

    ARCUSTOMER - Used in the Customer Number Edit routine.

    ARCUSTTOTS - Used in the Customer Number Edit routine.

    ARLOCKBOX  - Used in the Customer Number Edit routine.

    ARPAYMENT  - Used in the Customer Number Edit routine.

    CUSTDESC   - Used in the Customer Number Edit routine.

    EPTRANS    -

    ICCOMPANY  - Used in editing an Inventory Control company.

    INSTCTRYCD -

    ITEMMAST   - Used in editing Inventory Control item numbers.

    NATACCT    - Used in the Customer Number Edit routine.

    NATBALANCE - Used in the Customer Number Edit routine.

    OECUST     - Used in the Customer Number Edit routine.

    OEINVCTYPE - Used in editing Billing invoice types.

    OEMISC     - Used in editing Billing add-on charges.

    SACOMPANY  - Used in editing a Sales Analysis company.

    SAYEAR     - Used to store Sales Analysis fiscal year definition.

    SHIPTO     - Used in editing Billing ship-to codes.

    STATICCUST - Used in the Customer Number Edit routine.

    WFSETUP    -