OE950 - Returns Conversion Program Run this program to convert return authorizations from a non-Lawson system to Lawson. 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 AR code. 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 customer order line is for a kit item. COLINE - Used to store customer order line information. COLINEDTL - Used to maintain line allocation information. COSGBLK - CXCOMPANY - Used to maintain parameters for healthcare companies. CXCPIUAVAL - CXITEMHIST - Used to store item history for case visits. CXPREFITEM - Used to track items defined for use in a procedure. HCPATCHRG - Used to maintain patient charge information. HCPATVISIT - Used to maintain patient visit information. 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. 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. 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-tracked items. MMDIST - Contains general ledger account postings for inventory transaction. MMUAVAL - OECOMPANY - Used to validate the Billing company. OECUSTCODE - Used to validate the customer code. OEINVCCOMM - Used to store invoice/invoice line comments. OEINVCDTL - Used to store invoice line details (lots, serials, and so on). OEINVCLINE - Used to store invoice line information. OEINVCMISC - Used to store invoice/invoice line add-on charges. OEINVCTAX - Used to store invoice/invoice line sales tax amounts. 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 item pricing when an invoice line is priced via multiple units of measure. OEINVHDR - Invoice batch header. Stores batch totals. Deleted when all invoices in the batch are released. OEINVOICE - Used to store invoice information. 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. OEMISC - Used to validate add-on charges. 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. POINTERFAC - Used in the Purchase Order revision routine. RACMNTOUT - RAHDROUT - RALDTLOUT - RALINEOUT - RETURNCOMM - Used to store return comments. If the invoice flag is set these are passed to the credit memo when it is created. RETURNDTL - Used to store details for return lines (lots, serials, bins, and so on). RETURNHDR - Used to store return invoice level information. RETURNLINE - Used to store return line level information. RETURNSGBK - ROUTEDOC - Used to maintain the Route Document file, which details delivery routes and delivery points for documents. ROUTEHDR - Used to add header records to the Route Header file when routes are created. ROUTESTOP - Used to identify the stops along a route. SALESREP - Used to validate the sales representative. If this is the first time the sales representative 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 and maintain tax codes. 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 maintain and validate records for processing demands in the Warehouse system. WHDEMNDCMT - Used to validate comments from document lines. WHDEMNDHDR - Used to maintain and validate document header records. Referenced Files ACACCTCAT - Used to maintain and validate information on account categories. ACACTGRP - Used to maintain and validate information about activity group setup and definitions. ACACTIVITY - Used to maintain and validate activity setup and definition information. ACCAL - Used to maintain and validate calendar information, including the calendar name, description, fiscal year, and periods. ACCALX - Used to maintain and validate detailed calendar information, including calendar name, fiscal year, period, and period end date. AGINGCODE - Used to validate Accounts Receivable aging code override information. AMASSET - Used to maintain and validate asset records. AMTEMPLATE - Used to maintain and validate asset template information. APACCRCODE - Used to maintain and validate invoice accrual codes. APCOMPANY - Used to validate the Accounts Payable company. APVENMAST - Used to validate the Accounts Payable vendor. 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. ARCUSTOMER - Used to validate the Accounts Receivable customer. 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 to maintain header records Accounts Receivable transactions. ARPAYMENT - Used to maintain and validate detail payment records entered for a given batch. BILLTO - Used to validate a customer's alternate billing address. BUYER - Used to validate default and control information for valid buyers. 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. COMPONENT - Used to validate the component items that make up a kit item. CUCONV - Used to access general ledger and currency information. CURELAT - Used to validate currency relationships. CUSTDESC - Used to validate and maintain customer master records. CUSTORDER - Used to validate the customer order number. CXBURDEN - Used to maintain and validate burden codes. CXCASEPREF - Used to validate header records for case preference lists. CXPTMPITEM - Used to validate items included in a preference template. 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 to validate interzone and intercompany relationships. GLSYSTEM - Used to validate the General Ledger company. HCCHRGITEM - Used to validate patient charge item information. ICBIN - Used to validate Inventory Control bins. ICCATEGORY - Used to validate inventory and offset general ledger accounts used to post inventory transactions. ICCOUT - ICLOCATION - Used to validate the Inventory Control location. INSTCTRYCD - Validates the Intrastat country code. INSTREGN - Used to validate Intrastat region codes. ITEMADDON - Used to create add-on charges automatically when specified items are sold to specific states (or optionally to any state). ITEMMAST - Used to validate the Inventory Control item. KITITEM - Used to validate kit or parent items for a make-to-order or finished goods kit. NATACCT - Used to maintain and validate national account records that identify payment relationships between customers. NATBALANCE - Used to maintain and validate summary information for a national account customer. OEBASE - Used in the Item Pricing routine. Stores the price basis for each item. OECREDCARD - Used to validate the credit card type. If this is the first time the credit card type is referenced, the used flag is set. OECUST - Used in the Customer Edit routine. OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages and general ledger accounts. OEFRTCODE - Used to validate the freight code. If this is the first time the freight code is referenced, the used flag is set. OEORDCMNT - Used to store customer order and order line comments. 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 all user-defined routes set up in the Order Entry system. OESLSACCT - Used to validate sales class accounts. OPERATOR - ORDERTYPE - Used to print order type information. POCOMPANY - Used to validate the Purchase Order company. POLINE - Used to validate purchase order line item information. PURCHORDER - Used to validate purchase order header information. REASON - Used to validate approved reasons that explain why inventory transactions were made. RQLOC - Used to validate company requesting locations. 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. STATICCUST - Used to maintain and validate customer static aging amounts. STPURCHORD - Used to validate standard purchase order header information. SYSTEMCODE - TXTAXRATE - Used to maintain and validate tax rate information. WHDEMNDCMT - Used to validate comments from document lines. WHPROCTYPE - Used to validate process type records. WHSHIPLINE - Used to validate shipment line records. WHSHIPMENT - Used to validate shipment information. INVOKED Programs ACAC IFCR IFSG IFCU IFAC IFAU SLSE SLSU IFCC IFOB IFRS SLSS |