Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

OE920

OE920 - Order Conversion Program

Run this program to convert orders from a non-Lawson system to Lawson.

Updated Files

    ACCOMMIT   - Used to maintain commitment balance information for activity
                 transactions that have not been posted to the general ledger.

    ACCOMMITX  - Used to maintain commitment detail information for activity
                 transactions that have not been posted to the general ledger.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    CBBANKINST - Used to validate the payment type.

    CKPOINT    - Used in restart logic.

    COCOMP     - Used to store component information when a customer order line
                 is for a kit item.

    COLINE     - Used to store customer order line information.

    COLINEDTL  - Used to store allocated details (lot, serial, bin, unit of
                 measure quantity)
                 for a customer order line.

    COLINEUOM  - Used to store item pricing for a customer order line if the
                 item is priced
                 via multiple units of measure.

    COMISC     - Used to store customer order/customer order line add-on
                 charges.

    COSGBLK    - Used to store user analysis values for order header, line, and
                 add-on charge records. User analysis values represent
                 information your organization can use to measure profitability.
                 To utilize this measure of organizational profitability, you
                 must be set up to use the Strategic Ledger system.

    CUSTDESC   - Used to validate and maintain customer master records.

    CUSTORDER  - Used to validate the customer order number.

    HOLDCODES  - Used to validate the hold code.  If this is the first time the
                 hold code is
                 referenced, the used flag is set.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOT      - Used to obtain the lot expiration date.

    ICRECEIPTS - Used to record receipts of stock.

    INSTDETAIL - Used to maintain Intrastat detail records.

    INSTHEADER - Used to maintain Intrastat header records.

    INSTNBR    - Used to assign the next available Intrastat number to an
                 Intrastat transaction.

    ITEMLOC    - Used to maintain and validate quantity, cost, and reordering
                 information for an inventoried item at a stock location.

    ITSERIAL   - Used to store serial numbers for serial-tracked items.

    MMDIST     - Contains general ledger account postings for inventory
                 transaction.

    MMUAVAL    - Used to store user analysis values defined for transactions.
                 User analysis values represent information your organization
                 can use to measure profitability. To utilize this measure of
                 organizational profitability, you must be set up to use the
                 Strategic Ledger system.

    NATBALANCE - Used to maintain and validate summary information for a
                 national account customer.

    OEAUDIT    - Used to store audits of changes to released customer orders
                 and order lines.

    OECOMPANY  - Used to validate the Billing company.

    OECREDCARD - Used to validate the credit card type.  If this is the first
                 time the credit
                 card type is referenced, the used flag is set.

    OECUSTCODE - Used to validate the customer code.

    OEFRTCODE  - Used to validate the freight code.  If this is the first time
                 the freight
                 code is referenced, the used flag is set.

    OEMETHOD   - Used to validate the shipping method.  If this is the first
                 time the shipping
                 method is referenced, the used flag is set.

    OEMISC     - Used to validate add-on charges.

    OEORDCMNT  - Used to store customer order and order line comments.

    OEPROCLEV  - Used to maintain and validate information on the valid process
                 levels for the Order Entry system.

    OESOURCE   - Used to validate customer order source codes.

    ORDERTYPE  - Used to print order type information.

    POAOCDTL   - Used in the Purchase Order revision routine.

    POAUDIT    - Used in the Purchase Order revision routine.

    POCOMMENTS - Used in the Purchase Order revision routine.

    POCOMOUT   -

    POHDROUT   -

    POINTAOC   - Used in the Purchase Order revision routine.

    POINTCMTS  - Used to pass comments for purchase order items that are to be
                 ordered from a vendor rather than
                 fulfilled from stock.

    POINTERFAC - Used in the Purchase Order revision routine.

    POLINE     - Used in the Purchase Order revision routine.

    POLINEOUT  -

    PORETURNHD - Used to store and validate vendor return header information.

    POVENDOR   - Used in the Purchase Order revision routine.

    PURCHORDER - Used in the Purchase Order revision routine.

    ROUTEDOC   - Used to maintain the Route Document file, which details
                 delivery routes and delivery points for documents.

    ROUTEHDR   - Used to store total cubic feet, weight, and items for a route.

    ROUTESTOP  - Used to store total cubic feet, weight, and items for a route
                 stop.

    SALESREP   - Used to validate the sales representative.  If this is the
                 first time the sales representative is
                 referenced, the used flag is set.

    SHIPTO     - Used to validate the ship-to code.  If this is the first time
                 the ship-to code is
                 referenced, the used flag is set.

    SOHDETAIL  - Used to store stock-on-hand details.  Lot, bin, and unit of
                 measure
                 quantities are kept on these records.

    STPOLINE   - Used in the Purchase Order revision routine.

    STPURCHORD - Used in the Purchase Order revision routine.

    TERITORY   - Used to validate the territory. If this is the first time the
                 territory is
                 referenced, the used flag is set.

    TERMS      - Used to validate the terms code.  If this is the first time
                 the terms code is
                 referenced, the used flag is set.

    TXCODEMAST - Used to validate and maintain tax codes.

    TXCOMPANY  - Used to validate the Tax company.

    TXTAXCODE  - Used to validate the tax code.

    TXTAXTABLE - Used in the Sales Tax Calculation routine.

    WHDEMAND   - Used to maintain and validate records for processing demands
                 in the Warehouse system.

    WHDEMNDCMT - Used to validate comments from document lines.

    WHDEMNDHDR - Used to maintain and validate document header records.


Referenced Files

    ACACCTCAT  - Used to maintain and validate information on account
                 categories.

    ACACTGRP   - Used to maintain and validate information about activity group
                 setup and definitions.

    ACACTIVITY - Used to maintain and validate activity setup and definition
                 information.

    ACCAL      - Used to maintain and validate calendar information, including
                 the calendar name, description, fiscal year, and periods.

    ACCALX     - Used to maintain and validate detailed calendar information,
                 including calendar name, fiscal year, period, and period end
                 date.

    AGINGCODE  - Used to validate Accounts Receivable aging code override
                 information.

    AMASSET    - Used to maintain and validate asset records.

    AMTEMPLATE - Used to maintain and validate asset template information.

    APACCRCODE - Used to maintain and validate invoice accrual codes.

    APCOMPANY  - Used to validate the Accounts Payable company.

    APCPYVND   - Used to maintain and validate default codes assigned to a
                 vendor or alternate vendor location at the company level.

    APDISTCODE - Used in the Vendor Edit routine.

    APHLDINV   - Used to validate records of vendors, invoices, and payments
                 that are on hold.

    APPROCLEV  - Used to validate the Accounts Payable company.

    APVENCLASS - Used in the Vendor Edit routine.

    APVENGROUP - Used in the Vendor Edit routine.

    APVENLOC   - Used in the Vendor Edit routine.

    APVENMAST  - Used to validate the Accounts Payable vendor.

    ARCOMMENT  - Used to obtain customer comments for customer orders.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used to maintain and validate user-defined field information
                 for each customer.

    ARCUSTGRP  - Used to maintain and validate customer group records.

    ARCUSTTOTS - Used to maintain and validate information on customers'
                 inclusion process levels for invoicing.

    ARLOCKBOX  - Used to maintain and validate lock box record information,
                 including lock box addresses and default process level and cash
                 code information for cash entry.

    ARPAYMENT  - Used to maintain and validate detail payment records entered
                 for a given batch.

    BILLTO     - Used to validate alternate billing address information for a
                 customer.

    BUYCLASS   - Used in the Purchase Order revision routine.

    BUYER      - Used in the Purchase Order revision routine.

    COMPONENT  - Used to obtain Inventory Control definition of components for
                 a kit item.

    CUCONV     - Used to access general ledger and currency information.

    CURELAT    - Used to validate currency relationships.

    FOBCODE    - Used in the Purchase Order revision routine.

    GLADDRESS  - Used in the General Ledger Account Edit routine.

    GLCHART    - Used in the General Ledger Account Edit routine.

    GLCODES    - Used in the General Ledger Account Edit routine.

    GLINTCO    - Used in the General Ledger Account Edit routine.

    GLSYSTEM   - Used to validate the General Ledger company.

    ICBIN      - Used to validate Inventory Control bins.

    ICCATEGORY - Used to validate inventory and offset general ledger accounts
                 used to post inventory transactions.

    ICCOUT     -

    ICLOCATION - Used to validate the Inventory Control location.

    INSTATPROC - Used to validate Intrastat statistical procedure codes.

    INSTCMDTY  - Used to validate Intrastat commodity codes.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTNOTC   - Used to validate Intrastat nature of transaction codes.

    INSTPORTS  - Used to validate Intrastat port codes.

    INSTREGN   - Used to validate Intrastat region codes.

    INSTUOM    - Used to validate Intrastat secondary units of measure.

    ITEMADDON  - Used to create add-on charges automatically when specified
                 items are sold to specific states (or optionally to any state).


    ITEMMAST   - Used to validate the Inventory Control item.

    ITEMSUB    - Used to find item substitutes.

    KITITEM    - Used to identify kit items.

    MAJORCL    - Used to validate the major sales class.

    MINORCL    - Used to validate the minor sales class.

    MSDSACK    - Used to store the Material Safety Data Sheet acknowledgment
                 date.

    NATACCT    - Used to maintain and validate national account records that
                 identify payment relationships between customers.

    OEBASE     - Used in the Item Pricing routine.  Stores the price basis for
                 each item.

    OECUST     - Used in the Customer Edit routine.

    OECUSTITEM - Used to validate customer item numbers.

    OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
                 and general ledger accounts.

    OEINVCTYPE - Used to validate the invoice type. If this is the first time
                 the invoice type is referenced, the used flag is set.

    OEINVOICE  - Used to store invoice information.

    OEORDDISC  - Used to calculate order level discount amount.

    OEPLCLASS  - Used in the Item Pricing routine. Stores sales class level
                 pricing parameters.

    OEPLITEM   - Used in the Item Pricing routine. Stores item level pricing
                 parameters.

    OEPRCLIST  - Used in the Item Pricing routine. Stores price list pricing
                 parameters.

    OEREASON   - Used to validate the cancellation reason code.

    OEROUTE    - Used to validate routes.

    OESLSACCT  - Used to validate sales class accounts.

    OPERATOR   - Used to maintain and validate operator or user ID records.

    POAOCMAST  - Used in the Purchase Order revision routine.

    POAOCSPRD  - Used in PO revision routine.

    POAPPROVE  - Used in the Purchase Order revision routine.

    POCOMPANY  - Used to validate the Purchase Order company.

    POFRTTERM  - Used in the Purchase Order revision routine.

    POINVOICE  - Used in the Purchase Order revision routine.

    POITEMVEN  - Used in the Purchase Order revision routine.

    POLOCCON   - Used to maintain and validate ties between requesting
                 locations and contracts.

    POQUOTES   - Used in the Purchase Order revision routine.

    PORECLINE  - Used in the Purchase Order revision routine.

    POVENDLOC  - Used in the Purchase Order revision routine.

    REQHEADER  -

    REQLINE    - Used in Purchase Order revision logic.

    RQLOC      - Used to validate requesting locations.

    SHIPTOCMNT - Used to obtain ship-to order comments.

    STATICCUST - Used to maintain and validate customer static aging amounts.

    STCOMMCODE - Used to validate standard comment codes.

    SYSTEMCODE - Used to validate system code information.

    TXTAXRATE  - Used to maintain and validate tax rate information.

    WFSETUP    -

    WHPROCTYPE - Used to validate process type records.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    SLSS