Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

SA100

SA100 - SA File Create

Use this program to create the Sales Analysis detail files.  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.

    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     - Used to verify rate tables for the defined currency
                 relationship.

    CURELAT    - Used to verify the currency relationships used for a specific
                 currency table.

    CUSTDESC   - Used in the Customer Number Edit routine.

    GLSYSTEM   - Used to verify company information defined in the General
                 Ledger system.

    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.

    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.

    WHSHIPCOMP - Used to reference shipment line component items.

    WHSHIPLINE - Used to reference shipment line records.