Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BL820


BL820 - Invoice Load

**Form Purpose
Run Invoice Load (BL820) to import non-Lawson invoices into Lawson as
historical.

Note Do not use Invoice Load (BL820) to import unreleased invoices. This
program is intended to import historical invoices only. (The only status that
should be listed is 9.)

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 on the invoice.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.  If
                 this is the first
                 time the process level is referenced, the used flag is set.

    BLOEIUF    -

    BLOILUF    -

    CBBANKINST - Used to validate the payment type.

    CKPOINT    - Used for batch recovery.

    COCOMP     -

    COLINE     - Used to verify customer order line information.

    COLINEUOM  - Used to verify order line multiple pricing units of
                 measure.

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

    COSGBLK    -

    CUSTDESC   - Used in the customer edit routine.

    CUSTEP     -

    CUSTORDER  - Used to verify customer order information.

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    EPBATCH    -

    EPTRANS    -

    EPTYPE     -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    HOLDCODES  - Used to validate the hold code.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICHISTORY  -

    ICLOCATION - Used to validate the inventory control location.

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Used to verify the inventory control item location.  Also used
                 to store available, allocated, in process quantities for an
                 item location combination.

    ITSERIAL   -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    MXLISTHDR  -

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEAUDIT    -

    OECOLUF    -

    OECOMPREF  -

    OECORUF    -

    OECUSTCODE - Used to validate customer codes.

    OEFRTCODE  - Used to validate freight codes.

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

    OEINVCDTL  - Used to store lot/serial 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
                 invoice line.

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

    OEINVCTYPE - Used to validate invoice type.

    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 the Billing add-on charge code.

    OEORDCMNT  - Used to store order comments related to customer order(s) or
                 customer order line(s).

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.

    OESOURCE   -

    ORDERTYPE  - Used to validate order types.

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    REQLINE    -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SALESREP   - Used to validate sales representatives.

    SHIPTO     - Used to validate ship-to numbers.

    SOHDETAIL  -

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

    TERMS      - Used to validate Accounts Receivable terms.

    TXCODEMAST - Stores tax codes, descriptions, and tax types that define how
                 the tax code is used.

    TXCOMPANY  - Stores company information and which tax system the company
                 uses. Includes general ledger accounts if they are defined at
                 the company level.

    TXTAXCODE  - Used to validate tax codes.

    TXTAXTABLE - Used in the tax code edit routine.

    TXTAXTRAN  -

    WHDEMAND   -

    WHDEMNDHDR -

    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    -

    AMTEMPLATE -

    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.

    BLUSRFLDEF -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCONV     - Used for currency editing.

    CURELAT    -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FOBCODE    -

    FROPTIONS  -

    GLADDRESS  -

    GLCHART    -

    GLCODES    - Used in the General Ledger edit routines.

    GLINTCO    -

    GLNAMES    -

    GLSYSTEM   - Used in the General Ledger edit routines.

    HCCHRGITEM -

    ICBIN      - Used to obtain inventory control bin information.

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMADDON  - Used in the order line edit routine.  Automatically adds
                 add-on charges to an order when an item is ordered.

    ITEMGROUP  -

    ITEMMAST   - Used to validate the inventory control item.

    ITEMSRC    -

    ITEMSUB    -

    ITEMUPC    -

    KITITEM    -

    MAAOCDTL   -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    -

    MSDSACK    -

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    OEBASE     - Used to determine item pricing for the invoice line.

    OECOMPANY  - Used to validate the Billing company.

    OECUST     - Used in the Accounts Receivable customer edit routine.

    OECUSTITEM -

    OEDISCOUNT - Used to validate discount codes and provide discount
                 information for the pricing routine.

    OEORDDISC  -

    OEPLCLASS  - Used to store sales class pricing parameters for price list,
                 promotion, and contract.

    OEPLITEM   - Used to store item pricing parameters for price list,
                 promotion, and contract.

    OEPRCLIST  - Used to store default pricing parameters for price list,
                 promotion, and contract.

    OEROUTE    -

    OESLSACCT  - Used to obtain invoice line accounts for inventoried and
                 non-stock line
                 types.

    OPERATOR   -

    PBBILL     -

    PBHSTHDR   -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQUESTER  -

    RQLOC      -

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  - Used in the tax code edit routine.

    WFSETUP    -

    WHPROCTYPE -

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.

    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