Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

OE830

OE830 - Returns Load Program

Run this program to convert return authorizations 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.

    ARCODE     - Used to validate the Accounts Receivable code.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    CBBANKINST - Used to validate the payment type.

    CKPOINT    - Used for batch recovery.

    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 number, bin, unit
                 of measure quantity) for a customer order line.

    COSGBLK    -

    CXCOMPANY  - Not used in this program.

    CXCPIUAVAL -

    CXITEMHIST - Not used in this program.

    CXPREFITEM - Not used in this program.

    HCPATCHRG  - Not used in this program.

    HCPATVISIT - Not used in this program.

    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.

    ICHISTORY  - Used to store item sales history for inventory tracked
                 items.

    ICLOT      - Used to obtain the lot expiration date.

    ICRECEIPTS - Used to record receipts of stock.

    ICTRANS    - Used to store transaction history for stock on hand quantity
                 updates of inventory tracked items.

    ICTRANSDTL - Used to store detail transaction history for stock on hand
                 quantity updates of inventory tracked items.   Detail includes
                 bins, lots, serial numbers, and multiple units of measure.

    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 number tracked items.

    MMDIST     - Contains general ledger account postings for inventory
                 transaction.

    MMUAVAL    -

    OECOMPANY  - Used to validate the Billing company.

    OECUSTCODE - Used to validate the customer code.

    OEINVCCOMM - Used to store comments associated with an invoice or its line
                 items.

    OEINVCDTL  - Used to store lot/serial number information for an invoice
                 line for subsequent printing.

    OEINVCLINE - Used to store all information for an invoice line.

    OEINVCMISC - Used to store all information for an add-on charge attached to
                 an invoice or

    OEINVCTAX  - Used to store tax amounts calculated when the invoice is
                 released.

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

    OEINVCUOM  - Used to store invoice line pricing information when the line
                 has been priced
                 via multiple units of measure.

    OEINVHDR   - Invoice Batch Header file.  Created when an invoice is added,
                 if it does not
                 already exist.  Batch totals are updated as invoices are added
                 for the batch.

    OEINVOICE  - Stores all information for an invoice.

    OEINVSGBLK - Used to store user analysis values from the Billing system
                 Invoice file. 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.

    OEMISC     - Used to validate add-on charges.

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

    OEREASON   - Used to validate the cancellation reason code.

    POINTERFAC - Used to pass purchase order items that are to be ordered from
                 a vendor rather than filled from stock.

    RACMNTOUT  -

    RAHDROUT   -

    RALDTLOUT  -

    RALINEOUT  -

    RETURNCOMM - Used to store return and return line comments.

    RETURNDTL  - Used to store bin, lot, and serial number information for a
                 return line.

    RETURNHDR  - Used to maintain and validate the return header record.

    RETURNLINE - Used to store return line information.

    RETURNSGBK -

    ROUTEDOC   - Updated with changed values when a customer order line is
                 changed after the route files have been created.

    ROUTEHDR   - Used to edit whether the route has been created for a customer
                 order line.
                 If it has, the totals on the route files are updated with the
                 changed values.

    ROUTESTOP  - Updated with changed values when a customer order line is
                 changed after
                 the route files have been created.

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

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

    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 Accounts Receivable terms code.

    TXCODEMAST - Used to validate the tax code.

    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 validate demand in the Warehouse system.

    WHDEMNDCMT - Contains comments for the demand records.  Created from order
                 comments or requisition comments.

    WHDEMNDHDR - Used to validate the demand header in the Warehouse system.


Referenced Files

    ACACCTCAT  - Used in the Activity Management edit routines.

    ACACTGRP   - Used in the Activity Management edit routines.

    ACACTIVITY - Used to validate the Activity Management activity code.

    ACCAL      - Used in the Activity Management edit routines.

    ACCALX     - Used in the Activity Management edit routines.

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

    AMASSET    - Used in the Procurement Management distribution edit routine
                 to edit asset codes.

    AMTEMPLATE - Used in the Asset Management edit routine.

    APACCRCODE - Used to maintain and validate invoice accrual codes.

    APCOMPANY  - Used to validate the Accounts Payable company.

    APVENMAST  - Used to validate the Accounts Payable vendor.

    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.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    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.

    AROIHDR    - Used in the Customer Edit routine.

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

    BILLTO     - Used to validate the customer bill to entered on the order.

    BUYER      - Used in Purchase Order revision logic.

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

    COMISC     - Used to store order and order line add-on charges.

    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.

    CUSTDESC   - Used to validate and maintain customer master records.

    CUSTORDER  - Used to verify the customer order number.

    CXBURDEN   - Not used in this program.

    CXCASEPREF - Not used in this program.

    CXPTMPITEM - Not used in this program.

    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.

    HCCHRGITEM - Not used in this program.

    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 Inventory Control locations.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTREGN   - Used to validate Intrastat region codes.

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

    ITEMMAST   - Used to validate the Inventory Control item.

    KITITEM    - Used to identify kit items.

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

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

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

    OECREDCARD - Used to validate the credit card code.

    OECUST     - Used in the Customer Edit routine.

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

    OEFRTCODE  - Used to validate the freight code.

    OEORDCMNT  - Used to store order and order line comments.

    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.

    OEROUTE    - Used to validate routes.

    OESLSACCT  - Used to validate sales class accounts.

    OPERATOR   -

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

    POCOMPANY  - Used to validate the Purchase Order company.

    POLINE     - Used in Purchase Order revision logic.

    PURCHORDER - Used in Purchase Order revision logic.

    REASON     - Used to validate the cancellation reason code.

    RQLOC      - Used in the Warehouse edit routines.

    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.

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

    STPURCHORD - Used in Purchase Order revision logic.

    SYSTEMCODE -

    TXTAXRATE  - Used to maintain and validate tax rate information.

    WHDEMNDCMT - Contains comments for the demand records.  Created from order
                 comments or requisition comments.

    WHPROCTYPE - Used to validate a Warehouse process type.

    WHSHIPLINE - Used to store shipment line information including feedback
                 quantities.

    WHSHIPMENT - Used to store shipment header information.


INVOKED Programs

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