|
OE830 - Returns Load Program
**Form Purpose
Run Returns Load Program (OE830) to import return authorizations from a
non-Lawson system to Lawson.
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.
ARCUSTOMER - Used to validate the Accounts Receivable customer.
ARPROCLEVL - Used to validate the Accounts Receivable process level.
BLOEIUF -
BLOILUF -
CBBANKINST - Used to validate the payment type.
CKPOINT - Used for batch recovery.
COCOMP - Used to store component information when a customer order line
is for a kit item.
COLINE - Used to store customer order line information.
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 -
CUSTDESC - Used in the Customer Edit routine.
CUSTEP -
CUSTORDER - Used to verify the customer order number.
CXCOMPANY - Not used in this program.
CXCPIUAVAL -
CXITEMHIST - Not used in this program.
CXPREFITEM - Not used in this program.
EPBATCH -
EPTRANS -
EPTYPE -
GLCOMMIT -
GLCOMMITX -
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.
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 -
INSTHEADER -
INSTNBR -
ITEMLOC - Used to verify Inventory Control item locations.
ITSERIAL - Used to store serial numbers for serial number tracked items.
MAPOOLCNT -
MMDIST - Contains general ledger account postings for inventory
transaction.
MMUAVAL -
MXLISTHDR -
NATBALANCE - Used in the Customer Edit routine.
OEAUDIT -
OECOLUF -
OECORUF -
OECUSTCODE - Used to validate the customer code.
OEFRTCODE - Used to validate the freight code.
OEINVCDTL - Used to store lot/serial number 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
OEINVCTAX - Used to store tax amounts calculated 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 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 add-on charges.
OEORDCMNT - Used to store order and order line comments.
OEPROCLEV - Used to validate the Billing process level.
OEREASON - Used to validate the cancellation reason code.
OESOURCE -
ORDERTYPE - Used to validate the order type. If this is the first time
the order type is referenced, the used flag is set.
POAGMTPRIC -
POAOCDTL -
POAOCMAST -
POAOCSPRD -
POAUDIT -
POCODE -
POCOMPANY - Used to validate the Purchase Order company.
POHDROUT -
POHDRPVT -
POINTAOC -
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 -
POLINEPVT -
POLINESRC -
POMESSAGE -
POPCRUF -
POPLIUF -
PORECEIVE -
PORECLINE -
PORETURNHD -
PORETURNLN -
POREVISION -
POTRACK -
POTRANSDTL -
POVAGRMTHD -
POVAGRMTLN -
POVENDOR -
PURCHORDER - Used in Purchase Order revision logic.
RACMNTOUT -
RAHDROUT -
RALDTLOUT -
RALINEOUT -
RECAOCDTL -
REQLINE -
RETURNDTL - Used to store bin, lot, and serial number information for a
return line.
RETURNHDR - Used to store return information.
RETURNLINE - Used to store return line information.
RETURNSGBK -
ROUTEDOC - Updated with changed values when a customer order line is
changed after the route files have been created.
ROUTEHDR - Used to edit whether the route has been created for a customer
order line.
If it has, the totals on the route files are updated with the
changed values.
ROUTESTOP - Updated with changed values when a customer order line is
changed after
the route files have been created.
RQTRANS -
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.
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 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 in the Sales Tax Calculation routine.
TXTAXTRAN -
WHDEMAND - Used to validate demand in the Warehouse system.
WHDEMNDHDR - Used to validate the demand header in the Warehouse system.
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 - Used in the Procurement Management distribution edit routine
to edit asset codes.
AMTEMPLATE - Used in the Asset Management edit routine.
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.
BUYCLASS -
BUYCMPLOC -
BUYER - Used in Purchase Order revision logic.
BUYVENPF -
COMPONENT - Used to obtain Inventory Control definition of components for
a kit item.
CUCONV - Used in the Currency Conversion routine.
CURELAT -
CXBURDEN - Not used in this program.
CXCASEPREF - Not used in this program.
CXPTMPITEM - Not used in this program.
EEADVANCE -
EEEXPENSE -
FOBCODE -
FROPTIONS -
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.
GLNAMES -
GLSYSTEM - Used in the General Ledger Account Edit routine.
HCCHRGITEM - Not used in this program.
ICBIN - Used to validate Inventory Control bins.
ICCATEGORY - Used to validate Inventory Control general ledger categories.
ICCOUT -
ICFACILITY -
ICMFGCODE -
ICMFGDIST -
ICVALUOM -
INSTATPROC -
INSTCMDTY -
INSTCTRYCD -
INSTNOTC -
INSTPORTS -
INSTREGN -
ITEMADDON - Used to create add-on charges automatically when specified
items are sold to specific states (or any state).
ITEMGROUP -
ITEMMAST - Used to validate the Inventory Control item.
ITEMSRC -
ITEMSUB -
ITEMUPC -
KITITEM - Used to identify kit items.
MAAOCDTL -
MACOMPANY -
MAELMGPREL -
MAELMVALUE -
MAINVDTL -
MAJORCL -
MAMATCHTBL -
MAMTCHELEM -
MAMTCHRULE -
MAPOINV -
MAREASONCD -
MATCHCLASS -
MFGSHPFAC -
MINORCL -
MSDSACK -
NATACCT - Used in the Customer Edit routine.
OEBASE - Used in the Item Pricing routine. Stores the price base for
each item.
OECOMPANY - Used to validate the Billing company.
OECOMPREF -
OECUST - Used in the Customer Edit routine.
OECUSTITEM -
OEDISCOUNT - Used in the Item Pricing routine. Stores discount percentages
and general ledger accounts.
OEORDDISC -
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.
OPERATOR -
PBBILL -
PBHSTHDR -
POAGMTPART -
POAUDRULES -
POAUDTYPE -
PODOCREF -
POITEMVEN -
PORECADJHD -
PORECADJLN -
POVENDLOC -
PROCTEMPLN -
PROCUREGRP -
REASON - Used to validate the cancellation reason code.
REQHEADER -
REQUESTER -
RQLOC - Used in the Warehouse edit routines.
STATICCUST - Used in the Customer Edit routine.
STCOMMCODE -
SYSTEMCODE -
TXTAXRATE - Used in the Sales Tax Calculation routine.
WFSETUP -
WHPROCTYPE - Used to validate a Warehouse process type.
WHSHIPLINE - Used to store shipment line information including feedback
quantities.
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
|