Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BL520


BL520 - Billing Interface

**Form Purpose
Run Billing Interface (BL520) to import invoices and credit memos into the
Order Entry or Billing application from an outside source. There are interface
files to which you move invoices and credit memos from your system and from
which this billing interface pulls the invoices and credit memos.




Updated Files

    ACCOMMIT   - Used in the Activity Management edit routines.

    ACCOMMITX  - Used in the Activity Management edit routines.

    ADDRDATA   -

    ARCODE     - Used to validate Accounts Receivable codes.  If this is the
                 first time the Accounts Receivable code is
                 referenced, the used flag is set.

    ARCUSTOMER - Used to validate Accounts Receivable customer.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    BLOEIUF    -

    BLOILUF    -

    CBBANKINST - Used to validate payment code.

    CKPOINT    - Used to control program restart logic.

    COCOMP     -

    COLINE     - Used to print customer Order Line information.

    COLINEUOM  - Used to provide customer order line pricing information when
                 the line is priced
                 using multiple units of measure.

    COMISC     - Used to print customer order add-on charge information.

    COSGBLK    -

    CUSTDESC   - Used to display Accounts Receivable customer information.

    CUSTEP     -

    CUSTORDER  - Used to print customer order information.

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    EPBATCH    -

    EPTRANS    -

    EPTYPE     -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    HOLDCODES  - Used to validate hold codes.  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  -

    ICLOCATION - Used to validate the Inventory Control location.

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Used to print Inventory Control location information.

    ITSERIAL   -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    MXLISTHDR  -

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEAUDIT    -

    OECOLUF    -

    OECORUF    -

    OECUSTCODE - Used to validate customer codes.  If this is the first time
                 the customer code is
                 used, the used flag is set on.

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

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

    OEORDCMNT  - Used to print customer order comments.

    OEPROCLEV  - Used to validate the Billing Process Level.

    OEREASON   - Used to validate Reason Codes.  If this is the first time the
                 Reason Code is
                 referenced, the used flag is set.

    OESOURCE   -

    OIINVCCOMM - Primary file created by this program.  Pass invoice comments
                 to Billing.

    OIINVCLINE - Primary file created by this program.  Pass invoice line items
                 to Billing.

    OIINVCMISC - Primary file created by this program.  Pass invoice add-on
                 charges to Billing.

    OIINVOICE  - Primary file created by this program.  Pass invoice header
                 information to Billing.

    OISGBLK    -

    ORDERTYPE  - Used to validate order type.

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

    SHIPTO     - Used to validate Ship To number.

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

    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 Accounts Receivable customer edit routine.

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE - Used in 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 Accounts Receivable customer edit and update
                 routines.

    ARCUSTGRP  - Used in the Accounts Receivable customer edit routine.

    ARCUSTTOTS - Used in the Accounts Receivable customer edit routine.

    ARITRANS   - Used in the customer edit routine.

    ARLOCKBOX  - Used in the Accounts Receivable customer edit routine.

    AROIHDR    - Used in the customer edit routine.

    AROITEMS   - Used in the customer edit routine.

    ARPAYMENT  - Used in the Accounts Receivable customer edit routine.

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

    BLUSRFLDEF -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCONV     - Used in converting monetary amounts between currencies.

    CURELAT    - Used in converting monetary amounts between currencies.

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FOBCODE    -

    FROPTIONS  -

    GLADDRESS  - Used in the GL Company Edit routine.

    GLCHART    - Used in the GL account verification routine.

    GLCODES    - Used in the General Ledger account verification routine.

    GLINTCO    -

    GLNAMES    - Used in the GL account verification routine.

    GLSYSTEM   - Used in the General Ledger account verification routine.

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMADDON  - Used to trigger automatic creation of add-on charges for
                 specific items when
                 sold in specified states (or all states).   The add-on charge
                 is created at
                 the invoice line level.

    ITEMGROUP  -

    ITEMMAST   - Used to validate Inventory Control item numbers.

    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 print item base price information.

    OECOMMHDR  - Used to validate standard comment codes.

    OECOMPANY  - Used to validate the Billing company.

    OECOMPREF  -

    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.

    OESTDCOMM  - Used to obtain comments for standard comment codes.

    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