Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

BL21

BL21.2 - Invoice Copy

Use this subform to copy a previously defined invoice and create a new
invoice.

Updated Files

    ACCOMMIT   - Used in the Activity Management edit routines.

    ACCOMMITX  - Used in the Activity Management edit routines.

    ARCODE     - Used to validate Accounts Receivable codes.

    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    CBBANKINST - Used to validate the payment code.

    HOLDCODES  - Used to validate the hold code.

    OECOMPANY  - Used to validate the Billing company.

    OECUSTCODE - Used to validate customer 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 - Stores user analysis values processed through the Strategic
                 Ledger system.


    OEMISC     - Used to validate the Billing add-on charge code.

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.

    SALESREP   - Used to validate sales representatives.

    TERITORY   - Used to validate territories.

    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.


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 in the customer edit routine.

    APACCRCODE - Used in the vendor edit routine.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the customer edit routine.

    ARCUSTGRP  - Used in the Accounts Receivable company edit routine.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARCUSTTOTS - Used in the customer edit routine.

    ARLOCKBOX  - Used in the customer edit routine.

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


    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.


    CUCONV     - Used for currency editing.

    CURELAT    - Used to validate currency relationships.

    CUSTDESC   - Used in the Accounts Receivable customer edit routine.

    CUSTORDER  - Used to validate customer orders.

    GLCODES    - Used in the General Ledger edit routines.

    GLSYSTEM   - Used in the General Ledger edit routines.

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate the inventory control location.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTREGN   - Validates the Intrastat region code.

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


    ITEMLOC    - Used to validate the Inventory Control item location.

    ITEMMAST   - Used to validate the inventory control item.

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEBASE     - Used to validate the price base name.

    OECREDCARD - Used to validate credit card types.

    OECUST     - Used in the Accounts Receivable customer edit routine.

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


    OEFRTCODE  - Used to validate freight codes.

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


    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.


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


    OPERATOR   -

    ORDERTYPE  - Used to validate order types.

    SHIPTO     - Used to validate ship-to numbers.

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    SYSTEMCODE - Used by the General Ledger system edit routine.

    TXTAXRATE  - Used in the tax code edit routine.

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.


    WHSHIPMENT - Used to store shipment header information.


BL21.3 - Invoice Comments

Use this subform to assign comments to invoices in the customer's preferred
language.

Updated Files

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


    OEINVOICE  - Stores all information for an invoice.


Referenced Files

    ARCUSTOMER - Used to validate the Accounts Receivable customer.


BL21.4 - Invoice Line Comments

Use this subform to assign comments to invoice lines.

Updated Files

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


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


Referenced Files

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    OEINVOICE  - This is a primary file maintained by this program.  It
                 contains all information for an invoice.



BL21.5 - Line Add On Charges

Use this subform to attach add-on charges to an invoice line.  You define
add-on charges using BL09.1 (Add-on Charges).

Updated Files

    ACCOMMIT   - Used in the Activity Management edit routines.

    ACCOMMITX  - Used in the Activity Management edit routines.

    ARCODE     - Used to validate Accounts Receivable codes.

    ARPROCLEVL - Used to edit the Accounts Receivable process
                 level.


    CBBANKINST - Used to validate the payment code.

    HOLDCODES  - Used to validate the hold code.

    OECOMPANY  - Used to validate the Billing company.

    OECUSTCODE - Used to validate customer codes.

    OEINVCCOMM - This is the primary file maintained by this program.  Comments
                 for an invoice can be added, changed or deleted.


    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  - Top and bottom comment sequence numbers are updated when
                 comments are added to or deleted from an invoice.


    OEINVSGBLK - Stores user analysis values processed through the Strategic
                 Ledger system.


    OEMISC     - Used to validate the Billing add-on charge code.

    OEPROCLEV  - Used to validate the Billing process level.

    OEREASON   - Used to validate reason codes.

    SALESREP   - Used to validate sales representatives.

    TERITORY   - Used to validate territories.

    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.


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 in the customer edit routine.

    APACCRCODE - Used in the vendor edit routine.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used in the customer edit routine.

    ARCUSTGRP  - Used in the Accounts Receivable company edit routine.

    ARCUSTOMER - Used to validate the Accounts Receivable customer.

    ARCUSTTOTS - Used in the customer edit routine.

    ARLOCKBOX  - Used in the customer edit routine.

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


    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.


    CUCONV     - Used for currency editing.

    CURELAT    - Used in converting monetary amounts between currencies.

    CUSTDESC   - Used in the Accounts Receivable customer edit routine.

    CUSTORDER  - Used to validate customer orders.

    GLCODES    - Used in the General Ledger edit routines.

    GLSYSTEM   - Used in the General Ledger edit routines.

    ICCATEGORY - Used to validate inventory control general ledger categories.

    ICCOMPANY  - Used to validate the Inventory Control company.

    ICLOCATION - Used to validate the Inventory Control location.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTREGN   - Validates the Intrastat region code.

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


    ITEMLOC    - Used to validate the Inventory Control item location.

    ITEMMAST   - Used to validate the inventory control item.

    NATACCT    - Used in the Accounts Receivable customer edit routine.

    NATBALANCE - Used in the Accounts Receivable customer edit routine.

    OEBASE     - Used to validate the price base name.

    OECREDCARD - Used to validate credit card types.

    OECUST     - Used in the Accounts Receivable customer edit routine.

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


    OEFRTCODE  - Used to validate freight codes.

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


    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.


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


    OPERATOR   -

    ORDERTYPE  - Used to validate order types.

    SHIPTO     - Used to validate ship-to numbers.

    STATICCUST - Used in the Accounts Receivable customer edit routine.

    SYSTEMCODE - Used by the General Ledger system edit routine.

    TXTAXRATE  - Used in the tax code edit routine.

    WHSHIPLINE - Used to store shipline information including feedback
                 quantity.


    WHSHIPMENT - Used to store shipment header information.


BL21.6 - Copy Standard Comments

Use this subform to copy standard comments to an invoice line.

Updated Files

    OEINVCCOMM - This is the primary file maintained by this program.  Comments
                 for an invoice line can be added, changed or deleted.


    OEINVCLINE - Comment sequence number is updated when comments are added to
                 or deleted from an invoice line.


    OEINVOICE  - Stores all information for an invoice.


Referenced Files

    OECOMMHDR  - Used to validate standard comment codes.

    OESTDCOMM  - Used to retrieve standard comments.


INVOKED Programs

    IFAC
    ACAC
    IFCR
    IFSG
    IFCU
    IFAU
    SLSE
    SLSU
    IFOB
    IFRS
    SLSS