Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

OE114

OE114 - Ship Immediates

You must run this program to process ship immediate orders.  When you enter
and release a ship immediate order, the system transfers you to this batch
program, which must be run to process the order through invoicing.  This
program performs many functions, such as releasing the order, picking,
packing, shipping, and invoicing the order.  A pick list, pack list, and
invoice can print if the order type requires these to print.

Updated Files

    ACCOMMIT   - Used to maintain commitment balance information for activity
                 transactions that have not been posted to the general ledger.

    ACCOMMITX  - Used to maintain commitment detail information for activity
                 transactions that have not been posted to the general ledger.

    ARCODE     - Used to validate the Accounts Receivable code.

    ARCUSTOMER - Used to validate the Accounts Receivable customer. The open
                 order amount is updated with the released order's total amount.


    ARPROCLEVL - Used to validate the Accounts Receivable process level.

    CBBANKINST - Used to validate the payment type.

    CKPOINT    - Used for batch recovery.

    COCOMP     - Created if the order line is for a kit item.  Contains the
                 components for the kit item ordered.

    COLINE     - Used to store customer order line information.

    COLINEDTL  - Used to store allocated details (lot, bin, serial number,
                 multiple unit of measure quantities) for a customer order line.


    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    - Used to store user analysis values for order header, line, and
                 add-on charge records. User analysis values represent
                 information your organization can use to measure profitability.
                 To utilize this measure of organizational profitability, you
                 must be set up to use the Strategic Ledger system.

    CUSTDESC   - Used to validate and maintain customer master records.

    CUSTORDER  - Stores a record for every order entered in the Order Entry
                 system.

    CXCASEHEAD - Not used in this program.

    CXCASEPREF - Not used in this program.

    CXCOMPANY  - Not used in this program.

    CXCPIUAVAL - Used to store user analysis values defined for patient cases.
                 User analysis values represent information your organization
                 can use to measure profitability. To utilize this measure of
                 organizational profitability, you must be set up to use the
                 Strategic Ledger system.

    CXITEMHIST - Not used in this program.

    CXPREFDIAG - Not used in this program.

    CXPREFITEM - Not used in this program.

    CXPREFJOBS - Not used in this program.

    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.

    ICACTIVITY - Used in the inventory control edit routines.

    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 - Used to maintain Intrastat detail records.

    INSTHEADER - Used to maintain Intrastat header records.

    INSTNBR    - Used to assign the next available Intrastat number to an
                 Intrastat transaction.

    ITEMLOC    - Used to maintain and validate quantity, cost, and reordering
                 information for an inventoried item at a stock location.

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

    MMDIST     - Contains general ledger account postings for inventory
                 transaction.

    MMUAVAL    - Used to store user analysis values defined for transactions.
                 User analysis values represent information your organization
                 can use to measure profitability. To utilize this measure of
                 organizational profitability, you must be set up to use the
                 Strategic Ledger system.

    NATBALANCE - Used to maintain and validate summary information for a
                 national account customer.

    OEAUDIT    - Used to store audits of changes to released orders and order
                 lines.

    OECOMPANY  - Used to validate the Billing company.

    OECREDCARD - Used to validate the credit card code.

    OECUSTCODE - Used to validate the customer code.

    OEFRTCODE  - Used to validate the freight code.

    OEINVCCOMM - Used to store invoice comments.  Invoice comments are created
                 from order comments.

    OEINVCDTL  - Used to store lot and serial number detail information.
                 Invoice details are created from order details.

    OEINVCLINE - Used to store invoice line information.  Invoice lines are
                 created from order lines.

    OEINVCMISC - Used to store invoice add-on charges.  Invoice add-on charges
                 are created from order and order line add-on charges.

    OEINVCTAX  - Used to store invoice taxes 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 pricing information when multiple units
                 of measure are used to price an invoice line.

    OEINVHDR   - Invoice Batch Header file.  Created when an invoice is created
                 from an order.

    OEINVOICE  - Used to store invoice information.  An invoice is created from
                 an order.

    OEINVSGBLK - Used to store user analysis values from the Billing system
                 Invoice file. User analysis values represent information your
                 organization can use to measure profitability. To utilize this
                 measure of organizational profitability, you must be set up to
                 use the Strategic Ledger system.

    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 order and order line comments.

    OEPROCLEV  - Used to maintain and validate information on the valid process
                 levels for the Order Entry system.

    OEREASON   - Used to validate the cancellation reason code.

    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.

    POAOCDTL   - Used in Purchase Order revision logic.

    POAUDIT    - Used in Purchase Order revision logic.

    POCOMMENTS - Used in Purchase Order revision logic.

    POCOMOUT   -

    POHDROUT   -

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

    POINTCMTS  - Used to pass comments 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 Purchase Order revision logic.

    POLINEOUT  -

    PORETURNHD - Used to store and validate vendor return header information.

    POVENDOR   - Used in Purchase Order revision logic.

    PURCHORDER - Used in Purchase Order revision logic.

    REQHEADER  - Used in the Warehouse edit routines.

    REQLINE    - Used in the Warehouse edit routines.

    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  - Updated with changed values when a customer order line is
                 changed after the route files have been created.

    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.

    STPOLINE   - Used in Purchase Order revision logic.

    STPURCHORD - Used in Purchase Order revision logic.

    TERITORY   - Used to validate the sales 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 to maintain tax table information.

    WHBATCH    - Created when the pick list print program is run.  Used to
                 group all shipments into one batch for inquiry and feedback
                 purposes.

    WHDEMAND   - Used to validate the Warehouse demand.

    WHDEMNDCMT - Contains comments for the demand records.  Created from order
                 comments or requisition comments.

    WHDEMNDDTL - Contains detail information about bins, lots, serial numbers
                 and multiple units of measure for the demand lines.

    WHDEMNDHDR - Used to validate the Warehouse demand header.

    WHSCMNTOUT -

    WHSCOMPOUT -

    WHSHIPCOMP - Used to store the make-to-order kit components to be shipped
                 for the shipment line.

    WHSHIPLINE - Used to store shipment line information including feedback
                 quantities.

    WHSHIPMENT - Used to store shipment header information.

    WHSHLAUD   - Used to audit feedback changes to the shipment line. This is
                 only used when "full" feedback is not performed for a shipment
                 line.

    WHSHLDTL   - Used to store shipment line detail quantities for bin, lot,
                 serial number, and multiple unit of measure detail tracked
                 items.

    WHSHPMTOUT -

    WHSLINEOUT -


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 to validate Accounts Receivable aging code override
                 information.

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

    AMTEMPLATE - Used in the Asset Management edit routine.

    APACCRCODE - Used to maintain and validate invoice accrual codes.

    APCOMPANY  - Used to validate the Accounts Payable company.

    APCPYVND   - Used in the Vendor Edit routine.

    APDISTCODE - Used in the Vendor Edit routine.

    APHLDINV   - Used in the Vendor Edit routine.

    APPROCLEV  - Used in the Vendor Edit routine.

    APVENCLASS - Used in the Vendor Edit routine.

    APVENGROUP - Used in the Vendor Edit routine.

    APVENLOC   - Used in the Vendor Edit routine.

    APVENMAST  - Used to validate the Accounts Payable vendor.

    ARCOMMENT  - Used to obtain customer comments for customer orders.

    ARCOMP     - Used to validate the Accounts Receivable company.

    ARCUSTFLDS - Used to maintain and validate user-defined field information
                 for each customer.

    ARCUSTGRP  - Used to maintain and validate customer group records.

    ARCUSTTOTS - Used to maintain and validate information on customers'
                 inclusion process levels for invoicing.

    ARLOCKBOX  - Used to maintain and validate lock box record information,
                 including lock box addresses and default process level and cash
                 code information for cash entry.

    AROIHDR    - Used in the Customer Edit routine.

    ARPAYMENT  - Used to maintain and validate detail payment records entered
                 for a given batch.

    BILLOFLAD  - Used to validate Bill of Lading information.

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

    BUYCLASS   - Used in Purchase Order revision logic.

    BUYER      - Used in Purchase Order revision logic.

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

    CUCONV     - Used to access general ledger and currency information.

    CURELAT    - Used to validate currency relationships.

    CXBURDEN   - Not used in this program.

    CXCTIUAVAL - Used to store user analysis values defined for preference
                 templates. User analysis values represent information your
                 organization can use to measure profitability. To utilize this
                 measure of organizational profitability, you must be set up to
                 use the Strategic Ledger system.

    CXDIAGNOST - Not used in this program.

    CXPRACPROC - Not used in this program.

    CXPRACTNR  - Not used in this program.

    CXPREFTEMP - Not used in this program.

    CXPTMPDIAG - Not used in this program.

    CXPTMPITEM - Not used in this program.

    CXTMPJOBS  - Not used in this program.

    FOBCODE    - Used in Purchase Order revision logic.

    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.

    GLSYSTEM   - Used to validate the General Ledger company.

    HCCHRGITEM - Used to validate patient charge item information.

    HCPATIENT  - Used to validate patient information.

    ICBIN      - Used to validate Inventory Control bins.

    ICCATEGORY - Used to validate inventory and offset general ledger accounts
                 used to post inventory transactions.

    ICCOUT     -

    INSTATPROC - Used to validate Intrastat statistical procedure codes.

    INSTCMDTY  - Used to validate Intrastat commodity codes.

    INSTCTRYCD - Validates the Intrastat country code.

    INSTNOTC   - Used to validate Intrastat nature of transaction codes.

    INSTPORTS  - Used to validate Intrastat port codes.

    INSTREGN   - Used to validate Intrastat region codes.

    INSTUOM    - Used to validate Intrastat secondary units of measure.

    ITCOMMENT  - Used to retrieve item comments to be printed on the pick
                 list.

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

    ITEMGROUP  - Used in the inventory control company and item edit routines.

    ITEMMAST   - Used to validate the Inventory Control item.

    ITEMSUB    - Used to find item substitutes.

    KITITEM    - Used to identify kit items.

    KTINSTRUCT - Contains instructions for assembling make-to-order kits.

    MAJORCL    - Used to validate the major sales class.

    MINORCL    - Used to validate the minor sales class.

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

    NATACCT    - Used to maintain and validate national account records that
                 identify payment relationships between customers.

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

    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.

    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.

    OEROUTE    - Used to validate routes.

    OESLSACCT  - Used to validate sales class accounts.

    OESTDCOMM  - Used to validate the standard comment code. If valid, comments
                 are copied to the order comment file.

    OPERATOR   - Used to maintain and validate operator or user ID records.

    POAOCMAST  - Used in Purchase Order revision logic.

    POAOCSPRD  - Used in Purchase Order revision logic.

    POAPPROVE  - Used in Purchase Order revision logic.

    POCOMPANY  - Used to validate the Purchase Order company.

    POFRTTERM  - Used in Purchase Order revision logic.

    POINVOICE  - Used in Purchase Order revision logic.

    POITEMVEN  - Used in Purchase Order revision logic.

    POLOCCON   - Used to maintain and validate ties between requesting
                 locations and contracts.

    POQUOTES   - Used in Purchase Order revision logic.

    PORECLINE  - Used in Purchase Order revision logic.

    POVENDLOC  - Used in Purchase Order revision logic.

    REASON     - Used to validate the cancellation reason code.

    RQLOC      - Used in the Warehouse edit routines.

    SHIPTOCMNT - Used to store and validate customer ship-to information,
                 including the ship-to address and specific order processing
                 rules for the ship-to location.

    STATICCUST - Used to maintain and validate customer static aging amounts.

    STCOMMCODE - Used to validate standard comment codes.

    SYSTEMCODE - Used to validate system code information.

    TXTAXRATE  - Used to maintain and validate tax rate information.

    WFSETUP    -

    WHDEMNDDTL - Contains detail information about bins, lots, serial numbers
                 and multiple units of measure for the demand lines.

    WHPROCTYPE - Used to validate the Warehouse process type.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    CXCP
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    SLSS