Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OE113


OE113 - Quotation Listing and Delete

**Form Purpose
Run Quotation Listing and Delete (OE113) to print a list of orders that are
sales quotes, based on specified criteria. This program can optionally be used
to delete quotes with order dates equal to or earlier than a specific date.




Updated Files

    ACCOMMIT   - Used in the Activity Management edit routines.

    ACCOMMITX  - Used in the Activity Management edit routines.

    ADDRDATA   -

    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.  Optionally,
                 quotation lines are deleted.

    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    -

    CUSTDESC   - Used in the Customer Edit routine.

    CUSTEP     -

    CUSTORDER  - Used to validate the customer order number.  Optionally,
                 quotation header records are deleted based on input parameters.

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    EPBATCH    -

    EPTRANS    -

    EPTYPE     -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    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 sales history for Inventory Control items.

    ICLOCATION - Used to validate the Inventory Control location.

    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.

    ICTRANSDTL - Used to store detail transaction history for stock-on-hand
                 quantity updates.

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Used to verify the Inventory Control item location.

    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    - Used to store audits of changes to released customer orders
                 and order lines.

    OECOLUF    -

    OECORUF    -

    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.

    OEINVCTYPE - Used to validate the invoice type.  If this is the first time
                 the invoice type
                 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 validate the Billing process level.

    OESOURCE   - Used to validate customer order source codes.

    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   - Used in the Purchase Order revision routine.

    POAOCMAST  - Used in the Purchase Order revision routine.

    POAOCSPRD  - Used in the Purchase Order revision routine.

    POAUDIT    - Used in the Purchase Order revision routine.

    POCODE     -

    POCOMPANY  - Used to validate the Purchase Order company.

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   - Used to pass add on costs for purchase order items that are to
                 be ordered from a vendor rather than filled from stock.

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

    POLINE     - Used in the Purchase Order revision routine.

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  - Used in the Purchase Order revision routine.

    PORETURNHD - Used in the Purchase Order revision routine.

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   - Used in the Purchase Order revision routine.

    PURCHORDER - Used in the Purchase Order revision routine.

    RECAOCDTL  -

    REQLINE    - Used in Purchase Order revision logic.

    ROUTEDOC   - Used to store total cubic feet, weight, and items for an order
                 on a route.

    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.

    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, and 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 terms code.  If this is the first time
                 the terms code is
                 referenced, the used flag is set.

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

    WHDEMNDHDR - Used to validate the Warehouse demand header.

    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  - Used to validate the Accounts Payable company.

    APHLDINV   - Used in the Vendor Edit routine.

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  - Used to validate the Accounts Payable company.

    APUAVAL    -

    APVENADDR  -

    APVENGROUP - Used in the Vendor Edit routine.

    ARADJUST   -

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the Accounts Receivable Edit routine.

    ARCUSTGRP  - Used in the Accounts Receivable Edit routine.

    ARCUSTTOTS - Used in the Accounts Receivable Edit routine.

    ARITRANS   -

    ARLOCKBOX  - Used in the Accounts Receivable Edit routine.

    AROIHDR    -

    AROITEMS   -

    ARPAYMENT  - Used in the Accounts Receivable Edit routine.

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

    BUYCLASS   - Used in the Purchase Order revision routine.

    BUYCMPLOC  -

    BUYER      - Used in the Purchase Order revision routine.

    BUYVENPF   -

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

    CUCONV     - Used in the Currency Conversion routine.

    CURELAT    - Used in the Currency Conversion routine.

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FOBCODE    - Used in the Purchase Order revision routine.

    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    - Used in the General Ledger Account Edit routine.

    GLSYSTEM   - Used in the General Ledger Account Edit routine.

    HCCHRGITEM -

    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   -

    ITCOMMENT  - Used to print Inventory Control item type comments.

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

    ITEMGROUP  - Used to validate Inventory Control item types.

    ITEMMAST   - Used to validate the Inventory Control item.

    ITEMSRC    -

    ITEMSUB    - Used to find item substitutes.

    ITEMUPC    -

    KITITEM    - Used to identify kit items.

    MAAOCDTL   -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    - Used to validate the major sales class.

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    - Used to validate the minor sales class.

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

    NATACCT    - Used in the Customer Edit routine.

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

    OECOMPANY  - Used to validate the Billing company.

    OECOMPREF  -

    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.

    OEINVOICE  - Used to store invoice information.

    OEORDDISC  - Used to calculate the 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 validate the user ID.

    PBBILL     -

    PBHSTHDR   -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  - Used in the Purchase Order revision routine.

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  - Used in the Purchase Order revision routine.

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQUESTER  -

    RQLOC      - Used in the Warehouse edit routines.

    STATICCUST - Used in the Customer Edit routine.

    STCOMMCODE - Used to validate standard comment codes.

    SYSTEMCODE -

    TXTAXRATE  - Used in the Sales Tax Calculation routine.

    WFSETUP    -

    WHPROCTYPE - Used to validate the Warehouse process type.

    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