Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SA100


SA100 - Sales Analysis File Create

**Form Purpose
Run SA File Create (SA100) to create the Sales Analysis detail files.

**Processing Effect
This will store booking data at the order by order level and sales data at
the invoice by invoice level.




Updated Files

    CKPOINT    - Used to store data used in restart logic.

    COLINE     - Used to provide customer order information for transfer to
                 Sales Analysis bookings.  Updated to indicate that Sales
                 Analysis has been updated.

    CUSTEP     -

    CUSTORDER  - Used to provide customer order information for transfer to
                 Sales Analysis bookings. Updated to indicate that Sales
                 Analysis has been updated.

    OEINVOICE  - Used to provide actual invoice information for transfer to
                 Sales Analysis bookings. Updated to indicate that Sales
                 Analysis has been updated.

    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.

    SACOMPANY  - Used in editing a Sales Analysis company.

    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.

    TERMS      - Used in the Customer Number Edit routine.


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.

    COCOMP     - Used to store component information for kit lines.

    COMISC     - Used to provide customer order information for transfer to
                 Sales Analysis bookings.

    CUCONV     -

    CURELAT    -

    CUSTDESC   - Used in the Customer Number Edit routine.

    EPTRANS    -

    GLSYSTEM   -

    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.

    OECOMPANY  - Used in editing a Billing company.

    OECUST     - Used in the Customer Number Edit routine.

    OEINVCLINE - Used to provide actual invoice information for transfer to
                 Sales Analysis bookings.

    OEINVCMISC - Used to provide actual invoice information for transfer to
                 Sales Analysis bookings.

    OEINVCTYPE - Used in editing Billing invoice types.

    OEMISC     - Used in editing Billing add-on charges.

    OEREASON   - Used to store reason codes for canceling orders and adding
                 credit memos.

    RETURNHDR  - Used to provide Order Entry return information.

    RETURNLINE - Used to provide Order Entry return information.

    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    -

    WHSHIPCOMP - Used to reference shipment line component items.

    WHSHIPLINE - Used to reference shipment line records.