Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

SA300

SA300 - SA Detail Purge

The SA Detail Purge program is used to purge the Sales Analysis detail files.
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.

    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.

    ICCOMPANY  - Used in editing an Inventory Control company.

    INSTCTRYCD - Used to verify that the origin and destination countries in a
                 transaction are part of the European community and the
                 transaction is therefore subject to Intrastat reporting.

    ITEMMAST   - Used in editing Inventory Control item numbers.

    NATACCT    - Used in the Customer Number Edit routine.

    NATBALANCE - Used in the Customer Number Edit routine.

    OECOMPANY  - Used in editing a Billing company.

    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.