Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OE830


OE830 - Returns Load Program

**Form Purpose
Run Returns Load Program (OE830) to import return authorizations from a
non-Lawson system to Lawson.

Updated Files

    ACCOMMIT   - Used in the Activity Management edit routines.

    ACCOMMITX  - Used in the Activity Management edit routines.

    ADDRDATA   -

    ARCODE     - Used to validate the Accounts Receivable code.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    BLOEIUF    -

    BLOILUF    -

    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.

    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.

    COSGBLK    -

    CUSTDESC   - Used in the Customer Edit routine.

    CUSTEP     -

    CUSTORDER  - Used to verify the customer order number.

    CXCOMPANY  - Not used in this program.

    CXCPIUAVAL -

    CXITEMHIST - Not used in this program.

    CXPREFITEM - Not used in this program.

    EPBATCH    -

    EPTRANS    -

    EPTYPE     -

    GLCOMMIT   -

    GLCOMMITX  -

    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.

    ICLOCATION - Used to validate Inventory Control locations.

    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.

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Used to verify Inventory Control item locations.

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

    MAPOOLCNT  -

    MMDIST     - Contains general ledger account postings for inventory
                 transaction.

    MMUAVAL    -

    MXLISTHDR  -

    NATBALANCE - Used in the Customer Edit routine.

    OEAUDIT    -

    OECOLUF    -

    OECORUF    -

    OECUSTCODE - Used to validate the customer code.

    OEFRTCODE  - Used to validate the freight code.

    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 -

    OEMETHOD   -

    OEMISC     - Used to validate add-on charges.

    OEORDCMNT  - Used to store order and order line comments.

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate the cancellation reason code.

    OESOURCE   -

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

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  - Used to validate the Purchase Order company.

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

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

    POLINE     - Used in Purchase Order revision logic.

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER - Used in Purchase Order revision logic.

    RACMNTOUT  -

    RAHDROUT   -

    RALDTLOUT  -

    RALINEOUT  -

    RECAOCDTL  -

    REQLINE    -

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

    RETURNHDR  - Used to store return information.

    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.

    RQTRANS    -

    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, 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.

    TXTAXTRAN  -

    WHDEMAND   - Used to validate demand in the Warehouse system.

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

    WORDER     -


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.

    ACCATSUMX  -

    ACCUSTOMER -

    AGINGCODE  - Used in the Customer Edit routine.

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

    AMTEMPLATE - Used in the Asset Management edit routine.

    APACCRCODE - Used in the Vendor Edit routine.

    APAPIHIST  -

    APCOMPANY  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    ARADJUST   - Used in the Customer Edit routine.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the Customer Edit routine.

    ARCUSTGRP  - Used in the Customer Edit routine.

    ARCUSTTOTS - Used in the Customer Edit routine.

    ARITRANS   - Used in the Customer Edit routine.

    ARLOCKBOX  - Used in the Customer Edit routine.

    AROIHDR    - Used in the Customer Edit routine.

    AROITEMS   - Used in the Customer Edit routine.

    ARPAYMENT  - Used in the Customer Edit routine.

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

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      - Used in Purchase Order revision logic.

    BUYVENPF   -

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

    CUCONV     - Used in the Currency Conversion routine.

    CURELAT    -

    CXBURDEN   - Not used in this program.

    CXCASEPREF - Not used in this program.

    CXPTMPITEM - Not used in this program.

    EEADVANCE  -

    EEEXPENSE  -

    FOBCODE    -

    FROPTIONS  -

    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.

    GLNAMES    -

    GLSYSTEM   - Used in the General Ledger Account Edit routine.

    HCCHRGITEM - Not used in this program.

    ICBIN      - Used to validate Inventory Control bins.

    ICCATEGORY - Used to validate Inventory Control general ledger categories.

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

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

    ITEMGROUP  -

    ITEMMAST   - Used to validate the Inventory Control item.

    ITEMSRC    -

    ITEMSUB    -

    ITEMUPC    -

    KITITEM    - Used to identify kit items.

    MAAOCDTL   -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    -

    MSDSACK    -

    NATACCT    - Used in the Customer Edit routine.

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

    OECOMPANY  - Used to validate the Billing company.

    OECOMPREF  -

    OECUST     - Used in the Customer Edit routine.

    OECUSTITEM -

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

    OEORDDISC  -

    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   -

    PBBILL     -

    PBHSTHDR   -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     - Used to validate the cancellation reason code.

    REQHEADER  -

    REQUESTER  -

    RQLOC      - Used in the Warehouse edit routines.

    STATICCUST - Used in the Customer Edit routine.

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  - Used in the Sales Tax Calculation routine.

    WFSETUP    -

    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.

    WHSHLAUD   -


INVOKED Programs

    ACAC
    ACCL
    ACTA
    API4
    IFAC
    IFAU
    IFCU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    ACSB
    API3
    BLI1
    BLI2
    BLI3
    ICCP
    ICI1
    ICI4
    IFRS
    IFSC
    POCP
    POIF
    POIH
    POI6
    POI4
    POI7
    POI9
    POIA
    POIL
    POIX
    POIG
    POII
    POIJ
    POI1
    POIM
    SLSS